Excel Basics 9: Number Formatting as Façade & the ROUND Function

Excel 2016 Basics Free Course - Learn to Efficiently Use Excel at Work and to Get a Job. - Excel Basics 9: Number Formatting as Façade & the ROUND Function

4.0 (3)

24 learners

What you'll learn

This course includes

12.3 hours of video
Certificate of completion
Access on mobile and TV

Summary

Keywords

Highline College Busn 216 Mike Girvin Michael Girvin excelisfun Excel Basics Learn Excel Excel Excel 2016 Learn Excel for Free Learn Excel Online Complete Lesson in Excel

Full Transcript

Highline College Busn 216 Class: Computer Applications taught by Michael Girvin. Download Excel Start & Finished File: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EB09-NumberFormattingAndROUND.xlsm Download Full Written Notes: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/Office2016Class21-ExcelBasics09-NumberFormattingAndROUND.pdf Class web page link: https://people.highline.edu/mgirvin/AllClasses/216v2016/Content/04Excel/Excel2016.htm Topics in this video: 1. (00:01) Introduction 2. (02:10) What does Number Formatting do? 3. (03:20) Formulas do NOT see Number Formatting 4. (04:20) Number Formatting can save a lot of time for Data Entry 5. (07:03) Compare General, Currency and Accounting Number Formatting 6. (09:43) Percentage Number Formatting 7. (14:55) Rounding 8. (16:15) ROUND Function Basics 9. (20:34) When you MUST Round 10. (21:36) ROUND Function for Payroll 11. (24:00) ROUND Function for Invoicing 12. (26:30) ROUND Function for Income Taxxes when you need to round to the dollar 13. (27:22) Summary - Conclusion