live-workshop-excel-automation - Tech & Training Corporate Solutions Pvt. Ltd.
  • Navi Mumbai

Learn Excel Automation Power query and VBA

The key to effortlessly manage your data

Learn Excel VBA at just ₹9999/-

Learn to write macros to automate repetitive tasks, create user-defined functions to perform complex calculations, and build custom user interfaces to interact with data in your spreadsheets.

VBA is often used to create financial models, data analysis tools, and dashboards, among other applications.

 

Master VBA Macros

Automate Your Work and Save Time!

What Is Power Query?

Power Query is a data transformation tool that helps users extract, clean, and transform data from various sources into a single data model for analysis and reporting. It has an easy-to-use interface and supports a wide range of data sources and transformation tasks.

Topics Covered on this Training

Recording and Running Macros

*Absolute and relative recording

*Macro storage locations

*Running macros from toolbars, menus or worksheet buttons

Understanding Objects, Methods, Properties and Variable

*What is a object?

*The object hierarchy

*Properties and Methods

*Variable- Types of Variables,declaration and use of variables

Visual Basic Editor

*Understanding modules

*Window options – Immediate

*Editor formats

*Editor toolbar

*Commenting code

*Code editing including stepping

Control Structures – Decision Making

*The if control structures

*Else if

*Select Case

Importing Data

*Data from Excel

*From Text files

*From Websites

Transforming Data

*Unpivot Data

*Pivot Data

*Merging Queries

*Appending Queries

*Choosing the right data type

Combining Data

*Merging texting files

*Merging data from Multiple Excel files

*Merging data from Multiple sheets of a single excel files

*Merging Data from Multiples Excel files and Sheets

V Lookup

*Replace VLookUP

*Lookup Multiple Columns

*Lookup the Left side of the data

*Lookup with in a range

*Automate Lookups

Combo Offer – Power Query + VBA Macros at just ₹17,999/-

Meet your Coach

Pradip Pardeshi

Pradip Pardeshi is a Microsoft Certified Trainer and Coach. He helps organizations become efficient and productive by training and coaching them on various Microsoft Technologies. For more than a decade Pradip has conducted 1000+ training batches for 270 + companies in IT Domain. Some of the companies include brands like Ranbaxy, Cipla, Maersk Global, Kalpataru, Times Now, Aditya Birla Group, Tech Mahindra etc.

Our Approach

QUALITY CONTROL TRAINING

Expertise in IT Skills Training We are known for our expertise in providing corporate training in a variety of IT skills. Our trainers, who are Microsoft certified, are committed to delivering high-quality training services to our clients.

POST TRAINING SUPPORT

At Tech and Training Corporate Solutions Pvt Ltd, we pride ourselves on providing more than just training. We’re dedicated to ensuring our clients’ success long after the training is over by offering ongoing support through email.

EXCELLENT RESULTS

Proven Results Our training programs consistently receive high ratings from participants and have been well-received by many reputable companies. We strive to achieve excellent results for our clients.

We are a renowned corporate training house founded in the year 2008. We specialize in a range of Behavioral and IT training programs. We have already successfully conducted training for more than 100 companies globally.

Get in touch!

Shop No. 1, Plot no. 65, Sec 5, Ghansoli. Navi Mumbai

Follow Us On YouTube!

Copyright © 2023 Tech & Training Corporate Solutions PVT LTD.