How to automatically highlight alternate rows or columns in Excel 2016?

A reader was asking about whether we know of a method or formula to highlight every other row and column in Excel. Today, we’ll learn how to apply different color schemes to alternate rows or columns in Excel. There are several ways to alternate row colors, but today, we will focus on two main ways […]

Continue reading

How to merge and remove duplicated contact people in Outlook 365?

Here’s a question we got the other day: “I have many duplicated entries in my Outlook 2016 people list, can you provide me a solution to consolidate the list and get rid of any dups?” Good question, there is a little trick to find those redundant contacts and remove or merge it. In this post, […]

Continue reading

How to make Office 2016 your default Microsoft Office application?

Last updated: April 2018 Applicable to: Office 2019,2016,2013, 365; Windows 7, Windows 10 and partly to MAC OSX Here’s a question we received from one of our readers: “I’ve installed a new version of Office 365 in my system, but after the installation all my Office documents are showing up as unknown file types. Can […]

Continue reading

Automatically format cells, dates, columns and rows in Excel 2016?

Here’s a question from Krithi: “I know that Excel has some cool capabilities for setting automatic formats (such as colors/fonts sizes / height / styles) of individual columns, rows, cells specially when it relates to dates and times. Can you provide more information about auto-formatting in Excel spreadsheets” Great question. In this post we will […]

Continue reading

How to add a new business or personal calendar into Outlook 365?

Sometimes you might be in need to create additional calendars in order to more easily manage your personal schedule separately from work or manage your project schedule. In today’s post, we’ll show you how you can create a birthday calendar in Outlook 2016 that will send you reminders about your friends and colleagues birthdays so […]

Continue reading

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

Applicable to: Excel 2019, 2016, 2013, 365. Microsoft and Apple Office versions. Latest update: May 2018 Chances are that from time to time you might want create forms using in Office in order to easily capture user feedback or document a standard operating process. In today’s tutorial, we’ll teach you pretty much everything you need […]

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, 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