Course Overview

This one-day workshop will help intermediate Microsoft Excel users to advance their skills. You’ll learn how to use some of Excel’s more powerful features so that you can complete your work more effectively and quickly. 

Course Content

•          Workbook and worksheet protection

•          Cell referencing

•          Using functions - including SUMIF, COUNTIF, COUNTIFS and TODAY

•          Introduction to charts

•          Data tools

•          Excel tables

•          Cell linking within worksheets and workbooks

•          Sorting and filtering

•          Auditing and error checking

•          Using outlines

Benefits for the individual

•          Ability and confidence to use more of Excel’s tools and functions to improve your performance in the workplace

 •         A broad range of hints and tips to save time

Benefits for the organisation

•          More confident and proficient Microsoft Excel practitioners, operating at an intermediate level

 •         An efficient workforce, capable of producing and presenting high-quality spreadsheets which will assist business analysis and planning