Eric W. Augusta & Associates

Navigating The Road to EXCEL-lence

Menu

Major Topics Covered

Intermediate Seminar

  • Customize the QAT to create a high performance Excel environment
  • Create a macro in 3 minutes that can save you 15+ hours a year
  • Use Excel's built in forms to make your models super user friendly
  • Learn how the "Flash Fill" feature can save hours of painful date manipulation.
  • Why a VLOOKUP is a better choice than a “Nested IF” statement
  • How the CAMERA function can save hours of formatting frustration
  • Replace multiple charts with a single, DYNAMIC chart
  • Understand the advantages of using a "horizontal" timeline architecture approach in financial models
  • Use GOAL SEEK to set the required output of a model and then instantly find the correct input value that corresponds
  • See why SUBTOTAL and SUMIFS may become your favorite new Excel functions
Intermediate Seminar Details

Frequently Asked Questions

What Seminars are offered?

I currently offer a 6-7 hour intermediate level seminar titled "Excel Tips and Techniques for Increased Productivity and Improved Financial Modeling"

Where is this seminar offered?

Options include:

  1. At your location in the greater LA area.
  2. At my location near LAX (for groups of 8 or less).
  3. Through UCLA Extension
    Website: www.uclaextension.edu
    Course # 831.81
  4. Through CalCPA (course "ETTI")
Do I need to bring a computer?

Computers are not required, but participants are welcome to bring their own laptops.

Why is the Seminar unique?

Because the instructor, Eric Augusta, has 20 plus years of finance / accounting experience; is a certified Excel Expert; has received letters of commendation from UCLA Extension for his teaching ability and most importantly, the seminar topics have been selected from REAL WORLD situations... not from an "ivory-tower" perspective.

Eric W. Augusta & Associates

Click to view a Course Description and Pricing

Intermediate Course