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.
We use cookies to understand how you use our site and to improve your experience, including personalizing content and to store your content preferences. By continuing to use our site, you accept our use of cookies.
Read our privacy policy.
