Completed
11. Relationship Between Formulas and Number Formatting
Class Central Classrooms beta
YouTube videos curated by Class Central.
Classroom Contents
Microsoft 365 Excel Fundamentals: Formulas, Functions, Formatting and Page Setup - Part 1
Automatically move to the next video in the Classroom when playback concludes
- 1 1. Introduction
- 2 2. Topics in Video
- 3 3. How to download files to follow along
- 4 4. Summary Notes for Video
- 5 5. What is Excel? Complete introduction to what Excel does and other important topics
- 6 6. Ribbon and Quick Access Toolbar
- 7 7. What Excel Does: calculations and Data Analysis
- 8 8. Structure of Excel’s Two-Way Grid with Worksheets in a Workbook
- 9 9. Default Data Alignment to help track down errors
- 10 10. Number Formatting is a façade that formulas do not see
- 11 11. Relationship Between Formulas and Number Formatting
- 12 12. Project 01: Create Gradebook with formulas and formatting
- 13 13. Correct Keystrokes to Enter Data: Tab, Ctrl + Enter and Enter
- 14 14. Introduction to Fill Handle, Selection Cursor, Move Cursor, Cross Hair and Angry Rabbit to copy and increment cell content
- 15 16. Style Formatting like Borders, Fill and Font
- 16 17. Shift and Ctrl Selection Trick
- 17 18. Ctrl + Enter to enter same data into multiple cell simultaneously
- 18 19. Fill Handle and Cross Hair Angry Rabbit tricks to increment dates, months, days and numbers
- 19 20. Data Entry Trick by Pre-Highlighting Range
- 20 21. Aggregate calculation: SUM function
- 21 22. Relative Cell References
- 22 23. Create Grade Formula with Relative and Absolute Cell References
- 23 24. Create Grade Formula with Dynamic Spilled Array Formula
- 24 25. ROUND Function to round and change the underlying number in the cell
- 25 26. Benefits of Dynamic Spilled Array Formulas
- 26 27. Three Types of formulas: Aggregate, Single-Input / Single-Output, Dynamic Spilled Array Formula
- 27 28. XLOOKUP Function and how to create lookup table
- 28 29. # Spilled Range Operator
- 29 30. Excel’s Golden Rule: Formula Input Cells Rather than Hard Coding Numbers Into Formula
- 30 31. AVERAGE function
- 31 32. Page Setup to Print Only Some Of The Page and dynamic footers
- 32 33. Copy Worksheet
- 33 34. Enter New Data
- 34 35. IFERROR Function
- 35 36. BYROW and BYCOL functions to spill aggregate formulas
- 36 37. Summary of Video
