Macros Syllabus

Macros

This course covers Macros and consists of 10 topics.

Inserting the Developer Tab – In this video we show how to make the Developer Tab appear on your ribbon.
Inserting a List of Names – In this video we record a Macro that inserts a list of team members starting in cell A1. We also create a button to run the macro.
Relative References With Macros – In this video we show how to use Relative References to make sure our list of names can be entered anywhere in our workbook.
Using Macros to Format Cells – In this video we create a macro to apply a desired format to a range of selected cells and show how to run the Macro by clicking on a picture (in this case an Aircraft Carrier).
Formatting a Range of Variable Size – In this video we show how to create a macro that formats a range of variable size.
Using a Macro to Freeze Values – In this video we create a macro that coverts formulas in a selected range to numerical values.
Using Macros For Reporting – In this video we create macros that enable us to toggle in a PivotTable between a view that shows sales for all customers and sales for only our top 20 customers.
Creating a Border With a Macro – In this video we show how to create a macro that places a border around a range of selected cells.
Personal Macro –In this video we discuss how to save a macro to your Personal Macro Workbook.
Sorting Macro –In this video we show how to create a macro that will sort a list by last and first name.
Learn More