ADVANCED EXCEL TRAINING – LEVEL 2

Home » Training Programs » Advanced Excel Training – Level 2

Advanced Excel training (Level 2) participants across Mumbai, Kolkata, Bangalore, New Delhi, Gurgaon, Chennai, Hyderabad, Pune, Nasik, Ahmedabad, etc.

For an experienced professional, it’s easier to work with different techniques and formulas of Advanced Excel in a “standalone” mode. E.g. Just VLookup() formula or Consolidate technique.

Key Learning: Automate repetitive tasks | Prepare month-end reports with the click of a button | Automate PowerPoint preparation from Excel reports | User-defined functions (UDF) | Prepare User Forms … and more.

With the aim of equipping with this Ninja-level power. We have developed a 1-day workshop, which has been conducted at prestigious companies, including PwC, EY, ITC, Coca-Cola, Flipkart, Asian Paints, etc.

Pre -Training Video

Enquiry For Corporate Training +91-9167847797

Advanced Excel Ninja Training (Level 2) | Course Outline

Program Name: Advanced Excel
Software: Microsoft Excel
Level: Intermediate to Advanced (Level 2)
Duration: 3.5 – 6.5 effective hrs. (depending on Section A)

Learning Material: Datasets based case studies, PDF and YouTube videos from our channel for revision.

Delivery Style:

Hands-on practice (Demo -> Practice side-by-side).
First, show a demo with the problem statement and solution.
Then, slow down the pace to let people practice along with the Instructor.

Who is this program for?
This program is NOT for an Excel Beginners. Program attendees must have a good working knowledge of:

Filter, Pivot Table, $
VLOOKUP, MATCH, INDEX, SUMIFS & COUNTIFS

Objectives:
This program aims to help the learners learn more advanced technique of report consolidation, lookups, dataset re-structuring, and basic VBA Macros. The learners must know the topics of – Advanced Excel – Level 1.

Pre-Training Work:
10-to-20 mins video from our YouTube channel or eLearning portal.

A: Recap of Advanced Excel - Level 1 [OPTIONAL / VARIABLE]

The duration of this will vary based on the current skill level of the learners group.

B: Data Cleaning - Part 1 | 66 mins

Using INDIRECT with VLOOKUP to pull data from multiple sheets.
Using COUNTIFS to calculate running count based on any primary key.
(Used for developing VLOOKUP models for datsets with duplicate entries)

C: Advanced Pivot Table | 65 mins.

Role of Excel’s Power Query in Pivot Table – common use cases:

UnPivot Column(s) – Convert cross-tab data set into flat file.
Split Column’s data – to Rows (vertically)
Slicer Settings – Connections, Formatting (no. of columns, color, border)
Creating 100s of worksheets based on a column-category in seconds
Topics for next-level of learning (Excel’s Power Query)

D: VBA Macros for partial automation (non-coders approach) | 104 mins.

Activate Developer Tab
Basics of UI of code window and Macros record/run
Basics of a VBA code’s anatomy – SubRoutine start/end, Dim, Comments; UDF
Searching Google for readymade codes – “VBA Code to [verb] [object] [addl. logic]”
Basic DOs & DONTs while searching for VBA codes on Google
Using the Google code to copy-paste-run and get work done
Exercise: Create an index of links to worksheets
Exercise: Split a table in multiple sheets based on filter
Exercise: Extract comments from multiple cells (UDF)
Topics for next-level of learning
Saving a file with Macros (XLSM)
Post-Session revision exercise (18-mins video):

E: QnA & Extra case studies

Questions related to the Day to Day work

FAQs:

What is the purpose of corporate Excel training?

Corporate Excel training is designed to help employees learn how to effectively use Excel for tasks related to their job duties. Corporate Excel training can help employees work more efficiently and effectively, and may also help improve the overall productivity of the organization.

Who typically attends corporate Excel training?

Corporate Excel training is typically attended by employees who use Excel as part of their job duties, or who need to learn Excel for a specific project or task. This may include people in a wide range of roles, such as finance professionals, salespeople, marketing professionals, and administrative staff.

What are the benefits of corporate Excel training?

There are several benefits of corporate Excel training, including: Improved efficiency, Increased accuracy, Enhanced data analysis skills, Better teamwork, etc.

How can I ensure that my employees retain the skills learned in corporate Excel training?

There are several ways to ensure that your employees retain the skills learned in corporate Excel training: Such as: Encourage employees to practice what they have learned, Provide ongoing support, Encourage regular use of Excel and Consider follow-up training.

What are the prerequisites to learn MS Excel?

There are no specific prerequisites for learning Microsoft Excel. However, having a basic understanding of computers and how to use them may be helpful. Overall, the most important prerequisite for learning Excel is a willingness to learn and a desire to become proficient with the program. With some practice and patience, anyone can learn how to use Excel effectively.

Enquiry For Corporate Training
+91-9167847797

WHAT STUDENT SAYS

Pre-Training Prep Course Testimonials

It is highly appreciating the way he teaches us. We are a much more comfortable zone to understand since we are in the beginning.

The video and modules illustrated were good with the proper shortcuts mentioned. a great training prep.

This Excel Speed Training was really helpful and informative. Shortcuts were really good to know. Flash Fill. Vlookup and Pivot Table as well. Helped me get to the next level. A big thanks to PwC and Yoda Learning Team for introducing me to this course.

It's short, and concise yet pretty informative, your way of describing things and the edits mentioning the shortcuts on the screen helped me with the learning.

The way these sessions are planned is way more helpful than physical training in the classroom. These are very much helpful.

Now I can easily and efficiently use excel. Also really good and quick coverage Of the topics.

Pre-Training preparation is very crisp and really useful to refresh the formulas for advanced training.

All the concepts were explained very clearly and were easy to understand. The information conveyed was relevant and is really going to be handy.

All the topics were relevant and can be used in day-to-day projects. Very insightful and informative topics were covered.

WHAT STUDENT SAYS

Post-Training Testimonials

It was a superb and 2 ways session. The trainer made it so comfortable and easy for everyone though for almost everyone this is was the very first time to be working on Power BI.

It was excellent!! Very very worthwhile to attend it. Thank you so much, and I hope to have more sessions.

Just excellent. Such detailed explanation and patience, Sir, has no word other than 'excellent.' When training can be tedious, Sir has made the session interactive and not just for the namesake; because it's so exciting and accurate to its name Sir has done justice to the 'advanced excel training.' Kudos!!

The presenter was able to explain all aspects clearly. He was patient and was able to answer all Qs.

The session was great, and the way the trainer told things was convenient and easy to understand.

So far, I have enjoyed the session. It was very informative and exciting. I like the pace that the trainer conducts the session. Looking forward to learning more new and exciting stuff.

ADVANCED EXCEL TRAINING – LEVEL 2

Pre -Training Video

Advanced Excel Ninja Training (Level 2) | Course Outline

A: Recap of Advanced Excel - Level 1 [OPTIONAL / VARIABLE]

B: Data Cleaning - Part 1 | 66 mins

C: Advanced Pivot Table | 65 mins.

D: VBA Macros for partial automation (non-coders approach) | 104 mins.

E: QnA & Extra case studies

FAQs:

Pre-Training Prep Course Testimonials

Post-Training Testimonials

Most Demanded Programs

Company

Call us:

Email us:

Recent Posts

Excel TEXT Function – Formula, Examples, How to Use?

Excel REPT Function – Formula, Examples, How to Use?

ADVANCED EXCEL TRAINING – LEVEL 2

Pre -Training Video

Advanced Excel Ninja Training (Level 2) | Course Outline

A: Recap of Advanced Excel - Level 1 [OPTIONAL / VARIABLE]

B: Data Cleaning - Part 1 | 66 mins

C: Advanced Pivot Table | 65 mins.​

D: VBA Macros for partial automation (non-coders approach) | 104 mins.

E: QnA & Extra case studies

FAQs:

Pre-Training Prep Course Testimonials

Post-Training Testimonials

Most Demanded Programs

Company

Call us:

Email us:

Recent Posts

Excel TEXT Function – Formula, Examples, How to Use?

Excel REPT Function – Formula, Examples, How to Use?

C: Advanced Pivot Table | 65 mins.