Your Gateway To Business Support Call Freephone 0800 998 1098

Business Networking & Events

Getting Efficient with Excel Spreadsheets Workshop

28th January, 2020   9:30am to 2:30pm

Marches Growth Hub Shropshire. Shropshire Food Enterprise Centre Battlefield Shrewsbury SY1 3TG

Listed under: Shropshire

Do you want to learn the main features of using Excel efficiently for business? This workshop will give you the Level 2 skills and confidence to create a range of formulae and functions and analyse your data using a variety of methods.

Morning session

· Using brackets in a formula

· Fixing a cell reference in a formula

· Combining and linking data across worksheets

· Using a range of statistical functions

· Filtering and sorting data

· Using the IF function

· Using the VLookup function

· Using a Pivot Table and Pivot Chart

· Creating custom charts and formatting

· Preparing worksheets for printing, scaling, using page break preview

Afternoon session

· Practice session covering all skills and techniques at Level 2 spreadsheet standards.

· Complete Level 2 assessment of skills to satisfy Level 2 criteria standards, with City & Guilds certification on successful completion.

Contact Stuart Ford for more information

07814 028851