Excel Course

Introduction
• Excel Layout
• Data Entry
• Data Types
• Data Formatting
• Copy-Paste options
• Working with multiple sheets
• Magic of Fill Command
• Separate Columns (Tools & Text Functions)

Data Manipulation
• Advanced Sort & Filter Data
• Don’t repeat your work (Creating Macro & Macro types)
• Fixing Reference (Relative Vs Absolute value)
• Time Table
• Naming Ranges
• Remove Duplicates
• Magic of (Find and Replace tool)
• Data Validation

Data Analysis
• Aggregation Functions ( Sum & subtotal & Count & Max & Min & SV…….)
• Logical Functions ( Equal & IF & And & Or & Not & Nested If & Ifs …………)
• Conditional Aggregation Functions (Sum if & Count ifs & Average ifs …….)
• Lookup Functions ( VLOOKUP & HLOOKUP & Index & Match & indirect & Choose…..)
• Date & Time Functions
• Array Functions ( XLOOKUP & Unique & Filter ……)
• Advanced Select options & Grouping Data
• Conditional Formatting
• Custom Formatting

Pivot Tables
• Tables Vs Ranges
• Pivot Table Tricks
• Slicers ( Sync multiple tables & Charts)
• Formatting Pivot table & Slicers
• Calculated Fields
• Pivot Charts
• Get pivot Data Function
• Change Data Source

Data Visualization
• Choosing the appropriate Chart & Formatting Chart
• Pie & Doughnut Charts
• Area &Line Chart
• Column & Bar Charts
• Bridge Chart
• Treemap Chart
• Sparklines
• Final Project: Creating Excel Dashboard