load-gif
Invest in Yourself: Start Learning Now!

Excel Automation Mastery

This course will give you exposure to all the techniques which will enable you to design anything in Microsoft Excel

Kapil Manchanda

Instructor

Bestseller Top Rated

What you will learn?

  • Automation with VBA
  • Data Management

This Course Includes

  • Recorded Lessons:  29
  • Recorded Hours:  6
  • Duration:   6 days (Avg)
  • TD Assessment Available
  • 2 Jobs Available
  • Access on Mobile

Course Description

The Excel Automation Mastery course is designed into three phases - Basics, Interfacing and Development.

Each phase has five videos which can be viewed on daily basis. The videos and the exercises have been designed in such a way that it can be finished in a single day along with practice on Microsoft Excel. 

With each video you also receive template files to download. These files contain the same examples as shown in the video for reference and easy understanding. All the Scripts which have been shown in the videos are also available in these downloadable files. Also, at the end of each day, there is an Exercise and a Quiz which the user can undergo.

By the end of the course you will learn a lot of techniques by which you can make your daily tasks easier and efficient. You can also combine the knowledge of multiple days and design your own short codes/apps as per your requirement.

 There is no prior knowledge of coding required.

-----------------------------------------------------------------------------------------

This is a must attend course for people from the following industries :

- Finance

- IT

- Education

- Automotive

- FMCG

- Manufacturing

- Hospitality

- Banking

- Engineering

- Software

- HR

- Marketing

- And many more...

-----------------------------------------------------------------------------------------

The content for the course is listed below :

1) Phase I : Basics

Macros & Settings - Learn how to use macros in Microsoft Excel

Developer Tab - Learn all options on the developer tab

Auto File & Folder System - Automate files and folder using VBA

Auto Data Management - Copy, Paste, Move, Delete using VBA

File Protection - Auto Protect cells, files using VBA

2) Phase II : Interfacing

Loops & Formulas using VBA - Learn the IF and FOR loops and make your own formulas

All About Forms - Use forms to make your sheets interactive

Formatting & Shortcuts - Autoformat your sheets and create your own shortcuts

Pivot Tables - Create Pivot tables from scratch

Charts & Dashboards - Create charts and Interactive dashboards using Google Data Studio

3) Phase III : Development

Reporting & Printing - Do reporting and printing on a single button click

Google Forms & Sheets - Introduction to Google forms and sheets

Email - V Card - send emails from Excel, create v cards 

 Excel - WhatsApp Link - Send WhatsApp messages from Excel

Control Any Application - Control Mouse and Keyboard using VBA

Course Content

15 Lessons | 14 Documents | 5hr 3min

Quiz Link : https://forms.gle/79jqv5JH146iD2d49

Quiz Link : https://forms.gle/ZQMAfR2omqMEydvV6

Quiz Link : https://forms.gle/QjTQTGFMvn5gTJiZ6

Quiz Link : https://forms.gle/i619V9Mv7X44KLFG8

Quiz Link : https://forms.gle/JWF53Th1tsy2KCUo8

Quiz Link : https://forms.gle/TVKQUpGiEWhBZVRJ8

Quiz Link : https://forms.gle/LZBm1RfeUagYuWKs7

Quiz Link : https://forms.gle/YEU8a2basB94Kh4C8

Quiz Link : https://forms.gle/WMWRneBDB9SJ9oL79

Quiz Link : https://forms.gle/F4oN69ckrM6D952A7

Quiz Link : https://forms.gle/WzqN5WhvL2N69R4H6

Quiz Link : https://forms.gle/1BUFzcjBkLRCf47v9

Quiz Link : https://forms.gle/i71w15R1C43HpGpj7

Quiz Link : https://forms.gle/Nx5X2gpRuxQJt3L69

Quiz Link : https://forms.gle/TQbxE79Rv2kohd5K6

Frequently Asked Questions

The course is designed to teach participants how to automate repetitive tasks in Excel using tools like VBA (Visual Basic for Applications), macros, and Excel formulas.

This course is ideal for professionals, data analysts, and anyone who frequently uses Excel for data management. It's particularly beneficial for those who want to streamline their workflows, enhance their Excel skills, and improve their ability to handle large datasets.

While basic knowledge of Excel is beneficial, it is not mandatory. The course starts with fundamental concepts and gradually advances to more complex automation techniques, making it suitable for both beginners and intermediate users.

Introduction to Excel automation, Creating and recording macros, Understanding and using VBA, Automating data entry and formatting, Creating user-defined functions, Error handling in VBA, Working with Excel objects and events, Automating reports and dashboards

The course is delivered online through a series of recorded video lectures, hands-on exercises.
Course Preview
(4.2)
5hr 3min
₹499
Add To Cart