Advanced Excel – Open Course
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
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.
For further information please visit:https://www.emc-dnl.co.uk/developing-skills/it-cloud-computing2/advanced-excel/
East Midlands Chamber's Offer
Keeping staff development up to date is essential, harnessing skills which are required for businesses growth and progression. We run a full range of open courses, everything from Director level right through to Information Technology sessions. A full list is available on this website and can also be found at our website. We are also a leading provider of Bespoke Training. Working with our team of dedicated trainers, we are able to design and develop face to face or on-line training sessions to support your teams. This could be 1-1 through to sessions for up to 15 people. A dedicated staff member will liaise with you throughout, ensuring all your requirements are met and also completing a quality check with you following the course delivery. The Chamber is a leading partner for many businesses for their bespoke requirements, supporting over 100 businesses each year to train and develop their staff. Flexibility is the key to this and with over 30 years experience of developing bespoke training options, you will know you are in safe hands.View Website