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…