How to easily create checklists in Excel sheets and Word documents?

Sometimes you would like to create forms using in Office in order to easily capture user feedback. In today’s tutorial, we’ll teach you pretty much everything you need to know in order to create and format check box lists either as part of your Excel spreadsheets or Word documents. Once done you might want to […]

Continue reading

How to easily add Excel sheets and Word documents into PowerPoint 2016 slides?

One of the coolest features of Microsoft Office is the ability to embed an Office application into another. Few weeks ago, we showed you how to easily insert an excel worksheet into Word. In today’s tutorial we’ll learn how to easily we can add Excel and Word docs into a PowerPoint slide (pptx/ ppt file) . […]

Continue reading

How to manually create a Microsoft Outlook 2016 profile?

Here’s a question from John: “Can i manually setup Outlook.com in Outlook 2016?” Yes. By using the steps outlined below you would be able to manually define your outlook account in outlook or exchange active sync. Manually creating an Outlook 2016 profile: Open your control panel, search for mail and click it. Then in the dialog […]

Continue reading

How to open an Excel 97/2003 .xls file in Excel 2016?

Here’s a question from Skyler: “My xls files were created in the previous version of Excel. But now when I open the document in Excel 2016 it say its corrupted. Is there anyway to retrieve it?” Thanks for your question and Yes there is a way to retrieve the document. We will discuss about it […]

Continue reading

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