OS-MSO-301 Advanced Microsoft Excel

Overview

After learning how to use Excel, you can explore advanced features to help you improve the functionality of your spreadsheets. This course teaches you about several useful and popular Excel functions.

By the end of this course, you will be able to

• Use the VLOOKUP function to look up information in a vertical data table
• Use the HLOOKUP function to look up information in a horizontal data table
• Use the XLOOKUP function to look up information in a data table that is either vertical or horizontal
• Create PivotTables based on data in a spreadsheet
• Use PivotTable commands to filter, sort, or group data
• Change the style and layout of a PivotTable

Estimated completion time (hours): 5.0