Dec
15

Excel tips & news 15-Dec-2011: Get interactive with web-based Excel mashups

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

And again we picked several Excel news and tips for you. Check them out before Christmas holidays make you forget everything about work and get you on the bright carousel of presents, Champaign bubbles and holiday smiles.

News

Get interactive with web-based Excel mashups

Microsoft has launched a new web service known as ExcelMashup.com where you can embed an Excel file from Microsoft SkyDrive and mash it up with Excel Services JavaScript library to create interactive data visualizations. It’s a wonderful tool for web developers who work on handy Excel based web apps.

Microsoft Excel 2003 security update

This security update solves a privately reported vulnerability that could allow remote code execution if a user opens a specially crafted Excel file. This security update is regarded Important for all supported editions of Microsoft Excel 2003 and Microsoft Office 2004 for Mac. You can learn all the necessary details if you read this article on Microsoft Security Bulletin.

Tips & How-to for Excel

80 links to make you knowledgeable in any area of Excel

In this blog post Chandoo.org shares some of the best tutorials and examples for you to improve your Excel skills. The choice is based on the users’ answers to the question, which Excel area they would like to learn more. The links were divided into 16 groups with 5 best sources in each. Plus 1 or 2 training programs, plus excellent external resources. Great job!

Look up with Lookups in Excel

When you need to find information in a table the lookup functions in Excel can help. While there was a lookup wizard in earlier versions of Microsoft Excel that made the process of creating a lookup quite easy, this is no longer available in Excel 2010. So it’s very timely that Helen Bradley explains how to use the vlookup function in Microsoft Excel in this nifty post.

Embedding Excel files on your website

With Excel 2010, Microsoft introduced the possibility to edit Excel documents on-line. If you have a web account, you can place an Excel 2010 file on your SkyDrive. Then anyone with access to that folder can open it on-line for editing. You can learn more from the example.

Video: FIFA 12 - Excel tips and tricks - trading a list of players

If you are FIFA 12 fan and you are interested in selling footballers, in this video you will find some Excel tricks to help you trade a list of players.



Video: Drill through conditional formatting across sheets using format painter

We’ve also got some Excel magic for you. Watch how to conditionally format a row using a TRUE FALSE Logical Formula and drill through conditional formatting across sheets using format painter in this video blog post.




That’s all for today. Hope after reading this digest you have become one step closer to excelling in Excel.

See also:

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

Post a comment



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