Microsoft Excel Masterclass

  • Gain a solid understanding of Microsoft Excel’s basics and spreadsheet.
  • Learn how to use formulas and create pivot tables more effectively.
  • Become familiarised with the importance of status bar in Microsoft Excel.

Key Points About Microsoft Excel Masterclass

237 Learners Recommended

Duration: 1 Days*

Accredited: Yes

Book Now

Microsoft Excel Masterclass

Course Overview

This Microsoft Excel Masterclass is specially tailored for those who wish to use Excel in their work regularly and want to enhance their Excel skills. This one-day masterclass will help delegates to learn how to highlight cells containing text and how to create and edit worksheets. Along with this, delegates will gain knowledge of how to use formulas and functions as well as sort and filter detail data visually. Delegates will get an understanding of how to present summary information in a consumable and professional format.

They will also learn how to effectively use various excel formulas, tables and charts to manage the business process from small to large.

Course Outline

  • The Excel Tab Interface
  • The Tabs
  • The Main Components of the Workbook Screen
  • The Ribbon
  • Name Box
  • The Formula Bar
  • Worksheet Tab
  • Shortcuts
  • Showing and Collapsing the Ribbon
  • Understanding the Backstage View
  • Understanding Dialogue Boxes
  • Launching Dialogue Boxes
  • Understanding the Quick Access Toolbar
  • Changing the Location of the Bar
  • Modify Quick Access Commands
  • Add a Command
  • Remove a Command
  • Understanding the Status Bar
  • Understanding Filters
  • Applying a Filter
  • Performing an Alphabetical Sort
  • Performing a Numerical Sort
  • Creating a Table
  • Inserting or Deleting Table Records
  • Adding Table Column
  • Deleting Table Column
  • Deleting Table Record
  • Removing Duplicates
  • Modifying a Table
  • Sorting Data in a Table
  • Naming Tables
  • Resizing Tables
  • Deleting a Table
  • Understanding Conditional Formatting
  • Highlighting Cells Containing Values and Text
  • Highlighting Duplicate Values
  • Using Top/Bottom Rules
  • Applying Top/Bottom Rules
  • Top Bottom Rule Types
  • Using Data Bars
  • Using Colour Scales
  • Using Icon Sets
  • Creating Custom Rules
  • To Create a Custom Rule
  • The Conditional Formatting Rules Manager
  • Rules Manager
  • Clearing Rules
  • Using Sparklines
  • Using Formulas in Excel
  • Exploring Excel Functions
  • Using Functions in Excel
  • Insert Function Button
  • Working with Names and Ranges
  • Creating a Named Reference
  • Removing a Named Reference
  • IF Formulas
  • Common Logical Functions
  • Arguments used within IF Functions
  • Create a PivotTable from an Excel Data List
  • Add/Remove/Reorganise Data Fields
  • Changing the Pivot Table Design
  • Refresh Data/Change Data Source
  • Create and Modify a Pivot Chart
  • VLOOKUP

There are no formal prerequisites to attend this masterclass, but you should have some familiarity with computers and Windows 10.

The course is open for anyone who wishes to learn how to use Microsoft Excel.

The Microsoft Excel Masterclass Cost in United Kingdom Starts from £434.00

The Pearcemayfield is the best training provider in the world for Microsoft Excel Masterclass.

Please see our Microsoft Excel Training courses available in United Kingdom

The Pearcemayfield provide course training in almost every location.

telephone

Get More Information

Still have questions? We’re happy to help.

calendar

Dates & Prices

Choose a Location

Choose a Month

Learn from the comfort of your home or office

Join discussions via computer or mobile device

Interact with subject matter experts

40 Hours (on average)

90 Days Access

Certificate upon completion

Schedule and location of your choice

Save on travel costs

Monitor employee development

Key points about this course

237 Learners Recommended

Duration: 1 Days*

Accredited: Yes

Next Week

Fri 10 Jul 2020

Only 4 Seats left icon

flag Nottingham

Best Selling Course in United Kingdom

GBP 1094.00

Selling Fast !
Next Week

Fri 10 Jul 2020

Only 4 Seats left icon

flag Norwich

Best Selling Course in United Kingdom

GBP 1094.00

Selling Fast !
Next Week

Fri 10 Jul 2020

Only 4 Seats left icon

flag Birmingham

Best Selling Course in United Kingdom

GBP 1094.00

Selling Fast !
Next Week

Fri 10 Jul 2020

Only 4 Seats left icon

flag Southampton

Best Selling Course in United Kingdom

GBP 995.00

Selling Fast !
This Month

Fri 17 Jul 2020

Only 4 Seats left icon

flag Cambridge

Best Selling Course in United Kingdom

GBP 1094.00

Selling Fast !
This Month

Fri 17 Jul 2020

Only 4 Seats left icon

flag Aberdeen

Best Selling Course in United Kingdom

GBP 1094.00

Selling Fast !
This Month

Fri 17 Jul 2020

Only 4 Seats left icon

flag Leeds

Best Selling Course in United Kingdom

GBP 1094.00

Selling Fast !
This Month

Fri 24 Jul 2020

Only 4 Seats left icon

flag Glasgow

Best Selling Course in United Kingdom

GBP 1094.00

Selling Fast !
This Month

Fri 24 Jul 2020

Only 4 Seats left icon

flag Liverpool

Best Selling Course in United Kingdom

GBP 1094.00

Selling Fast !
Next Month

Fri 07 Aug 2020

Only 4 Seats left icon

flag London

Best Selling Course in United Kingdom

GBP 1094.00

Selling Fast !
Next Week

Fri 10 Jul 2020

Only 4 Seats left icon

GBP 434.00

Selling Fast !
This Month

Fri 17 Jul 2020

Only 4 Seats left icon

GBP 434.00

Selling Fast !
This Month

Fri 24 Jul 2020

Only 4 Seats left icon

GBP 434.00

Selling Fast !
Next Month

Fri 07 Aug 2020

Only 4 Seats left icon

GBP 434.00

Selling Fast !
Next Month

Fri 14 Aug 2020

Only 4 Seats left icon

GBP 434.00

Selling Fast !
Next Month

Fri 21 Aug 2020

Only 4 Seats left icon

GBP 434.00

Selling Fast !
Next Month

Fri 28 Aug 2020

Only 4 Seats left icon

GBP 434.00

Selling Fast !

Fri 04 Sep 2020

Only 4 Seats left icon

GBP 434.00

Selling Fast !

Fri 11 Sep 2020

Only 4 Seats left icon

GBP 434.00

Selling Fast !

Fri 18 Sep 2020

Only 4 Seats left icon

GBP 434.00

Selling Fast !

Add additional features

6 Months Access - £ 109.00

1 Year Access - £ 164.00

Official Exam - £ 109.00

Personal career coach and career services

£ 215.00

Your online (Microsoft Excel Masterclass) package

Upon purchase you will receive a password via the email you used to purchase the course.

You will then be able to login to our online learning platform with your email and password.

You will have access to the platform for 90 days to complete your course.

Course Onsite Enquiry

Microsoft Excel Masterclass

Complete the steps below to receive a quote or more information

Your details

How many employees need training test?

When would you like to take the course test?

How many employees need training?

Prev

Discover how we are doing

Our goal is to always provide training of the highest quality for your organisation.

We aim for customer satisfaction across all areas, including price, quality, and learning support. We always use the feedback from clients to continually improve and ensure we surpass expectation. Have a look at our customer reviews that showcase the standard we offer.

97% price

Response Rate

99% price

Positive Rating

Steps For Success

Leading Path To Success

works