MS Office Tips

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

Microsoft Excel Basics Tutorial – Learning How to Use Excel

by File in: MS Office Tips

If you have Microsoft Office installed, but have never touched Excel before because you either didn’t know how to use it or didn’t know what it could do for you, then you MUST read this post on learning how to use Excel! Microsoft Excel is a powerful spreadsheet application that can be used for anything […]

Ultimate Troubleshooting Guide for Office 2013 Installation Problems

by File in: MS Office Tips

I’ve been installing Office 2013 on a lot of computers lately and I’ve ran into quite a few problems along the way. From annoying messages like “Sorry we ran into a problem” and “Something went wrong” to slow downloads, hanging at certain percentages during the install, it’s been typical Microsoft problems all along the way. […]

How to Securely Password Protect an Excel File

by File in: MS Office Tips

Password protecting your Excel worksheet can prevent others from tampering with your data, but it’s best you never store really sensitive information in an Excel spreadsheet. Why? For the simple reason that Excel passwords can easily be cracked. This is because Excel uses a very weak form of encryption that can easily be broken use […]