How to open, view and compare two Excel worksheets side by side?

A pretty helpful function when working with spreadsheets is the ability to compare them side by side.In today’s tutorial  we’ll show you how to view and compare two or more worksheets in the same or different workbooks side by side. View two worksheets in same workbook: Open your excel spreadsheet which consists of two workbooks. […]

Continue reading

Add a voting button to your Outlook 2016 message

Did you know that Outlook emails can also be used as a vote questions like yes or no, approve or reject and some custom options? In this post will show you how to insert voting button to gather your colleagues opinions on different matters through email. We’ll use Office 16, however the process is similar […]

Continue reading

How to create and use an Outlook 2016 rule?

Here’s a question from Ronnie: “Using Outlook at work, Can i automatically forward an email from someone to another mailbox i have configured in Yahoo?” Yes, that’s possible by using the rules option available in Outlook 2016. By setting up and managing rules we can automatically manage Outlook actions. Here are a few useful examples: […]

Continue reading

How to easily capitalize text in Microsoft office 2016?

We usually forget to use uppercase letters when needed. Word ofteb automatically changes the first letter of a sentence into uppercase by default. But what if we want to convert the entire sentence or cell contents to uppercase? In this post we will learn about changing sentence to upper cases in Office 2016 applications. Similar […]

Continue reading

How to combine two or more cells or columns in Excel 2016?

Here’s a question from Nanda: “I need to copy list of names available in spreadsheet to a text document. But when I copy and paste it, all goes wrong. Can you help to have first and last name in the same column?” Sure. Read on for the details. To merge columns using concatenation function: Open […]

Continue reading

How to remove duplicated entries from an Excel 2016 list?

If you use Excel to analyze large data sets, you might have encountered the need to find and remove duplicate rows from your data. In today’s post, we’ll provide a simple tutorial to help you find those duplicates and scrub them from your data. Although Excel 2016 is used to outline the steps below, they […]

Continue reading

How to add picture captions in Office 2016 applications?

Here’s a question from a reader: I thought to include title and information to pictures i am adding to a document. Could you propose simple way to define photo captions in Word? Thanks for your question. Follow this tutorial for the detailed overview. Word: Open Microsoft Word. To add image click Insert tab and then […]

Continue reading

How to customize your bullet points color in Office 2016?

Here’s a question from Diane: I am creating a bulleted list in Word. By default, all bullets are colored black. is there are way to switch the bullets to a different color, say red?   Sure Diane. Please read on this tutorial which is applicable for all Office 2016 applications. Set color bullet point: In […]

Continue reading

Yahoo Mail and GMail configuration settings for setup in Outlook 2016

Here’s a question from Selena: I used to read only Outlook mails in Outlook 2016. But I’ve heard that i can also use Outlook to access my Gmail and Yahoo Mail accounts. Is so, how to configure my Yahoo and Gmail mailboxes in Outlook 2016? Thanks. Read further to learn how to add your Yahoo and […]

Continue reading

How to write from right to left in Office 2016?

Several languages such as Arabic, Persian, Urdu or Hebrew are usually written from right to left. In today’s posts we will learn how to shift the writing direction in Office 2016 from the default Left To Right (LTR) into Right To Left direction (RTL). For convenience, we are providing detailed instructions for Word and Outlook; […]

Continue reading