Free

UC Staff Training | Microsoft Excel Essentials (Intermediate/Advanced)

Event Information

Share this event

Date and Time

Location

Location

Building 8 (Library), Training Room 4

Bruce Campus

Canberra, ACT 2617

Australia

View Map

Event description
Extend your basic knowledge of Excel in high-level formula structure and advanced database manipulation.

About this Event

IMPORTANT INFORMATION: After registering for this workshop, you must enter the details in your Performance and Development Plan. This is required for fixed term and continuing staff only.

PARTICIPANTS MUST BRING THEIR OWN WORK LAPTOP

This course is designed for existing users of Excel who would like to expand their skills and knowledge and learn more of the techniques associated with creating better and more productive workbooks.

Prerequisites

This course is designed for current Microsoft Excel users who can build basic workbooks. It is assumed that the user will know how to create and save a workbook, enter basic formulas and functions (such as SUM, AVERAGE and so forth), and can perform basic database filtering and sorting.

Learning outcomes

At the completion of this course participants will be able to:

  • Create and use labels and names in a workbook
  • Work with logical functions in Excel
  • Work with v lookup and reference functions
  • Use a range of formula techniques
  • Apply a range of number formatting techniques to data
  • Use information and text functions
  • Use standard and nested database summarising and
  • Subtotalling techniques
  • Use Advanced filters to create And/Or conditions within our databases
  • Understand and create simple PivotTable reports
  • Construct and operate PivotTables using some of the more advanced techniques
  • Create and edit a PivotChart
  • Create data validation drop-down boxes

What you need to bring

All participants are required to bring their work laptop and have Excel installed.

Training Facilitator

This workshop will be facilitated by Excel Dimensions. Excel Dimensions have ten years experience specialising in Microsoft Excel training, tailoring each workshop to the industry and skill level.

Training Audience

This workshop is for the staff of University of Canberra.

Share with friends

Date and Time

Location

Building 8 (Library), Training Room 4

Bruce Campus

Canberra, ACT 2617

Australia

View Map

Save This Event

Event Saved