The Modern Formulas Course

Learn How to Analyze Data and Prepare Reports in Excel Faster Than Ever

Are you ready to level up your data analysis 
with Excel's new formulas?

Microsoft has unleashed a wave of powerful new functions in recent years that are transforming how we work with data.

These aren't just minor updates – they're game-changing innovations that can slash your workload in half.

But if you're like most Excel users, you're missing out on these incredible tools.
 You're still using outdated VLOOKUP formulas while your colleagues talk about XLOOKUP.
 You're stuck maintaining complex formulas that could be simplified with modern techniques.
 As Excel continues to evolve, you're worried about falling behind, but you don't know where to start with all these new features.

Introducing Modern Formulas: Your Fast Track to Excel Mastery

Imagine writing a single formula that does the work of an entire column of complex calculations. 

That's the power of modern Excel.

While these new functions might seem intimidating at first, they're designed to make complex problems simple. 

What once required nested formulas and multiple steps can now be accomplished with a single, elegant solution. The future of Excel is here – and it's more powerful and intuitive than ever before.

Stop struggling with outdated formulas. 

It's time to harness the power of Excel's latest innovations.

Welcome to Excel's new generation of formulas. 


We'll guide you through Microsoft's latest innovations, showing you how these powerful new functions can transform your workflow. 

You'll discover how features like formula spilling can automatically handle changing data sizes, eliminating the need for complex array formulas of the past.

CUSTOM JAVASCRIPT / HTML

Dynamic Array Formulas Demystified

CUSTOM JAVASCRIPT / HTML
We'll introduce you to the world of Dynamic Array Formulas, where a single formula can return multiple results. 

In our Modern Formulas Course, we'll guide you through six powerful new functions that will revolutionize how you work with data.

From creating dynamic drop-down lists to building interactive seating charts, you'll discover how these modern tools can automate complex calculations and save you hours of work.
You're Invited to Join the Modern Formulas Course.
The masterclass you need to become a better data analyst.

You're Going to Learn

XLOOKUP

Search and match data like a pro with training on basic lookups, wildcards, closest match for tax/commission rates, 2D lookups, error handling, and more.

Dynamic Array Formulas

Excel’s new functionality returns multiple results with one single formula, allowing you to easily solve problems that were previously impossible.

Spill Range

Learn how to reference formula results in other formulas to simplify calculations and prevent errors.

Error Handling

New error types like #SPILL can be frustrating. You’ll learn how to identify causes and more importantly, prevent errors from happening in the first place.

Analysis Functions

FILTER, UNIQUE, SORTBY, and SEQUENCE are some of the many functions you will learn for quick data analysis and reporting.

Summary Reports

Create dynamic and interactive reports that are easy to use. Your boss will love it. Includes training on drop-down lists, calendar tables, and more.

LAMBDA & LET

These two new functions allow you to simplify complex formulas, improve efficiency and create reusable functions that you can share with your team. Get ready to supercharge your spreadsheets!

From Excel Zero to Excel Hero

“I'm not just that analyst sitting in the corner crunching numbers anymore. I am, I have always been…a problem solver. You and Excel have brought me out of the shadows and are helping me get recognized for the problem solver I have always been.”

Charlotte Goodenow

Quality Engineer Data Analyst
“The training gave me the confidence I needed to get in there and start working, and also the very specific skills that I needed to finish my project. I love that the training [lessons] are bite-sized so I can go in and learn what I need to know and stay on track with my deadlines.”

Kristen Corbler

Project Coordinator & Data Analyst
“I am now the Excel expert in the office and have already increased my earnings well beyond the cost of my investment. Your trainings have helped me learn so much and cement the skills I’ve gained.”

Grant Bagby

Data Analyst
"LOVE the course! My biggest frustration is scheduling my time so I remain consistent in completing the lessons. So far, everything is very easy to understand and I've already applied several of the shortcuts I've learned from the beginner lessons even though I am an experience user."

Kelly Dixon

Program Manager
The course has definitely made me an Excel Hero. Our company has grown since I joined the team and now our CEO who is the excel master refers people to me to help with excel."

Angela Bielanin

Quality Improvement Specialist
In a short period of time I was able to learn valuable techniques and best practices."

Orel Shema

Senior Campaign Manager
If Our Other Students Can Achieve These Incredible Results 
with our Excel Training, Then You Can Too.

So, What's Included?

For just $79, you'll get lifetime access to our course content PLUS our awesome Excel Campus bonuses worth over $700. Some of the topics covered include: 
  • ​​XLOOKUP Overview (10 Bite-Sized Lessons)
  • ​The Spill Range 
  • ​Dynamic Array Formula Errors
  • ​FILTER, UNIQUE and SORT Functions Explained
  • ​Summary Reports
  • ​Drop Down Lists
  • ​Calendar Tables
  • ​New training on LAMBDA, LET, and more! 

Wait, There's More!

$79

Lifetime Access
  • Certificates of Completion
  • Access to our moderated comment sections to get your questions answered by our team
  • ​Free use of our online learning platform with offline viewing capabilities 
  • ​Practice files and downloadable Excel sheets
  • ​Exclusive entry to our Excel Blueprint Training

Frequently Asked Questions

  Do I need to be an Excel expert before starting this course?

No.

We designed this course to be suitable for Excel users at the beginner to intermediate level.  Power Query is a feature of Excel that will save you a ton of time, and we created this program to help make it accessible to more users, regardless of your current skill level.

  What if I get stuck?  Do you provide support?

Yes.

There is a comments section at the bottom of each lesson page where you can ask questions.  Our team of Excel experts here at Excel Campus will help answer your questions.

You will also be able to see questions (and answers) from other members of the program.  

Our goal is to help you learn quickly and efficiently, and we encourage you to ask questions.

  What happens if I'm not satisfied with the program?

If you are unsatisfied with your purchase for any reason, contact us within 30 days of purchase to get a full refund. We want you to be fully satisfied, learn a ton, and produce amazing results!

  How long will it take me to complete the course?

This course has been designed to get you up and running with Modern Formulas quickly.  

You will use the companion Excel files to follow along and get hands on experience with real world examples. 

We made this course short and succinct so that you can start implementing these formulas in your work immediately, to help produce results that matter to your organization.

  Commodo non aliquam ac lobortis?

Lorem ipsum dolor sit amet, consectetur adipisicing elit. Autem dolore, alias, numquam enim ab voluptate id quam harum ducimus cupiditate similique quisquam et deserunt, recusandae.

  Scelerisque enim turpis proin nibh?

Lorem ipsum dolor sit amet, consectetur adipisicing elit. Autem dolore, alias, numquam enim ab voluptate id quam harum ducimus cupiditate similique quisquam et deserunt, recusandae.

  Posuere arcu ultrices nec et?

Lorem ipsum dolor sit amet, consectetur adipisicing elit. Autem dolore, alias, numquam enim ab voluptate id quam harum ducimus cupiditate similique quisquam et deserunt, recusandae.

  Nunc aliquam viverra lacus vitae?

Lorem ipsum dolor sit amet, consectetur adipisicing elit. Autem dolore, alias, numquam enim ab voluptate id quam harum ducimus cupiditate similique quisquam et deserunt, recusandae.

  Sed suspendisse et facilisi eros?

Lorem ipsum dolor sit amet, consectetur adipisicing elit. Autem dolore, alias, numquam enim ab voluptate id quam harum ducimus cupiditate similique quisquam et deserunt, recusandae.

  Sed suspendisse et facilisi eros?

Lorem ipsum dolor sit amet, consectetur adipisicing elit. Autem dolore, alias, numquam enim ab voluptate id quam harum ducimus cupiditate similique quisquam et deserunt, recusandae.

  Sed suspendisse et facilisi eros?

Lorem ipsum dolor sit amet, consectetur adipisicing elit. Autem dolore, alias, numquam enim ab voluptate id quam harum ducimus cupiditate similique quisquam et deserunt, recusandae.

  Sed suspendisse et facilisi eros?

Lorem ipsum dolor sit amet, consectetur adipisicing elit. Autem dolore, alias, numquam enim ab voluptate id quam harum ducimus cupiditate similique quisquam et deserunt, recusandae.

  Sed suspendisse et facilisi eros?

Lorem ipsum dolor sit amet, consectetur adipisicing elit. Autem dolore, alias, numquam enim ab voluptate id quam harum ducimus cupiditate similique quisquam et deserunt, recusandae.

About Your Instructor, 
Microsoft MVP

My name is Jon Acampora and I am your instructor for this course.
I have been using Excel for over 15 years as a financial analyst and systems developer.

Over that time, I have become passionate about learning Excel and finding the fastest and most efficient ways to accomplish a task.

I have been awarded the Microsoft MVP Award (for the past 11 years in a row) for my contributions to the Excel community. 

My mission help others learn and thrive with Excel.

My courses are trusted by thousands of organizations, including: 
CUSTOM JAVASCRIPT / HTML

You Have My Guarantee.

My goal is to help you learn Excel  so you can use your time more productively (instead of wasting it on tedious data preparation).

These skills will allow you to easily maximize efficiency at your organization, and help you gain exposure to top management. But if they don't? You get your money back. No questions asked.

Join Us, 
For This Limited Time Offer

For just $79, you'll get lifetime access to our course content PLUS our awesome Excel Campus bonuses worth over $700.

$79

Lifetime Access
  • Certificates of Completion
  • Access to our moderated comment sections to get your questions answered by our team
  • ​Free use of our online learning platform with offline viewing capabilities 
  • ​Practice files and downloadable Excel sheets
  • ​Bonus training on Excel dashboards 
  • ​Exclusive entry to our Excel Blueprint Training
© 2024 Excel Campus. All Rights Reserved.