Lesson 10: How to use the INSERT FUNCTION command in Excel?

In this lesson, I’m going to be showing you how to: Understand, what the INSERT FUNCTION command is used for Benefits of the Insert Function Command Use the INSERT FUNCTION command to create the following functions:– AVERAGE function– MIN function– MAX function– SUM function Download the Excel file below, and save it onto your computer. … Read more

Lesson 9: Simple Subtraction Formula in Excel

In this lesson, I’m going to be showing you how to: Use the Subtraction formula 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 tutorial at your own pace: If I have not covered … Read more

Lesson 8: Using the COUNT and COUNTIF function to count ONLY the cells, which contains TEXTUAL data

In this lesson, I’m going to be showing you how to: Use the COUNT and COUNTIF function to ONLY count the number of cells, which contains TEXTUAL data Be able to use a combination of the COUNT function to be able to count ONLY TEXT from a list or range of cells. Download the Excel … Read more

Lesson 7: Count & CountA function in Excel | Difference between Count and CountA function in Excel

In this lesson, I’m going to be showing you how to: Use the Count function Use the CountA function What is the difference between the Count and CountA 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 … Read more

Lesson 6: MIN & MAX function in Excel | Find the Minimum and Maximum value within a range in Excel

In this lesson, I’m going to be showing you how to: Use the Min function to find the smallest value from a range of numbers Use the Max function to find the largest value from a range of numbers Download the Excel file below, and save it onto your computer. So you can complete this … Read more

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

108 Shares
Share via
Copy link
Powered by Social Snap