AskFarouk.net

Excel Lab files

Data Analysis

Analyze Data – QatarDownload
Transform Data – StartDownload
PivotTables – QatarStoresDownload
chartsDownload
dashboradDownload

Exams

Exam 1Download
Exam 2Download
Quarter-One-ReportDownload

Main files

basicDownload
StaffData-Oct24 UpdateDownload
Phone number changeDownload

Projects Lab

DueDownload
Updated_Factory_Production_Data_Q1_2024Download
Factory_Sales_Data_Q1_2024Download

Lookup

vlookupDownload
ExcelExpert_3-2Download
Match-indexDownload
vlookup-approxDownload

Logical IF

IFDownload
logicalDownload
ExcelExpert_3-1Download
ExcelExpert_3-1 with QuestionsDownload

What -IF

PMTDownload
Goal SeekDownload
data table exerciseDownload

Power Query

Folder append

Jan 2022Download
Feb 2022Download
Mar 2022Download

Power Query Labs

PQ Exercise 1aDownload
PQ Exercise 1bDownload
PQ Exercise 1cDownload
PQ Exercise 1dDownload
PQ Exercise 2bDownload
PQ Exercise 2dDownload
PQ Exercise 2zDownload
PQ Exercise 3aDownload
PQ Exercise 3bDownload
PQ Exercise 3zDownload
Workbook1Download
Workbook2Download

Visualization

chartDownload
ExcelExpert_4-1Download

Data Validations

Validation with questionsDownload

Conditional Formatting

Conditional FormatsDownload
ExcelExpert_2-3aDownload

Pivot-Table

PivotTablesDownload
Sales Data PivotingDownload

Ice Breakers

BreakoutPuzzle-QatarDownload
find the missing numberDownload
by nationalityDownload

More

Apr 2022Download
May 2022Download
Jun 2022Download