Onsite Computer Training in Sheffield, Derbyshire, Yorkshire & UK
  • Home
  • About
  • Microsoft Training
    • Microsoft Word Training
    • Microsoft Excel Training
    • Microsoft Project Training
    • PowerPoint Training
    • Microsoft Access Training
    • Microsoft Outlook Training
    • Microsoft Publisher Training
    • MS Office Tips & Tricks
    • Office 365 Training
    • SharePoint Training
    • Visual Basic Training
    • MS Office Upgrade Training
    • OneNote Training
    • Email Merge Workshop
  • One to One Training
  • Adobe Training Courses
    • Photoshop Training
    • Illustrator Training
    • InDesign Training
  • Professional Development
    • Handling Difficult Situations and People
    • Change Management
    • Assertiveness and Personal Effectiveness
    • Time Management
    • Effective Telephone Techniques
    • The Effective Team Leader
    • Presentation Skills
    • Managing Poor Performance
    • Customer Service
  • Pricing
  • Contact

Raise Your Game

The raise your game blog will ensure you do just that.

Slick 'SAD'  Shortcut for Word Editors + Video

6/30/2016

0 Comments

 
SAD stands for 'Shift Alt Down' and it's the favourite keyboard shortcut for editing in Word.

Highlight your text and use this shortcut to quickly move text up (Shift Alt Up arrow) or down (Shift Alt Down arrow) in paragraphs, bulleted or numbered lists, even tables. Much quicker than cut and paste.

On the MAC try Ctrl Shift and arrow keys (not quite so easy to remember ;)

Watch this short video...

​
0 Comments

December 31st, 1969

4/29/2016

1 Comment

 
1 Comment

Outlook Top 10 Time Saving Features of 2016

4/15/2016

0 Comments

 

Tip 1 Avoid Duplicating Emails, Use Outlook Templates

Ever find yourself writing the same email over and over? A quotation for a customer, a supplier enquiry, a feedback request? If so, you should be using Outlook templates. When you create a template in Outlook, standard text and even attachments are stored so that they can be easily re-used at a point in the future. Here's how...
  1. Create a new message containing the text you want to store along with a subject line and any file attachments.
  2. From the File menu select Save As
  3. Change the Save as Type drop down to Outlook Template
  4. Give it a file name and click Save
  5. To access the template you will need to add the Choose Form button to the Quick Access Tool bar, to do this, click Home, New Items, More Items and then right click Choose Form, select Add to Quick Access tool bar
  6. The button is now added to the Quick Access Tool bar in the upper left corner of the screen
  7. Whenever you want to use the template, click the button and select User Templates in File System then select the template you require

Tip 2 My Fave 3 Find Features

  1. FLAGS:- Use Flags to quickly find messages. To flag a message use the Insert key on the keyboard to toggle the flag status to red or complete (alternatively click the flag icon to the right of the message).
  2. SEARCH FOLDERS:- When you flag a message you can view all flagged messages easily by making use of the Follow Up Search Folder. If you're not already familiar with search folders you should be! For any search you perform often, just save the search for quick access. To do this, right click on Search Folders in the left navigation menu, select "New Search Folder," and then select what you want, in our case Mail Flagged for Follow Up. Likewise you could create search folders for mail with attachments to quickly filter messages with file attachments or Unread Mail to see all unread messages fast.
  3. ADVANCED FIND:- Already using the search box above your inbox to find messages? When you click in the search box a new tab appears at the end of the ribbon called Search Tools, giving you the ability to perform an Advanced Find. Use an advanced search to specify more criteria to narrow down your search results.



Tip 3 - Create an Outlook Item from your Clipboard


Copy any text to your clipboard, then in Outlook press Ctrl-V. Outlook creates a new message (or note or whatever item, depending on the folder you're viewing) with the text already pasted.

So instead of creating a new item in Outlook, and then copying and pasting text in, you do both in one step.

Look forward to seeing you soon,

Anita Lund
Owner and Founder of Trainers Direct Pty Ltd (Sydney)  
On Site MS Office, Excel, Word, PowerPoint, Outlook and computer training courses and workshops in Sydney
www.trainers-direct.com.au
​& Storm Training & Solutions (UK) www.stormtraining.com

Tip 4 - Turn off Email Conversations (Grouping of Emails)


I don’t like Conversation View and how it groups emails together as it requires additional clicks to get to a specific message within a conversation.  It's particularly common if you're using the web app version of Outlook. 

Also, it makes it difficult to find a message. I couldn't find a message which I received last week and then discovered it under “Yesterday” under a different “From” name of someone who replied later! I'll show you here different ways to de-activate this and how to do the same on your I-Phone too.

In Outlook on the Web, you’ll find a drop down link at the top right of your message list. When you click on this link, you can select various filters and sorting methods.
At the bottom of this list, you’ll find a section where you can choose between “Messages” and “Conversations”. Select “Messages” to turn off Conversation View. The screen shot below shows Outlook 2013 which is similar.

Picture
How to Turn Off Threads in Mail on the iPhone 6
  1. Tap the Settings icon
  2. Choose Mail, Contacts, Calendar
  3. Scroll down and tap the button to the right of Organize by Thread to turn it off. You will know that thread organization has been turned off when there is not any green shading around the button.

Tip 5 - Group and Sort

To quickly sort by a column click on its heading to sort ascending and then again to sort descending. You can also remove a column by dragging it away from the title row and Arrange By to group emails together.

Tip 6 - My Favourite Outlook Shortcut Keys

Picture

​Tip 7 - Outlook Notifications

If you receive a lot of messages or are easily distracted by the notification sound that plays for incoming messages, you may wish to turn off the following options:
In ​File, Options, Mail ​under the Message Arrival section untick 'Display a desktop alert' and any or all of the other options shown below.
Picture

Tip 8 - Advanced Search

A really useful button to add to the quick access toolbar in Outlook is the Advanced Find button. A normal search in Outlook will only search the email subject by default so if you want to search the message body or search against other criteria such as importance, from etc you'll need to add this button.  
  1. Click in the Search box just above the received column, a new Search tab will appear at the end of the ribbon.
  2. Click the Search Tools button
  3. You will see Advanced Find in the list.
  4. Right click Advanced find to add it to the quick access toolbar.
  5. The next time you want to use advanced search criteria, simply click the button which will have been added to the end of the quick access toolbar in the top left hand corner of the screen.

Tip 9 - Add an Email address to Your Contacts List

The next time you receive an email from someone and you want to add them to your contacts...
  • Click the email in your Inbox to highlight it (don't double click to open it).
  • There email address will be displayed in the preview pane to the right or at the bottom.
  • Right click on their email address and choose Add to Outlook Contacts.
0 Comments

Create a Pivot Table using Multiple Data Sources

4/7/2016

0 Comments

 
For those of you who are already familiar with using Pivot Tables, this is a really useful tip. If you want to combine data from more than one sheet, use the short cut key Alt D and then press P (Alt D is the old Data tab command and P is Pivot Table). This launches the old user friendly pivot table wizard where you can choose to add 'Multiple Consolidation Ranges'. You can then select more than one data source for your report.

Check in again soon for a short tutorial to guide you through those steps.

Look forward to seeing you soon,

Anita Lund
Owner and Founder of Trainers Direct Pty Ltd (Sydney)  
On Site MS Office, Excel, Word, PowerPoint, Outlook and computer training courses and workshops in Sydney
www.trainers-direct.com.au
​& Storm Training & Solutions (UK) www.stormtraining.com

​ 
0 Comments

Control Text Wrap in 2 Clicks when you insert Pictures in a Word Doc

4/2/2016

0 Comments

 
Picture
How annoying is it when you've produced a great looking document, spent ages on the layout and formatting and then... bam. You inserted a picture right? The whole thing is messed up, text jumps off the page, you can't move the image and the text won't wrap around. Here are just 2 clicks you need to know about to fix the problem.
  1. When you insert the picture, click on it and a new 'Format' tab will appear at the end of the ribbon.
  2. On the Format tab click Wrap Text and choose Square (this means the text will wrap around all 4 sides of the picture in a square shape. To get the text to wrap closely, select Tight.

Now you will be able to move and resize the picture and the text will move with it.
0 Comments

Save Time! Use a Pivot Table to Analyse Data

3/29/2016

1 Comment

 
"I need that report by..." 5 words that create panic in the work place when you have a list that's a thousand lines long, you need to summarise it and just don't know where to start. 

Chances are if you are doing lots of filtering, sorting and subtotalling on your Excel data lists, you're wasting a lot of time repeating tasks. If  you want to save yourself a stack of time, the tool to use is a Pivot Table.  This feature can be found under the Insert tab on the ribbon.

Select a populated cell in the list you want to analyse and click the Pivot Table icon. This will highlight the entire list including headers, and the Pivot Table analyses the data on a new sheet where you can manipulate that data in a variety of ways (see below).

Here's an example (you can download the file to practise yourself! or play the video tutorial at the end of this post).
amazon_referrals_pivot_data_2013.xlsx
File Size: 122 kb
File Type: xlsx
Download File

Picture
Watch a short video tutorial here...
Look forward to seeing you soon,

Anita Lund
Owner and Founder of Trainers Direct Pty Ltd (Sydney)  
On Site MS Office, Excel, Word, PowerPoint, Outlook and computer training
www.trainers-direct.com.au
​& Storm Training & Solutions (UK) www.stormtraining.com  
1 Comment

10 Easter Excel Tips that will leave you wanting more!

3/27/2016

1 Comment

 
  1. Use F4 to make a cell absolute instead of typing $ when creating a formula (press F4 multiple times to make only part of the reference absolute)
  2. Use Name Ranges in formulas? Press F3 to paste a name into a formula
  3. To wrap text in a cell press Alt Enter e.g First Alt Enter Name would wrap First Name to display on 2 lines
  4. To edit the current cell press F2
  5. To jump to the top or bottom of a sheet press Ctrl Home or End
  6. To select to the end of a list, position the active cell where you want to select from and press Ctrl  Shift  End
  7. To view formulas on a worksheet press Ctrl and the key immediately underneath the Esc key on the keyboard
  8. To insert the current date press Ctrl ;
  9. To create a chart, highlight the data and corresponding column/row labels and press F11
  10. To quickly copy a sheet, hold down Ctrl and drag the sheet and drop it immediately to the right

Look forward to seeing you soon,

Anita Lund
Owner and Founder of Trainers Direct Pty Ltd (Sydney)  
www.trainers-direct.com.au
​
& Storm Training & Solutions (UK) www.stormtraining.com 
1 Comment

10 Easter MS Word Tricks Not to be Missed...

3/26/2016

1 Comment

 
  1. To select a line, an entire paragraph or the whole document make one, two or three clicks anywhere in the left margin next to the paragraph, the mouse pointer should resemble a white pointer
  2. Ctrl + Enter inserts a page break, use to start a new page​
  3. To create a horizontal line type 3 hyphens (dashes) and then press Enter
  4. Ctrl+ makes a word subscript and Ctrl Shift + makes a word superscript
  5. Pressing backspace while holding Ctrl key down deletes the preceding word
  6. Ctrl + F3 will change case to upper, lower, title etc
  7. Select some text and press Ctrl + ] the font size of the selected text will increase. To decrease the font size use Ctrl + [
  8. Easily clear text formatting by selecting the text and pressing Ctrl + Space bar
  9. Use Ctrl + Alt +  1, 2 or  3 to apply the built in heading styles 1, 2 and 3
  10. Press Ctrl G​ to Go To a page number
Look forward to seeing you soon,

Anita Lund
Owner and Founder of Trainers Direct Pty Ltd (Sydney)  
www.trainers-direct.com.au
​
& Storm Training & Solutions (UK) www.stormtraining.com 
1 Comment

2 Minute Tutorial - Learn basic Excel formulas 

3/26/2016

1 Comment

 
Look forward to seeing you soon,

Anita Lund
Owner and Founder of Trainers Direct Pty Ltd (Sydney)  
www.trainers-direct.com.au
​
& Storm Training & Solutions (UK) www.stormtraining.com 
1 Comment

2 Minute Tutorial - How to create an Excel Chart and plot data on a secondary axis

3/26/2016

1 Comment

 
In the first of our 2 minute tutorials we show you how to create a chart in Excel 2013 with 2 data series, and plot the second data series on a secondary axis. This is useful if you have a large variation in values. Yes, all in 2 minutes, it's that easy!
Look forward to seeing you soon,

Anita Lund
Owner and Founder of Trainers Direct Pty Ltd (Sydney)  
www.trainers-direct.com.au
​
& Storm Training & Solutions (UK) www.stormtraining.com 
1 Comment
<<Previous

    About The Author

    Anita Lund is an avid MS Office evangelist, trainer and Company Owner. Passionate about sharing the most useful tricks of the trade using plain English. 

    Archives

    June 2016
    April 2016
    March 2016

    Categories

    All
    2 Minute Tutorials
    Excel
    Outlook
    Word

    RSS Feed

    View my profile on LinkedIn

 

MS Office Courses Sydney







​Email louise@stormtraining.com 
or call Louise on ​07305 444769

  • Home
  • About
  • Microsoft Training
    • Microsoft Word Training
    • Microsoft Excel Training
    • Microsoft Project Training
    • PowerPoint Training
    • Microsoft Access Training
    • Microsoft Outlook Training
    • Microsoft Publisher Training
    • MS Office Tips & Tricks
    • Office 365 Training
    • SharePoint Training
    • Visual Basic Training
    • MS Office Upgrade Training
    • OneNote Training
    • Email Merge Workshop
  • One to One Training
  • Adobe Training Courses
    • Photoshop Training
    • Illustrator Training
    • InDesign Training
  • Professional Development
    • Handling Difficult Situations and People
    • Change Management
    • Assertiveness and Personal Effectiveness
    • Time Management
    • Effective Telephone Techniques
    • The Effective Team Leader
    • Presentation Skills
    • Managing Poor Performance
    • Customer Service
  • Pricing
  • Contact