Excel Macros VBA + Power Query (2 in 1 course)

Excel Macros VBA + Power Query (2 in 1 course), available at $69.99, has an average rating of 4.25, with 90 lectures, 1 quizzes, based on 30 reviews, and has 192 subscribers.

You will learn about Students will learn how to debug recorded macros and write their own coding using VBA. A little basic understanding of Macros is what you need. Most students struggle to understand VBA codes, this course has what you need to expand your knowledge into the VBA world. All you need is a will to master the basic concepts, some practise and your on your way to become an expert. Watch, repeat and Practise is key here. VBA code written in front of your eyes, not written and then narrated. Relate words with action. Follow along as we write code, debug and correct errors. At the end of the course, you will be able to master key concepts, write your own loops and even make summary reports. This course is ideal for individuals who are All students seeking coding knowledge basics, working professionals wanting to learn Excel Macros and how to automate processes. or Managers , Sales professionals, Data Analysts, anyone basically wanting to learn new skills. It is particularly useful for All students seeking coding knowledge basics, working professionals wanting to learn Excel Macros and how to automate processes. or Managers , Sales professionals, Data Analysts, anyone basically wanting to learn new skills.

Enroll now: Excel Macros VBA + Power Query (2 in 1 course)

Summary

Title: Excel Macros VBA + Power Query (2 in 1 course)

Price: $69.99

Average Rating: 4.25

Number of Lectures: 90

Number of Quizzes: 1

Number of Published Lectures: 90

Number of Published Quizzes: 1

Number of Curriculum Items: 91

Number of Published Curriculum Objects: 91

Original Price: $79.99

Quality Status: approved

Status: Live

What You Will Learn

Students will learn how to debug recorded macros and write their own coding using VBA. A little basic understanding of Macros is what you need.
Most students struggle to understand VBA codes, this course has what you need to expand your knowledge into the VBA world.
All you need is a will to master the basic concepts, some practise and your on your way to become an expert. Watch, repeat and Practise is key here.
VBA code written in front of your eyes, not written and then narrated. Relate words with action. Follow along as we write code, debug and correct errors.
At the end of the course, you will be able to master key concepts, write your own loops and even make summary reports.

Who Should Attend

All students seeking coding knowledge basics, working professionals wanting to learn Excel Macros and how to automate processes.
Managers , Sales professionals, Data Analysts, anyone basically wanting to learn new skills.

Target Audiences

All students seeking coding knowledge basics, working professionals wanting to learn Excel Macros and how to automate processes.
Managers , Sales professionals, Data Analysts, anyone basically wanting to learn new skills.

Fear not if you don’t know how to record a Macro and use it. In this course, I will show you how to record macros, edit them , understand the code, debug them and start writing your own applications.

VBA for Excel is still King in terms of Automation. There is so much magic that you can achieve by learning how to code. All you need is the will power to learn and practise.

Start from the Basics of recording and understanding macros. Learn to write VBA code from scratch. You don’t need to be a Programmer.

Once you’re done with VBA, learn Power Query…..the best tool to Master without learning how to code

“It is in detail ie., step by step for the non coding background learners”

Rajesh L N – India

“I needed a course that takes me from basic vba to intermediate vba and so far with the course content i see myself headed towards becoming an expert vba which is awesome”

Emmanuel – Uganda

“Excellent course contents and thanks for uploading this savior course. It really helped and perfectly fits for the day to day work automations. I highly recommend this course for macros learners…!!”

Rizwan Safdar – Switzerland

“Practical examples and well explained formulas. Excellent course explained with formulas and debugging. Can’t wait to learn the Excel animation and move to Power BI. Would recommend the course to Excel enthusiasts to explore.”

Shagufta M – Pakistan

“It’s a very nice course, I recommend to everyone who wants to learn VBA. Instructor has got excellent knowledge about the teachings.”

Sarfraz – India

Variety of codes for different situations, written right before your eyes. Debug, compile and recover from mistakes.

Over 50 completed files, videos and examples.

Userforms
Animation in Charts using Named ranges and VBA
Looping over multiple files
Using the speed of Arrays
Scripting with Files and Folders
Creating Summary Reports
Formatting your reports
Embedding images onto sheets
Resizing multiple charts in a grid
Creating Charts in VBA
Embedding Pictures from a Folder
Error handling and debugging
Using Advanced Filter
Using Shapes in VBA
Understanding Tables and List Objects
Interactive Sales Dashboard

Record macros in Absolute and Relative mode, understand the differences. Start building Userforms, create loops to loop over multiple files.

Understand Pivot table automation and to access Tables as List Objects.

Create multiple charts and resize them in a customized grid.

Create animation using Advanced techniques with Named ranges and VBA to animate Excel charts.

This course covers all the basics as well as advanced concepts of VBA for beginners.

Each project contains exercise files that you can download and use.

This course will help students, accountants, data analysts, working professionals, any Excel enthusiast.

Course will be updated with new videos…

Course Curriculum

Lecture 1: Excel Macros Magician

Chapter 1: Introduction – Getting the Fundamentals right

Lecture 1: Introduction

Lecture 2: The VB editor

Lecture 3: Range object – Most Important

Lecture 4: Start writing your first code

Lecture 5: Absolute Mode Recording

Lecture 6: Understanding the recorded code in Absolute Mode

Lecture 7: Recording in Relative Mode

Lecture 8: Recording in Absolute and Relative Mode

Lecture 9: Understanding the recorded Macro codes

Chapter 2: Variables and Using Loops

Lecture 1: Declaring Variables

Lecture 2: Scope of Variables

Lecture 3: Data Types

Lecture 4: Loops in VBA

Lecture 5: Using Instr

Lecture 6: IF statements

Lecture 7: Loops – Final Touches

Chapter 3: Userform – Message

Lecture 1: Welcome Message

Chapter 4: Employee Database Userform

Lecture 1: Employee Database Userform

Chapter 5: How to merge text in a cell

Lecture 1: Merge text in a cell

Chapter 6: How to split Numbers

Lecture 1: Split Numbers

Chapter 7: Loops

Lecture 1: Looping over Mutliple Files

Chapter 8: Loop Multiple files and sum totals by date

Lecture 1: Looping over files and summing by dates

Chapter 9: Summarize Profits by Weekday

Lecture 1: Summarize Profits by Weekday using Loops

Chapter 10: Understanding R1C1 referencing

Lecture 1: R1C1 Referencing

Chapter 11: Vlookup in VBA

Lecture 1: Vlookup – VBA version

Chapter 12: Formatting Dates

Lecture 1: Formatting Dates and save as Table feature

Chapter 13: Tables and ListObjects

Lecture 1: Tables – List Objects

Chapter 14: Calculating Margins and Revenue using Tables

Lecture 1: Using Formulas in VBA

Chapter 15: Text function in VBA

Lecture 1: Text Function

Chapter 16: Convert numbers stored as text to Numbers

Lecture 1: Convert numbers stored as text to Numbers

Chapter 17: Sales Summary report

Lecture 1: Sales Summary report in VBA

Chapter 18: Formatting your Report

Lecture 1: Formatting your report

Chapter 19: Errors in VBA and how to deal with them

Lecture 1: Error handling

Lecture 2: Error Handling Part 2

Chapter 20: Create Multiple Reports with Unique function

Lecture 1: Multiple reports

Chapter 21: Multiple Report Generation with Criteria

Lecture 1: Multiple reports with crtieria

Chapter 22: Advanced Filter

Lecture 1: Advanced Filter – VBA

Chapter 23: VBA on Steroids – Arrays

Lecture 1: Arrays

Lecture 2: Using Arrays (Part 2)

Lecture 3: Using Arrays (Part 3)

Lecture 4: Using Arrays (Part 4)

Lecture 5: Arrays (Part 5) – Complete

Chapter 24: Pivot table in VBA

Lecture 1: Pivot table automation

Chapter 25: Shapes in VBA

Lecture 1: Using Shapes in VBA

Chapter 26: Pictures from Folder

Lecture 1: Adding pictures from a folder

Chapter 27: Embedding pictures from a folder

Lecture 1: Embedding Pictures

Chapter 28: Resizing pictures into a grid

Lecture 1: Resizing pictures

Chapter 29: File System Object

Lecture 1: FileSystemObject – Access Files and Folders

Chapter 30: Adding Hyperlinks to Folder Names

Lecture 1: Add Hyperlinks

Chapter 31: Copying Folder and Subfolders

Lecture 1: Copy files to folders

Chapter 32: Embedding the images onto sheets

Lecture 1: Embed images onto sheets

Chapter 33: Creating Charts in VBA

Lecture 1: Create a Chart with VBA (Part 1)

Lecture 2: Creating Multiple Charts (Part 2)

Lecture 3: Creating Multiple Charts (Part 3)

Lecture 4: Creating Multiple Charts (Part 4)

Chapter 34: Chart Animation 1

Lecture 1: Chart Animation using VBA (Part 2)

Lecture 2: Chart animation using VBA (Part 1)

Chapter 35: Chart Animation 2

Lecture 1: Arranging the Data first

Lecture 2: Understanding how animation works

Lecture 3: Using Named Ranges with Loop to create the Animation

Lecture 4: Applying the Final Touches

Chapter 36: Chart Animation 3

Lecture 1: Adjusting the VBA code and Named Ranges

Instructors

MyExcelAcademy .
Excel Enthusiast and trainer

Rating Distribution

1 stars: 1 votes
2 stars: 3 votes
3 stars: 2 votes
4 stars: 9 votes
5 stars: 15 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu