Excel & Business Math 01: Introduction to Excel. Why We Use Excel for Math. First Formula. HD
Download Excel File: https://people.highline.edu/mgirvin/AllClasses/135NoTextBook/Content/01IntroductionToExcel/ExcelBusinessMath01-IntroToExcel.xlsx Download pdf file: https://people.highline.edu/mgirvin/AllClasses/135NoTextBook/Content/01IntroductionToExcel/ExcelBusinessMathVideo01-IntroToExcel.pdf Entire Class Web Site: https://people.highline.edu/mgirvin/AllClasses/135NoTextBook/135/135NoTextBookClass.htm In this video you have an introduction to Excel for this Business Math class and see our first two formulas. Excel & Business Math Class (Busn 135) taught by Michael Girvin at Highline College / Mike Girvin at excelisfun Channel at YouTube Channel. Topics in Video: 1. (00:01) Introduction 2. (00:34) Class Web Site, Class Files & USB Drive to store files from class 3. (01:56) Download Excel & pdf Files. Look at different Browsers: Chrome, Internet Explorer, Mozilla 4. (03:05) Create Folder & Save Files using Save As & Windows Explorer 5. (05:49) Why we use Excel for Business Math 6. (09:46) Conventions for Class 7. (13:18) What does Excel do? 8. (14:35) Excel Workbook Layout 9. (17:38) Move Between Sheets 10. (19:00) Zoom in and out = Ctrl + Roll Wheel on Mouse 11. (20:00) Ribbon Tabs 12. (20:38) QAT – Quick Access Toolbar 13. (21:20) First Excel Formula: Total Sales 14. (31:33) Selecting a Range with the Selection Cursor 15. (31:40) Number Formatting as a Façade to display numbers in a different way that the Actual Number in the cell 16. (34:06) Second Excel Formula: Net Income. Also see how to copy a formula to the side (not down a column) 17. (35:32) Verify that Number Formatting is NOT misleading 18. (36:52) Review PDF Notes () 19. (37:52) Summary Next Video: Excel & Business Math 02: https://www.youtube.com/watch?v=1tnqnq2gIQc
Похожие видео
Показать еще