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.
Excel With Wayne is an online Microsoft Excel Training Course taught by Dr. Wayne Winston. Dr. Winston is the world's foremost Microsoft Excel Expert that teaches at some of the world's largest organizations including Microsoft and government organizations such as the Navy and Army.