Excel TutorialTutorial

Create a Thermometer Chart in Excel

Thermometer charts are useful if you want to display actual values against target values: for example actual sales against sales target.  Follow the tutorial or watch our YouTube tutorial at the bottom of this page.  Please see our Excel Dashboard training course if you would like this training delivered at your place of work. Here’s an…

Read More
Excel TutorialExcel VBA TutorialTutorial

Working With Workbooks in Excel VBA

Referring to a Workbook Using ThisWorkbook

 

70+ MUST KNOW EXCEL SHORTCUT KEYS: Download the pdf from our Excel training page
UNDERSTAND & FIX EXCEL ERRORS: Download the pdf from our Excel training page
Learn how to fix these errors: #DIV/0!, #N/A!, #NAME?, #NULL!, #NUM!, #REF! & #VALUE!

Open a Workbook Close (and Save Changes to) a Previously Saved Workbook Close (and Save Changes to) to a New Workbook

 

70+ MUST KNOW EXCEL SHORTCUT KEYS: Download the pdf from our Excel training page
UNDERSTAND & FIX EXCEL ERRORS: Download the pdf from our Excel training page
Learn how to fix these errors: #DIV/0!, #N/A!, #NAME?, #NULL!, #NUM!, #REF! & #VALUE!

Save Workbook Performing a SaveAs… Delete Workbook Protect a Workbook Add a Named Reference to…

Read More
Excel TutorialExcel VBA TutorialTutorial

Working With Worksheets in Excel VBA

Select a Specific Worksheet

Refer to the Active Worksheet Using ActiveSheet

 

70+ MUST KNOW EXCEL SHORTCUT KEYS: Download the pdf from our Excel training page
UNDERSTAND & FIX EXCEL ERRORS: Download the pdf from our Excel training page
Learn how to fix these errors: #DIV/0!, #N/A!, #NAME?, #NULL!, #NUM!, #REF! & #VALUE!

Activate a Worksheet Create a New Worksheet/s Name a Worksheet

 

70+ MUST KNOW EXCEL SHORTCUT KEYS: Download the pdf from our Excel training page
UNDERSTAND & FIX EXCEL ERRORS: Download the pdf from our Excel training page
Learn how to fix these errors: #DIV/0!, #N/A!, #NAME?, #NULL!, #NUM!, #REF! & #VALUE!

Name the active sheet Name a specific sheet Change a Worksheet’s Tab Colour Delete Worksheet Copy a Worksheet To…

Read More