Wat is LessonUp
Zoeken
Kanalen
Inloggen
Registreren
‹
Terug naar zoeken
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
.
Start les
Bewaar
Deel
Printen
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
Meer lessen zoals deze
Excel Wizardry: Mastering Data Analysis
Maart 2024
- Les met
13 slides
16 - DL Excel Introduction
April 2024
- Les met
21 slides
Computing
Lower Secondary (Key Stage 3)
7 - DL Excel Introduction - Improved
Mei 2024
- Les met
15 slides
Computing
Lower Secondary (Key Stage 3)
Excel - Part 2
Juli 2024
- Les met
10 slides
Computing
Lower Secondary (Key Stage 3)
7 - DL Excel Introduction - Improved
Maart 2024
- Les met
15 slides
Computing
Lower Secondary (Key Stage 3)
7 - DL Excel Introduction
Maart 2024
- Les met
15 slides
Computing
Lower Secondary (Key Stage 3)
7 - DL Excel Introduction - Improved
Juni 2024
- Les met
15 slides
Computing
Lower Secondary (Key Stage 3)
7 - DL Excel Introduction - Improved
Juni 2024
- Les met
15 slides
Computing
Lower Secondary (Key Stage 3)