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!