Learn your way! Get started

Microsoft Excel 2016 Data Analysis, Part 2 of 4: Lookups and DataTables

with expert Sondra Nelson


Watch trailer


Course at a glance


Release date 10/21/2017
Level Intermediate
Runtime 1h 4m
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

Excel contains an endless amount of useful data tools to help you sift, sort, and present data. Explore some of these convenient tools including Lookup functions, Data Tables, Validating Cells, and tools for filtering data and creating charts and graphics, in this examination of Excel data tools. Some specific items to be covered include VLOOKUP and HLOOKUP functions, creating, managing, and manipulating data in tables, and setting up validation rules for cells in data sets to help reduce errors and speed up data entry.

Prerequisites

This course is designed for students with a base knowledge of Excel and want to learn higher-level skills to display data and perform functions. Students should know how to perform calculations, modify worksheets, format worksheets, print workbooks and manage workbooks.

Learning Paths

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

Meet the expert

Sondra Nelson is a Microsoft Certified Trainer and has been teaching Microsoft Office for over 15 years. She has teaching and consulting experience with high school students, college students and corporate employees.

Course outline



Lookups and Data Tables

Lookup Functions (08:49)
  • Introduction (00:30)
  • Using Lookup Functions (01:29)
  • VLOOKUP and HLOOKUP Functions Demo (01:52)
  • Demo: Lookup Functions (04:40)
  • Summary (00:16)
Data Tables (12:21)
  • Introduction (00:23)
  • Creating Data Tables (01:23)
  • Demo: Creating a Table (02:29)
  • Demo: Data Table Calculation (02:06)
  • Data Management (00:43)
  • Demo: Data Management (05:00)
  • Summary (00:14)
Validating Cells (15:15)
  • Introduction (00:29)
  • Validating Cell Entries (01:58)
  • Validation Demos (02:25)
  • Demo: Date Validation (03:32)
  • Demo: Value Validation (01:32)
  • Demo: Populate Data Area (01:41)
  • Demo: Custom Validation (03:22)
  • Summary (00:14)
Filtering (10:18)
  • Introduction (00:26)
  • Filtering (00:26)
  • Filter Demo (01:44)
  • Demo: Filter in the Table Header (05:23)
  • Demo: Slicers (02:01)
  • Summary (00:15)
Charting and Graphics (17:36)
  • Introduction (00:26)
  • Charting (00:50)
  • Bubble Chart Demo (00:39)
  • Demo: Create a Chart (05:23)
  • Combining Charts (01:22)
  • Demo: Combining Charts (02:47)
  • Graphics (00:34)
  • Graphics Demos (01:22)
  • Demo: Using Graphics in Excel (03:46)
  • Summary (00:21)