MS Excel Masterclass

A complete course to increase your office productivity
Introduction
Course Overview
3 mins
Study Material and all Exercise files
13.5 MB
Basics
Basics
9 mins
Entering values and Formulas
8 mins
Data Formats
9 mins
Worksheet Basics
17 mins
Data Handling Basics - Cut, Copy and Paste
14 mins
Saving and Printing - Basics
9 mins
Essential Formulas
Basic Formula Operations
14 mins
Mathematical Functions
20 mins
Textual Functions
8 mins
Logical Functions
12 mins
Date-time (Temporal) Functions
8 mins
Lookup Functions
Lookup Functions
9 mins
Data Tools
Data Tools
20 mins
Formatting data and tables
Formatting data and tables
18 mins
Pivot Tables
Pivot Tables
9 mins
Charts
Categories of messages that can be conveyed
5 mins
Elements of charts
6 mins
The Easy way of creating charts
4 mins
Bar and column charts
13 mins
Formating charts
16 mins
Line Charts
10 mins
Area Charts
7 mins
Pie and Doughnut Charts
14 mins
Why we should avoid Pie charts
5 mins
Scatter plot or XY chart
17 mins
Frequency Distribution and Histograms
14 mins
Excel Shortcuts
Excel Shortcuts
13 mins
Analytics in Excel
Analytics in Excel
16 mins
Macros
Macros
11 mins
Bonus Lectures
Waterfall chart
12 mins
Infographics 1: Cool charts
15 mins
Infographics 2: Cool charts
7 mins