Wednesday 20th June 2012| Type: | IT Training |
| Venue: | Derby Office |
| Date: | 20th June 2012 |
| Time: | 9:30 am to 4:30 pm |
| Available To: | Members and Non Members |
| Members Price: | £150.00 + VAT |
| Non Members Price: | £195.00 + VAT |
| Discount: | 10 percent discount for 3 delegates or more. |
This course will introduce you to some of the more powerful tools available within Excel and enable you to build complex formulae and gain a greater understanding on how Excel can save you time. You will learn and see new features that will help you to use Excel more efficiently.
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).
ContentConditional Formatting
Advanced Filtering
Statistical Functions (COUNT, COUNTA, COUNTBLANK, COUNTIF, MODE, MEDIAN, LARGE and SMALL)
Date and Time Functions (NOW, HOUR, MINUTE, TODAY, DATE, WEEKDAY, WORKDAY)
Validating data
Formula Auditing
Pivot Tables
Summarising Data
Data Consolidation (Incl. 3D functions)
Custom Views
Working with comments
The TrainerThe 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 the applications throughout the day ensuring maximum hands on experience with numerous opportunities provided to recap on learning points.
Submit your booking today using the form below.
NOTE: Bookings are subject to confirmation. Bookings will be rejected for non-members who book as members.
Take a look at the monthly events calendar for a quick overview of all the upcoming training courses.
Business Training Directory
Training is vital for the future success of your business - without investing in your staff you could be holding back your business potential.
Business Development Programmes
This series of "how to" programmes will help you to get the best from your business.
ILM Courses
DNCC are pleased to offer a range of Institute of Leadership and Management nationally recognised qualifications.
Health & Safety Training
A comprehensive range of Health & Safety courses available to complete online.
Bespoke Training
We can put together custom training packages targeted especially to meet the needs of your business.
Apprenticeships
Apprenticeships are designed to help you gain the specific knowledge, experience and skills to do the job you want.
Workforce Development
Chamber Training has a successful track record of working closely with local employers, providing able workers and training programmes.
Unemployment Support Services
Work-based learning for adults is all about getting unemployed adults trained up, back into permanent employment.
One of the many great offers available to members:
