Modeling with Excel

Don’t be intimidated by Excel. Boost your productivity with the core functionality you’ll use more than 90% of the time.

Freecontent below!

Learn More

Choose Your Course

Course 01

Get off the Mouse!

Seriously, Get off the Mouse! This course will show you how to save hours of unnecessary work – time you can reinvest in yourself. Stop underutilizing Excel. Come learn the shortcuts to move among sheets, cells, dialog boxes, and task panes. We extend these basics to formulas, paste special, and shapes.

  • 2.0 hours of high-quality video

  • Before/After files

  • PDF slides and reference sheets

  • Hands-on exercises

Course Outline

Introduction

  • How to interact with the course
  • General setup
Watch Preview

Navigation and Selection

Exercise 1

Watch Preview

Keyboard Shortcuts

  • 40 highly useful shortcuts
Watch Preview

Formula Basics

Watch Preview

Paste Special

Exercise 2

Watch Preview

Working with Objects

  • Select, move and align, and resize
  • Snap to grid and snap to shape

Wrap Up

Matthew Herbert

Lead Instructor

Matthew’s 15 years of experience spans Investment Banking, Corporate Finance, and Programming across Banking, Retail, Consumer Products, and eCommerce.

Join others in skyrocketing your skills.

What others are saying about this course!

“It’s the small tips that make the most impact because they add up over time. Retraining my hand eye coordination was hard at first, but so worth it. Thanks!” -Brandon

This Course

Get Off the Mouse!

$99

  • Access for 1 year
  • 2.0+ hours of video
  • 2 exercises with accompanying step-by-step videos
  • Excel: Files
  • PDF: Shortcut key reference sheet
  • PDF: Reference slides
Recommended

The Bundle

Get Off the Mouse!
+
Functions

$168 $198 Save $30

  • Access for 2 years
  • 5.0+ hours of video
  • 4 exercises with accompanying step-by-step videos
  • Excel: Files
  • PDF: Shortcut key reference sheet
  • PDF: Reference slides
Course 02

Functions

~30 “Tier 1” functions will service more than 95% of your needs. Learning these removes complexity and equips you to apply any of Excel’s functions with ease. This course also covers a handful of “Tier 2” functions that address common issues that plague many users. Learning the right functions improves your ability to solve your problem efficiently and correctly. The shortcuts from Course 1, Get off the Mouse, are used throughout this course.

  • 2.5 hours of high-quality video

  • Before/After files

  • PDF slides and reference sheets

  • Hands-on exercises

Course 03

Organize for Efficiency

Organize for Efficiency teaches frameworks for data and formula setup. This will eliminate downstream mistakes and make future updates plug and play. Spend the time doing it right once rather than having to redo it time and time again. You'll also learn effective auditing tools and how to format your files so that data, formulas, and references are easy to identify in a split second.

  • 6.0+ hours of high-quality video

  • Before/After files

  • PDF slides and reference sheets

  • Hands-on exercises

Course 04

Formatting (FREE COURSE!)

Do you struggle to organize and format your Excel files? This free course is the Formatting chapter within Course 3. Come learn how to better organize and format your data with techniques that will improve both your modeling and branding frameworks.

  • 1.0 hour of high-quality video

  • Before/After files

  • PDF slides and reference sheets

  • Hands-on exercises

What Others Are Saying About This Training

Modeling With Excel.

“I’ve seen Matt live. Watching him work in Excel is mesmerizing. He literally was making changes on the fly, real time while I was speaking the changes to him. I’ve never seen that before. After seeing that, I had to learn how to do it myself.” -Sofia

“I was skeptical about the simpleness of the topic, but Matt opened my eyes to see a side of Excel I didn’t know exists.” -Jason

“I wish I would have learned these tools sooner. I don’t want to think of all the time I wasted in Excel. Regardless, onward and upward.” -Molly

Matthew Herbert

Lead Instructor

Matthew’s 15 years of experience spans Investment Banking, Corporate Finance, and Programming across Banking, Retail, Consumer Products, and eCommerce.

Keep Learning! There is More...

Team Training

Looking to train your team?

BizTrix offers the ability to mix and match course content to address team needs, including on-site trainings.

Learn More

FAQs

Why should I take this course?

Who should take this course?

What if I don’t like the course?

Should I take the course if I am using Excel for Mac?

How do I know my payment is secure?

Stay up to date

Don't miss out on any updates and new courses that are coming soon!

We respect your privacy.