How to Generate Random Dates in Excel
You might need to generate random dates between two dates in Excel, for example, when creating a sample set of transaction dates to test formulas. I will show you how …
Steve Scott
List All Dates Between Two Dates in Excel
If your work involves tracking attendance, building project timelines, creating schedules, or similar tasks, knowing how to generate a list of all dates between two dates in Excel is a …
How to Add Years to a Date in Excel
If your Excel work includes calculating contract end dates, retirement dates, or similar timelines, knowing how to add years to a date can simplify your work. I will show you …
How to Remove Header and Footer in Excel
You should remove the headers and footers from your Excel reports when they add no value to the printed document or make it look cluttered and unprofessional. As shown in …
How to Shift Cells Down in Excel (8 Easy Ways)
When working with Excel, you may sometimes want to rearrange your data and shift some cells down to make room for new cells. There are multiple ways to do this, …
How to Use Wildcard in XLOOKUP
Want to supercharge your Excel lookups? Wildcards in XLOOKUP let you match fragments of text, hunt down partial entries, and return accurate results even when you don’t know the full …
Create a Drop-down List with Color in Excel
When you create a drop-down list in Excel, it only displays text options. But sometimes you may want it to show colors, too. Although you can’t display colors in the …
How to Convert Minutes to Hundredths in Excel
If you want to use minutes data in Excel in arithmetic calculations, you need to first convert it into hundredths in Excel. And this is because Excel stores dates and …
Excel Dates Not Formatting – How to Fix?
One common frustration for many Excel users is that sometimes dates don’t act as dates. Sometimes they would appear as hash signs, sometimes as text, and sometimes in the wrong …
Get End of Year Date in Excel (Formula)
It’s a common task for many Excel users to get the last date of the current year or any specified year. In this tutorial, I will show you various formulas …
How to Insert an Image in a Cell in Excel
While Excel is designed primarily for calculations and data analysis, you can also insert images into cells. This feature proves valuable when creating product catalogs, inventory lists, or employee directories. …
Bulk Find and Replace in Excel
In Excel, the built-in Find and Replace feature works great when you need to find and replace a single value. But if you’re dealing with multiple values at once, it’s …