Excel Roundup 20141020

In this video, sports scientist, John Lythe, shows how you can create 4 dynamic Excel charts in 10 minutes.

Or watch on YouTube: Make Four Dynamic Excel Charts in 10 Minutes

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:

  • In a very short video, Sara Silverstein, from Business Insider, shows how to run a multiple regression in Excel and actually understand the results. Even if you’re not a statistics pro, it’s worth watching.
  • If there’s anything that you need to know about arrays in VBA, you’ll find it in snb’s latest article. If it’s not in this extensive list, you probably don’t need to know it!
  • Winston Snyder wrote some code to find the first and last used cells on a worksheet, and outlines the steps he went through to get there.
  • David Kandie shows how to show 3 sets of data in one chart, using different scales.

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 only until this Thursday, Oct. 23rd.

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.

   
Excel University Volume 3 – Excel Training for CPAs and Accounting Professionals, by Jeff Lenning, CPA

“This volume covers PivotTable basics and a comparison between formula-based and PivotTable reports…Explores options to replace formula-based reports with PivotTables when appropriate…Efficient ways to get data into workbooks, summarize it graphically with PivotCharts and other Excel features.

   
excelsumo

Excel Sumo — The sporting contest of Microsoft Excel Spreadsheets, Formula and Add-Ins

Enter your best Excel solution in the Excel Sumo tournament by Nov 3, 2014. Free registration – read the details here

There are four categories of Excel Sumo for your submission (you can choose multiple).

  1. Business and Productivity
  2. Lifestyle
  3. Fun and Entertainment
  4. Technical (e.g. VBA, Macros, Data Visualization)
   
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  

_________________________________

You may also like...

2 Responses

  1. Erik Svensen says:

    Thanks for the mention :-)

Leave a Reply

Your email address will not be published. Required fields are marked *