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

Contextures Posts

Here’s what I posted recently:

Other Excel Articles

Here are a few of the Excel articles that I read recently, that you might find useful.

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 Books

  • 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.”

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!

Weekly Excel Roundup http://blog.contextures.com/

_____________________

Links to Recent Excel Books on Amazon.com

_________________________________

You may also like...

3 Responses

  1. MF says:

    Hi Debra,
    Just wonder if this trick of using Ctrl+Enter is relevant to you.
    https://wmfexcel.wordpress.com/2015/02/07/ctrlenter-wont-let-you-down/
    Cheers,

Leave a Reply

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