Data calculations in Microsoft Excel

提供方
Coursera Project Network
在此指導項目中,您將:

Create a free Microsoft 365 account

Use functions with criteria in Microsoft Excel

Perform calculations with criteria input in Microsoft Excel

Clock1.5 hours
Beginner初級
Cloud無需下載
Video分屏視頻
Comment Dots英語(English)
Laptop僅限桌面

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.

分步進行學習

在與您的工作區一起在分屏中播放的視頻中,您的授課教師將指導您完成每個步驟:

  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

指導項目工作原理

您的工作空間就是瀏覽器中的雲桌面,無需下載

在分屏視頻中,您的授課教師會為您提供分步指導

常見問題

常見問題

還有其他問題嗎?請訪問 學生幫助中心