Do you want to save time on routine tasks in Microsoft Excel? Macros are the answer. In this course the instructor explains how macros can be used to automate tasks in Excel, and how you can create simple macros yourself. You will learn when and how to record a macro step-by-step, share macros between workbooks, set up keyboard shortcuts to execute macros quickly, and use Visual Basic for Applications (VBA) to code macros that cannot be recorded. The course ends with a macro project that brings all the elements together in a realistic scenario: converting mailing list data into a database-friendly format.

Excel 2019/365 Power Pivot
12/1, 09/2, 09/3, 20/4, 17/5 ...
By the end of this course, you will be able to determine which of the two tools, PivotTables and PowerPivot,…