Advanced Excel 2013/2016 Training

Advanced Excel 2013/2016 Training

108 ratings    1049 Students Enrolled
Watch the Introduction
Preview the Free Demo Lesson
600 + (GST)
5999 90% off
Offer Ends In

Key Features

Our e-Learning course is as good as attending classroom session. If you are not happy with the course, get 100% refund.

  • Simple and Easy Video Tutorials
  • 8 hours Training Videos; Total 46 sessions
  • Lifetime Access to this course – Learn at your own pace!
  • Access anywhere from any device (Mobile, Laptop, Desktop, Tablet)
  • Course completion certificate
  • Training by 20+ years experienced Microsoft Certified Trainer
  • 100% pass rate for Microsoft Certification (Exam 77-420)
  • Money Back Guarantee
  • 24/7 Support via email and live chat
  • International Accredited & Award Winning Training Organization
  • 18 Years of Trust in offering classroom, online and e-learning courses
  • Save time by simplified tips with Advanced Excel Training

AADSEducation's Advance Excel 2013/2016 training course teaches you techniques employed by experienced professionals to enhance your use of Excel and master building rich feature spreadsheets. Learn concepts ranging from complex functions, nesting, data manipulation to basics of VBA Macros. By the end of the course, you will become an expert in using Excel. You can clear the Microsoft Certification (Exam 77-420) with this course. For booking a slot for exam, reach us via customer support. Below are the topics you will learn in this course:

Topics covered in this course

Session-1 Understnding Cell References and Range
1 Working with Range Name 15:00
2 Cell References 12:30
Session-2 Working with Advanced Functions
3 Statistical Functions 13:00
4 Logical Functions 18:00
5 Array Function 5:00
Session-3 Data Visualisation
6 Conditional Formatting Part-I 17:00
7 Conditional Formatting Part-II 13:00
8 Conditional Formatting Part-III 12:00
9 Data Sorting 4:30
Session-4 Analyzing Data
10 Normal Filter 7:00
11 Advanced Filter 8:30
12 Filter with Subtotal Function 8:30
Session-5 Managing Date and Time in Excel
13 Date & Time Function Part-I 16:30
14 Date & Time Function Part-II 11:00
Session-6 Validation Data and understanding error
15 Data Validation 21:00
16 Error handling 15:00
Session-7 Managing and Consolidating data
17 Working with Table 14:00
18 Consolidate Data from Multiple Sheets into one 19:00
19 Data Analysis using Subtotal Tools 14:00
Session-8 Generating Interactive Reports using Pivot Tables
20 Pivot Table -Part-1 29:00
21 Pivot Table Part-2 Slicers 5:00
22 Pivot Table-Part-3 Calculated Field 5:30
23 Pivot Table Part-4 Calculated Item 4:30
24 Pivot Table Part-5 Date Timeline 6:30
25 PivotTable Part-6 Recommend PT 2:30
26 Pivot Chart- Part-7 8:00
Session-9 Working with What if Analysis Tools
27 Sparklines 6:06
28 What if analysis -Goal Seek 6:06
29 What if analysis -Scenario Manager 8:05
Session-10 Auditing and Securing data in Excel
30 Formula Auditing 7:30
31 Data Protection in Excel 14:30
32 Data Import From text 11:45
33 Data Import from Web 11:45
Session-11 working with Lookup Function
34 Vlookup with False parameter 19:00
35 Vlookup with True Parameter 6:03
36 Vlookup with any left column 3:45
37 Vlookup using Array 6:00
38 Vlookup Limitation 6:00
39 Vlookup with Sum 3:00
40 Vlookup with multiple lookup values 7:45
41 HLookup Function 6:00
42 Match Function 7:00
43 Index Function 6:00
44 Match and Index Combination 6:00
45 Vlookup With Match 4:30
Session-12 Introduction of VBA Macros
46 Introduction to Excel Macro VBA 17:00

Buy Similar Courses

3999 90% off
5999 80% off

Best Combo Offer

Actual Price INR 12999
(Limited time offer)

Frequently Asked Questions (FAQs)

What does Advanced Excel course consist of?

Advanced Excel course consists of concepts ranging from complex functions, nesting, data manipulation to basics of VBA Macros. Macro VBA is a separate course, which can be found here.

How can I get certification?
  • After completion of learning modules, you can send an email to or send a message via live chat. You’ll receive a course completion certificate via email within 48 hours.
  • For Microsoft Certification (Exam 77-420), please contact us via customer support and we will book a slot for your examination
How can I get my doubts cleared?

We offer 3 level support to clear your doubts

  • Free Email Support – Send us an email at customercare@aadseducation regarding your doubts and you will receive a reply within 24 hours from the trainer during working days. On Holidays/Weekends, your doubts will be answered within the next 24 hours
  • Join a doubt clearing session along with other students. Contact our customer support to join the session
  • For personalized experience or in case of urgency, you can book for one to one session. To book your slot, send us an email at
Do you provide classroom training for Advanced Excel?

We have discontinued classroom training for this course. Our e-learning course is budget-fit and the cost of the course is 5 times lesser than classroom training. Other advantage is that you can access the course anytime, anywhere. With our lifetime access on courses, you can refer to the videos whenever you have doubts!

Benefits of Advance Excel

  • Advanced Excel skills are must in any role of business to save time and be efficient
  • For every professional from entry to senior-level, Advanced Excel skills are preferred by employers
  • Microsoft Excel is still the best productivity software when it comes to managing data through spreadsheets
  • Opportunity for entry-level job seekers to start a career with Advanced Excel skills
  • By learning this course, individuals will be able to clear: Exam 77-420 certification of Microsoft Advanced Excel

Who Should Attend?

  • From the technical standpoint it can be any one using Excel from any business stream with basic understanding of the Excel environment
  • From the business standpoint it can be an individual from any trade hierarchy or roles from students, accountants, financial professionals, Sales managers, marketing managers, managers in any domains, clerical workers, bookkeepers, instructors, senior manager, director...etc., seeking to perform advance level of Excel skills to manipulate a workbook with multiple sheets for a variety of purposes and situations. Examples include professional-looking budgets, team performance charts, sales invoices and exercise logs.

About the Trainers

  • Microsoft Certified Trainer (MCT)
  • Microsoft product specialist corporate Trainer with 20+ years of Experience
  • Has delivered more than 1000 trainings with a modest feedback of over 4.5/5 throughout the career
  • Very proficient in modern tools and technology which are used as a reference point in teaching when required
  • Is a key contributor and Author to various Microsoft technical E-books
  • Dedicated from past 20+ years delivering Microsoft Office trainings
  • Globally Recognized industrial expert
  • A very rich experience of handling Spreadsheets and PPTs in various domains, having close Matrix teams to geo-separated teams with varying sizes and complexities

Why Aads Education?

  • Excellent Customer and after sales support
  • Global Experience of 16 years in the field of Education, IT, Management Services and Media
  • Collaboration with Global Giants in the field of Education
  • Award Winning Training organization
  • We operate in multiple countries
  • We offer both Online and Classroom trainings
  • We constantly upgrade our course ware, staff, facilities, trainers and we follow the latest trends of the market so that we can offer you the best and latest
  • We assist our participant in placements through our HR consultants and have tie up with large organization
  • Our Professional trainers and mentors are industry experts
  • Our ultimate goal through the training programs is to build high value and high end professionalism in every individual

Professionals participated from

Professionals attended this program from Amazon, Delloite, Genpact etc.
  • About the Trainers

  • Why Aads Education?

I am interested in this course
600 + (GST)
5999 90% off
Offer Ends In
go to top