Wouldn't it be great to learn how to effectively use all the advanced Excel pivot table features? In this practical and information-packed course, you will learn how to maximize this program's functions and capabilities. Most organizations rely heavily on Microsoft Excel pivot tables to analyze and report financial information. Your company is probably no exception. By learning these advanced techniques, you can become more valuable to your organization. This course will teach you how to utilize the numerous pivot tables to develop useful analysis models and reports within your company. Impress your coworkers by learning how to create functional and eye-catching interactive dashboards using a combination of pivot tables, Pivot Charts, and Slicers. You will discover advanced techniques for pivot tables, like creating Timelines, calculated fields, and calculated items. You will learn how to use Excel's Table function to efficiently manage changes to the pivot table's source data in order to avoid making mistakes when data is added or deleted.
Completion Time
24 hours
Access Time
42 Days
Outcome
Individual Skill Course
Language
English
Training Level
Beginner
Delivery Information:
Online
Asynchronous
Self-paced
Description
Learning Outcomes
What you will learn:
- Learn how to work with the numerous pivot table options and system settings
- Become skilled in developing useful analysis models and reports
- Learn how to create functional and eye- catching interactive dashboards using a combination of pivot tables, Pivot Charts, and Slicers
- Discover advanced techniques for pivot tables, like creating Timelines, calculated fields, and calculated items
- Learn how to efficiently manage changes to the pivot table's source data in order to avoid making mistakes when data is added or deleted
- Learn advanced techniques and become more valuable to your organization
- Become more confident in your ability to report accurate data efficiently using Microsoft Excel
- Open the door to new career opportunities in data analysis and reporting
Requirements
Technology Requirements
Hardware Requirements: This course can be taken on either a PC, Mac, or Chromebook.
Software Requirements: Software must be installed and fully operational before the course begins.
- PC: Windows 8 or later.
- Mac: macOS 10.6 or later.
- Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge and Safari are also compatible. Cookies and JavaScript must be enabled
- The latest Adobe Reader/Acrobat Reader ( free download available at https://get.adobe.com/reader/ )
- Any modern Office suite: Microsoft Office, Apple iWork, OpenOffice, or LibreOffice
- Reliable internet connection. Broadband cable or highspeed DSL is recommended for optimal experience.
- E-mail account (to be able to register and to receive e-mail from the course system regarding registration, course status, etc.)
Enroll My Team
Are you looking to enroll your team in this training Course? You Can: