Introduction: This is an intermediate level workshop for those who are reasonably familiar users of Excel and have some basic skills including an understanding of simple formula, and entering and editing data and would now like to unlock more of Excel's power to become more proficient users.
Requirements: Attendees must have their own laptops (not Tablets) with full Microsoft Excel, version 2010 or higher. (To check version, open a spreadsheet, click on File then Account.)
General: worksheet tips; number formatting; paste special; advanced Tables;
Absolute and relative references; COUNTIFS; SUMIFS; AVERAGEIFS; VLOOKUP; HLOOKUP; some text functions; some date 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.