Recent Posts

Excel

PivotTables can save the day in a budget crisis

This “Office Show” episode features a common dilemma: The budget data you want to analyze in Excel contains so many rows and columns of numbers that it seems like an impossible task to get it all sorted out. This is where PivotTables in Excel come in. PivotTables are brilliant at making sense out data chaos, because they do a lot of the work for you. They can automatically organize and…

News

Mail merge in Word and Publisher made easy

Mail merge in Office is not always the easiest thing to pull off correctly. But once you do, it can save you enormous amounts of time. Plus you can really impress your friends and customers with the results. Right now, when you’re getting ready for the holidays, is a great time to learn how to do it. Part of the problem is with the number of variables involved. There are…

News

How to embed a PowerPoint presentation on a web page

You can display a Microsoft PowerPoint presentation on your web page, such as your blog or SharePoint wiki page.Here’s a step-by-step guide: The presentation is stored in a public location in Windows Live SkyDrive, where you copy an HTML tag that you paste into the HTML of your blog or wiki page. That way, people can see the presentation without having to go to the SkyDrive folder. They advance through…

PowerPivot in Excel 2010: Millions of rows! (Insert Dr. Evil laugh here….)

PowerPivot for Excel is an Excel 2010 add-in that allows users to pull data from multiple sources, mash them up, and then build reports using regular pivot tables. You can even share these reports with others in Microsoft SharePoint (via PowerPivot for SharePoint). In this demo from Channel 9, Julie Strauss, Program Manager for Microsoft SQL Server Analysis Services, shows just how easy it is to get a better view…

News

New for Excel 2010: Sparklines!

Guest blogger Sam Radakovitz, program manager for Excel, has a post today on a sparklines, a new feature in Excel 2010. For Excel 2010 we’ve implemented sparklines, “intense, simple, word-sized graphics”, as their inventor Edward Tufte describes them in his book Beautiful Evidence.  Sparklines help bring meaning and context to numbers being reported and, unlike a chart, are meant to be embedded into what they are describing.  As you can see, I’m really…