Recent Articles

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

| January 17, 2016 | 0 Comments

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 as your default Microsoft Office application?

| January 13, 2016 | 0 Comments

Here’s a question from Diggle: “I’ve installed a new version of Office 365 in my system, but after the installation all my document opening formats are shown as an unknown program. Can you help me to set it up as the default for the Microsoft Office files?” Yes thank you for the question. In this […]

Continue Reading

How to add a form in Microsoft Access 2016?

| January 13, 2016 | 0 Comments

Here’s a question from Washi: “I am pretty new to Access. Could you explain how can i develop a form to allow me to add some entries to a table” Thanks for the question. Read on for the step-by-step explanation. Creating table and form: Open Access 2016 and click on new database. Now you’ll be […]

Continue Reading

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

| January 8, 2016 | 0 Comments

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?

| December 30, 2015 | 0 Comments

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?

| December 29, 2015 | 0 Comments

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?

| December 29, 2015 | 0 Comments

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?

| December 21, 2015 | 0 Comments

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?

| December 20, 2015 | 0 Comments

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 view and compare two Excel worksheets side by side?

| December 20, 2015 | 0 Comments

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