📈 Data Analysis & Power Query
2 files
Advanced data analysis techniques including conditional formatting, logical functions, SUMPRODUCT, LET, LAMBDA, and data transformation tasks.
Analyze Data – Qatar.xlsx
⬇ Download
Transform Data – Start.xlsx
⬇ Download
📊 Pivot Tables & Dashboards
4 files
Master pivot tables, create interactive dashboards with slicers and charts, and build comprehensive sales reports with year-over-year comparisons.
PivotTables – QatarStores.xlsx
⬇ Download
charts.xlsx
⬇ Download
dashborad.xlsx
⬇ Download
Quarter-One-Report.xlsx
⬇ Download
✅ Exams & Assessments
2 files
Comprehensive exam files to test student proficiency in multiple Excel skills including functions, data analysis tools, and what-if analysis.
Exam 1.xlsx
⬇ Download
Exam 2.xlsx
⬇ Download
🎯 Foundational Skills
1 file
Starter file with basic calculations using different reference methods: point-and-select, named ranges, and table references.
basic.xlsx
⬇ Download
📊 Statistical & Counting Functions
2 files
Master COUNTIF and SUMIF functions with a comprehensive 741-employee dataset, plus learn to automate data updates.
StaffData-Oct24 Update.xlsx
⬇ Download
Phone number change.xlsx
⬇ Download
🔍 Lookup & Reference Functions
4 files
Practice VLOOKUP (exact and approximate match), INDEX-MATCH functions, and apply them in real-world scenarios like customer classification.
vlookup.xlsx
⬇ Download
vlookup-approx.xlsx
⬇ Download
Match-index.xlsx
⬇ Download
Due.xlsx
⬇ Download
🧮 Logical Functions
2 files
Learn IF, AND, OR, NOT functions and more complex logical operations to create dynamic spreadsheets.
IF.xlsx
⬇ Download
logical.xlsx
⬇ Download
💰 Financial Analysis
2 files
Master financial functions like PMT for loan calculations and use Goal Seek for powerful what-if analysis.
PMT.xlsx
⬇ Download
Goal Seek.xlsx
⬇ Download
🏭 Factory Data Analysis
2 files
Analyze factory performance by combining production and sales datasets for comprehensive business intelligence.
Updated_Factory_Production_Data_Q1_2024.xlsx
⬇ Download
Factory_Sales_Data_Q1_2024.xlsx
⬇ Download
🎓 Excel Expert Series
3 files
Advanced Excel exercises focusing on logical functions (IF, IFERROR, ISNULL) and other expert-level techniques.
ExcelExpert_3-1.xlsx
⬇ Download
ExcelExpert_3-1.xlsx (with Questions)
⬇ Download
ExcelExpert_3-2.xlsx
⬇ Download