Microsoft Excel 2019/365 Advanced
Course Code: XL19L3
Duration: 1 Day
This course is aimed at people who want to expand their knowledge into some of the more advanced functions, analyse/summarise tables of data and automate common tasks.
On completion of this course, delegates will be able to:
• Use logical, lookup, statistical and error functions
• Use auditing tools
• Create range names and use range names in formulas
• Set restrictions on data entry using data validation
• Protect an Excel cell, worksheet and workbook
• Automate common task by recording a basic macro
• Create, edit, format pivot tables and pivot charts
We also offer training on older software versions. Get in touch to find out more.