6 Sections
18 Lessons
10 Weeks
Expand all sections
Collapse all sections
Preparing Business-Ready Data using Excel
0
Key Business Questions
3
2.1
How do I clean and unify inconsistent data from multiple sources?
2.2
How do I automate reports and dashboards for recurring business needs?
2.3
Can I use Excel to model business scenarios and make data-backed decisions?
Advanced Excel for Data Structuring
Master core Excel functions used in business analysis:
3
3.1
Logical functions: IF, IFS, AND, OR
3.2
Lookup functions: VLOOKUP, INDEX, MATCH, XLOOKUP
3.3
Text & Date handling: TEXTJOIN, LEFT/RIGHT, DATEDIF
Summarizing & Visualizing Business Metrics
3
4.1
Create dynamic summaries using PivotTables & Pivot Charts
4.2
Apply business logic through Conditional Formatting and Data Validation
4.3
Build an interactive performance dashboard
Modelling Scenarios & Workflow Automation
3
5.1
Use What-If Analysis (Goal Seek, Data Tables, Scenario Manager) for forecasting
5.2
Optimize resource allocation using Solver Add-in
5.3
Automate data workflows using Power Query in Excel
Projects
6
6.1
Data Cleaning & Preparation in Excel
6.2
Sales Analysis Dashboard
6.3
Advanced Data Filtering
6.4
Bank Marketing Campaign Report
6.5
Human Resource Dashboard
6.6
Project Management Analysis
Advanced Excel course
Curriculum
This content is protected, please
login
and enroll in the course to view this content!
Your Website
Modal title
Main Content
Your Website
