### Excel 2019 for Windows: Managing Data

Overview/Description
Expected Duration
Lesson Objectives
Course Number
Expertise Level

Overview/Description

Excel offers a set of tools that allows you to explore more in detail data analysis and complex formulae. In this 8-video course, you will learn how to use different formulae to make calculations when you have multiple conditions imposed. You will also become able to forecast data by using the NPER function. Key concepts covered in this course include how to import, edit, and update data from a text file; how to import, edit and update data from a .csv file; and how to use the LOOKUP, MATCH, and INDEX functions to extract data. Next, you will learn how to run multiple conditions without nesting other functions; examine how to calculate averages by using one or more conditions; and learn how to calculate the smallest and the largest numbers that meet one or more criteria. Finally, learn how to count cells that meet one or more criteria; and how to calculate the number of periods to pay a loan and forecast loan approval that meet one or more criteria.

Expected Duration (hours)
0.7

Lesson Objectives

Excel 2019 for Windows: Managing Data

• import, edit and update data from a text file
• import, edit and update data from a .csv file
• use the LOOKUP, MATCH and INDEX functions to extract data
• run multiple conditions without nesting other functions
• calculate averages using one or more conditions
• calculate the smallest and the largest numbers that meet one or more criteria
• count cells that meet one or more criteria
• calculate the number of periods to pay a loan and forecast loan approval that meet one or more criteria
• Course Number:
ds_msex2019_21_enus

Expertise Level
Intermediate