Watch trailer
Course at a glance
| Release date | 5/13/2026 | |
| Level | Beginner | |
| Runtime | 1h 8m | |
| Closed captioning | N/A | |
| Transcript | N/A | |
| eBooks / courseware | N/A | |
| Hands-on labs | N/A | |
| Sample code | Included | |
| Exams | Included |
Course description
In parts 1 and 2 of this course you will get started with Excel. You'll learn basics of excel ranging from the interface, cell formatting, to functions, sorting, filtering and working with data finally wrapping up with print preview and printing your data.
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 expert
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.
Course outline
Module 2
Working with Data Efficiently (41:34)
- Introduction (00:58)
- Sorting and Filtering (05:20)
- Remove Sorts (01:34)
- Filtering (00:15)
- Header filters (00:40)
- Active Filter (03:07)
- Advanced Filter (01:23)
- Numbers (01:27)
- Working with Tables (01:57)
- Create a Table from Data (01:02)
- Table Design (01:11)
- Name Data Table (00:47)
- Structured Reference (00:57)
- Add Total Row (03:57)
- Turn Table off (01:19)
- Data Shortcuts (00:48)
- Flashfill (02:52)
- Autofill (01:15)
- Autofill Patterns (02:08)
- Duplicate Removal (02:58)
- Text to Columns (02:14)
- Data Shortcut keys (00:43)
- Summary (02:31)
Printing (26:32)
- Introduction (00:49)
- Printing Example (00:15)
- Page Layout View (00:52)
- Set Print Area (01:12)
- Page Break Preview (01:18)
- Clear Print Area (01:21)
- Scaling (04:06)
- Grid Lines (00:58)
- Print Options (00:22)
- PrintPreview (01:26)
- Print Properties (00:58)
- Print Workbook (00:25)
- Headers and Footers (01:41)
- Print to PDF (01:07)
- Export (01:15)
- Print Large Files (03:56)
- Add Headers to Each Page (02:59)
- Printing Shortcuts (01:01)
- Summary (00:21)