Office Articles
How To Share An Excel File For Easy Collaboration
Plus how to add back Shared Workbook feature
Collaboration is important in many work spaces. Since most projects require files to be accessed by a lot of users, collaborative setups have become necessary. Microsoft Excel is one is […]
Basic One-Column and Multi-Column Data Sorting in Excel Spreadsheets
A simple but very powerful tool
Two of Excel’s primary functions are to allow you to manipulate and view data from different perspectives, and one of the program’s more simple but powerful tools for doing so […]
How to Automatically Forward Email in Outlook 2019
In case you need access outside of work
When going on vacation, a wise trick is to not have access to your work email. This way, you won’t be stressed out thinking about too many work-related stuff. The […]
How to Use the CONCATENATE Function in Google Sheets
Will help you to merge cells
The CONCATENATE function in Google Sheets joins together multiple chunks of data. This function is helpful when managing large sets of information that each need a similar treatment. For example, […]
How to Recover Deleted Emails in Office 365
Provided you meet certain conditions
It’s easy to accidentally delete emails every now and then. But it is possible to recover some emails that are thought to be gone for good. Deleted emails in Office […]
Change to Landscape Orientation in Google Docs
You never know when this could come in handy
There’s no doubt that portrait orientation is the way to view the vast majority of documents on the web. It’s how we’ve always read books and browsed websites. You’re reading […]
10 Excel Tips and Tricks for 2019
Bookmark this page for easy reference
In this article, I’ll be covering 10 Excel tips that you can use to boost productivity and make your work life easier. Make sure you read through the entire list […]
How to Recover Deleted Files from a PST File in Outlook
Some very important steps to do right away
Removing emails from the Deleted Items folder should always be done with caution. But accidents happen and sometimes we delete emails by mistake. Luckily, there’s a way to recover deleted […]
Miss Hotmail? Microsoft Outlook Email Services Explained
Hopefully this will bring you some closure
Do you remember using Microsoft’s Hotmail email service? Throughout the years, Microsoft has offered a variety of cloud email services that it has rebranded several times. These rebrands become even […]
How to Create a Simple Pivot Table in Excel
Also, we answer what is a pivot table?
If you are in the field of finance or accounting, you already know that most of the job opportunities require intermediate or advanced Excel skills. Some of the most common […]
How to Use If and Nested If Statements in Excel
Calculate commissions and so much more
One Excel function that I use quite a bit in my formulas is the IF function. The IF function is used to test a logical condition and produce two different […]
Use Dynamic Range Names in Excel for Flexible Dropdowns
Easy to edit, great for inexperienced users
Excel spreadsheets often include cell dropdowns to simplify and/or standardize data entry. These dropdowns are created using the data validation feature to specify a list of allowable entries. To set […]
Google Sheets vs Microsoft Excel – What are the Differences?
The gap is closing between them
Previously, we wrote about the differences between Google Docs and Microsoft Word and in this post, we’re going to talk about spreadsheets. Spreadsheets are the pillars for our modern day […]
Why You Should Be Using Named Ranges in Excel
Use it in forms, macros, and source definitions
Named ranges are a useful, but often underutilized, feature of Microsoft Excel. Named ranges can make formulas easier to understand (and debug), simplify the creation of complicated spreadsheets, and simplify […]
Google Docs vs Microsoft Word – What are the Differences?
Some of these are very important
Ever wondered what the differences were between Google Docs and Microsoft Word? Whilst both word processors may look similar on the surface, they are actually different in many ways. In […]
Best New Features in Microsoft Office 2019
Office 365 users can access right away
Microsoft Office 2019 was announced and released on September 24, 2018 and it’s now available for Mac and Windows 10 users to purchase in all regions. Microsoft Office 2019 brings […]
When to Use Index-Match Instead of VLOOKUP in Excel
We'll show you with an example
For those of you who are well-versed in Excel, you are most likely very familiar with the VLOOKUP function. The VLOOKUP function is used to find a value in a […]