Now you have mastered the topics in the first two modules, you are ready to move on to the first of the intermediate workshops. Discover how to organise, analyse, manipulate, and present tables of data in a meaningful way. You will learn how to: convert data into a table; improve clarity by applying automatic table formatting; locate the information you need quickly using sort, filter and find commands; analyse data using automatic totals and the SUBTOTAL function; setup rules to control the way data looks, based on specific criteria e.g. spend over budget flagged in red; create drop down lists to control data input; remove duplicates.

This module equips you with the tools to: navigate and view multiple sheets/workbooks; use "Group Mode" to create and update multiple sheets at the same time; report on, analyse and link data from multiple sheets; protect your data and sheet layout from unwanted changes. To benefit from this module you will already be confident in using the tools covered in the first two introductory modules.

Improve your ability to manipulate and analyse data by harnessing the power of Excel's popular logical and lookup functions. We'll show you how to test data using different IF statements; combine information from different sheets/workbooks using VLOOKUP; compare data in two sheets/workbooks using the MATCH function; error trap formula using the IFERROR and ISERROR functions; automatically flag exceptions or colour code your data using conditional formatting. Before attending this module, you will already be confident using the functions and formulae introduced in the two introductory modules. 

Develop your existing skills and learn: when and how to use an advanced filter; identify and manage duplicate records; use data tables for “what if” analysis; employ database functions like DSUM, DMAX, DMIN, DAVERAGE, and DCOUNT to analyse large tables of data.

The last module, in our range of bite-size workshops, shows you how to save time by automating repetitive, routine tasks using macros. We explain the concepts and terminology associated with macros and you will discover the benefits of planning, preparation and documentation. Learn how to record, run, and make simple changes to your macros. This skill set is often best acquired, once you have developed a sound, working knowledge of Excel's functionality. You have to know what Excel can do, before you can start recording it!