Excel Modeling Tips and Techniques for Improved Productivity: Intermediate
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.
Get More Info
What you can learn.
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.