Completed
14. Introduction to Fill Handle, Selection Cursor, Move Cursor, Cross Hair and Angry Rabbit to copy and increment cell content
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
