Week 4 of EXCEL101 was the week students stopped cleaning data manually and started building systems. Up until now, we had been working with datasets that were already structured enough to analyze. This week introduced a different reality: Data rarely arrives analysis-ready. It comes from different files, different teams, different systems, and often in different formats. That's why we spent the week learning "Power Query" — Excel's built-in data transformation engine. And once students saw what it could do, the conversation changed. We started with the concept of ETL: Extract – Bring data in from external sources. Transform – Clean, standardize, reshape, and enrich the data. Load – Push the refined dataset into Excel for reporting and analysis. The most important lesson wasn't the buttons. It was understanding that Power Query doesn't change your original data. Every transformation becomes a recorded step. Fix it once. Refresh forever. That's a completely different way of working. For the practical session, students worked with multiple CSV files based on regional sales data. The datasets were intentionally messy. Different date formats. Inconsistent name formats. Extra spaces. Blank rows. The kind of problems analysts deal with every day. Step by step, students learned how to: * Remove blank rows * Fix incorrect data types * Standardize text fields * Create calculated columns * Generate date-based attributes * Load clean datasets back into Excel The highlight for many students was "Appending". Instead of manually copying and pasting multiple reports into one sheet, they combined separate datasets into a single master table using Power Query. More importantly, they learned the principle behind it: Automation only works when structure is respected. If column names, formats, and data types are inconsistent, automation breaks. If the structure is right, the process scales. From there, we moved into "Data Modeling concepts". Students were introduced to Fact and Dimension tables and the idea that not all data belongs in one giant spreadsheet. We discussed: * Fact Tables (transactions and measurable events) * Dimension Tables (descriptive information) * Primary Keys * Foreign Keys These concepts laid the foundation for one of the most important topics of the week: Merge. Many students initially saw Merge as another lookup feature. By the end of the session, they understood that it is much more than that. Append adds rows. Merge adds context. Append is vertical. Merge is relational. We explored different join types and discussed why choosing the wrong join can change the results of an analysis without generating an error. That insight alone was worth the session. Then came the assignment. Students received data from a fictional logistics company containing shipment transactions, customer information, route details, and driver records. Their task was to: * Clean and standardize the shipment data * Merge multiple dimension tables into the fact table * Create new calculated fields * Build KPI summaries * Develop PivotTable reports and charts * Answer business questions using the transformed dataset The objective wasn't simply to build reports. It was to create a repeatable workflow that could handle changing data. That's what analysts do. They don't just analyze data. They design processes that make analysis possible. Week 4 introduced that mindset. And with Power Query now in place, students are beginning to see Excel as more than a spreadsheet application. They're starting to see it as a complete data transformation and reporting platform. Next up: Power Pivot, Data Modeling, DAX, and KPI Reporting.

Just go camp here.

As simple as excel dashboard looks it's not really easy to create... can't wait to be really Good at it !!! If you have any resource that can help a beginner to create good dashboard in excel, please drop it in the comment section.

Day in a life of an unemployed person 😭