Description: Microsoft Excel 2016 makes ensuring Workbooks are accessible to all who need to use them very easy. This course covers using the accessibility checker to identify accessibility issues, altering the tab order, and making sure a workbook is modified appropriately for use in other jurisdictions. The course also covers transforming data and checking your work for errors.
Target Audience: End users at all levels, including those who have little or no familiarity with Microsoft Excel; and more experienced Excel users who want to learn about the new interface and features in Microsoft Excel 2016
Duration: 01:03
Description: Using Power Pivot in Microsoft Excel 2016, you can pull together huge amounts of data from different sources and analyze it. In this course, you will learn how to use Power Pivot, which was formerly an add-in and is now a feature of Excel 2016. This course also covers the creation of custom and conditional formatting and filters, as well as custom fills.
Target Audience: End users at all levels, including those who have little or no familiarity with Microsoft Excel; and more experienced Excel users who want to learn about the new interface and features in Microsoft Excel 2016
Duration: 01:11
Description: Microsoft Excel 2016 is a very powerful data analysis tool, but its functionality can be enhanced even further using third-party applications. This course covers how to find, install, and manage apps. It also covers What-if analysis, where Excel offers a number of ways of exploring how altering inputs can affect the outcome of calculations.
Target Audience: End users at all levels, including those who have little or no familiarity with Microsoft Excel; and more experienced Excel users who want to learn about the new interface and features in Microsoft Excel 2016
Duration: 00:47
Description:
Knowing how to bring in data and map it to your 3D Maps tours is key to getting the most out of your data. Learn how to use data from multiple tables, add layers, timestamps, and filters to better understand your tours, and how to customize the information on display.
Target Audience:
Duration: 00:54
Description:
3D Maps for Excel 2016 is a 3D data visualization tool that's great for geographically or spatially mapping your data. Find out how to open the 3D Maps tool, and how to start building visual tours to explore and analyze your data.
Target Audience:
Duration: 00:41
Description: You can create advanced PivotTables and analyze data from a variety of different sources using the Power Pivot add-in for Excel 2016. Learn how to use Power Pivot to import databases, create and modify tables, and create a dashboard.
Target Audience:
Duration: 00:59
Description:
You can use the Power View add-in to create reports in Excel 2016. Discover the capabilities of Power View, including illustrating and organizing reports, filtering data, and adding PivotTables and charts to reports.
Target Audience:
Duration: 01:07