Excel is a great tool, but sometimes the spreadsheet files we get to work with aren’t ideal. A classic example is you’re given a file that has one column that you’d really like to split into multiple ones. That was the scenario I faced when I got a large file that had street addresses in one field. Using the LEFT and RIGHT text formulas, I was able to have Excel extract text substrings into two new fields.
These pages include all the site tutorials regardless of category. These mainly cover Microsoft and Google products. In addition, there are some posts that provide information about key terms. Presently, the categories include:
This section is several pages long so be sure to use the blue Next Page >> button at the bottom or the search box to the right.
Some reader favorites include:
Cornell Note taking is a great way to learn and retain subject matter. The system does require a specific way to lay out your notes which is made easier by using a template. In this tutorial, I’ll show how to make one in Microsoft Word.
Everyone looks at information in a slightly different way. Some people create Excel spreadsheets where the data is useful, but it doesn’t work with the way you view or interact with the data. One common example is where you want to transpose or switch Excel row or column data so Row A data becomes Column A data and so on.
Conveniences come at a cost and Microsoft Word documents are no different. Some of the features we use can lead to large file sizes. This can be an issue if you’re low on disk space or you need to send these files as email attachments. Many ISPs and companies have a size limit for email attachments. Here are five quick tips to compress Microsoft Word files.
One of the lesser known, but important files included with Windows is the hosts file. It’s a simple text file without a file extension that was designed to map or override IP addresses before accessing a domain name server. Recently, it’s taken a more protective role in ad blocking and stopping spyware.
If you’ve ever been stumped on how to create watermarks in Microsoft Word, this tutorial will help. It provides steps for text watermarks but the steps are the same for images.
Like many people, I have a love-hate relationship with software. It’s great when it works, but it’s so frustrating when you get a cryptic error message. And these messages seem to appear when you’re short on time and patience
Ever received an Excel spreadsheet with those crazy divide by zero errors – #DIV/0!? It’s an annoyance as it just draws the eye to the wrong cell. Instead, take 5 minutes to apply this fix so you can concentrate on the important parts.
ActiveX sounds like a complex term, but it’s not. It is a way to make programs interactive using a set of controls and rules. You might think of as small apps for Internet Explorer. Microsoft has dropped support for it in Microsoft Edge, which is their latest browser.