Member Fees: $289

Non-Member Fees: $389

Microsoft Excel – Number Crunching with Pivot Tables

Duration: 4-hours

 Prerequisites: This course requires that you are familiar with Excel. It is suggested that you successfully completed Excel 1 and Excel 2, or had more than 6 months using the software.

Description: Pivot tables are the perfect solution when summarizing and analyzing large amounts of data. You can access a whole new information set in just a few clicks. Pivot tables extract meaning from that seemingly endless jumble of numbers on your screen. It lets you group your data differently to draw helpful conclusions more quickly. If you work with large amounts of data in Excel, you need to know Pivot Tables to work more efficiently.

Contents:

PivotTable Fundamentals
Creating a Basic Pivot Table
Introduce Slicers and other New Pivot Table Tools
Customize the Pivot Table View
Layout Changes
Changing Summary Calculations
Using Running Totals, % Of, and Rank Options
Grouping, Sorting, and Filtering Pivot Tables
Calculations within Pivot Tables
Calculated Fields and Calculated items
Using Pivot Charts
Advanced Pivot Table Tips & Techniques
Solutions to Common Pivot Table Problems

*NOTE: Half and Full Day Computer Skills classes are not eligible for AAIM’s All Access Training Pass usage.

*Registration will close TEN business days prior to the event.

For Cancellation/Reschedule and Inclement Weather Policy please click HERE

HRCI 2024 Approved Provider logo

HRCI Accreditation:

N/A|N/A|N/A


SHRM Recertification Provider logo

SHRM Accreditation:

N/A|N/A|N/A


National Registry of CPE Sponsors logo

CPE Accreditation:

Professional Development Credits Awarded: 7 Recommended

AAIM Employers’ Association is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website: www.learningmarket.org.|Professional Development Credits Awarded: 7 Recommended

AAIM Employers’ Association is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website: www.learningmarket.org.|Professional Development Credits Awarded: 7 Recommended

AAIM Employers’ Association is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website: www.learningmarket.org.

Course Dates

Course Date and Time

Start Date: 05/23/2024 08:00 AM CDT
End Date: 05/23/2024 12:00 PM CDT

This Event is not available.

Course Date and Time

Start Date: 08/27/2024 11:00 AM CDT
End Date: 08/27/2024 03:00 PM CDT

This Event is not available.

Course Date and Time

Start Date: 11/21/2024 11:00 AM CST
End Date: 11/21/2024 03:00 PM CST
Register Now