Managing Data

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

  • 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

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Likes  53
Likes  74
Likes  50