MS Office Tips

How to Make Flowcharts in PowerPoint

by File in: MS Office Tips

PowerPoint is a powerful application that can be used for just about any type of presentation. One great example of using PowerPoint is to present processes and decisions using flow charts and diagrams. Just about every version of Office has the ability to add standard flow chart shapes like Process, Decision, Data, etc., but Office […]

Use Summary Functions to Summarize Data in Excel

by File in: MS Office Tips

For those who use Excel regularly, the number of built-in formulas and functions to summarize and manipulate data is staggering. Excel is literally used by everyone: from students in a financial class to hedge fund managers on Wall Street. It’s extremely powerful, but at the same time very simple. For those just getting started with […]

How to Hide Sheets, Cells, Columns, and Formulas in Excel

by File in: MS Office Tips

If you use Excel on a daily basis, then you’ve probably run into situations where you needed to hide something in your Excel worksheet. Maybe you have some extra data worksheets that are referenced, but don’t need to be viewed. Or maybe you have a few rows of data at the bottom of the worksheet […]

How to Set Away Message in Outlook

by File in: MS Office Tips

Going out of the office soon and need to setup an Out of Office, Away or Vacation message in Outlook? You would think it would be super easy, but unfortunately it’s not! There are actually two ways of creating an automatic reply and it depends on whether Outlook is stand-alone or using Microsoft Exchange. If your are in […]

Ultimate Guide to Repairing a Damaged or Corrupt Word File

by File in: MS Office Tips

Need to repair or fix a corrupt Word document? Sometimes when opening a Word document, you will give you an error stating that the document cannot be read because it is corrupt or because there is some other problem with the file. Word documents can become corrupt in a number of different ways, but usually it’s […]

How to Track Changes in Excel

by File in: MS Office Tips

Are you looking for a way to track changes made to an Excel spreadsheet? There are many cases where you have to distribute a file to multiple people and keep track of what changes were made. You might want to track when the change was made, who made the change, what cell the change occurred in and […]

Hide Text and Show Hidden Text in Word

by File in: MS Office Tips

Microsoft Word has a feature whereby you can hide text so that it does not visibly appear in the document. If you don’t want to delete text completely, hiding the text is a good option. So why would you ever want to hide text in a Word document? Well, one reason would be if you wanted […]

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, […]