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 What you'll learn Architecture of Spreadsheet Usage of Formula Excel Functions & Formulas Re-Engineering of Formula Data Analysis Editing the Recorded Macro VBA Code Compatibility Course Duration Course Name Type Course Duration Price Advanced Excel Training 25 hrs 5,000/- Advanced Excel Course ContentSection 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 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 Writing Nested Formula Array Functions Re-Engineering of Formula Formula Auditing 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