MS 365 Excel Basics #3: Number Formatting as Façade & when you MUST use ROUND Function

Posted on by Annie D

Download Excel File: https://people.highline.edu/mgirvin/AllClasses/218M365/Content/ExcelBasics03.xlsx
Read (download right-click): 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

excelisfunSun, November 17, 2024 2:12pm