Performing data calculations using formulas in Excel 365

Excel Microsoft 365 (2021)    |    Beginner
  • 10 Videos | 31m 9s
  • Includes Assessment
  • Earns a Badge
  • Certification CPE
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. In order to practice what you have learned, you will find practice exercises and samples in the Resources section.

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
    46s
    UP NEXT
  • Playable
    2. 
    Performing simple calculations
    4m 14s
  • Locked
    3. 
    Creating automated running totals
    3m 25s
  • Locked
    4. 
    Counting cells in a range
    4m 33s
  • Locked
    5. 
    Using the IFS and SWITCH functions
    4m 34s
  • Locked
    6. 
    Using the MAXIFS and MINIFS functions
    3m 26s
  • Locked
    7. 
    Using the OFFSET function
    2m 22s
  • Locked
    8. 
    Configuring your default formula options
    3m 46s
  • Locked
    9. 
    Calculating average with different conditions
    2m 2s
  • Locked
    10. 
    Determining the remainder of a simple division
    2m 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.