This very popular workshop is at a basic/intermediate level 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.
Skills introduced:
Worksheets: screen and row and column navigating, moving & copying worksheets, worksheet tabs, number formatting, navigating around a worksheet and selecting data.
Excel Tables: the foundation for successful data manipulation: advantages, creating, sorting & filtering, adding up-date data, themes & styles, referenced formula.
Introduction to creating professional looking 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, Today and Now functions.
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.