Advance Excel
Advance Excel Course - Syllabus
Sort Functions
Paste functions
Lookup functions (Vlookup, Hlookup, Xlookup, Index, Match)
Pivot Table, Chart and Slicer
Basic + Advanced Formulas
Conditional Formatting
Filter and Advanced Filter
Data validation
What if Analysis
Macros
Power Query
Link
Page Layout setup
Linking External data
Data Tables
Worksheet Editing
Shortcut keys and tricks in excel
Dashboard creation
Charts, Graph creation and analysis