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…

Updated! Interactive Excel files on web pages: An Excel PM explains

Update: See near the end of this post for the latest Office how-tos on embedding Excel and PowerPoint files. Hi everyone, My name is Larry Waldman and I’m a program manager on the Excel team. This week the Crabby Office Lady was nice enough to let me combine a couple of Office’s cool features to highlight one of my favorite little tricks. (Note that this post and these features refer to…