Coursera

Free How to Use Lookup Reference Math and Text Functions in Excel — Guided Project

This guided project focuses on spreadsheet skills, using How to Use Lookup Reference Math and Text Functions in Excel as its central topic. It is delivered in English through Coursera.

How to Use Lookup Reference Math and Text Functions in Excel — free guided project from Coursera
Free learning access

The provider’s published access terms were checked on 16 November 2026 and identify the learning content as free. This listing does not rely on a paid subscription trial or a preview of only the first lesson. A provider account may be required; availability can change.

About this guided project

This guided project focuses on spreadsheet skills, using How to Use Lookup Reference Math and Text Functions in Excel as its central topic. It is delivered in English through Coursera.

The format is a focused guided project. Use it to practice a defined task, and allow additional time if you need to learn the software basics. It is not a complete professional qualification.

Official title How to Use Lookup Reference Math and Text Functions in Excel
Provider Coursera
Learning platform Coursera
Format Guided project
Language English
Level Intermediate
Listed duration 1.5 hours
Certificate The provider lists a completion certificate after all course requirements are met.

Learning focus

The learning focus is How to Use Lookup Reference Math and Text Functions in Excel. Review the provider’s full outline before starting, especially if the task uses software you have not used before. The related courses below can help you choose a useful next step.

Create a reusable working example

Build a small document, spreadsheet or workflow using fictional information. Check the result from the perspective of someone who did not create it: labels, instructions and the next action should be clear. Save an editable copy so that you can repeat the exercise.

Software plans and interfaces can change. Free course access does not guarantee free access to every commercial product, cloud service or advertising feature demonstrated outside the learning environment.

Enroll Now ↗

Some enrollment links may be affiliate links. Coursya may receive a commission if you make a qualifying purchase, at no extra cost to you.

Related courses for your next step

Frequently asked questions

Is the complete learning content free?

The provider’s published access terms were checked on 16 November 2026 and identify the learning content as free. This listing does not rely on a paid subscription trial or a preview of only the first lesson. A provider account may be required; availability can change.

Does the course include a certificate?

The provider lists a completion certificate after all course requirements are met.

What should I check before enrolling?

Check the language, prerequisites and current access terms on the provider page. Use the free learning option described above. If the provider has changed its offer or only shows a paid option, do not assume that a trial is the same as free course access.

Share this course

Questions & discussion

Share a useful question or correction. Comments appear after moderation. Please avoid personal or sensitive information.

  1. Good format but only basic level formulas shown. XLOOKUP not include. Needs to be updated or other advanced formulas

  2. Unlike other courses and guided projects I’ve taken, this one does not include a spreadsheet with all of the data we need. We are required to type everything up on our own spreadsheet. This was a little annoying, but I still would have stuck with it becasue the information was useful. However, the instructor seemed to be unaware of the fact that we are trying to follow along in a split screen mode. When it was time to work on a new sheet, we had to type everything up on a new worksheet, but her information was not visible. She needs to scroll over on her sheet so we can see her sheet and type on ours at the same time. I wish this class would have been set up properly. I ended up leaving the project to look for something better.

  3. Most of the time was wasted copying the data and information (manually) instead the instructor can opt to uplaod it next time.

  4. The course didint provide the excel files, and creating it manually cant get boring and unpleasant

  5. The instruction is very easy to follow for begineer, but it is better to make it obvious where can learners get the data file before the lesson starts such as write it down on the introduction page. It seems that the instructor did not update this project after they prepared the data file for learners to use.
    For learners who do not know where the data file is:
    First, follow the instruction login your Microsoft account in the cloud workplace.
    Second, go to OneDrive.
    Third, click upload file. You will probably see there is a file for you to upload to your OneDrive. That file is the data file.
    Fourth, open the data file and continue the lesson.

  6. It is explaining in the simplest way ,examples are good and simple and more complex example can be use for deeper understanding.

  7. This has been the only poor course so far. Some things made absolutely no sense to me. For whatever reason I didn’t retain much and couldn’t pass the final.

Add to the discussion

Your email address will not be published. Required fields are marked *