googlefd16b42746daa692.html

Upcoming RMH Library sessions: endnote, excel

Thursday 13 July

EndNote

9:00am – 2:00pm, Library Computer Lab, Ground Floor, RMH

An introduction to basic email functionality, calendar features, address book, personal folders, email signatures and more. Fees apply. Enquiries to Elizabeth Deans 9342 8613 or email elizabeth.deans@mh.org.au

Wednesday 19 July

Intermediate Excel

1:00pm – 4:00pm, Library Computer Lab, Ground Floor, RMH

Cover cells styles, conditional formatting, creating a database, grouping, formulas, complex equations applying the BEDMAS rule, charts, relative and absolute referencing and more. Participants must have attended an Introduction to Excel workshop or have equivalent skills. Fees apply. Enquiries to Elizabeth Deans 9342 8613 or email elizabeth.deans@mh.org.au

Tuesday 25 July

Excel Dashboards

9:00am – 4:00pm, Library Computer Lab, Ground Floor, RMH

An introduction to the principles of data analysis and good dashboard design to synthesise and summarise information into a logical framework, and to present data graphically, using existing Excel tools to analyse data & build reports. Participants must be competent spreadsheet users. The workshop is designed for users who use Excel on a regular basis, and are comfortable with using its tools and functions. Fees apply. Enquiries to Elizabeth Deans 9342 8613 or email elizabeth.deans@mh.org.au 

Wednesday 26 July

Using Power Pivot and Power Pivot Table

9:00am – 12:00 noon, Library Computer Lab, RMH

Developed for people wanting to use the more complex functionality of Pivot Tables within Excel, including the PowerPivot add-in which allows you to analyse multiple files. Participants will need to be familiar with all topics covered in Intermediate and Advanced Excel. Fees apply. Enquiries to Elizabeth Deans 9342 8613 or email elizabeth.deans@mh.org.au

Wednesday 26 July

Excel Formulas

1:00pm – 4:30pm, Library Computer Lab, Ground Floor, RMH

Cover the BEDMAS rule, the difference between AVERAGE & AVERAGEA, the difference between COUNT & COUNTA & using COUNTBLANK, date/time formulas, rounding formulas and more. Participants will need to be familiar with all topics covered in Intermediate Excel. Fees apply. Enquiries to Elizabeth Deans 9342 8613 or email elizabeth.deans@mh.org.au  

googlefd16b42746daa692.html