Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Excel Beginners Guide - Fundamental Tools to Work Smarter in 2020
Introduction to Microsoft Excel
Introduction
Excel interface overview
Excel Ribbon - How to work and how to customize
Quick Access Toolbar - How to use and edit
Start Working With Excel - Learn Fundamental Tools
Excel Workbooks - Create, Open and Save files
Working with Worksheets - Add, delete and change name
Automatic data with autofill - save time using this tool
Rows and columns - Add and delete
Hide & Unhide Rows/Colums and Worksheets
Change row and column size
Wrap, shrink and merge text
First Challenge - Practical exercise using Font tools
Format painter tool - Another powerfull tool to save time
Format Numbers Tool - Date and Time Format
Identify and Remove Duplicates Values
Sort and Filter Tools
Formulas and Functions to manipulate your Data
Cell references to link data - Relative, absolute and mixed
Formula Anatomy - How to create a formula using Math operators
Use Functions in Excel - Syntax used to create functions
Sum Numbers with Sum Function
Average Function for cells ranges average calculation
How to use Statistical Functions Min and Max
Count and CountIf Functions
Exercise with Logical Functions IF, OR and AND for single and multiple condition
Conditional Addition with Sumif and Sumifs
Extract Data using Vlookup Reference Function
Hlookup Function to Extract Data
Offset function for dinamyc ranges
Sort and Filter Tools
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock