PivotTables are likely the most powerful “in-built” feature in Excel aside from Macros. They provide engaging enhancement through powerful graphical presentation and dynamic management of data. Mastering PivotTables is now a highly sought-after skill in a wide range of sectors and fields including data analysis, marketing, social media, public service, banking, accounting, financial analysis, and business administration. A PivotTable displays a summary of a selected data set in a condensed format of rows, columns, data fields, and pages. These components can be “pivoted” with your mouse allowing you to expand, isolate, calculate, and group the particular data in real-time. This empowers the user to view and analyze large amounts of information. PivotTables are a “must have” reporting tool enabling quick business decisions, crucial in business, government, and academic fields. Work “hands-on” during this webinar to reinforce your understanding and retention. Understand this power-packed capability of Excel and how you can create PivotTables in minutes “working smarter .. not harder”! Seize this crucial opportunity to significantly advance ahead of your peers and competition. Replicating the in-person classroom experience using a step-by-step guide, student files, and data samples this interactive webinar offers clear understanding and maximum knowledge retention.

Learning Objectives:-

To gain a practical “hands-on” understanding of how to efficiently create, manage, and display PivotTables, charts, and timelines in Excel for maximum effectiveness.

Areas Covered:-

• Data table design essentials
• Understand PivotTables
• Manually Refresh Data
• Create your own PivotTable
• Define PivotTable structure
• Switch & Delete PivotTable fields
• Using Compound Fields
• PivotTable Tools Analyze and Design Ribbons
• View Format & Display Options
• Summary Value Calculations and Format
• Counting in a PivotTable
• Formatting PivotTable Values
• Column and Row Filters
• Sort PivotTable Data
• PivotCharts with Filtering
• Keyboard shortcuts – Excel, general & web browser
• NOTE: Topic sequence may be subject to slight variation

Why Should You Attend?

• Work smarter, faster, and more effectively
• Know MS Office capabilities & features without asking Google or peers
• Achieve more in less time with higher quality results.
• Boost profit, efficiency, and productivity
• Improve job satisfaction, team performance, and professionalism
• Gain strong competitive advantage at peer and business level
• Strengthen your resume and job applications
• Confidently apply key features and capabilities in Microsoft Office

Who will Benefit?

• Account Executive
• Accountants
• Excel users seeking to boost skill levels
• Auditor
• Bookkeeper
• Business Owner
• Chief Executive
• Controller
• CPA
• Cybersecurity staff
• Database Administrators (DBA)
• Educator / Trainer
• Engineer
• Financial Analyst
• Human Resource Personnel
• IT Professional
• Manager
• Marketer
• New recruit
• Project Manager
• Social Media
• Specialist
• Staff at all levels
• Supervisor