Learn your way! Get started

Microsoft Excel 2013, Part 3 of 5: Working with Data

with expert Leeanne McManus


Watch trailer


Course at a glance


Release date 1/16/2017
Level Beginner
Runtime 1h 31m
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

In this course, instructor LeeAnne McManus delves into Excel’s ability to complete calculations on formatted data. From basic multiplication and division to the use of advanced, predefined formulas, she will review the best practices for applying various types of calculations to 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.

Learning Paths

This course is part of the following LearnNowOnline SuccessPaths™:
Microsoft Office Advanced

Meet the expert

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



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)