Rick Grantham explains what a Monte Carlo Simulation is, and shows how to run one in Excel.
You can download the sample file from his blog, and watch the video below, to see the steps.
New Workbook Based On Old One
It’s almost Halloween, and perhaps you’re familiar with the horror story that I’m about to tell you. It’s a frightening tale of an Excel workbook that was destroyed forever, by a well-intentioned, but easily-distracted genius.
Excel Roundup 20141027
If you’d like Microsoft to make Power Pivot available in all the Office 2013 and Office 365 packages, please sign the Friends of Power Pivot petition.
Excel Chart Compares High and Low Scores
Last weekend, I helped someone who needed a chart for a fantasy football league, to show the highest and lowest win/loss scores for each week. To help explain what it should look like, they posted a picture of a hand drawn chart, similar to the picture below.
By the way, I created the sketch in Excel, by using the Marker option, in the Artistic Effects. Who knew that Excel was so artistically talented?
Excel Roundup 20141020
In this video, sports scientist, John Lythe, shows how you can create 4 dynamic Excel charts in 10 minutes.
Or watch on YouTube: Make Four Dynamic Excel Charts in 10 Minutes
Excel Report Diagnostic Display
Did you ever print and distribute pivot table reports in Excel, only to discover – too late – that they weren’t showing the correct information? To help save you from wasted time and paper, and possible embarrassment, AlexJ is sharing his Report Diagnostic Display technique today.
You might remember some of his other handy tips, such as
Excel Roundup 20141013
The Power Map feature was improved last month, and this short video shows some of the things you can do with custom maps in Excel.
Or watch on YouTube: 6 Cool Ways To Use Custom Maps in Power Map
Mysterious Excel 2013 Filter Problems
A couple of days ago, I had problems while trying to run a simple macro in Excel 2013. Things didn’t go too well, and it took me quite a while to solve the problem. You can read the details below, and I hope it helps, if you ever run into a similar error.
Continue reading “Mysterious Excel 2013 Filter Problems”
Excel Roundup 20141006
In this video, Annie Cushing shows how to create a scrolling table, by using the INDEX function and a scroll bar form control. This technique would work nicely in a dashboard, where space is limited.
For more dashboard tips, take a look at Mynda Treacy’s Excel Dashboard course which has just opened for registration, until Oct. 23rd. Details are in the Announcements section, below.
Add Your Own Icon to an Excel Custom Ribbon Tab
Are you building custom tabs for your workbooks yet? Last year, I wrote a couple of articles about custom tabs:
- Custom Ribbon Tab for Excel File – how to open and edit the Ribbon Code
- Add Custom Ribbon Tab to Excel Workbook – create a custom tab and add buttons
Continue reading “Add Your Own Icon to an Excel Custom Ribbon Tab”