Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Create Your Own Simple Customize Personal Financial Sheet
Introduction to Excel
Take a Tour Excel Panel - What is Tabs and Ribbons (0:32)
Creating Your First Excel Document
Create Your Document (0:28)
Entering Data and Navigating Around the Cells (0:43)
Save Your Document (0:44)
Close Your Document (2:32)
Open Your Document (0:24)
Customize and Dealing with Excel Functions
Download: Sample File
Download: Sample File (Lower Version)
Auto & Custom: SUM (3:08)
Auto & Custom: SUMIF (3:45)
Auto & Custom: COUNT (2:25)
COUNTIF AND COUNTIFS (2:54)
Creating Charts From Your Spreadsheet
Introduction of Charts (2:02)
Create a Bar Chart (4:41)
Create a Pie Chart (2:06)
Create a Line Chart (1:49)
Create Table & Generate Pivot Tables
Download: Sample File 2
Download: Sample File 2 (Lower Version)
Introduction to Pivot Tables - Preparing Your Data (1:25)
How to Create a Pivot Table (1:47)
Filter and Analyse based on your Pivot Table (1:46)
Show Chart Based On Pivot Table (2:42)
Create a Line Chart
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock