Webcast: Hyperlinks, Data Validation, Pivot Tables, Macros and More (CAHDV15)
Tell a Friend About This EventTell a Friend

When: 06/30/2015
1:00 PM until 3:00 PM
Where: Webcast
United States
Presenter: Jeff S. Lenning, CPA, CITP

Online registration is closed.
« Go to Upcoming Event List  

Registration Fees
Members $70
Non-Members $94

CPE: 2 hours
Level: Intermediate
Vendor: CAL CPA
Category: Management
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.


Major Topics
  • Hyperlinks
  • Data validation
  • Pivot Tables
  • Macros