The goal of this Microsoft Office 2016 Excel Intermediate is to provide you with the knowledge required to use more advanced formulas and work with various tools to analyse data in spreadsheets, such as sorting, filtering, conditional formatting and auditing. You will organise table data and present data as charts. You will discover how Excel spreadsheets are constructed and be given a clear path on how to create templates. You’ll also discover how to use Goal Seek and Solver and apply them to real-world problems. The course provides you the guidance of how to create a proper database, organizing your data such that it can be used to work with multiple worksheets.
- Calculate with advanced formulas
- Audit formulas using the auditing tools
- Work with Excel tables
- Organise worksheet data so that data can be sorted and filtered
- Create and modify Charts
- Create Excel templates
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 Functions|
|Work with Ranges||FREE||00:18:00|
|Use Specialized Functions||00:11:00|
|Work with Logical Functions||00:23:00|
|Work with Date & Time Functions||00:08:00|
|Work with Text Functions||00:11:00|
|Working with Lists|
|Query Data with Database Functions||00:09:00|
|Outline and Subtotal Data||00:09:00|
|Create and Modify Tables||00:15:00|
|Apply Intermediate Conditional Formatting||00:07:00|
|Apply Advanced Conditional Formatting||00:05:00|
|Visualizing Data with Charts|
|Modify and Format Charts||00:12:00|
|Use Advanced Chart Features||00:12:00|
|Using PivotTables and PivotCharts|
|Create a PivotTable||00:13:00|
|Analyze PivotTable Data||00:12:00|
|Present Data with PivotCharts||00:07:00|
|Filter Data by Using Timelines and Slicers||00:11:00|
|Mock Exam – Microsoft Office 2016 Excel Intermediate||00:20:00|
|Final Exam – Microsoft Office 2016 Excel Intermediate||00:20:00|
No Reviews found for this course.