Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Learn Microsoft Excel 2010 for Beginners
Introduction to Excel
Introduction and Overview of Excel 2010 Course (0:56)
Overview of the Excel Window (11:52)
Working with the Mouse (4:05)
Excel Options (2:44)
Creating a New Workbook
Entering Text and Numbers (5:39)
Creating Basic Formulas (6:55)
Relative References (1:54)
Order of Operations (4:33)
Working with Ranges (5:03)
Saving Workbooks
Working with Save and Save As Commands (5:22)
File Extensions (3:48)
Navigating Workbooks
Opening a File (4:36)
Working with Larger Files (6:26)
Freeze Panes Options (2:19)
Split Screen Option (3:43)
Printing
Page Setup Options (5:11)
Headers and Footers (7:37)
Print Titles (2:29)
Comments (4:22)
Fit to print on one page (5:11)
Printing Workbooks (2:21)
Working with Rows, Columns, and Cells
Adding and Deleting Rows, Columns, and Cells (5:41)
Changing Column and Row Widths (4:39)
Moving Data
Cut, Copy and Paste (6:21)
Copying Formulas (4:13)
Formulas and Functions
Overview of Formulas (3:00)
Create Formulas using Functions - Part 1 (10:21)
Create Formulas using Functions - Part 2 (6:54)
Absolute Values (5:44)
Working with Worksheets
Adding, Deleting and Renaming Sheets (6:25)
Additional Sheet Tab Options (5:09)
3-D Formulas (7:13)
Formatting Worksheets
Cell Formatting (12:16)
Number Formatting (10:00)
Borders and Shading (9:32)
Format as Table (6:56)
Using Styles (9:14)
Using Format Painter (4:40)
Protecting Sheets (11:27)
Fill Handle and Custom Lists (7:11)
Charts
Creating Charts (11:12)
Types of Charts (4:27)
Editing Charts (10:20)
Using Graphics to Enhance Charts (5:41)
Working with Names
Creating Range Names (10:21)
Managing Names (2:36)
Using Names in Formulas (5:29)
Sorting and Filtering
Removing Duplicates (8:56)
Sort Data (11:11)
Filter Data (11:31)
Advanced Filters (3:59)
Outlining and Subtotaling
Creating an Outline - Part 1 (8:11)
Creating an Outline - Part 2 (5:09)
Subtotals (9:41)
Working with Views
New Window Option (3:08)
Arrange File Options (2:40)
Creating a Workspace (4:16)
Custom Views (6:10)
Scenarios (6:32)
Linking Files
Creating Formulas between Files (7:58)
Working with Links (4:36)
Advanced Formula Creation
IF Statement (9:23)
VLookups (7:05)
Consolidating Data (4:39)
Data Validation (9:39)
Formula Auditing (4:01)
Additional Excel Features
Comments (6:08)
Goal Seeker (2:05)
Text to Columns Option (2:28)
Watch Window (2:58)
Conclusion
Closing Video (0:28)
Course Quiz and Certificate of Completion
Entering Text and Numbers
Complete and Continue