Learn your way! Get started

Microsoft Excel 2019. Part 5 of 5: Printing and Sharing

with experts Kari Hoien, Leeanne McManus

Watch trailer

Course at a glance

Release date 10/22/2020
Level Advanced
Runtime 1h 45m
Closed captioning N/A
Transcript N/A
eBooks / courseware N/A
Hands-on labs N/A
Sample code Included
Exams Included

Enterprise Solutions

Need reporting, custom learning tracks, or SCORM? Learn More

Course description

Whether through printing or electronic file-sharing, most Excel files are created with the intention of distribution. In this course, Microsoft Office expert LeeAnne McManus and Kari Hoien explore the layout, printing, and sharing features you will need to understand in order to improve the final appearance of your Excel documents.


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

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)