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

Advanced Excel - Nottingham

Host: East Midlands Chamber
Venue: Nottingham Office
Date: Wednesday 12th September, 2018
Time: 9.30am - 16.30pm
Cost: Member £205 + VAT - Non Member £290 + VAT
This one-day course deals with automation and productivity features. It includes such areas as conditional formatting, validation and consolidation methods, data analysis tools such as pivot tables and data summarising.

Course Programme in Detail



• Custom Views
• Working with Comments
• Conditional Formatting
• Advanced Filtering
• Statistical Functions (COUNT, COUNTA, COUNTBLANK, COUNTIF, MODE, MEDIAN, LARGE and SMALL)
• Validating Data
• Pivot Tables
• Creating and using Macros

Course Outcome



On completion of this course you should be able to analyse and present your data visually, use advanced filtering techniques, validate and consolidate data; analyse your data using data summarising and pivot tables, use 'what-if' tools and automate repetitive tasks.

Who Should Attend



Users who are familiar with and have a good understanding of Excel. Those who use it regularly and write their own basic formulas. 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 Chamber's modern training facilities and is limited to a maximum of eight 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
• Intermediate Excel
• MS Project

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