Josh Aharonoff – Everything You Can do in Excel Course 2025

Master Excel from the ground up and unlock every feature to work faster, smarter, and with total confidence. From beginner to power user, this course helps you save hours, impress at work, and truly own Excel.

Josh Aharonoff – Everything You Can do in Excel Course 2025

Learn all of Excel’s features to buy back your time
Everything You Can Do In Excel is your quick path to Excel mastery, whether you’re a beginner or have some experience.

If you’ve only used the Home tab or tried to learn Excel but got confused, this course will help you break through.

We start from the basics and teach you every single feature inside Excel.

By the end, you’ll know Excel inside and out. You’ll work faster, make better decisions using data, and get the most output from this powerful tool.

What’s the difference between

Professionals who effortlessly navigate Excel to boost their productivity and impress their managers
and those who waste hours struggling with basic functions while watching their career opportunities pass them by?
❌ If you think memorizing every formula is the answer, you’d be wrong.

❌ If you believe you need to be a “numbers person,” you’d still be wrong.

​❌ And if you thought spending hours watching countless boring tutorials was the key, you couldn’t be further from the truth.

​✅ Here’s the reality: learning Excel doesn’t have to be complicated.

Whether you’re:

​An ambitious professional climbing the corporate ladder
A manager overseeing teams and projects
A freelancer juggling projects
A business owner making data-driven decisions
A fractional CFO presenting financial data to stakeholders
Or you are just about to enter the workforce​
Your career success increasingly relies on your ability to use the power of Excel.

Do you know without a doubt that

You’re not using Excel as efficiently as you could be?
Your basic spreadsheet skills leave you anxious when asked to perform even simple Excel tasks, in person or on calls.
If so, you’re not alone. Here’s why:
Most of us received little to no Excel training in school or university. Yet when we enter the workforce, the demands are drastically different. Suddenly, we’re expected to be Excel wizards, effortlessly manipulating data and creating insightful reports.

But here’s the good news
In just a month, you could be looking back on this moment as the time everything changed. Picture yourself confidently solving any Excel challenge, saving hours each week, and truly living up to that “proficient in Excel” claim on your CV.

Excel is supposed to be an easy-to-use tool that helps you save time.
But for many professionals, it’s more like that complex tool you know you should understand, but somehow always leaves you scratching your head. Here’s what a typical Excel experience might look like for you:

Your manager asks you to analyze some data in Excel. You nod confidently, but inside, you’re already worrying that they’ll discover you’re not as proficient as you claimed.
You open Excel, feeling overwhelmed by all the lines and buttons. You can’t focus or narrow down what you’re supposed to do.
You waste time trying to figure things out in your spreadsheets, then spend hours Googling for help. At the end of the day, when you ask yourself what you’ve accomplished, you know the answer is “nearly nothing.”
When you finally hand in the task, you’re hoping no one asks too many questions about what you did. When they do, you find yourself stumbling through explanations.
You go home wondering if what you did will cause major problems down the line.
You deserve to approach Excel with confidence, not fear. Here’s how your work could look like:

You receive an assignment and smile, genuinely excited about the opportunity.
Excel opens, and it’s like coming home. Every function and menu is familiar, ready to serve your needs.
No more wasting hours on Google. You apply the right functions and formulas. What used to take all day now takes an hour.
You confidently share your findings with beautifully designed reports. You easily explain your method and make on-the-spot adjustments when asked.
You even show your coworker a shortcut that turns hours of work into minutes.
The truth is, in today’s data-driven workplace, being uncomfortable with Excel is like having a pebble in your shoe. It always bothers you and makes you worry about your job security. But what if you could change this narrative?

4 Reasons You’re Still Struggling with Excel

Reason #1: You’re Overwhelmed by Excel’s Vast Array of Features

​It’s easy to get confused when trying to master Excel on your own.

50 Google searches and a dozen YouTube tutorials later and you ask yourself “What the heck did I just watch”

What you need: You don’t have to be an Excel guru to dramatically improve your productivity and confidence with spreadsheets.
You just have to understand all of Excel’s capabilities.

And I’m about to show you how you can transform your relationship with Excel from a source of stress to a powerful tool in your professional toolkit.

Reason #2: You’re Still Treating Excel as Just a Spreadsheet Tool

​Excel is much more than just rows and columns.

There’s a huge difference between using Excel as a glorified calculator and leveraging it as a powerful data analysis and decision-making tool.

Being aware of Excel’s true potential informs every decision you make in your work.

Excel can transform the way you approach problems and make decisions in your professional life.

There’s no need to pay for separate tools that only perform specific functions.

All these features are readily available at your fingertips within Excel itself.

Reason #3: You think Excel is outdated and will soon be irrelevant

​”Is Excel still relevant?”

It’s a question I hear often, and it’s holding many back from investing time in this powerful tool.

​Let me put your mind at ease: Excel isn’t going anywhere.

​In my role as a fractional CFO, I’ve worked with companies of all sizes – from small startups to businesses earning eight figures.

Across the board, Excel remains an essential tool.

​There’s not even a whisper about moving away from it.

Reason #4 The assumption that struggling with Excel means you’re not cut out for your job.

“I’m just not a numbers person. My brain doesn’t work that way.”

​WE should stop this stereotype once and for all.

​Excel is a skill anyone can learn with the right approach.

​You just didn’t have the right training.

Then you’ve been thrown into the deep end at work, pressured to handle advanced tasks before mastering the basics.

​That’s the real problem.

​We’re changing that. We’re building a solid foundation first, period.

What you need: Learning Excel doesn’t require sitting through hours of boring lectures.

No wonder people put off learning!

​My course uses interactive, engaging methods that make learning enjoyable.

If endless Googling, YouTube tutorials, and Excel books haven’t worked for you, there’s a better way.

If you’ve been following my content, you’ve probably noticed my ability to explain complex topics in the simplest terms, together with beautiful visuals.

This approach received so much positive feedback that it inspired me to take it even further with our new course. Here’s what makes my method unique:

Full Excel Tour: I dive into every single button and feature across all Excel tabs.
Beginner-Friendly Approach: Whether you’re a complete novice or a long-time Excel user, I start from scratch. I don’t expect any knowledge from you
Visual Learning: We leverage clear, engaging visuals to make even the most complex Excel concepts easy to grasp.
Practical Application: You’ll practice using Excel in real-life situations with my handpicked homework.
Grasp commonly missed basics and rapidly advance to expert techniques
Use shortcuts to save time and get more done
Select and apply the best formulas for every situation
Use little-known tools to turn chaotic data into organized, useful information
Build professionally designed Excel documents
Boost your career options and promotion chances with enhanced Excel skills

Instructor
Josh Aharonoff
Founder & CEO of Mighty Digits

Hey there! I’m Josh Aharonoff, but you might know me better as “The CFO Guy.”

Like many people, I first started using Microsoft Excel around high school.

But it was only through starting my career at the Big 4, and then eventually opening up my own fractional CFO agency, that I truly mastered it.

Throughout my career, Excel has been my constant companion.
I found myself returning to an Excel sheet every single day.

I’ve used it for everything from basic formatting to building complex reports and dashboards that have helped my clients raise millions in VC funding.

I attribute a large part of my success to Excel.

I love Excel so much that I created a plug-in that gives you access to tons of different templates for finance and accounting.

Now, I spend my days teaching Excel, finance, and accounting to over 400,000 followers on LinkedIn and 90,000 newsletter subscribers.

It’s no wonder Excel has become my favorite tool, and I’m here to make it yours as well.

Introducing Everything you can do in Excel
Transform from Excel novice to spreadsheet expert by mastering all the key functions and possibilities within Excel’s main tabs.

This solid foundation will prepare you for more advanced topics down the road.

Course content
14 sections•110 lessons•6 hr 34 min

Introduction to Everything You Can Do In Excel
3 lessons • 7 min

1.01 Course Intro
02:05
1.02 Meet Your Instructor
02:20
1.03 How To Use This Course
03:10
Starting with the Basics
6 lessons • 22 min

2.01 What Is An Excel Spreadsheet?
02:16
2.02 File Extensions
02:24
2.03 Different Versions Of Excel
01:25
2.04 Excel Objects
08:32
2.05 Getting To Know Our Excel File
05:28
2.06 Navigating Through The Tabs
02:23
Getting To Know Cells
3 lessons • 7 min

3.01 Cell Navigation
02:07
3.02 Cell Formulas
03:08
3.03 Absolute References
01:53
File Ribbon
2 lessons • 7 min

4.01 File Overview
02:28
4.02 Options
04:55
Home Ribbon
17 lessons • 47 min

5.01 Introduction To Home Ribbon
02:02
5.02 Clipboard
02:05
5.03 Font
01:09
5.04 Alignment
01:25
5.05 Number
02:04
5.06 Styles
02:04
5.07 Cells
01:18
5.08 Editing
03:13
5.09a Analyze Data
00:55
5.09b Add – Ins
01:00
5.10 HW – Home Ribbon
01:47
5.11 HW – Be Special
04:10
5.12 HW – Create A KPI Box
11:37
5.13 HW – Create Vertical Date Headers
02:54
5.14 HW – Add Arrows To Your Text
05:41
5.15 HW – Highlight Best Vs Worst
02:47
5.16 HW – Select All Assumption Cells
01:41
Insert Ribbon
16 lessons • 1 hr 16 min

6.01 Introduction To Insert Ribbon
00:44
6.02a Tables
05:05
6.02b PivotTables
03:04
6.03 Illustrations
00:48
6.04 Charts
04:45
6.05 Tours
6.06 Sparklines
01:27
6.07 Filters
00:44
6.08 Links & Comments
01:09
6.09 Text, Equations & Symbols
02:55
6.10 HW – Insert Ribbon
01:21
6.11 HW – The Power of Tables
07:05
6.12 HW – PivotTable Profit & Loss
16:03
6.13 HW – Create A Cover Dashboard
06:51
6.14 HW – Chart Dashboards
21:35
6.15 HW – Sparkline P&L
02:46
Page Layout
10 lessons • 21 min

7.01 Introduction To Page Layout
00:46
7.02 Themes
01:23
7.03 HW – Tell Me I’M Pretty
01:51
7.04 HW – Create A Theme
04:05
7.05 Page Setup
02:35
7.06 Scale To Fit & Sheet Options
01:14
7.07 HW – Print A Board Deck
02:58
7.08 Arrange
02:16
7.09 HW – Arrange Them
02:51
7.10 HW – Align Them
01:27
Formulas
9 lessons • 34 min

8.01 Introductions To Formulas Ribbon
01:35
8.02 Insert Function & Function Library
01:27
8.03 Defined Names
02:11
8.04 Formula Auditing
04:13
8.05 Calculation
02:52
8.06 HW – My 4 Favorite Functions
08:24
8.07 HW – Give it a name
08:52
8.08 HW – QA An Error
03:27
8.09 HW – Change Calculation Options For Data Tables
01:31
Data Ribbon
17 lessons • 1 hr 10 min

9.01 Introduction To Data Ribbon
02:23
9.02 Get & Transform Data
04:41
9.03 Queries & Connections
04:34
9.04 Data Types
02:10
9.05 Sort & Filter Option
02:11
9.06 Data Tools – Pt I
02:59
9.07 Data Tools – Pt II
04:34
9.08 Forecast
03:36
9.09 Outline
03:07
9.10 HW – Powerquery Accounts Payable
20:32
9.11 HW – External Links
01:59
9.12 Hw – Custom Sort
02:52
9.13 HW – Create A Scenario
01:51
9.14 HW – Find The Optimal Price
00:51
9.15 Showcase 3 Scenarios In 1 View
02:25
9.16 HW – Group, Ungroup, And Subtotals
03:14
9.17 HW – Get Validated
06:07
Review
9 lessons • 13 min

10.01 Introduction to Review
01:05
10.02 Proofing
01:17
10.03 Accessibility, Insights, and Language
01:31
10.04 Changes
01:21
10.05 Comments & Notes
01:46
10.06 Protect Section
01:43
10.07 Ink Section
01:15
10.08 HW – Stay protected
02:33
10.09 HW – Comments & Notes
01:25
View
7 lessons • 11 min

11.01 Introduction To View
00:52
11.02 Sheet View
01:11
11.03 Workbook Views
00:38
11.04 Show & Zoom
02:34
11.05 Window
03:13
11.06 Macros
00:18
11.07 HW – Staring Out The Window
02:59
Developer
7 lessons • 19 min

12.01 Introduction To Developer
02:30
12.02 Code
01:32
12.03 Add-Ins
01:16
12.04 Controls
02:02
12.06 HW – Create A Basic Macro
07:49
12.07 HW – Create Chart Buttons
01:18
12.08 HW – Month End Close Checklist
03:22
Help
1 lesson • 1 min

13.01 Help & Community
01:18
Course Wrap Up And Next Steps
3 lessons • 52 min

14.01 Course Wrap Up & Next Steps
04:36
14.02 Bonus 1 – 18 Excel Functions for Accountants
17:49
14.03 Bonus 2 – 25 Excel Tips & Tricks
29:55