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
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
Introduction
Watch Preview
Navigation and Selection
Free!
Click to watch a lesson
Free!
Click to download lesson slide(s)
Exercise 1
Watch Preview
Keyboard Shortcuts
Watch Preview
Formula Basics
Free!
Click to watch a lesson
Free!
Click to download lesson slide(s)
Watch Preview
Paste Special
Free!
Click to watch a lesson
Free!
Click to download lesson slide(s)
Exercise 2
Watch Preview
Working with Objects
Wrap Up
Matthew’s 15 years of experience spans Investment Banking, Corporate Finance, and Programming across Banking, Retail, Consumer Products, and eCommerce.
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
~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
Introduction
Watch Preview
Data Types and Formulas
Free!
Click to watch a lesson
Free!
Click to download lesson slide(s)
Watch Preview
Lookup and Positioning Functions
Watch Preview
String Extraction and Manipulation Functions
Free!
Click to watch a lesson
Free!
Click to download lesson slide(s)
Exercise 1
Watch Preview
Logic Functions
Watch Preview
Summation Functions
Free!
Click to watch a lesson
Free!
Click to download lesson slide(s)
Watch Preview
Date and Time Functions
Watch Preview
Statistics and Math Functions
Exercise 2
Watch Preview
Spill Functionality
Watch Preview
Tier 2 Functions
Bonus
Wrap Up
Matthew’s 15 years of experience spans Investment Banking, Corporate Finance, and Programming across Banking, Retail, Consumer Products, and eCommerce.
What others are saying about this course!
“I learned some really useful functions in this lesson that simplify many of those other functions I was using. I see now that blindly searching the Internet for functions often resulted in complex formulas which I don't fully understand.” -Kate
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
Introduction
Watch Preview
Data Types and Operators
Free!
Click to watch a lesson
Exercise 1
Watch Preview
Dynamic Arrays and LAMBDA
Free!
Click to watch a lesson
Exercise 2
Watch Preview
Data and Tables
Free!
Click to watch a lesson
Exercise 3
Watch Preview
Dynamic Patterns
Free!
Click to watch a lesson
Exercise 4
Watch Preview
Formula Auditing
Free!
Click to watch a lesson
Exercise 5
Watch Preview
Formatting
Free!
Click to watch a lesson
Exercise 6
Watch Preview
Excel Options
Wrap Up
Matthew’s 15 years of experience spans Investment Banking, Corporate Finance, and Programming across Banking, Retail, Consumer Products, and eCommerce.
What others are saying about this course!
"Once I saw dynamic patterns, it was like a light bulb going off. Why didn't I do this sooner with my models? And the spacer concept? Spot on. I'll always implement these."-Mark
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
Introduction
Watch Preview
Format codes and colors
Free!
Click to watch a lesson
Presentation ready tables
Format tools
Apply custom color palettes
Worksheet settings
Customize formats for built-in features
Wrap Up
Matthew’s 15 years of experience spans Investment Banking, Corporate Finance, and Programming across Banking, Retail, Consumer Products, and eCommerce.
What others are saying about this course!
“I wish I had this course when I came out of college. I always knew my struggle to organize and format my data on Excel’s white canvas was a drag on productivity, but I didn’t know what else to do. This course offered lots of inspiration and direction.”-Sam
“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’s 15 years of experience spans Investment Banking, Corporate Finance, and Programming across Banking, Retail, Consumer Products, and eCommerce.
BizTrix offers the ability to mix and match course content to address team needs, including on-site trainings.
Learn More
We believe in building from the ground up, regardless of level. We’ve worked with Excel users across all levels and even those who classify themselves as “expert” have benefited from our courses. Elite proficiency saves hours of time and builds a strong foundation for subsequent concepts, especially if you want to learn Excel VBA. We teach the functionality that unlocks these success-yielding efficiencies, which are applicable in any Excel-based role.
These courses aren’t just for Investment Bankers or Corporate Finance professionals. We have trained professionals in Finance, Sales, Marketing, Operations, and Analytics. If you use Excel in any capacity, these courses are for you.
If you are unsatisfied with the course, let us know. We’ll refund your purchase provided you contact us within 30 days of purchase and refrain from watching more than 25% of course content.
Microsoft built its software for PC platforms, so full functionality is designed for PCs. Thus, courses are designed and taught with a PC. Shortcut keys may be different across PC and Mac, but functionality is nearly identical, and the techniques are agnostic. For example, Ctrl+S (PC) = Command+S (Mac).
We accept payment via Stripe. All payments are processed securely using 128-bit SSL encryption. Furthermore, we encrypt all the data passing between our site and your device using HTTPS.
Don't miss out on any updates and new courses that are coming soon!
