This one-day course deals with Data Analysis, productivity features and data cleansing features. It includes tools such as Pivot Tables, Data Validation, Dynamic Array Formulas and Power Query
Course Programme in Detail
• Creating Custom Views
• Using the Excel Camera
• Using Power Query
• Using Dynamic Array functions including FILTER, SORT, UNIQUE, XLOOKUP TEXTSPLIT and HSTACK and more
• Validating Data
• Advanced Pivot Table techniques
• Automating Excel tasks
Tips, tricks and shortcuts throughout
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.
This course is for those 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).
book your place
Please complete with delegate details, we can only accept one delegate booking per form. If you wish to book multiple delegates, please email business.training@emc-dnl.co.uk or complete a form for each delegate.
UPCOMING EVENTS