The Modern Formulas Course
Learn How to Analyze Data and Prepare Reports in Excel Faster Than Ever
Join thousands of people that are working smarter in Excel
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.
Introducing
The Modern Formulas Course
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.
“ I used the XLOOKUP on my test data to identify those results where no information had been supplied in the dataset. Worked a treat! Less issues than when using the VLOOKUP. Looking forward to watching the remaining videos on the XLOOKUP. ”
Sheena Raimondi-Monroe
UI/UX Designer
Dynamic Array Formulas Demystified
Say goodbye to outdated formulas and obsolete Excel skills.
Lighten your workload and free up time for promotion-worthy work.
Increase efficiency in the workplace and help you company's bottom line.
End the cycle of working overtime and weekends to get everything done.
We'll introduce you to the world of Dynamic Array Formulas, where a single formula can return multiple results.
From creating dynamic drop-down lists to building interactive reports, you'll discover how these modern tools can automate complex calculations and save you hours of work.
You'll also master spill ranges and learn how to handle and prevent new types of formula errors.
This in-depth training will help you 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!
Hear From Some of Our
Happy Students
What's Included
Everything you need to master AI in Excel
Step-by-step video lessons
AI prompt templates & guides
Direct support with comments section on every lesson page
Access via our mobile app or any device
Downloadable Excel practice files
Lifetime access to all course materials
Certificate of Completion that you can add to your LinkedIn Profile
30-day money-back guarantee
Get Lifetime Access for:
$197 $97 (Save 50%)
Join the Modern Formulas for Excel Course
Meet Your Instructor
Jon Acampora
Microsoft MVP
Excel Campus Founder
15+ Years Teaching Experience
My mission is simple: to help you succeed with Excel. After experiencing the "overtime blues" in my own corporate finance career, I dedicated myself to mastering the tools that create automation and drive real business value.
As a Microsoft MVP for over 10 years, I've had the privilege of helping millions of viewers on YouTube and my blog (excelcampus.com) and guiding thousands of students in my training programs to become the Excel Heroes of their organizations.
Now, I want to share that same blueprint with you!
Trusted by Professionals at World-Class Companies:
Frequently Asked Questions
No.
We designed this course to be suitable for Excel users at the beginner to intermediate level. Excel formulas are 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.
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.
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!
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.
There are about 5 hours of video lessons included in the course. Each lesson is about 5 to 7 minutes in length and covers a specific topic, formula, or scenario. This makes it easy for you to complete lessons as time permits.
You get lifetime access to the course. You can watch whenever you want, as often as you want. You can also access the course from any device including our mobile app.
Yes.
When you complete any of our courses you will earn a Certificate of Completion.
The certificate includes the number of training hours and skills mastered.
Each certificate is shareable, including its own certified web page that you can share with employers.
You can also easily add the certificate to your LinkedIn profile, share it on social media, add a badge to your email footer, include in your resume, print and frame it, and more.
We love celebrating our members' success and look forward to supporting you in your journey to learn and grow.
The new dynamic array functions and formulas are available on Excel 2021 and later for Windows and Mac.
Ideally, you'll want to have a Microsoft 365 account to get access to the latest functions and features, as they are not backwards compatible.
However, if you don't have access to a modern version of Excel, you can also use the free web version of Excel for the course. The web version contains all the latest function updates and is a great way to access new features.
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 Modern Formulas for Excel
During This Limited Time Offer
For just $197 $97, you'll get lifetime access to our course content PLUS our awesome Excel Campus bonuses worth over $700.
$197 $98 USD Save 50%
Join Today and Get Lifetime Access