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

with expert Sondra Nelson

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.

Intermediate | 1h 4m | October 21, 2017


Course Outline

Sondra Nelson

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.

Explore Our Blogs, Courses and Webinars