Microsoft Excel: Intermediate/Advanced Workshop

Skills needed: This is an intermediate /advanced level workshop for reasonably confident users of Excel with basic skills including an understanding of formula like sum & average, and entering and editing data.


Requirements: Attendees must bring their own laptops (not Tablets) with full Microsoft Excel, version 2010 or higher. (To check version, open a spreadsheet, click on File then Account.)


Skills introduced:

  • General workbook/worksheets general tips

  • Number formatting including Custom formatting of dates and numbers

  • Advanced Excel Tables features including structured referenced formula

  • Introduction to Charts (graphs)

  • Formula & Functions including:

    • Absolute & Relative references

    • Logical functions: IF, AND, OR, IFS, SUMIFS, COUNTIFS, AVERAGEIFS

    • Lookup functions: VLOOKUP, HLOOKUP




Numbers will be limited because the workshop is interactive, with attendees getting hands-on experience. Raw data to work with and detailed 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.