Disclosure: when you buy through links on our site, we may earn an affiliate commission.

Business Friendly Excel Automation (Formula + Macro/VBA)

Easy to learn Formulas and Macros to start automating most business processes
0.0
0.0/5
(0 reviews)
7 students
Created by Michael Joon Seng Goh, PhD (Eng)

9.0

CourseMarks Score®

10.0

Freshness

N/A

Feedback

7.5

Content

Platform: Udemy
Price: $11.99
Video: 1h 55m
Language: English
Next start: On Demand

Top Excel Formulas and Functions courses:

Detailed Analysis

CourseMarks Score®

9.0 / 10

CourseMarks Score® helps students to find the best classes. We aggregate 18 factors, including freshness, student feedback and content diversity.

Freshness Score

10.0 / 10
This course was last updated on 4/2021.

Course content can become outdated quite quickly. After analysing 71,530 courses, we found that the highest rated courses are updated every year. If a course has not been updated for more than 2 years, you should carefully evaluate the course before enrolling.

Student Feedback

We analyzed factors such as the rating (0.0/5) and the ratio between the number of reviews and the number of students, which is a great signal of student commitment.

New courses are hard to evaluate because there are no or just a few student ratings, but Student Feedback Score helps you find great courses even with fewer reviews.

Content Score

7.5 / 10
Video Score: 7.8 / 10
The course includes 1h 55m video content. Courses with more videos usually have a higher average rating. We have found that the sweet spot is 16 hours of video, which is long enough to teach a topic comprehensively, but not overwhelming. Courses over 16 hours of video gets the maximum score.
Detail Score: 9.3 / 10

The top online course contains a detailed description of the course, what you will learn and also a detailed description about the instructor.

Extra Content Score: 5.5 / 10

Tests, exercises, articles and other resources help students to better understand and deepen their understanding of the topic.

This course contains:

0 article.
0 resource.
0 exercise.
0 test.

Table of contents

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

Requirements

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

You will 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

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

How much does the Business Friendly Excel Automation (Formula + Macro/VBA) course cost? Is it worth it?

The course costs $11.99. And currently there is a 40% discount on the original price of the course, which was $19.99. So you save $8 if you enroll the course now.

Does the Business Friendly Excel Automation (Formula + Macro/VBA) course have a money back guarantee or refund policy?

YES, Business Friendly Excel Automation (Formula + Macro/VBA) has a 30-day money back guarantee. The 30-day refund policy is designed to allow students to study without risk.

Are there any SCHOLARSHIPS for this course?

Currently we could not find a scholarship for the Business Friendly Excel Automation (Formula + Macro/VBA) course, but there is a $8 discount from the original price ($19.99). So the current price is just $11.99.

Who is the instructor? Is Michael Joon Seng Goh, PhD (Eng) a SCAM or a TRUSTED instructor?

Michael Joon Seng Goh, PhD (Eng) has created 1 courses that got reviews which are generally positive. Michael Joon Seng Goh, PhD (Eng) has taught 7 students and received a — average review out of reviews. Depending on the information available, Michael Joon Seng Goh, PhD (Eng) is a TRUSTED instructor.

More info about the instructor, Michael Joon Seng Goh, PhD (Eng)

Solution Architect, Business Transformation
Dual role Solution Architect and Transformation Office Analyst with global experience automating lots of business processes in Excel. Finance and Accounting Reports, Sales Overview, Production Dashboards, Data Science Analysis and many more!Experienced instructor delivering in-person and remote training/knowledge-sharing sessions to business executives, production technicians, finance administrators, IT programmers and school students.

9.0

CourseMarks Score®

10.0

Freshness

N/A

Feedback

7.5

Content

Platform: Udemy
Price: $11.99
Video: 1h 55m
Language: English
Next start: On Demand

Students are also interested in

Get this widget on your website (for course creators):

Business Friendly Excel Automation (Formula + Macro/VBA) rating
Copy this code and paste it to your website:
<a href="https://coursemarks.com/course/business-friendly-excel-automation-formula-macro-vba/" target="_blank" title="Business Friendly Excel Automation (Formula + Macro/VBA) on Coursemarks.com"><img border="0" src="https://coursemarks.com/widget/90.svg" width="200px" alt="Business Friendly Excel Automation (Formula + Macro/VBA) rating"/></a>