Category: Tutorial

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
Excel TutorialExcel VBA TutorialTutorial

Countdown to Christmas in Excel with Christmas Tree & Lights

A few years’ ago I created a video showing you how to create an animated Christmas tree.  See the video here http://www.bluepecantraining.com/portfolio/created-a-christmas-tree-with-sparkling-lights-in-excel/

 

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!

It’s Christmas time again and I thought it was time to create version 2.0 to include an automated countdown to Christmas and animated tree and stars, all on a Christmassy…

Read More