Watch trailer
Course at a glance
| Release date | 4/25/2020 | |
| Level | Beginner | |
| Runtime | 12h 9m | |
| Closed captioning | N/A | |
| Transcript | N/A | |
| eBooks / courseware | N/A | |
| Hands-on labs | N/A | |
| Sample code | N/A | |
| Exams | Included |
Course description
Exam only course for Microsoft Excel 365
Microsoft Excel 365. Part 1 of 5: Get Acquainted with the Environment
Microsoft Excel 365, Part 2 of 5: Excel Basics
Microsoft Excel 365. Part 3 of 5: Working with Data
Microsoft Excel 365. Part 4 of 5: Modifying Workbook
Microsoft Excel 365. Part 5 of 5: Printing and Sharing
Prerequisites
This course assumes that students are familiar with the basic use of Windows and common use of the mouse and keyboard. No prior experience with Excel is assumed.
Meet the experts
I’m Kari Hoien. I have a Bachelors degree in Business and Accounting from Concordia College in Moorhead, I was a CPA and went on to get my Masters in Education Technology from Pepperdine in Malibu, California. I have been working as a trainer and consultant for Microsoft Office products for more than 20 years and I’ve helped clients in almost every industry in a wide range of different capacities and applications. I have taught thousands of people how to use Microsoft Office apps (Excel, Access, Outlook, PowerPoint etc). I have done stand-up classroom style training, virtual training, on-demand training, self-paced training, executive training, one-on-one training – you name it – I've probably done it. I LOVE teaching people how to use these everyday programs better, ways to save time so you can work SMARTER and have more time for the things that you love. Thanks so much for allowing me to help you learn.
Leeanne McManus is a nationally renowned trainer, facilitator, and productivity expert who has conducted thousands of sessions over the past decade. While widely recognized for helping end-users, departments, and organizations learn how to maximize their software products, most notably Office 365 and Adobe, Leeanne also facilitates sessions to enhance productivity and performance through soft skills development. Her professional background includes Human Resources, Operations, and Talent and Development.
Course outline
Getting Started with Excel
Getting Started (29:13)
- Introduction (01:09)
- Audience (00:45)
- The Excel Interface (01:16)
- Documents (01:01)
- Navigating the Ribbon Tabs (01:44)
- The Quick Access Toolbar (00:49)
- Contextual Ribbon Tabs (01:19)
- Status Bar (00:53)
- Changing Views (00:36)
- Demo: Ribbon Tabs (05:24)
- Demo: More Ribbon Tabs (04:19)
- Demo: Quick Access Toolbar (03:35)
- Demo: Status Bar (05:36)
- Summary (00:40)
Sign in to Office 365 (09:24)
- Introduction (01:00)
- Sign in to Office 365 (02:11)
- Demo: Office 365 (04:53)
- Switch Between Office Accounts (00:30)
- Demo: Switch Between Office Accounts (00:30)
- Summary (00:17)
Drop Downs, Dialogs, and Galleries (10:59)
- Introduction (01:00)
- Understanding Drop Downs (01:25)
- Opening a Dialog Box (00:55)
- Expanding Galleries (00:48)
- Demo: Cell Formatting (04:27)
- Demo: Other Drop Downs (02:01)
- Summary (00:20)
Understanding the Backstage (16:40)
- Introduction (01:04)
- Understanding the Backstage (01:42)
- Demo: Backstage (05:34)
- Demo: More Backstage (05:07)
- Demo: Pinned Folders and Files (02:50)
- Summary (00:21)
Sharing and Managing an O365 Account (17:45)
- Introduction (00:52)
- Manage Your Office 365 Account (01:36)
- Demo: Managing an O365 Account (05:17)
- Stress-Free Sharing (01:30)
- Demo: Sharing (02:37)
- Demo: Activity (05:22)
- Summary (00:29)
Backstage and Customization
Templates (10:31)
- Introduction (01:05)
- Start New or with a Template (00:38)
- Demo: Template (04:35)
- Demo: Finding Templates (03:56)
- Summary (00:15)
Customization (28:23)
- Introduction (00:51)
- Customizing the Environment (00:48)
- Show or Hide the Ribbon (00:41)
- Customize the Ribbon (00:25)
- Customize the QAT (00:33)
- Options Dialog Box (00:26)
- Demo: Show/Hide Ribbon (02:45)
- Demo: Quick Access Toolbar (06:15)
- Demo: More Commands (05:45)
- Demo: Customize the Ribbon (03:37)
- Demo: Other Excel Options (05:55)
- Summary (00:17)
Select, Edit, and Modify (13:00)
- Introduction (00:56)
- Select, Edt, and Modify Content (00:40)
- Mini Toolbar Formatting (01:19)
- Quick Clicks for Fast Modify (00:41)
- Quick Preview (00:58)
- Demo: Mini Toolbar (04:13)
- Demo: Quick Preview (03:52)
- Summary (00:18)
Interface and Smart Lookup (24:09)
- Introduction (00:45)
- Additions in the Interface (01:16)
- Demo: Tell Me (02:47)
- Smart Lookup (01:15)
- Demo: Smart Lookup (04:39)
- XLOOKUP Function (01:27)
- Demo: XLOOKUP (06:45)
- Demo: Lookup to the Left (04:49)
- Summary (00:22)
Exploring the Workbook
Exploring the Workbook (20:27)
- Introduction (00:57)
- Exploring the Workbook (03:03)
- Demo: Adding a Worksheet (06:42)
- Demo: Views (05:23)
- Demo: Arrange All (04:05)
- Summary (00:14)
Working with Excel (20:53)
- Introduction (00:51)
- Working with Excel (02:13)
- Demo: Rows and Columns (05:04)
- Demo: Selections (04:31)
- Demo: Selections Continued (04:45)
- Demo: Modifying Content (02:51)
- Summary (00:36)
Common Excel Features (21:36)
- Introduction (00:52)
- Common Excel Features (00:42)
- Demo: Merge Cells (05:46)
- Demo: Merge Cells Continued (04:26)
- Demo: Formatting Text (02:59)
- Demo: Paste Special (03:47)
- Demo: Show and Hide (02:29)
- Summary (00:31)
Excel Features
Find, Replace, Select (11:35)
- Introduction (01:00)
- The Editing Group (00:27)
- Demo: Find and Replace (05:52)
- Demo: Other Selections (03:47)
- Summary (00:27)
Fill or Series (12:13)
- Introduction (00:56)
- The Editing Group (00:39)
- Demo: Fill (05:50)
- Demo: Fill Example (04:32)
- Summary (00:14)
AutoSum (17:09)
- Introduction (00:49)
- The Editing Group (01:43)
- Demo: Adding Numbers (03:07)
- Demo: AutoSum (04:18)
- Demo: Other Calculations (03:58)
- Demo: More Functions (02:45)
- Summary (00:27)
Clear, Sort, and Filter (25:40)
- Introduction (01:07)
- The Editing Group (00:29)
- Demo: Clear (04:52)
- The Editing Group (01:07)
- Demo: Sort (06:58)
- Demo: Sort Levels (04:14)
- Demo: Filter (03:51)
- Demo: Multi Filter (02:37)
- Summary (00:22)
Sort, Filter, and Unique Functions (21:35)
- Introduction (00:08)
- SORT Function (00:24)
- Demo: Sort (06:52)
- SORTBY Function (00:18)
- Demo: SORTBY (04:24)
- FILTER Function (00:12)
- Demo: Filter (04:39)
- UNIQUE Function (00:36)
- Demo Unique (03:50)
- Summary (00:08)
Calculations
Creating Calculations (11:47)
- Introduction (01:00)
- Creating Calculations (04:19)
- Demo: Calculations (03:18)
- Demo: Entering Calculations (02:46)
- Summary (00:22)
Formulas (16:57)
- Introduction (00:57)
- Formulas (03:42)
- Demo: Formulas (05:11)
- Demo: Parentheses (05:22)
- Demo: Parentheses Continued (01:22)
- Summary (00:21)
Functions (24:00)
- Introduction (00:54)
- Functions (02:47)
- Demo: Functions (05:59)
- Demo: Text Functions (04:01)
- Demo: Convert to One Field (06:10)
- Demo: If (03:37)
- Summary (00:30)
AutoComplete (08:28)
- Introduction (00:49)
- AutoComplete Fuctions (01:28)
- Demo: AutoComplete (05:48)
- Summary (00:21)
AutoFill (06:01)
- Introduction (00:53)
- AutoFill (00:40)
- Demo: AutoFill (04:10)
- Summary (00:17)
FlashFill (11:10)
- Introduction (00:47)
- FlashFill (01:14)
- Demo: FlashFill (04:17)
- Demo: Forcing FlashFill (04:34)
- Summary (00:16)
Cell Reference (17:05)
- Introduction (01:17)
- Cell Reference (02:23)
- Relative, Absolute, Mixed (02:21)
- Demo: Cell Reference (04:55)
- Demo; Absolute Cell Reference (05:48)
- Summary (00:19)
Formatting
Common Formatting (30:06)
- Introduction (01:02)
- Common Formatting (01:32)
- Demo: Common Formatting (05:08)
- Demo: Format Cells Dialog Box (04:10)
- Demo: Cell Styles (05:14)
- Demo: Alignment (04:53)
- Demo: Alignment Cont. (02:14)
- Demo: Number Formatting (05:34)
- Summary (00:16)
Borders and Fill (13:13)
- Introduction (00:52)
- Borders and Fill Formatting (00:41)
- Demo: Borders (02:34)
- Demo: Fills (05:10)
- Demo: More Formatting (03:30)
- Summary (00:23)
Move, Copy, and Color Sheets (16:42)
- Introduction (00:57)
- Sheets (01:16)
- Demo: Color Sheets (03:29)
- Demo: Hide and Unhide Sheets (03:59)
- Demo: Move or Copy (06:42)
- Summary (00:17)
Format as a Table (20:48)
- Introduction (01:01)
- Format as a Table (01:36)
- Demo; Format as a Table (05:14)
- Demo: Table Styles (04:19)
- Demo: Table Tricks (03:51)
- Demo: Delete Table Rows (04:29)
- Summary (00:16)
Using Objects
Conditional Formatting (19:00)
- Introduction (01:04)
- Conditional Formatting (01:01)
- Demo: Conditional Formatting (04:43)
- Demo: Top/Bottom Rules (02:04)
- Demo: More Conditional Formats (05:14)
- Demo: Editing Rules (04:21)
- Summary (00:31)
Text Effects (18:54)
- Introduction (00:57)
- Text Effects (01:19)
- Demo: Insert Objects (05:37)
- Demo: Styling Objects (03:15)
- Demo: WordArt (04:31)
- Demo: Grouping (02:42)
- Summary (00:29)
Inserting Charts (24:54)
- Introduction (01:13)
- Inserting Charts (02:25)
- Demo: Recommended Charts (04:22)
- Demo: Recommended Charts Continued (04:53)
- Demo: Chart Formatting (04:20)
- Demo: Chart Types (05:25)
- Demo: Objects and Charts (01:53)
- Summary (00:20)
Inserting Graphics (18:42)
- Introduction (01:05)
- Inserting Graphics (01:03)
- Demo: Screenshot (03:21)
- Demo: Screen Clipping (03:00)
- Demo: SmartArt (04:20)
- Demo: Images from the Web (05:22)
- Summary (00:28)
3D Models and Maps (27:00)
- Introduction (00:08)
- Demo: 3D Models (12:58)
- Demo: 3D Maps (13:45)
- Summary (00:08)
Enhanced Inking and Improved Open File (27:59)
- Introduction (00:50)
- Enhanced Inking Features (01:30)
- Demo: Enhanced Inking Features (06:04)
- Improved Open File Features (01:25)
- Demo: Open File (05:29)
- Drawing, Image, and Shape Tools (01:10)
- Demo: Pens (01:23)
- Demo: Shapes (04:09)
- Demo: Images (05:22)
- Summary (00:32)
Finishing Touches
Inserting Headers and Footers (13:36)
- Introduction (01:04)
- Headers and Footers (01:15)
- Demo: Headers and Footers (06:27)
- Demo: More Headers and Footers (04:21)
- Summary (00:26)
Views (17:28)
- Introduction (00:52)
- Workbook Views (02:59)
- Demo: Views (05:12)
- Demo: Print Preview (02:52)
- Demo: Page Setup (05:02)
- Summary (00:28)
Print Preview and Print (11:34)
- Introduction (00:55)
- Print Preview and Print (03:05)
- Demo: Print Preview (02:15)
- Demo: Print Settings (04:54)
- Summary (00:24)
Sharing (17:04)
- Introduction (00:56)
- Sharing Your Workbook (04:02)
- Demo: Sharing (05:45)
- Collaborative Editing (00:37)
- Demo: Collaborative Editing (03:52)
- Demo: More Accessible PDFs (01:13)
- Summary (00:35)
Sparklines (14:21)
- Introduction (00:52)
- Sparklines (01:43)
- Demo: Sparklines (02:34)
- Demo: Sparkline Design (05:23)
- Demo: Other Sparklines (03:25)
- Summary (00:21)
Quick Analysis (10:59)
- Introduction (01:01)
- Quick Analysis (02:20)
- Demo: Quick Analysis (04:29)
- Demo: More Quick Analysis (02:42)
- Summary (00:24)
Icons, Calendars, and Email Insights (20:28)
- Introduction (00:44)
- Add Icons to Our Workbooks (01:20)
- Demo: Icons (05:11)
- Demo: Icons Continued (01:49)
- Calendar and Email Insights (01:12)
- Demo: Insights Setup (04:37)
- Demo: Email Insights (03:30)
- Demo: Calendar Insights (01:38)
- Summary (00:22)