Excel 2016 Basics Free Course - Learn to Efficiently Use Excel at Work and to Get a Job. - Excel Basics 2: Introduction to Excel 2: Excel's Golden Rule for Formulas, Formula Inputs, & Charts

Highline College Busn 216 Class: Computer Applications taught by Michael Girvin. Download Excel Finished File: Download File: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EB02-NetIncomeProjections.xlsx Download Full Written Notes: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/Office2016Class14-ExcelBasics02-IntroductionToExcel02.pdf Class web page link: https://people.highline.edu/mgirvin/AllClasses/216v2016/Content/04Excel/Excel2016.htm Buy excelisfun products: https://teespring.com/stores/excelisfun-store Topics in this video: 1. (00:01) Introduction 2. (00:25) Goal of video 3. (03:07) Type labels for Net Income Projection Table and Assumption Table 4. (07:18) Add Stylistic Formatting 5. (09:00) Enter Formula Inputs 6. (09:35) Format Cells Dialog Box using Ctrl + 1 7. (13:43) Start Revenue Formula (we are not copying this formula anywhere) 8. (14:12) Revenue Increase Formula (uses Relative and Absolute Cell References): 9. (15:50) Why Percentage Revenue Increase Formula is TRUE 10. (19:26) The Beauty of Excel 11. (20:23) Expense Formula (uses Relative and Absolute Cell References) 12. (22:15) Why Expense Formula is TRUE 13. (22:30) Net Income Formula (uses two Relative Cell References) 14. (24:05) Insert Chart: Column Chart 15. (25:03) Move and Resize Chart 16. (26:12) Format Chart with Green Plus 17. (27:00) Discuss Chart Junk 18. (27:44) Delete Chart Elements 19. (28:22) Open Chart Formatting Task Pane with Ctrl + 1 20. (30:36) Link Chart Title to Cell 21. (32:56) Use Alt Key to Snap Chart to Grid 22. (32:26) Excel’s Golden Rule 23. (32:26) Use Assumption Table (Formula Input Table) to change Formula inputs and watch everything update 24. (34:26) Page Setup 25. (36:56) Summary