PowerPoint

Create a table with nifty rounded corners (video)

This is the fifth in a series of quick video tips for business managers using PowerPoint by guest blogger Bruce Gabrielle, author of Speaking PowerPoint. Tables with rounded corners are friendlier, more contemporary, more web 2.0. But you can’t create them automatically. Here’s how you can achieve this effect using a handful of workarounds that include shapes, gradient colors, and background fills. — Bruce Gabrielle

Access

Power Tip: Supercharge conditional formatting by using a bit of code

Over the past few versions of Access, the product team has steadily added more conditional formatting functionality for forms and reports. For example, in Access 2010, you can add up to 50 conditional formatting rules for each object without having to write any Visual Basic for Applications (VBA) code. However, if you’re working in an earlier version, or if you just prefer to use VBA to perform formatting tasks on…

News

Out of the office? Reply to messages with Outlook

Matt Shelton contributed today’s post about how to use Out of Office and Automatic Replies to send email responses when you’re away from the office. Matt, a senior writer, focuses on creating Office content for teachers and students. If you can’t reply to e-mails during the work day (or if you’re away from your computer), you know how emails can pile up. And it can be frustrating when you email…

PowerPoint

Wrap text around pictures and shapes in PowerPoint? Avoid it!

We see a lot of questions about how to wrap text around a picture or a shape in PowerPoint. And it isn’t easy (though we do have articles for PowerPoint 2010 and PowerPoint 2007 that discuss admittedly complicated workarounds to achieve the wrapping effect). Since it’s hard and awkward to do, we see more comments from people who are unhappy about it than from people who say they find it…

Excel

America’s debt: Get the facts!

 The United States has a massive debt problem. Politicians have talked about why the country is in this position and what could be done about it. Tyler Chessman, the author of the book Understanding the United States Debt, used data to get to the bottom of the issue.  As a data expert, not an economist, Tyler analyzed data sets from several government sources using PowerPivot for Excel 2010 to determine where the…

Excel

A capital idea: Changing case in Excel (video)

Unlike Word, Excel doesn’t have a Change Case button or keyboard shortcut for magically switching between uppercase, lowercase, and proper case. Now, that doesn’t mean that you have to manually retype all your text. (In fact, the very thought of you doing that makes me weep.) Instead, you can use a function designed specifically for this job, or even a macro. Excel MVP Bill Jelen recently created a couple of videos…