Microsoft Excel 2013 – Advanced

Provided by

  • Sector IT
  • Course Type Online
  • Duration 10 Hours
  • Price £29 + VAT

Enquire about this course

About the course

Description

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:

  • 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

Benefits you will gain:

By enrolling in to this course, you’ll get:

  • High quality e-learning study materials and mock exams.
  • Tutorials/materials from the industry leading experts.
  • Includes step-by-step tutorial videos and an effective, professional support service.
  • 24/7 Access to the Learning Portal.
  • Benefit of applying NUS extra Discount Card.
  • Recognised Accredited Qualification.
  • Access Course Content on Mobile, Tablet or Desktop.
  • Study in a user friendly, advanced online learning platform.
  • Excellent customer service and administrative support.
Who is this course for?
  • If you frequently use Excel, and want to learn even more features of this comprehensive software, our Microsoft Excel Expert course is the one for you. To get the most out of this course, you will need to have completed our Excel beginner or intermediate course or have the equivalent experience of this popular software.
  • Microsoft Office Excel is widely used in businesses across all industries and this online Training Programme is designed for those who wish to develop their skills of using Microsoft Office Excel application. This Qualification is helpful for any Office job, such as PA, Secretary, Admin Assistant, and Administrator, Accountant, Account Assistant, Bookkeeper, Office Manager or any other role in the office environment. Being able to demonstrate you have a high level of Microsoft Office skills will help you stand out to employers.

Course Objectives:

  • This Basic Microsoft Excel training course will teach you to use the basic and common features of Excel in 2013 version. By the end of this course, you will be able to create charts, work effectively with multiple sheets in workbooks, use basic functions effectively, use productivity tools and work with the Excel list/database features.
Requirements
  • To get the most out of this course, you will need to have completed our entry-level Microsoft Excel (Beginner level) or Intermediate course or have the equivalent experience of this extremely popular software.
  • Learners should be ages 16 or over to undertake the qualification.
  • Basic understanding of English language, literacy, numeracy and ICT are required to attend this course.
Career path
  • Completing this training course will show any potential employer that you are comfortable and confident with using key Microsoft Excel applications.
  • This Qualification is helpful for any Office job, such as Admin Assistant, PA, Secretary, and Administrator, Accountant, Account Assistant, Bookkeeper, Office Manager or any other role in the office environment.

Enquire

Start date Location / delivery
No fixed date Online Book now

Related article

Could you be making CV mistakes that are sabotaging your job search? It’s quite possible, and easily fixed, by addressing these common CV mistakes.