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 …
Steve Scott
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 …
Get a List of All Sheet Names in Excel
You may want to list all sheet names in your Excel workbook, for instance, when creating a Table of Contents (TOC) for easy navigation across multiple sheets. I will show …
How to Open Multiple Instances in Excel
In Excel 2013 and later, each workbook you open is displayed in its own window. However, all the open workbooks run within a single Excel instance by default. This means …
Generate All Possible Combinations from Two Lists
In Excel, you may sometimes want to generate all possible combinations from two lists, for instance, to display all product variations. I will show you how to accomplish this in …
Convert Fraction to Decimal in Excel
In Excel, working with decimals is often easier than fractions. That’s why you might want to convert fractions to decimals—it just makes things simpler. I will show you how to …
Make Pivot Table from Multiple Sheets
You want to create a Pivot Table from data spread across multiple sheets in a workbook. How do you do it? In this tutorial, I will show you three ways …
Reorder Rows in Pivot Table in Excel
When you create a Pivot Table, by default, Excel orders the rows based on the row labels’ data type. This means that: If the default row order in a Pivot …
Count Distinct Values in Excel Pivot Table
When you create a standard Pivot Table from a dataset containing duplicate values, the count summary will, by default, include all values, including duplicates. For instance, in the dataset shown …
Count Colored Cells in Excel
You may get a dataset with colored cells done manually or using conditional formatting to highlight specific data, such as completed tasks, pending approvals, or key milestones. To analyze this …