Lesson 21: How to COPY cells from one spreadsheet to another spreadsheet in Excel

In this lesson, I’m going to be showing you how to: Copy non-adjacent cells in Excel Paste the cells as adjacent columns in another spreadsheet 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 comment or … Read more

Lesson 20: How to select multiple NON-ADJACENT cells in Excel | What are the benefits?

In this lesson, I’m going to be showing you how to: Select multiple non-adjacent cells in Excel Understand the benefits of selecting multiple non-adjacent cells 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 comment or … Read more

Lesson 19: What is a Workbook and Worksheet in Excel | What is the difference between a workbook and worksheet in Excel?

In this lesson, I’m going to be showing you how to: Understand what is a workbook in Excel Understand what is a worksheet in Excel Understand what is the difference between a workbook and worksheet in Excel Go ahead, open the video below and watch the tutorial at your own pace: If I have not … Read more

Lesson 18: What is a Formula and Function in Excel | What is the difference between a formula and function in Excel?

In this lesson, I’m going to be showing you how to: Understand what is a formula in Excel Understand what is a function in Excel Understand what is the difference between a formula and function in Excel Go ahead, open the video below and watch the tutorial at your own pace: If I have not … Read more

Lesson 17: How to PRINT the spreadsheet SHOWING the formulas and functions in Excel

In this lesson, I’m going to be showing you how to: Show all formulas and functions on screen in Excel Print the spreadsheet showing the formulas and functions 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 16: What is Page Orientation in Excel | Change Portrait orientation to Landscape in Excel

In this lesson, I’m going to be showing you how to: Understand what is portrait and landscape page orientation in Excel Change the portrait orientation to landscape 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 15: Format the Font color in Excel | Shade a range of cells to any color in Excel

In this lesson, I’m going to be showing you how to: Format the font colour of a range of cells in Excel Shade the cells in any colour 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 14: How to insert a HEADER in Excel | How to insert an AUTOMATIC FILENAME in the header

In this lesson, I’m going to be showing you how to: Understand what a header is in Excel How to insert a header in Excel What is an automatic filename How to insert an automatic filename in the header Go ahead, open the video below and watch the tutorial at your own pace: If I … Read more

Lesson 8 – What is the IF function, and how to insert it in Excel?

In this lesson, I’m going to be showing you how to: Understand, what an IF function is Insert an IF function Go ahead, open the video below and watch the tutorial at your own pace: Note: a NEW lesson 8 VIDEO is coming soon – sorry for the inconvenience If I have not covered everything … Read more