Outlook is a widely used Microsoft Office program, however many people could still use some tips and tricks. Here are a few of my commonly used tactics for using Outlook more efficiently and effectively for email;
1. Flags – Flag important emails to come back and read them later.
How to – Click on the ‘flag’ symbol all the way to the right of the email
2. Sorting – Sort emails by sender or subject to quickly find a lost message.
How to – Click the header that you would like to sort by.
3. Folders – Use folders to organize emails of similar topics. This helps keep important information together.
How to – Right-click over the ‘Inbox’ icon to the left, Click New Folder
4. Drafts – Create and save drafts of commonly sent emails to easily use and resend regularly.
How to – After creating and formatting your email, click the Save button. Now a copy of this message is in the ‘Drafts’ folder. To reuse the content, copy and paste it to a new email.
5. Signature – Create a professional signature to include at the bottom of all emails
How to – From your Inbox, Go to Tools, Click Options, Click the Mail Format Tab, Click the Signatures button at the bottom. Then, click new to create a new signature file.
For more help with using Outlook or general email, please contact Office Solutions ME!
Microsoft Excel is a very powerful program. It can be even more powerful when the formulas are used, and used correctly. In most cases, Excel formulas are not really that difficult… as long as you remember your 8th grade math class.
Here are the basics;
The ‘Formulas’ above are typed directly into the cell that you wish to show your answer, of course replacing the ‘__’ with the information you wish to calculate. In addition, you can replace the ‘__’ with the actual cell reference that you wish to calculate.
Here’s an example of adding two values using cell references;
Column ‘C’ shows the formula that you would enter to get the answer of ‘150’. The benefit of using formulas is that if you change cell A2 to ‘150’, then your formula will automatically update the answer to ‘250’.
A few more Functions that can be helpful include;
- Count – simply counts the number of occurrences in a range of cells
- CountIf – counts the number of occurrences of a specific value in a range of cells
- Max – returns the maximum value in a range of cells
- Min – returns the minimum value in a range of cells
- Average – returns the average value in a range of cells
These (and much more) are all found on the ‘Formulas’ Tab à ‘More Functions’ button à ‘Statistical’ menu
The help feature (located in the top right, below the close button) and the advanced screen tips (appear if you hover over an item in the toolbar) are both very useful when searching for the appropriate formulas for creating and optimizing your spreadsheets.
When you select a cell, the formula will appear in the Address Bar.
To view all of the formulas in a spreadsheet, instead of the results, press Ctrl+` (press it again to revert back to the results view)
For more helpful tips and help with Excel Formulas, please contact Office Solutions ME!