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

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.

For further information please visit:https://www.emc-dnl.co.uk/developing-skills/it-cloud-computing2/advanced-excel/

Contact Hours

Level

Cohort Minimum

Cohort Maximum

Number of Training Sessions

Price per Learner

(Minimum Cohort)

£290.00

East Midlands Chamber's Offer

Keeping your staff development up to date during this time is essential, meaning that once we get back to ‘normal’, skills will have been harnessed and we will be ready to hit the ground running! We are now offering a range of online bite-size courses specifically to support your business during this period of social distancing.We continue to promote and take bookings on our face to face training courses.  Be ‘course confident’, if courses are postponed we will transfer your place onto the next available date, and new dates are being added to support the additional numbers that will be required once we are able to meet face to face again.  We also have our own large training rooms, where social distancing measures will be in place to support and protect our customers – so you will be in safe hands.  And don’t forget we offer bespoke training, designed to support your businesses specific needs – this is online or face to face.General: Vicki Thompson 07469148833 International: Julie Whiting 07879519404E: business.training@emc-dnl.co.uk  

Reviews

There are no reviews yet.

Be the first to review “Advanced Excel – Open Course”

Your email address will not be published. Required fields are marked *