Highline Excel 2016 Class 01: Excel Fundamentals: Efficiency, Data, Data Sets, Formatting

Download Files: https://people.highline.edu/mgirvin/AllClasses/218_2016/218Excel2016.htm
In this video learn about these Excel Fundamentals for Excel Highline Excel 2016 Class:
1. (04:24) Download Files
2. (00:33) Prerequisites for class
3. (01:04) Excel Professional 2016
4. (01:50) Install Com Add-in Power Pivot
5. (02:54) Examples of Effective and Efficient Solutions in Excel
6. (09:20) What Excel Does: 1) Make Calculations & 2) Data Analysis
7. (11:25) Structure of Excel: Cells, Worksheets, Sheet Tabs and Workbooks
8. (13:00) Keyboard Shortcuts are efficient because they help you to accomplish tasks quickly
9. (15:06) Data Analysis and Business Intelligence terms
10. (16:31) What is Raw Data?
11. (17:16) Excel Proper Data Sets
12. (20:18) Terminology: Cleaning, Transforming, Importing Data Data
13. (22:40) Data Types and Default Alignment in Excel
14. (29:05) Excel Table feature
15. (34:45) Number Formatting is a Façade
16. (39:13) Date Number Formatting and Date Math (Date Formulas)
17. (43:51) Time Number Formatting and Time Math (Time Formulas)
18. (46:35) Percentage Number Formatting
19. (53:10) Custom Number Formatting
20. (01:03:00) Style Formatting allows you to present information in an effect way
21. (01:10:00) Cell Styles
22. (01:13:45) Page Setup allows you to print information in an effect way
23. (01:19:24) Summary
24. (01:20:25) Homework Problems

Highline Excel 2016 Professional Class taught by Michael excelisfun Girvin

Prerequisite class: https://www.youtube.com/playlist?list=PLrRPvpgDmw0kbIJuNnApcYG3pQI3sG8j4

Видео Highline Excel 2016 Class 01: Excel Fundamentals: Efficiency, Data, Data Sets, Formatting канала ExcelIsFun