MS Office Tips

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

Save MS Office Files to Local PC Instead of OneDrive

by File in: MS Office Tips

In the desktop version of Office and in Office 365, if you are logged in using your Microsoft account, it will try to save the file to your OneDrive account by default. This is a new feature that started back in Office 2013 that aims to help you move your documents to the cloud, so […]

How to Use a Lookup Table in Excel 2010

by File in: MS Office Tips

One of the most often cited areas of assistance requests to help-desk personnel regarding Microsoft Excel, is the VLOOKUP command. For some reason, people seem intimidated by it, and then rather than break it down into simple components, panic and reach for help. Things don’t have to go that way though, because if you look […]

How to Create Form Letters in Word

by File in: MS Office Tips

Sometimes you may want to create a letter that you will be sending to a lot of different people, but you’d like certain parts of it to be individualized for each addressee: parts such as the greeting, name, address, etc. In Word parlance, this means you should create a form letter, which is really easy to […]

How to use AutoText and Quick Parts in MS Word

by File in: MS Office Tips

For several of the past iterations of Word, Microsoft has had an AutoText feature that allows users to capture a piece of text and then to use it over and over again in other parts of their documents, or even in other documents. Microsoft has added to that feature by including something it calls, Quick […]

Link Cells Between Sheets and Workbooks In Excel

by File in: MS Office Tips

A common thing to do in Excel is to use one sheet for collecting raw data, such as sales totals, and then to use another tab, or even a workbook to create summations or reports; the thing is though, doing so requires you link the cells first. Fortunately, this is a lot easier than it […]