PowerPoint

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

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!…

PowerPoint

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.

Excel

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;…

Word

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…

Excel

Conditional Formatting Rules Simplified

Conditional formatting is a popular feature and is a great way to easily identify cells with a range that meet some criteria. However, users often want to create conditional formatting rules that go beyond comparing a cell’s value to a single value or a single cell reference – row or column comparisons are commonly requested operations. In this blog post, we will learn how to use relative references in conditional…