Basic Excel Formulas and the Formula Wizard

In this training session, Allison Gonzalez, a Microsoft Certified Trainer at Pragmatic Works, introduces beginners to the fundamentals of formulas in Microsoft Excel. Whether a user is brand new to Excel or simply unfamiliar with formulas, this session provides step-by-step guidance on how to write formulas, use the formula bar, apply ranges, and navigate the Formula Wizard to simplify calculations.

Starting with the Basics

Every formula in Excel begins with an equals sign (=). Once typed, Excel expects the user to complete the calculation. Users can write formulas directly in a cell or in the formula bar, which provides more space and flexibility. Allison recommends the formula bar for clarity and accuracy, especially when working with longer expressions.

Performing Simple Calculations

Allison demonstrates how to perform basic mathematical operations with cell references:

• Addition: =B2+C2+D2
• Subtraction: =B2+C2-D2
• Division: =B2/C2
• Multiplication: =B2*C2

Parentheses can also be added to control order of operations, ensuring formulas follow the correct sequence just like standard math.

Using Ranges Instead of Individual Cells

Manually typing each cell in a calculation is inefficient, particularly with large datasets. Instead, Excel allows the use of ranges. For example:

• =SUM(B2:B26) adds values from B2 through B26.
• =AVERAGE(C2:C26) calculates the mean of a range.

This eliminates the need to manually select or type each cell reference.

Introducing the Formula Wizard

The Insert Function (fx) button, also known as the Formula Wizard, helps users find and apply functions. It provides:

• A searchable list of functions grouped by category (Math, Statistical, Lookup, etc.).
• Descriptions of each function, including its purpose and required arguments.
• A preview of results before committing, helping users verify accuracy.

For example, selecting SUM automatically suggests a logical range (such as all numbers above the current cell). Users can confirm or modify this selection with ease.

Commonly Used Functions

Allison highlights several beginner-friendly functions:

1. SUM – Adds values in a range.
2. AVERAGE – Calculates the mean of selected values.
3. COUNT – Counts numeric values in a range.
4. COUNTA – Counts both numbers and text in a range.

For instance, =COUNT(B2:D2) would return the number of numeric cells in that row, while =COUNTA(A2:D2) would include text entries as well.

Formula Tips and Best Practices

• Use the Formula Bar: Provides more visibility when building complex formulas.
• Check Results Quickly: Highlighting cells displays totals and averages in the Excel status bar.
• Be Mindful of Formatting: Switch between currency, general, or number formats as needed for clarity.
• Drag and Autofill: Extend formulas across rows or columns quickly using the fill handle.
• Explore the Formulas Tab: Excel organizes all functions into categories for easy discovery.

Practical Applications

These foundational formulas allow users to:

• Calculate final costs by adding product cost, tax, and freight.
• Apply discounts by subtracting a value from totals.
• Evaluate large datasets quickly using range-based formulas.
• Ensure accuracy with built-in function descriptions and result previews.

Building Confidence in Excel

Allison emphasizes that formulas are not as intimidating as they may seem. By starting with simple arithmetic, learning to reference ranges, and using the Formula Wizard, users can confidently expand their skills. These basics prepare learners for more advanced Excel functions such as VLOOKUP, INDEX, and MATCH, which will be covered in future sessions.

Don't forget to check out the Pragmatic Works' on-demand learning platform for more insightful content and training sessions on Excel and other Microsoft applications. Be sure to subscribe to the Pragmatic Works YouTube channel to stay up-to-date on the latest tips and tricks.