Data AnalyticsBeginner
Excel for Data Analysis
Master formulas, pivot tables, charts, and dashboards. The fastest path from spreadsheet user to data analyst.
June 6, Saturday 10:00 AM - 1:00 PM 3 Hours Faizan AnsariOnlineOffline
What You'll Learn
Master 30+ essential Excel formulas
Build pivot tables to summarise large datasets
Create interactive dashboards
Clean and transform real-world data
Session Agenda
01
10:00 - 10:45
Excel Foundations & Formula Mastery
VLOOKUP, INDEX-MATCH, IF nesting, SUMIFS
02
10:45 - 11:30
Pivot Tables & Data Summarisation
Group, filter, and aggregate large datasets
03
11:30 - 12:00
Data Cleaning & Transformation
Remove duplicates, handle blanks, reshape raw data
04
12:00 - 12:45
Interactive Dashboard Design
Build a live Excel dashboard with slicers and charts
05
12:45 - 13:00
Q&A & Interview Tips
Common Excel interview questions
Who Is This For?
Freshers entering the job market
Working professionals who use Excel daily
Anyone preparing for analyst interviews
Meet Your Instructor
What Our Students Say
“I had a highly positive experience completing the SQL course with AnalyticShala. The instructor is very knowledgeable, clear and responsive, ensuring an engaging and effective learning experience.”
SameerData Analyst @ Infosys
“I recently took Data Analytics using Python classes with AnalyticShala, and my experience was exceptional. The course provided a deep and practical understanding of the subject.”
NehaManager @ Genpact