Performing data calculations using formulas in Excel 365

Excel Microsoft 365 (2021)    |    Beginner
  • 10 Videos | 52m 15s
  • Includes Assessment
  • Earns a Badge
  • Certification CPE
  • Certification PMI PDU
Likes 5 Likes 5
The power of Excel 365 lies in the support given when using formulas with your data, which automatically update when the underlying data changes to ensure your calculations are always up to date. In this course, you will observe how to perform simple and more advanced calculations with formulas, including the use of built-in formulas such as SUM and COUNT, as well as working with formulas that include IFS, SWITCH, MAXIFS, MINIFS, COUNTA, OFFSET, COUNTIFS, MOD, QUOTIENT, and AVERAGEIFS. You will start by discovering how to perform simple calculations within an individual cell; then explore how to use formulas to create automated cumulative totals in a table and insert subtotals. Following this, you will learn how to use different formulas to count cells in a range. Learn how to perform logical operations such as IFS and SWITCH, MAXIFS, and MINIFS, and keep your data up to date with COUNTA and OFFSET formulas. Finally, you will explore how to configure default formula options, find data with multiple conditions, factorize the results of a division, and calculate average values under different criteria.

WHAT YOU WILL LEARN

  • discover the key concepts covered in this Microsoft 365: Performing data calculations using formulas in Excel 365 course
    perform simple calculations in Excel 365
    create automated running totals in Excel 365
    count cells in a range in Excel 365
    use the IFS and SWITCH functions in Excel 365
  • use the MAXIFS and MINIFS functions in Excel 365
    use the OFFSET function in Excel 365
    configure default formula options in Excel 365
    calculate averages with different conditions in Excel 365
    determine the remainder of a simple division in Excel 365

IN THIS COURSE

  • Playable
    1. 
    Course Overview: Performing data calculations using formulas in Excel 365
    56s
    UP NEXT
  • Playable
    2. 
    Performing simple calculations
    5m 12s
  • Locked
    3. 
    Creating automated running totals
    4m 16s
  • Locked
    4. 
    Counting cells in a range
    5m 30s
  • Locked
    5. 
    Using the IFS and SWITCH functions
    5m 40s
  • Locked
    6. 
    Using the MAXIFS and MINIFS functions
    4m 22s
  • Locked
    7. 
    Using the OFFSET function
    3m 3s
  • Locked
    8. 
    Configuring your default formula options
    4m 37s
  • Locked
    9. 
    Calculating average with different conditions
    2m 33s
  • Locked
    10. 
    Determining the remainder of a simple division
    2m 35s

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.