Details

Includes tuition, course materials, parking and meals.

Register

Contact Us

Directions

About the Program

Do you own a Mac? Do your Excel skills need an upgrade? Do you want to learn more about the functionalities of Excel — like macros, data tables, solver and sliders? If so, the Excel for Business Professionals (Mac Version) is the perfect course to help you become an Excel pro.

At this hands-on, one-day program you will learn to use Excel to successfully tackle financial forecasting, purchase order calculations, pro forma financials, manipulating text, capital budgeting and the effects of different economic scenarios on earnings.

Participants

This course is designed for beginner-to-intermediate-level Excel users. Participants should have some basic familiarity with Excel and its functions.

Topics Covered:

  • Formatting
  • Absolute vs. Relative Cell References
  • Filtering
  • Tables
  • Sorting
  • Formulas and Functions
  • Macros
  • Solver / Goal Seek
  • Linking Spreadsheets
  • Present Value Applications and Finance Functions
  • Charting
  • Conditional Formatting
  • Sparklines
  • Sliders
  • Histograms
  • Working with Text

Course Faculty

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
at the Rady School of Management