Details

May 30, 2014
8:00 a.m. – 5:00 p.m.

$695

Includes tuition, course materials, parking and meals.

Register

Contact Us

Directions

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

About the Program

Get more out of Microsoft Excel® 2013: more productivity and better answers for greater success. This course brings together all the intensely useful knowledge you need: insights, techniques, tips, and shortcuts. Get comfortable with its updated interface and leverage its new tools.

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

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

Participants

This course is designed for participants with advanced-beginner to intermediate skill level using Excel. Participants should be comfortable using Excel and have some familiarity with its basic functions. This course is not designed for people with no Excel experience.

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

Excel for Business Professionals (Mac Version)

Advanced Excel for Business Professionals

Accounting and Finance for Non Financial Managers