Courses
Excel 2013 Intermediate

5 hour course

Excel 2013 Intermediate

4.9 out of 5 on G2

Try this course with a Free Trial

Looking to enhance your Excel? This course covers intermediate features like charts, tables, and data management.

Learn to:

Create eye-catching charts
Use absolute & relative relative references
Apply conditional formatting
Collaborate with other users

Features:

Learn by doing simulations
Skill assessments
Covers Certiport certification

Certiport certification

Skill	Pre-assess	Lesson	Post-assess	Learning mode

Excel 2013 Intermediate Outline

Skill	Pre-assess	Lesson	Post-assess	Learning mode
Charts			Verified Learning
Create Charts How to Create Charts in Excel	Not Started	Not Started	Not Started
Move and Resize How to Move and Resize a Chart in Excel	Not Started	Not Started	Not Started
Chart Types How to Change Chart Types in Excel	Not Started	Not Started	Not Started
Layout and Style How to Apply Chart Layouts and Styles in Excel	Not Started	Not Started	Not Started
Titles and Legends How to Customize Chart Titles and Legends in Excel	Not Started	Not Started	Not Started
Gridlines, Labels, and Data Tables How to Display Chart Gridlines, Labels, and Data Tables in Excel	Not Started	Not Started	Not Started
Chart Elements How to Format Chart Data in Excel	Not Started	Not Started	Not Started
Modify Chart Data How to Modify Chart Data in Excel	Not Started	Not Started	Not Started
Filter Charts How to Filter Charts in Excel	Not Started	Not Started	Not Started
Trendlines How to Add Trendlines in Excel	Not Started	Not Started	Not Started
Dual-Axis Charts How to Create Dual-Axis Charts in Excel	Not Started	Not Started	Not Started
Chart Templates How to Create Chart Templates in Excel	Not Started	Not Started	Not Started
Sparklines How to Add Sparklines in Excel	Not Started	Not Started	Not Started

Skill	Pre-assess	Lesson	Post-assess	Learning mode
Print and Distribute			Verified Learning
Page Size and Scale How to Adjust Page Size and Scale in Excel	Account Required
Print Area and Page Breaks How to Set Print Area and Page Breaks in Excel
Print Titles, Gridlines, and Headings How to Print Titles, Gridlines, and Headings in Excel
Headers and Footers How to Add Headers and Footers in Excel
Margins and Orientation How to Adjust Margins and Orientation in Excel
Inspect for Issues How to Inspect for Issues in Excel

Skill	Pre-assess	Lesson	Post-assess	Learning mode
Intermediate Formulas			Verified Learning
Reference External Worksheets How to Reference External Worksheets in Excel
Absolute and Relative References How to use Absolute and Relative Cell References in Excel
Order of Operations Order of Operations in Excel
Cell and Range Names How to Add Cell and Range Names in Excel
Insert Functions How to Insert Functions in Excel
CONCATENATE Function How to use the Concatenate Text Function in Excel
PMT Function How to Use the PMT Function in Excel
Display Formulas How to Display Formulas in Excel
Date Formulas How to Use Date Formulas in Excel

Skill	Pre-assess	Lesson	Post-assess	Learning mode
Manage Data			Verified Learning
Quick Analysis What is the quick analysis tool in Excel
Outline and Subtotal How to Use the Outline and Subtotal Features in Excel
Data Validation How to Use Data Validation Rules in Excel
Flash Fill How to Use Flash Fill in Excel
Import and Export Data How to Import and Export Excel Data

Skill	Pre-assess	Lesson	Post-assess	Learning mode
Tables			Verified Learning
Insert a Table How to Insert a Table in Excel
Sort Data How to Sort Data in Excel
Filter Data How to Filter Data in Excel
Add Rows and Columns How to Add Rows and Columns to Excel Tables
Table Styles How to Apply Table Styles in Excel
Remove Duplicates How to Remove Duplicates in Excel
Slicers How to Use Slicers in Excel
Structured References How to Use Structured References in Excel

Skill	Pre-assess	Lesson	Post-assess	Learning mode
Intermediate Formatting			Verified Learning
Apply Conditional Formatting How to Apply Conditional Formatting in Excel
Apply and Remove Cell Styles How to Apply and Remove Cell Styles in Excel
Create and Modify Cell Styles How to Create and Modify Cell Styles in Excel
Find and Replace Formatting How to Find and Replace Formatting in Excel
Apply a Theme How to Apply a Theme in Excel

Skill	Pre-assess	Lesson	Post-assess	Learning mode
Collaborate with Excel			Verified Learning
Cell Comments How to Add, Edit, and Delete Cell Comments in Excel
Share Workbooks How to Share Workbooks in Excel
Track Changes
Protect a Worksheet How to Protect a Worksheet in Excel
Protect Workbook Structure How to Protect a Workbook's Structure in Excel
Manage Workbook Versions How to Use Version History in Excel
Password Protection How to Add Password Protection in Excel