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.
This course is designed for beginner-to-intermediate-level Excel users. Participants should have some basic familiarity with Excel and its functions.
- Absolute vs. Relative Cell References
- Formulas and Functions
- Solver / Goal Seek
- Linking Spreadsheets
- Present Value Applications and Finance Functions
- Conditional Formatting
- Working with Text
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.