Human Resources
Basic, Easy-To-Follow Pivot Tables For Superior Data Analytics
CWS2024245
90 Minutes
Dec 6,2024
10:00 AM PST | 01:00 PM EST
Overview
- Understand the relationship between data field headers and the Pivot Table pane
- Transform data into a Pivot Table and actionable information
- Instantly Transform (Pivot) Rows and Columns
- Use Pivot Table filters to analyze your data
- Deign a Pivot Chart from your Pivot Table
- Develop Slicers for User Interactive Filters
- Understand the first steps of dashboard design using Pivot Tables
- Group your data for instant analysis and charting
- Group your data in easy-to-follow silos with pivot tables and chart the results with pivot charts
- Create beautifully designed pivot charts that get noticed
Who should attend?
Managers, supervisors, financial professionals, CPAs, budget directors, financial analysts, administrative assistants, sales professionals, marketers - anyone who uses Microsoft Excel and wants to save hours, avoid using cumbersome tables and analyze data in the most proficient manner possible. This includes Accountants (staff through manager), Financial Analysts, Budget Managers/Directors, Data Analyst, IT Analyst, CFOs, Controllers, and Internal Auditors. Also, all C-Level employees at Fortune 1000 Firms, Listed Corporations, Utility/Energy Companies, Federal, State and Local Government Agencies/Administrators, CPA Firms, Banks, and Small Business Administrators.
Why should you attend?
In this webinar you'll discover the fun, simplicity and incredible usefulness of PivotTables... and you'll be well on your way to harnessing all the impressive power that comes with Excel Pivot Tables, Pivot Charts and Pivot Slicers. Learn to use this fun, versatile Excel tool to manage data more effectively than you thought possible. Discover how to use the power of the Excel Pivot Table with this easy-to-follow Excel webinar.
With our crystal clear instructions including easy-to-follow screen-shot reference manuals you’ll be able to set up a pivot table in less than 2 minutes. Slice-‘n-dice data the way you want with this practical on-the-job training. You will be able to prepare Pivot Tables, Pivot Charts and Pivot Slicers and much more at the conclusion of this webinar.
What you'll learn?
- Set up your data and create a Pivot Table in less than 2 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 & Pivot Charts with WOW power that commands respect for your work
- 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.
- Expand and compress pivot tables and pivot charts simultaneously for easy presentation and analysis
- Creating custom pivot charts to illustrate your data.
- Create slicers to allow any user to automatically filter and manipulate your data.
- Group and Chart data instantly using the power of Pivot Tables.
Mr. Joseph Weil
Joe has a Master of Accounting Degree from Florida State University and is an actively licensed Florida CPA. Joe’s work experience includes staff accountant with large CPA firm, corporate controller, state agency director of auditing and former municipal CFO. Joe also started and sold his own CPA firm.
Joe spent six years working as an adjunct accounting professor. Joe is the owner and CEO of the National Center for Continuing Education, a nation-wide financial and technology training firm. Joe leads interesting and informative webinars.
Joe’s past in-house seminar/webinar clients have included Harley-Davidson, Hewlett-Packard, General Mills, Oracle, Burger King, Deloitte, Florida Power and Light and many similar organizations.