ISG Blog

How to add drop-down lists in Excel 

You use Data Validation to manage what is permitted in a cell eg: only dates after today or select from a list (Drop-down).

FAQ for this is here.

If you have any Tips you would like to share – send them to us via return email for publication.

Changing who recipients see as the email sender 

If you have access to Shared mailboxes or someone else has delegated access to you then depending how and where you start an email from, you may need to check and/or change who the email is from.

FAQ for this is here.

If you have any Tips you would like to share – send them to us via return email for publication.

Create an Outlook Contact from a received email 

At times you may be emailing someone and then need a permanent record of their contact details or they have given you their private contact / address details. Simply find an email from them then Right click on their email address and then click Add to Outlook Contacts.

FAQ for this is here.

If you have any Tips you would like to share – send them to us via return email for publication.

How to recall an email 

Ever had that sinking feeling when you realise your email went to the wrong person or it contained the wrong content?

FAQ for this is here.

If you have any Tips you would like to share – send them to us via return email for publication.

Get Excel to fill in numbers or dates based on a pattern 

Typing sequential numbers or dates into cells can be time consuming. Try pattern filling instead.

FAQ for this is here.

If you have any Tips you would like to share – send them to us via return email for publication.

Do you use pictures in your documents and want to control how the text wraps? 

Text wrapping can be by trial and error or it becomes too difficult and you give up. Have a look at this video which explains each of the wrapping options.

FAQ for this is here.

If you have any Tips you would like to share – send them to us via return email for publication.

Working in a Team and wanting to assign and track tasks? 

You can use Tasks in Outlook but, if you use Teams for collaboration, you can add a Planner or multiple planners to the team

Have a look at these instructions and videos on using Planner for Teams.

FAQ for this is here.

If you have any Tips you would like to share – send them to us via return email for publication.

Attachments in Email – Sharing vs Attaching a copy 

When attaching a document from OneDrive using the Attach File button, you may be asked to Share or Attach the file but what is the difference to you and your recipients?

FAQ for this is here.

If you have any Tips you would like to share – send them to us via return email for publication.

Reminders set at 15 minutes before the meeting not needed or you want to change the default 15mins? 

You can turn the default reminders off entirely and change the 15 min default to any number of minutes or days.

Go to File->Options->Calendar then look in the Calendar Options section.

Faq for this is here.

If you have any Tips you would like to share – send them to us via return email for publication.

Save your Word, Excel or Powerpoint as a PDF document 

PDF files make it easy to send or share documents in a format most Computer and SmartPhone users can open.

If you need to create PDF’s with more features, security or as forms then you should look at obtaining a copy of Acrobat.

FAQ for this is here.

If you have any Tips you would like to share – send them to us via return email for publication.

Edit a PDF document using Microsoft Word 

You no longer need a specific application to edit a PDF. Convert it to Microsoft Word, make your changes and save it as a PDF.

FAQ for this is here.

If you have any Tips you would like to share – send them to us via return email for publication.

Can’t figure out how to MailMerge and Cc or BCc some people? 

The Microsoft Word Merge is unable to do this however, Salvation Army recommends a cost effective 3^rd party application called EmailMerge CC.

Contact the Service desk if you would like additional information and pricing (approx. $69 per person)

If you have any Tips you would like to share – send them to us via return email for publication.

Tame your inbox with Clean-up or Sweep 

Our inboxes can quickly fill up with emails no longer needed or multiple emails in a conversation when you only needed the latest reply.

FAQ for this and other cleanup options is here.

If you have any Tips you would like to share – send them to us via return email for publication.

Confirm delivery and / or that the recipient has read your email

Delivery and Read receipts send you an email when a recipient has received or read your email.

FAQ for this is here.

If you have any Tips you would like to share – send them to us via return email for publication.

Quickly move between active applications instead of minimising or closing windows till you see what you want next 

Press and hold the Alt key and at the same time, tap the TAB key.

A little menu opens and each time you tap TAB, the next application is highlighted.

When you have the one you want, release the Alt key.

FAQ for this is here.

If you have any Tips you would like to share – send them to us via return email for publication.

Get rid of those incorrect email addresses that keep appearing when creating email. 

When typing in the To, CC or BCC fields, Outlook tries to help and suggests addresses you have used before. This is great except where you may have mis-typed an address.

To remove an address, hover your mouse over it then click the X on the right.

FAQ for this is here.

If you have any Tips you would like to share – send them to us via return email for publication.

Check out the office Status Bars 

Each office application has a status bar at the bottom of the window and each item on the status bar is clickable giving you additional information or features.

FAQ for this is here.

If you have any Tips you would like to share – send them to us via return email for publication.

Page and Section breaks give you greater control over your document.

How do you force text to appear on a new page? If you answered by hitting the Enter key as many times as needed, then you need Page breaks.

FAQ for this is here.

If you have any Tips you would like to share – send them to us via return email for publication.

Have you ever wanted a really quick Total, Average or Count of some values in Excel? 

If you only need a quick total, average or count of how many items you have, simply click and select the cells you want then look at the status bar at the bottom of the Excel window.

FAQ for this is here.

If you have any Tips you would like to share – send them to us via return email for publication.

How to get Rooms, Cars, Trucks or other resources into Outlook so we can book them out and trace them. 

Raise a ticket in the supportal for ISG to setup the resource for you. We will need information such as Title, max capacity of the room, car rego number/colour.

If you have any Tips you would like to share – send them to us via return email for publication.