# Managing Data

Excel 2019 (Windows)
• 8 Videos | 42m 26s
• Includes Assessment
• CPE
• PMI PDU
25
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.

## WHAT YOU WILL LEARN

• import data from a text file
import data from a .csv file
find a value in a double entry table
use the IFS and SWITCH functions
• calculate averages using one or more conditions
use the MAXIFS and MINIFS functions
find data with multiple conditions
use the NPER function to calculate a loan repayment period or forecast data

## IN THIS COURSE

• 1.
Importing data from a text file
• 2.
Importing data from a .csv file
• 3.
Finding a value in a double entry table
• 4.
Using the IFS & SWITCH functions
• 5.
Calculating average with different conditions
• 6.
Using the MAXIFS & MINIFS functions
• 7.
Finding data with multiple conditions
• 8.
Forecasting data

## EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion of this course, which can be shared on any social network or business platform

Digital badges are yours to keep, forever.

## YOU MIGHT ALSO LIKE

COURSE Managing Data
75
41
0

53
74
50