Using Basic Formulas

Excel 2019 (Windows)    |    Beginner
  • 12 Videos | 51m 12s
  • Includes Assessment
  • Earns a Badge
  • Certification CPE
  • Certification PMI PDU
Likes 266 Likes 266
Put formulas to work with Excel 2019 for Windows. In this 12-video course, learners will observe how to work with formulas, including built-in formulas such as SUM and COUNT. You will begin by discovering how to insert a formula by using the function library, and then perform simple calculations within an individual cell. Explore how to use automated formulas in a table; create automated cumulative tools; and insert subtotals. Following on from this, you will learn how to count cells in a range by using different formulas, and then rank values, which is extremely useful if you want to find out where a particular value places on a list of data entries. The course also explores how to examine rounding a number, to round up or down your data values; use replacement formulas when you need to make changes; convert number types, and factorize the results of a division. Conclude the course by observing how to create random values.

WHAT YOU WILL LEARN

  • insert a formula using the function library in Excel 2019
    perform simple calculations in Excel 2019
    use automated formulas in an in Excel 2019 table
    create automated cumulative totals in Excel 2019
    insert subtotals in Excel 2019
    count cells in a range in Excel 2019
  • rank a value in Excel 2019
    round a number in Excel 2019
    use replacement formulas in Excel 2019
    convert number types in Excel 2019
    factorize the results of a division in Excel 2019
    create random values in Excel

IN THIS COURSE

  • Playable
    1. 
    Inserting a formula using the function library
    5m 21s
    UP NEXT
  • Playable
    2. 
    Performing simple calculations
    4m 53s
  • Locked
    3. 
    Using automated formulas in a table
    3m 44s
  • Locked
    4. 
    Creating automated cumulative totals
    3m 10s
  • Locked
    5. 
    Inserting subtotals
    5m 13s
  • Locked
    6. 
    Counting cells in a range
    6m
  • Locked
    7. 
    Ranking a value
    4m 48s
  • Locked
    8. 
    Rounding a number
    4m 55s
  • Locked
    9. 
    Using replacement formulas
    3m 18s
  • Locked
    10. 
    Converting number types
    2m 55s
  • Locked
    11. 
    Factorizing the results of a division
    1m 55s
  • Locked
    12. 
    Creating random values
    5m 1s

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 212 Likes 212  
Likes 75 Likes 75  
Likes 95 Likes 95  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Likes 212 Likes 212  
Likes 279 Likes 279  
Likes 1408 Likes 1408