Microsoft 365 Excel Fundamentals: Formulas, Functions, Formatting and Page Setup - Part 1

Overview

Save Big on Coursera Plus. 7,000+ courses at $160 off. Limited Time Only!

Grab it

Learn essential Microsoft 365 Excel fundamentals in this comprehensive video tutorial taught by experienced Highline College Professor and YouTuber Mike Girvin. Master formulas, functions, and formatting while building a practical gradebook project. Explore crucial Excel concepts including the Ribbon interface, data analysis capabilities, worksheet structure, and default alignments. Practice efficient data entry techniques using keyboard shortcuts, Fill Handle operations, and selection tricks. Discover how to implement various formula types including aggregate calculations, relative/absolute cell references, and dynamic spilled array formulas. Apply professional formatting with styles, borders, and fonts, while learning essential functions like SUM, AVERAGE, XLOOKUP, IFERROR, BYROW, and BYCOL. Gain practical knowledge about page setup, worksheet management, and Excel's Golden Rule for formula creation. Downloadable practice files and PDF notes are provided to follow along with the hands-on demonstrations.

Syllabus

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