# LearnNowOnline

## Excel 2013, Part 3: Working With Data

#### Course at a glance

Included in these subscriptions:

• Creative Design Power Pack
• Power Pack Plus

 Release date 1/16/2017 Level Beginner Runtime 1h 31m Published eBooks N/A Hands-on labs N/A Sample files Included Exams Included

#### 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 Word is assumed.

#### Meet the expert

Leeanne is a nationally renowned trainer, facilitator, and productivity expert. For the past decade, she has trained, facilitated, and conducted thousands of sessions, helping clients to achieve their maximum potential. While being most well-known for helping end-users, departments, and organizations learn how to maximize their software products such as Office 365 and Adobe, Leeanne also facilitates sessions to enhance productivity and performance through soft skills. Leeanne consults clients on team building, leadership, succession planning, and more and utilizes a science-driven battery of assessments to help identify the uniqueness, skills, competencies, behavior, and drivers for each person. Leeanne's background includes Human Resources, Operations, and Talent and Development.

#### 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)