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