Data Analysis
Learn powerful tools and techniques to analyze data and derive insights.
Detailed Tutorials
Click any tutorial card above to see the steps and download the practice file.
What is Sort & Filter?
Quickly organize data and focus only on what matters.
- Step 1: Select your data
- Step 2: Data → Filter
- Step 3: Apply filters
Conditional Formatting
Highlight important values and patterns automatically.
- Highlight Top Values
- Color Scale
- Duplicate Values
- Formula Based Formatting
What is Sort & Filter?
Sort and filter the Data
- Step 1: Select your data
- Step 2: Data → Filter
- Step 3: Apply filters
Conditional Formatting
Format the data as per condition.
- Highlight Top Values
- Color Scale
- Duplicate Values
- Formula Based Formatting
What-if Analysis
Test different outcomes before taking a decision.
- Goal Seek
- Scenario Manager
- Data Tables
Data Cleaning
Clean and prepare your data for analysis and dashboards.
- Remove Duplicates
- TRIM Function
- Flash Fill
- Text to Columns
Pivot Tables
Create Pivot tables Process
- Create Pivot Table
- Rows
- Columns
- Values
- Filters
Data Validation Card
Validate the Data.
- Dropdown Lists
- Number Validation
- Date Validation
- Custom Validation
Pivot Tables
Create fast summaries and interactive reports.
- Create Pivot Table
- Rows
- Columns
- Values
- Filters
Data Validation
Control data entry to reduce errors and keep your sheet clean.
- Dropdown Lists
- Number Validation
- Date Validation
- Custom Validation
Data Cleaning
Make data clean
- Remove Duplicates
- TRIM Function
- Flash Fill
- Text to Columns
Remove Duplicates
Remove Duplicates from the data
- Select Data
- Go to Data Tab – Click Data → Remove Duplicates
- Choose Columns
- Confirm – Click OK