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.
Or watch on YouTube: How to Create a Scrolling Table in Excel
Here’s what I posted recently:
- After you create a custom Ribbon tab, design and add your own icon to it
- You can download my Excel weekly meal planner, which creates a pivot table shopping list, grouped by grocery store section.
- 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:
- Alan Murray shows how to create a battery chart. It's based on a 3-D stacked cylinder, but he shows it without rotation.
- Can Excel help your love life? OKcupid founder on big data, Excel tinkering and the results of that for his company.
- For a bit of fun, try creating formulas in the interactive Pizza Party Panic. You have to type in the cell references, but it's an interesting experiment..
- Abbott Katz had a problem with rounding in pivot table groups, and was able to solve it, with a bit of indirect help from me.
- Ken Puls explains how to pull named ranges into Power Query, from the workbook.
- Brad Edgar uses options buttons and the CHOOSE function to control the display on a dashboard.
Here are some upcoming events, courses, recently published books, and other new items, related to Excel.
|Mynda Treacy’s Excel Dashboard course is open for registration, until Oct. 23rd. Save 20% if you sign up by Oct. 16th.
I highly recommend this online course, which has excellent content, and great student support from Mynda.
BONUS: If you sign up for the course through this link, you can have a copy of any one of my Contextures Products.
When you sign up, type DebraD in the Code box, and email me your receipt number.
|Practical Numerical Methods for Chemical Engineers: Using Excel with VBA by Richard A. Davis
“This latest 3rd edition continues to expand the breadth of practical numerical methods with over 100 VBA macros for extending Excel's power for engineering & scientific analysis. Engineers & scientists will find the enhanced coverage of computational tools applicable to a variety of problems in their own disciplines.”
|Excel VBA for Financials, 2-day course led by Excel experts, Jan Karel Pieterse and Tony de Jonker
This Dutch course is specifically aimed at the Finance professional. It has no frills, and no technical mumbo-jumbo – just the VBA you need to achieve more success in your daily job.
Date: November 19 and December 3, 2014
Location: Utrecht (Netherlands)
Share Your Events and Articles
If you read or wrote any other interesting Excel articles recently, or have upcoming Excel events, please share a link in the comments below, with a brief description. Thanks!
Links to Recent Excel Books on Amazon.com