MS Office Tips

How to Open MDI Files

by File in: MS Office Tips

An MDI file, which stands for Microsoft Document Imaging, is a proprietary Microsoft image format used for storing images of scanned documents created by the Microsoft Office Document Imaging (MODI) program. The program was included with Office XP, Office 2003 and Office 2007. It was discontinued in Office 2010 and above. It has basically been […]

Insert a PDF into PowerPoint

by File in: MS Office Tips

Are you working on a PowerPoint presentation and need to insert a PDF document into a slide? Well it seems easy enough right? Just click on the Insert menu, choose Object and pick the PDF file! Unfortunately, I learned that it’s not that simple, especially if you are dealing with a PDF document that has more […]

How to Add Music to PowerPoint Presentations

by File in: MS Office Tips

If you’re creating a PowerPoint presentation, adding a couple of music tracks, voiceovers or sound effects can go a long way in making the presentation more interesting and entertaining. Adding any kind of audio to PowerPoint is a simple process and PowerPoint also has the ability to perform simple tasks on the audio like trimming, […]

Export Contacts from Outlook, Outlook Express and Windows Live Mail

by File in: MS Office Tips

Need to export your contacts out of Outlook? I used to work at an office where there are multiple versions of Office installed on employee computers including Office 2003, Office 2007, Office 2010 and Office 2013! When someone switched computers, I usually end up having to export their email and their contacts to a different computer, which more […]

Link to Specific Slides in Other PowerPoint Presentations

by File in: MS Office Tips

Have you ever needed to link your PowerPoint presentation to another one? What if you could link it to a specific slide in the other presentation? What if you could link it to a Word or Excel document as well (and specify exactly which part of the document you want to open)? Well, it can be […]

How to Add Comments to an Excel Worksheet Cell

by File in: MS Office Tips

I’m a big user of Excel and it always amazes me how few people add comments to their Excel spreadsheets! Adding and using comments in Excel is a great way to explain formulas, cells, and other data in the spreadsheet itself, thus saving you the time spent on the phone with colleagues! It’s really easy […]

Format Cells using Conditional Formatting in Excel

by File in: MS Office Tips

If you are used to using older versions of Excel, the conditional formatting options in Excel 2007, 2010, and 2013 will amaze you. So why would you want to bother using conditional formatting? Well, here are a couple of reasons why I love using this feature of Excel: 1. To make your data more visually appealing. […]

How to Create Microsoft Outlook Shortcuts for Email and Tasks

by File in: MS Office Tips

Here’s a quick guide on how to create your own Outlook shortcuts (not Outlook keyboard shortcuts) on the desktop or Quick Launch bar so that you can easily create a new email message, add new notes, add new contacts, or create new appointments without having to open the Outlook window at all! I find these […]

How to Make a Simple Graph or Chart in Excel

by File in: MS Office Tips

Excel is a powerful tool that you can use to create charts and graphs for small or large amounts of data. In this Excel tutorial, I’ll show you how to take a small set of data and create a simple bar graph, along with the options you have to customize the graph. Once you have […]

Create Dropdown Lists in Excel using Data Validation

by File in: MS Office Tips

If you’re a big Excel user, then you may have found yourself in a situation where you wished you could have simply picked a value for a cell from a dropdown list of choices rather than having to copy and paste text between cells. For example, let’s say you have an Excel sheet for your […]