MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Excel Tips


Consolidating to a Pivot Table

Consolidating to a Pivot Table »


October 12, 2017

Consolidate several ranges in Excel to a single pivot table. This episode will show you how.

Consolidate Sheets

Consolidate Sheets »


October 11, 2017

Today, an ancient technique called Data Consolidation. If you have to combine data from multiple worksheets or multiple workbooks, Consolidation can handle the job if your data is in a specific format. Learn more about this ancient tool.

Extract Uniques

Extract Uniques »


October 10, 2017

There is a killer formula for extracting the unique values that match a criteria. It requires Ctrl+Shift+Enter, but it is powerful and cool.

Formatting as Facade

Formatting as Facade »


October 9, 2017

This article reveals hidden secrets about Excel number formatting. How you can store numbers in Excel but add words next to the numbers. Read on for more cool tips about number formatting.

Mark Linked Cells

Mark Linked Cells »


October 6, 2017

How to use conditional formatting to mark cells that link to another worksheet or workbook.

SUMIFS

SUMIFS »


October 6, 2017

SUMIF and COUNTIF were great when they were introduced in Excel 97. But they could only handle one condition. The new, superior SUMIFS handles up to 127 conditions.

Deleting Alternating Blank Rows

Deleting Alternating Blank Rows »


October 5, 2017

Every other row in Excel is blank. How can you quickly delete the blank rows?

Preventing Formula Errors

Preventing Formula Errors »


October 5, 2017

Preventing formula errors in Excel using IFERROR or IFNA. These are better than the old ISERROR ISERR and ISNA. Learn more here.

Year over Year % Growth »


October 4, 2017

Excel Pivot Table technique to calculate year over year growth percentage for each product, each customer, or anything.

Flash Fill

Flash Fill »


October 4, 2017

Flash Fill debuted in 2013. It is an oddity, but it can be used to transform columns of data quickly. Join columns with text, extract data from columns, all by giving Excel 1 or 2 examples of the final result.

TEXTJOIN in Power Query

TEXTJOIN in Power Query »


October 3, 2017

CONCATENATEX in Power Query. The new TEXTJOIN function is awesome. Can you do the same thing with Power Query? Yes. Now you can.

April Fools Day Trick

April Fools Day Trick »


October 3, 2017

How to drive your co-workers crazy with the Excel command: Speak Cells on Enter. This is an obscure command that most people don't know about. It is hard to find. But if you enable the feature while your co-worker goes to get a cup of coffee, hilarity will ensue.