• LOGIN
  • No products in the basket.

Login

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.

Requirements

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

Course Curriculum

Working with Multiple Worksheets and Workbooks
Use Links and External References FREE 00:12:00
Use 3-D References 00:06:00
Consolidate Data 00:05:00
Using Lookup Functions and Formula Auditing
Use Lookup Functions 00:12:00
Trace Cells 00:09: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
Create Sparklines 00:07:00
MapData 00:07:00
Forecasting 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
Mock Exam – Microsoft Office 2016 Excel Advanced 00:20:00
Final Exam
Final Exam – Microsoft Office 2016 Excel Advanced 00:20:00

Course Reviews

4.7

4.7
7 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 Units17
  • Number of Quizzes2
  • 3 hours, 14 minutes
449 STUDENTS ENROLLED