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…

Office 365

The secret to converting your presentation into a video

Did you know that you can save your PowerPoint 2010 presentations as Windows Media Player (.wmv) video files? Well, you can. And it only takes a few mouse clicks. You can then burn the video to a DVD, upload it to your blog or video-sharing web site, or email it to your professor to share the video file with people who don’t have PowerPoint installed on their computer. If you’re using…