Excel Roundup 20150223
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.
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!
- Sumit Bansal explains how to create a dynamic Pareto Chart in Excel, and you can download the sample file, and follow the tutorial.
- 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.
Here are some upcoming events, courses, recently published books, and other new items, related to Excel.
- Problem Solving Cases In Microsoft Access and Excel, by Ellen Monk, Joseph Brady, Gerard S. Cook, Emillio Mendelsohn
- “Helps you effectively apply the Access database management system and Excel spreadsheet to analyze and solve real-world business problems. Six user-friendly tutorials build your practical knowledge as they walk you step-by-step through each software application’s capabilities, while 12 all-new case studies present scenarios and problems common in today’s business practice.”
- Excel 2013 for Biological and Life Sciences Statistics, (pre-order), by Thomas J Quirk, Meghan Quirk, Howard Horton
- “This is the first book to show the capabilities of Microsoft Excel to teach biological and life sciences statistics effectively. It is a step-by-step exercise-driven guide for students and practitioners who need to master Excel to solve practical science problems. If understanding statistics isn’t your strongest suit, you are not especially mathematically-inclined, or if you are wary of computers, this is the right book for you.”
- Microsoft Office for iPad Step by Step, by Joan Lambert
- “This is learning made easy. Get productive fast with every Office for iPad app–plus OneNote, too! Jump in wherever you need answers–brisk lessons and colorful screen shots show you exactly what to do, step by step.”
- 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!
Links to Recent Excel Books on Amazon.com