Contact Us Below

Course Schedule

Visit Our Website

Discount Offer

Email

Phone: 1300 368 784
July 2017
 

Welcome to The Fourth R Newsletter
 

We're pleased to present you with the July issue of The Fourth R Newsletter. This edition looks at a new series of tips and tricks for Microsoft Office 2016.

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

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.
 

Virtual Fourth R Instructor Led Training
 
 

Virtual Fourth R 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:

  • 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

  • Elimination of travel costs, accommodation and business downtime

  • Free "After Support"

  • Additional discounts

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 about Virtual Fourth R please email or call the Fourth R on 1300 368 784
 
 
 

Microsoft Office 2016 - Excel (Part 1)
   
 

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

Tip 1 - New Charts

To enhance visualisations for data analysis, Excel has provided us with six new chart types including Hierarchy, Treemap, Sunburst, Histogram, Pareto and Box and Whisker.

Tip 2 - Get and transform (Query)

Before analysis can begin, you must be able to bring in the data relevant to the business question you are trying to answer. Excel 2016 now comes with built-in functionality that brings ease and speed to getting and transforming your data—allowing you to find and bring all the data you need into one place. These new capabilities, previously only available as a separate add-in called Power Query, can be found natively within Excel. Access them from the Get & Transform group on the Data tab.

Tip 3 - PivotTable enhancements

A number of enhancements including Automatic Relationship Detection (discovers and creates relationships among the tables used for your workbook’s data model, so you don’t have to), PivotChart drill-down buttons, Search in the PivotTable (field list helps you get to the fields that are important to you across your entire data set) and Smart Rename (gives you the ability to rename tables and columns in your workbook’s data model) have been added.

 
  Fourth R Discount Offers
   
  July Discount

Save 15% discount on vouchers purchased and paid by the end of July 2017. Vouchers expire one year from the date of the invoice (standard or solution based training excluded from this offer).

CODE: 4ROFFER0717

Please mention the code above at time of purchase to receive your discount.

 

 

Conditions Apply*

 

 

 
   
 

 
 

Un-subscribe
 

Published by The Fourth R Pty Ltd. 
Copyright 2016. 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.