Excel Interface Review: Quick Recap of Basic Excel Functions, Customizing the Ribbon and Toolbar, Working with Multiple Sheets and Workbooks, Cell Referencing: Relative, Absolute, and Mixed.
Advanced Formulas & Functions: Logical Functions: IF, AND, OR, IFERROR, Lookup & Reference: VLOOKUP, HLOOKUP, XLOOKUP, INDEX, MATCH, Text Functions: TEXT, LEFT, RIGHT, MID, CONCAT, TEXTJOIN, Date & Time Functions: TODAY, NOW, DATEDIF, EDATE, Math & Statistical: SUMIFS, COUNTIFS, AVERAGEIFS, ROUND, RANK.
Data Analysis Tools: Sorting and Filtering (Advanced Filters), Conditional Formatting with formulas, Data Validation (drop-down lists, restrictions), What-If Analysis: Goal Seek, Data Tables, Scenario Manager, Pivot Tables and Pivot Charts, Grouping, Filtering, and Calculated Fields in Pivot Tables.
Charts and Visualization: Creating and Customizing Charts, Dynamic Charts with Named Ranges, Combo Charts (Bar + Line), Sparklines, Conditional Formatting in Charts.
Advanced Excel Tools: Named Ranges, Form Controls (Checkboxes, Drop-downs), Data Consolidation, Remove Duplicates & Flash Fill, Grouping & Outlining Data.
Excel Dashboard Design (Intro): Creating Interactive Dashboards, Linking Charts, Tables, and Filters, Using Slicers with Pivot Tables, Designing Layout for Reporting.
Importing & Exporting Data: Importing Data from Text, CSV, Web, and Other Sources, Cleaning and Transforming Data, Connecting Excel to Access or SQL (Intro Level).
Protection and Security: Worksheet and Workbook Protection, Locking Cells and Ranges, Password-Protecting Files, Tracking Changes and Comments.
Introduction to Macros (Optional): Recording and Running a Macro, Assigning Macros to Buttons, Understanding Basic VBA Code (Optional).
Qual : 8th or 10th or Above
Course Code : M-S003
Course Code : DS002
Course Code : DS013
Course Code : DS025
Course Code : M-T-S005
Course Code : M-D-S004
Course Code : M-AH-S006
Course Code : S-DS032
Course Code : MD-S-006
Course Code : DS-S005