Excel Modeling Tips and Techniques for Improved Productivity: Intermediate
MGMT 831.81
For intermediate Excel users who want to learn tips and techniques that will help them take their Excel model-building skills to the next level.
What you can learn.
- Learn QAT (Quick Access Toolbar), Camera, Subtotaling, Data Validation, keyboard shortcuts, and key functions (e.g., VLOOKUP, SUBTOTAL, XIRR)
- Create "mega formulas," conditional formatting, use Goal Seek, modeling best practices, protection techniques, andforms controls
- Get an introduction to macros
About this course:
This one-day seminar is primarily intended for intermediate Excel users who want to learn tips and techniques that will help them take their Excel model-building skills to the next level. Topics include the QAT (Quick Access Toolbar), Camera, Subtotaling, Data Validation, keyboard shortcuts, key functions (e.g., VLOOKUP, SUBTOTAL, XIRR), creating "mega formulas," conditional formatting, using Goal Seek, modeling best practices, protection techniques, forms controls, introduction to macros (recorder) and much more. Demo models are discussed and made available to attendees. Computers are not required. The instructor uses Windows/Microsoft Office Excel for PC.Corporate Education
Learn how we can help your organization meet its professional development goals and corporate training needs.
Donate to UCLA Extension
Support our many efforts to reach communities in need.