Join Our Most Professional Telegram Group. Only Learning. No Nonsense. https://t.me/TheExcelism
Topic: Advanced Ms-Excel I Mode: Online LIVE I Date: ---- I Time: ---- I Fees: INR 5,000
SYLLABUS:
|
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
13. 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
14. Writing Nested Formula 15. Array Functions 16. Re-Engineering of Formula 17. Formula Auditing 18. 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
27. Comparision of Version 2007 Vs Version 2010 Vs Version 2013 Vs 2016 i) Sparklines ii) Slicers iii) Timeline iv) Falsh Fill v) Recomended Charts / Pivot Tables vi) Relationships under Pivot Table |
