Microsoft Excel - Pivot Tables
Maximize your investment in Microsoft Excel by mastering its pivot table features. In this practical hands-on course, you will discover how to use different layout, subtotaling, and filtering options and discover a variety of advanced techniques for pivot tables, including Pivot Charts, Timelines, and Slicers. You will also master data analysis by learning how to quickly and easily summarize your data.
Microsoft Excel - Pivot Tables
Details + Objectives
Course code: pts
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.
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
How you will benefit
- 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
How the course is taught
- Instructor-Moderated or Self-Guided online course
- 6 Weeks or 3 Months access
- 24 course hours
Instructors & Support
Chad Wambolt
Chad Wambolt has spent his entire professional career in the finance field, working for both private and publicly-held companies with sales ranging from $500 million to $3 billion. He is a graduate of Boise State University, where he obtained his bachelor's degree in accounting. Through the course of his career, Wambolt became an expert user of Microsoft Excel. Since 1997, he has taught Excel to students of varying skill levels and helped organizations streamline internal processes.
Instructor Interaction: The instructor looks forward to interacting with learners in the online moderated discussion area to share their expertise and answer any questions you may have on the course content.
Requirements
Prerequisites:
There are no prerequisites to take this course.
Requirements:
Hardware Requirements:
- This course can be taken on either a PC or Mac.
Software Requirements:
- 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.
- Microsoft Excel 2016, Microsoft Excel 2019, Microsoft Excel 2021, or Microsoft Office 365 (not included in enrollment).
- The "Starter", "Web App", and "Office Mac Home" versions of Microsoft Excel will not work with the full version of Excel taught in this course.
- Adobe Acrobat Reader.
- Software must be installed and fully operational before the course begins.
Other:
- Email capabilities and access to a personal email account.
Instructional Material Requirements:
The instructional materials required for this course are included in enrollment and will be available online.