⚠️ Report an Error
Back to Catalog Technology & Programming

Microsoft Excel for Data Analysis, Reporting & Business Intelligence

Microsoft Excel for Data Analysis, Reporting & Business Intelligence is a practical, hands-on course designed to help professionals turn raw data into meaningful insights. You will learn how to clean,…

0.0 (0 ratings) 1 students 15 hours 14 lessons
Rahim Zulfiqar Ali
About This Course

Microsoft Excel for Data Analysis, Reporting & Business Intelligence is a practical, hands-on course designed to help professionals turn raw data into meaningful insights. You will learn how to clean, transform, and analyze data using advanced Excel tools, create dynamic reports and dashboards, and apply business intelligence techniques to support smarter decision-making. Ideal for analysts, bankers, and business professionals looking to enhance their data-driven skills.

Syllabus
14 lessons
Fundamentals
1
01 - Introduction to Excel - Module A - Excel Basics (for Beginners) Sign In to Preview Video
2
02 - Relative & Absolute Cell References - Module A - Excel Basics (for Beginners) Sign In to Preview Video
Excel Essentials
3
03 - Formatting Paste Special - Module B - Excel Essentials Video
4
04 - Excel Tables - Module B - Excel Essentials Video
5
05 - Data Filters and Sorting - Module B - Excel Essentials Video
6
06 - Data Validation Tips & Tricks - Module B - Excel Essentials Sign In to Preview Video
7
07 - Named Ranges - Module B - Excel Essentials Sign In to Preview Video
8
08 - Worksheet and Workbook Protection - Module B - Excel Essentials Video
9
09 - Printing and Page Layout Tab - Module B - Excel Essentials Video
10
10 - Handle Formula Errors - Module B - Excel Essentials Video
Formulas and Functions
11
11 - Using IF Formula, Nesting IF Formulas - Module C - Excel Formulas and Functions Sign In to Preview Video
12
12 - Using IF with AND OR Formulas - Module C - Excel Formulas and Functions Sign In to Preview Video
13
13 - COUNTIFS, SUMIFS, AVERAGEIFS Formulas - Module C - Excel Formulas and Functions Video
14
14 - Excel TEXT Functions - Module C - Excel Formulas and Functions Video
Your Instructor
Rahim Zulfiqar Ali
Masters

Founder & CEO Excel Basement, Microsoft Most Valuable Professional (MVP) Excel M365 (2025-26), Microsoft Certified Trainer (MCT) 2016-2025, Microsoft Excel & POWER BI Trainer & Consultant (2011 to Pre…

1 course 1 students in this course
Free
Register to Enroll Sign In
15 total hours
14 lessons
Technology & Programming
Certificate on completion