Must Know Excel Functions for CPAs

Course Information

Title:	Must Know Excel Functions for CPAs
Category:	Computer Software
Field of Study:	Computer Software and Applications
Course Code:	M196
CPE Credits:	5.0
Price:	43.95

Description

Description:

This course is designed for intermediate users of Excel who are looking to improve their Excel skills and productivity. The course covers some basics, along with some advanced tips and tricks. It starts with how to select and navigate through data and worksheets as well as copying and moving data efficiently. It then details a wide spectrum of functions that can be used in everyday practice. Functions discussed include creating nested Ifs and exploring a variety of text functions such as RIGHT(), MID() and LEN(). SUMIF() and INDEX MATCH are also discussed. New functions, such as XLOOKUP(),AGGREGATE(), IFNA(),TEXTJOIN() , CONCAT() and IFS() are covered. Learn how to comparing lists using arrays. Pivot tables are discussed in detail. Other topics include: Charts, Conditional formatting, and tools for importing data into Excel. You will definitely impress your coworkers with all your new knowledge!
An exercise file containing a few of the examples in the eBook are included. All topics are gone over in a detailed step by step fashion that is easy to follow whether you wish to use the optional exercise files or not.

Delivery Method: Online Interactive Self Study

Level: Overview

Prerequisites: None

Advanced Preparation: None

Course Details

Category: Computer Software

Field of Study: Computer Software and Applications

Passing Score: 70%

Technical Details: CA, FL: Computer Software and Applications are technical subjects TX: Computer Software and Applications are non-technical subject for TX. NY: Advisory Services includes Computer Software and Application

For More Detail:

If you are unable to view PDF then right click the mouse and click save link as

Objectives

Objectives:

Recognize different short cut keysand their function
Recognize the function of pinning a file to Favorites
Identify and create range names
Recognize different ways to navigate within and between Excel workbooks
Identify some of Excel’s newer features and functions
Recognize different copyand move methods
Identify different types of formatting and how to apply them
Recognize different functions and formulas and how to apply them
Recognize the different components of a Pivot Table and how to create and edit them
Identify types of charts to use and how to create them
Identify features that allow you to evaluate the workings of formulas and functions

For More Objectives:

If you are unable to view PDF then right click the mouse and click save link as

Profession

NASBA: Yes

QAS: Yes

CPA: Suitable for all CPAs

IRS: No IRS credit for Enrolled Agents.

Profession Identifiers: CPA