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

Lesson 7 – What is the ROUND function, and how to insert it in Excel?

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