Empower Yourself: Free Stress Awareness Month Tips!

Electronic Spreadsheet Fundamentals Certification for Mac

  • Live Session
  • Certification
From $573.00
  • June 26, 2023, 12:30 pm   EST
Training Includes:
  • Certificate of Attendance
  • All resources and training materials

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

  • When to use PivotTables
  • What you should know before you create a PivotTable
  • Creating a PivotTable
  • Formatting PivotTables
  • Customizing PivotTable formatting
  • Sorting and filtering PivotTables
  • Changing PivotTable calculations
  • Creating PivotCharts
  • Sharing PivotTables and charts in PowerPoint, Word, and other apps
  • Filtering with interactive slicer tools
  • Power tips, tricks, and shortcuts
Monday, June 26 - Friday, June 30, 2023; 12:30 PM Eastern
Scheduled for 90 minutes including question and answer period.

Training Overview

Find a fast solution for year-end analysis. Excel PivotTables can reveal the information hidden in your data.

As the end of the year approaches, data is piling up, reporting deadlines are looming, and you need clear information to plan for 2022. Excel PivotTables are the perfect solution! This powerful spreadsheet feature allows you to quickly create calculations and draw conclusions from massive sets of data.

In just a few clicks, PivotTables can reveal financial conclusions, annual invoicing totals, satisfaction survey results, payroll anomalies, nonprofit donor histories, departmental productivity metrics, Six Sigma statistics, vendor compliance ratings, and 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
  • Filtering with interactive slicer tools
  • Creating PivotCharts

Part 2: PivotTables And Charts

  • Customizing PivotTable formatting
  • Changing PivotTable calculations
  • Formatting Pivot Charts
  • Advanced PivotTable Techniques
  • 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:

  • Human resources professionals
  • Business owners
  • Finance professionals
  • CEOs
  • CFOs
  • CTOs
  • Managers of all levels
  • Operations managers
  • Administrators
  • Commercial lenders
  • Credit analysts
  • Loan documentation specialists
  • Relationship managers
  • Branch managers
  • Private bankers
  • Business development officers
  • Nonprofit chief executives
  • Supplier relationship managers

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


  • 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.

Other Trainings You May Be Interested In…

For Teams

Have a team that needs training? Our enterprise customers receive custom branding, reporting and analytics tools, and of course, preferred pricing.