In this video, learn how to perform arithmetic operations while understanding arithmetic operators. Also, use comparison operators to trigger a true or false result.
- [Instructor] Well if you've been following along with me…so far, we've created some very simple formulas…using some arithmetic operators…like the dash, or minus sign…for subtracting one cell from another.…The asterisk for multiplication.…We could use the slash for division.…We could also use the plus sign for addition.…We're going to to look at some other operators…in this movie that will allow us to compare.…So we'll continue working with our…Leaf and Mortar Budget 0504 if you're catching up.…If we go over here to our top table,…our annual budget overview for 2018…and click in cell D3 and look at the bottom,…you can see the formula is the actual total income…minus the estimated total income.…
The operator is the minus sign, we use the dash.…If we go over to the difference in Canadian,…you can see that's a formula that uses multiplication.…We use the asterisk and the multiplication sign…or operator was added for us in our formula.…But what if we wanted to do something else…like compare values.…Well we would use a different type of operator…
Author
David Rivers
Released
1/12/2018- Customizing the user interface
- Creating basic spreadsheets
- Importing spreadsheet data
- Adding and modifying tables
- Working with content in table cells
- Using and modifying table cells
- Using formulas and functions
- Working with charts, text, numbers, and objects
- Designing templates
- Sharing spreadsheets
Skill Level Beginner
Duration
Views
-
Introduction
-
Welcome59s
-
What you need to know1m 7s
-
-
1. Get Started
-
Numbers templates3m 23s
-
Explore the user interface6m 27s
-
Customize the user interface5m 48s
-
-
2. Work with Spreadsheets
-
Create a basic spreadsheet7m 22s
-
Import spreadsheet data4m 33s
-
Save a spreadsheet4m 31s
-
Work with sheets4m 32s
-
Use row and column headers3m 34s
-
-
3. Work with Tables
-
Add a table8m 14s
-
Modify a table5m 25s
-
Use controls5m 36s
-
Add images to cells4m 52s
-
Reorganize table data5m 19s
-
-
4. Work with Table Styles
-
Use table styles3m 41s
-
Modify a table’s style6m 41s
-
-
5. Use Formulas and Functions
-
Use formulas4m 28s
-
Use functions7m 8s
-
Use cell references4m 58s
-
Use operators4m 19s
-
-
6. Work with Charts
-
Add a chart6m 39s
-
Modify chart data2m 44s
-
Change chart types2m 22s
-
Format 3D charts2m 33s
-
Use interactive charts3m 46s
-
-
7. Work with Text and Numbers
-
Format text8m 5s
-
Use conditional highlighting4m 16s
-
Use special characters5m 28s
-
Use hyperlinks4m 14s
-
Use find and replace4m 38s
-
-
8. Work with Objects
-
Use text boxes9m 36s
-
Copy text to a text box4m 51s
-
Work with shapes6m 10s
-
Add and arrange images4m 42s
-
Mask and adjust images5m 18s
-
-
9. Create Templates
-
Design a template5m 16s
-
Provide input options5m 51s
-
Create placeholders2m 25s
-
Save a custom template3m 46s
-
-
10. Share Spreadsheets
-
Print and adjust page setup7m 13s
-
Export to Excel5m 42s
-
Send a copy via email2m 39s
-
Collaborate with iCloud4m 43s
-
-
Conclusion
-
Next steps38s
-
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.
Share this video
Embed this video
Video: Use operators