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.
- 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).
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.
There are no academic entry requirements for this course, and it is open to students of all academic backgrounds.
|Working with Multiple Worksheets and Workbooks|
|Use Links and External References||FREE||00:12:00|
|Use 3-D References||00:06:00|
|Using Lookup Functions and Formula Auditing|
|Use Lookup Functions||00:12:00|
|Watch and Evaluate Formulas||00:08:00|
|Sharing and Protecting Workbooks|
|Collaborate on a Workbook||00:19:00|
|Protect Worksheets and Workbooks||00:08:00|
|Automating Workbook Functionality|
|Apply Data Validation||00:13:00|
|Search for Invalid Data and Formulas with Errors||00:04:00|
|Work with Macros||00:18:00|
|Creating Sparklines and Mapping Data|
|Determine Potential Outcomes Using Data Tables||00:08:00|
|Determine Potential Outcomes Using Scenarios||00:09:00|
|Use the Goal Seek Feature||00:04:00|
|Forecasting Data Trends||00:05:00|
|Mock Exam – Microsoft Office 2016 Excel Advanced||00:20:00|
|Final Exam – Microsoft Office 2016 Excel Advanced||00:20:00|
No Reviews found for this course.