Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Microsoft Excel 2013 Beginners/Intermediate Training
Introduction
Introduction to Excel 2013 (9:12)
What's New (7:31)
Course Exercise Files
Using Touch
Overview of Principles (3:39)
Getting Started
Starting and Closing Excel; Workbook, Sheets, Cells, Rows, & Columns (11:20)
Templates; Creating, Opening, and Saving a Workbook (10:54)
Help
Online, Offline, and Contextual Help (8:00)
Settings and Preferences
Excel Options (11:22)
The Ribbon and Toolbars
Ribbon Interface (15:00)
Quick Access Toolbar (8:03)
Mini Toolbar (2:58)
Backup and Recovery
Create Backup Option; Auto-Recover and Autosave (6:54)
Entering and Deleting Data
Entering Text and Numbers (15:15)
Date Formats (15:57)
Formatting Cells; Editing and Deleting Data (15:15)
Fill (12:51)
Flash Fill (5:08)
Formatting a Worksheet
Themes and Cell Styles (14:01)
Inserting, Deleting, Hiding and Adjusting Rows and Columns (13:28)
Wrap Text and Alignment (15:02)
Merging Cells; Applying Themes and Styles (11:36)
Borders (9:25)
Copy, Paste and Paste Special
Copy, Cut and Paste (17:06)
Proofing
Spell checking (11:57)
Managing Worksheets
Moving, Copying, Inserting, Deleting and Locking Sheets; Multiple Worksheets (14:51)
Comments
Inserting Comments (6:54)
Viewing and Printing
Workbook Views, Zoom and Freeze (11:17)
Printing; Headers, Footers and Margins (12:57)
Formulas and Functions
Overview of Formulas and Functions (14:08)
Cell References (14:50)
Names (15:38)
Finding Errors; New Excel Functions (14:13)
Working with Workbooks
Multiple Workbooks and Windows; Comparing Workbooks (10:39)
Find and Replace
Go to; Find and Replace Options (11:14)
Conditional Formatting
Applying, Clearing and Managing Rules (15:35)
Graphing and Charting
Chart Types; Chart Recommendation (13:35)
Basic Formatting (14:41)
Selecting Data, Positioning and Printing Charts (15:47)
File Types
Saving Workbooks; PDF and CSV Formats (11:21)
Managing Data
Sorting (9:06)
Filtering (10:43)
Tables (12:25)
Functions Case Study
VLOOKUP (12:58)
Text Function (5:17)
Date and Time Functions (5:32)
Logical Functions (18:31)
Analyzing Data
Financial Analysis Case Study - Part 1 (16:03)
Financial Analysis Case Study - Part 2 (9:23)
Quick Analysis Tool (7:57)
Shapes and Pictures
Adding and Formatting Shapes, Picture, Clip Art, WordArt and SmartArt (14:27)
Sharing and Protecting
Protecting Worksheets (7:42)
Protecting Workbooks (10:02)
Sharing and SkyDrive (14:24)
More Backstage View Options
Trust Center; Export; Inspect Workbook (5:33)
Closing
Summary; More Help (1:49)
Downloadable course MP3 audio files
MP3 audio files
Course Transcripts
Course Quiz and Certificate of Completion
Workbook Views, Zoom and Freeze
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock