Mastering Spreadsheet Formulas: Unlocking the Power of Excel

Mastering Spreadsheet Formulas: Unlocking the Power of Excel

Learning Objective

At the end of the lesson, you will be able to explain what a formula is and apply basic formulas in Excel.

What do you already know about using formulas in spreadsheets?

What is a Formula?

A formula is an expression that calculates a value in a spreadsheet. Starts with an '=' sign followed by operations and functions.

Basic Structure of Formulas

Formulas use cell references, operators (+, -, *, /), and functions (SUM, AVERAGE). Example: =A1+B1.

Using Functions in Formulas

Functions perform specific calculations. Example: =SUM(A1:A5) adds values in a range.

Exercise: Basic Formulas

Task: Calculate total sales in cells A1 to A5. Use =SUM(A1:A5).

Exercise: Using Operators

Task: Subtract expenses (B1) from sales (A1). Formula: =A1-B1.

Exercise: Advanced Functions

Task: Find the average of test scores in C1 to C5. Use =AVERAGE(C1:C5).

Review and Q&A

Discuss what you learned about formulas. Questions?

Write down 3 things you learned in this lesson.

Write down 2 things you want to know more about.

Ask 1 question about something you haven't quite understood yet.