Signup as a Tutor

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


MS -EXCEL (Intermediate & Advance) Training

No Reviews Yet

Course type: Instructor led Course

Course ID: 25898

Course type: Instructor led Course

Students Interested 0 (Seats Left 0)

₹ 4,000

Advance Excel & MIS Training

No Reviews Yet

About the Course

Highlights :

Individual attention to all students
Practical class conducted after each topic for better understanding of concepts
Simple and lucid explanation of complex topics with Examples
Flexible timings ...Early morning and late night batches also conducted for the benefit of working professionals
Once you register for any course , you can attend any number of batches of the same course till 6 months after your registration without any additional cost
You can attend Two demo classes to assess the quality of training before paying the fees
100% Cash back Guaranteed if you are not satisfied with quality of training.

Topics Covered

Training Details
Session - 1
Uses of Advance Excel Formulas

Session - 2
Session - 3
Various Methods and Uses of IF Conditions
When should use the "IF" Conditions?
Creation of Multiple IF Conditions in One Cell
Use the IF Conditions with the Other Advance Functions
How to use nested IF statements in Excel with AND, OR, ,
Session - 4
Various Methods of Filter and Advance Filter options
Creating and Updating Subtotals
Various Methods of Text to Column options
Uses of Data Grouping and Consolidation options
Uses of Goal Seek and Scenarios Manager
Various Method of Sorting Data
Creating, Formatting and Modifying Chart
Data Validation, Creating drop down lists using different data sources
Linking Workbooks and Uses of Edit Link options
Excel Options, Customizing the Quick Access Tool Bar
Formula Auditing features and Trace formula error
Session - 5
Pivot Tables
Various Methods and Options of Pivot Table
Using the Pivot Table Wizard
Changing the Pivot Table Layout
Subtotal and Grandtotal Options
Grouping items
Inserting calculated fields
Pivot Table Options
Display and hide data in fields
Select, Move & Clear Pivot data
Creating and Modifying a PivotChart
Power Pivot
Installation & Set up of Power Pivot
Creating your first Power Pivot report
Power Pivot Case Study
End-user Reporting need analysis
Creating a data model & refining it
Using Tables & Structured References
Using Pivot Tables & Slicers
Power Pivot formulas & DAX
Complex DAX examples
Working with time-intelligence
Disconnected tables & slicers
Power Pivot Dashboard #1
Form controls & interactivity
Charting & Dashboard Theory
Power Pivot Dashboard #2
Using Power View in Excel 2013
Discussion on new features of Power Pivot in 2013
Hosting & Sharing your Power Pivot workbooks

Session -7
Dashboard Tutorial

Introduction To Macros

What is a Macro
Using Macro Recorder and Your First Macro
Editing Macros & VBE
Macros vs. UDFs
How to get more help on Macros & Advanced Excel

Who should attend

Advanced Excel Training for Finance, Audit & MIS reporting
In todayâ??s fast-paced business climate, it is vital that decisions are made quickly and accurately. This course will help you improve your existing skill sets, and teach you Excel techniques to build sophisticated spreadsheets and better ways of overcoming Excel related problems.
Learning this powerful business software will set you apart from your co-workers and make you more valuable in the job market.
Excel is an important skill to have for any job. Excel can be used for a variety of different tasks in the workplace. Whether you work in the Accounting, Finance, HR, Sales and Marketing, Admin or even IT department, you have to use Excel for Data Management and Data Analysis.
Having the skill to use Excel will also open up new career options for you, often giving you new job possibilities and the potential for a higher salary. Becoming an advanced user of Excel will get you places in the corporate world.


Should have basic computer knowledge

What you need to bring

Notebook and pen

Key Takeaways

his will build on your current Excel skills. This course will cover all aspects of creating Spreadsheets, Performing calculations,Data Validation, VLookup, HLookup, SumIf, CountIf, Ranges, Match, Index etc. It also guides you on data presentation using Conditional Formatting, Excel-Charts, Formatting and using page setup for printing. Our professional Excel training teaches you not only basics of Microsoft Excel but also the application of it to your everyday problems. We evaluate candidate's knowledge level, their problems and adjust our training to their specific needs. Getting Excel to make decisions using the function, You will learn how to create templates for commonly used worksheets. We teach you how to develop analysis and data processing problems on the worksheet then how to determine the proper MS Excel tools to create a unique solution. This training will also enable you to create, build and customize graphs.

Date and Time

Not decided yet.

About the Trainer

Avg Rating

0 Reviews

4 Students

3 Courses

Amit Thakur


4 Years of Experience

Have around 10 years Experience in Business analytics and Reporting Domain ,I have trained more than 400 students in Advanced Excel , MS Access ,Advanced Excel VBA and Macros , SAS Base and Advance.


No reviews currently Be the First to Review


Amit Thakur

Advance Excel & MIS Training

No Reviews Yet

Students Interested 0 (Seats Left 0)

₹ 4,000

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


Submit your enquiry for MS -EXCEL (Intermediate & Advance) Training

Please enter valid question or comment

Please select a category

No matching category found.

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 Amit

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

Register for Free Master Class

tickYou have successfully registered

Class Scheduled at


To join, click

Add to Google Calendar
How to join a Class?
  • For Mobile phone, download the UrbanPro app for Learners

    The UrbanPro Learner app is your study app for this course. You can attend the Demo Class on the app and also get access to the course material, course schedule and ability to communicate with the Tutor. To learn more, watch this video.

    Play Store App Store
  • For Laptop, download the Zoom app

    Download the Zoom app for your laptop. The link to join the class will launch the meeting with the tutor on this Zoom app. To learn more, watch this video.

UrbanPro.com is India's largest network of most trusted tutors and institutes. Over 55 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 7.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