Excel 2016 - Macro Recorder Basics & Copying VBA Code From Internet

Learn the fundamentals of using the Macro Recorder in Excel 2016 and discover how to incorporate VBA code from online sources. Master creating six different types of macros, including absolute and relative reference macros for formatting reports and converting data layouts. Explore techniques for finding and implementing useful VBA functions, such as spelling out numbers as words and working with cell fill colors. Gain practical skills in using form control buttons to add records to existing datasets across different sheets. Access downloadable files for hands-on practice and explore recommended YouTube channels and books for further VBA learning.

Syllabus

) Basics for Recorded Macros (VBA).
) Absolute Reference Macro: Format report that always has the same number of columns and rows. This Macro is stored in Personal Workbook..
) Absolute & Relative Reference Macro: Format report that that has an unknown number of rows.
) Relative Reference Macro to convert vertical records into a proper data set with horizontal records.
) Search for VBA Code online: Function to spell out numbers as words.
) Search for VBA Code online: Add or count cells with red fill.
) Form Control Button to Add Record to Existing Proper Data Set on different sheet..
) Summary.