Online
Microsoft Office Excel 2013 – Advanced
  • Duration / Course length: Upto 6 Hours Start now
  • Accredited by: CPDiAP
  • Certificates:
  • Course delivery: This course is delivered in video format

Course details


Looking for Microsoft Office Excel 2013 course for Advanced level? This online course is specially designed for the learners who have studied beginner or intermediate level course or are already confident with the basic features offered in Microsoft Excel. The advanced Excel course will surprise you, excellent teaching materials and lots of formulas to play around with. If you are looking to improve your Excel knowledge and your skills, this is the right course for you! What are you waiting for?

If you know the basics of Excel, including entering data, formatting cells, using functions and formulae and inserting charts and graphs, this Advanced Excel course will really unlock the power of the programme and its advanced functionality. This advanced Microsoft Excel training course will teach you to use the advanced features of Excel to their full extent.

This online training course is comprehensive and is designed to cover the following key topics are listed under the curriculum. This course has been designed for 15 guided learning hours.

COURSE CURRICULUM

MODULES
 
  • Apply Conditional Formatting
  • Trace Cells
  • Troubleshoot Invalid Data and Formula Errors
  • Watch and Evaluate Formulas
  • Create a Data List Outline
  • Create Sparklines and Scenarios
  • Perform a Statistical Analysis with the Analysis ToolPak
  • Create Interactive Data with Power View
  • Consolidate Data
  • Link Cells in Different Workbooks
  • erge Workbooks
  • Export and Import Excel Data
  • Integrate Excel Data with the Web
  • Create a Web Query
Course Objectives:
  • For those who have a basic grounding in Microsoft Excel, this course will provide you with the knowledge and skills to use MS Excel at an advanced level.
Course Duration:

You will have 12 Months access to your online study platform from the date you purchased the course. The course is self-paced so you decide how fast or slow the training goes. You can complete the course in stages revisiting the training at any time.

Method of Assessment:

At the end of the course learners will also take an online multiple choice questions assessment test. This online multiple choice questions test is marked automatically so you will receive an instant grade and know whether you have passed the course.

Certification:

Successful candidates will be awarded certificate for “Certificate in Microsoft Office Excel 2013 – Advanced”.
 
  Ultima actualização em  29 February, 2024

Eligibility / Requirements

  • Learners must be age 16 or over and should have basic understanding of the English Language, numeracy, literacy and ICT.