Microsoft Excel 2016, Part 3 of 6: Working with Data

Course description

Delve into Excel's ability to complete calculations on formatted data with Microsoft Office expert Leeanne McManus. From basic multiplication and division to the use of advanced, predefined formulas, Leeanne will review the 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 expert

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.

Video Runtime

91 Minutes

Time to complete

156 Minutes

Course Outline

Calculations

Creating Calculations (11:06)

• Introduction (00:18)
• Creating Calculations (04:19)
• Demo: Calculations (03:18)
• Demo: Entering Calculations (02:46)
• Summary (00:22)

Formulas (16:24)

• Introduction (00:23)
• Formulas (03:42)
• Demo: Formulas (05:11)
• Demo: Parentheses (05:22)
• Demo: Parentheses Cont. (01:23)
• Summary (00:21)

Functions (23:20)

• Introduction (00:15)
• 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:29)

AutoComplete (07:54)

• Introduction (00:15)
• AutoComplete Functions (01:28)
• Demo: AutoComplete (05:48)
• Summary (00:21)

AutoFill (05:32)

• Introduction (00:24)
• AutoFill (00:40)
• Demo: AutoFill (04:10)
• Summary (00:16)

FlashFill (11:12)

• Introduction (00:18)
• FlashFill (01:44)
• Demo: FlashFill (04:48)
• Demo: Forcing FlashFill (04:04)
• Summary (00:16)

Cell Reference (16:08)

• Introduction (00:22)
• Cell References (02:23)
• Relative, Absolute, Mixed (02:21)
• Demo: Cell Reference (04:55)
• Demo: Absolute Cell Reference (05:48)
• Summary (00:16)