Learn Advance Excel for Data Analysis(ChatGPT Flavour)

Advance Excel Functions, Pivot Table, Charts, Dynamic Dashboards

Created byMohammed Abdul Rafay Imran Khan

Last updated 6/2025

English

What you'll learn

Excel provides functions, formulas, and features like PivotTables and the "Analyze Data" feature to simplify complex calculations and summarize large datasets.
By analyzing data trends and patterns, individuals can make more informed and strategic decisions across various business functions.
Tools like charts and graphs help in visually representing data, making it easier to identify trends, patterns, and communicate insights clearly to stakeholders
Excel's user-friendly interface and wide adoption make it a versatile tool applicable in many industries and roles

Course content

1 section • 5 lectures • 4h 40m total length

Introduction to Advance Excel Functions39:56
a) Vlookup Formula
b) Hlookup Formula
c) Xlookup Formula
d) Filter Formula
e) & Formula
f) Textjoin Formula
g) Sumif Formula
h) Sumifs Formula
i) Countif Formula
j) Countifs Formula
Introduction to Power Query in Excel41:39
a) Importing Data from Files
b) Append Excel Tables
c) Merge Different Tables
d) Data Modelling aspects
e) Data Cleaning & Transformations
f) Adding Columns
g) Merging Columns
i) Split Columns
j) Pivot Columns
k) Unpivot Columns
l) Group Columns
m) Using features of Column from Examples
n) And function
o) Or function
p) If statement
Using ChatGPT and implement Data Analysis25:33
a) Creating a prompt for SUM
b) Creating conditional IF Statement prompt
c) Creating prompt for Average of numbers
d) Creating conditional IF Statements(advance multiple conditions )
e) Data Cleaning Prompts
f) Prompts for aggregation with if statement
g) Creating a sample table with structure and records
Pivot Table, Pivot Charts & Dashboards2:13:25
a) Creating Pivot Tables
b) Creating Pivot Charts
c) Creating Data Analysis Dashboard of Employee Salaries based on Education
d) Creating Data Analysis Dashboard of Retail Domain
e) Creating Data Analysis Dashboard of KPIs of IT Infrastructure
Creating a Dynamic Dashboard with Story39:31

Requirements

The course is designed in a way that you can comfortably grasp the concepts and hence there are no prerequisites required.

Description

Data analysts routinely use Microsoft Excel to organize, interpret, and evaluate data. The program includes numerous tools and features crucial to the data analysis process. Pivot tables transform chaotic, overwhelming datasets into useful, structured information while pivot charts allow you to visualize data using line graphs, bar charts, area charts, and other graphical representations. Conditional formatting is another tool for organizing data into easy-to-understand, eye-catching visuals. If you want to display the need-to-know information succinctly and beautifully, you can use an Excel feature called dashboards to do so.

Functions such as VLOOKUP, XLOOKUP, and FILTER constitute the foundation of most Excel data analysis capabilities. Using functions, you can search for and retrieve data, detect errors, organize information, perform complex mathematical operations, and much more.

Pivot tables and pivot charts allow you to organize large quantities of data in meaningful ways, identify patterns and trends, and answer questions about the data. Data analysts often use these powerful tools to analyze income and expenses and understand how resources are allocated in a business.

Microsoft Excel is one of the most widely used software applications in the country. With Excel, you can organize and analyze data, perform calculations, identify errors, visualize information, and even make predictions about changing variables. Developing Microsoft Excel skills is crucial for the data analysis field.

Who this course is for:

Data Analysts, Business Analyst, Data Science & Excel Enthusiasts