Who is this guide for ?

• Knows basic Excel (data entry, basic formulas, charts).
• Wants to analyze data, automate tasks, or build dashboards.

Strengthen Your Formula Foundation

What to Learn:

• Basic Functions Review: SUM, AVERAGE, MIN, MAX, COUNT
• Logical Functions:IF: =IF(A1>100, "Pass", "Fail"),AND, OR: Combine multiple conditions.

Learn Data Tools for Cleanup & Analysis

What to Learn:

• Data Cross-validation : Create dropdown menus.
• Text to Columns : Split full names or addresses.
• Remove Duplicates: Clean duplicate records.
• Flash Fill: Automatically fill patterns (like first names from full names).

Use Sorting, Filtering & Conditional Formatting

What to Learn:

• Sort & Filter by multiple columns.
• Conditional Formatting to: Highlight values above average.Color code using data bars or icon sets.

Introduction to PivotTables

What to Learn:

• Create a PivotTable from a dataset.
• Drag fields to Rows, Columns, Values.
• Use filters and slicers.

Get Started with Power Query (Data Cleanup Tool)

What to Learn:

• Import data from Excel/CSV files.
• Clean/transform data (remove rows, rename columns, split columns).
• Use Applied Steps to automate the cleanup.

Master Charts & Visualizations

What to Learn:

• Standard Charts: Column, Line, Pie
• Dynamic charts using named ranges or tables.
• Advanced: Combo charts, Sparklines, Histogram