Lesson 5: Average Function in Excel | What does Average mean

In this lesson, I’m going to be showing you how to: Understand, what an AVERAGE function is Insert an AVERAGE function Understand the meaning of Average Download the Excel file below, and save it onto your computer. So you can complete this lesson with me. Go ahead, open the video below and watch the tutorial … Read more

Lesson 4: Multiplication Formula in Excel | Replicate or Copy Formulas in Excel

In this lesson, I’m going to be showing you how to: Multiply in Excel by using the multiplication formula Copy or replicate formulas into other cells automatically Download the Excel file below, and save it onto your computer. So you can complete this lesson with me. Go ahead, open the video below and watch the … Read more

Lesson 3: Formatting Cells in Excel | Make a Spreadsheet look visually attractive

In this lesson, I’m going to be showing you how to: Make a Spreadsheet look visually attractive by Formatting Cells, by using: Font Font size Bold Italic Underline Fill color Font color Borders Alignment Cell styles Download the Excel file below, and save it onto your computer. So you can complete this lesson with me. … Read more

Lesson 2: SUM function in Excel | Entering Text & Numbers | FREE Series of Microsoft Excel Lessons

In this lesson, I’m going to be showing you how to: Understand what is the SUM function How to insert the SUM function Entering text and numbers in Excel Download the Excel file below, and save it onto your computer. So you can complete this lesson with me. Go ahead, open the video below and … Read more

Lesson 1 – Introduction to Microsoft Excel | Excel Interface | FREE Series of Microsoft Excel Lessons (pdf guide included)

In this lesson, I’m going to be showing you how to: Understand the interface of Microsoft Excel and the various sections, which makes up the interface, such as the: Ribbon, Quick Access toolbar, Backstage view Rows, Columns, Cells, Cell addresses, Name box Scroll bars, zoom, worksheet views Download the PDF file below, and save it … Read more

Lesson 62 – The AverageA function in Excel | Why and When to use the AverageA function in Excel

In this lesson, I’m going to be showing you how to: Understand, what the AVERAGEA function is used for Insert an AVERAGEA function Know, why and when to use the AVERAGEA function Include text data in your average calculations The difference between the Average function and the AverageA function Download the Excel file below, and … Read more

Lesson 61 – AVERAGEIFS function in Excel | Find the average value by using many criterias in excel

In this lesson, I’m going to be showing you how to: Use the AVERAGEIFS function to work out the average results by using criteria’s from multiple columns Download the Excel file below, and save it onto your computer. So you can complete this lesson with me. Go ahead, open the video below and watch the … Read more

Lesson 60 – What is the AVERAGEIF function in Excel | How to insert the AVERAGEIF function in Excel?

In this lesson, I’m going to be showing you how to: Understand, what the AVERAGEIF function is used for Insert an AVERAGEIF function Download the Excel file below, and save it onto your computer. So you can complete this lesson with me. Go ahead, open the video below and watch the tutorial at your own … Read more

Lesson 59 – FORMULATEXT function in Excel | Display formulas or functions of individual cells only

In this lesson, I’m going to be showing you how to: Use the FORMULATEXT function to permanently show on the screen, the formulas or functions that’s been used Download the Excel file below, and save it onto your computer. So you can complete this lesson with me. Go ahead, open the video below and watch … Read more

Lesson 58 – SUMIFS function in Excel to ADD multiple CRITERIONS from different columns

In this lesson, I’m going to be showing you how to: Use the SUMIFS function to ADD up the revenue by using criterions from multiple columns or categories Download the Excel file below, and save it onto your computer. So you can complete this lesson with me. Go ahead, open the video below and watch … Read more