Excel Roundup 20141110

One Excel annoyance is that after you select a group of cells, you can’t unselect one of them. For example, you might want to format specific cells, or create a named range, and you accidentally include a cell that shouldn’t be in the group. You can’t click on that cell to unselect it – you have to start over, and select more carefully the next time.

To solve that problem, Doug Glancy has created a free tool that you can download — SelecTracker.

Next, we need a version that lets you unselect one cell within an large area, e.g. if you drag down from A2:A7, click on cell A5, to unselect it.

Excel SelecTracker add-in

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.

  • I’m sure you’ve heard that Microsoft Office apps, including Excel, are now free for the iPad. Jared Newman takes a look at what you get.

Excel Announcements

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

LONDON Chris Webb is running a one-day Power Query course in London on Nov. 13, 2014.

This course is aimed at Excel users and BI professionals who want to learn how to use Power Query to load data into Excel and use it with Power Pivot and the rest of the Power BI stack. The course will include practical exercises, and for attendees to take part they must bring a laptop with Excel 2013 and Power Query installed.

Advanced Excel Essentials, by Jordan Goldmeier

“For Intermediate or advanced excel users who wish to learn how to be more productive and develop more powerful applications…starts from the assumption that you are well-versed in Excel—and builds on your your skills to take them to the advanced level.”

Six Sigma Statistics with Excel and Minitab, 2E by Issa Bass

“This practical guide provides the perfect toolbox of theory, illustrations, explanations, exercises, and case studies both in the book and on an affiliated website to show how to use Excel and Minitab in conjunction with Six Sigma for an ideal improvement package.It reviews the quality tools that require Excel and/or Minitab, including measurement system analysis, SPC, the Taguchi method, and process capability

LONDON Abbot Katz is presenting a series of Excel courses in London on consecutive Monday evenings, in November, at the offices of the Guardian newspaper near the Kings Cross station.

Nov 10th — Formula and function writing
Nov 17th — Visual enhancements
Nov 24th — Grabbing and grooming the numbers


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