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.

Or watch on YouTube: How to Create a Scrolling Table in Excel

Contextures Posts

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..

Excel Announcements

Here are some upcoming events, courses, recently published books, and other new items, related to Excel.

Excel Dasboard Course 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. 
A new Power Pivot course is available too, and you can get both courses in a bundle.

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.”

jankarelpieterse 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!

Weekly Excel Roundup http://blog.contextures.com/


Links to Recent Excel Books on Amazon.com

101excelformulas   excelfunctionsheld01