Главная
Study mode:
on
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
Description:
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. Read more

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

ExcelIsFun
Add to list
#Business #Business Software #Microsoft Office 365 #Microsoft Excel #Data Science #Data Analysis #Spreadsheets #XLOOKUP
0:00 / 0:00
1 of 36

1. Introduction