Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Excel for Beginners
Introduction
Course Overview (7:39)
Introduction (1:25)
Basic Terminology
Column Row Cell (3:04)
Tab Worksheet Spreadsheet (2:22)
Click Left-Click Right-Click (2:20)
Formula Bar Scroll Bar (4:10)
Table Data Cursor (1:41)
Arrow Select (3:13)
Dropdown and Dialogue Box (2:45)
Hit Say Control Shortcuts (2:06)
Absolute Basics
Opening a New Excel File (2:45)
Opening an Existing Excel File (2:29)
Saving an Excel File (4:31)
Renaming an Excel File (3:06)
Deleting an Excel File (2:13)
Closing an Excel File (1:05)
Navigating Excel
Navigating Within and Between Worksheets (4:53)
Insert Cells (4:10)
Insert Rows and Columns (2:15)
Insert Worksheets (2:13)
Delete Cells (2:37)
Delete Rows and Columns (1:35)
Delete Worksheets (1:52)
Renaming a Worksheet (2:48)
Select All (1:30)
F2 (3:19)
Inputting Data
Basic Input and Display as Text (4:16)
Enter a Formula In a Cell (2:35)
Line Breaks In a Cell (2:03)
Undo Redo (3:21)
Auto Suggested Text (3:49)
Copy Cut Paste Basics (6:09)
Copy Cut With Formulas (5:49)
Keep Cell Reference Fixed When Copying (4:57)
Paste Special (5:06)
Delete Data (3:03)
Find and Replace (4:34)
Copying Patterns (3:54)
Freeze Panes (4:49)
Data Principles (4:34)
Formatting Data
Cell Alignment (4:52)
Bold Italics Underline (5:48)
Borders (7:41)
Fill Color (3:05)
Font Choice (1:46)
Font Size (1:55)
Font Color (1:46)
Currency (2:40)
Date (3:07)
Number (3:04)
Percentage (2:35)
Column Width (5:10)
Row Height (3:41)
Merge and Center (6:08)
Wrap Text (2:41)
Format Painter (6:33)
Mini Formatting Bar (2:14)
Manipulating Data
Sorting Explanation (5:02)
Sorting Demonstration (6:02)
Filtering Explanation (4:26)
Filtering Demonstration (4:55)
Cell Notation (5:14)
Addition (5:29)
Subtraction (4:19)
Multiplication (2:20)
Division (2:53)
Complex Formulas (3:31)
Other Functions (8:49)
Copying Formulas (7:28)
Printing
Print Overview (3:24)
Number of Copies and Printer (2:16)
What to Print and Two Sided (6:19)
Collation Portrait Landscape Paper Size (4:36)
Margins Scaling (4:35)
Page Setup Dialogue Box (4:42)
Page Layout Tab (7:00)
Other Resources
Other Resources (4:55)
Teach online with
Course Overview
Complete and Continue