Скачать или смотреть 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