Autoplay
Autocomplete
Previous Lesson
Complete and Continue
The Ultimate Microsoft Excel 2013 Training Bundle
Chapter 1: Introduction
Introduction to Excel 2013 (9:12)
What's New (7:31)
Excel 2013 Beginner Course Exercise Files
Chapter 2: Using Touch
Overview of Principles (3:39)
Chapter 3: Getting Started
Starting and Closing Excel; Workbook, Sheets, Cells, Rows, & Columns (11:20)
Templates; Creating, Opening, and Saving a Workbook (10:54)
Chapter 4: Help
Online, Offline, and Contextual Help (8:00)
Chapter 5: Settings and Preferences
Excel Options (11:22)
Chapter 6: The Ribbon and Toolbars
Ribbon Interface (15:00)
Quick Access Toolbar (8:03)
Mini Toolbar (2:58)
Chapter 7: Backup and Recovery
Create Backup Option; Auto-Recover and Autosave (6:54)
Chapter 8: 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)
Chapter 9: 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)
Chapter 10: Copy, Paste and Paste Special
Copy, Cut and Paste (17:06)
Chapter 11: Proofing
Spell checking (11:57)
Chapter 12: Managing Worksheets
Moving, Copying, Inserting, Deleting and Locking Sheets; Multiple Worksheets (14:51)
Chapter 13: Comments
Inserting Comments (6:54)
Chapter 14: Viewing and Printing
Workbook Views, Zoom and Freeze (11:18)
Printing; Headers, Footers and Margins (12:57)
Chapter 15: Formulas and Functions
Overview of Formulas and Functions (14:08)
Cell References (14:50)
Names (15:38)
Finding Errors; New Excel Functions (14:13)
Chapter 16: Working with Workbooks
Multiple Workbooks and Windows; Comparing Workbooks (10:39)
Chapter 17: Find and Replace
Go to; Find and Replace Options (11:14)
Chapter 18: Conditional Formatting
Applying, Clearing and Managing Rules (15:35)
Chapter 19: Graphing and Charting
Chart Types; Chart Recommendation (13:35)
Basic Formatting (14:41)
Selecting Data, Positioning and Printing Charts (15:47)
Chapter 20: File Types
Saving Workbooks; PDF and CSV Formats (11:21)
Chapter 21: Managing Data
Sorting (9:06)
Filtering (10:43)
Tables (12:25)
Chapter 22: Functions Case Study
VLOOKUP (12:58)
Text Function (5:17)
Date and Time Functions (5:32)
Logical Functions (18:31)
Chapter 23: Analyzing Data
Financial Analysis Case Study - Part 1 (16:03)
Financial Analysis Case Study - Part 2 (9:23)
Quick Analysis Tool (7:57)
Chapter 24: Shapes and Pictures
Adding and Formatting Shapes, Picture, Clip Art, WordArt and SmartArt (14:27)
Chapter 25: Sharing and Protecting
Protecting Worksheets (7:42)
Protecting Workbooks (10:02)
Sharing and SkyDrive (14:24)
Chapter 26: More Backstage View Options
Trust Center; Export; Inspect Workbook (5:33)
Chapter 27: Closing
Summary; More Help (1:49)
Chapter 28: Course Quiz
Quiz - Learn Microsoft Excel 2013 Beginners Course
Chapter 1: Introduction
Prerequisites of Excel 2013 Advanced Course (9:55)
Excel 2013 Advanced Course Exercise Files
Chapter 2: Functions
List of Functions; Common Types of Arguments; Basic Use of Functions (13:38)
Advanced Aspects of Functions; Searching for a Function (11:00)
Autosum (6:18)
Chapter 3: Personal and Professional Financial Functions
Payment (12:48)
Future Value (11:17)
Principle Payment (12:01)
Depreciations (13:25)
Chapter 4: Date and Time Functions
How Dates and Times are Stored (11:57)
Dates and Times Calculation (12:45)
Exercise on Date and Time Functions; Date and Time Settings (7:25)
Chapter 5: Statistical Functions for Description, Prediction and Interference
Average (13:05)
Percentile (10:21)
Regression (14:02)
LINEST Function (9:49)
Example of Functions for Inferential Statistics (12:39)
Chapter 6: Text Functions
Text Function Case Study - 1 (14:26)
Text Function Case Study - 2 (10:35)
Chapter 7: Lookup Functions
Lookup and Reference Functions (15:43)
Chapter 8: Logical Functions
Logical Functions (15:59)
Chapter 9: Connecting to External Data
Connecting to Other Workbooks (16:04)
Connecting to Access Data (14:11)
Connecting to Web Data (10:18)
Chapter 10: Tables
Creating a Table and Changing Table Name; Filter; Removing Duplicates; Total Row (13:48)
Inserting Columns and Rows; Resizing Tables (15:02)
Table Reference (9:18)
Table Styles (7:07)
Table Selection (4:08)
Chapter 11: Pivot Tables
Basic Principles of Pivot Tables (14:58)
Presentational Side of Pivot Tables (15:40)
Filtering in Pivot Tables; Slices (14:06)
Chapter 12: Data Analysis
What if (15:32)
Scenario Manager (14:07)
Goal Seek (7:51)
Solver (14:38)
Chapter 13: Charts
Area Charts (10:39)
Surface Charts (7:40)
Stock Charts - Part 1 (12:27)
Stock Charts - Part 2 (12:47)
Radar Charts (5:08)
Bubble Charts (10:20)
Chapter 14: Graphs
Regression and Scatter Chart (7:00)
Chapter 15: Pivot Charts
Creating Pivot Charts (12:32)
Chapter 16: Sparklines
Using Sparklines (15:30)
Chapter 17: Web App
Creating Workbooks using a Web App (15:15)
Sharing your Workbook (10:00)
Chapter 18: Conclusion
Closing (0:19)
Chapter 19: Course Quiz
Quiz - Microsoft Excel 2013 Advanced
Bonus Materials
Excel 2013 Keyboard Shortcuts
Course Transcript for Excel 2013 Beginners Course
Course Transcripts for Excel 2013 Advanced Course
MP3 Excel 2013 Audio Files
MP3 Excel 2013 Advanced Audio Files
Presentational Side of Pivot Tables
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock