Over the last few years, there has been much debate about the merits and perils of Microsoft Ribbon UI in Excel 2007. Personally I think ribbon is a good way to explore an application. I have gotten used to it since I tested excel 2007 for first time. Now, during the rare occasions I work on excel 2003, I feel strange navigating through a bunch of menus to do even the simplest things (like aligning cell content vertically).
As more and more people are migrating to excel 2007 (and eventually to excel 2010) it is very important to master the ribbon UI to be productive with spreadsheets.
So to make you an excel guru, I am releasing a free learning guide to excel 2007 ribbon interface.
The learning guide has 10 pages. It explains 7 ribbons and has 3 more pages of ribbon tips. The ribbon tabs explained are,
- Home ribbon tab
- Insert ribbon tab
- Page Layout ribbon tab
- Formulas ribbon tab
- Data ribbon tab
- View ribbon tab
- Review ribbon tab
See the sample page for insert tab (click on it to see at higher resolution)
Download the free Excel 2007 learning guide now
Click here to download the Using Excel 2007 Ribbon – Learning Guide.
What is the catch?
There is no catch, except that, I am in a generous and becoming-a-daddy mood.
But if you must catch, just go ahead and sign-up for our e-mail news letter. It is free, awesome and packed with super-cool tips. And as if there is not enough free, you will also get a 25 page free e-book on using excel when you sign-up. It has 95 really fun and productive excel & charting tips.
Go…
11 Responses to “MLB Pitching Stats Dashboard in Excel+VBA by our VBA Class Student”
Hey Dan,
Thanks a lot... this is too good 🙂
Awesome stuff Dan! very impressed..
Thanks guys.
Some nice ideas in there, thanks for sharing. I noticed the list with teams has a missing value though ('Arizona Diamondbacks'). Also when manipulating Pivot Tables with VBA you should be really careful not to try to select a value that isn't in the Pivot Table, if you do all hell breaks loose 🙂 That's not the case here but just some advise as I learned the hard way...
Ah.....ya caught me.
dnrTeamName drives both the charts and the drop down list. It refers to:
=OFFSET(PvtTeams!$A$6,0,0,COUNTA(PvtTeams!$A$6:$A$40),1)
If you change A6 to A5, it fixes that little issue.
A better question though, who actually cares about the Arizona Diamondbacks?
🙂
Excellent post. Thanks
Great job, Dan! Thanks a million!
[...] MLB Pitching Statistics Dashboard [...]
Gr8 work Dan
Hi,
I downloaded file, but looks like everything is in xml. Was there suppose to be excel file as well?
Thanks!
I'm late to the party, but seeing this file in action and studying the underlying data in this Excel file has been AWESOME. I have TONS of new ideas to implement in my work files now. THANK YOU Dan and Chandoo!