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…

Access

Power Tip: Password protect your VBA project

A question came in recently regarding whether you can password protect just the VBA code for an Access database, but not the rest of the database. The answer is yes! Here’s how to do it: In Access, press ALT+F11 to open the VBA editor. On the Tools menu, select <Database Name> Properties… On the Protection tab, select the Lock project for viewing check box. Enter and confirm a password. Click…

News

Ready for widescreen? How to manage aspect ratios in PowerPoint (16:9 vs. 4:3)

Widescreen, with its 16:9 aspect ratio, is taking over video screens faster than Godzilla in a scale model city. And that’s a good thing, with PowerPoint. As the name implies, widescreen brings wider, more beautiful images onto your TV and computer screens. So why does your PowerPoint presentation suddenly look terrible? Possibly because you copied slides that contain graphics between one presentation created in 16:9 and another created in 4:3.…

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…

OneNote

5 things you wanted to know about OneNote 2010

You’ve read so much about OneNote 2010 getting the Office ribbon interface, but you can’t find (or control) it. What’s up? There seems to be no way to browse, apply, or download OneNote templates now, even though you could before. How come? You’re not sure if your old notebooks need to be converted to a different file format before you can use them in OneNote 2010. Do they? What’s happening…