Microsoft Excel 2019. Part 3 of 5: Working with Data
Course description
Delve into Excel's ability to complete calculations on formatted data with Microsoft Office experts Leeanne McManus. and Kari Hoien show how you can go from basic multiplication and division to the use of advanced, predefined formulas, as well as best practices for applying various types of calculations to your data.
Each LearnNowOnline training course is made up of Modules (typically an hour in length). Within each module there are Topics (typically 15-30 minutes each) and Subtopics (typically 2-5 minutes each). There is a Post Exam for each Module that must be passed with a score of 70% or higher to successfully and fully complete the course.
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
Leeanne McManus
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.
Kari Hoien
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.
Video Runtime
95 Minutes
Time to complete
162 Minutes
Course Outline
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)
