Through Excel Learning series my aim is to help you learn Excel. These videos are produced using the Excel 2016 version, however, shall help you learn even if you are using Excel 2019, 2007, 2010, 2013 as they all have same basics with some differences which I will highlight in the course to enlighten you.
I will produce 1 or more than 1 video every week. If I get enough room to produce these videos, I will ensure to bring you at least 1 video every day.
Overview When working with time data in Excel, you may need to calculate the difference between two time points and display the time difference in minutes only. Excel provides a simple way to calculate this, ensuring accurate results even if…
Creating a Multi-Select Drop-Down List in Excel: Two Techniques Creating an Excel drop down list with multiple selections can significantly enhance your spreadsheets’ functionality and user experience. Whether you’re utilizing Excel for personal or professional tasks, this feature can be…
If you’ve ever wanted to convert numbers into words in Excel, VBA (Visual Basic for Applications) can make it happen. Whether it’s for financial reports, invoices, or educational purposes, you can use VBA to spell out numbers in words. Let’s…
With this post, my aim is to help you Locate information using Match Function in Excel. In the practice file of this video lesson, I have three sheets: See it: This is where I will demonstrate the lesson. Do it:…
HLookup in Excel is a post where I will help you to understand how to use the hlookup function in Excel. By the end of this post, you will be comfortable using the hlookup function in Excel. HLookup searches for…
Vlookup Based on Dropdown Selection in Excel is a video demonstration that will help you to understand how to build VLookup in Excel based on dropdown selection. Vlookup Based on Dropdown Selection in Excel tutorial requires you to be aware…
Overview Return custom value in VLookup of Excel is an article that will help you understand how you can return a custom value when your VLookup succeeds. Good to know This exercise for returning a custom value in VLookup requires…
You must be logged in to post a comment.