Managing Data in Excel Microsoft 365 for Windows

Excel Microsoft 365 (Windows)    |    Expert
  • 8 videos | 39m 37s
  • Includes Assessment
  • Earns a Badge
Rating 5.0 of 3 users Rating 5.0 of 3 users (3)
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.

WHAT YOU WILL LEARN

  • 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

IN THIS COURSE

  • 4m 49s
    Excel allows you to import data from a text file and edit as you need. With Power Query you can transform the data to fit your Excel file and then replace the data to highlight what you want to show. If you update the source document, the Excel file can be updated to incorporate the changes. FREE ACCESS
  • 4m 30s
    Excel allows you to import data from a .csv file and edit as you need. With Power Query you can transform the data to fit your Excel file and then replace the data to highlight what you want to show. If you update the source document, the Excel file can be updated to incorporate the changes. FREE ACCESS
  • Locked
    3.  Finding a value in a double entry table in Excel Microsoft 365 for Windows
    6m 28s
    You can use the LOOKUP formula to find a value in a double entry table that you have created in Excel. You can, for example, use it to find a client's address based on their last name. It's also possible to use the INDEX formula to return a particular value in a table if you know its row and column coordinates. FREE ACCESS
  • Locked
    4.  Using the IFS & SWITCH functions in Excel Microsoft 365 for Windows
    4m 48s
    The IFS and SWITCH functions allow you to test multiple conditions without nesting the IF function. With IFS, you can use different operators, while with SWITCH you can get a result for a non-exact match. FREE ACCESS
  • Locked
    5.  Calculating average with different conditions in Excel Microsoft 365 for Windows
    4m 21s
    If you need to calculate the average in a certain range but have a criteria to apply, you can use the AVERAGEIF function. Excel also proposes the AVERAGEIFS function that calculates the average in a range if you have more than one criteria. FREE ACCESS
  • Locked
    6.  Using the MAXIFS & MINIFS functions in Excel Microsoft 365 for Windows
    4m 13s
    The MINIFS and MAXIFS functions allow you to find the minimum and maximum value in a range after applying one or more criteria. You can use logical operators and wild card for partial matching if necessary. FREE ACCESS
  • Locked
    7.  Finding data with multiple conditions in Excel Microsoft 365 for Windows
    4m 18s
    You can use the COUNTIFS function when you need to count the number of cells that meet one or more criteria. With COUNTIFS, you can apply more than one criteria in more than one range. Excel also offers the NOT function, that returns the opposite of a logical value. Combined with the IF function you can determine, for example, the availability of a product. FREE ACCESS
  • Locked
    8.  Forecasting data in Excel Microsoft 365 for Windows
    6m 11s
    If you want to calculate how many months it will take you to reimburse a loan according to a fixed monthly payment and a rate, you can use the NPER function. You can combine the NPER function with the IF and AND functions and forecast data that meet one or more criteria. FREE ACCESS

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

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

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Rating 4.9 of 7 users Rating 4.9 of 7 users (7)
Rating 3.0 of 2 users Rating 3.0 of 2 users (2)
Rating 4.5 of 1501 users Rating 4.5 of 1501 users (1501)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Rating 4.7 of 60 users Rating 4.7 of 60 users (60)
Rating 4.7 of 446 users Rating 4.7 of 446 users (446)
Rating 4.4 of 58 users Rating 4.4 of 58 users (58)