Business Friendly Excel Automation (Formula + Macro/VBA)

MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English + srt | Duration: 18 lectures (1h 55m) | Size: 948.9 MB

Easy to learn Formulas and Macros to start automating most business processes
What you'll learn:
Excel Formula
Excel Macro
Programming Logic
Process Automation
Report Automation
Excel Consolidation
Smart Excel workbooks for business
Smart Excel workbooks for operations
Smart Excel workbooks for finance
SAP automation with Excel
Email automation with Excel

Requirements
Basic operation of Microsoft Excel
Access to Microsoft Excel 2013 and above

Description
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

5. Offset

6. Sumproduct

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

Who this course is for
Business users looking to improve productivity
Business users wanting to learn how to automate their existing and future Excel workbooks
Business, Operations and Finance users who want to automate tedious manual Excel work
People who want to start using Robotic Process Automation (RPA) but want start small with existing infrastructure