About this course:

Let’s get to know about Microsoft Excel a bit. For starters, Microsoft Excel is a spreadsheet developed by Microsoft for Windows, macOS, Android and iOS. It features calculation, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications. In this intermediate level course you will learn advanced PivotTable features and create PivotCharts. PivotTables and PivotCharts are tools you can use to analyze your raw data, summarize data to analyze it, and organize the data in a way that can be meaningfully presented to others.

The average salary for Microsoft Office Administrator is $46,000 per year.

Course Objective:

After completing this course, students will be able to:

• Prepare data for PivotTable reporting and create PivotTables from various data sources.
• Analyze Data Using PivotTables.
• Work with PivotCharts.

Audience: 

This course is intended for:

• Excel users 

Prerequisites:

• Students should have basic knowledge of excel.

Suggested prerequisites courses:

• Excel 2013 Beginner
• Excel 2016 Beginner