September 16, 2014

8:00 a.m. – 5:00 p.m.

$695 - Includes tuition, course materials, parking and meals.

University of California, San Diego
Rady School of Management
Center for Executive Development


Contact Us


This course is designed for PC users and uses Microsoft Excel 2013. A limited quantity of laptops are available to borrow.

About the Program

Are you ready to take your Excel skills to the advanced level? Have you heard terms like Pivot tables and What if analysis and want to know that they are? Do your Excel skills need an upgrade? If so, the Advanced Excel course is the perfect course to help you become an Excel pro.

Topics Covered:

  • Pivot Tables
  • Pivot Charts
  • Hyperlinks, Macros
  • Macro Writing
  • VBA
  • Advanced Lookup Functions
  • Offset
  • Conditional Sums and Ifs
  • Creating Amortization Tables
  • What-if Analysis?
  • Scenario Manager
  • Data Tables
  • Name Definitions
  • Advanced Chartins
  • Database Functions


This advanced course is designed as a follow-on to our Excel for Business Professionals course. It is not mandatory to have taken the first course, but participants should have an understanding of the topics covered (listed here). Participants should have a very strong working knowledge of Excel and be comfortable with advanced functions. This course is not designed for beginner users.


David Ravetch has been a UCLA accounting faculty member for over 25 years. He has received numerous teaching awards as well as the California Society of Certified Public Accountants' Faculty Merit Award. He was named as the director of the undergraduate accounting program by the Anderson School, where he served for seven years. Ravetch has taught several Executive Education classes at the Rady School, including the popular Accounting and Finance for Non-Financial Managers.

Related Courses