Begin with the fundamental aspects of working with formulas in Excel. This module lays the groundwork for mastering more complex formula techniques.

Topics Covered:

• Typing Inside a Cell
• Typing in the Formula Bar
• Dragging Formulas

Grasp the importance of absolute, relative, and mixed references to guarantee the accuracy and functionality of your formulas, especially when duplicating them across cells.

Topics Covered:

• Absolute Reference
• Relative Reference
• Mixed Reference
• Modifying References

Master using formulas to compute totals both within and outside tables, making your interactions with dynamic table data more efficient.

Topics Covered:

• Calculating Totals
• Formulas Inside Tables
• Formulas Outside Tables

Enhance readability and manageability of your formulas by using named ranges, allowing you to utilize meaningful names instead of mere cell references.

Familiarize yourself with essential Excel functions vital for data analysis.

Topics Covered:

• SUM
• AVERAGE
• COUNT
• COUNTBLANK
• MAX
• MIN
• SUBTOTAL

Advance your number-managing skills by learning functions focused on numerical data, including adjusting decimals and working with rounding and odd/even numbers.

Topics Covered:

• Adjusting Decimals
• Nearest Digit Rounding
• Odd and Even Numbers

Discover how to manipulate text data, including joining, cleaning, and extracting text, as well as changing cases and counting characters.

Topics Covered:

• Joining Text Data
• Cleaning Text Data
• Counting Characters in a String
• Changing Text Case
• Extracting Simple Text Data
• Extracting Complex Text Data

Learn how to effectively manage and analyze date and time data.

Topics Covered:

• Calculating Days, Working Days, Weeks, Months, Quarters, and Years Between Dates
• Extracting Date Values
• Extracting Time Values
• Adding Hours, Minutes, and Seconds to Time

Explore logical functions like IF, AND, and OR, which are essential for decision-making processes within your worksheets.

Topics Covered:

• Simple IF Condition
• Multiple Conditions (IFs and Nested IF)
• IF Condition with AND
• IF Condition with OR

Delve into powerful lookup functions like VLOOKUP, HLOOKUP, INDEX, and XLOOKUP to retrieve data accurately and efficiently.

Topics Covered:

• VLOOKUP
• INDEX & MATCH
• HLOOKUP
• XLOOKUP
• Two-Way XLOOKUP
• Two-Way INDEX & MATCH
• FILTER
• UNIQUE & SORT
• SORT
• SORTBY

Learn how to conduct calculations based on specific criteria, including functions like SUMIF, COUNTIF, and AVERAGEIF.

Topics Covered:

• SUMIF
• SUMIFS
• COUNTIFS
• AVERAGEIFS
• MAXIFS
• MINIFS
• RANK

Utilize functions within conditional formatting to make data analysis and comparisons more visually accessible.

Topics Covered:

• Comparing Two Lists (Match)
• Comparing Two Lists (No Match)

Explore a variety of functions that, while not fitting neatly into other categories, are immensely useful in diverse scenarios.

Topics Covered:

• TOCOL
• TOROW
• VSTACK
• TEXTBEFORE
• TEXTAFTER
• TEXTSPLIT

Gain expertise in array formulas, which enable multiple calculations and return several results within a single formula.

Topics Covered:

• Introduction to Array Formulas
• Array Formula Examples 1 & 2

Harness the power of Lambda functions to create custom functions for repetitive tasks, a revolutionary feature in Excel.

Topics Covered:

• Lambda Function Example 1
• Lambda Function Example 2
• Lambda Function Example 3

Discover the tools available for auditing and troubleshooting formulas to keep your worksheets error-free.

Topics Covered:

• Identifying Formula Errors
• Audit Tools

Develop skills to maintain the accuracy and user-friendliness of your worksheets even when unexpected errors occur.

Topics Covered:

• Introduction to Error Handling
• IFERROR

Learn tips and tricks so you can work more efficiently and find clever solutions to common problems using formulas.

Topics Covered:

• AutoSum Calculation
• Using the Status Bar
• Calculation Tricks

Uncover the power of Excel functions within PivotTables for advanced data analysis.

Topics Covered:

• Calculated Fields
• GETPIVOTDATA Function

Use Excel functions within data validation to control the type of data entered into cells.

Topics Covered:

• Text Entries
• Text Length
• Preventing Duplicate Entries