Excel Tips
Rearrange Just One Row in Excel »
August 18, 2014
You have one row out of place in Excel. Sorting seems like a hassle. Is there a fast way to sling the row to the right place?
August 15, 2014
Need to remove duplicates in Excel? Excel 2007 introduced the Remove Duplicates command on the Data tab of the ribbon.
Secret DateDif Function in Excel Calculates Years, Months, Days »
August 14, 2014
Sometimes, you need to show each employee’s age in Years and Months. The cool|secret|sometimes buggy =DATEDIF function does the trick.
Wish Excel Had AutoAverage Like AutoSum? »
August 13, 2014
It already does! Open the tiny dropdown arrow next to the AutoSum icon, and you have AutoAverage, AutoMax, AutoMin, and AutoCount!
Copy the Quick Stats Values to the Clipboard »
July 10, 2014
The question came during an Excel seminar in Tampa: Wouldn't it be cool if you could copy the statistics from the status bar to the clipboard for later pasting to a range?
Learn Excel - "Charting Improvements in Excel 2013" »
June 17, 2014
Is your Excel work 'Chart Heavy'? Do you do a lot of Charting in Microsoft Excel? Curious about Charting in Excel 2013? Well, MrExcel is here to tell you that Charting improved greatly in Excel 2013, with new features like Recommended Charts, easier Combo Charts, and Chart Labels from Cells.
Cloud Computing is Dangerous when You don't Own the Cloud »
February 5, 2014
Cloud computing is dangerous when you don’t own the cloud. I learned that lesson again this week when Facebook removed the MrExcel.com page at Facebook. Gone are hundreds of Excel Q&A posts. Gone are event notices. Gone are the 2000+ fans who would be notified when I posted there.
Hilary Smart beats Alex Gordon in Excel Championships »
December 9, 2013
It was the second year for the ModelOff Financial Modelling championships and sixteen finalists competed head to head at Bloomberg on December 8, 2013. After four grueling hours, Hilary Smart was crowned the new ModelOff World Champion.
October 24, 2013
Excel dashboarding guru Mynda Treacy is offering an online course on building dashboards. The course is video based and available online 24/7.