Microsoft Excel 2016 is the spreadsheet application in the MS Office 2016 suite. Get help organizing and calculating data in this Excel 2016 tutorial.
For more information about Excel and an overview of what's included in this tutorial, view this video.
This Excel 2016 tutorial includes everything you need to know to get started with Microsoft Excel.
Use OneDrive to create, store, edit, and share documents online. All you need is a Microsoft account.
Get Microsoft Office help creating blank and template MS Excel 2016 spreadsheets, opening existing ones, and converting files.
Save and share MS Excel 2016 documents to your computer or OneDrive account. In Excel save as PDF also helps for Excel spreadsheets.
In Excel cell function and references are helpful to better understand Excel spreadsheets. Use Excel cell reference functions as well.
In Excel column width can be modified, as can row height and width in Excel. Learn to modify Excel cells in this free Excel 2016 lesson.
Basic formatting in Excel can customize the look and feel of your Excel spreadsheet. Learn about formatting cells in Excel here.
In Excel number formats tell your spreadsheet what data you're using. Use custom number formatting in Excel to improve spreadsheets.
Use multiple worksheets in Excel when working with a large amount of data so it is better organized and easier to find content.
In Excel find and replace are both useful functions. Use find and replace in Excel to locate specific information in Excel 2016.
Use spell check in Excel to eliminate spelling errors. In Excel spell check is useful for keeping Excel spreadsheets professional.
In Excel page layout is useful for printing Excel spreadsheets correctly. With page layout view Excel lets you preview what you print.
When using formulas in Excel you can add, subtract, multiply, and divide. Use Excel formulas to also make cell references in Excel.
In Excel complex formulas can include several operations. Use complex formulas in Excel to calculate more extensive data.
Learn the difference between a relative absolute cell reference in Excel and an absolute cell reference in Excel in this free lesson.
When using Excel functions play an important role in finding values for a range of cells. Learn all about using functions in Excel.
In Excel data analysis can be crucial. Using data analysis Excel spreadsheets become much more functional and useful.
In Excel freeze panes to compare information, and use view options in Excel to more easily read Excel spreadsheets.
The Excel sort function is useful for rearranging data. When working in Excel sorting data can quickly reorganize content too.
Filtering in Excel lets you temporarily hide unwanted data. Use filters in Excel to narrow down data in your Excel spreadsheet.
In Excel groups and subtotals let you can hide data and summarize groups. Use groups and subtotals in Excel to better read data too.
Using tables in Excel 2016 can improve how your spreadsheet looks. Use the table function in Excel to also better organize content.
Excel charts let you illustrate your workbook data graphically to see trends. Also use charts in Excel to visualize comparisons.
Use conditional formatting in Excel to make data easier to read. Use the Excel conditional formatting function to better visualize data too.
In Excel track changes is a useful feature. Track changes in Excel and use the comments feature when proofreading workbooks.
In Excel inspect workbook feature lets you keep private data private. Also in Excel protect workbook feature keeps data safe.
Use pivot tables in Excel for stronger data analysis. This Excel pivot table tutorial also helps you summarize data.
Do more with pivot tables in Excel, like manipulating data. This Excel pivot table tutorial covers slicers, filters, and pivot charts.
In Excel what if analysis lets you answer questions with data. With what if analysis Excel also lets you experiment with data.
If you'd like to work with Office 2016 download it online or buy the software from Microsoft. Learn about buying Office 2016 here.
There are plenty of new features in Office 2016. Learn about Office 2016 features old and new here.
Change reference style in Excel spreadsheets with this free lesson. Also use the Excel reference style feature to better work with data.
These free Excel resources can help you better work with and manipulate data in Excel 2016.