With this video, you can learn how to build your own dynamic Unit Converter in Excel, performing very similar to the one on Google’s result page.
If you have intermediate Excel skills, you won’t have a problem to follow the step by step instructions and build the Conversion calculator by yourself.
With this mini-project, you will practice the following Excel skills:
- Dependable drop-down lists with data validation;
- Defining list names for ranges;
- Creating tables;
- Using functions like VLOOKUP, INDIRECT, CONVERT & IFERROR, and last but not least
- Recording and using macros.
I hope you will enjoy this video and will find the project interesting!
Nadia Karaboycheva 