Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Microsoft Excel 365: Ultimate Beginner's Guide
Section 1: Introduction
Course Introduction (3:36)
Excel 365 Online Portal (6:49)
Exercise 01 (0:59)
DOWNLOAD ME: Course Files
DOWNLOAD ME: Exercise Files
Section 2: Get Started in Excel 365
Launch Excel (3:47)
Explore the Interface (9:50)
Work with Contextual Menus, Ribbons, and Panes (4:43)
Customize the Quick Access Toolbar (7:08)
Keyboard Shortcuts (7:59)
Exercise 02 (4:01)
Section 3: Create an Excel Spreadsheet
Excel Templates (6:39)
Work with Workbooks and Worksheets (6:40)
Save Workbooks to OneDrive (4:47)
Enter Text, Numbers, and Dates (7:07)
Custom Lists (6:30)
Exercise 03 (4:03)
Section 4: Introduction to Excel Formulas
The Order of Operations (BODMAS Rule) (6:51)
A Simple Formula (6:33)
The 'Big 6' Functions (6:28)
Absolute vs Relative Referencing (7:28)
Quick Calculations with Autosum (5:35)
Auto-Fill and Flash Fill (10:40)
Exercise 04 (4:50)
Section 5: Use Named Ranges
What are Named Ranges? (3:24)
Create Named Ranges (4:16)
Use Named Ranges in Formulas (3:28)
Exercise 05 (2:29)
Section 6: Format Numbers and Cells
Apply Number Formats (12:19)
Format Cells, Rows, and Columns Manually (13:10)
AutoFormat Data (3:40)
Find and Replace Formatting (6:26)
Copy Formatting: Format Painter (4:37)
Clear Cells (5:18)
Exercise 06 (4:02)
Section 7: Excel Tables
Excel Tables Explained (7:50)
Format Data as an Excel Table (10:28)
Table References in Formulas (6:52)
Exercise 07 (2:43)
Section 8: Format Worksheets
Work with Rows and Columns (9:20)
Align Text and Numbers (8:53)
Merge Cells vs Center Across Selection (6:56)
Apply and Modify Themes (8:30)
Exercise 08 (3:04)
Section 9: Excel Lists
How to Structure a List (6:49)
Sort a List: Single-Level Sort (5:28)
Sort a List: Multi-Level Sort (5:52)
Sort a List: Sort with Custom Lists (3:55)
Filter a List - Numbers and Text (8:11)
Filter and Sort by Color (3:53)
Add Subtotals to a List (5:47)
Exercise 09 (2:50)
Section 10: Move and Link to Data
Cut, Copy, and Paste (5:08)
Paste Options (8:56)
Paste From Clipboard (4:04)
Move and Copy Worksheets (6:38)
3D Referencing (6:03)
Insert Hyperlinks to Worksheets (7:37)
Exercise 10 (7:39)
Section 11: Introduction to Intermediate Formulas
Lookup Functions: VLOOKUP Explained (9:55)
Lookup Functions: XLOOKUP Explained (6:29)
Logical Functions: IF, AND, OR (9:56)
Text Functions: PROPER, TRIM, CLEAN (8:09)
Time and Date Functions: TODAY, NOW, WORKDAY (7:26)
Exercise 11 (5:08)
Section 12: Analyze Data
Quick Analysis Button (7:07)
Choose the Right Chart Type (6:49)
Present Data with Charts (5:55)
Format a Chart (11:23)
In-Cell Charts: Sparklines (5:59)
In-Cell Charts: The REPT Function (4:52)
Exercise 12 (4:35)
Section 13: Conditional Formatting
Highlight Cell Values (7:23)
Data Bars (6:42)
Color Scales (4:26)
Icon Sets (5:02)
Exercise 13 (3:59)
Section 14: Insert Pictures and Other Graphics
Add Interest with Pictures and Icons (9:32)
Insert Shapes and Text Boxes (9:50)
Create Diagrams using SmartArt (8:13)
Insert Screenshots and Clips (4:08)
Insert and Respond to Threaded Comments (5:32)
Exercise 14 (4:34)
Section 15: Work with Views
Workbook Views and Zoom (8:12)
Arrange Workbooks and Worksheets (5:47)
Freeze Panes (3:34)
Exercise 15 (1:51)
Section 16: Prepare for Printing
Set Margins and Orientation (3:59)
Set and Clear the Print Area (3:16)
Insert Page Breaks (4:13)
Set Print Titles and a Background (4:50)
Insert Headers and Footers (6:43)
Print a Workbook (6:50)
Exercise 16 (2:54)
Section 17: Finalizing the Spreadsheet
Protect Cells, Worksheets, and Workbooks (6:37)
Inspect the Workbook for Issues (8:29)
Save the Workbook in Different Formats (4:11)
Exercise 17 (3:09)
Section 18: Excel 365 Online
Work with Files in Excel Online (5:52)
Share Workbooks with Others (5:44)
Co-Author Workbooks in Real-Time (5:21)
Add an Excel Workbook to Microsoft Teams (3:10)
Excel Live: Share a Workbook in a Teams Meeting (3:27)
Exercise 18 (3:44)
Section 19: Course Close and Quiz
Course Close (7:12)
Course Quiz and Certificate of Completion
Launch Excel
Complete and Continue