Lesson 35 – How to insert a NEW worksheet in-between 2 worksheets in Excel | Rearrange and Rename worksheets in Excel

In this lesson, I’m going to be showing you how to: Insert a NEW worksheet in-between 2 worksheets in Excel Rearrange worksheets in Excel Rename worksheets 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 … Read more

Lesson 34 – What is the PLOT & CHART AREA on a chart in Excel | How to SHADE the plot area in a chart in Excel

In this lesson, I’m going to be showing you how to: Understand what is the PLOT & CHART AREA on a chart in Excel SHADE the plot area in a chart in Excel Go ahead, open the video below and watch the tutorial at your own pace: If I have not covered everything in this … Read more

Lesson 33 – How to insert an Embedded Clustered Column Chart in Excel | What is a Clustered Chart?

In this lesson, I’m going to be showing you how to: Understand what is a CLUSTERED column chart in excel Insert a CLUSTERED column chart in excel Understand what is an EMBEDDED chart in excel Go ahead, open the video below and watch the tutorial at your own pace: If I have not covered anything … Read more

Lesson 32 – What is Scale to Fit in Excel | How to use Scale to Fit (shrink pages) in Excel

In this lesson, I’m going to be showing you how to: Understand what is Scale to Fit in Excel or Shrink pages Use scale to fit to print on a desired number of pages in Excel Go ahead, open the video below and watch the tutorial at your own pace: If I have not covered … Read more

Lesson 31 – Relative OR Absolute references in Excel | Everything explained | Confusion solved!

In this lesson, I’m going to be showing you how to: Understand what is a Relative cell reference in excel Understand what is an absolute cell reference in excel The differences between relative & absolute cell references Know when to use relative & absolute references in a formula before replicating it Go ahead, open the … Read more

Lesson 30 – Best method to format numbers to display as PERCENTAGES in Excel

In this lesson, I’m going to be showing you how to: Format numbers to display as percentages in Excel Go ahead, open the video below and watch the tutorial at your own pace: If I have not covered anything in this lesson, please leave a comment or your question below and I will get back … Read more

Lesson 29 – Everything you need to know about ABSOLUTE cell references before replicating a formula in Excel

In this lesson, I’m going to be showing you how to: Understand what is an absolute cell reference in Excel Understand why it is important to use absolute cell reference to a formula before replicating in Excel Apply an absolute cell reference to a formula before replicating in Excel Go ahead, open the video below … Read more

Lesson 28 – A simple DIVISION formula in Excel | How to DIVIDE in Excel

In this lesson, I’m going to be showing you how to: DIVIDE in Excel Use a simple DIVISION formula in Excel Go ahead, open the video below and watch the tutorial at your own pace: If I have not covered anything in this lesson, please leave a comment or your question below and I will … Read more

Lesson 27 – What is the thousand separator in Excel | How to use the thousand separator in Excel

In this lesson, I’m going to be showing you how to: Understand what is the thousand separator in Excel Use the thousand separator in Excel Go ahead, open the video below and watch the tutorial at your own pace: If I have not covered anything in this lesson, please leave a comment or your question … Read more

Lesson 26 – Use the AUTOSUM button to quickly ADD up cells in Excel | What is the Autosum Button in Excel?

In this lesson, I’m going to be showing you how to: Use the AUTOSUM button to quickly ADD up cells in Excel Understand everything about the Autosum button in Excel Go ahead, open the video below and watch the tutorial at your own pace: If I have not covered anything in this lesson, please leave … Read more

Share via
Copy link
Powered by Social Snap