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.

Spring 2020 Schedule

Available Format(s):

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

Future Offering (Opens February 03, 2020 12:00:00 AM)
Saturday 8:30AM - 4:30PM
Location: UCLA Extension Lindbrook Center in Westwood
Instructor: Eric Augusta
372995
Fee:
$175.00
See Details
Notes

Enrollment limited; early enrollment recommended. Includes course materials.

Refund Deadline
No refunds after April 03, 2020
Schedule
Type
Date
Time
Location
Lecture
Sat Apr 4, 2020
8:30AM - 4:30PM
UCLA Extension Lindbrook Center in Westwood
UCLA Extension Lindbrook Center 209

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