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
Contextures Posts
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.
Excel Announcements
Here are some upcoming events, courses, recently published books, and other new items, related to Excel.
Excel Course
- 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 Summit
- 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!