Excel Roundup 20150216
In this video, Bill Jelen (Mr. Excel) and Mike Girvin (ExcelIsFun) show two different ways to insert an apostrophe at the start of a long column of numbers.
There is an interesting bit of history, starting at the 1:00 mark – Bill shows how that apostrophe, and other characters, affected cell entries in old versions of Lotus 1-2-3.
Or watch on YouTube: Add Leading Apostrophe to Column of Data
Here’s what I posted recently:
- Hide pivot table subtotals quickly, using a Ribbon command or a macro.
Other Excel Articles
Here are a few of the Excel articles that I read recently, that you might find useful.
- Here's another reason to start using Power Query. Gašper Kamenšek shows how to get all the data from a folder.
- Jan Karel Pieterse has updated his comprehensive article on working with circular references in Excel.
- In case you missed any of the new features in Office 365, you can check this list of what was added in January 2015.
- If you don't mind clicking though the items one at a time, ComputerWorld UK has 10 free apps to boost your Excel and Word 2013 productivity.
- Excel is easier to use if you understand basic math, so your kids might enjoy playing Prodigy, a free online math game. My 7-year-old grandson loves it!
- The Investintech blog shares 9 simple tips for working with Excel data. Of all those tips, I probably use #4 most often. How about you?
- Jordan Goldmeier is presenting at this year's PASS Business Analytics conference, and has released an hour-long preview webinar for his session – Creating Outstanding Spreadsheet Models.
- Here is another use for pivot tables – Susan Wenograd uses them to visualize search query mismatches, for AdWords reports.
Here are some upcoming events, courses, recently published books, and other new items, related to Excel.
- Chandoo has a new online course – 50 Ways to Analyze Your Data. It is not for beginners though – you should have at least intermediate or higher level Excel skills for this course.
- Excel 2013 for Biological and Life Sciences Statistics, (pre-order), by Thomas J Quirk, Meghan Quirk, Howard Horton
- "This is the first book to show the capabilities of Microsoft Excel to teach biological and life sciences statistics effectively. It is a step-by-step exercise-driven guide for students and practitioners who need to master Excel to solve practical science problems. If understanding statistics isn’t your strongest suit, you are not especially mathematically-inclined, or if you are wary of computers, this is the right book for you."
- Microsoft Office for iPad Step by Step, by Joan Lambert
- "This is learning made easy. Get productive fast with every Office for iPad app–plus OneNote, too! Jump in wherever you need answers–brisk lessons and colorful screen shots show you exactly what to do, step by step."
- Problem Solving Cases In Microsoft Access and Excel, (pre-order), by Ellen Monk, Joseph Brady, Gerard S. Cook, Emillio Mendelsohn
- "Helps you effectively apply the Access database management system and Excel spreadsheet to analyze and solve real-world business problems. Six user-friendly tutorials build your practical knowledge as they walk you step-by-step through each software application's capabilities, while 12 all-new case studies present scenarios and problems common in today's business practice."
- Amsterdam Excel Summit, April 13-15, 2015. Mark your calendar for April 13-15, so you can attend this amazing Excel event. Last year's summit was an outstanding success, and registration will open soon, for this year's event. Registration is now open, and you can click here to register.
Share Your Events and Articles
If you read or wrote any other interesting Excel articles recently, or have upcoming Excel events, please let me know. Thanks!
Links to Recent Excel Books on Amazon.com