Basic, Easy-to-Follow Pivot Tables Including an Introduction to Dashboards
Instructor:
Joe Weil
Product ID: 705044
Training Level: Basic to Intermediate
- Duration: 100 Min
Why Should You Attend:
In this webinar, attendees will discover the convenience of using the features within Excel Pivot Tables, Pivot Charts and Pivot Slicers effectively. Learn to use this versatile Excel tool easily and manage data more effectively and discover how to use Excel Pivot Table with this easy-to-follow Excel webinar.
Learning Objectives:
- Understand the relationship between data field headers and the Pivot Table pane
- Transform data into a Pivot Table
- Instantly transform (Pivot) rows and columns
- Use Pivot Table filters to analyze your data
- Design a Pivot Chart from your Pivot Table
- Develop Slicers for User Interactive Filters
- Understand the first steps of dashboard design using Pivot Tables
Areas Covered in the Webinar:
- Set up your data and create a Pivot Table in less than 5 minutes
- Understand how to activate the Pivot Table and use the Pivot Field for instant versatility
- Place key business metrics in an interactive Pivot Table for improved, instant analysis
- Expand and collapse levels of data for focused results
- Create Slicers and Pivot Charts
- Instantly interchange rows and columns of information for added clarity and analysis
- Instantly organize, subtotal, sort and analyze numeric data; alphabetize as necessary
- Summarize your data by categories and subcategories
- Creating custom pivot charts to illustrate your data
- Create slicers to allow any user to automatically manipulate your data
Who Will Benefit:
- Managers
- Supervisors
- Financial professionals
- CPAs
- Budget directors
- Financial analysts
- Administrative assistants
- Sales professionals
- Marketers
- Anyone who uses Microsoft Excel
Joe Weil
CEO, NCCE
Joe Weil, CPA, M. Acc., is the president of the National Center for Continuing Education (NCCE), a Tallahassee based nationwide financial training firm. Mr. Weil has led over 400 seminars on Excel and financial topics and several highly acclaimed webinars on the same topics. He is a former corporate controller, former state agency director of auditing, and a former municipal CFO.
Mr. Weil earned his Master of Accounting Degree at Florida State University. His training clientele include Harley-Davidson, Hewlett-Packard, Oracle, Deloitte, Florida Power and Light, Motorola, National Institute of Science and Technology, and many others.
More Training By Experts
- Excel Pivot Table: Step-by-Step System Flowchart Makes Pivot Tables Easy for Administrators and Financial Professionals
- Excel Charting Basics - Produce Professional-Looking Excel Charts - Part 1
- Step-By-Step Excel Tables - Part 2
- Harness the Incredible Power of Excel Pivot Tables in 90 Minutes: Learn To Slice, Dice and Crunch Numbers with Expert Ability - Part 3
- Excel Training - Be A Pro at Charting Basics, Advance Table Functions and Pivots
Refund Policy
Our refund policy is governed by individual products and services refund policy mentioned against each of offerings. However in absence of specific refund policy of an offering below refund policy will be effective.
Registrants may cancel up to two working days prior to the course start date and will receive a letter of credit to be used towards a future course up to one year from date of issuance. ComplianceOnline would process/provide refund if the Live Webinar has been cancelled. The attendee could choose between the recorded version of the webinar or refund for any cancelled webinar. Refunds will not be given to participants who do not show up for the webinar. On-Demand Recordings can be requested in exchange. Webinar may be cancelled due to lack of enrolment or unavoidable factors. Registrants will be notified 24hours in advance if a cancellation occurs. Substitutions can happen any time. On-Demand Recording purchases will not be refunded as it is available for immediate streaming. However if you are not able to view the webinar or you have any concern about the content of the webinar please contact us at below email or by call mentioning your feedback for resolution of the matter. We respect feedback/opinions of our customers which enables us to improve our products and services. To contact us please email [email protected] call +1-888-717-2436 (Toll Free).
