Welcome to the new look for MrExcel.com. The site was originally built using simple HTML and Notepad back in 1998.
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 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.
Microsoft Excel offers many invoice templates that you can download. But there is no built-in way to increment to the next invoice number.
You might have two reasons to want to split a workbook where each worksheet becomes a new workbook.
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.