Microsoft® Certified Trainer and Excel expert Jackie Kiadii will show you how to use PivotTables to analyze your data, produce impressive reports, and advance your career. After these two engaging and information-packed sessions, you will be amazed by how well you can use these powerful features.
What You'll Learn
- Financial conclusions
- Quarterly invoicing totals
- Satisfaction survey results
- Payroll anomalies
- Nonprofit donor histories
- Departmental productivity metrics
- Assessment score trends
- Six Sigma statistics
- Vendor compliance ratings
Training Overview
Summarize data in 30 seconds. Excel PivotTables can reveal the information hidden in your data.
Instead of spending hours summarizing results and information from the first half of the year, you can use an Excel PivotTable to do it in seconds! This powerful spreadsheet feature allows you to quickly create calculations and draw conclusions from massive data sets in any type of organization.
In just a few clicks, PivotTables can reveal:
- Financial conclusions
- Quarterly invoicing totals
- Satisfaction survey results
- Payroll anomalies
- Nonprofit donor histories
- Departmental productivity metrics
- Assessment score trends
- Six Sigma statistics
- Vendor compliance ratings
- Whatever other answers you need from your data
To help you unlock conclusions, we have assembled a two-part webinar series with step-by-step guidance that will enable you to make PivotTables from your data immediately following the training:
Excel PivotTables Series
Part 1: Introduction To PivotTables
- When to use PivotTables
- What you should know before you create a PivotTable
- Creating a PivotTable
- Formatting PivotTables
- Sorting and filtering PivotTables
- Creating PivotCharts
Part 2: PivotTables And Charts
- Customizing PivotTable formatting
- Changing PivotTable calculations
- Formatting Pivot Charts
- Creating Advanced Pivot Charts
- Sharing PivotTables and charts in PowerPoint, Word, and other apps
- Power tips, tricks, and shortcuts
We are not affiliated, endorsed, or sponsored by Microsoft or Microsoft Excel®.
Who Should Attend?
|
Everyone who uses or could use Excel, including:
|
|
Expert Presenter
Jackie Kiadii
-
Founder of Phoenix Computer Consultants, LLC, an Atlanta-based IT services firm
-
Helping clients leverage technology to increase their productivity and profitability since 2001
-
Provides curriculum development, consulting, and training in Microsoft 365® applications
-
Microsoft® Certified Trainer and Microsoft® Certified Expert – Excel
Credits
- This program has been approved for 3.0 general recertification credit hours toward PHR, SPHR, and GPHR recertification through the HR Certification Institute.
- This program is valid for 3.0 PDCs for the SHRM-CP or SHRM-SCP.
CareerLearning Quality Commitment
CareerLearning wants you to be satisfied with your purchase. If this program does not meet your expectations, email us at support@careerlearning.com.
