Microsoft Excel Level 3 Training

Microsoft Excel Level 3 Training provides structured learning in the fundamentals and practical use of Microsoft Excel. The course begins with the Excel interface, workbooks, files and shortcut keys before progressing to text, numbers, dates, sorting and cell references. Learners then explore formulas and functions, including SUM, MIN, MAX, AVERAGE, COUNT and COUNTA. Further modules cover worksheets, formatting, conditional formatting, images, SmartArt, printing and Excel templates. This Excel course can help learners develop practical spreadsheet skills for administrative, office and business environments. It may also be relevant to learners searching for CPD Excel courses or structured Excel CPD learning.

Key areas covered include:

• Excel interface, workbooks and file management

• Data entry, sorting and cell references

• Formulas and essential Excel functions

• Worksheet management and formatting

• Templates, printing and document presentation

Course Overview

Microsoft Excel Level 3 Training is a comprehensive introductory-to-intermediate learning programme covering a broad range of Excel features and functions. Across 44 modules, learners progress from launching Excel and understanding its interface to creating workbooks, entering data, using formulas and working with worksheets.

The curriculum includes important Excel functions such as SUM, MIN, MAX, AVERAGE, COUNT and COUNTA, alongside cell references and order of operations. Learners also study data management, worksheet organisation, formatting, conditional formatting, images, SmartArt, printing and templates.

This Excel training may be useful for learners who want to strengthen their spreadsheet knowledge for workplace, administrative or business tasks. It can also be relevant to people searching for an Excel CPD course or CPD Excel courses.

No external CPD accreditation or certification is specified in the supplied course information.

Description

Microsoft Excel Level 3 Training is designed to develop practical knowledge of Microsoft Excel through a structured 44-module curriculum. Learners start with the Excel interface and essential file-management skills before progressing into data entry, sorting, cell references, formulas and commonly used functions.

The course also covers worksheet management, formatting, conditional formatting, images, SmartArt, printing and Excel templates. These topics provide a broad foundation for using Excel in everyday professional and administrative environments.

Learners can use the course to build confidence with spreadsheets and develop skills relevant to tasks involving data organisation, calculations, formatting and document preparation.

Course Curriculum

Module 1: Introduction

This module introduces the course and provides the starting point for learning Microsoft Excel.

Main learning topics:

• Introduction to Excel

• Overview of the course

• Foundations of Excel use

• Basic spreadsheet concepts

Module 2: Launching Excel

Learn how to launch Microsoft Excel and begin working within the application.

Main learning topics:

• Launching Excel

• Starting the application

• Beginning an Excel session

• Accessing Excel features

Module 3: Start Up Screen

This module introduces the Excel start-up screen and its available options.

Main learning topics:

• Excel start-up screen

• Initial Excel options

• Navigating the start-up environment

• Beginning a workbook

Module 4: The Excel Interface

Explore the main Excel interface and become familiar with its working environment.

Main learning topics:

• Excel interface

• Main interface elements

• Navigating Excel

• Working within the Excel environment

Module 5: The Quick Access Toolbar

Learn about the Quick Access Toolbar and its role in accessing commonly used commands.

Main learning topics:

• Quick Access Toolbar

• Frequently used commands

• Accessing Excel tools

• Working efficiently within Excel

Module 6: The Ribbon

This module introduces the Excel Ribbon and its organisation.

Main learning topics:

• Excel Ribbon

• Ribbon organisation

• Excel commands

• Accessing features and tools

Module 7: Creating New Excel Workbooks

Learn how to create new Excel workbooks.

Main learning topics:

• Creating workbooks

• Starting new Excel files

• Workbook basics

• Beginning spreadsheet projects

Module 8: Saving Excel Files

Explore how to save Excel files and manage saved workbook documents.

Main learning topics:

• Saving Excel files

• Workbook file management

• Saving work

• File organisation

Module 9: Opening Excel Files

Learn how to open existing Excel files and continue working with saved documents.

Main learning topics:

• Opening Excel files

• Accessing saved workbooks

• Working with existing files

• File access

Module 10: Beginner Shortcut Keys

This module introduces shortcut keys that can help learners work more efficiently in Excel.

Main learning topics:

• Beginner Excel shortcuts

• Keyboard commands

• Efficient navigation

• Common shortcut keys

Module 11: Entering Text

Learn the fundamentals of entering text into Excel worksheets.

Main learning topics:

• Entering text

• Adding information to cells

• Working with text data

• Basic data entry

Module 12: Working with Numbers

This module focuses on entering and working with numerical information.

Main learning topics:

• Working with numbers

• Numerical data

• Entering numeric information

• Spreadsheet calculations

Module 13: An Introduction to Dates

Explore the use of dates within Excel.

Main learning topics:

• Entering dates

• Working with dates

• Date information

• Basic date handling

Module 14: Find and Replace

Learn how to use Excel’s Find and Replace functionality.

Main learning topics:

• Finding information

• Replacing information

• Searching worksheets

• Editing spreadsheet data efficiently

Module 15: Sorting Data

This module introduces sorting data within Excel.

Main learning topics:

• Sorting data

• Organising information

• Arranging spreadsheet records

• Data organisation

Module 16: Working with Cell References

Learn about cell references and how they are used in Excel.

Main learning topics:

• Cell references

• Referencing cells

• Using references in formulas

• Spreadsheet calculations

Module 17: Relative Versus Absolute Cell Reference in Formulas

Explore the difference between relative and absolute cell references when working with formulas.

Main learning topics:

• Relative cell references

• Absolute cell references

• Cell references in formulas

• Formula referencing

Module 18: Understanding the Order of Operation

This module introduces the order of operations used when Excel evaluates formulas.

Main learning topics:

• Order of operations

• Formula calculation

• Calculation sequence

• Working accurately with formulas

Module 19: The Structure of an Excel Function

Learn about the structure of Excel functions.

Main learning topics:

• Excel functions

• Function structure

• Function syntax

• Using functions in spreadsheets

Module 20: Working with the Sum Function

Explore the SUM function and its use in Excel calculations.

Main learning topics:

• SUM function

• Adding numerical values

• Spreadsheet calculations

• Applying SUM to data

Module 21: Working with Min and Max

Learn how MIN and MAX functions can be used with spreadsheet data.

Main learning topics:

• MIN function

• MAX function

• Identifying minimum values

• Identifying maximum values

Module 22: Working with Averages

This module introduces the use of averages in Excel.

Main learning topics:

• AVERAGE function

• Calculating averages

• Numerical data

• Spreadsheet calculations

Module 23: Working with Count and CountA

Learn how COUNT and COUNTA can be used to work with spreadsheet data.

Main learning topics:

• COUNT function

• COUNTA function

• Counting spreadsheet information

• Working with data

Module 24: Moving and Copying Data

Explore techniques for moving and copying information within Excel.

Main learning topics:

• Moving data

• Copying data

• Organising spreadsheet information

• Managing cell contents

Module 25: Inserting and Deleting Rows and Columns

Learn how to insert and delete rows and columns within worksheets.

Main learning topics:

• Inserting rows

• Deleting rows

• Inserting columns

• Deleting columns

Module 26: Changing the Width and Height of Cells

This module covers adjusting cell dimensions to organise spreadsheet information.

Main learning topics:

• Cell width

• Cell height

• Adjusting worksheet layout

• Improving spreadsheet presentation

Module 27: Hiding and Unhiding Rows, Columns and Sheets

Learn how to hide and unhide spreadsheet elements.

Main learning topics:

• Hiding rows

• Unhiding rows

• Hiding columns

• Unhiding columns and sheets

Module 28: Renaming Worksheets

Learn how to rename worksheets to help organise workbooks.

Main learning topics:

• Renaming worksheets

• Worksheet organisation

• Managing workbook structure

• Identifying worksheets

Module 29: Deleting Worksheets

This module covers deleting worksheets from an Excel workbook.

Main learning topics:

• Deleting worksheets

• Workbook organisation

• Managing worksheet structure

• Removing unnecessary worksheets

Module 30: Moving and Copying Worksheets

Learn how to move and copy worksheets within Excel.

Main learning topics:

• Moving worksheets

• Copying worksheets

• Organising workbooks

• Managing worksheet structure

Module 31: Adding Borders to Cells

Explore how borders can be added to cells to improve spreadsheet presentation.

Main learning topics:

• Cell borders

• Formatting cells

• Spreadsheet presentation

• Organising worksheet information

Module 32: Formatting Percentages

Learn how to format numerical values as percentages.

Main learning topics:

• Percentage formatting

• Formatting numerical information

• Percentage values

• Spreadsheet presentation

Module 33: Merging and Centering Cells

This module introduces merging and centering cells.

Main learning topics:

• Merging cells

• Centering content

• Worksheet formatting

• Spreadsheet presentation

Module 34: A Quick Look at Styles

Explore Excel styles and their role in formatting worksheets.

Main learning topics:

• Excel styles

• Cell formatting

• Consistent presentation

• Worksheet appearance

Module 35: Basic Conditional Formatting

Learn the basics of conditional formatting in Excel.

Main learning topics:

• Conditional formatting

• Basic formatting rules

• Highlighting spreadsheet information

• Visual presentation of data

Module 36: Inserting Images and Shapes

Learn how to insert images and shapes into Excel worksheets.

Main learning topics:

• Inserting images

• Adding shapes

• Worksheet presentation

• Visual spreadsheet elements

Module 37: Working with SmartArt

This module introduces SmartArt and its use within Excel.

Main learning topics:

• SmartArt

• Visual information

• Adding SmartArt

• Presenting information visually

Module 38: Print Preview

Learn how to use Print Preview before producing a printed Excel document.

Main learning topics:

• Print Preview

• Reviewing documents

• Preparing worksheets for printing

• Checking spreadsheet presentation

Module 39: Margins, Scaling and Orientation

Explore key page-layout settings for Excel documents.

Main learning topics:

• Margins

• Scaling

• Page orientation

• Print preparation

Module 40: Printing

Learn the fundamentals of printing Excel worksheets and documents.

Main learning topics:

• Printing worksheets

• Print settings

• Preparing Excel documents

• Producing printed spreadsheets

Module 41: Intro to Excel Templates

This module introduces Excel templates and their potential use in spreadsheet work.

Main learning topics:

• Excel templates

• Template basics

• Working with predefined spreadsheet structures

• Template use

Module 42: Opening an Existing Template

Learn how to open and use an existing Excel template.

Main learning topics:

• Opening templates

• Existing Excel templates

• Using template files

• Starting from a template

Module 43: Creating a Custom Template

Explore how to create a custom Excel template.

Main learning topics:

• Creating templates

• Custom templates

• Saving reusable spreadsheet structures

• Template development

Module 44: Conclusion

The final module concludes the course and brings together the areas covered throughout the training.

Main learning topics:

• Course conclusion

• Review of Excel topics

• Consolidating learning

• Further Excel development

Who Is This Course For?

Microsoft Excel Level 3 Training may be suitable for:

• Beginners who want structured Excel training

• Learners developing workplace spreadsheet skills

• Administrative professionals

• Office assistants

• Personal assistants

• Business support staff

• Professionals who regularly work with spreadsheets

• Learners wanting to improve data organisation skills

• Individuals interested in Excel-based office skills

• Learners looking for an Excel CPD course

• Professionals seeking additional Excel learning for continuing development

It can also be useful for learners who want to build a foundation in Excel before progressing to more advanced spreadsheet training.

Requirements

No specific academic or professional prerequisites are stated in the supplied course information.

Learners should ideally have:

• Basic computer literacy

• An interest in learning Microsoft Excel

• Basic English comprehension

• Access to a suitable computer or device

• Access to Excel or a compatible learning environment where practical use is required

No previous Excel expertise is specified as a requirement.

Skills You Can Develop

The course can help learners develop knowledge and practical skills in:

• Navigating Microsoft Excel

• Creating and managing workbooks

• Saving and opening Excel files

• Using keyboard shortcuts

• Entering text and numbers

• Working with dates

• Finding and replacing information

• Sorting data

• Using cell references

• Understanding relative and absolute references

• Creating formulas

• Using Excel functions

• Working with SUM, MIN, MAX, AVERAGE, COUNT and COUNTA

• Managing rows, columns and worksheets

• Formatting spreadsheet data

• Using conditional formatting

• Adding images and shapes

• Working with SmartArt

• Preparing worksheets for printing

• Using Excel templates

Learning Outcomes

By the end of Microsoft Excel Level 3 Training, learners should be able to:

1. Navigate the Microsoft Excel interface.

2. Create, open and save Excel workbooks.

3. Use common Excel shortcut keys.

4. Enter and organise text, numbers and dates.

5. Find, replace and sort spreadsheet information.

6. Understand and use cell references in formulas.

7. Distinguish between relative and absolute cell references.

8. Use functions including SUM, MIN, MAX, AVERAGE, COUNT and COUNTA.

9. Manage, format and organise worksheets.

10. Prepare Excel documents using formatting, templates and printing features.

Career Paths

Excel skills are widely relevant to office-based and administrative work because spreadsheets can be used for organising information, calculations, reporting and document preparation. The supplied curriculum provides foundational Excel knowledge, but it does not specify a particular occupational qualification or guarantee employment.

Administrative Assistant

Typical UK salary: Salary varies according to experience, location, employer and responsibilities.

How This Course May Be Relevant: Administrative roles can involve spreadsheets, data entry, organising information and preparing documents. The course develops knowledge of Excel features that may support these tasks.

Office Administrator

Typical UK salary: Salary varies according to employer, sector, location and experience.

How This Course May Be Relevant: Office administrators may use spreadsheets to organise information, manage records and prepare documents. The course provides a broad foundation in Excel.

Data Entry / Administrative Support

Typical UK salary: Salary varies according to employer, location, experience and role requirements.

How This Course May Be Relevant: The course covers entering text and numbers, sorting data, finding and replacing information, and organising worksheets, which can support spreadsheet-based administrative work.

Personal Assistant

Typical UK salary: Salary varies according to employer, sector, location and experience.

How This Course May Be Relevant: Personal assistants may use spreadsheets for organising information, preparing documents and maintaining records. Excel skills can complement wider administrative and organisational abilities.

Business Support Roles

Typical UK salary: Salary varies considerably depending on the role, industry, employer and experience.

How This Course May Be Relevant: Excel is commonly used in business environments for organising information and performing calculations. The course covers formulas, functions, formatting, templates and printing that may be useful in business-support work.

Career note: Salary information varies significantly by job title, employer, location and experience. Completing this course does not guarantee employment or a specific salary. Learners should check current UK job advertisements and reliable UK career sources for the latest salary information.

Frequently Asked Questions

1. What is Microsoft Excel Level 3 Training?

Microsoft Excel Level 3 Training is a 44-module course covering Excel fundamentals, data entry, formulas, functions, worksheets, formatting, printing and templates.

2. What will I learn on this Excel course?

You will learn how to navigate Excel, create and manage workbooks, enter and sort data, use cell references and formulas, apply functions, format worksheets and work with templates.

3. Does the course cover Excel formulas and functions?

Yes. The curriculum includes cell references, relative and absolute references, order of operations, the structure of Excel functions, SUM, MIN, MAX, AVERAGE, COUNT and COUNTA.

4. Is this course suitable for beginners?

Yes. The curriculum begins with launching Excel, the start-up screen, the interface, the Ribbon and basic file management before progressing to formulas, functions and formatting.

5. Is this a CPD Excel course?

The supplied keywords include “CPD Excel”, “Excel CPD” and “CPD Excel course”. However, the supplied course information does not specify external CPD accreditation or a particular CPD certification. Learners should check the course provider’s current accreditation information if formal CPD recognition is required.