On the top left corner of your screen is the Quick Access Toolbar, you can add commands to this toolbar to customize it for your use. We will add the “Message Options” command to the QAT, this will make it easier to…
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…
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…
If you use a specific list frequently (i.e. states or sales peoples names), you can save time by creating your own lists to use with auto-fill.
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…
