Microsoft Office Productivity Archives - Page 2 of 38

How to Add a Third Time Zone to Outlook Calendar (Outlook 2016)

June 7, 2018
Helios Visions
Calendar & Task Management, Email Management, Microsoft Office Productivity, Pro Member Tutorials

You can now add a third-time zone to your calendar to help when scheduling meetings with attendees located in another time zone.

This post is only available to members.

How to Record and Use a Simple Macro (Excel 2013/2016)

June 14, 2017
Helios Visions
Excel, Microsoft Office Productivity, Pro Member Tutorials

A Macro is just a recording of keystrokes. It can be used for an unlimited amount of tasks. The best thing to remember when recording is the shorter the better. You will want to record smaller Macros that can be used in…

This post is only available to members.

How to Force Text to Appear on a New Line Within a Cell (Excel)

June 14, 2017
Helios Visions
Excel, Microsoft Office Productivity, Pro Member Tutorials

When typing text into a cell in Excel you may have reason to start a new line. There is a keyboard shortcut to force the text on the next line in Excel. You can also separate existing text but putting the cursor…

This post is only available to members.

How to Use Index/Match Instead of Vlookup (Excel 2016)

June 7, 2017
Helios Visions
Excel, Microsoft Office Productivity, Pro Member Tutorials

Using Vlookup is a great tool, however, if you add columns to your original table of data, you will have to create a new Vlookup formula. If you use Index/Match, you can add or remove columns without having to create…

This post is only available to members.

How to Create Use e-mail Template (Outlook 2016)

December 15, 2016
Helios Visions
Email Management, Microsoft Office Productivity

If you find that there are e-mail messages that you send out frequently that contain similar text, you can create a reusable template in Outlook. You can then edit and send the template as often as you need to.