Signup as a Tutor

As a tutor you can connect with more than a million students and grow your network.

Advance Excel workshop

6 Reviews

Khar West, Mumbai

Course ID: 42653

Khar West, Mumbai

Students Interested 0 (Seats Left 0)

6 Reviews

About the Course

Microsoft Excel is the most commonly used spreadsheet application. Businesses uses Excel as a primary tool for diverse functions and applications ranging from IT projects to company picnics

Why should you learn Microsoft Excel?
Learning how to use Excel is an investment in both your personal and professional life. A working knowledge of Excel is vital for most working professionals today, and stronger Excel skills can open the door to greater heights and leadership opportunities.

What will I gain/learn?
Learning how to use Excel efficiently provides tremendous value, making the students better prepared to take on the corporate world. This opens up more opportunities for employment and career advancement.

This Intermediate Microsoft Excel training is ideal for students who want to advance their skill set by learning to work with advanced formulas, work effectively with multiple sheets in workbooks. Students will also work with charts and advanced formatting, including styles.
By the end of this course, students will be able to create and format charts, work effectively with multiple sheets in workbooks, use productivity tools, copy and paste data in desirable formats, quick analysis tools and work with the Excel list/database features.
Having practiced all of these new skills extensively during the course students will be able to hit the ground running on their entry to the corporate world, and should be able to complete Excel work far more quickly and effectively.

Broad Overview

Key Topics

Worksheet Techniques

Renaming, Inserting And Deleting Worksheets
Copying And Moving Worksheets
Hiding And Unhiding A Worksheet
Hiding sheet tabs
Copying a worksheet to new and other workbooks
Changing Worksheet Tab Colors
Freezing and grouping Rows And Columns
Naming a range and maintaining name ranges
Advanced Excel functions

Advanced Paste Special
Calculation with Paste Special
Link Data from different sheets/workbook
Advanced Sorting and Filtering
advance Conditional Formatting
Share and Protect workbook
Advance Date Function
Charts & Pivot Table

Different types of charts
Modifying charts
Adding Legends, Axis, Data labels, Chart Title
Adding a Trendline
Changing chart type and source data
Creating and working with Pivot Table
Advance Pivot functions
Advanced Excel Formulas

3D Formulas
Logical Formulas (IF, and, Or, IfError Formulas)
Nested If Formulas
Using Mid&find, Left&find together
Offset, Indirect
Offset with Sum and Average
Is Functions
Lookup method() and advance Vlookup Formulas

VLookup with approximate match,
Match & Index
Dynamic Vlookup
Reverse Vlookup
Nested Vlookup
Advance data Functions

Naming ranges and modifications to the named ranges
Senario Manager
Data Tables
Goal Seek
Basic Automation

Recording a Macro
Basic VBA codes (Opening/saving a work sheet using VBA)
Insert userforms and display message box

Date and Time

Not decided yet.

About the Trainer

Trisha Jagtiani picture

5 Avg Rating

6 Reviews

13 Students

3 Courses

Trisha Jagtiani


12 Years of Experience

She is a seasoned professional with over a decade of experience in the financial services industry. She started her career with a small stint in e-Clerx; she then moved on to join Prudential Process Management Services in the risk analytics department. Trisha was responsible for all MIS and reporting for Prudential globally.

This is where Trisha developed her excel skills and was recognized by the organization at every level. She was responsible for multiple projects of automating excel based reporting. Trisha has also traveled to US and UK extensively for excel automation projects. After a long stint with Prudential, she went on to join BNP Paribas in the Regulatory Reporting team, leading a team of analysts. She further mastered her excel skills in her new role.

Trisha has conducted over a 100 excel training sessions in the last couple of years. Her area of expertise with excel training range from excel for beginners to advanced and complex excel trainings.

In her spare time Trisha is fond of reading crime based fictional novels and loves to cook for her family.

Student Feedback


Average Rating





Excellent knowledge transfer,All questions explained in details,Learning was fun with live problem solving


Dvijesh Donde

It was an amazing experience when learning excel with Trisha. She clears the doubts of the students at her best level, no matter how difficult to teach to beginners or time consuming it might be. She creates a friendly atmosphere while teaching and understands the comfort level of her students. The best part of Trisha's teaching is that she teaches with such examples which can be understood easily and cannot be forgotten. I can guarantee you that you will definitely enjoy the session and learn a lot of things which would be helpful in your career path.



A very well conducted workshop. The best part is that Trisha not only explains the logic behind the formulas, she aligns the training to relevant scenarios faced while working on excel in office.


Vishaldeep Advani

Trisha has a very good knowledge on excel. Workshop that I have attended so far has helped me professionally.



I really liked the tips and tricks and shortcuts used in excel. Trainer has an excellent command over the language and the concepts are explained in such a manner, which helps remembering the formula and practical examples help using them at workplace. Organized flow of the workshop n the topics go in a systematic order. The practice exercises helps understand the concept well and separate time given to doubt solving session. All in all, a very good experience and a wonderful trainer.



I would Recommend all those willing to have an hands on experience on working with excel. The thing that I realized after doing this course was excel is so much more than just V lookup. It really makes excel so much simpler. In terms of the entire course, solution materials, practice sheets, shortcuts etc were provided. Highly Recommend.


Students Interested 0 (Seats Left 0)

Post your requirement and let us connect you with best possible matches for Microsoft Excel Training classes Post your requirement now


Submit your enquiry for Advance Excel workshop

Please enter valid question or comment

Please enter your name.

Please enter valid Phone Number

Please enter the Pin Code.

Please check the fields again.

By submitting, you agree to our Terms of use and Privacy Policy

Connect With Trisha

You have reached a limit!

We only allow 20 Tutor contacts under a category. Please send us an email at for contacting more Tutors.

You Already have an UrbanPro Account

Please Login to continue

Please Enter valid Email or Phone Number

Please Enter your Password

Please enter the OTP sent to your registered mobile number.

Please Enter valid Password or OTP

Forgot Password? Resend OTP OTP Sent

Sorry, we were not able to find a user with that username and password.

We have sent you an OTP to your register email address and registered number. Please enter OTP as Password to continue

Further Information Received

Thank you for providing more information about your requirement. You will hear back soon from the trainer is India's largest network of most trusted tutors and institutes. Over 25 lakh students rely on, to fulfill their learning requirements across 1,000+ categories. Using, parents, and students can compare multiple Tutors and Institutes and choose the one that best suits their requirements. More than 6.5 lakh verified Tutors and Institutes are helping millions of students every day and growing their tutoring business on Whether you are looking for a tutor to learn mathematics, a German language trainer to brush up your German language skills or an institute to upgrade your IT skills, we have got the best selection of Tutors and Training Institutes for you. Read more