0   reviews on Udemy

Business Friendly Excel Automation (Formula + Macro/VBA)

Easy to learn Formulas and Macros to start automating most business processes
Course from Udemy
 9 students enrolled
 en
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

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

Business Friendly Excel Automation (Formula + Macro/VBA)
$ 19.99
per course
Also check at

FAQs About "Business Friendly Excel Automation (Formula + Macro/VBA)"

About

Elektev is on a mission to organize educational content on the Internet and make it easily accessible. Elektev provides users with online course details, reviews and prices on courses aggregated from multiple online education providers.
DISCLOSURE: This page may contain affiliate links, meaning when you click the links and make a purchase, we receive a commission.

SOCIAL NETWORK