Watch Microsoft Excel 2016 - Training

Microsoft Excel 2016 can help you organize, calculate, analyze, revise, update, and present your data in ways that will help you or other decision makers in your organization steer you in the right direction. This course aims to provide you with a foundation for Excel knowledge and skills, which you can build upon to eventually become an expert in Excel 2016.

SONIC Performance Support
4 Seasons, 20 Episodes
December 31, 2016
Ad
i
Watch Episodes

Microsoft Excel 2016 - Training Full Episode Guide

  • Yet as powerful as PivotTables are, by presenting PivotTable data graphically through PivotCharts, you can help users tell at a glance what the data is showing.

  • Learn how to filter your PivotTable, group certain data together, alter its formatting, or analyze data from multiple sources. Now that you've created a basic PivotTable, you're ready to dive deeper into your data analysis.

  • PivotTables provide powerful ways to interact with data through easy-to-read formats and the ability to summarize large amounts of data quickly. This enables you to more easily analyze a large dataset and arrive at solid business decisions.

  • Excel 2016 contains a robust variety of functionality that is designed to help with forecasting data. Becoming familiar with how these different features work and what they can do to help you analyze your data will open whole new worlds of possibilities in terms of data analysis.

  • Display data combined with a map can make data with geographical information more useful than just a table. Sparklines display data in a cell. Learn when a Sparkline should be choosen over a Chart. Excel 2016 now has a built-in feature that allows showing the relationship of that data geographically over time - 3D Maps.

  • Microsoft Office Excel 2016 includes a variety of features that ensures that only the correct data or type of data can be entered into your worksheets, to performing repetitive tasks so you don't have to, Excel's automation features can save you valuable time and keep your data intact.

  • Microsoft Excel 2016 includes a number of features and capabilities that enable you to navigate the fine balance between collaboration and security. Understanding how these features and capabilities work and how they work together will help you balance these concerns, keep your important work on track, and provide you with the peace of mind that comes with knowing your information is secure.

  • With Lookup functions you'll begin to develop the ability to create incredibly complex functions and formulas that can perform any number of calculations. Learn also to audit your workbook content to find, troubleshoot, and correct a number of different errors.

  • In many cases, you are collecting or tracking data in one or more worksheets in a workbook. While you know how to summarize the data on one worksheet, you may wish to combine the data into a report from these individual worksheets or even from other workbooks. Excel has several features that allow you to aggregate the data to generate those reports.

Watch Microsoft Excel 2016 - Training Online - Watch online anytime: Buy, Rent

Microsoft Excel 2016 - Training is available to watch and stream on SONIC Performance Support. You can also buy, rent Microsoft Excel 2016 - Training on demand at Amazon Prime, Amazon online.