MrExcel Consulting
Your One Stop for Excel Tips & Solutions

MrExcel News


How to Pass Your Interview Excel Test

How to Pass Your Interview Excel Test »


Many job positions require candidates to have a mastery of Excel. Therefore, employers would like to test potential candidates during the interview process to ensure they can complete the Excel tasks that are required for the job. It is important to score high on your Pre-Employment Excel test and prove to you employer that you have what it takes to excel at the job.

Mail Merge to PDF from Excel

Mail Merge to PDF from Excel »


On January 1, 2018, the minimum wage in New York City increases to $13.50. This means that millions of copies of form LS 54S or form LS54 – Notice and Acknowledgement of Pay Rate must be sent to workers. The State of New York provides a blank copy of this form as a password-protected PDF. How can you use Excel to prepare hundreds of such documents for your employees?

One Million Threads and Still Excelling

One Million Threads and Still Excelling »


Welcome to the new look for MrExcel.com. The site was originally built using simple HTML and Notepad back in 1998.

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.

Brute Force Solving in Excel

Brute Force Solving in Excel »


Lev is commissioner of a competitive swim league. He writes: "I am the commissioner of a swim league. There are eight teams this year. Each team hosts one meet and is the home team. A meet will have 4 or 5 teams. How to arrange the schedule so every team swims against every other team twice? In the past, when we had 5, 6, or 7 teams, I could solve it by pressing F9 until close. But this year, with 8 teams, it is not coming out."

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.