Course Content
Introduction
0/7
What is a Spreadsheet?
02:37
Exploring the Home Screen, New and Open
02:35
Titlebar & Quick Access Toolbar
01:53
The Ribbon
03:32
The Formula Bar
01:39
Workbooks & Worksheets
01:31
The Status Bar
02:34
Building Spreadsheets
0/23
Entering Data
02:46
Understanding Number Formats
02:35
Functions & Formulas
03:20
Assignment 1
00:33
The Average Function
01:38
The CountIF Function
01:40
The Count Function
01:21
Assignment 2
00:33
VLookup Function
02:29
Assignment 3
00:33
Date & Time Functions
03:41
Relative, Absolute & Mixed Cell References
02:24
Adding & Deleting Rows & Columns
01:16
Merging Cells
01:41
Cut, Copy, Paste & Paste Special
03:23
Freeze & Split Panes
03:14
Sorting Data
02:35
Filtering Data
01:18
Introduction to Cell Borders & Shading
02:45
Introduction to Conditional Formatting
01:50
Introduction to Excel Tables
02:01
Table Design Ribbon Tab
01:34
Summary
15:00
Saving Printing & Sharing
0/7
Introduction
00:14
Saving Workbooks
02:10
Opening Workbooks
00:54
Preparing a Worksheet for Printing
02:54
Page Margins
00:51
Print Selection
00:48
Summary
15:00
Creating Charts
0/6
Introduction
00:17
Types of Chart
00:47
Inserting a Chart
01:00
Customizing a Chart
04:03
Assignment 4
00:33
Summary
15:00
Data Validation
0/4
Introduction
00:18
Introduction to Data Validation Rules
01:15
Adding Validation Rules
02:26
Summary
10:00
Data Analysis
0/9
Introduction
00:18
Introduction to Data Analysis Tools
01:32
Goal Seek
02:21
Assignment 6
00:33
Scenario Manager
03:13
Assignment 7
00:33
Introduction to Pivot Tables
02:58
Assignment 8
00:00
Summary
10:00
Sharing & Collaboration
0/2
Introduction
01:07
Sharing a Workbook
01:54
Macros & Automation
0/3
Introduction to Macros
00:41
Recording a Macro
01:54
Executing a Recorded Macro
00:41
Summary & Next Steps
0/1
Wrap up & Summary
02:11
Microsoft Excel Fundamentals
    About Lesson

    Click next to continue

    Previous
    Next
    0% Complete
    0
      Your Cart
      Your cart is empty
      Continue Shopping