Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Excel Beginners Guide - Fundamental Tools to Work Smarter in 2020
Introduction to Microsoft Excel
Introduction (1:56)
Excel interface overview (4:25)
Excel Ribbon - How to work and how to customize (3:50)
Quick Access Toolbar - How to use and edit (1:38)
Start Working With Excel - Learn Fundamental Tools
Excel Workbooks - Create, Open and Save files (5:18)
Working with Worksheets - Add, delete and change name (2:44)
Automatic data with autofill - save time using this tool (5:25)
Rows and columns - Add and delete (4:07)
Hide & Unhide Rows/Colums and Worksheets (4:20)
Change row and column size (3:29)
Wrap, shrink and merge text (4:05)
First Challenge - Practical exercise using Font tools (3:27)
Format painter tool - Another powerfull tool to save time (2:46)
Format Numbers Tool - Date and Time Format (5:00)
Identify and Remove Duplicates Values (4:10)
Sort and Filter Tools (14:28)
Formulas and Functions to manipulate your Data
Cell references to link data - Relative, absolute and mixed (8:09)
Formula Anatomy - How to create a formula using Math operators (4:43)
Use Functions in Excel - Syntax used to create functions (4:07)
Sum Numbers with Sum Function (2:34)
Average Function for cells ranges average calculation (1:35)
How to use Statistical Functions Min and Max (2:00)
Count and CountIf Functions (5:31)
Exercise with Logical Functions IF, OR and AND for single and multiple condition (7:10)
Conditional Addition with Sumif and Sumifs (3:54)
Extract Data using Vlookup Reference Function (6:08)
Hlookup Function to Extract Data (2:43)
Offset function for dinamyc ranges (14:51)
Excel Workbooks - Create, Open and Save files
Complete and Continue