This Microsoft Office 2016 Excel Advanced covers working with Microsoft Excel spreadsheet software to create, edit and save worksheets and workbooks. With this course you will gain the skills necessary to use pivot tables, audit and analyze worksheet data, utilize data tools, collaborate with others, and create and manage macros. You will learn how to write advanced excel formulas, auditing and debugging errors in formulas and to combine formulas with conditional formatting to highlight data meaningfully. You will have a good understanding of Excel features like templates, tables and how to establish relationship between tables to create impressive workbooks for reporting.

Learning Outcomes:

• Create pivot tables and charts
• Learn to trace precedents and dependents
• Convert text and validate and consolidate data
• Collaborate with others by protecting worksheets and workbooks
• Create, use, edit, and manage macros
• Import and export data

Method of Assessment:

Upon conclusion of the course, there’s an online multiple-choice quiz assessment, which will determine whether you have passed the course. The test is marked immediately and results are published instantly (60% pass mark).

Certification:

Certificates can be obtained at an additional cost of £9.99 for PDF, £16.99 for Printed Hardcopy format and £24.99 for Both for Both PDF and Hardcopy Certificates.