Curriculum
Course:
Microsoft Excel Basics for Beginners
Login
Curriculum
Microsoft Excel Basics for Beginners
0/29
01 Trailer
01:30
Preview
02 Introduction to Microsoft Excel - What you will learn
01:56
03 Excel interface overview
04:25
04 Excel ribbon - How works and how to customize
03:50
05 How use and edit Quick access toolbar
01:38
06 Excel Workbooks - Create, Open and Save files
05:18
07 Working with Worksheets - Add, delete and change name
02:44
08 Automatic data with autofill - save time using this tool
05:25
09 Rows and columns - Add and delete
04:07
10 Hide & Unhide Rows Colums and Worksheets
04:20
11 Change row and column size
03:29
12 Wrap, shrink and merge text
04:05
13 Practical exercise using Font tools
03:27
14 Format painter tool - Another powerfull tool to save time
02:46
15 Format Numbers Tool - Date and Time Format
05:00
16 Identify and Remove Duplicates Values
04:10
17 Sort and Filter Tools
14:28
18 Cell references to link data - Relative, absolute and mixed
08:09
19 Excel Formulas - How to create a formula using math operators
04:43
20 Use Functions in Excel - Syntax used to create functions
04:07
21 Add Numbers with Sum Function
02:34
22 Average Function for cells ranges average calculation
01:35
23 How to use Statistical Functions Min and Max
02:00
24 Count and CountIf Functions
05:31
25 Exercise with Logical Functions IF, OR and AND for single and multiple
07:10
26 Conditional Addition with Sumif and Sumifs
03:54
27 Extract Data using Vlookup Reference Function
06:08
28 Hlookup Function to Extract Data
02:43
Exsersice
Assignment
Video lesson
01 Trailer
Sign In
The password must have a minimum of 8 characters of numbers and letters, contain at least 1 capital letter
I want to sign up as instructor
Remember me
Sign In
Sign Up
Restore password
Send reset link
Password reset link sent
to your email
Close
Confirmation link sent
Please follow the instructions sent to your email address
Close
Your application is sent
We'll send you an email as soon as your application is approved.
Go to Profile
No account?
Sign Up
Sign In
Lost Password?
Layer 1
Hey, Please Login
Sign in
Register