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/2018LinkedIn Learning (Lynda.com) is a PMI Registered Education Provider. This course qualifies for professional development units (PDUs). To view the activity and PDU details for this course, click here.
The PMI Registered Education Provider logo is a registered mark of the Project Management Institute, Inc.
- Recall how to customize the user interface.
- Explain how to save a spreadsheet.
- Describe how to customize table cells and borders.
- Cite the steps for adding an image to a cell.
- Distinguish between different functions and explain how to use them.
- Explain how to format general chart attributes.
- Describe how to use interactive charts.
- Cite how to insert hyperlinks into a document.
- Recall how to add and arrange images.
- Summarize how to collaborate with iCloud.
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