Beginner
Data Analysis with Excel
Organizing raw data in Excel, summarizing it with pivot tables and basic formulas, and reporting with simple charts.
Request This TrainingWho It's For
academic researchers (individual) and corporate teams It's suitable for
Prerequisites
- None
Learning Outcomes
- Summarizing data with pivot tables
- Matching data with VLOOKUP / INDEX-MATCH
- Building basic charts and dashboards
- Data cleaning (removing duplicates/errors)
Program
1
Organizing and Cleaning Data
- Cell formatting
- Cleaning duplicate/erroneous data
- Text-to-number conversions
2
Formulas and Functions
- VLOOKUP / INDEX-MATCH
- Conditional functions (SUMIF, COUNTIF)
3
Pivot Tables and Summarizing
- Setting up pivot tables
- Grouping and filtering
4
Visualization and Reporting
- Chart types
- Simple dashboard design
Tools Used
Microsoft Excel
Frequently Asked Questions
The current Microsoft 365 version is recommended; it is also compatible with 2016 and later versions.
Yes, that is the preferred approach.
Submit your request to take this training.
Request This TrainingWe respond to requests within 24 hours.