Ride the Shark! It’s VLOOKUP Week March 25-31, 2012

What strikes terror into the hearts of Excel beginners? VLOOKUP! Excel power users, though, can’t live without it.  Excel MVP Bill Jelen has declared March 25 – 31, 2012 to be VLOOKUP week. He’s invited his fellow Excel experts to publish VLOOKUP posts on their sites during the week. Already it’s taken on a life of its own with VLOOKUP t-shirts and coffee mugs, and a theme song and logo.


Creating custom shapes in PowerPoint 2010

PowerPoint has a lot of great pre-set shapes, but sometimes what you really need is a tailor-made shape for your presentation. If you’re looking to go beyond the Freeform Tool and create more complex custom shapes, there’s a feature called Combine Shapes in PowerPoint 2010 that helps you do just that!  It uses the principles of Boolean Geometry, to help you create new shapes by combining multiple shapes in one of…


Access 2010: How to write expressions for Web queries, forms, and reports

Before Access 2010, Access supported a wide variety of expressions in different areas of the application.  Tables and fields, queries, form and report properties, controls, and macros can all use expressions to evaluate data or logic to drive the behavior of an application. In the past, each of these contexts in which an expression is used have shared a single, common expression evaluation engine. This means that no matter where…

Office 365

New Lower Prices for Office 365

Customers continue to give us fantastic feedback on Office 365. Since we launched last summer, we’ve been happy to serve great companies like JetBlue, Patagonia, Campbell Soup Company, Groupe Marie Claire, and Tata Steel Europe. We’re regularly delivering new value in the service, releasing updates now monthly, and recently brought Office 365 to another 22 new markets to grow our global footprint to 64 geographies¬† – with more to come!…


Use PowerPoint slide layouts to make presentations memorable

When all your slides look alike, your entire message can be blurred. At the end of your presentation, you want your audience to remember your main points most, and if they remember some of the details, that’s a plus. By making key slides distinctive, you can help people follow and retain the content in your presentation.  PowerPoint MVP Ellen Finkelstein shares her PowerPoint layout tips.


Samples for learning conditional formatting: icons, formulas, cell values, and more

When we released Excel 2010, we published a workbook for you to download, which contains samples of conditional formatting rules. The samples are really helpful for learning how to track trends, check status, spot data, and find top values. Some samples are for busineses and some just for fun. You can find out how to compare bicycles by using a rating scale; calculate sales for a specific region and target;…


Change the default line spacing in Word

When the default line spacing in documents changed from single spacing in Word 2003 to a slightly roomier 1.15 spacing in Word 2007 and Word 2010, customers asked the inevitable: Why did the default line spacing change? And how do I change it back? The short answer is that the default line spacing changed in Word 2007 to make online documents more readable. If you want to change the default line spacing in Word…