Lesson 50 – How to LINK data and ADD up cells from a DIFFERENT WORKBOOK in Excel

In this lesson, I’m going to be showing you how to: Add up cells from a different workbook in Excel Link data cells across multiple different workbooks 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 … Read more

Lesson 49 – How to LINK data and ADD up cells from MULTIPLE different worksheets in Excel

In this lesson, I’m going to be showing you how to: Add up cells from multiple different worksheets in Excel Link data and cells across multiple different worksheets 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

Lesson 48 – How to Hide & Unhide Worksheets in Excel | Hide Worksheets, so it CANNOT be unhidden easily in Excel!

In this lesson, I’m going to be showing you how to: Hide Worksheets in Excel Unhide Worksheets in Excel Hide Multiple Worksheets at the same time in Excel Hide Worksheets, so it CANNOT be unhidden very easily! Go ahead, open the video below and watch the tutorial at your own pace: If I have not … Read more

Lesson 47 – How to Hide & Unhide Rows & Columns in Excel | Hide & Unhide Multiples Columns & Rows in Excel

In this lesson, I’m going to be showing you how to: Hide Columns & Rows in Excel Unhide Columns & Rows in Excel Hide & Unhide Multiples Columns & Rows 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, … Read more

Lesson 46 – Find & Replace in Excel | What is Match Case & Match Entire Cell Contents in Excel

In this lesson, I’m going to be showing you how to: What is Find & Replace in Excel How to use Find & Replace to change contents of cells How to Match Case when finding contents and what it means How to Match Entire Cell Contents when finding and what it means Go ahead, open … Read more

Lesson 45 – How to apply borders around and in-between cells in Excel | Difference between borders & Gridlines in Excel

In this lesson, I’m going to be showing you how to: Apply borders around and in-between cells in Excel Understand the difference between borders and gridlines 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 … Read more

Lesson 44 – Use the IF function to work out if you are over BUDGET or not in Excel

In this lesson, I’m going to be showing you how to: How to use the IF function to work out, if over budget or not in Excel Manually typing in the full IF function Use the function key to do the IF function Go ahead, open the video below and watch the tutorial at your … Read more

Lesson 43 – How to change a DATE to different FORMATS in Excel

In this lesson, I’m going to be showing you how to: Change a DATE to different FORMATS 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 42 – How to set and print rows & titles automatically at the top of each page in Excel

In this lesson, I’m going to be showing you how to: Apply settings and print rows & titles automatically at the top of each page 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 … Read more

Lesson 41 – How to display and print GRIDLINES and ROW & COLUMN HEADINGS in Excel

In this lesson, I’m going to be showing you how to: Understand what is GRIDLINES and ROW & COLUMN HEADINGS in Excel Display and print GRIDLINES and ROW & COLUMN HEADINGS in Excel Go ahead, open the video below and watch the tutorial at your own pace: If I have not covered anything in this … Read more