Password protect and un-protect Word, PowerPoint and Access 2016 files

Here’s a question from Kyle: “I know all our documents in Microsoft Office can be pass-protected. Can you explain how to add and remove passwords to my docs and presentations?” Thanks for you question. You can add password protection to your mail, spreadsheets, documents, presentations and databases. In today’s post we will learn together how […]

Continue reading

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?

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 to a Microsoft Access 2016 application?

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?

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?

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