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