Course Details


Course Name: Intermediate Excel Functions for CPAs
CPD hours: 2
Type: Online/Video
Price: $120 $108




Topics:
What you'll learn
IF, AND, OR and NOT statement
IF statement
AND statements
OR statements
NOT statements
COUNT and SUM functions
COUNT functions
COUNTIF functions
COUNTIFS functions
SUM functions
SUMIF functions
SUMIFS functions
AUTO SUM
PMT functions
IPMT functions
LEFT, RIGHT, MID, TRIM CONCATENATE, and CHOOSE functions
LEFT, RIGHT, and MID functions
CONCATENATE and TRIM functions
CHOOSE functions
MATCH, INDEX, and VLOOKUP functions and How to Name a Range
How to Name a Range
MATCH functions
INDEX functions
VLOOKUP functions
Data Analysis 1
Data Analysis 2
Data Validation
Pivot Tables
Custom Formatting
Advanced Graphs
Arrays
What you learned today






Screenshots