
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.
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
- Continue learningExcel Formulas and Functions: Free Course
Explore another free course in spreadsheet skills or a closely related subject.
Free learning
- Continue learningFree Excel and Word Mini-Course: Fill Techniques, Text Cleanup and Tables
Explore another free course in spreadsheet skills or a closely related subject.
Free learning
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.
Good format but only basic level formulas shown. XLOOKUP not include. Needs to be updated or other advanced formulas
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.
Most of the time was wasted copying the data and information (manually) instead the instructor can opt to uplaod it next time.
it was a good course
would to study another course from you maam
Thank you
The course didint provide the excel files, and creating it manually cant get boring and unpleasant
Easy to understand and very fast.
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.
nice
Such training courses help an individual to grow and improve skills for the better job assignments.
very good project
The workspace needs to be improved it was too small to work in comfortably
It is explaining in the simplest way ,examples are good and simple and more complex example can be use for deeper understanding.
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.
I finish my second project with this instructor and I am very happy about it.
Muy bueno si te interesa aprender formulas.