Aim: How do we create Excel formulas?
Aim: What is EXCEL? Do Now: Work with your Department. You have 5 minutes to list 5 ways your department uses EXCEL. READY! GO!
1
What is Excel? • Excel is an electronic spreadsheet program that can be used for storing, organizing and manipulating data
Why Excel? • So we can manage our Data – including Financials!
2
What we will learn… • • • • • •
Nocti will ask for a BUDGET in Excel How to create formulas How to SUM Numbers How to create a Series Learn how to use Reference Cells Format Cells
3
4
Excel Basics • Each box in an Excel Spreadsheet is called a CELL REFERENCE • Each Sheet is made up of; – Rows (labeled by numbers) and are horizontal – Columns (labeled by letters) and are vertical
• Each cell has a particular name which you can see in the Name box
5
Excel Basics • You type your information and formulas in the Formula Bar
6
Change to equations • • • • •
What are the mathematical formulas for each: 2 plus 3 = 2+3 5 times 10 =5*10 100 minus 44 =100 – 44 =60 / 10 60 divided by 10
Order of Operations
• What do you need to do in order to specify the order of equations? • Use Parenthèses =(10+5)*8 7
Creating Formulas • • • •
Start formulas with an EQUAL SIGN Plus +, Minus -, Multiply *, Divide / ∑ Auto Sum lets you Sum a row or column The Fill Handle is located on the bottom right of a highlighted cell
8
Activity 1. Complete the Excel Basics Worksheet and name the parts of Excel
9
Label the Parts
10
Answers 1. File Tab 2. Tab 3. Title Bar 4. Ribbon 5. Help 6. Name Box 7. Cell 8. Formula Bar 9. Group 10. Command 11. Sheet Tab 12. Scroll Bars 11
1
What is Excel? • Excel is an electronic spreadsheet program that can be used for storing, organizing and manipulating data
Why Excel? • So we can manage our Data – including Financials!
2
What we will learn… • • • • • •
Nocti will ask for a BUDGET in Excel How to create formulas How to SUM Numbers How to create a Series Learn how to use Reference Cells Format Cells
3
4
Excel Basics • Each box in an Excel Spreadsheet is called a CELL REFERENCE • Each Sheet is made up of; – Rows (labeled by numbers) and are horizontal – Columns (labeled by letters) and are vertical
• Each cell has a particular name which you can see in the Name box
5
Excel Basics • You type your information and formulas in the Formula Bar
6
Change to equations • • • • •
What are the mathematical formulas for each: 2 plus 3 = 2+3 5 times 10 =5*10 100 minus 44 =100 – 44 =60 / 10 60 divided by 10
Order of Operations
• What do you need to do in order to specify the order of equations? • Use Parenthèses =(10+5)*8 7
Creating Formulas • • • •
Start formulas with an EQUAL SIGN Plus +, Minus -, Multiply *, Divide / ∑ Auto Sum lets you Sum a row or column The Fill Handle is located on the bottom right of a highlighted cell
8
Activity 1. Complete the Excel Basics Worksheet and name the parts of Excel
9
Label the Parts
10
Answers 1. File Tab 2. Tab 3. Title Bar 4. Ribbon 5. Help 6. Name Box 7. Cell 8. Formula Bar 9. Group 10. Command 11. Sheet Tab 12. Scroll Bars 11
