Using Basic Formulas

Excel Microsoft 365 (Windows)    |    Beginner
  • 12 Videos | 58m 20s
  • Includes Assessment
  • Earns a Badge
Likes 704 Likes 704
Formulas in MS Excel for Office 365 are useful in helping you visualize data. This course explores the large collection of formulas available in the Excel searchable library. Learn how to program each data cell to perform calculations, insert subtotals, create automated cumulative totals, and apply a formula to a large number of entries with the fill down function. Observe how to employ the COUNTA, COUNTIF, number rounding, and replacement formulas. Other topics explore how to rank a value with the rank function; convert between binary and hexadecimal number systems; factorize division results with the QUOTIENT and MODE formulas, and generate random values.

WHAT YOU WILL LEARN

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

IN THIS COURSE

  • Playable
    1. 
    Inserting a formula using the function library
    5m 39s
    UP NEXT
  • Playable
    2. 
    Performing simple calculations
    4m 50s
  • Locked
    3. 
    Using automated formulas in a table
    3m 28s
  • Locked
    4. 
    Creating automated cumulative totals
    3m 12s
  • Locked
    5. 
    Inserting subtotals
    5m 3s
  • Locked
    6. 
    Counting cells in a range
    5m 30s
  • Locked
    7. 
    Ranking a value
    5m 36s
  • Locked
    8. 
    Rounding a number
    4m 52s
  • Locked
    9. 
    Using replacement formulas
    3m 42s
  • Locked
    10. 
    Converting number types
    2m 46s
  • Locked
    11. 
    Factorizing the results of a division
    2m 9s
  • Locked
    12. 
    Creating random values
    5m 33s

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 0 Likes 0  
Likes 67 Likes 67  
Likes 114 Likes 114  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Likes 856 Likes 856  
Likes 229 Likes 229  
Likes 547 Likes 547