Excel

Portable formulas: A PowerPivot benefit you’ll never believe you lived without

This post is from former Excel team member Rob Collie, who is CTO of Pivotstream and writes the PowerPivotPro blog about his experiences adopting PowerPivot. How much time do you spend in Excel doing basically the same thing over and over again, like calculating “growth versus prior year?” My bet is you spend a lot of time doing that sort of thing. Maybe even the majority of your time. The reason for…

Excel

Learn the ins and outs of dates and formulas in this free training course

Have you ever wanted to subtract one date from another? Or find out how many workdays until vacation? Or maybe you need to figure out a project end date. You can do all of this and more by using date functions in Excel formulas. As long as you type a date in a format that Excel recognizes: 8/22/2011, 22-August-2011, or August 22, 2011, for example, Excel will interpret the date…

Outlook delegate access helps shoulder a principal’s burden

The issue of getting elementary schools—public or otherwise—on board with electronic communication has taken some time. It takes a strong leader, possibly in the form of a principal, to guide that effort. When you’re a busy school principal or administrator, your administrative assistants, secretaries, office managers, and other support staff are of vital importance to the day-to-day operations of the front office. If you’re using Outlook with Microsoft Exchange, you can hand off some…

Excel

Conquer your calendar: Use PowerPivot to analyze your time (video)

Today the Microsoft Business Intelligence Team is excited to release a free tool that uses PowerPivot for Excel–Calendar Analytics. This time management application pulls your Microsoft Exchange data and visualizes it in a very easy-to-use Excel dashboard. Watch this special episode of BITV, learn how the Calendar Analytics application works, and then download it for yourself.

OneNote

Is Microsoft OneNote hijacking your print jobs?

While we don’t usually focus on tech support issues here on the Office Blog, let me shine a quick light on a recurring issue that has caused some of you to scratch your heads and write in about. In a nutshell, the problem appears to be that OneNote 2010 (or OneNote 2007) intercepts all of your print jobs whenever you try to send any information from your other programs or your…

Excel

Add the date, time, file name, and page numbers to Excel headers or footers (video)

So it turns out that Excel 2010 users have something in common with Word users after all. While researching the top search terms and phrases on the Office.com web site, I discovered that just like Word users, many people who use Excel 2010 want to add page numbers, the date and time, a file name, and other text to the header or footer of all worksheets in a workbook. So…