close
search
search
menu
Topics
close
I want to...
Get started with computers
Learn Microsoft Office
Apply for a job
Improve my work skills
Design nice-looking docs
More...
Microsoft
Office 2019
|
2016
|
2013
Word
Excel
PowerPoint
Access
Excel Formulas
More...
Basic Skills
Computers
Smartphones & Tablets
Typing Tutorial
Windows
More...
Internet Skills
Internet
Online Safety
Social Media
Email
Search Better
More...
Google
Gmail
Google Docs
Google Sheets
More...
Work & Career
Career Planning
Resume Writing
Cover Letters
Job Search and Networking
Business Communication
More...
Skills for Today
Adapting to Change
3D Printing
Wearables
Freelance Work
Personal Finance
Sharing Economy
Decision-Making
More...
Creativity & Design
Graphic Design
Creativity
Photography
Image Editing
Photoshop
More...
Core Skills
Math
Reading
Grammar
Language Learning
More...
For Educators
Translations
Staff Picks
All Topics
English
expand_more
expand_less
English
expand_more
expand_less
Español
Português
search
person_outline
arrow_drop_down
menu
All Topics
My Account
About Us
FAQ
Contact Us
EN
ES
PT
Signin
Signup
Dashboard
Profile
Logout
search
560d890a369ca18833b60c20
Excel 2016 Basics
1
Getting Started with Excel
arrow_forward_ios
✓
Learn your way around the Excel 2016 environment.
2
Understanding OneDrive
arrow_forward_ios
✓
Learn all about working with your Microsoft account and OneDrive.
3
Creating and Opening Workbooks
arrow_forward_ios
✓
Learn how to create and open Excel workbooks.
4
Saving and Sharing Workbooks
arrow_forward_ios
✓
Learn how to save and share Excel workbooks.
Working with Cells and Sheets
5
Cell Basics
arrow_forward_ios
✓
Learn how to insert and delete cells and cell content, drag and drop cells, use the fill handle, and use the cut, copy, and paste functions.
6
Modifying Columns, Rows, and Cells
arrow_forward_ios
✓
Learn how to modify rows, columns, and cells in Excel.
7
Formatting Cells
arrow_forward_ios
✓
Learn all about formatting text in Excel.
8
Understanding Number Formats
arrow_forward_ios
✓
Learn all about formatting numbers in Excel.
9
Working with Multiple Worksheets
arrow_forward_ios
✓
Learn how to add, delete, copy, and move worksheets, as well as group and ungroup worksheets.
10
Using Find & Replace
arrow_forward_ios
✓
Learn how to use Excel's Find and Replace features to search for specific data.
11
Checking Spelling
arrow_forward_ios
✓
Learn how to use Excel's spell check feature.
12
Page Layout and Printing
arrow_forward_ios
✓
Learn how to use Excel commands that let you control the way your content will appear on a printed page.
Formulas and Functions
13
Intro to Formulas
arrow_forward_ios
✓
Learn how to use cell references to create a simple formula in Excel.
14
Creating More Complex Formulas
arrow_forward_ios
✓
Learn how to create a complex formula in Excel.
15
Relative and Absolute Cell References
arrow_forward_ios
✓
Learn all about absolute and relative cell references and how they're used in Excel.
16
Functions
arrow_forward_ios
✓
Learn the different parts of a function and how to create arguments to calculate values and cell references.
Working with Data
17
Basic Tips for Working with Data
arrow_forward_ios
✓
Learn these basic tips for working with data to help you organize it and find what you need.
18
Freezing Panes and View Options
arrow_forward_ios
✓
Learn how to freeze panes and split your worksheet so you're only seeing certain parts of your worksheet.
19
Sorting Data
arrow_forward_ios
✓
Learn how to sort data to better view and organize the contents of your spreadsheet.
20
Filtering Data
arrow_forward_ios
✓
Learn how to filter the data in your worksheet to display only the information you need.
21
Groups and Subtotals
arrow_forward_ios
✓
Learn how to organize data in groups, summarize different groups using the Subtotal command, and create an outline for your worksheet.
22
Tables
arrow_forward_ios
✓
Learn how to use styles to format tables in Excel.
23
Charts
arrow_forward_ios
✓
Learn how to insert and modify Excel charts to visualize comparisons in your data.
24
Conditional Formatting
arrow_forward_ios
✓
Learn how to apply, modify, and delete conditional formatting rules in Excel.
Doing More with Excel
25
Track Changes and Comments
arrow_forward_ios
✓
Learn how to use Excel's track changes and comments features when proofreading workbooks.
26
Inspecting and Protecting Workbooks
arrow_forward_ios
✓
Learn how to inspect and protect your Excel workbook.
27
Intro to PivotTables
arrow_forward_ios
✓
Learn how to use PivotTables in Excel for stronger data analysis.
28
Doing More with PivotTables
arrow_forward_ios
✓
Learn how to do more with PivotTables in Excel to better summarize data.
29
What-if Analysis
arrow_forward_ios
✓
Learn how to use what-if analysis to answer different types of questions.
Extras
30
Buying Office 2016
arrow_forward_ios
✓
If you're considering purchasing Office 2016, learn about some important changes you should know about.
31
New Features in Office 2016
arrow_forward_ios
✓
Discover some of the new features in Office 2016.
32
What are Reference Styles?
arrow_forward_ios
✓
Learn all about using reference styles in Excel.
33
More Resources
arrow_forward_ios
✓
These free resources can help you better work with and manipulate data in Excel.
Quiz
34
Excel Quiz
arrow_forward_ios
✓
Test your knowledge of Excel by taking our quiz.