Skills needed: This is a basic/intermediate level course for those who are mainly self-taught users of Excel who would like to improve their skills and become more proficient users. The workshop focuses on those features of Excel , especially tables, that can be applied immediately to your data and make the biggest impact on your spreadsheet usage whatever type of data you work with.
Worksheets: navigating, auto-fill, moving & copying worksheets, worksheet tabs, number formatting, protecting worksheets/workbooks.
Excel Tables: advantages, creating, sorting & filtering, adding data, themes & styles, referenced formula.
Introduction to Charts: choosing the correct chart type, creating and editing charts.
Conditional Formatting: allows cells to be automatically formatted (with colour of text/cell etc.) if they meet certain criteria set by the user.
Formula introduction: basic arithmetical functions and order of preference, AutoSum, sum, counta, count, min, max, average.
Interactive Workshop: Numbers are limited as the workshop is interactive, with attendees getting hands-on experience. Raw data to work with as well as summary notes will be provided.
This two hour workshop is offered at the Taranaki Chamber of Commerce's training room from time to time and is also available for individual businesses and can be adapted to suit their needs.