1-855-778-8463

Microsoft Office Productivity

How To Record And Use A Simple Macro (Excel 2013/2016)

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

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…
Read More
How To Force Text To Appear On A New Line Within A Cell (Excel)

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

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 cursor in…
Read More
How To Use Index/Match Instead Of Vlookup (Excel 2016)

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

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…
Read More
How To Add Signature To E-mail When Sending A File (Outlook/Office 2016)

How to Add Signature to e-mail when sending a File (Outlook/Office 2016)

If you send a document (or other file type) via e-mail directly from a program (Word, Excel, etc.) Outlook will automatically open a new e-mail with the document attached. Even if you have Auto-Signature turned on, the new e-mail will…
Read More