Excel 2016
- 1
- Getting Started with Excel
Learn your way around the Excel 2016 environment. more..
- 2
- Understanding OneDrive
Learn all about working with your Microsoft account and OneDrive.more..
- 3
- Creating and Opening Workbooks
Learn how to create and open Excel workbooks. more..
- 4
- Saving and Sharing Workbooks
Learn how to save and share Excel workbooks. more..
- 5
- Cell Basics
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. more..
- 6
- Modifying Columns, Rows, and Cells
Learn how to modify rows, columns, and cells in Excel. more..
- 7
- Formatting Cells
Learn all about formatting text in Excel. more..
- 8
- Understanding Number Formats
Learn all about formatting numbers in Excel.more..
- 9
- Working with Multiple Worksheets
Learn how to add, delete, copy, and move worksheets, as well as group and ungroup worksheets.more..
- 10
- Using Find & Replace
Learn how to use Excel's Find and Replace features to search for specific data. more..
- 11
- Checking Spelling
Learn how to use Excel's spell check feature.more..
- 12
- Page Layout and Printing
Learn how to use Excel commands that let you control the way your content will appear on a printed page.more..
- 13
- Intro to Formulas
Learn how to use cell references to create a simple formula in Excel. more..
- 14
- Creating More Complex Formulas
Learn how to create a complex formula in Excel. more..
- 15
- Relative and Absolute Cell References
Learn all about absolute and relative cell references and how they're used in Excel.more..
- 16
- Functions
Learn the different parts of a function and how to create arguments to calculate values and cell references. more..
- 17
- Basic Tips for Working with Data
Learn these basic tips for working with data to help you organize it and find what you need. more..
- 18
- Freezing Panes and View Options
Learn how to freeze panes and split your worksheet so you're only seeing certain parts of your worksheet. more..
- 19
- Sorting Data
Learn how to sort data to better view and organize the contents of your spreadsheet. more..
- 20
- Filtering Data
Learn how to filter the data in your worksheet to display only the information you need. more..
- 21
- Groups and Subtotals
Learn how to organize data in groups, summarize different groups using the Subtotal command, and create an outline for your worksheet. more..
- 22
- Tables
Learn how to use styles to format tables in Excel. more..
- 23
- Charts
Learn how to insert and modify Excel charts to visualize comparisons in your data. more..
- 24
- Conditional Formatting Graphics
Learn how to apply, modify, and delete conditional formatting rules in Excel.more..