Excel Tips and Techniques: Improve Productivity and Financial Modeling Webinar

Dec 14
9:30 - 5:00 p.m.

Online

8-Other
CPE Credits

Identify three problems caused by merging cells.
Determine if a cell has Text or Values, and why it's important.
Identify three advantages of named ranges using the Name Box.
Recognize the 10 steps to follow when creating a model.
Identify a potential fraud situation using the Histogram tool.
Create a macro using the macro recorder.

Highlights

Ribbons and Quick Access toolbar
New Excel capabilities
Key features: Camera, Grouping, Filtering, Goal Seek, Sorting, Subtotaling, Data Validation, Conditional Formatting and Protection Techniques
Macros and the macro recorder
Pivot tables: Proper setup for best results
Financial modeling architecture best practices
Fraud investigation tips using Excel, including Benford's Law

Registration

PICPA Member: $245
Nonmember: $345

More Information

Course No. 4181197C Level: Intermediate

Prerequisites:

One-to-two years of experience using Excel (PC version, 2007, 2010 or 2013) in a work related environment.

Notes

This webinar is hosted by PICPA's partner, The California Society of CPAs. After registering, you will receive an email from the California Society with the log-in information.