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

Lesson 57 – SUMIF function used to ADD up MULTIPLE different items in one column in Excel | SUMIF+SUMIF

In this lesson, I’m going to be showing you how to: Use the SUMIF function to ADD up multiple different items from the SAME range or column Add up ALL types of criteria in the same column EXCEPT one criteria Use SUMIF + SUMIF Download the Excel file below, and save it onto your computer. … Read more

Lesson 56 – SUMIF function in Excel | What it is & how to insert the SUMIF function in Excel?

In this lesson, I’m going to be showing you how to: Understand, what the SUMIF function is used for in Excel Insert a SUMIF function 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 watch the … Read more

Lesson 55 – COUNT function in Excel | COUNTA function in Excel | COUNTBLANK function in Excel

In this lesson, I’m going to be showing you how to: Use the COUNT function to count numbers in Excel Use the COUNTA function to count non-blank cells in Excel Use the COUNTBLANK function to count blank cells in Excel Download the Excel file below, and save it onto your computer. So you can complete … Read more