• LOGIN
  • No products in the basket.

Login

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.

Learning Outcomes:

  • 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).

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.

Requirements

There are no academic entry requirements for this course, and it is open to students of all academic backgrounds.

Course Curriculum

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
Sort Data 00:10:00
Filter Data 00:10:00
Query Data with Database Functions 00:09:00
Outline and Subtotal Data 00:09:00
Analyzing Data
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
Create Charts 00:13:00
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
Mock Exam – Microsoft Office 2016 Excel Intermediate 00:20:00
Final Exam
Final Exam – Microsoft Office 2016 Excel Intermediate 00:20:00

Course Reviews

4.9

4.9
10 ratings
  • 5 stars0
  • 4 stars0
  • 3 stars0
  • 2 stars0
  • 1 stars0

No Reviews found for this course.

TAKE THIS COURSE OR ALL COURSES FOR £69.99
  • £24.99
  • 1 year
  • Course Certificate
  • Number of Units19
  • Number of Quizzes2
  • 4 hours, 16 minutes
452 STUDENTS ENROLLED