Dec
1

Microsoft Excel tips & news digest from 19-November to 01-December 2011

Microsoft Excel digest: tips and tricks, interesting information and news

It’s the first winter day and Excel articles drop into the cyberspace like snowflakes. But unlike the latter they don’t melt and we attentively read them and present you the most beautiful ones. Today we are going to introduce you to quick MS Excel tips, interesting news and videos that are meant to warm up your experience with this application.

News: Introducing magic for data: CollateBox

This blog post may be interesting for you if managing data is part of your everyday life. It is a free online service that solves the basic problem of data collation (sharing and organizing). If you are interested, here is one more article that shows how the tool works: Making business easy for Jake with CollateBox.

If you want to test the service, you can get a beta invite here. But you should hurry up, the offer is limited!

Tip: insert picture into a cell comment

It is an absolutely nice video that shows how to paste pictures into Excel comments. It may be really useful if you want to improve a table with a list of products by adding their images. It both saves plenty of space and makes your spreadsheets more visual. You can insert photos, charts, drawings and such; hover your mouse over cells with comments and see the pictures.

Tip: Add data to Excel charts with Copy Paste

Read this quick tip with a solution that actually bubbles to the surface. Animated visuals on the page make it even easier. In addition the author gives a couple of bonus tips to finish it all up.

Tip: How to send this sheet to an e-mail in Excel 2010?

Have a look at the answer if you need to e-mail your MS Excel 2010 spreadsheet.

Tip: Three unknown uses of the AutoFilter tool

AutoFilter in Microsoft Excel allows filtering a large list of data to see only those records you need. It is irreplaceable if you work with huge tables and analyze their data. This tutorial covers three handy uses of the AutoFilter tool:

  • Finding typos and spelling mistakes
  • Filtering by colour
  • Counting records.

Video: Data’s got a brand new bag: PowerPivot for Excel

You should definitely check this short video out if millions of rows in Excel are not enough for you to organize your data.

That’s it for today. It’s high time to start searching for more useful tips which simplify your interaction with MS Office.

See you one of these winter days!

You may also be interested in:

Microsoft Excel autumn tips digest

Microsoft Outlook autumn tips digest

One Response to "Microsoft Excel tips & news digest from 19-November to 01-December 2011"

  1. Santanu Das says:

    Hi Maria,

    Thanks for mentioning CollateBox in your post.

    Regards,

    Santanu

Post a comment



Please note that we are on holiday until Sep-16, so we won’t be able to reply to your comments for a while, sorry.
Ultimate Suite for Excel Professionals
 
 
The best spent money on software I've ever spent!
Patrick Raugh
Ablebits is a fantastic product - easy to use and so efficient.
Debra Celmer
Excel is at its best now
Annie C.
I don't know how to thank you enough for your Excel add-ins
Jennifer Morningstar
Anybody who experiences it, is bound to love it!
Kumar Nepa
It's the best $100 we've ever spent!
Mike Cavanagh
I love the program, and I can't imagine using Excel without it!
Robert Madsen
One word… WOW!
Dave Brown
Love the products!
David Johnston
It is like having an expert at my shoulder helping me…
Linda Shakespeare
Your software really helps make my job easier
Jeannie C.
Thanks for a terrific product that is worth every single cent!
Dianne Young
I love your product
Brad Gibson
Awesome!!!
Sheila Blanchard