Introduction to Excel Macros
Learning Outcomes
Get More Info
data, Tech & ai skills in
What’s Included
What are Macros and VBA?
What are Macros and VBA?
In this lesson, I explain what Macros and VBA exactly do and show you how to build a simple Macro in your spreadsheet
Add Multiple Tasks to a Macro
Add Multiple Tasks to a Macro
A Macro's real power is combining multiple tasks into a single command. In this lesson, we'll learn how to append additional tasks to the original Macro.
Undo, Saving and Distributing Macros
Undo, Saving and Distributing Macros
Macros can create a few headaches when you want to undo, save or distribute macros. I'll address these problems in detail during this lesson.
Macros and Security Settings
Macros and Security Settings
By default, Macros are disabled when you open an external macro-enabled file. In this lesson, I'll tell you why this is the case and how to configure your security settings in Excel.
Editing and Deleting Macros
Editing and Deleting Macros
Editing and deleting Macros can be tricky, particularly if you save a Macro to the Personal.xlsb file. In this lesson, I'll show you how to accomplish these tasks.
Remove Blank Cells with Macros
Remove Blank Cells with Macros
Blank cells appear in most columns and can be frustrating to remove, particularly in large datasets. To save time, let's build a Macro to remove any blanks in a column of data.
Absolute and Relative References
Absolute and Relative References
When Macros don't work correctly, it can be due to having the wrong references setting. In this lesson, I'll show you when relative references should be used.
Problems with Pasting Text
Problems with Pasting Text
Macros can have problems when pasting text from a cell or comment. In this lesson, I'll show you how to overcome this problem using 3 lines of code (but no more, I promise!).
Should I Learn to Program in Visual Basic?
Should I Learn to Program in Visual Basic?
After learning how to record simple macros, the next question for Excel users is, 'Should I learn Visual Basic?' In this short lesson, I'll try help you answer this question.
Certifications
A Learner Experience Designed to Deliver Transformation
How Leading Teams Use Kubicle to Upskill & Excel
