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.
- 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.