BECOME a Advanced Excel EXPERT

ExtraCourse is the NO.1 Excel training institute offering the best Advance Excel online training in Hyderabad, expert guidance and 100% placement assistance..

Extra Course is the best Advanced Excel training in Hyderabad. We offer 100% practical driven program through our unique experiential learning, focus on comprehensive practical approach. We follow a holistic curriculum which has been designed by Industrial experts in a systematic approach from the beginner’s level to a more advanced study.

Holistic Curriculum | Complete Practical Driven Learning | Real Time Projects | Be a Future Ready

Key Highlights of Advanced Excel online training

  • Curriculum is curated by Industrial Experts in Excel

  • Extensive study on real time projects

  • Handouts, Exercises and Assignments on each and every topic in Advance Excel

  • Work on Real-time scenarios

  • 100+ Hands on Practical Assignments

  • Real time work on currently running projects

  • Resume preparation

  • Mock Interviews

  • 100% Placement Assistance

  • All classes will be recorded and sent to you everyday

  • Get Certified

WhatsApp Image 2020-08-29 at 11.16.01 AM

What you'll learn

  1. Architecture of Spreadsheet
  2. Usage of Formula
  3. Excel Functions & Formulas
  4. Re-Engineering of Formula
  5. Data Analysis
  6. Editing the Recorded Macro VBA Code
  7. Compatibility

Course Duration

Course Name
Type
Course Duration
Price
Advanced Excel
Training
25 hrs
5,000/-

Advanced Excel Course Content

Section 1: Understanding the Excel

1. Architecture of Spreadsheet
2. Excel Interface
3. Different types of Values
​4. Characteristics of Excel
5. Entering Values into Excel

Section 2: Usage of Formula

6. Understanding a Formula
7. Rules of the Formula
8. Understanding the Syntax
9. Different Categories of Functions
10. Characteristics of Arguments
11. Types of Cell References
12. Define Names

Section 3: Excel Functions & Formulas

  1. 70+ Excel Functions includes
    i) Mathematical Functions (SUM, SUMIF, SUMIFS, AGGREGATE, SUBTOTAL, SUMPRODUCT etc.,)
    ii) Text Functions (LEFT, RIGHT, MID, LEN, FIND, SUBSTITUTE etc.,)
    iii) Logical Functions (IF, IFERROR, AND, OR etc.,)
    iv) Lookup Functions (VLOOKUP, HLOOKUP, CHOOSE, INDEX, MATCH, INDIRECT, OFFSET etc.,)
    v) Financial Functions (FV, PV, NPV, IRR, RATE etc.,)
    ​vi) Statistical Functions (AVERAGE, MAX, MIN, COUNT, RANK etc.,)
    vii) Date & Time Functions (DATE, MONTH, YEAR, DATE, WEEKDAY, DATEDIF etc.,)

Section 4: Writing Advanced Formula

  1. Writing Nested Formula
  2. Array Functions
  3. Re-Engineering of Formula
  4. Formula Auditing
  5. Watch Window

Section 5: Data Analysis

19. Text to Columns
20. Sorting includes Custom Sorting
21. Filtering includes Advanced Filtering
22. Consolidation of more Datasets
23. Using Subtotals
24. Pivot Tables for
i) Range
ii) Tables
iii) External Data
25. Charts
26. Data Validation

Section 6: Macros

27. Recording a Macro
28. Editing the Recorded Macro VBA Code
29. Saving the Macro for all workbooks
30. Assigning a Shortcut or Button to Macro

Section 7: Compatability

31. Comparison of Version 2007 Vs Version 2010 Vs Version 2013 Vs 2016
i) Spark-lines
ii) Slicers
iii) Timeline
iv) Falsh Fill
v) Recommended Charts / Pivot Tables
vi) Relationships under Pivot Table