Latest News

14 Aug

Impact of lost businesses felt in latest employment figures

The impact of a number of high-profile business closures earlier in the year has begun to filter through to the unemployment figures for the East Midlands.

14 Aug

Rural Community Awards Now Open

The Plunkett Foundation is welcoming applications for this year’s annual awards celebrating achievements of rural community businesses in tackling rural issues.

08 Aug

Seasalt launches new IT support partnership with Retail Assist

Cornish womenswear retailer, Seasalt has partnered with Retail Assist for IT Support

Intermediate Excel - Derby

Host: East Midlands Chamber
Venue: Derby Office
Date: Thursday 20th September, 2018
Time: 9.30am - 16.30pm
Cost: Member £205 + VAT - Non Member £290 + VAT

Intermediate Excel

This one day course extends the learner's basic knowledge of Excel and provides the learner with skills and knowledge to produce more effective and productive workbooks. It covers formulas and function techniques, more intricate formatting, setting complex printing options, using intricate charting features, and working more effectively with existing worksheets and workbooks.

Course programme in detail

• Filling data
• Formula referencing (understanding $ in formulas)
• Cell alignment
• Finding and replacing
• Page setup
• Headers and Footers
• Sorting data
• Charting techniques
• Logical and lookup functions (including Vlookup)
• Filtering data

Course outcome

On completion of this course you should be able to use the fill operations available; understand and use absolute and relative formula referencing; sort data in a worksheet; use a range of logical and lookup functions; work with a variety of elements in a worksheet; work with more than one workbook at a time and filter large amounts of data in a table.

Who should attend

The course is designed for existing users of Excel who would like to expand their skills and knowledge and learn more of the techniques associated with creating better and more productive workbooks. This is a "packed" course and due to the level of content, not all topics may be covered (to be agreed during training).

Course delivery

This course is delivered from the Chambers modern training facilities and is limited to a maximum of 8 delegates. Lunch and refreshments are provided as part of this course. Please note, there is no requirement for delegates to bring any stationery or IT equipment unless otherwise stated in the joining instructions.

About the trainer

The tutor for the course is Martin Perry who has many years experience as an IT Trainer. Martin's courses are geared to ensuring all delegates walk away with new skills regardless of their ability when they arrived. All courses are delivered in such a way that delegates continually use Excel throughout the day ensuring maximum hands on experience.

Other courses you may benefit from

• Foundation Excel
• Advanced Excel
• A variety of Microsoft packages are available on a bespoke basis, including MS Word, PowerPoint etc. Please contact us for more information.
Book Now