Loading Events

« All Events

  • This event has passed.

Excel Intermediate

February 21, 2019 @ 9:00 am - 4:00 pm

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

Details

Date:
February 21, 2019
Time:
9:00 am - 4:00 pm
Event Categories:
,
Website:
https://www.eventbrite.com.au/e/excel-intermediate-registration-52140980075?aff=ebdssbdestsearch

Organiser

TP Human Capital
Phone:
0747723800
Email:
training@tphumancapital.com.au
Website:
www.tphumancapital.com.au

Venue

TP Human Capital
Level 1 - 48 Gregory Street
North Ward, QLD 4810 Australia
+ Google Map
Phone:
07 4772 3800
Website:
www.tphumancapital.com.au