Microsoft® Excel 2016 Advanced Quick Reference Guide PivotTable Elements PivotTables Create a PivotTable: Select the data range to be used by the PivotTable. Click the Insert tab on the ribbon and click the PivotTable button in the Tables group. Verify the range and then click OK. Add Multiple PivotTable Fields: the field areas in the task pane.

• Microsoft Excel 2016 is the spreadsheet application in the MS Office 2016 suite. Get help organizing and calculating data in this Excel 2016 tutorial.
• Excel for insightful spreadsheets – anytime, anywhere and with anyone. A modern take on Excel with new built-in tools help you get more out of your data. Create your best work with Microsoft 365.

77-728: Excel 2016 Expert: Interpreting Data for Insights

Languages: English, Chinese (Simplified), Chinese (Traditional), German, Spanish, French, Japanese, Korean, Dutch

Retirement date: none

Expert-level candidates for the Excel 2016 exam have an advanced understanding of the Excel environment and have the ability to guide others to the proper use of the program’s features.

Price based on the country in which the exam is proctored.

for Excel 2016 Expert: Interpreting Data for Insights

All objectives of the exam are covered in depth so you'll be ready for any question on the exam.

Congratulations, you have completed the Excel 2016 tutorial.

Tutorial Summary

Excel 2016 is a version of Excel developed by Microsoft that runs on the Windows platform. This Excel 2016 tutorial covered the basic concepts of spreadsheets such as:

• Cells
• Rows
• Columns

And then expanded on the more advanced Excel topics such as:

• Sheets
• Hyperlinks
• Ranges

Each version of Excel can 'look and feel' completely different from another. As such, we recommend that you try one of our other Excel tutorials to become familiar with the Excel version that you will be using.

Other Excel Tutorials

Now that you know the basics of Excel 2016, learn more.

Try one of our other Excel tutorials:

Microsoft Excel 2016 Apk

Microsoft Excel 2016 365

Microsoft Excel 2016 Tutorial For Beginners

There is still more to learn!