For those who have a basic grounding in Microsoft Excel, this course will provide you with the knowledge and skills to use Excel at an advanced level.
To get the most out of this course, you will need to have completed our entry-level Microsoft Excel course or have the equivalent experience of this extremely popular software.
This training in Microsoft Excel will propel your Excel skills forward to a more advanced level. Over several lessons, you’ll become confident in a range of Excel’s more sophisticated features including using AutoFill, creating and working with tables, using/hiding worksheets, custom formats; defining, using and managing named ranges, using conditional formatting and filtering data, recording and running macros, summarising data, database functions and pivot tables, using data across worksheets, switching between workbooks and workbook templates, worksheets, file and cell properties, and using Excel’s statistical functions.
Like all our Excel courses, you will be given a workbook to use as you progress through the course, which will be yours to take away as a handy reference guide.
You can also be confident that you’ll possess the top skills being sought by employers. What’s more, you will also be in a position to gain FETAC Award B20028 in Spreadsheet Methods, as well as the Microsoft Office Specialist test (MOS).