Excel - Pivot Tables & Pivot Charts  - 3 hr Zoom Workshop

The Health Sciences Library is based at the Royal Melbourne Hospital, located in Parkville, Victoria.The Library offers onsite training in Microsoft Office programs, using accredited Microsoft trainers.Workshops are open to public hospital staff, clinical & research staff of affiliated institutions, & the public.

RMH Health Sciences Library

Introducing Excel Pivot Tables. Organise, summarise, &amp; analyse data. Create pivot charts &amp; pivot tables, calculated fields &amp; the slicer tool

RMH Health Sciences Library - Lab 2

There are multiple tickets types allocated for this event. Sometimes the number of tickets available will change without notice. Contact the Library on 9342 8617 if you have a question regarding ticket types.
We recommend using the Wait List to be notified if tickets are  become available.

3 hour Zoom workshop with an accredited trainer. Participants will be given a case study to complete. Our trainer will show you how to:<ul><ul><li>create, modify, &amp; format pivot tables</li><li>use summary functions &amp; customized calculations</li><li>group numbers &amp; dates</li><li>create filters &amp; slicers</li><li>link &amp; update pivot tables</li><li>expand &amp; collapse data</li><li>sort data</li><li>refresh data</li><li>edit the data source</li><li>create pivot charts</li></ul></ul>Venue: Your own location (participants will require a headset with microphone &amp; two screens, or a combination of devices that will enable use of Zoom &amp; Excel simultaneously)Library Computer Lab (PC monitor / smartboard combination with headset). Select Computer Lab option when enrolling.Prerequisites : Participants must have a good understanding of Excel to intermediate levelFees &amp; Payment OptionsCost Centre Payment (Melbourne Health Staff only)- $200 excl. GST<ul><li>Cost Centre payments: A valid campus code &amp; cost centre must be provided at time of registration. Your nominated cost centre will be charged at the close of registration.</li></ul>Credit Card Payment - $215 (Includes booking fee . Does not include GST ). Hospital staff may be entitled to a reimbursement. Check with your supervisor or Finance department.Cancellations/Refunds Policy:Cost Centre Cancellations: Less than 7 days prior to the workshop date - 100% of the course fee is charged unless we fill your place.Course transfers are not available. Course attendance can be transferred to another individual from the same cost centre provided we are informed ahead of the workshop.Credit Card Cancellations &amp; Refunds: Up to7 days prior to the workshop date - 100% of the workshop fee will be refunded, less Eventbrite booking fees.Less than7 days prior to the workshop date - no refund unless we fill your place with another applicant.Melbourne Health reserves the right to cancel or reschedule workshops without notice. In the event of a workshop cancellation, a full refund (less Eventbrite fees) will apply.Workshop transfers Course transfers are not available.More Information &amp; workshop enquiriesContact us on 9342 8617 or email rmh.libinfo@mh.org.au

Our {communityGuidelinesLink} describe the sort of content we prohibit on Eventbrite. If you suspect an event may be in violation, you can report it to us so we can investigate.

To report other categories of prohibited or illegal content, submit {link}

Ticket sales have ended

Excel - Pivot Tables & Pivot Charts - 3 hr Zoom Workshop

More events from RMH Health Sciences Library

Discover more events from RMH Health Sciences Library, from Business to other experiences you might love.

Still looking for the right event?

Explore all events in Parkville and filter by date, category, and more to find the perfect fit.