Pivot Table Intermediate: Mastering Pivot Tables like a PRO

Continuing Education Credits
Click or touch a Credit for more information
CPA
1.5 CPE
CPD-IES8
1.5 Hours
CMA
1.5 CPE
CFE
1.5 CPE
CIA
1.5 CPE
CRMA
1.5 CPE

Certified Public Accountant

Continuing Education Credit:
1.5 CPE Credit
Field of Study:
Computer Software & Applications
CPE Delivery Method:
Self-Study
Program Location:
Online
Program Level:
Basic
Prerequisites:
No advanced preparation or prerequisites are required for this course.
cpe/qas logo
Illumeo 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 the final authority on the acceptance of individual course for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website: www.nasbaregistry.org.

NASBA Sponsor Number: 109504
State of New York Sponsor Number: 002746
State of Texas Sponsor Number: 009890
In accordance with the standards of the National Registry of CPE Sponsors, CPE credits have been granted based on a 50-minute hour.
More information about CPA CPE Credits
Back to Top

Chartered Accountant (IES8 CPD)

Continuing Education Credit:
1.5 Hour
Field of Study:
Computer Software & Applications
CPE Delivery Method:
Self-Study
Program Location:
Online
Your specific provider of Continuing Professional Development accreditation has final authority on the acceptance of individual courses for CPD-IES8 credit.
More information about CPD-IES8 Hours
Back to Top

Certified Management Accountant

Continuing Education Credit:
1.5 CPE Credit
Field of Study:
Computer Software & Applications
CPE Delivery Method:
Self-Study
Program Location:
Online
Program Level:
Basic
Prerequisites:
No advanced preparation or prerequisites are required for this course.
More information about CMA CPE Credits
Back to Top

Certified Fraud Examiner

Continuing Education Credit:
1.5 CPE Credit
Field of Study:
Computer Software & Applications
CPE Delivery Method:
Self-Study
Program Location:
Online
Program Level:
Basic
Prerequisites:
No advanced preparation or prerequisites are required for this course.
More information about CFE CPE Credits
Back to Top

Certified Internal Auditor

Continuing Education Credit:
1.5 CPE Credit
Field of Study:
Computer science
CPE Delivery Method:
Self-Study
Program Location:
Online
Program Level:
Basic
Prerequisites:
No advanced preparation or prerequisites are required for this course.
Registry of CPE Providers Seal


Recognized CPE provider, authorized by the Institute of Internal Auditors for use in the Certified Internal Auditor (CIA) CPE program.
More information about CIA CPE Credits
Back to Top

Certification in Risk Management Assurance

Continuing Education Credit:
1.5 CPE Credit
Field of Study:
Other activities contributing to professional competence
CPE Delivery Method:
Self-Study
Program Location:
Online
Program Level:
Basic
Prerequisites:
No advanced preparation or prerequisites are required for this course.
Registry of CPE Providers Seal

Recognized CPE provider, authorized by the Institute of Internal Auditors for use in the Certified Risk Management Assurance (CRMA) CPE program.
More information about CRMA CPE Credits
Back to Top
Instructor for this course
  Course Overview CPE
Course Syllabus
Introduction and overview
  Introduction to Excel Pivot Table Intermediate: Mastering Pivot Tables like a PRO0:58
  Recap0:46
  Instructor Introduction 1:12
  Comparison with Other Similar Courses 1:26
  What You Will Get from This Course? 0:38
Intermediate Taming Maneuvers – Calculations
  How to solve a formula error in a pivot table3:20
  How to show a running total2:37
  How to show averages? What average?4:03
  How to show a list of formulas used2:00
  How to count a unique times3:55
Intermediate Taming Maneuvers – Display and Layout
  How to customize pivot table fields window1:36
  How to add or remove fields quickly1:26
  How to turn grand total off1:33
  How to repeat all row labels1:07
  How to quickly open value field settings1:00
  How to keep formatting upon update0:46
  How to set up a schedule to refresh pivot tables2:26
Advanced Taming Maneuvers
  How to remove old data from the filter2:46
  How to automatically update manual filtered list3:40
  How to set up a customized sorting order4:50
  How to cut down big file size2:59
  How to get original Field name for a Renamed one1:14
  How to generate pivot reports for all entities1:49
10 Keyboard Shortcuts
  To convert data list to data table1:18
  To create a pivot table0:38
  To open Calculated Field Window0:33
  To insert a pivot chart0:30
  To refresh 1 pivot table0:35
  To refresh all pivot tables0:52
  To group fields0:34
  To ungroup fields0:24
  To filter out an item0:38
  To open the old PivotTable Wizard window2:10
CONCLUSION
  Takeaways 1:56
  Next Course & Q&A0:26
CONTINUOUS PLAY
  Pivot Table Intermediate: Mastering Pivot Tables like a PRO58:36
SUPPORTING MATERIAL
  Slides: Pivot Table Intermediate: Mastering Pivot Tables like a PROPDF
  Pivot Table Intermediate: Mastering Pivot Tables like a PRO Glossary/ IndexPDF
  Workbook: Pivot Table Intermediate: Mastering Pivot Tables like a PROXLXS
REVIEW AND TEST
  REVIEW QUESTIONSquiz
 FINAL EXAMexam