How to Use Lookup Reference Math and Text Functions in Excel

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

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

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

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.

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. 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

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.