Description
Overview
PivotTables are reputed to be 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 analyse large amounts of information.
PivotTables are a “must have” reporting tool enabling quick business decisions which are 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.
Why should you attend ?
- Work smarter, faster and more effectively
- Boost profit, efficiency, and productivity
- Improve job satisfaction, team performance, and professionalism
- Gain strong competitive advantage at peer and business level
- Achieve more in less time with higher quality results.
- Strengthen your resume and case for increased salary
- Understand the latest and most relevant MS Office functions available
Areas Covered in the Session
- 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
- Timeline Filter for Data with Dates
- Slicers as an Engaging Filter Interface
- Keyboard shortcuts – Excel, general & web browser
- NOTE: Topic sequence may be subject to slight variation
Who will benefit
- Private
- Public and Academic Sector Staff
- Managers & Executives or
- Anyone seeking to maximize their investment in Microsoft Office Applications.
- Account Executive
- Accountant
- Auditor
- Bookkeeper
- Business Owner
- Chief Executive
- Controller
- CPA
- Cybersecurity staff
- Database Administrator (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
Instructor Profile
Ray Evans, professional and relaxed style reflects his thorough understanding of adult learning principles and is demonstrated through his diverse range of classroom, seminar, workshop and online delivery services and instructional materials.
With Microsoft Certifications in Excel and Word, he has mastered over 2500 topics to advanced level in Microsoft Excel, Access, Outlook, Project, PowerPoint, Word, Visio, and Publisher.
Ray has qualifications in Frontline Management, Accounting, Training, and Assessment and is certified in Six Sigma business improvement methodology.
