You will learn the basic building blocks of working with formulas in Excel. This chapter sets the foundation for more advanced formula techniques.

Topics Covered Include:

• Typing Inside Cell
• Typing inside Formula Bar
• Drag Formula

Understanding the differences between absolute, relative, and mixed references is crucial for ensuring your formulas work correctly, especially when copying formulas across cells.

Topics Covered Include:

• Absolute Reference
• Relative Reference
• Mixed Reference
• Changing References

You’ll learn how to use formulas to calculate totals, how to use formulas inside and outside of tables, and how these can dynamically interact with the table data.

Topics Covered Include:

• Total
• Inside Formula
• Outside Formula

This can make your formulas more readable and easier to manage. Named ranges allow you to refer to a cell or group of cells by a meaningful name instead of just the cell references.

Covers the essential functions that every Excel user should know.  These functions form the backbone of data analysis in Excel.

Topics Covered Include:

• Sum
• Average
• Count
• Countblank
• Max
• Min
• Subtotal

This chapter introduces you to functions that deal specifically with numerical data. From adjusting decimals to rounding numbers to the nearest digit and working with odd and even numbers, this chapter will elevate your number-crunching skills.

Topics Covered Include:

• Adjust Decimals
• Nearest Digit
• Odd-Even Number

You will learn how to join, clean, count characters, and change the case of text data. We will also delve into more advanced techniques for extracting specific portions from strings.

Topics Covered Include:

• Joining Text Data
• Cleaning Text Data
• Count Characters in String
• Change Text Case
• Extract Simple Text Data
• Extract Complex Text Data

Covers functions related to date and time. Learn how to work with current dates and times, calculate intervals, and manipulate date and time data for analysis.

Topics Covered Include:

• Calculate the Number of Days, Working Days, Weeks, Months, Quarters, and Years Between 2 Dates
• Extract Date Values from Date
• Extract Time Values from Date
• Add Hours, Minutes, Seconds to a Time – Time

You will explore logical functions like IF, AND, OR, and more. These functions are fundamental for decision-making within your worksheets.

Topics Covered Include:

• Simple Condition – If
• Multiple Condition – Ifs & Nested If
• If Condition with AND
• If Condition with OR

It will take you through the powerful lookup functions in Excel, such as VLOOKUP, HLOOKUP, INDEX, and the new XLOOKUP. You’ll learn how to retrieve data efficiently and accurately.

Topics Covered Include:

• Vlookup
• Index & Match
• Hlookup
• Xlookup
• 2-Way Xlookup
• 2-Way Index & Match
• Filter
• Unique & Sort
• Sort
• Sortby

Learn how to perform calculations based on certain criteria. This includes SUMIF, COUNTIF, AVERAGEIF, and their plural counterparts that work on multiple criteria.

Topics Covered Include:

• Sumif
• Sumifs
• Countifs
• Averageifs
• Maxifs
• Minifs
• Rank

Explores utilizing functions within conditional formatting to analyze data and make comparisons more accessible visually.

Topics Covered Include:

• Compare 2 List via Conditional Formatting – Match
• Compare 2 List via Conditional Formatting – No Match

This chapter covers an array of functions that don’t fit neatly into a single category but are incredibly useful in various scenarios.

Topics Covered Include:

• ToCol
• ToRow
• VStack
• Text Before
• Text After
• Text Split

Delves into the powerful world of array formulas, which allow you to perform multiple calculations and return multiple results in a single formula.

Topics Covered Include:

• What is an Array Formula
• Array Formula 1
• Array Formula 2

Lambda functions are a game-changing feature allowing you to create custom functions. This chapter will show you how to harness the power of Lambda functions for repetitive task.

Topics Covered Include:

• Lambda 1
• Lambda 2
• Lambda 3

Introduces the tools available for auditing and troubleshooting formulas, helping you maintain error-free worksheets.

Topics Covered Include:

• Formula Errors
• Audit Tools

An essential skill for ensuring that your worksheets remain accurate and user-friendly, even when unexpected.

Topics Covered Include:

• Intro to Error Handling
• Iferror

Offers tips and tricks to help you become more efficient and uncover clever solutions to common problems using formulas.

Topics Covered Include:

• AutoSum Calculation
• Status Bar
• Calculation

Learn how to unleash the power of Excel functions within PivotTables, one of Excel’s most powerful data analysis tools.

Topics Covered Include:

• Calculate Fields
• Get Pivot Data Function

Learn Excel functions within data validation to control the data type that can be entered into cells.

Topics Covered Include:

• Text Entries
• Text Length
• Prevent Duplicate Entries