Feb.

Intermediate Excel - 3 hr Zoom Workshop

by RMH Health Sciences Library

Actions and Detail Panel

Sales Ended

Date and time

Tue., 8 February 2022

1:00 pm – 4:00 pm AEDT

Location

RMH Health Sciences Library

300 Grattan Street

Ground Floor

Parkville, VIC 3050

Australia

View map

Refund policy

Refunds up to 7 days before event

Eventbrite's fee is nonrefundable.

Sales Have Ended

Ticket sales have ended

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 an event is sold out. We recommend using the Wait List to be notified if cost-centre tickets become available.

Build on your Excel skills to perform calculations, create charts & use a range of formula functions.

About this event

3 hour Zoom workshop with an accredited trainer. Participants will be given a case study to complete.

Our trainer will show you how to:

apply cell styles & understand conditional formatting
understand relative & absolute referencing
create a database in Excel & use a range of functions including sorting, filters, subtotals, & removing duplicates
add charts & manipulate chart data
create complex equations applying the BEDMAS rule
use a range of formula functions
use Freeze Panes & Split Screen to view data easily

Venue: Your own location (participants will require a headset with microphone & two screens, or a combination of devices that will enable use of Zoom & Excel simultaneously)

Prerequisites : Participants must have a basic understanding of Excel

Fees & Payment Options

Cost Centre Payment (Melbourne Health Staff only)- $200 excl. GST

Cost Centre payments: A valid campus code & cost centre must be provided at time of registration. Your nominated cost centre will be charged at the close of registration.

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 & 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 & workshop enquiries