Download Excel File: https://excelisfun.net/files/ExcelBasics01.xlsx
pdf notes: https://excelisfun.net/files/ExcelBasics01.pdf
In this video learn about the different types of formulas and functions in MS 365 Excel, as well as how to so style and number formatting. Learn about all the shortcuts that will allow you to create an Excel solution with lightening speed and accuracy.
In this video get a complete introduction to Excel basics taught by Mike “excelisfun” Girvin, Highline College Profession since 2002 years and excelisfun YouTuber since 2008. This is video is first in a class of 10 free videos and Excel files!
This is a free YouTube class that teaches you all about Microsoft 365 Excel.
Topics in Video:
1. (00:00) Introduction
2. (00:38) Topics in Video
3. (01:11) How to download files to follow along
4. (02:29) Summary Notes for Video
5. (02:58) What is Excel? Complete introduction to what Excel does and other important topics
6. (03:15) Ribbon and Quick Access Toolbar
7. (03:47) What Excel Does: calculations and Data Analysis
8. (04:46) Structure of Excel’s Two-Way Grid with Worksheets in a Workbook
9. (07:23) Default Data Alignment to help track down errors
10. (11:18)Number Formatting is a façade that formulas do not see
11. (13:23) Relationship Between Formulas and Number Formatting
12. (18:32) Project 01: Create Gradebook with formulas and formatting
13. (19:23) Correct Keystrokes to Enter Data: Tab, Ctrl + Enter and Enter
14. (20:10) Introduction to Fill Handle, Selection Cursor, Move Cursor, Cross Hair and Angry Rabbit to copy and increment cell content
15. Ctrl + * to select the current region
16. (22:49) Style Formatting like Borders, Fill and Font
17. (24:45) Shift and Ctrl Selection Trick
18. (26:47) Ctrl + Enter to enter same data into multiple cell simultaneously
19. (28:34) Fill Handle and Cross Hair Angry Rabbit tricks to increment dates, months, days and numbers
20. (31:58) Data Entry Trick by Pre-Highlighting Range
21. (32:53) Aggregate calculation: SUM function
22. (33:33) Relative Cell References
23. (36:46) Create Grade Formula with Relative and Absolute Cell References
24. (37:35) Create Grade Formula with Dynamic Spilled Array Formula
25. (40:07) ROUND Function to round and change the underlying number in the cell
26. (42:37) Benefits of Dynamic Spilled Array Formulas
27. (43:02) Three Types of formulas: Aggregate, Single-Input / Single-Output, Dynamic Spilled Array Formula
28. (44:16) XLOOKUP Function and how to create lookup table
29. (50:43) # Spilled Range Operator
30. (51:37) Excel’s Golden Rule: Formula Input Cells Rather than Hard Coding Numbers Into Formula
31. (53:10) AVERAGE function
32. (54:28) Page Setup to Print Only Some Of The Page and dynamic footers
33. (57:47) Copy Worksheet
34. (59:24) Enter New Data
35. (01:00:13) IFERROR Function
36. (01:01:45) BYROW and BYCOL functions to spill aggregate formulas
37. (01:04:26) Summary of Video