Office Articles
Automatically Remove Duplicate Rows in Excel
But there are also a few caveats
Excel is a versatile application having grown far beyond its early versions as simply a spreadsheet solution. Employed as a record keeper, address book, forecasting tool, and much more, many […]
Connecting Excel to MySQL
Populate your spreadsheet using a database
Sure Excel is used for spreadsheets, but did you know you can connect Excel to external data sources? In this article we’re going to discuss how to connect an Excel […]
Fix Outlook Spell Checker Not Working
Usually a problem related to Word or Office
I recently upgraded the version of Microsoft Office on my computer and learned that my spell checker was no longer working! Usually, it would automatically show me misspelled words immediately […]
Fix “Word Cannot Start the Converter MSWRD632.WPC/SSPDFCG_x64.CNV” Error
A strange Office 2013 problem solved
Recently, I had a user in my office get the following errors when trying to open a Word document: Word cannot start the converter mswrd632.wpc. or Word cannot start the […]
How to Create Multiple Linked Dropdown Lists in Excel
Update List B with List A
So previously I wrote about how you can create a simple dropdown list in Excel, which is perfect for any kind of data validation. If you have a range of […]
How to Use Excel’s Speak Cells Feature
Handy if you have tired eyes
I am a big fan of text-to-speech technology, mostly because it doesn’t work all that well. However, sometimes it ends up being useful for certain situations. Excel is packed with […]
Get Outlook Email Stats using StatView
Find out who's emailed you the most and more
Just about every corporate email account is using Outlook and Exchange server to handle user email and there is an awful lot of data stored in those PST files. My […]
How to Fix Microsoft Office Error 25090
Aka when you've installed Office twice
Working in a corporate environment as an IT support technician always means you’ll end up dealing with weird problems that would never occur on a normal consumer PC. Why? Well, […]
Cannot Delete Outlook 2007 thru 2016 Reminder
It's like having an unwanted houseguest
Can’t delete a reminder in Outlook 2007, 2010, 2013 or 2016? I recently had this very strange problem where I created a calendar event in Outlook with a reminder attached […]
Remove Passwords on Excel Password Protected Sheets and Workbooks
The nuclear option in case you need it
How many times has this happened to you: you set a password on an Excel spreadsheet or workbook and then you forget about it? Or worse, the person that setup […]