Microsoft Excel 2016 Advanced

Janets

Course

Online

£ 315 VAT inc.

The best Excel courses

See all

See all

Description

  • Type

    Course

  • Level

    Advanced

  • Methodology

    Online

  • Duration

    1 Year

  • Start date

    Different dates available

  • Online campus

    Yes

  • Delivery of study materials

    Yes

  • Support service

    Yes

  • Virtual classes

    Yes

Microsoft Excel 2016 Advanced is one of our best selling and most popular course.

This course is suitable for anyone aspiring to or already working in Microsoft Excel and looks at skills needed to improve Microsoft Excel. By taking this course you will gain the necessary skills to perform effectively in this field.

The Microsoft Excel 2016 Advanced is organised into 6 modules and includes everything you need to become successful in this profession.

To make this course more accessible for you, we have designed it for both part-time and full-time students. You can study at your own pace or become an expert in just 8hours!

If you require support, our experienced tutors are always available to help you throughout the comprehensive syllabus of this course and answer all your queries through email.

Facilities

Location

Start date

Online

Start date

Different dates availableEnrolment now open

About this course

Upon successful completion of the course you will be able to obtain your course completion e-certificate free of cost. Print copy by post is also available at an additional cost of 9.99 and PDF Certificate at 4.99.

Why choose this course
Earn a free e-certificate upon successful completion.
Accessible, informative modules taught by expert instructors
Study in your own time, at your own pace, through your computer tablet or mobile device
Benefit from instant feedback through mock exams and multiple-choice assessments
Get 24/7 help or advice from our email and live chat teams
Full Tutor Support on Weekdays

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

Subjects

  • Excel
  • Import
  • XML training
  • XML
  • Microsoft excel training
  • MS Excel
  • Microsoft Excel
  • Web
  • Export
  • Workbook Properties
  • Properties
  • Create

Course programme

Automating Worksheet Functionality
  • Update Workbook Properties
  • Activity-Update Workbook Properties
  • Create and Edit a Macro
  • Activity-Create and Edit a Macro
  • Apply Conditional Formatting
  • Activity-Apply Conditional Formatting
  • Add Data Validation Criteria
  • Activity-Add Data Validation Criteriaty
Auditing Worksheets
  • Trace Cells
  • Activity-Trace Cells
  • Troubleshoot Invalid Data and Formula Errors
  • Activity-Troubleshoot Invalid Data and Formula Errors
  • Watch and Evaluate Formulas
  • Activity-Watch and Evaluate Formulas
  • Create a Data List Outline
  • Activity-Create a Data List Outline
Analyzing and Presenting Data
  • Create Sparklines
  • Activity_Create Sparklines
  • Create Scenarios
  • Activity-Create Scenarios
  • Perform a What-If Analysis
  • Activity-Perform a What-If Analysis
  • Perform a Statistical Analysis with the Analysis ToolPak
  • Activity-Perform a Statistical Analysis with the Analysis ToolPak
  • Create Interactive Data with Power View
  • Activity-Create Interactive Data with Power View
Working with Multiple Workbooks
  • Consolidate Data
  • Activity-Consolidate Data
  • Link Cells in Different Workbooks
  • Activity-Link Cells in Different Workbooks
  • Merge Workbooks
  • Activity-Merge Workbooks
Exporting Excel Data
  • Export Excel Data
  • Activity-Export Excel Data
  • Import a Delimited Text File
  • Activity- Import a Delimited Text File
  • Integrate Excel Data with the Web
  • Activity-Integrate Excel Data with the Web
  • Create a Web Query
  • Activity-Create a Web Query
Importing and Exporting XML Data
  • Import and Export XML Data
  • Activity-Import and Export XML Data
Activities
  • Activities and Exercise Files – Microsoft Excel 2016 Advanced
Mock Exam
  • Mock Exam- Microsoft Excel 2016 Advanced
Final Exam
  • Final Exam- Microsoft Excel 2016 Advanced

See related categories

Microsoft Excel 2016 Advanced

£ 315 VAT inc.

The best Excel courses

See all

See all