This lecture series will cover my pick of top Excel Formulas, Macros and/or functions that helped me automate the majority of business processes I have encountered such as consolidating data from multiple workbooks, sending emails with data from Excel, data cleanup, handling of complicated data structure, SAP automation, etc.
The two series is taught assuming basic Excel operation knowledge suitable for business users with little to no programming background.
Most of the materials are taught with relatable business applications and some Macros are provided as easily reusable templates to help you get started in automating your own business processes.
The course is separated into two video series, one for Formulas and another for Macro / VBA. Each series has 7 or 8 bite size videos which get progressively more difficult and may require learnings from a previous video.
Two versions of Excel .xlsx and .xlsm workbooks are also provided; one for you to follow along the video and attempt the Formulas/Macros for yourself and one with the solutions along with detailed commentary to help you understand how to use each Formula/Macro taught.
Video Series 1, Excel Formulas:
1. Basics: Mathematical Operators, If / Else, And/Or, List, Iferror / ifblank / ifnumber
2. String Manipulation: Concatenation, cutting strings
3. Sumif: Sumif and Sumifs
4. Index & Match combination
7. Indirect Reference
Video Series 2, Excel Macros:
1. Basics: Hello World, Get and Set Range / Cells
2. Range Management
3. Copy & Paste
4. For Loops
5. If Else Logic
6. Importing Data from other workbooks (Excel files)*
7. Sending Email*
8. SAP Automation using Excel Macro*
*Easily Reusable Templates