Day 6: Advanced Excel & Data Analysis | Lookups, SUMIFS & Pivot Tables

In Day 6 of the Data Analytics series, we move from basic Excel skills to advanced Excel techniques that are expected in almost every data analyst job role. This session focuses on lookup functions, conditional aggregations, and Pivot Tables—the tools that help analysts work efficiently with large, multi-table datasets and generate insights in minutes. In this video, you’ll learn: How to use VLOOKUP and when its limitations matter Why INDEX-MATCH is more powerful and flexible than VLOOKUP How XLOOKUP simplifies lookups in Excel 365 Conditional aggregation using SUMIF, SUMIFS, COUNTIF, COUNTIFS, AVERAGEIF How to build Pivot Tables to summarize and analyze large datasets Pivot features like grouping, slicers, calculated fields, and pivot charts Sorting, filtering, and conditional formatting to highlight key patterns Hands-on exercises using realistic sales datasets By the end of Day 6, you’ll be able to analyze real business datasets, connect data across tables, and build professional-grade Excel analysis used in dashboards and reports. 📌 Ideal for: Aspiring Data Analysts | Intermediate Excel Users | Business Analysts | Freshers preparing for analytics roles