MrExcel News


Resolve to Learn Power Query in 2018 »

February 2, 2018

Power Query is the most amazing set of features to arrive in Excel in twenty years. It might take 18 months to learn how to be proficient using VBA macros in Excel. But you can get completely up the Power Query learning curve in hours or days.


Free Excel Dashboard Webinars from Mynda Treacy »

January 30, 2018

Mynda Treacy is recognized as the leading expert on creating amazing interactive dashboards by using the tools already in Excel. She will be sharing her secrets in a free webinar.


Bill 'MrExcel' Jelen To Present at InDesign Conference in New Orleans »

January 23, 2018

CreativePro Week is the best event for every creative professional who designs, creates, or edits in Adobe InDesign, Adobe Photoshop, or Adobe Illustrator. CreativePro Week combines four amazing conferences in a single week.


How to Pass Your Interview Excel Test »

January 17, 2018

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 »

December 29, 2017

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 »

December 24, 2017

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 »

November 29, 2017

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 »

July 21, 2017

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.