Autoplay
Autocomplete
HTML5
Flash
Player
Speed
Previous Lecture
Complete and continue
Useful Excel for Beginners
Introduction
Introduction to Course (7:11)
Download All Exercise Files
Basics of Excel
Launching Excel (3:36)
Workbooks and Worksheets (2:46)
Fundamentals (5:03)
Entering Data
How to Enter Data (4:17)
AutoFit (7:07)
Keyboard Navigation (5:07)
Auto Complete (4:49)
Entering Numbers (3:32)
Navigating Edges (9:18)
Navigating First & Last Used Cell (2:27)
Selecting Cells - Introduction (2:03)
Selecting Cells - Shift + Arrow (8:38)
Selecting Cells - Ctrl + Shift + Arrow (8:59)
Selecting Cells - Mouse Click Drag (3:44)
Selecting Cells - Mouse Click Shift+Click (3:21)
Selecting Cells - All Cells and Used Cells (3:09)
Selecting Cells - Rows, Columns and All (3:16)
Selecting Cells - NonContiguous Cells (4:41)
Selecting Cells - Summary (10:02)
Number Formatting - Introduction (6:23)
Number Formatting - General - Text (8:40)
Number Formatting - Number - Fraction (15:54)
Number Formatting - Currency (5:21)
Number Formatting - Accounting (1:50)
Number Formatting - Percentage (5:45)
Number Formatting - Date (12:05)
Number Formatting - Time (10:51)
Number Formatting - Summary (2:22)
Inserting & Deleting Rows, Columns and Cells (11:37)
Formatting
Formatting - Introduction (5:08)
Formatting - Bold, Italics and Underline (5:05)
Formatting - Borders (8:58)
Formatting - Fill and Font (5:27)
Formatting - Alignment (9:09)
Formatting - Format Painter - Clear Formats (3:17)
Editing
Editing - Editing Cell Content (7:44)
Editing - Multiple Lines of Text (3:32)
Editing - Same Data In Multiple Cells - Ctrl+Enter (2:51)
Editing - Same Data In Multiple Cells - Auto Fill (5:39)
Editing - Same Data In Multiple Cells - Copy Paste (7:13)
Editing - Cut Paste (7:32)
Editing - Auto Fill Series (6:59)
Editing - Sort (12:18)
Editing - Filter (6:14)
Editing - Find and Replace (10:45)
Saving
Saving Excel Documents (9:58)
Viewing
Viewing - Freeze Panes (6:47)
Calculations
Calculations - Introduction to Formula (7:42)
Calculations - Editing Formula (2:03)
Calculations - Introduction to Functions (8:23)
Calculations - Entering Functions (8:51)
Calculations - Types of Functions (3:00)
Calculations - MIN MAX AVERAGE (5:00)
Calculations - Copying Formulas (7:34)
Calculations - Cell References (9:40)
Calculations - Paste Formulas (2:26)
Calculations - Counting (8:25)
Calculations - Looking Up (13:29)
Calculations - Date Functions (4:53)
Calculations - Text Functions (15:26)
Calculations - SUMIF Function (11:08)
Calculations - IF Function (4:37)
Calculations - Errors (11:33)
Calculations - Summary (1:52)
Visualizing
Charts - Introduction to Charts (2:33)
Charts - Creating a Chart (8:58)
Chart Components - Chart Labels (10:33)
Chart Components - Chart Background (1:27)
Chart Components - Chart Axes (7:49)
Chart Components - Format Design (2:20)
Chart Types (10:47)
Conditional Formatting - Introduction (1:51)
Conditional Formatting - Format All Cells (8:35)
Conditional Formatting - Format Only Cells (5:44)
Conditional Formatting - More Rule Types (6:52)
Conditional Formatting - Formula Based (5:33)
Conditional Formatting - Summary (3:03)
Visualizing - Illustrations (4:51)
Analyzing
Analyzing - Intro to Pivot Tables (2:07)
Analyzing - Creating a Pivot Table (7:45)
Analyzing - Pivot Table Summarization Types (5:44)
Analyzing - Pivot Table Tools (10:44)
Analyzing - Pivot Table Pivot Charts (4:55)
Excel Tables
Creating an Excel Table (6:39)
Tables - Functionality (9:51)
Sharing
Save & Send (1:47)
Printing (10:37)
Final Thoughts
Final Thoughts (2:35)
Chart Types
Lecture content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock