May 30, 2014
8:00 a.m. – 5:00 p.m.
Includes tuition, course materials, parking and meals.
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
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 course 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, mortgage analysis, purchase order calculations, pro forma financials, capital budgeting and the effects of different economic scenarios on earnings.
- Absolute vs. Relative Cell References
- Formulas and Functions
- Solver / Goal Seek
- Linking Spreadsheets
- Present Value Applications and Finance Functions
- Conditional Formatting
- Working with Text
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.
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.