Curriculum
Guided course : Excel for Data analysis
Introduction
0/2
Excel Basics
0/8
-
Getting started with Excel
08:18 minPreview -
Worksheet Basics
16:42 min
-
Entering Values And Formulas
7:05 min
-
Book a 1-to-1 live session with our mentors
Text lesson -
Data Formats
08:37 min
-
Quiz
5 questions -
Data Handling Basics - Cut, Copy and Paste
13:56 min
-
Saving and Printing in Excel
08:57 minPreview
Essential Formula Operations
0/20
-
Basic Formula Operations
13:10 min
-
Quiz
5 questions
-
Mathematical Functions - Part
11:36 min
-
Mathematical Functions - Part 2
07:31 min
-
Difference between RANK, RANK.AVG and RANK.EQ
00:36 min
-
Exercise : Mathematical Functions
00:12 min
-
Quiz
5 questions
-
Textual Functions - Part 1
08:46 min
-
Textual Functions - Part 2
08:37 min
-
Exercise : Textual Function
00:07 min
-
Quiz
5 questions
-
Logical Functions
11:14 min
-
Exercise : Logical Functions
00:07 min
-
Quiz
5 questions
-
Date-Time Functions
07:00 min
-
Exercise : Date-Time Functions
00:09 min
-
Quiz
5 questions
-
Lookup Functions ( V Lookup, Hlookup, Index-Match )
08:34 min
-
Exercise : Lookup Functions
00:10 min
-
Quiz
5 questions
XLookup - only for Excel 2021 and Office 365
0/6
Data Tools
0/5
Formatting data and tables
0/3
Pivot Tables
0/4
Excel Charts
0/22
-
Excel Charts - Categories of me
04:35 min
-
Elements of charts
05:33 min
-
Quiz
5 questions
-
The Easy way of creating charts
03:18 min
-
Bar and column charts
12:38 min
-
Exercise : Bar and column charts
00:12 min
-
Quiz
5 questions
-
Formatting charts
15:13 min
-
Line Charts
09:05 min
-
Area Charts
06:04 min
-
Pie and Doughnut Charts
13:05 min
-
Exercise : Line, Area and Pie chart
00:12 min
-
Quiz
4 questions
-
Why we should avoid Pie chart
04:06 min
-
Scatter plot or XY chart
06:17 min
-
Frequency Distribution and Hi
13:03 min
-
Waterfall Charts
12:01 min
-
Hierarchy Charts: Sunburst and Treemap
07:57 min
-
Combination charts
07:32 min
-
Sparklines
05:44 min
-
Exercise : Advance Excel Charts
00:12 min
-
Quiz
4 questions
Pivot Charts
0/1
NEW! Analyze Data option in Excel - only for Microsoft 365 users
0/1
Maps Chart - only for Excel 2019 and above
0/1
Special purpose charts
0/7
Named Ranges
0/4
Excel Shortcuts
0/2
Using ChatGPT with Excel
0/2
Importing data from PDF and Websites
0/4
Advanced Excel
0/5
Creative Infographics
0/5
Video lesson
Google