UC EVENTS

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

This workshop will be held via Microsoft Teams as 2 X 4 hour sessions split across 2 days.

Part 1: 15 September (9:30 AM to 1:30 PM)

Part 2: 16 September (9:30 AM to 1:30 PM)

Once registered, you will be invited via the UCPD email with the Teams link.

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 use a work computer and have Excel installed. It is recommended you have a mouse for easier use.

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 all Academic and Professional staff of University of Canberra.