Data calculations in Microsoft Excel

Offered By
Coursera Project Network
In this Guided Project, you will:

Create a free Microsoft 365 account

Use functions with criteria in Microsoft Excel

Perform calculations with criteria input in Microsoft Excel

Clock1.5 hours
BeginnerBeginner
CloudNo download needed
VideoSplit-screen video
Comment DotsEnglish
LaptopDesktop only

By the end of this project, you will create a free account on Microsoft 365, will get access to Microsoft Excel, you will create a table with data that you will later be able to manipulate to calculate sums, average amounts, percentages, and also calculate with certain criteria. Your new skills will help you efficiently manipulate data and operate with formulas that can help make more efficient management decisions in the future.

Learn step-by-step

In a video that plays in a split-screen with your work area, your instructor will walk you through these steps:

  1. Create a free Microsoft 365 account

  2. Use Sum and Average functions in Microsoft Excel

  3. Use Sum and Average functions with criteria input in Microsoft Excel

  4. Use Networkdays and Percentage functions in Microsoft Excel

  5. Perform calculations with criteria input in Microsoft Excel

How Guided Projects work

Your workspace is a cloud desktop right in your browser, no download required

In a split-screen video, your instructor guides you step-by-step

Frequently asked questions

Frequently Asked Questions

More questions? Visit the Learner Help Center.