This course is designed to build on acquaintance gained in the introductory course. In Advanced Microsoft Office Excel, you learn how to analyse and handle your data and explore the many data analysis tools accessible in Excel, such as formula auditing, goal seeks, Scenario Manager and subtotals. Additionally, in this course, you will use advanced functions, discover how to apply conditional formatting, filter and maintain your data lists, create and manage PivotTables and PivotCharts and record essential macros. Once you finish the course, your familiarity and confidence in using the advanced features of Excel will expand, making Excel a more useful tool in your personal and professional life.
All the courses advertised on this website are studied online. There is no need for you to attend a venue to gain one of our qualifications.
The course is designed to display correctly on all devices including PC’s, Tablets and Mobile phones. As long as you have an internet connection you can log on and study.
Yes. Each course has an end, of course, multiple-choice test that will test your knowledge of the course modules you have just studied.
The pass mark for the end of course tests is 60%