MrExcel Publishing
Your One Stop for Excel Tips & Solutions

MrExcel News

In Defense of P.F. Changs »

On November 22, 2017, an article in the Wall Street Journal headlined "Stop Using Excel Finance Chief Tells Staff". I appreciate that dozens of my friends and associates sent me a link to the article written by Tatyana Shumsky.

Excel Offers a New Sound Theme to Provide Feedback

Excel Offers a New Sound Theme to Provide Feedback »

Excel adds a new feature in July 2017 - Provide Feedback with Sounds. Go to File, Options, Ease of Access to find the new feature. Choose Modern as the Sound Scheme.

Next Invoice Number

Next Invoice Number »

Microsoft Excel offers many invoice templates that you can download. But there is no built-in way to increment to the next invoice number.

Split Workbook by Worksheets in Excel

Split Workbook by Worksheets in Excel »

You might have two reasons to want to split a workbook where each worksheet becomes a new workbook.

Sync Slicers in Excel

Sync Slicers in Excel »

How can you have a slicer drive two pivot tables if they came from different data sets? I recorded this video showing how to add a few lines of VBA code to your workbook to do this.