Excel Modeling Tips and Techniques for Improved Productivity: Advanced

MGMT 831.812

This one-day seminar is for solid intermediate to slightly advanced Excel users who want to learn tips and techniques that will take their model-building skills to the next level.

READ MORE ABOUT THIS COURSE

What you can learn.

  • Learn to use the OFFSET function, three-dimensional consolidations, INDIRECT, SUMPRODUCT, VLOOKUP using INDEX and MATCH, advanced filtering, data tables, pivot tables, named ranges/Name Manager
  • Be introduced to Excel VBA (Visual Basic for Applications), writing simple macros and creating a simple UserForm
  • Understand circular reference pros and cons
  • Explore demo models

About this course:

This one-day seminar is primarily intended for solid intermediate to slightly advanced Excel users who want to learn tips and techniques that will help them take their model-building skills to the next level. Topics include the OFFSET function, three-dimensional consolidations, INDIRECT, SUMPRODUCT, VLOOKUP using INDEX and MATCH, advanced filtering, data tables, pivot tables, named ranges/Name Manager, introduction to Excel VBA (Visual Basic for Applications), writing simple macros and creating a simple UserForm, circular reference pros and cons, and much more. Demo models are discussed and made available to attendees. Computers are provided for hands-on learning using Windows/Microsoft Office Excel for PC.
Suggested Prerequisites

It is advisable that you complete the following (or equivalent) since they are prerequisites for Excel Modeling Tips and Techniques for Improved Productivity: Advanced.

831.81 Excel Modeling Tips and Techniques for Improved Productivity: Intermediate.

Contact Us

Speak to a program representative. Hours: Mon-Fri, 8am-5pm.
Keep up to date on the latest news and offerings in Finance

vector icon of building

Corporate Education

Learn how we can help your organization meet its professional development goals and corporate training needs.

Learn More

vector icon of building

Donate to UCLA Extension

Support our many efforts to reach communities in need.

Innovation Programs

Student Scholarships

Coding Boot Camp

Lifelong Learning