Courses
Excel 2016 Basic

4 hour course

Excel 2016 Basic

4.9 out of 5 on G2

Try this course with a Free Trial

New to Excel? This course gives you a solid foundation in Excel and spreadsheet basics.

Learn to:

Build & edit spreadsheets
Calculate with formulas
Add eye-catching formatting
Organize and manage workbooks

Features:

Learn by doing simulations
Skill assessments
Covers Certiport certification

Certiport certification

Skill	Pre-assess	Lesson	Post-assess	Learning mode

Excel 2016 Basic Outline

Skill	Pre-assess	Lesson	Post-assess	Learning mode
Getting Started			Verified Learning
Understand the Excel Screen Understand the Excel Screen	Not Started	Not Started	Not Started
Create Workbooks How to create blank & template-based workbooks in Excel	Not Started	Not Started	Not Started
Navigate Worksheets How to Navigate Worksheets in Excel	Not Started	Not Started	Not Started
Open Workbooks How to Open Workbooks in Excel	Not Started	Not Started	Not Started
Save Workbooks How to Save Workbooks in Excel	Not Started	Not Started	Not Started
AutoRecover How to AutoRecover Excel Files	Not Started	Not Started	Not Started
The Quick Access Toolbar How to Use The Quick Access Toolbar in Excel	Not Started	Not Started	Not Started
Print How to Print in Excel	Not Started	Not Started	Not Started
Share a Workbook How to Share Workbooks in Excel	Not Started	Not Started	Not Started
Help How to Get Help in Excel	Not Started	Not Started	Not Started
Close and Exit How to Close and Exit from Excel	Not Started	Not Started	Not Started

Skill	Pre-assess	Lesson	Post-assess	Learning mode
Edit a Workbook			Verified Learning
Select Cells and Ranges How to Select Cells and Ranges in Excel	Account Required
Edit Cell Data How to Edit Cell Data in Excel
Cut, Copy, and Paste How to Cut, Copy, and Paste in Excel
Undo, Redo, Repeat How to Use Undo, Redo, Repeat Commands in Excel
More Pasting Options How to Use Special Paste Options in Excel
Insert and Move Cells How to Insert and Move Cells in Excel
Delete Cells How to Delete Cells in Excel
Check Spelling How to Spell Check in Excel & avoid errors
Find and Replace Text How to Use Find and Replace in Excel
Hide Columns and Rows How to Hide Columns and Rows in Excel
Document Properties How to View and Edit Document Properties in Excel

Skill	Pre-assess	Lesson	Post-assess	Learning mode
Basic Formulas			Verified Learning
Formula Basics How to Create Basic Formulas in Excel
AutoFill How to Use AutoFill in Excel
Sums and Averages How to Use Sum and Average Formulas in Excel
MIN and MAX How to Use MIN and MAX Functions in Microsoft Excel
COUNT How to Use the COUNT Function in Excel

Skill	Pre-assess	Lesson	Post-assess	Learning mode
Basic Formatting			Verified Learning
Format Text How to Apply Formatting to Text in Excel
Align and Merge Cells How to align and merge cells in Excel
Format Numbers and Dates How to Format Numbers and Dates in Excel
Borders and Background Colors How to Add Cell Borders and Background Colors in Excel
Copy Formatting How to Copy Formatting in Excel
Row Heights and Column Widths How to Adjust Row Heights and Column Widths in Excel

Skill	Pre-assess	Lesson	Post-assess	Learning mode
Insert Objects			Verified Learning
Images How to Insert Images in Excel
Shapes How to Insert and Format Shapes in Excel
Hyperlinks How to Insert Hyperlinks in Excel
Object Properties and Alt Text How to Adjust Object Properties and Alt Text in Excel

Skill	Pre-assess	Lesson	Post-assess	Learning mode
View and Manage Worksheets			Verified Learning
View Worksheets How to Change Worksheet Views in Excel
Multiple Windows How to Work with Multiple Windows in Excel
Move and Copy Worksheets How to Move and Copy Worksheets in Excel
Insert, Rename, and Delete Worksheets How to Insert, Rename, and Delete Worksheets in Excel
Freeze Rows and Columns How to Freeze and Unfreeze Rows and Columns in Excel
Hide Worksheets and Gridlines How to Hide Worksheets and Gridlines in Excel