MS Office Tips

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

How to Remove, Crack, or Break a Forgotten Excel XLS Password

by File in: MS Office Tips

Have you forgotten your Excel password for a workbook or sheet? Or has someone left your office and they forgot to unlock an Excel workbook with a password set on it? If you’re stuck with an XLS file with a password that you need to break or crack, you can try out a small little […]

Compare Two Excel Files using SpreadSheet Compare

by File in: MS Office Tips

Office 2013 Professional Plus has a couple of new features including a new program called Spreadsheet Compare. Spreadsheet Compare takes two Excel files and tell you the difference between them in a very nice table layout. You can quickly see the differences in formulas between two spreadsheets and the differences in values also. It’s a […]