Highline Excel 2013 Class Video 01: Back To Basics: Number Format, Keyboards, PivotTables, Formulas
Download workbook: http://people.highline.edu/mgirvin/AllClasses/214_2013/214/Busn214_2013.htm This is the Highline Community College Class, Spreadsheet Construction taught by Michael Girvin: Basic To Advanced Excel. Topics in this video: 1. Cells, Worksheets, Sheet Tabs and Workbooks (0:01:14 min) 2. Navigating Sheets in Excel 2013 (0:02:14 min) 3. Keyboards (0:03:30 min) 4. Number Formatting as Façade (0:08:51 min) 5. Types of Data in Excel (0:21:36 min) 6. Alignment (0:23:20 min) 7. Proper Data Sets, Non-Proper Data Sets (0:27:47 min) 8. Raw Data Into Information using Formula (0:29:28 min) 9. PivotTable #1: Raw Data Into Information using PivotTable (0:33:00 min) 10. Bad Data and Tracking Down Formula Errors (0:39:38 min) 11. Excel Tables (0:45:42 min) 12. Style & Number Formatting for cells (0:53:40 min) 13. PivotTable #2: Style & Number Formatting for PivotTable (1:00:39 min) 14. Page Setup (1:04:34 min) 15. Sorting (1:11:04 min) 16. Filtering (1:13:15 min) 17. PivotTable #3: PivotTables (1:17:35 min) 18. Charts (1:19:12 min) 19. PivotTable #4: Recommended Chart (1:25:28 min) 20. Excel's Golden Rule (1:26:42 min) 21. IF function (1:29:53 min) 22. VLOOKUP function (1:33:35 min)
Download workbook: http://people.highline.edu/mgirvin/AllClasses/214_2013/214/Busn214_2013.htm This is the Highline Community College Class, Spreadsheet Construction taught by Michael Girvin: Basic To Advanced Excel. Topics in this video: 1. Cells, Worksheets, Sheet Tabs and Workbooks (0:01:14 min) 2. Navigating Sheets in Excel 2013 (0:02:14 min) 3. Keyboards (0:03:30 min) 4. Number Formatting as Façade (0:08:51 min) 5. Types of Data in Excel (0:21:36 min) 6. Alignment (0:23:20 min) 7. Proper Data Sets, Non-Proper Data Sets (0:27:47 min) 8. Raw Data Into Information using Formula (0:29:28 min) 9. PivotTable #1: Raw Data Into Information using PivotTable (0:33:00 min) 10. Bad Data and Tracking Down Formula Errors (0:39:38 min) 11. Excel Tables (0:45:42 min) 12. Style & Number Formatting for cells (0:53:40 min) 13. PivotTable #2: Style & Number Formatting for PivotTable (1:00:39 min) 14. Page Setup (1:04:34 min) 15. Sorting (1:11:04 min) 16. Filtering (1:13:15 min) 17. PivotTable #3: PivotTables (1:17:35 min) 18. Charts (1:19:12 min) 19. PivotTable #4: Recommended Chart (1:25:28 min) 20. Excel's Golden Rule (1:26:42 min) 21. IF function (1:29:53 min) 22. VLOOKUP function (1:33:35 min)