Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Ms Excel/Excel 2020 - the complete introduction to Excel
Introduction
Introduction (7:57)
Starting out
The basics of Excel (15:38)
Relative vs absolute cell reference (9:38)
Difference between a function and a formula (2:44)
Basic Excel formulas (4:50)
Project 1 (7:49)
Functions
Introduction to excel functions (9:08)
If function (10:10)
VLOOKUP Function (10:39)
Project 2 (10:06)
Charts and Data
Visually representing Data (10:01)
Creating and using Charts (9:02)
Importing Data from the Web (13:57)
Project 3 (13:10)
Pivot tables
Introduction to pivot tables (16:44)
Course project
Step 1 Creating the architecture of the APP (10:39)
Step 2 Entering the functions (11:12)
Step 3 Manipulating the Data and tests (10:04)
Final Words
Final Words (2:10)
The basics of Excel
Complete and Continue