close

close

Thank you for your enquiry!

One of our training experts will be in touch shortly to go over your training requirements.

close

close

Press esc to close

close close

Back to course information

Thank you for your enquiry!

One of our training experts will be in touch shortly to go overy your training requirements.

close close

Thank you for your enquiry!

One of our training experts will be in touch shortly to go over your training requirements.

Microsoft Excel Training & Certification Course

Online Instructor-led (1 days)

Classroom (1 days)

Online Self-paced (8 hours)

Microsoft Excel Masterclass Course Outline

 

Module 1: Navigation of the Excel Interface

  • Understanding the Excel Start Screen
  • Excel Tab Interface
  • Introduction to Microsoft Excel
  • Excel Workbook Screen
  • Ribbon
  • Name Box
  • Formula Bar
  • Worksheet Tab
  • Understanding the Backstage View
  • Accessing the Backstage View
  • Understanding Dialogue Boxes
  • Launching Dialogue Boxes
  • Understanding the Quick Access Toolbar
  • Changing the Location of the Bar
  • Understanding the Status Bar
  • Exercise

Module 2: Use of Lists and Tables

  • Understanding Lists
  • Applying a Filter
  • Clearing a Filter
  • Performing an Alphabetical Sort
  • Performing a Numerical Sort
  • Creating a Table
  • Inserting or Deleting Table Records
  • Removing Duplicates
  • Modifying a Table
  • Sorting Data in a Table
  • Naming Tables
  • Resizing Tables
  • Converting a Table to a Range
  • Deleting a Table
  • Exercise

Module 3: Conditional Formatting

  • Understanding Conditional Formatting
  • Highlighting Cells Containing Values
  • Highlighting Cells Containing Text
  • Highlighting Duplicate Values
  • Using Top and Bottom Rules
  • Using Data Bars
  • Using Colour Scales
  • Using Icon Sets
  • Creating Custom Rules
  • Conditional Formatting Rules Manager
  • Clearing Rules
  • Exercise

Module 4: Using Formulas and Creating Pivot Tables

  • Using Sparklines
  • Using Formulas in Excel
  • Exploring Excel Functions
  • Using Functions in Excel
  • Insert Function Button
  • Working with Names and Ranges
  • IF Formulas
  • AVERAGE Function
  • COUNT Function
  • Common Logical Functions
  • Create a PivotTable from an Excel Data List
  • Add/Remove/Reorganise Data Fields
  • Refresh Data/Change Data Source
  • Changing the PivotTable Design
  • Creating and Modifying a Pivot Chart
  • VLOOKUP
  • Undo, Redo, and Repeat with Keystrokes
  • Exercise

Enquire Now to Get Free Advice from The Knowledge Academy Excel Training Experts!

Show moredown

Prerequisites

In this Microsoft Excel Masterclass training, there are no formal prerequisites. But, you should have some familiarity with computers and Windows 10.

Audience 

This Microsoft Excel Masterclass training provided by The Knowledge Academy is ideal for anyone who wants to learn how to use Microsoft Excel more effectively.

Microsoft Excel Masterclass Course Overview

The Knowledge Academy is Globally Recognised as the Global Market Leader in Excel Training Courses. Our ‘Microsoft Excel Team’ comprises over 35 leading Microsoft Office Experts with more than 21 years of industry recognised teaching experience. Our instructors have developed a unique teaching style to help aspiring Excel learners to master the art of successfully using Excel as a spreadsheet tool. Our Award-Winning Excel Masterclass Training Course Trainers will guide you step by step on how to use the Excel spreadsheet tool successfully.

Microsoft Excel is a spreadsheet program that is part of the Microsoft Office Suite, and its online and desktop versions allow users to share and collaborate on their files with others in real-time. Microsoft Excel is a spreadsheet program, which is included in the Microsoft Office suite of applications. Enterprises use MS Excel as a spreadsheet solution because of its simplicity for analysing, sorting, reporting and storing data. Excel is used for analysis by businesses of all sizes worldwide to perform financial analysis and accounting tasks. Holding the knowledge and skills required for using Microsoft Excel will benefit individuals in increasing their value, job prospects and becoming successful in their professions.

In this 1-Day Microsoft Excel Masterclass training, delegates will learn about different vital skills required to use Excel to create and edit workbooks and spreadsheets effectively. This training course will show how to fully unlock Excel’s powerful capabilities for sorting and manipulating data. Further, delegates will acquire in-depth knowledge about the uses of Excel’s tab interface and file tab. They will gain an understanding of various steps to add the command to the quick access toolbar. Our highly skilled and expert trainer will conduct this training who have years of experience in teaching Microsoft Office Suite courses.

This training course will cover various essential concepts, such as:

  • Navigation of the Excel interface
  • Excel workbook screen
  • Use of lists and tables
  • Performing an alphabetical sort
  • Conditional formatting
  • Using formulas and creating pivot tables
  • Working with names and ranges

After attending this training course, delegates will be able to generate equations allowing them to give additional data on critical company functions. They'll be able to create spreadsheets that better organise data and give a clearer picture of what's being input. They'll also be able to interpret data at a more advanced level to provide answers and solutions to problems affecting the business.

Delegates can also choose our other popular courses like Microsoft Access MasterclassMicrosoft Outlook MasterclassMicrosoft Word Masterclass, and more courses from our Microsoft Office Training section to gain sufficient skills to use Office tools to enhance their organisational productivity.

What level would I achieve by taking this Excel Masterclass training course?

We have designed this Excel Masterclass course to cover both Beginner and Intermediate levels. For a more advanced level why don’t you try our Microsoft Excel VBA and Macro training course. If you’re not happy that any of these courses cover the level you require, please contact our sales advisors and they will be happy to help!

Enquire Now to Get Free Advice from The Knowledge Academy Excel Training Experts!​

Show moredown

What’s Included in this Excel Training Course?

Our Microsoft Excel Masterclass includes:

  • The Knowledge Academy Microsoft Excel Masterclass Manual
  • Experienced Microsoft Excel Trainer
  • Certificate of Completion
  • Refreshments

Show moredown

Online Instructor-led (1 days)

Classroom (1 days)

Online Self-paced (8 hours)

Microsoft Excel VBA and Macro Training 

Module 1: Recorded Macros

  • Understanding Excel Macros 
  • Enable the Developer Tab
  • Record a Macro
  • Run a Macro
  • Edit a Macro
  • Macro Security
  • Saving a Document as Macro Enabled
  • Relative Cell References
  • Assigning a Macro to the Toolbar
  • Assigning a Keyboard Shortcut to a Macro 

Module 2: Understanding Excel VBA

  • Programming in Microsoft Excel
  • VBA Terminology 
  • VBA Editor Screen
  • Closing the Editor 
  • Viewing the Excel Object Model 
  • Using the Immediate Window 
  • Setting Property Values 
  • Working with Worksheets
  • Accessing Help 

Module 3: Starting with Excel VBA

  • Using the Project Explorer 
  • Working with the Properties Window
  • Working with a Code Module
  • Setting Breakpoints in Code

Module: 4 Using Excel Objects

  • Application Object 
  • Workbook Object
  • Range Object 
  • Using Range Objects 
  • Using Objects in a Procedure

Module 5: Programming Techniques

  • MsgBox Function
  • InputBox Function
  • InputBox Method
  • Simple If Statement
  • If...Then…else Statement
  • Select Case Statement
  • Do Loop
  • Do Until Loop
  • Do While Loop
  • For Next Loop
  • For Each…Next Loop

Module 6: Creating Custom Forms

  • Steps to Create Custom Forms
  • Adding TextBoxes to a Form
  • Changing TextBox Control Properties
  • Adding Label Controls to a Form 
  • Adding a Combo Box Control
  • Adding Option Buttons
  • Adding Command Buttons

Module 7: Procedures

  • Understanding Procedures
  • Creating a New Sub Routine 
  • IntelliSense 
  • Using the Edit Toolbar 
  • Commenting Statements 
  • Indenting Code 
  • Bookmarking in Procedures

Module 8: Using Variables

  • Understanding Variables 
  • Creating and Using Variables 
  • Explicit Declarations
  • Scope of Variables 
  • Understanding Passing Variables 
  • Declaring Data Types
  • Using Arrays

Module 9: Functions In VBA

  • Understanding Functions 
  • Creating User-Defined Functions
  • VARTYPE Function
  • Creating a Function Library 
  • Importing a VBA Module

Module 10: Error Handling

  • Error Types
  • Excel Objects
  • Handling Errors
  • Error-Handling Routine
  • On Error Statements
  • Error Statement
  • Untrapped Errors
  • Working with Err Object  

Show moredown

 

Prerequisites

There are no formal prerequisites for attending this Microsoft Excel VBA and Macro Training course. However, a basic understanding of Microsoft Excel would be beneficial.

Audience

This course is designed by The Knowledge Academy for everyone who wants to enhance their knowledge regarding Microsoft Excel and the Office programming language. 

Microsoft Excel VBA and Macro Training Overview

Microsoft Excel VBA, also known as Visual Basic for Applications, is an internal programming language used by Microsoft Office programmes and is used to create programmes for the Windows operating system. VBA and macros allow users to automate solutions with the use of an intuitive action recorder and the ability to edit those recordings. Studying this training will speed up learners understanding of the VBA programming language in Excel and help them consistently perform repetitive actions on worksheets. Individuals with Excel and programming skills will be able to climb the success ladder by obtaining highly regarded positions in multinational corporations.

In this 1-day Microsoft Excel VBA and Macro Training course, delegates will obtain a solid understanding of Visual Basic for Applications (VBA) and macros. During this training, they will get knowledge of how to manage and regulate user input by creating user forms in Excel. They will also learn how to generate and duplicate a formula from many cells using relative references. Our highly expert trainer with years of teaching experience will conduct this course and help delegates get familiar with the use of Microsoft Excel for VBA and Macros.

Course Objectives

  • To comprehend the scope of a variable when working with variables
  • To understand the concept of passing input parameters into a module
  • To create solutions for complex problems by leveraging Excel functionality
  • To identify an element that allows the input of free-form text
  • To write custom VBA Macros for creating more robust automation
  • To use IntelliSense to speed up development by decreasing keyboard input

After attending this training, delegates will be able to automate processes and carry out a number of other tasks in addition to making and organising spreadsheets. They will also be able to use powerful techniques for editing macros and using Excel more efficiently.

Show moredown

What’s Included in this Excel Training Course?

This course includes:

  • The Knowledge Academy Microsoft Excel VBA and Macro Training Manual
  • Experienced Instructor
  • Certificate of Completion
  • Refreshments
 

Show moredown

Online Instructor-led (1 days)

Classroom (1 days)

Online Self-paced (8 hours)

Excel for Accountants Masterclass Course Outline

Module 1: Using Lists in Excel

  • Defining a List
  • Sorting Lists
  • Filtering Lists
  • Managing a List
  • Using the Data Form

Module 2: Pivot Tables

  • Purpose of Pivot Tables
  • Getting Data Summaries
  • Building Pivot Tables
  • Data Cache
  • Using Named Ranges as Data Sources

Module 3: Common Sizing Using Worksheets

  • Rationale for Common Sizing
  • Common Sizing Income Statements
  • Other Uses of Common Sizing

Module 4: Charting

  • Why Charts?
  • Charts that Show Time Series
  • Pivot Charts Vs Standard Charts
  • Budget Variances Over Time

Module 5: Tools for Accountants

  • What Tools do Accountants Need?
  • Built-In Lists
  • Building Custom Lists
  • Using the Macro Recorder
  • Using Keyboard Shortcuts

Module 6: Scenarios in Excel

  • Scenarios and Multiple Inputs
  • Scenarios and Worksheets
  • Creating Scenarios
  • Defining an Implicit Intersection
  • More Help from the Scenario Manager
  • Grinding it Out with Goal Seek and Solver
  • Wrapping Up Scenarios

Module 7: Payment Functions

  • Using a Function
  • Using the Function Wizard
  • Payment Functions

Module 8: Excel's Depreciation Functions

  • Family of Depreciation Functions
  • SLN Function
  • Accelerated Depreciation

Module 9: Excel and QuickBooks

  • IIF Import Files
  • Format of an IIF File
  • Exporting Data into an IIF File
  • Creating Multiple Lists in One IIF File
  • Importing an IIF File
  • IIF File Keywords for Lists
  • Profile Lists Import Files
  • Standard Lists Import Files
  • Updating Lists with Excel Import Files
  • Importing Adjusting Entries
 

Show moredown

Prerequisites

There are no formal prerequisites to attend this Excel for Accountants Masterclass. However, having some basic understanding of operating desktop or PC and Excel can be beneficial for the delegates.

Audience

This Excel for Accountants Masterclass is designed for anyone who wants to gain in-depth knowledge about Microsoft Excel' features to handle and manage a large amount of data and improve their productivity.

Excel for Accountants Masterclass Course Overview

Microsoft Excel is a useful and sophisticated software for data analysis and documentation. It is a spreadsheet application with columns and rows, with each intersection of a column and row is referred to as a "cell." Microsoft Office Excel was created to help with accounting tasks, including budgeting, financial statement preparation, and balance sheet creation. It can import and export banking and financial data to and from other accounting software platforms by integrating external data. MS Excel spreadsheet is a useful software for businesses and professionals for carrying out accounting, analysis, and record-keeping tasks. It also helps users to maintain a thorough track of their product sales. Holding Excel accounting knowledge and skills will provide individuals with the opportunities to work in multi-national organisations with handsome salaries.

In this 1-day Excel for Accountants Masterclass, delegates will learn to organise the data, including how to lay it out, label it, keep it separate from other information, edit it, and so on. They will gain in-depth knowledge of different ways to use lists for setting up financial analyses that are more sophisticated than just looking at transactions. Our highly professional and expert trainer will conduct this training who have years of experience in teaching Microsoft Office Suite courses.

This Excel for Accountants Training, will cover various essential concepts, such as:

  • Using lists in Excel
  • Pivot tables
  • Charting
  • Tools for accountants
  • Scenarios in Excel
  • Payment functions

After attending this training course, delegates will be able to utilise pivot tables to summarise detailed records like individual transactions into periodic summaries like total debits and credits for an account over a set period. They will also be able to arrange a company's costs by cost centre, vendor within a cost centre, invoice date within a cost centre, and vendor within cost centre.

Show moredown

  • Delegate pack consisting of course notes and exercises
  • Experienced Instructor

Show moredown

Online Instructor-led (1 days)

Classroom (1 days)

Online Self-paced (8 hours)

Business Analytics with Excel Masterclass Course Outline

Module 1: Introduction to MS Excel

  • What is Business Analytics?
  • What is MS Excel?
  • Features of MS Excel
  • Basic Worksheet Modelling
  • Range Names

Module 2: Functions

  • Lookup Functions
  • INDEX Function
  • MATCH Function
  • Text Functions
  • NPV and XNPV Functions
  • IRR, XIRR, and MIRR Functions
  • More Excel Financial Functions
  • IF, IFERROR, IFS, CHOOSE, and SWITCH Functions
  • COUNTIF, COUNTIFS, COUNT, COUNTA, and COUNTBLANK Functions
  • SUMIF, AVERAGEIF, SUMIFS, AVERAGEIFS, MAXIFS, and MINIFS Functions
  • OFFSET Function
  • INDIRECT Function

Module 3: Using Solver

  • Using Solver to Determine the Optimal Product Mix
  • Using Solver to Schedule Your Workforce
  • Using Solver to Solve Transportation or Distribution Problems
  • Using Solver for Capital Budgeting
  • Using Solver for Financial Planning
  • Using Solver to Rate Sports Teams

Module 4: Data in Excel

  • Importing Data from a Text File or Document
  • Geography and Stock Data Types
  • Validating Data
  • Summarising Data by Using Histograms and Pareto Charts
  • Summarising Data by Using Descriptive Statistics
  • Using Pivot Tables and Slicers to Describe Data
  • Data Model
  • Summarising Data with Database Statistical Functions
  • Consolidating Data

Module 5: Introduction to Variables

  • An Introduction to Random Variables
  • Binomial, Hypergeometric, and Binomial Random Variables
  • Poisson and Exponential Random Variable
  • Normal Random Variable and Z-Scores
  • Using the Lognormal Random Variable to Model Stock Prices
 

Show moredown

Prerequisites

There are no formal prerequisites in this Business Analytics with Excel training course.

Audience

This training course is ideal for anyone who wants to advance their knowledge about Excel using business analytics in the organisation.

Business Analytics with Excel Masterclass Course Overview

Business Analytics (BA) is a combination of disciplines and technologies that use data analysis, statistical models, and other quantitative approaches to solve business issues. Many sectors and corporations continue to value Excel skills as a helpful approach to extracting meaningful data. In this training course, delegates will evaluate revenue patterns, operations, marketing trends using Excel and maintain profitability. Magnifying your skills by choosing our very popular Business Analytics with Excel training course will lead you to attain many more acknowledged employment opportunities such as product analysts, marketing analysts, senior revenue data analysts, and many other job opportunities globally.

The Knowledge Academy’s 1-day Business Analytics with Excel training course is designed to enlighten delegates with abundant knowledge of using Excel in business analytics. Delegates will learn about various functions of Excel to maintain the spreadsheet, create graphical visualisation, and take efficient decisions to achieve proficiency in the organisation. During the training course, they will also master the information about the basic worksheet modelling in business analytics.

It also accommodates the delegates with more knowledgeable concepts, such as:

  • To gain knowledge about IRR, XIRR, and MIRR functions
  • To understand more Excel financial functions
  • To use solver for financial planning
  • To use various solver to rate sports teams
  • To gain knowledge about Normal random variable and z-scores

At the end of this training course, delegates will acquire insights into all the different functions used in Excel. Delegates will also get familiar with summarising data using histograms and Pareto charts. Our highly expert trainer with abundant knowledge has curated this training course to drive the delegates to the path of gaining business analytics basics and enhancing data-driven decision-making skills.

Show moredown

  • Delegate pack consisting of course notes and exercises
  • Experienced Instructor

Show moredown

Online Instructor-led (1 days)

Classroom (1 days)

Online Self-paced (8 hours)

Excel Training with Gantt Charts Course Outline

Module 1: MS Excel Basics

  • Getting Started
  • Explore Window
  • Backstage
  • Entering Values
  • Move Around
  • Save Workbook
  • Worksheet
    • Create Worksheet
    • Copy Worksheet
    • Hiding Worksheet
    • Delete Worksheet

Module 2: Editing Worksheet

  • Data
    • Insert Data
    • Select Data
    • Delete Data
    • Move Data
  • Rows and Columns
  • Copy and Paste
  • Find and Replace
  • Spell Check
  • Zoom In-Out
  • Special Symbols
  • Insert Comments
  • Add Text Box

Module 3: Working with Formula

  • Creating Formulas
  • Copying Formulas
  • Formula Reference
  • Using Functions
  • Built-in Functions

Module 4: Excel Charts

  • Types of Advanced Charts
  • Advanced Charts in Brief
    • Waterfall Chart
    • Band Chart
    • Gantt Chart
    • Thermometer Chart
    • Bullet Chart
    • Funnel Chart
    • Waffle Chart
    • Step Chart
    • Box and Whisker Chart
    • Histogram
    • Pareto Chart
  • Organisation Chart
  • Methodology for Creating Advanced Excel Charts

Module 5: Advanced Excel - Gantt Chart

  • What is a Gantt Chart?
  • Advantages of Gantt Charts
  • Preparation of Data
  • Creating a Gantt Chart

Module 6: Make a Gantt Chart

  • How to Make a Gantt Chart in Excel?
  • Add Duration Data to the Chart
  • Add Task Description to the Gantt Chart in Excel
  • Transform the Bar Chart into an Excel Gantt Chart in Excel
  • Adjust the Number of Dates on Your Gantt Chart in Excel

 

 

Show moredown

Prerequisites 

In this Excel Training with Gantt Charts, there are no formal prerequisites. However, it will be great for the delegates to have some basic knowledge of Microsoft Excel.

Audience 

This Excel Training with Gantt Charts Training course is ideal for anyone who handles personal or professional assignments and manages projects and various aspects of the project.

Excel Training with Gantt Charts Overview

A Gantt chart is a type of chart in which the sequence of horizontal lines indicates the amount of work done in a definite period of time. In Excel, you may customise the stacked bar chart type, with the bars constituting tasks, and days are usually represented as the unit of time. Studying this training course will help learners create an amazing Gantt chart dashboard with various filters like timelines and slicers. This training assists organisations in promoting collaboration and handling projects and various activities. Having extensive knowledge of Excel and the ability to work with Gantt charts can help any individual advance in their career and land a higher-paying job.

In this 1-day Excel Training with Gantt Charts Training course, delegates will gain basic knowledge of Excel and its project management tools. During this training, delegates will learn different types of advanced charts, the process of a worksheet, built-in functions, the preparation of data, and how to make Gantt charts in Excel. They will also learn how to transform a bar chart into an Excel Gantt chart in Excel, how to add duration data in Excel, and how to create advanced Excel charts. Our experienced trainer with years of experience in providing interactive training courses will teach this course.

Course Objectives 

  • To gain an understanding of Gantt charts and how to use them in Excel
  • To learn the importance of formulas, functions, and worksheets in Excel
  • To use the various Gantt chart Excel templates to prepare dynamic visuals
  • To adjust the number of dates on your Gantt chart in Excel
  • To learn about the methodology for creating advanced Excel charts

At the end of this training, delegates will be able to create presentations of information in the form of Gantt charts and timelines. They will also be able to measure progress with planned and actual Gantt charts.

 

Show moredown

  • Delegate pack consisting of course notes and exercises
  • Experienced Instructor

Show moredown

Not sure which course to choose?

Speak to a training expert for advice if you are unsure of what course is right for you. Give us a call on 01344203999 or Enquire.

Package deals

Our training experts have compiled a range of course packages to compliment a variety of categories in order to help fast track your career. The packages consist of the best possible qualifications in each industry and allows you to purchase multiple courses at a discounted rate.

Swipe for more. Don’t miss out!

Microsoft Excel Training & Certification Course FAQs

FAQ's

Microsoft Excel is an industry-leading spreadsheet program for storing, manipulating and analysing data.
Our Microsoft Excel courses include a courseware book, refreshments, certificate upon completion and 1 day of tuition from an expert trainer.
Our Excel training courses are available across the world in thousands of locations, making it easy to find a course near you.
There are no formal prerequisites for attending our Excel courses, but you should have some knowledge of how to use a computer and Windows.
The Knowledge Academy is the Leading global training provider for Microsoft Excel Training & Certification Course.
The price for Microsoft Excel Training & Certification Course certification in the United Kingdom starts from £.

Why we're the go to training provider for you

icon

Best price in the industry

You won't find better value in the marketplace. If you do find a lower price, we will beat it.

icon

Trusted & Approved

We are accredited by PeopleCert on behalf of AXELOS

icon

Many delivery methods

Flexible delivery methods are available depending on your learning style.

icon

High quality resources

Resources are included for a comprehensive learning experience.

barclays Logo
deloitte Logo
Thames Water Logo

"Really good course and well organised. Trainer was great with a sense of humour - his experience allowed a free flowing course, structured to help you gain as much information & relevant experience whilst helping prepare you for the exam"

Joshua Davies, Thames Water

santander logo
bmw Logo
Google Logo

Looking for more information on Microsoft Excel Training & Certification Course