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.

READ MORE ABOUT THIS COURSE
Classroom
Starting at $175.00
As few as 1 day
0.0
0.8

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.

Fall 2019 Schedule

Available Format(s):

These courses meet in person and make use of an online presence to varying degrees.

Available
Saturday 8:30AM - 4:30PM
Location: UCLA Extension Lindbrook Center in Westwood
Instructor: Eric Augusta
370120
Fee:
$175.00
3 days left. Enroll by Oct 23, 2019
See Details
Notes

Enrollment limited; early enrollment recommended. Includes course materials.

Refund Deadline
No refunds after October 25, 2019
Schedule
Type
Date
Time
Location
Lecture
Sat Oct 26, 2019
8:30AM - 4:30PM
UCLA Extension Lindbrook Center in Westwood
UCLA Extension Lindbrook Center 201

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