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/