Learn your way! Get started

Microsoft Excel 2019. Part 4 of 5: Modifying Workbook

with experts Kari Hoien, Leeanne McManus


Watch trailer


Course at a glance


Release date 10/22/2020
Level Intermediate
Runtime 3h 37m
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

Discover the collection of graphics and objects available to users of Excel with Microsoft Office experts Leeanne McManus and Kari Hoien. This course will discuss the various tools that can help to illuminate the data in your workbook in order to give your audience the information they need in a more digestible, visual manner.

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



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)