Excel

Data’s got a brand new bag: PowerPivot for Excel (video)

There’s lots of data out there: LOTS. The digital universe is about eight hundred thousand petabytes (that’s eight hundred million gigabytes). Your business is no doubt contriubting to that number and needs a way to work with it. PowerPivot is a free add-in for Excel that can link multiple spreadsheets or even link to databases. That means you can work with millions–emphasis on the “s”–of lines of data. Excel also…

Not there? How to say you’re Out of Office in Outlook

Can’t find the Out of Office Assistant to update your contacts for a long July 4th weekend? Well, for Outlook 2010 you find it where you find all the other options and tools: the Backstage view (click the gold File tab in the upper-left corner of the program window) and then click the Automatic Replies button. This new video training goes over the basics of setting up Automatic Replies for…

PowerPoint

Fabulous free templates await: The PPT165 project is complete

Happy to announce that all 165 templates created by PowerPoint MVP Julie Terberg are now available as free downloads at Office.com. You can use these templates as-is, or unlock your inner designer (reproduction steps appear in each template’s Notes pane in PowerPoint). This is a sequel of sorts; we created PPT157 on the first set of Terberg’s templates and, well, you don’t mess with success. See more about the project including…

Better PowerPoint presentations: The Office Casual Way (video)

Here’s a little balm to sooth your nerves about presenting at your next meeting. I’ve collected some advice from presentation masters Seth Godin, Guy Kawasaki, and Garr Reynolds to help you create better PowerPoint Slides and give better presentations. Plus we’ll look at that ace you have up your sleeve: PowerPoint’s underutilized Presenter’s View tool. Read the full post to find help and how-to links discussed in the video. –Doug…

How to install the Outlook Social Connector (video)

The installation of Outlook Social Connector is different from most downloads. Besides downloading Outlook Social Connector (for Outlook 2007 and Outlook 2003; it’s included in Outlook 2010), you must download provider files for each social network you want to connect to. Watch this short video to see how, and see the important links plus an overview of the Outlook Social Connector below. Note: To use Facebook in the Outlook Social…

Outlook gets social: See how you can Facebook while reading your email

Today, the Outlook Social Connector lets you connect with Facebook and Windows Live, and it works for Outlook 2003 and Outlook 2007, along with Outlook 2010. Cool beans. I gotta say that I have been using this and it’s quite pleasurable–plus a time-saver. How do you use it? Let me show you in this quick video (complete with a warning) on the Outlook Social Connector. Learn more about the Connector and…

News

How PowerPoint font embedding and replacement can save your presentation

No doubt about it, fonts can add significant visual appeal to a presentation. As long as they make it onto the screen for your audience to see, that is. If you created your presentation on one computer, but deliver it from another (say, in a conference room), you could be stuck without the very fonts you were counting on, causing some possibly acute pre-show panic. But not to worry. Font…