Course Introduction

Individuals who have been using Microsoft Excel 2013 either for their work purpose or during self-development carry a small basis in the basic and intermediary skills for working in Excel. This one-day course will enable the candidates to expand their information and capabilities above a foundation level by using some of the more functional and advanced abilities of Excel.

This will include automating few common tasks, applying advanced scrutiny techniques to more complex data sets such as pivot tables, cooperating on worksheets with others and importing and exporting data.

  • topics-icons

    This Excel course include course material, manuals, Exams and certificates

  • topics-icons

    Learn how to use and apply Excel by your Accredited Microsoft partner

  • topics-icons

    Enhance your productivity at work and fast track your career

  • topics-icons

    Excel training course delivered by highly experienced Instructors

  • topics-icons

    Getting a certification always increases your value and helps in getting a hike in salary

  • topics-icons

    Pre and post course Email support is provided

What’s included

BPT offers more benefits. Here is what's included with this course:


Tutor Support




Participants are expected to have the below mentioned basic skills prior to attending this course:

    • Creating, editing and formatting spreadsheets
    • Working with absolute references
    • Creating named ranges
    • Using insert function to create built-in functions
    • Creating tables within excel
    • Sorting and filtering data
    • Navigating within worksheets and books
Show More

Delegates will learn how to

  • Set up and manipulate pivot tables and pivot charts
  • Writing functions as an array
  • Create macros to automate common tasks
  • Write advanced lookup and reference functions
  • Ensure acceptable data entry with data validation
  • Import and export data
  • Use advanced practices to analyse data
  • Collaborating by merging and tracking workbooks
Show More

Target Audience

The course is designed for the individuals who intend to expand their knowledge and skills to use advanced practices for manipulating Excel data. Prior to attending this course participants should have some basic skills of using Excel.

Show More

Course Information



Our state of the art venue based in Southampton has the latest learning tools to help you enhance your skills as a professional proje... Learn More

Popular Locations

Reaching You Across The World

enquireEnquiry call02380