Managing Data

Excel Microsoft 365 (Windows)    |    Expert
  • 8 Videos | 39m 40s
  • Includes Assessment
  • Earns a Badge
Likes 112 Likes 112
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

  • Playable
    1. 
    Importing data from a text file
    5m 3s
    UP NEXT
  • Playable
    2. 
    Importing data from a .csv file
    4m 30s
  • Locked
    3. 
    Finding a value in a double entry table
    6m 28s
    FREE ACCESS
  • Locked
    4. 
    Using the IFS & SWITCH functions
    5m 23s
    FREE ACCESS
  • Locked
    5. 
    Calculating average with different conditions
    3m 36s
    FREE ACCESS
  • Locked
    6. 
    Using the MAXIFS & MINIFS functions
    4m 13s
    FREE ACCESS
  • Locked
    7. 
    Finding data with multiple conditions
    4m 18s
    FREE ACCESS
  • Locked
    8. 
    Forecasting data
    6m 11s
    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 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 Solving data problems in Excel 365
BOOK Microsoft Excel Functions and Formulas: With Excel 2019 / Office 365, Fifth Edition
COURSE Performing data analysis and forecasting in Excel 365
Likes 1 Likes 1  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

COURSE Working with Data in PivotTables
Likes 139 Likes 139  
COURSE Inserting PivotTables
Likes 238 Likes 238  
COURSE Using Conditional Formulas
Likes 114 Likes 114