Course Introduction

Microsoft Excel is a spreadsheet application used worldwide for creating, updating and reviewing spreadsheets from anywhere. The Microsoft Excel Masterclass training course is designed to provide essential knowledge and skills required to create, edit, format and share spreadsheets and workbooks by effectively using Excel. The course familiarises the delegates with advanced formulas and different tools used for analysing data in spreadsheets, such as sorting, conditional formatting, filtering, and checking.

 

  • topics-icons

    Learn to use spreadsheet application more effectively

  • topics-icons

    Explore, import and organise massive data sets

  • topics-icons

    Create and work with interactive PivotTable views with ease

  • topics-icons

    Fast track your career opportunities and enhance your productivity

  • topics-icons

    Course delivered by highly experienced Microsoft Excel Instructor

What’s included

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

exam

Tutor Support

exam

Certificate

exam

Refreshment

Prerequisites

There are no formal prerequisites for attending the Microsoft Excel Masterclass training course. However, the candidates should be familiar with Windows 10 and Microsoft Office.

Show More

Delegates will learn how to

  • Use Microsoft Excel for creating basic worksheets
  • Modify an Excel worksheet as per specific requirements
  • Work with Backstage views and Quick Access Toolbar
  • Customise a Workbook using tab colours and themes
  • Create pivot tables, pivot charts, and slicers
  • Trace precedents and dependents to identify which cells impact specific cells
  • Restrict type of data entered into a cell using data validation
  • Add and edit macros to the Quick Access Toolbar
  • Collaborate with others by protecting worksheets and workbooks
  • Import and export data to a text file
  • Work with Array and advanced lookup and reference functions
Show More

Target Audience

The Microsoft Excel Masterclass training course is designed for anyone who wants to learn how to create, format, edit, analyse and share Microsoft Excel workbook and spreadsheet. 

Show More

Course Information

Microsoft Excel has become a crucial part of every business, and it is widely used for interpreting and analysing the data and performing formula-based calculations quickly and efficiently. Microsoft Excel helps the delegates to save their time and make the work more manageable by displaying, manipulating and sharing data. Learn the basics of Excel including entering data, creating 3-D workbooks, sorting and analysing data and designing custom charts and graphs. The course introduces delegates to the latest features, functions, and tools of MS Excel.

Microsoft Excel Masterclass Schedules

Course Name Duration Dates Price
Microsoft Excel Masterclass 1 Day Southampton
24-08-2018 £795.00
Microsoft Excel Masterclass 1 Day Southampton
12-10-2018 £795.00
Microsoft Excel Masterclass 1 Day Southampton
07-12-2018 £795.00
Microsoft Excel Masterclass 1 Day London
03-08-2018 £214.00
Microsoft Excel Masterclass 1 Day London
17-08-2018 £214.00
Microsoft Excel Masterclass 1 Day London
07-09-2018 £214.00
Microsoft Excel Masterclass 1 Day London
21-09-2018 £214.00
Microsoft Excel Masterclass 1 Day London
05-10-2018 £214.00
Microsoft Excel Masterclass 1 Day London
19-10-2018 £214.00
Microsoft Excel Masterclass 1 Day London
02-11-2018 £214.00
Southampton

Southampton

Southampton is the largest city, which is located in England. The city lies around 111 kilometres south-west of London and about 24 kilometres west north-west of Portsm... Learn More

Popular Locations

Reaching You Across The World

Summer Sale Discount 

  023 8000 1008 Call us today

Cookie Policy - To give you the best possible experience, this site uses cookies. Continuing to use this site means that you agree to our use of cookies.  Okay, I accept

enquireEnquiry call02380
001008