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
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
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
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
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
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
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
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
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
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
