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 Benfords 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. Dont miss this unique opportunity to learn more about Excel from this unique and interesting perspective.
- Excels custom visuals
- Bullet charts; speedometer charts
- Creating dashboards
- Automated workflows
- Synchronizing data sources (such as stock prices or currency exchange rates)
- Forms controls
- New functions such as IFS, SWITCH, TEXTJOIN, MAXIFS and MINIFS
- Map charts; funnel charts
- Color-code heat maps
- Power Query
- Data scrubbing
- Benfords Law, converting general ledgers into pivot tables, converting pivot tables into a CUBE function-based tables
- Regression-based data analysis
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
Registration for this course has passed.
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|