fbpx

Learn Excel Automation
Power query and VBA

The key to effortlessly manage your data

Learn Excel VBA at just ₹9999/-

Book Your Seat Now- Power Query

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!

Topics Covered

Recording and Running Macros

  1. Absolute and relative recording
  2. Macro storage locations
  3. Running macros from toolbars, menus or worksheet buttons

Visual Basic Editor

  1. Understanding modules
  2. Window options – Immediate
  3. Editor formats
  4. Editor toolbar
  5. Commenting code
  6. Code editing including stepping

 Understanding Objects, Methods, Properties and Variable

  1. What is a object?
  2. The object hiearchy
  3. Properties and Methods
  4. Variable- Types of Variables,declaration and use of variables

Control Structures – Decision Making

  1. The if control structures
  2. Else if
  3. Select Case

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.


Learn Power Query at just ₹9999/-

 

Date and Time to be announced soon

Book Your Seat Now

Topics Covered

Importing Data

  1. Data from Excel
  2. From Text files
  3. From Websites

 

Combining Data

  1. Merging texting files
  2. Merging data from Multiple Excel files
  3. Merging data from Multiple sheets of a single excel files
  4. Merging Data from Multiples Excel files and Sheets
 
 

Transforming Data 

  1. Unpivot Data
  2. Pivot Data
  3. Merging Queries
  4. Appending Queries
  5. Choosing the right data type

 V Lookup

  1. Replace VLookUP
  2. Lookup Multiple Columns
  3. Lookup the Left side of the data
  4. Lookup with in a range
  5. Automate Lookups

 

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

 
Book Your Seat Now

Upcoming Webinars.
Stay tuned for more updates on dates and registration for these webinars

Webinar on Power BI

Learn how to create interactive data visualizations and insights with Power BI. Understand how to connect to data sources, create and share dashboards, and use advanced features like data modeling and DAX formulas.

Formulae in Excel

Dive deeper into the world of Excel formulas and functions. Learn how to use advanced formulas such as VLOOKUP, INDEX, and MATCH to manipulate and analyze data.

Lookup and Advanced Lookup

Learn how to use the LOOKUP and HLOOKUP functions in Excel to retrieve data from a table or range. Understand the difference between these functions and how to use them effectively.

MS 365 Features

Learn about the latest features and updates in MS 365 and how they can help you work smarter and more efficiently.

MS 365 for Businesses

Discover how MS 365 can help your business increase productivity, collaboration, and security. Understand how to use MS 365 tools such as OneDrive, Teams, and SharePoint to improve your business operations.

Testimonial

What Our Students Says
Prashant PardeshiPrashant Pardeshi
13:33 16 May 22
Nice computer training centre to learn Basic Excel, Advance Excel, PowerPoint PowerApp, Power Query, Power Pivot, PowerBi, Tally, and many more.
Vikram PashteVikram Pashte
12:35 16 May 22
It's v nice & cooperative staff. Good Knowledge of Excel.
Karin SinghKarin Singh
18:04 15 May 22
I was in a fix when my Drive was changed and we experienced loss of data on Outlook ... called Pradeep our Microsoft expert who always but always so helpful.. Data was recovered and all in sync now.. Thank You Pradeep .… if nobody can, you can !
Umesh MAneUmesh MAne
14:13 14 May 22
I was pro in excel but when i visited and interacted with Mr. Pradip, i got to know what i dont know. I was quite familiar with Advance excel most of the features because in My company Parle agro, we have huge data and many reports are to be created. I used to do it manually until i started my Excel automation class from Tech and Training. I found the sessions on VBA, PowerQuery, PowerPivot and Power BI sessions Extremely helpful.I recommend every person to go and attend the classes to know what you dont know and to know more about Excel.Thanks team for helping me.
Nayna JadhavNayna Jadhav
14:03 14 May 22
Its Good teacher to explain all Excel & Tally feature's.
js_loader

Bonus E-Books

Yes! You will get trained by a working professional and a corporate trainer which brings a lot of credibility in you to understand Real-Time Market and Projects Scenarios.

Bonus 1
Power BI Installation Guide and DataSets(For Hands-on During the Live Workshop).
Worth Rs. 500
Bonus 1
Power BI Installation Guide and DataSets(For Hands-on During the Live Workshop).
Worth Rs. 500
Bonus 1
Power BI Installation Guide and DataSets(For Hands-on During the Live Workshop).
Worth Rs. 500
Bonus 1
Power BI Installation Guide and DataSets(For Hands-on During the Live Workshop).
Worth Rs. 500

Our Approach

Methodology

At Tech and Training Corporate Solutions Pvt Ltd, we focus on delivering the best training programs that are tailor made for the participants. We consider the background and knowledge level of the participants to impart the best and optimum training. We train the participants using real life examples, simulators, set up files, reading manuals, practice data, tips-n-tricks, and many other useful stuff. We design our training strategy to make it more practical, interactive and fun simultaneously ensuring that the participants get in-depth knowledge in their respective domain. Our trainers are certified and experienced to deliver the best quality training programs.

Post Training Support

At Tech and Training Corporate Solutions Pvt Ltd, our engagement does not end with the end of training. We invite and solve queries from participants through email post training. We also periodically send ‘Tips and Tricks’ to support the participants in implementing their learning’s. We ensure that participants leave with a high level of comfort and confidence on successful completion of training.

Excellent Results

Our programs consistently receive high rating from the participants. Our trainings have been well received by several renowned companies. We have found that our professional training and customized handouts empower the participants to apply the knowledge in their regular job.
Book Your Seat Now

Pradip Pardeshi – Microsoft Expert

Director – Tech and Training Corporate Solutions Pvt Ltd

Facebook Linkedin Youtube

About Trainer

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.

He has been invited as a consultant and keynote speaker to various prestigious events in India, UAE, Singapore, Philippines and many others. Some of the notable events he has been invited are:

• LEADERS OF TOMORROW on ET NOW channel
• Rotary Annual General Meeting, Mumbai
• MFRT, India’s largest conference in Mutual Fund Industry
• ITC (International Trainers Conclave)
• ICAI, Dubai, Abu Dhabi and India
• ISACA

Tech and Training

  • Founded in the year 2008.
  • Registered dealers in providing Microsoft licenses
  • Process automation by using Microsoft Power Platforms like SharePoint, PowerApps, PowerAutomate and PowerBI.
  • Successfully conducted IT and Microsoft-related training for more than 270 companies globally
  • Trained 24000 plus professionals
  • Training provided diverse range of industries from textile to pharmaceuticals, real estate to automobiles.
  • Our training deliveries have been across countries like the Philippines, South Africa, Singapore, Dubai, and Abu Dhabi to name a few.

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.

Company

Important Links

Get in touch!

support@techtrainings.net

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

Facebook Twitter Instagram Pinterest Youtube

Follow Us On YouTube!

Copyright © 2023 Tech & Training Corporate Solutions PVT LTD.