Mastering Spreadsheet Formulas: Unlocking the Power of Excel

Mastering Spreadsheet Formulas: Unlocking the Power of Excel
1 / 13
volgende
Slide 1: Tekstslide

In deze les zitten 13 slides, met interactieve quizzen en tekstslides.

Onderdelen in deze les

Mastering Spreadsheet Formulas: Unlocking the Power of Excel

Slide 1 - Tekstslide

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

Slide 2 - Tekstslide

What do you already know about using formulas in spreadsheets?

Slide 3 - Woordweb

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.

Slide 4 - Tekstslide

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

Slide 5 - Tekstslide

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

Slide 6 - Tekstslide

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

Slide 7 - Tekstslide

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

Slide 8 - Tekstslide

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

Slide 9 - Tekstslide

Review and Q&A
Discuss what you learned about formulas. Questions?

Slide 10 - Tekstslide

Write down 3 things you learned in this lesson.

Slide 11 - Open vraag

Write down 2 things you want to know more about.

Slide 12 - Open vraag

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

Slide 13 - Open vraag