Excel 2016

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.