Instructor for this course
more

Excel Efficiency: Dashboards Part 1

Continuing Education Credits
Click or touch a Credit for more information

Certified Public Accountant

Continuing Education Credit:
2 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.

Chartered Accountant (IES7 CPD)

Continuing Education Credit:
2 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-IES7 credit.

Certified Management Accountant

Continuing Education Credit:
2 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.

Certified Fraud Examiner

Continuing Education Credit:
2 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.

Certified Internal Auditor

Continuing Education Credit:
2 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.

Certification in Risk Management Assurance

Continuing Education Credit:
2 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.
Course Syllabus
INTRODUCTION AND OVERVIEW
  11:21Introduction to Excel Efficiency: Dashboards Part 1
  9:08Microsoft Query: New Data Source and Text Files
  10:18Microsoft Query with Text Files and Amending the Query
  8:52Data Security Prompts, Recommended Pivot Tables and Charts (Excel 2013+) and Summarize Pivote Tables
  7:59Applying Number Formats to Pivot Tables, Hiding Worksheet Gridlines and Autofit Column Widths
  7:33Renaming Value Fields in Pivot Tables and Replicate the Pivot Tables
  9:59Top 10 Pivot Tables and Silicing Pivot Tables (Excel 2010+)
  10:04Slicing Pivot Tables (Excel 2010+), Formatting Slicer (Excel 2010+) and Slicing Multiple Pivot Tables
  6:48Incorrect Way to Assemble the Dashboard, Pivot Table Conflicts and Pasting Linked Pictures of Pivot Tables
  10:21Assembling the Dashboard and Automatic Pivot Table Refresh
  9:55Refreshing All Pivot Tables, Pivot Tables Drill-Down and Blank Cell Within Data
  5:19Filling Blank Cells with Zeros for Pivot Tables, Pivot Table Enable Show Detail Option and Conclusion
CONTINUOUS PLAY
  1:47:36Excel Efficiency: Dashboards Part 1
SUPPORTING MATERIALS
  PDFSlides: Excel Efficiency: Dashboards Part 1
  PDFExcel Efficiency: Dashboards Part 1 Glossary/Index
  XLSXWorkbook: Excel Efficiency Dashboards Part 1
  CSVFruit Sales
REVIEW AND TEST
  quizREVIEW QUESTIONS
 examFINAL EXAM