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. For example, if you drag down from A2:A7, you could click on cell A5, to unselect just that cell.
Here’s what I posted recently:
- Fix numbers that don't add or sort correctly, when you copy data into Excel from a website, or another source.
- The deadline has passed for the Pivot table online course giveaway. Winners will be announced on Wednesday.
- For a humorous peek at what other people are saying about spreadsheets, read the latest collection of Excel tweets, on my Excel Theatre blog.
This week, I've added a poll at the end, so please vote for your favourite tweet.
Other Excel Articles
Here are a few of the Excel articles that I read recently, that you might find useful.
- Neale Blackwood shares his 4 guidelines for formula creation. Do you agree with all of them?
- Did you celebrate International Keyboard Shortcut day last week? Dick Kusleika shared several of his favourites, including shortcuts to open, close and save workbooks.
- On Chandoo's blog, Sohail Anwar explains how you can use multiple conditions in a VLOOKUP.
- Even if you're not a lawyer, you can keep track of your time, with this technique from Ben J. Kusmin.
- Sumit Bansal compares the benefits of VLOOKUP versus using INDEX/MATCH.
- Mike Alexander had some trouble getting rid of the AutoFill Options menu that appears after you fill down on a worksheet.
- 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.
- Winston Snyder shows how he makes some subtle changes to an Excel Table's TableStyle.
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.
|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!
Links to Recent Excel Books on Amazon.com