X
108 ratings    1016 Students Enrolled
Watch the Introduction
Preview the Free Demo Lesson
660 + (GST)
2999 78% off

Features

  • Simple and Easy Video Tutorials
  • Microsoft Certified Trainer (MCT) with 20+ years of Experience
  • Course completion certificate
  • Lifetime access to the course
  • 24/7 Support by Email
  • Learn at your own pace
  • Mobile Friendly
  • Money Back Guarantee
  • International Accredited and Award Winning Training Centre

AADSEducation Advance Excel 2013/2016 training course teaches you techniques employed by experienced users to enhance your use of Excel and build feature rich spreadsheets. Learn exactly what you need to know about advance Excel, including complex functions, nesting, data manipulation and much more. At the end of the course you will become an expert and will be able to use Excel like a Professional.

Benefits of Advance Excel

  • Advance Excel skills are most demanding in every sector of business learning adv. excel will help in your job role.
  • Excel as a tool is being used in small and big organisations globally and it is benchmark product from Microsoft.
  • At the end of this course you will become excel professional.
  • Advance Excel creates an avenue for the new job seeker and extend the skills portfolio of a Professional.
  • By the end of the course you will be able to write and pass (Exam 77-420) of Microsoft advance excel.

Advanced Excel Sessions Plan

Session Topic Duration (Mins)
1 Working with Range Name 15:00
2 Cell References 12:30
3 Statistical Functions 13:00
4 Logical Functions 18:00
5 Array Function 5:00
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
10 Normal Filter 7:00
11 Advanced Filter 8:30
12 Filter with Subtotal Function 8:30
13 Date & Time Function Part-I 16:30
14 Date & Time Function Part-II 11:00
15 Data Validation 21:00
16 Error handling 15:00
17 Working with Table 14:00
18 Consolidate Data from Multiple Sheets into one 19:00
19 Data Analysis using Subtotal Tools 14:00
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
27 Sparklines 8:30
28 What if analysis -Goal Seek 6:06
29 What if analysis -Scenario Manager 8:05
30 Formula Auditing 7:30
31 Data Protection in Excel 14:30
32 Data Import From text 11:45
33 Data Import from We 5:45
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
46 Introduction to Excel Macro VBA 17:00

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

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.

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

Benefits of Advance Excel
  • Advance Excel skills are most demanding in every sector of business learning adv. excel will help in your job role.
  • Excel as a tool is being used in small and big organisations globally and it is benchmark product from Microsoft.
  • At the end of this course you will become excel professional.
  • Advance Excel creates an avenue for the new job seeker and extend the skills portfolio of a Professional.
  • By the end of the course you will be able to write and pass (Exam 77-420) of Microsoft advance excel.
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 courseware, 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
;