Download Excel File: https://people.highline.edu/mgirvin/AllClasses/218M365/Content/ExcelBasics03.xlsx
Link to full Excel Basics Class: https://www.youtube.com/playlist?list=PLrRPvpgDmw0k7ocn_EnBaSJ6RwLDOZdfo
pdf notes: https://people.highline.edu/mgirvin/AllClasses/218M365/Content/ExcelBasics03.pdf
In this video learn about how to not be tricked by Number Formatting, and how to use the ROUND function rather than number formatting to calculate accurate payroll, invoicing and income tax calculations. Lean about difference between Currency and Accounting Number Formatting.
Topics:
1. (00:00) Introduction
2. (01:04) What does Number Formatting do?
3. (02:38) Formulas do not see Number Formatting
4. (04:10) Keyboard to apply General Number Formatting (Eraser): Ctrl + Shift + ~ / `
5. (04:40) Number Formatting can save time entering data.
6. (07:40) Currency and Accounting Number Formatting
7. (08:35) Percentage Number Formatting
8. (11:05) Rounding with the ROUND function
9. (14:55) Rule for when you MUST use ROUND function.
10. (15:33) Payroll Example
11. (17:28) Invoice Example
12. (19:30) Income Tax Example
13. (20:37) Summary
14. (21:35) Closing