Basic Formulas in Excel 2016 for Windows

Excel 2016 (Windows)    |    Beginner
  • 12 videos | 48m 21s
  • Includes Assessment
  • Earns a Badge
Likes 335 Likes 335
The power of Excel 2016 is the support provided for using formulas on your data. Learn how to work with formulas, including built-in formulas such as SUM and COUNT, perform rounding and ranking, and generate random numbers.

WHAT YOU WILL LEARN

  • Inserting a formula using the function library
    Performing simple calculations
    Using automated formulas in a table
    Creating automated cumulative totals
    Inserting subtotals
    Counting cells in a range
  • Ranking a value
    Rounding a number
    Using replacement formulas
    Converting number types
    Factorizing the results of a division
    Creating random values

IN THIS COURSE

  • Playable
    1. 
    Inserting a formula using the function library in Excel 2016 for Windows
    3m 57s
    UP NEXT
  • Playable
    2. 
    Performing simple calculations in Excel 2016 for Windows
    5m 20s
  • Locked
    3. 
    Using automated formulas in a table in Excel 2016 for Windows
    3m 50s
    FREE ACCESS
  • Locked
    4. 
    Creating automated cumulative totals in Excel 2016 for Windows
    3m 40s
    FREE ACCESS
  • Locked
    5. 
    Inserting subtotals in Excel 2016 for Windows
    3m 47s
    FREE ACCESS
  • Locked
    6. 
    Counting cells in a range in Excel 2016 for Windows
    4m 30s
    FREE ACCESS
  • Locked
    7. 
    Ranking a value in Excel 2016 for Windows
    5m 23s
    FREE ACCESS
  • Locked
    8. 
    Rounding a number in Excel 2016 for Windows
    4m 49s
    FREE ACCESS
  • Locked
    9. 
    Using replacement formulas in Excel 2016 for Windows
    3m 5s
    FREE ACCESS
  • Locked
    10. 
    Converting number types in Excel 2016 for Windows
    3m 2s
    FREE ACCESS
  • Locked
    11. 
    Factorizing the results of a division in Excel 2016 for Windows
    2m 30s
    FREE ACCESS
  • Locked
    12. 
    Creating random values in Excel 2016 for Windows
    4m 27s
    FREE ACCESS

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Course Solving data problems in Excel 365
Course Managing & calculating data in Sheets 2022
Course Using macros in Excel 365

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Getting Started in Excel 2016 for Windows
Likes 809 Likes 809  
Course Custom & Conditional Formatting in Excel 2016 for Windows
Likes 150 Likes 150  
Course Using Basic Formulas in Excel 2019 for Windows
Likes 266 Likes 266