How to Use Lookup Reference Math and Text Functions in Excel

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

Use lookup reference, math and text functions in an Excel Spreadsheet by using a free version of Microsoft Office Excel.  

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

By the end of this project, you will learn how to use lookup reference, math and text functions in an Excel Spreadsheet by using a free version of Microsoft Office Excel.

分步進行學習

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

  1. Download Microsoft Office365 Excel Program and go over the basic view of Excel

  2. Use lookup references VLookup and HLookup formulas

  3. Use lookup references Match and Choose formulas

  4. Use math functions Sum and Average in Excel

  5. Use math functions CountA and CountIF and text functions in Excel

指導項目工作原理

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

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

常見問題

常見問題

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