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

Lesson 54 – COUNTIFS function in Excel with 2 examples | How to use Data Filter in Excel

In this lesson, I’m going to be showing you how to: How to use the COUNTIFS function to COUNT MULTIPLE items from different categories or columns How to use the DATA FILTER feature to confirm our answers of the COUNTIFS function Download the Excel file below, and save it onto your computer. So you can … Read more

Lesson 53 – COUNTIF function used to COUNT MULTIPLE different items in a column in Excel | COUNTIF+COUNTIF

In this lesson, I’m going to be showing you how to: Insert a COUNTIF function TO COUNT MULTIPLE different items in a column Use COUNTIF + COUNTIF 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 52 – COUNTIF function in Excel | What it is & how to insert the COUNTIF function in Excel?

In this lesson, I’m going to be showing you how to: Understand, what the COUNTIF function is used for in Excel Insert a COUNTIF 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 51 – How to use FILTER DATA in Excel | Number Filters: Greater Than Or Equal To | Less Than

In this lesson, I’m going to be showing you how to: Filter Data in Excel Use Number Filters: Greater Than Or Equal To Less Than Go ahead, open the video below and watch the tutorial at your own pace: If I have not covered everything in this lesson, please leave a comment or your question … Read more

Lesson 50 – How to LINK data and ADD up cells from a DIFFERENT WORKBOOK in Excel

In this lesson, I’m going to be showing you how to: Add up cells from a different workbook in Excel Link data cells across multiple different workbooks in Excel Go ahead, open the video below and watch the tutorial at your own pace: If I have not covered everything in this lesson, please leave a … Read more

Lesson 49 – How to LINK data and ADD up cells from MULTIPLE different worksheets in Excel

In this lesson, I’m going to be showing you how to: Add up cells from multiple different worksheets in Excel Link data and cells across multiple different worksheets in Excel Go ahead, open the video below and watch the tutorial at your own pace: If I have not covered everything in this lesson, please leave … Read more

Lesson 48 – How to Hide & Unhide Worksheets in Excel | Hide Worksheets, so it CANNOT be unhidden easily in Excel!

In this lesson, I’m going to be showing you how to: Hide Worksheets in Excel Unhide Worksheets in Excel Hide Multiple Worksheets at the same time in Excel Hide Worksheets, so it CANNOT be unhidden very easily! Go ahead, open the video below and watch the tutorial at your own pace: If I have not … Read more

Lesson 47 – How to Hide & Unhide Rows & Columns in Excel | Hide & Unhide Multiples Columns & Rows in Excel

In this lesson, I’m going to be showing you how to: Hide Columns & Rows in Excel Unhide Columns & Rows in Excel Hide & Unhide Multiples Columns & Rows in Excel Go ahead, open the video below and watch the tutorial at your own pace: If I have not covered everything in this lesson, … Read more

100 Shares
Share via
Copy link
Powered by Social Snap