# Tag Archives: Microsoft Excel

## Add a calculator to the Excel toolbar

There’s a calculator in Excel 2010 but by default this feature is hidden, to get the calculator on your Excel screen navigate to Quick Access toolbar options, it’s the down… Read more »

## Power of Paste Special – Multiply

For some of you this is already known, but I know there are users who are not aware of the power of the Paste Special Dialog. Suppose you have been… Read more »

## How to remove leading spaces from Excel cells?

Leading spaces can cause major issues with automated reports and Excel lookups as values that might have been set previously no longer match what is in the data. Imagine if… Read more »

## How to convert a date into a month name?

Converting a date into a month name is an extremely easy thing to do in Excel, but like everything it is only easy if you know how There are a… Read more »

## Trick to Complex Excel Formulas

There comes a time in many Excel users’ careers where we start to write incredibly complex Excel formulas to summarize or extract data from poorly structured workbooks. I’m not talking… Read more »

## A trick with MONTH() Function in Excel

I guess we are all familiar with the MONTH function in Excel. If you give it a date as an argument, it will return the month number. So far so… Read more »

## When to use Multi-Cell Array Formulas

Excel Multi-cell array formulas are a single formula which returns multiple values and is entered into multiple cells. Hence ‘multi’ in the name. Let’s look at an example, say we… Read more »

## How to enter same Formula in multiple cells?

As you probably know, there are a TON of ways to copy or fill formulas. I am going to show you the technique that works best when you already have… Read more »

## Fill All Blank Cells in an Excel Range With a Desired Value

Here’s a nifty little trick I use every day while working in Excel. It’s a two part trick. Part one will be selecting all the blank cells in a range… Read more »

## Formula to get the start or end of the week date

On many occasions and in many dashboards, time will be the main factor of your analysis and reports. As far as time goes, you can do a Yearly, Quarterly, Monthly,… Read more »