Loading...

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

171,641 views

Loading...

Loading...

Transcript

The interactive transcript could not be loaded.

Loading...

Rating is available when the video has been rented.
This feature is not available right now. Please try again later.
Published on Apr 6, 2016

Download Files: https://people.highline.edu/mgirvin/A...
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...

Loading...

Advertisement

to add this to Watch Later

Add to

Loading playlists...