Excel Intermediate

TP Human Capital, Level 1, 1 January

01 Jan
Home / Upcoming Events / Excel Intermediate

Event Cost: $351.07

Description

Microsoft Excel is the bestselling and most widely used spreadsheeting program in the world. Microsoft Excel is standard in most businesses, and is almost essential to operate efficiently in today’s office environment. TP human capital’s Microsoft Excel training will give you the skills to confidently and efficiently produce professional spreadsheets and databases.

This course builds on the base developed in Introduction to Excel, giving you increased skills to produce more complex documents. This level of training is the minimum level required for anyone who is serious about developing their office skills.

Course Topics:

  • Revision Exercises
  • Viewing and printing a large worksheet effectively
  • Working with worksheets
  • Freeze document panes and split worksheets
  • Rename, insert, delete, copy, group worksheets within the workbook
  • Outlining
  • Create and protect templates
  • Protect Workbooks
  • Charting
  • Commonly used functions
  • Construct formulas using relative and absolute references
  • Sum, Max, Min, Average, PMT, PV and IF functions
  • Auditing your worksheets
  • Validating your data
  • Data lists
  • Auto filtering

Prerequisites: Introduction to Excel or equivalent

Important Note:

Click here to download skills assessment just to make sure you are registering at right level.

Email to training@tphumancapital.com.au for review, prior to registering for event.

Or click here for more information about this workshop.

Click here to access Terms and Conditions prior to registering

Holding a STEM related event in Queensland?

Subscribe to the Inspiring Australia Queensland e-newsletter

Keep up to date with news, events and funding opportunities for STEM in Queensland
  • This field is for validation purposes and should be left unchanged.