The cover slide in this presentation, with its 3-D column and pie charts, led me to believe that the content wouldn’t be too useful. However, a different person must have prepared the remaining slides, because they have some useful tips.
The last slide shows that the content is from Mike Alexander’s book, Excel Dashboards & Reports for Dummies, which was published last year.
Contextures Posts
Here’s what I posted recently:
- For a humorous peek at what other people are saying about spreadsheets, read the latest collection of Excel tweets, on my Excel Theatre blog.
Other Excel Articles
Here are a few of the Excel articles that I read recently, that you might find useful.
- Jon Peltier shows how to add option buttons to a worksheet, so you can select the data to display in a chart.
- MF shares another trick with the Ctrl + Enter shortcut – stay in the same cell, instead of moving down.
- On Microsoft’s Excel Team blog, Carl Kadie builds 3D graphics, and controls the rotation by typing a number in a worksheet cell. Download the sample file, to see how it works. And I agree with Carl’s conclusion – “If you want to understand something, make an Excel spreadsheet!”
- Michael Nellessen shares 3 of his favourite Excel formulas, with examples of how to use them. I’d recommend typing your criteria in worksheet cells, and referring to those cells in the formula, instead of hardcoding the values.
- Meagan Longoria used a combination of tips to fix performance issues with her Power View reports, that are based on a Power Pivot data source.
- A PhD student has calculated the optimal search path to find Waldo in a two page crowd scene. Is there a similar search path to find errors in a multi-sheet Excel file?
- Doug Jenkins tests the speed of different methods for slicing arrays with VBA. I’m relieved to see that other people write articles, then forget about them!
- If you’re starting to learn VBA, JD Sartain shares 5 essential tips for creating Excel macros. Tip #4 is valid if you’re following their advice to use relative references.
Excel Announcements
Here are some upcoming events, courses, recently published books, and other new items, related to Excel.
Excel Summit
- Amsterdam Excel Summit, April 13-15, 2015. Mark your calendar for April 13-15, so you can attend this amazing Excel event. Last year’s summit was an outstanding success, and registration will open soon, for this year’s event. Registration is now open, and you can click here to register.
Share Your Events and Articles
If you read or wrote any other interesting Excel articles recently, or have upcoming Excel events, please let me know. Thanks!