Must Know Excel Tips, Tricks, and Tools for the CPA (PSMC)

Customer Rating
Field of Study
Computer Software & Applications
Level
Overview
Credits
5
Qualifies For
CPE



Price:  $49.99

This course is designed for the intermediate user of Excel 2013 and 2016 who are looking to improve their productivity and to learn some cool new Excel skills. The course covers some basics, along with some advanced tips and tricks on selecting, navigating as well as copying and moving data efficiently. It also covers a spectrum of functions that can be used in everyday practice. Functions such as SUBTOTAL, SUMIF, SUMIFs as well as INDEX MATCH are discussed. New functions, such as AGGREGATE, IFNA, TEXTJOIN and IFS functions are covered. Comparing lists using arrays is overviewed. Pivot tables are discussed in detail. Other topics include: functions and tools for importing data into Excel, conditional formatting as well as charts. There are no associated Excel files.

Additional information

Credits

5

Format

Self-Study Download

Company Code

Self Study

Yellow Book Approved

0

CFP Approved

0

IRS Approved

0

CTEC Approved

0

Field of Study Credits

Computer Software & Applications (5)

Field of Study Department

Computer Software & Applications

Course Version

2019-01

CPE Approved

1

Pre-requistes:

Knowledge of Excel and how to create a formula and use functions.

Knowledge Level:

Overview

Major Topics:

  • Overview of Excel tips, tricks, and tools for the CPA 
  • Navigating 
  • Copying / Moving / Grouping 
  • Custom Formats
  •  Must Know Functions Nested IF 
  • Miscellaneous Formulas You May Actually Need One Day Pivot Tables Charts

Designed For:

All CPAs