CPE Packages (Incl. Ethics) for Multiple States and Qualifications Available. Price $4/credit - CLICK HERE to view.

Excel Pivot Tables and Dashboards

4.6 (250)

Alicia Katz Pollock, MAT,ACN,MOS

Royalwise Solutions

Wednesday, July 22, 2020 | 09:30 AM EDT

  • CPA

1.5 Credits

$30

Subject Area

Computer Software and Applications

Webinar Qualifies For

1.5 CPE credit of Computer Software & Applications for all CPAs

1 CE credit of Computer Technology for Maryland Tax Preparers

1.5 General Educational credit for Tax Professionals / Bookkeepers / Accountants

Upcoming Webinars

prospective financial statements

(90)

Jun 24, 2021 | 10:00 AM EDT View Details

the mathematics of estate planning for iras after the secure act

(31)

Jun 24, 2021 | 10:00 AM EDT View Details

sox internal controls for accounts receivable

(3)

Jun 24, 2021 | 10:00 AM EDT View Details

best workshop on s corporation (form 1120s) tax return review & case study (new)

(2)

Jun 24, 2021 | 10:00 AM EDT View Details

annual federal tax update - c & s corporations, partnerships & llcs (forms 1120, 1120s & 1065)

Jun 24, 2021 | 10:00 AM EDT View Details

comprehensive guide to identity theft with case studies

(3)

Jun 24, 2021 | 10:00 AM EDT View Details

complete cfo guide on analytics,corporate performance management,budgeting,reporting

Jun 24, 2021 | 10:00 AM EDT View Details

tax ethics

(30)

Jun 24, 2021 | 10:00 AM EDT View Details

quickbooks for desktop pc exploring the interface - for beginners

(1)

Jun 24, 2021 | 10:00 AM EDT View Details

ppp and erc: maximize your money

(14)

Jun 24, 2021 | 10:30 AM EDT View Details

excel accountant: internal control

Jun 24, 2021 | 10:30 AM EDT View Details

practical guide to iras – contributions & distributions for traditional, roth, sep & simple iras

(4)

Jun 24, 2021 | 08:00 AM PDT View Details

fundamental concepts of trusts & estates for planning & compliance

(1)

Jun 24, 2021 | 08:00 AM PDT View Details

auditing for corruption

Jun 24, 2021 | 11:30 AM EDT View Details

intro to accountingsuite™ & multi-channel inventory

(18)

Jun 24, 2021 | 12:00 PM EDT View Details

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

Array
(
    [no_of_record] => 250
    [average] => 4.5560
)
 

4.6

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

BM

great job and thank you.