CPE: 2 hours
Prerequisites: Must have a general working knowledge of Excel and be familiar with basic formulas and navigation within the Excel interface.
Advanced prep: None
Who should attend: Accounting and finance professionals who use Excel.
In this webcast, you will learn to use the power of Excel to get your job done in a fraction of the time through the power of hyperlinks, data validation, pivot tables, macros and more.
- Identify Excel features that improve productivity, including creating in-cell drop down boxes and generating summary reports from transaction detail.
- Recall critical Excel worksheet functions.
- Determine how to use Excel to automate time-consuming manual tasks.
- Data validation
- Pivot Tables