Microsoft Office 2016: Excel Part 2 (Intermediate)

Course Overview

Excel 2016 is one of the most used office programs. However, users without training support usually only use 10% of the functionality of Excel 2016. In this advanced course, you will learn how to organize, analyze, and visualize your data and calculations. We'll also show you how to apply formulas to solve tasks.

Target Audience

This course is designed for those, who already have foundational knowledge and skills in Excel 2016 and who wish to begin taking advantage of some of the higher-level functionality in Excel to analyze and present data.

Learning Objectives

Upon successful completion of this course, you will be able to leverage the power of data analysis and presentation in order to make informed, intelligent organizational decisions. You will learn how to :

• Work with functions
• Work with lists
• Analyze data
• Visualize data with charts
• Use PivotTables and PivotCharts

Business Outcomes

Increase your office productivity