Managing Data in Excel Microsoft 365 for Windows


Overview/Description
Expected Duration
Lesson Objectives
Course Number
Expertise Level



Overview/Description

This 8-video course provides an in-depth exploration of tools available for data analysis, and it examines complex formulae in Excel for Office 365. Learners will observe how to use Power Query to transform the data to fit an Excel file. This course demonstrates how Excel allows you to import and edit data from a CSV (comma separated value) file. You will then learn how to use the LOOK UP formula to find a value in a double entry table. This course continues by demonstrating how to use different formulae to make calculations when multiple conditions have been imposed. You will examine the IFS and switch function to test multiple conditions without nesting the IF function. Next, you will learn how to use the AVERAGEIF, the MINIFS, and MAXIFS functions. You will learn to how use the NPER (number of periods required) function to calculate the number of months to reimburse a loan. Finally, you will learn how to use the IF and AND functions to forecast data.



Expected Duration (hours)
0.7

Lesson Objectives

Managing Data in Excel Microsoft 365 for Windows

  • 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_msex365_21_enus

    Expertise Level
    Expert