In this video I show you to create a drop-down list in Excel that lets you select multiple items. Download the featured file here. Please note the featured file does not contain the VBA code required to complete the task. Unfortunately, WordPress does not allow me to upload macro-enabled workbooks. Step…
Read More
How to Calculate Age in Excel from Date of Birth or Specific Date
In this video I demonstrate how to calculate a person's current age as well as how to calculate their age on a specific date. Download the featured file here. Calculate a Person's Current Age The formula to calculate a person's current age is: =YEARFRAC(B2, TODAY()), where B2 is the cell that…
Read More
How to Convert an Excel File to a CSV File
In this video, I demonstrate how to convert an Excel file into a CSV file. This method will retain the original file and create an additional file with the data saved in CSV format. The method for doing this slightly differs between versions of Excel. Excel 365/2019/2016 Method Open the Excel…
Read More