Managing Data

Excel 2019 (Windows)    |    Intermediate
  • 8 Videos | 54m 26s
  • Includes Assessment
  • Earns a Badge
  • Certification CPE
  • Certification PMI PDU
Likes 50 Likes 50
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

  • Playable
    1. 
    Importing data from a text file
    4m 39s
    UP NEXT
  • Playable
    2. 
    Importing data from a .csv file
    4m 38s
  • Locked
    3. 
    Finding a value in a double entry table
    6m 57s
  • Locked
    4. 
    Using the IFS & SWITCH functions
    6m 38s
  • Locked
    5. 
    Calculating average with different conditions
    4m 3s
  • Locked
    6. 
    Using the MAXIFS & MINIFS functions
    4m 17s
  • Locked
    7. 
    Finding data with multiple conditions
    4m 53s
  • Locked
    8. 
    Forecasting data
    6m 22s

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

Likes 266 Likes 266  
Likes 50 Likes 50  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Likes 50 Likes 50  
Likes 176 Likes 176  
Likes 266 Likes 266