Webcast: Best Enhancements in Excel 2007/2010/2013 (CATECHL15)
Tell a Friend About This EventTell a Friend
 

Harness the power of Excel and explore Tables, SUMIFS, Remove Duplicates, Sparklines, Slicers, Web Apps and PowerPivot, among other Excel features and functions that can save you time. We'll be using business and industry scenarios, but the Excel features and benefits apply to all accounting and financial professions.

11/9/2015
When: 11/09/2015
1:00 PM until 3:00 PM
Where: Webcast
Louisiana
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: CalCPA
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.

Harness the power of Excel and explore Tables, SUMIFS, Remove Duplicates, Sparklines, Slicers, Web Apps and PowerPivot, among other Excel features and functions that can save you time. We'll be using business and industry scenarios, but the Excel features and benefits apply to all accounting and financial professions. Formerly titled: Best Enhancements in Excel 2007/2010

Objectives

  • Identify Excel worksheet functions that are helpful and relevant to accounting professionals.
  • Determine how to apply these features and functions through practical examples.
  • Recall techniques that improve your productivity.


Major Topics
  • Tables: Solve one of the biggest Excel pitfalls
  • SUMIFS: Conditional summing explained
  • Remove Duplicates: See how to use this new feature
  • Sparklines: One-cell charts
  • Slicers: Visual filters
  • Web apps: Free web-based version of Excel
  • PowerPivot: Advanced Pivot Tables