New Features in Excel 2019 & Using Excel to Detect and Prevent Fraud
In this course, participants will also learn about ways to use Excel to help detect and prevent fraud, including working with random numbers, consolidating data, applying Benford’s Law, converting a general ledger into a pivottable, converting a pivottable into a Cube function-based table, using regression to test the validity of data, profit margin monitoring, preparing a proof of cash, cleaning data so it can be properly analyzed, data analysis tools, using Sparklines to evaluate data trends, conditional formatting methods, ratio reporting and more. Don’t miss this unique opportunity to learn more about Excel from this unique and interesting perspective.
In this CPE course, participants will learn about the new features included in Excel 2018, followed by sessions demonstrating how Excel can be used to detect and prevent fraud.
CPAs who want to elevate their Excel knowledge to a more advanced level
Early Registration Member Fee
Applicable if you are a HSCPA member in good standing and register by October 8, 2019.
Applicable if you are a HSCPA member in good standing.
Early Registration Non-Member Fee
Applicable if you are not a HSCPA and register by October 8, 2019.
Applicable if you are not a HSCPA member.
Neighbor Island Discount
Applicable for Neighbor Island members in good standing
Associate Neighbor Island Discount
Applicable for Associate Neighbor Island members in good standing
CPE ChoiceLearn more about CPE Choice.
|CPE Choice Fee||$250.00|