How to get Microsoft Office for FREE legally | Word | Excel | PowerPoint | OneDrive

In this lesson, I’m going to be showing you how to: Get Microsoft Office for FREE Word, Excel, PowerPoint, OneNote, OneDrive and many more for FREE 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 … Read more

Lesson 13: How to Format cells as Currency, Date, Percentages and apply Decimal Places to numbers in Excel

In this lesson, I’m going to be showing you how to: Format cells as Currency (£) in Excel Format cells as Accountancy (£) in Excel Format cells as Percentages in Excel Format cells as Dates in Excel Apply Decimal places to numbers in Excel Download the Excel file below, and save it onto your computer. … Read more

Lesson 12: Wrap Text in Excel | Break Text to Multiple Lines | Shrink to Fit

In this lesson, I’m going to be showing you how to: Understand what the Wrap Text feature does in Excel Wrap Text manually and automatically, to fit the contents within the cell on multiple lines Create manual line breaks by using the keyboard shortcut – Alt and Enter Shrink to Fit – so text will … Read more

Lesson 11: Merge & Center in Excel | Merge Across | Merge Cells

In this lesson, I’m going to be showing you how to: Understand what the Merge & Center feature does in Excel How to apply the Merge & Center feature to your text/cells in Excel What is the difference between: Merge & Center | Merge Across | Merge Cells Download the Excel file below, and save … Read more

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