Black Friday Offer Extends till Dec 3rd ! Unlimited Continuing Education only @$299 $199 (2 Days Left) CLICK HERE to view.

Excel Pivot Tables and Dashboards

  • CPA (US)
Excel Pivot Tables and Dashboards

1.5 Credits

FREE

Subject Area

Computer Software and Applications

Upcoming Webinars

Course Description

16% of the world population is using Excel. Ask any accountant in any field which software they use on a daily basis, and the most common answer will be Microsoft Excel. AICPA has also included Excel as the spreadsheet tool in the CPA Exam

The spreadsheet tool is perfect for anyone working in the finance and accounting fields due to its versatility and specific financial applications. Mastery of Microsoft Excel is a must-have skill for accountants these days and a key to their professional growth. Whether you’re just starting out or have been in the field for some time, being able to efficiently navigate through a data set in an Excel file and use formulas to make sense of the data should be one of your top priorities.

Join this webinar to understand your Excel data instantly by turning endless rows & columns of numbers into stunning visuals. We’ll manipulate vast amounts of data by creating :

  • Pivot Tables
  • Pivot Charts
  • Dashboards.
  • Formatting of Data from the shape to the color. 

RECOMMENDED FOR ALL THE ACCOUNTING AND TAX PROFESSIONALS

** It doesn’t matter what version of the PC or Mac operating system you’re using. The techniques we will cover work similarly in Excel for PC and Mac



Learning Objectives

  • How to move around in spreadsheet
  • How to enter data and manage Autofill handle
  • To learn about Relative and Absolute Cell References
  • To learn about various Formulas and Functions
  • To learn about Formatting, conditional formatting, creating charts, Sparklines & others in Excel

Who Should Attend?

  • Accountant
  • Accounting Firm
  • Accounting Managers
  • Accounting Practice Owners
  • Accounts Director
  • Auditors
  • Bookkeeper
  • CEO
  • CFO/Controller
  • Compliance Managers
  • CPA (Industry)
  • CPA - Mid Size Firm
  • CPA - Small Firm
  • CPA in Business
  • Enrolled Agent
  • Entrepreneurial Accountant
  • Entrepreneurial CPA
  • Finance Director
  • Finance Pros
  • Government Contractor
  • Legal Professionals
  • Non Profit Pros
  • Others
  • QB Pro Advisor
  • Senior Accountant
  • Staff of Accounting Firm
  • Tax Attorney
  • Tax Firm
  • Tax Managers
  • Tax Practitioners
  • Tax Preparer
  • Tax Pros
  • Xero Advisor
  • Young CPA

Testimonial

4.6

(250)
66%
26%
7%
0%
1%

BM

great job and thank you.