Excel 2013, Beginner - Course Overview
Course Overview
Lesson One - Getting Started with Excel 2013
Getting Started with Excel 2013 - Lesson Introduction
Identify the Elements of the Application Window
Identify the Elements of the Workbook Window
Create a Basic Worksheet
Use the Help System
Getting Started with Excel 2013 - Summary
Getting Started with Excel 2013 - Quiz
Lesson Two - Performing Calculations
Performing Calculations - Lesson Introduction
Create Formulas in a Worksheet
Insert SUM and AVERAGE Functions in a Worksheet
Insert MIN and MAX Functions in a Worksheet
Cut and Paste Commands
Absolute Cell References
Performing Calculations - Summary
Performing Calculations - Quiz
Lesson Three - Modifying a Worksheet
Modifying a Worksheet - Lesson Introduction
The Auto Fill Feature
The Undo and Redo Commands
Column Width and Row Height Alteration Methods
The Hide and Unhide Options
The Insert and Delete Options
Cell Names and Range Names
The Find and Replace Commands
Spell Check a Worksheet
Modifying a Worksheet - Summary
Modifying a Worksheet - Quiz
Lesson Four - Formatting a Worksheet
Formatting a Worksheet - Lesson Introduction
Modify Fonts
Add Borders and Color to Cells
Apply Number Formats
Align Cell Contents
Apply Cell Styles
Formatting a Worksheet - Summary
Formatting a Worksheet - Quiz
Lesson Five - Printing Workbook Contents
Printing Workbook Contents - Lesson Introduction
Define the Basic Page Layout for a Workbook
Refine the Page Layout and Apply Print Options
Printing Workbook Contents - Summary
Printing Workbook Contents - Quiz
Lesson Six - Managing Large Workbooks
Managing Large Workbooks - Lesson Introduction
Format Worksheet Tabs
Manage Worksheets
Manage the View of Worksheets and Workbooks
Managing Large Workbooks - Summary
Managing Large Workbooks - Quiz
Lesson Seven - Customizing the Excel Environment
Customizing the Excel Environment - Lesson Introduction
Customize General and Language Options
Customize Formula Options
Customize Proofing and Save Options
Customize the Quick Access Toolbar
Customize the Ribbon
Customize the Functionality of Excel by Enabling Add-Ins
Customize Advanced Options
Customize Trust Center Options
Customizing the Excel Environment - Summary
Customizing the Excel Environment - Quiz
Excel 2013, Beginner - Course Follow-Up
Course Follow-Up
Excel 2013, Intermediate - Course Overview
Course Overview
Lesson One - Creating Advanced Formulas
Creating Advanced Formulas - Lesson Introduction
Add Range Names
Edit and Delete Range Names
Use Range Names in a Formula
Use Specialized Functions
Use the SUM Function
Use the AVERAGE Function
Use the MIN Function
Use the MAX Function
Use COUNT, COUNTA and COUNTIF Functions
Use the ROUND Function
Use the AND Function
Use the CONCATENATE Function
Use HLOOKUP and VLOOKUP Functions
Creating Advanced Formulas - Summary
Creating Advanced Formulas - Quiz
Lesson Two - Analyzing Data with Logical Functions
Analyzing Data with Logical Functions - Lesson Introduction
Work with Logical Functions
Use the Nested IF Function
Analyzing Data with Logical Functions - Summary
Analyzing Data with Logical Functions - Quiz
Lesson Three - Organizing Worksheet Data with Tables
Organizing Worksheet Data with Tables - Lesson Introduction
Create and Modify Tables
Sort Data
Filter Data with the Auto Filter
Filter Data with the Advanced Filter
Remove Duplicates
Total Row
Organizing Worksheet Data with Tables - Summary
Organizing Worksheet Data with Tables - Quiz
Lesson Four - Visualizing Data with Charts
Visualizing Data with Charts - Lesson Introduction
Create Charts
Change the Default Chart Type
Modify Charts
Edit Axes
Format Charts
Create a Trendline
Create Advanced Charts
Visualizing Data with Charts - Summary
Visualizing Data with Charts - Quiz
Lesson Five - Analyzing Data with PivotTables, Slicers, and PivotCharts
Analyzing Data with PivotTables, Slicers, and PivotCharts - Lesson Introduction
Create a PivotTable
Advanced Field Settings
Filter Data by Using Slicers
Analyze Data by Using PivotCharts
Analyzing Data with PivotTables, Slicers, and PivotCharts - Summary
Analyzing Data with PivotTables, Slicers, and PivotCharts - Quiz
Lesson Six - Inserting Graphics
Inserting Graphics - Lesson Introduction
Insert and Modify Graphic Objects
Insert and Group Shapes
Incorporate SmartArt
Inserting Graphics - Summary
Inserting Graphics - Quiz
Lesson Seven - Enhancing Workbooks
Enhancing Workbooks - Lesson Introduction
Comments
Hyperlinks
Watermarks
Manage Themes
Create and Use Templates
Protect Files
Enhancing Workbooks - Summary
Enhancing Workbooks - Quiz
Excel 2013, Intermediate - Course Follow-Up
Course Follow-Up
Excel 2013, Advanced - Course Overview
Course Overview
Lesson One - Automating Worksheet Functionality
Automating Worksheet Functionality - Lesson Introduction
Update Workbook Properties
Apply Conditional Formatting
Edit a Conditional Formatting Rule
Add Data Validation Criteria
Automating Worksheet Functionality - Summary
Automating Worksheet Functionality - Quiz
Lesson Two - Auditing Worksheets
Auditing Worksheets - Lesson Introduction
Trace Cells
Troubleshoot Invalid Data
Troubleshoot Invalid Formulas
Evaluate Formulas
Watch Formulas
Create a Data List Outline
Add Subtotals to Grouped Data
Auditing Worksheets - Summary
Auditing Worksheets - Quiz
Lesson Three - Analyzing and Presenting Data
Analyzing and Presenting Data - Lesson Introduction
Create Sparklines
Create Scenarios
Perform a What-If Analysis
Analyzing and Presenting Data - Summary
Analyzing and Presenting Data - Quiz
Lesson Four - Working with Multiple Workbooks
Working with Multiple Workbooks - Lesson Introduction
Consolidate Data
Link Cells in Different Workbooks
Merge Workbooks
Working with Multiple Workbooks - Summary
Working with Multiple Workbooks - Quiz
Lesson Five - Exporting Excel Data
Exporting Excel Data - Lesson Introduction
Export Excel Data
Import a Delimited Text File
Integrate Excel Data with the Web
Create a Web Query
Exporting Excel Data - Summary
Exporting Excel Data - Quiz
Excel 2013, Advanced - Course Closing
Course Closing