Download Start Excel File: https://people.highline.edu/mgirvin/AllClasses/135NoTextBook/Content/01IntroductionToExcel/ExcelBusinessMathVideo04DataFunctionsKeyboards.xlsx
Download pdf Notes: https://people.highline.edu/mgirvin/AllClasses/135NoTextBook/Content/01IntroductionToExcel/ExcelBusinessMathVideo04DataFunctionsKeyboards.pdf
Entire Class Web Site: https://people.highline.edu/mgirvin/AllClasses/135NoTextBook/135/135NoTextBookClass.htm
In this video learn about three important Excel facts to help build smart Excel Solutions: Data Types and Default Alignment to help track down errors, Excel Built-in Functions, and Keyboard shortcuts to do things quickly in Excel.
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. (01:02) Reminder about Save All Class Files to correct Folder
3. (04:17) Data Types and Default Alignment
4. (11:48) Define Aggregate Calculations
5. (12:27) Look at the Excel Built-in Functions: COUNT, COUNTA, SUM, MAX, MIN and AVERAGE
6. (23:32) How to enter multiple ranges into an Aggregate Excel Built-in Function
7. (26:36) Keyboard Shortcuts for Speed
8. (33:05) Summary

Next Video: 05 Excel & Business Math