How-To
How To Share An Excel File For Easy Collaboration
Collaboration is important in many work spaces. Since most projects require files to be accessed by a lot of users,...
Microsoft Office
How-To
Basic One-Column and Multi-Column Data Sorting in Excel Spreadsheets
Two of Excel’s primary functions are to allow you to manipulate and view data from different perspectives, and one of...
How-To
How to Automatically Forward Email in Outlook 2019
When going on vacation, a wise trick is to not have access to your work email. This way, you won’t...
How-To
How to Delete Personal Metadata from Microsoft Office Documents
Everything you do generates data somewhere. That data, when collected and analyzed, becomes information. That information can tell someone more...
How-To
How to Convert an ODT File to Word the Easy Way
OpenOffice is a free open-source software suite that includes Writer, an alternative to Microsoft Word. While Writer works incredibly well,...
How-To
Retrieve Excel Data From a Web Page Directly
Excel is an incredibly powerful piece of software that can do almost any mathematical or logical calculations you could want....
How-To
How to Recover Deleted Emails in Office 365
It’s easy to accidentally delete emails every now and then. But it is possible to recover some emails that are...
How-To
10 Excel Tips and Tricks for 2019
In this article, I’ll be covering 10 Excel tips that you can use to boost productivity and make your work...
How-To
How to Recover Deleted Files from a PST File in Outlook
Removing emails from the Deleted Items folder should always be done with caution. But accidents happen and sometimes we delete...
How-To
Miss Hotmail? Microsoft Outlook Email Services Explained
Do you remember using Microsoft’s Hotmail email service? Throughout the years, Microsoft has offered a variety of cloud email services...
How-To
How to Create a Simple Pivot Table in Excel
If you are in the field of finance or accounting, you already know that most of the job opportunities require...
How-To
How to Use If and Nested If Statements in Excel
One Excel function that I use quite a bit in my formulas is the IF function. The IF function is...
How-To
How to Use COUNTIFS, SUMIFS, AVERAGEIFS in Excel
The three most commonly used formulas in Excel that perform simple mathematical calculations are COUNT, SUM and AVERAGE. Whether you...
How-To
Extract Images From A Word Document The Easy Way
Microsoft Word is one of the most common word processors on the market, but while it’s a great solution for...
How-To
Use Dynamic Range Names in Excel for Flexible Dropdowns
Excel spreadsheets often include cell dropdowns to simplify and/or standardize data entry. These dropdowns are created using the data validation...
How-To
Google Sheets vs Microsoft Excel – What are the Differences?
Previously, we wrote about the differences between Google Docs and Microsoft Word and in this post, we’re going to talk...
How-To
Why You Should Be Using Named Ranges in Excel
Named ranges are a useful, but often underutilized, feature of Microsoft Excel. Named ranges can make formulas easier to understand...
How-To
Google Docs vs Microsoft Word – What are the Differences?
Ever wondered what the differences were between Google Docs and Microsoft Word? Whilst both word processors may look similar on...
How-To
Best New Features in Microsoft Office 2019
Microsoft Office 2019 was announced and released on September 24, 2018 and it’s now available for Mac and Windows 10...
How-To
When to Use Index-Match Instead of VLOOKUP in Excel
For those of you who are well-versed in Excel, you are most likely very familiar with the VLOOKUP function. The...
How-To
12 Useful Microsoft Word Tips and Tricks
Chances are, you either use Microsoft Word now, or may have to use it in the future. It’s easily the...
How-To
How to Separate First and Last Names in Excel
If you use Excel a lot, you have probably run across a situation where you have a name in a...
How-To
How to Delete Blank Rows in Excel
If your Excel document has thousands of rows, manually deleting blank lines can be stressful and virtually impossible. You can...
How-To
How to Take and Insert Screenshots using OneNote
As a professional blogger, I take a lot of screenshots on a daily basis. Most I use and then simply...
How-To
How to Reduce Outlook Memory Usage
One of the major issues most users have with Outlook is the fact that it gets really slow and eats...
