Tag: Excel

Posted in Excel, Tutorial

Excel Video Tutorial: World Geographic Heat Map With Real Covid-19 Data

Posted on by Nadia K

Follow step-by-step tutorial on how to build a World Geographic Heat Maps in Excel, using Covid-19 data from World Health Organization.

For more tutorials please make sure to check out the complete list of videos on EZ Excel YouTube Channel. Please also leave a comment of what you would like to learn in future and subscribe to the channel. Thank you.

Posted in Excel, Tutorial

Excel Video Tutorial: How to Build Dynamic Unit Converter

Posted on by Nadia K

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.

GoogleUnitConversion

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!