Signup as a Tutor

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

Advance Excel workshop

1 Reviews

Khar West, Mumbai

Course ID: 42653

Khar West, Mumbai

Students Interested 0 (Seats Left 0)

1 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.

ABOUT THE WORKSHOP:
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
Hyperlink
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
Sumproduct
Logical Formulas (IF, and, Or, IfError Formulas)
Nested If Formulas
Data Summarization Formulas (AVERAGEIF,AVERAGEIFS,COUNTIF,COUNTIFS
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

9 Students

3 Courses

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

5.0

Average Rating

100%
0%
0%
0%
0%

Reviews

V

Vishaldeep Advani

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

Discussions

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

Enquire

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 support@urbanpro.com 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

UrbanPro.com is India's largest network of most trusted tutors and institutes. Over 25 lakh students rely on UrbanPro.com, to fulfill their learning requirements across 1,000+ categories. Using UrbanPro.com, 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 UrbanPro.com. 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