Using Basic Formulas in Excel 2019 for Windows

Excel 2019 (Windows)    |    Beginner
  • 12 Videos | 51m 12s
  • Includes Assessment
  • Earns a Badge
  • Certification CPE
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. In order to practice what you have learned, you will find the Word document named Excel 2019 for Windows: Using Basic Formulas Exercise as well as the associated materials in the Resources section.

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 in Excel 2019 for Windows
    5m 21s
    UP NEXT
  • Playable
    2. 
    Performing simple calculations in Excel 2019 for Windows
    4m 53s
  • Locked
    3. 
    Using automated formulas in a table in Excel 2019 for Windows
    3m 44s
  • Locked
    4. 
    Creating automated cumulative totals in Excel 2019 for Windows
    3m 10s
  • Locked
    5. 
    Inserting subtotals in Excel 2019 for Windows
    5m 13s
  • Locked
    6. 
    Counting cells in a range in Excel 2019 for Windows
    6m
  • Locked
    7. 
    Ranking a value in Excel 2019 for Windows
    4m 48s
  • Locked
    8. 
    Rounding a number in Excel 2019 for Windows
    4m 55s
  • Locked
    9. 
    Using replacement formulas in Excel 2019 for Windows
    3m 18s
  • Locked
    10. 
    Converting number types in Excel 2019 for Windows
    2m 55s
  • Locked
    11. 
    Factorizing the results of a division in Excel 2019 for Windows
    1m 55s
  • Locked
    12. 
    Creating random values in Excel 2019 for Windows
    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.

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Likes 231 Likes 231  
Likes 2832 Likes 2832