Contact Us Below

Course Schedule

Visit Our Website

No Contact Training

Email

Phone: 1300 368 784
May 2020
 

Welcome to The Fourth R Newsletter
 

We're pleased to present you with the May issue of The Fourth R Newsletter. This edition starts a new series of tips and tricks with Microsoft Office programs.

Our article this month looks at a previous story on keyboarding online.

The Fourth R provides clients with a wide range of solutions including consulting, instructor-lead and Online courses. Vendors include Microsoft, Adobe, MYOB and more. Please call us or visit our website at www.fourthr.com.au for further information.
 

Keyboarding Online (and Skill Evaluator)
 
 

The Fourth R can now provide its clients with the ability to learn professional keyboarding skills online at a fraction of the price for physical media.

Over six million users have learned to type with this multi-award winning software.

Companies that have encouraged employees to learn to type have seen productivity increase by up to 40%.

The Keyboarding Online programs are self-paced, interactive and effective.

Key features include:

  • Learning the keys (10 lessons) - Teaches all alpha\numeric keys in 10 lessons

  • Punctuation (3 lessons) - Teaches punctuation keys like ? “ and top row symbols

  • Accuracy Challenge (7 lessons) - Designed to improve accuracy

  • Speed Challenge (6 lessons) - Designed to increase speed

  • Advanced (6 lessons) - More lessons designed to further improve accuracy

The user is guided through the course of ten comprehensive and enjoyable lessons in a planned and logical sequence that takes them on the shortest path to learning. Each self-paced lesson builds on the skills learned in the previous lessons and at each step they are encouraged and motivated to continue.

Skill Evaluator (Australian Standard (AS2708-2001)).

In addition to Keyboarding Online, The Fourth R can provide keyboarding accuracy and speed testing through Skill Evaluator Online.

Skill Evaluator is the only program marked to the Australian Standard (AS2708-2001).

Skill Evaluator is a comprehensive package that can include practice exercises, warm up tests and the actual speed and accuracy test.

A certificate is available after completion via print and/or by saving a PDF file to your computer.

Companies can administer logins, warm up tests and the speed and accuracy test.

If you are interested in learning more about Keyboarding Online and Skill Evaluator, please email or call the Fourth R on 1300 368 784
 
 
 

Microsoft Office - Excel
   
 

This month we take a look at five tips and tricks that you can use with Microsoft Excel.

Tip 1 - Date and Time

Type: =now() into any cell will give you the current date and time off your computers clock.

Type: =today() into any cell to get just the date.

Note: Formulas are not case sensitive.

Tip 2 - Creating a Drop Down list

Selecting the list option from the Data Validation's settings dialog box allows you to create a drop down list.

Tip 3 - Hide formula errors (#VALUE! or #DIV/0!)

Use IF and ISERROR functions to cloak an error. A formula such as the following below could be used to leave a cell empty if a formula error appears.

=IF(ISERROR(A1),"",A1)

Tip 4 - Transfer data from horizontal to vertical

Highlight the data you want to transpose and copy it. Select a separate area of the spreadsheet and click on the Paste Special command. Select the Transpose function and click OK.

Note: This function will also work for vertical to horizontal. It is Important to note that formulas will not transpose unless structured in a way that complements this function.

Tip 5 - Manual Wrapping

Pressing ALT + Enter in a line of text allows you to control the wrap point. Automatic wrapping is also available through the Alignment tab of the Format Cells dialog box.
 

 
  No Contact Training (Covid-19)
   
 

As we face constantly changing circumstances related to COVID-19, we’d like to update you on the steps we are taking as a business to ensure the safety and wellbeing of our staff and clients.

The Fourth R is providing none-contact training with an instructor via screen sharing software. This type of training combines the benefits of both customised instructor led and classroom based training with the convenience of a virtual learning environment. Virtual Fourth R allows people to learn in real time so it’s both interactive and participative. The key difference is that participants and trainer are not in the same physical location.

The benefits to you:

• No physical contact

• Live interaction with experienced and qualified instructors

• Dedicated online environment enables interactive exercises so delegates learn by doing

• Participation from the comfort of your own home or office

• Platform independent - delivery on PC and Mac – just need internet access

How does it work?

Typically sessions involve participants logging on to a Fourth R computer where the trainer is able to interact with them directly. The required visuals are viewed by both parties for the session. A physical manual is provide to the client prior to establishing a session. There will also be an audio facility provided by a separate audio bridge such as a telephone conference facility.

If you are interested in learning more, please email or call the  Fourth R on 1300 368 784
   
 

 
 

Un-subscribe
 

Published by The Fourth R Pty Ltd. 
Copyright 2020. All rights reserved.

The Fourth R is committed to protecting your privacy. We do not sell, trade, rent or otherwise disclose any personal information you provide to us.