Teach on Udemy

Turn what you know into an opportunity and reach millions around the world.

Learn More

Your cart is empty.

Keep shopping

100+ Excel Formulas to Work Faster, Smarter, Impress at Work

Name: 100+ Excel Formulas to Work Faster, Smarter, Impress at Work
Rating: 4.7 (258 reviews)

Stop guessing in Excel. This practical course teaches formulas with clarity, confidence, and no fluff.

Created byRami Abou Jaoude

Last updated 5/2025

English

What you'll learn

EFFICIENCY: Learn to work SMARTER in Ms Excel not HARDER
DONT MEMORIZE: Microsoft Excel Formulas are like Cooking. Learn the structure to write dynamic and powerful functions from 0
PRACTICAL: Learn Formula that you will use in real life (text manipulation, counting, summing, conditions, lookups)
PRO: Get Access to tips and tricks that will stay with you forever
EXPERIENCE: FROM EX HARVARD, MCKINSEY CONSULTANT & HEAD OF ADVANCED ANALYTICS IN BIG INSTITUTIONS
ALL LEVELS: Get access to a well structured course that goes from NOOB to Expert / Advanced level with Dynamic Array Formulas that you find in Office 365
FUN: Straight to the point yet entertaining lectures
LIFETIME: Access to HOURS of material such as lectures, practice sheets, quizzes and others

Course content

9 sections • 114 lectures • 8h 42m total length

L01 Housekeeping & expectations3:22
Housekeeping items
Building expectations
L02 Understanding the degree of difficulty of each lesson - the star concept1:05
Want to navigate the course better and see the lessons more adapted to your level? Understand the Star Concept!
All Material for Course0:07
Objectives of the section

L01 Material to Download for Section0:07
Material for the section
L02 Excel Formula Syntax (**)10:25
Understand the Syntax used in Excel for every formula. This way, once you see a new formula, you will be able to dissect it quickly. See a practical example on how to write/insert formulas (including nested formulas) and get the definition of each formula
L03 Referencing other Workbooks or Worksheets (*)4:46
Learn how to reference a cell in 1) Another Sheet 2) Another workbook + Tips to drag the formula
L05 Cell Referencing (**)7:32
You need to set the right cell reference before dragging a formula! Learn how to use the $ sign to achieve your purpose
L07 Common Error types (**)5:41
Learn about the 7 most common errors in Excel and how to fix them
L08 Formula Auditing Part 1 (***)3:35
How to:
Check all the cells that have a formula (including shortcut)
Trace dependents cells to audit an find the root cause of an error
L09 Evaluate Formula & Error Checking (*)2:44
How to:
Use Evaluate formula to get the root cause of an error
Use the Error checking features in Excel
L14 PC & Mac Extensive Shortcut List (*****)0:24
Extensive list of shortcuts for both PC and Mac
L15 Increase the size of the Text in the Formula Bar (*****)1:16
How to increase the size of the Text in the Formula Bar so everybody can see it in the meeting
L16 Basic Excel Formulas you need to know (*)8:04
So far, we learned the fundamentals to be able to use Excel. Now, it is time to learn some of the most used basic formulas so you can directly apply them at work.
Test your might! - Formula 101

L01 Material to download for Section0:07
Material for the section
L02 If Statement (*)6:32
Learn the IF statement:
Parameters
How to write a simple IF with hard coded values
How to refer to cells for the different parameters
How to have a formula as parameter
The parenthesis and colors
L03 Nested IF Statement (**)5:19
Learn how to write multiple IF statements within each others
L04 And / Or Conditions (***)3:46
Understand the value of And/Or statement in an IF statement (vs Nested IF)
L05 Not <> with IF (*)3:01
How to use the <> and NOT function within an IF statement
L06 IFS statement & Emojis trick (*****)7:37
Learn how the IFS statement can be much better than the IF statement in situations where you have a lot of conditions. In addition, I will show you a cool Emoji trick for your reports
L07 IFerror (**)2:05
Learn a quick formula to fix errors you might get from your other formulas.
L08 Isxxx statements + Row coloring trick (***)6:13
Discover all the isxxx statements (isnumber, iserror, isodd, iseven, isblank, istext) and how to use them in real life. Learn a trick to color alternative rows quickly.
L09 IF with partial match - Pro trick (*****)8:01
Pro trick to write an if statement with Partial match using the search / Find formula.
Test your might! IF statements and Logical Operators

L01 Material to download for Section0:07
Material for the section
L02 Round (Normal, Up or Down) (*)5:56
Get familiar with the round functions in Excel
L03 Popular Stat functions (***)8:27
Learn how some of the most popular stat functions such as mean, mode, median, max, min, variance and standard deviation
L04 Ranking Basics (**)7:22
Discover:
Small and large to find the smaller/largest nth value in your data
Rank formulas
Percent Rank formulas
L05 Percentile (***)4:50
Understand the difference between % and Percentile and learn how to calculate percentiles (several formula options)
L06 Dealing with Randomness (*)2:44
See different formulas & trick to generate random numbers:
Rand
Randbetween
Randarray (Office 365)
L07 Ratios in Excel (***)5:14
Discover how to use the GCD formula to create rations in Excel
L08 Sumproduct - Basic Use (**)2:17
Know the most common use of the SUMPRODUCT formula
L09 Master Sumproduct (*****)10:06
If you want to be advanced in Sumproduct, you have to learn how to use it for filtering. In this lesson, you will learn:
How to filter
How to do and conditions
How to do or conditions
L10 Countifs, Sumifs, Averageifs (***)9:53
Explore the difference between:
Countif and countifs
Sumif and sumifs
Averageif and averageifs
L11 Sumifs with Dates + EOMonth formula (***)7:10
Apply your sumifs knowledge on date and learn a trick with the eomonth formula
L12 Build a Dynamic Mini Dashboard with Sumifs, Countifs, AverageIf (***)5:19
Practical example of a mini dynamic dashboard with some of the formulas we learned in the course
L13 Identify and Count Duplicates in 1 step + Range Name (*****)4:18
Be able to quickly identify and count duplicates in 1 step with Sumproduct and Countif. Use Name Range to make the formula easier to read
L14 Sumif with Partial Match (****)6:11
Perform sumif, averageif, countif with partial match:
Use the * sign
Use the ? sign
L15 Control Shift Enter (*****)5:36
Understand when to use Control Shift Enter to deal with Array formulas in older versions of Excel.
L16 MinIFs, MaxIfs & Aggregate - How to get min/max with conditions (*****)7:55
Learn how to get min and max with conditions:
Excel 365: MinIFS & MaxIFS
Older versions: Aggregate & Large/Small
Test your Might! All About Stats

L01 Material to download for Section0:07
Material for the section
L02 Named Ranges & Excel Tables (**)5:13
If you want to simplify your formula and make it more readable, you can use:
Named Range
Excel Table
L03 Vlookup / Hlookup (*)8:44
Learn the basics of Vlookup & Hlookup
L04 Row, Rows, Column, Columns practical application (****)9:46
Learn all syntax to write Row, Rows, Column, Columns formulas
See practical applications of the formulas
L05 Joining Data with Vlookup (***)6:32
Real life example on joining data using vlookup. You will learn:
One drawback of vlookup
How to optimize your column_index
L06 Improve your Vlookup with an Excel Table (*)1:50
Get rid of problems such as increasing data by transforming your reference Table to an Excel Table.
L07 Troubleshoot your Vlookup (**)3:46
See multiple examples of the most common errors in Vlookup. As a bonus, troubleshoot date issues.
L08 Approximate Match for Vlookup for lookup within boundaries (****)2:49
Scenario where you can use approximate match to solve your business problem
L09 Index Match Basics (***)7:39
Learn the Basic syntax of Index + Match to perform lookups. This includes a more complex case where you look up values in an array of values
L10 Index Match Advanced (*****)5:59
Advanced Index Match Trick to deal with lookup data in multiple cells
L11 Lookup in different sheets with Indirect (*****)4:51
Use the Indirect formula to lookup values in different sheets without having to change the formula
L12 Reverse Lookup problem (*****)5:20
Real life Example of having to use multiple index and match within 1 formula
L13 Complex Lookup with Index & Sumproduct (*****)5:16
Combine Index and Sumproduct for a complex lookup scenario
L14 Xlookup (***)10:22
Learn the syntax of Xlookup
Discover some of the benefit of this new function
L15 Cool HR Dashboard with XLOOKUP (***)11:21
Apply your Xlookup knowledge to build an HR Dashboard!
L16 Choose Formula and its applications (****)7:56
Learn some cool ways to use choose in Excel:
Rolling average
Perform selective calculations
perform calculations on difference ranges
L17 Offset with Rolling average example (****)4:00
Understand the basics of the Offset formula. See a real example of how to calculate a rolling average.
L18 YTD Calculations with Offset & Sumproduct (*****)10:14
See the difference between the NOOB vs Pro approach to calculate YTD numbers
L19 Offset and Charts (****)5:46
Practical example of a cool chart with dynamic ranges
L20 Multiple Matches (*****)6:08
Trick to get multiple matches from lookup
Test your Might! Lookups

L01 Material to download for Section0:07
Material for the section
L02 New Formulas to Arrange your Data (***)8:35
Save lot of time with Flash Fill!
L03 Changing the Case of Text (**)2:06
Use formulas to change the case of text:
Upper
Lower
Proper
Learn how to remove extra spaces with Trim
PS: Check out font options to change the case of your text:
www.dafont.com
www.1001freefonts.com
www.fontsquirrel.com
L04 Concatenate Text (**)5:11
4 ways to concatenate text:
Concatenate
&
Concat
Textjoin
L05 Text Extraction (**)3:53
Learn the basics of text extraction:
Left
Right
Mid
Len
L06 Text & Value (***)5:23
Learn how to use Text & Value formulas. Touchbase on a custom formatting trick
L07 Search & Find practical application (**)2:05
Get to know the difference between Search & Find and use the formulas in a practical context
L08 Combining Search & Find with other functions for powerful results (***)1:44
Learn another practical use of search/find formulas to extract info from text
L09 More Complex example with Search/Find (****)4:55
Learn how to combine, Len, Right, Left, Search to extract info from text
L10 Substitute (***)1:51
Learn the basic to replace subtext within a text
L11 System Data (*****)4:57
How to clean spaces coming from system data and special characters
L12 Splitting Text with TextSplit, TextBefore and TextAfter (****)7:14
Those 3 formulas in the newest versions of Excel will make your life way easier. you Can split text, extract text before / after a delimiter
L13 Translate (***)4:06
Learn how to use Translate and DetectLanguage
L14 Generate Bar Codes and QR Codes (***)3:13
Let's use the image function to generate bar codes and QR codes with the help of a free 3rd party site.
L15 REGEX (****)4:25
Learn how to extract and replace text just by indicating the pattern!
Test your Might! Dealing with Text

L01 Material to Download for Section0:07
Material for the section
L02 Dates Basics (*)4:12
Basic understanding on how dates are structured in Excel
L03 Flash fill & Format (*)2:07
Learn the different options with flash fill and dates & how to fix the date format
L04 Today & Now (*)1:16
Learn 2 very useful basic dates formulas: Today and Now
L05 Date fields extraction (*)1:26
Some more basic formulas to get the year, month, day, hours, minutes and seconds from a date
L06 Get First/Last day of the month and First day of the year (***)3:35
Discover how to use the EOMONTH formula to get:
Last day of the month
First day of the month
First day of the year
L07 YearFrac (**)2:15
Calculate the percentage of time between 2 dates and vs 1 year
L08 Workday & Workday.Intl (***)4:24
Deep dive into how to calculate deadlines with holidays, weekdays, etc...
L09 Networkdays, Networkdays.INTL + Changing holiday list (****)4:25
Deep dive into Networkdays and Networkdays.INTL
Learn the difference with Workday and Worday.INTL
Apply a cool trick to modify holidays based on selection
L10 Weekday (**)2:47
Lear how to use:
Weekday with the different options
Weekday as text
L11 Count Fridays between 2 dates (****)3:06
Practical example to use formulas: Learn how to count the number of Fridays or any day between 2 dates.
L12 Define a custom weekend in Networkdays (*****)1:41
Pro trick to define a custom week end that feeds into your networkdays formula
Test your Might! Date & Time

L01 Material to download for Section0:07
Material for the section
L02 Conditional formatting rules with formula (****)6:25
Tricks and explanation on how to do conditional formatting with formulas
L03 Boring Mod used in a Powerful way (*****)13:15
Learn how to use boring and seemingly useless functions such as NA() and Mod() to achieve dynamic reports, charts and analysis
L04 Conditional formatting with logical operators (***)3:43
More complex formulas used in combination with conditional formatting
L05 Adding icons to your reports (****)7:19
2 methodologies to add icons to your reports:
Fonts
Symbols with unichar formula
L06 Matrix Coloring (****)4:05
Color a cell in a matrix based on selected input
L07 Data Bars in Cells (***)3:20
Create beautiful dynamic data bars in cells
L08 Create a dynamic Calendar with Sequence (*****)11:27
Use the Sequence and Date formulas to create a dynamic calendar
Test your Might! Formatting

L01 Material to download for Section0:07
Material for the section
L02 The Buzz about dynamic arrays (*****)3:27
Understand the difference between Excel Office 365 and older versions of Excel
L03 Spill Range & # (*****)3:37
Learn the properties of spill range and how to use the #
L04 Excel Table to automatically calculate formulas for new data (****)1:26
Learn my solution to be able to add new data and get the results of formulas automatically
L05 Sort (*****)4:05
How to use the sort function with multiple sorting columns
L06 Sortby (*****)2:34
Learn the difference between Sort and Sortby and how to use Sortby
L07 Filter (*****)6:17
Understand the filter formula:
Syntax
And condition
Or condition
L08 Unique (*****)1:40
Bye Bye Remove Duplicate. Discover the new Unique function!
L09 Filtering non adjacent columns (*****)5:45
Combine Sort, Filter & Unique to filter non adjacent columns!
L10 Creating a dropdown menu (*****)1:19
Learn how to avoid a common mistake in creating a dropdown menu!
L11 Filtering based on DropDown Menu (*****)1:14
Filter data based on dropdown menu selection
L12 Improve your calculations with Dynamic Arrays (*****)1:28
How to modify traditional formulas for better calculations
L13 Formatting with Dynamic Arrays (*****)2:08
Learn about the limitations of formatting with Dynamic Arrays
L14 Charts with Dynamic Arrays (*****)3:56
Use Named ranges with Dynamic Arrays to populate charts
L15 Real life Dashboard with Sequence, Filter & Sort (*****)4:49
Apply your knowledge with a real life example on dynamic array formulas
L16 Frequency (*****)6:12
Learn the frequency function through practical examples
L17 Create a Matrix with Transpose (*****)3:56
L18 Merging Spilled ranges (*****)3:20
Use choose to merge spilled ranges for more sustainable formulas
L19 Simplify your formula with Let (*****)6:56
Having a huge formla? What to improve readability? Use Let....
L20 Pivot Tables with Formulas (*****)5:29
Use Formulas to create pivot table like output
L21 ChooseCols and ChooseRows (***)2:37
Pick columns or rows from your dataset with ChooseCols and ChooseRows
Test your Might! Dynamic Array Formulas

Requirements

Very basic knowledge of Excel
Preferred to have Microsoft Excel 2013+ as some features/formulas might not be available
For the advanced lessons, Excel 2021 / Office 365 to get the benefit of dynamic array formulas

Description

About Me

I’m not just an Excel enthusiast—I’ve used it to build departments, lead strategy teams, and train professionals across industries. I hold a Harvard MBA and a degree in Computational Sciences. I was a VP at a major bank for 11+ years, and a McKinsey consultant trained to solve complex problems fast. I built the analytics department for a 3,500+ employee company and have worked on everything from AI to automation—but I still believe Excel is the most powerful, underrated tool for career success.

1. Why Learn Microsoft Excel Formulas?

Excel is the language of business. Over 500,000 companies in the U.S. use it every day. More than 90% of tasks at work don’t require complex models—just the right formulas. And with Excel 365’s new capabilities, it’s becoming more like Power BI but easier to learn. If you master Excel, you can:

Get promoted faster
Save hours on repetitive tasks
Build clean, impressive reports
And even transition into data analytics or automation roles

Excel is no longer optional. It’s the skill that unlocks the others.

2. Work Smarter, Not Harder

Most people waste hours manually fixing spreadsheets. But here’s the truth:

The difference in productivity between a beginner and an advanced Excel user is often 10X.

One person takes 10 hours to clean a report. The other does it in one. That’s the real power of formulas. This course will give you the skills to automate the boring stuff, eliminate embarrassing errors, and work faster than your peers.

3. Why This Course?

Formulas are the foundation of everything in Excel—from dashboards to budgeting to data cleaning. But most courses teach you to memorize syntax without context. This one’s different.

You’ll learn how formulas actually work, with real-world examples that make it easy to remember and apply what you learn. Whether you’re just starting or diving into new Excel 365 formulas, this course is built to help you feel confident and in control, not lost and frustrated.

It’s a structured, no-fluff, practical program designed specifically for ambitious professionals who are short on time and tired of generic courses. You won’t just complete lessons—you’ll transform how you work with Excel.

And yes, you're protected by Udemy’s 30-day refund policy, provided your request is within 30 days and meets their platform conditions. No risk, no stress.

No fluff. No academic detours. Just practical lessons to help you analyze smarter, not harder.

Frequently Asked Questions

Q: Is this course beginner-friendly?
Yes. Even if you’re starting from scratch, this course guides you step by step with clear, relatable examples.

Q: What if I already know a bit of Excel?
Perfect. You’ll learn advanced tricks, dynamic formulas, and real-time use cases that go beyond basic courses.

Q: Do I need Excel 365?
No—but you’ll benefit more if you have it. The course still covers core formulas that apply across versions.

Q: I don’t have much time. Can I still benefit?
Definitely. Lessons are short, focused, and built for people who want to make real progress without wasting time.

Q: Do I need to be good at math to take this course?
Not at all. This course focuses on logic, structure, and real-world applications—not on complex math. If you can follow a recipe or a checklist, you can learn Excel formulas.

Q: I’m not a “tech” person—will I get overwhelmed?
No. This course was designed for professionals who want to feel in control, not confused. Everything is broken down clearly, with no jargon or programming needed.

Who this course is for:

Course is designed to go from no knowledge about formulas to advanced levels - No matter your level, you will benefit from the different sections
Beginners will learns to write a formula for the first time
Advanced Excel users will learn the new Dynamic Array formulas in Excel 2021 & OFFICE 365

100+ Excel Formulas to Work Faster, Smarter, Impress at Work

What you'll learn

Explore related topics

Course content

01. The Beginning! Setting up the Right Way3 lectures • 5min

02. Formula 101 - Basics before writing Your first formula (*)10 lectures • 45min

03. IF statements & Logical Operators (**)9 lectures • 43min

All About Stats (***)16 lectures • 1hr 33min

Lookups (****)20 lectures • 2hr 4min

Dealing with Text (**)15 lectures • 1hr

Date & Time (***)12 lectures • 31min

Formatting with Formulas (****)8 lectures • 50min

Dynamic Array formulas - Office 365 (*****)21 lectures • 1hr 12min

Requirements

Description

Who this course is for: