Microsoft Excel Masterclass

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.

Overview
Course Content

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.

Course Content

Introducing Microsoft Excel

Start a Microsoft Excel
Create a Workbook
Save a Workbook
Describe the Status Bar
Add and Delete Worksheets
Copy and Move Worksheets
Transform the Order of Worksheets
Split the Worksheet Window
Close a Workbook

The Backstage View (The File Menu)

Backstage View - An Overview
Opening Workbooks
Select, Open and Save a Template
Explore new Workbooks and Excel Templates
Print Worksheets
Add your Name to Microsoft Excel
Personalize your Copy
Manage Workbook Versions

Working with Data

Enter Text
Expand Data across Columns
Add and Delete Cells in Worksheets
Enter Numbers and Dates
Add a Hyperlink
Add an Outline
Add WordArt to a Worksheet
Use AutoComplete
Use the Fill Handle

Sorting Data

How to Perform Alphabetical and Numerical Sort?
How to Sort Numbered List?
Perform Sorting By Rows
An Overview Of Filters, Compound Filters, Multiple Value Filters
How To Create Custom Filters?

Manipulating Rows and Columns

Insert lesson titles in a bulleted list
Add Rows and Columns
Delete Rows and Columns
Change Row Height and Column Width
Transpose Rows and Columns
Hide and Unhide Rows and Columns
Freeze Panes

Format Microsoft Excel Worksheets

Hide Worksheets
Add Color to Worksheet Tabs
Add a Watermark
Add Themes to Workbooks
Add Borders to Cells
The Font Group
Change Font and Font Size
The Alignment Group
Wrap and Indent Text
Merge and Center Text
The Number Group
Change Date Formats
Change Number Formats

Pivot Tables & Charts

Create Pivot Tables
Amend the Fields in a PivotTable
Work with Pivot Tables
Format Pivot Tables
Add Calculations to a PivotTable
Create Pivot Charts
Add Grouping to a PivotTable
Insert Slicers
PivotTable Timelines
More Pivot Table Functionality
Create PivotTables from Tables and Related Tables

Automating Tasks with Macros

Create a Macro
Compare Relative and Absolute Macros
Assign Shortcuts to Macros
Macro Security
Enable Macros in the Backstage View
Copy a Macro between Workbooks
Describe Document Properties and the Document Inspector

Advanced Lookup and Reference Functions

GETPIVOTDATA
MATCH
INDIRECT
ROW / COLUMN
INDEX
VLOOKUP
OFFSET
LOOKUP (Array format)
LOOKUP (Vector format)

Array Functions

Define an Array Formula
Understand Array Functions
FREQUENCY
Define Single Cell or Multiple Cell Arrays
Single Cell Array Functions
Multiple Cell Array Functions TRANSPOSE

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.

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.

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

Training Solutions at Your Convenience

Our objective has always been to address and resolve the problems of our learners in an efficient manner and improve their learning prospects. We are accustomed in providing training courses as per our learner’s convenience. We love every opportunity to use our experience to resolve difficulties confronted by learners.

Microsoft Excel Masterclass Training Calender

Filters

Explore Now

Choose Mode of Training

Classroom

Online Instructor-led

Online Self-Paced

Onsite

Microsoft Excel Masterclass

Book Now

6 Months Access - £219

Extend your access to match your schedule.

1 Year Access - £439

Give yourself as much time as you need to complete the course

Microsoft Excel Masterclass

40 Hours (on average)

90 Days Access

40 Hours (on average)

Course Price

£1095
add-ons Price

£0
Sub-Total

£1095

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 from the date of purchase.

ONSITE ENQUIRY?

Fill up the form below and we will get back to you!

Video Conferencing

We provide the best web conferencing platform(s) to facilitate our learners to enhance their communication with the instructor.

Digital Whiteboards

Our courses include the real-time demonstration of figures, diagrams and other interactive material through digital whiteboards.

Instant Messaging

During the Virtual Classroom session, learners can raise their queries through instant messaging and follow up on their doubts.

Participation Controls

Through participating effectively in training, individuals can easily discuss their views, mute their surroundings and virtually "raise" their hands.

Features of Our Virtual Classroom Courses

How to Choose and Attend Your Ideal Course?

FIND COURSES

We provide 400+ courses covering broader aspects of personal and professional development training needed by any individual. You can choose any course as per your need or requirement. Our courses are designed to fulfil the current organisational and job marketplace requirements.

Select the Course

Choose the course you want to attend to fulfil your desired goals.

Attend the Course

Attend the training with your prefered method at your convenience.

Get Certification

Upon finishing the course, you will get the completion certificate validating your learning.

Microsoft Excel Masterclass

£ 1095 £ 1045

Benefits of Attending Our Online Courses

We provide a variety of certification programmes or courses for individuals to master a skill set and pursue a full-time career in management, IT, or other domains through the online method to provide them with the convenience of learning. Our dedicated staff works tirelessly to assure the availability of courses with eminence quality that's not found anywhere with benefits like:

Learn a New Skill From Onsite Training

Adaptable Courses

We provide onsite courses modified according to our client's organisational needs.

Cost-Effective Learning

Onsite training helps you to reduce travelling and venue expenses.

Learn in Familiar Surroundings

Training at your convenient place can be ideal for learning new skills.

Team Building Opportunity

Attending onsite training with your team can help to improve your team dynamics tremendously.

Best Practice Training provides specially designed training courses in 410+ locations spanning over 30+ countries globally. All our locations have state of the art facilities for the learners. Some of the Popular Locations are: