MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Excel Tips

Shift Subtotals Right 1 Column

Shift Subtotals Right 1 Column »

November 6, 2017

You've added subtotals in Excel. But you want those subtotals to move one column to the right, so they will be easy to see. Here is a method.

Fill Weekend Dates

Fill Weekend Dates »

November 6, 2017

Excel Fill Weekend Dates. While Excel has a secret option to fill weekdays, there is no good way to fill weekend dates. This article will show you how.

Sales by Region & Team

Sales by Region & Team »

November 3, 2017

You have a report showing sales for 16 sales reps. Each sales rep belongs to a team. How can you create a report showing total sales for each team?

Bottom 5 Months

Bottom 5 Months »

November 3, 2017

Which are the bottom five months of rainfall? Learn how to solve this problem using a pivot table.

Ctrl+Click to Insert Columns

Ctrl+Click to Insert Columns »

November 2, 2017

Excel fast way to insert many columns using the F4 key to Redo.

Sentiment Analysis

Sentiment Analysis »

November 2, 2017

Sentiment Analysis in Excel! There is a free add-in from Microsoft Labs that will let you do sentiment analysis in Excel. What if you have to wade through hundreds of survey comments to see what people think of your company? Excel can assign a probability showing how positive or negative each comment is.

Map Charts

Map Charts »

October 31, 2017

In 2017, Excel introduced a new chart type called a Map Chart. These maps will shade each country based on a value. Also, shade each state, province, county, zip code, and so on.

Golf Handicap

Golf Handicap »

October 30, 2017

How to calculate a Golf Handicap in Excel

Track Changes in Formula Cells

Track Changes in Formula Cells »

October 30, 2017

Track Changes in Excel Formula Cells. Can you show which items just changed as a result of changing certain input cells?

SUMIF Visible Cells

SUMIF Visible Cells »

October 27, 2017

How to use a SUMIF to sum the *visible* cells that match a criteria. For example, sum all of the records where the Region="East", but ignore the rows that are already hidden. You will be surprised at the function that saves the day.

Advanced Filter

Advanced Filter »

October 27, 2017

Using Advanced Filter in Excel to solve Mort's problem. Although regular filters have gotten more powerful, there are still times that the Advanced Filter can do some tricks that others can not.

Fill without Formatting

Fill without Formatting »

October 26, 2017

Fill without Formatting. Sometimes you need to copy a formula but not screw up the existing formatting. Learn how with this article.