Superb course. Possibly the best course I have been on in 22 years in the Fire Service.

J.W. Durham Darlington Fire Rescue, Excel Level 3

Another very useful course that will help me in my job role, brilliant, thank you.

L.B. Greggs, Excel Analysing and Presenting Data with Dashboards and Pivot Tables

Another great course from IT Training Solutions!

A.R. NIHR Clinical Research Network North East and Nort, Adobe Photoshop Level 1
  • Windows Server 2022 Installation, Storage and Compute
  • Windows Server 2022 Managing Identity with Active Directory
  • Windows Server 2022 Networking
  • Administering Windows Server Hybrid Core Infrastructure - AZ-800T00
  • Configuring Windows Server Hybrid Advanced Services - AZ-801T00
  • Autodesk Revit Architecture Essentials
  • CompTIA A+ Core 2 (220-1102)
  • Computers for Beginners and Getting Started with Microsoft Office
  • Microsoft Power Apps and Power Automate Essentials

Excel Level 1

1 Day From £245+VAT per person on a public scheduled course Flexible training dates, locations, and content — request a quote for private course details.
Get full course options and prices sent to you via email
 Book a place on a public course
Get an answer to a question via email

Course Overview

Microsoft Excel is a spreadsheet program that can be used for storing, organising and manipulating data.

This Excel introductory course will enable delegates to gain a good general understanding of the main features of Microsoft Excel, giving them the ability to produce standard spreadsheets, create formulae and format and print spreadsheets.

Course Objectives

    • Create a spreadsheet containing data, navigate using keyboard shortcuts, add new columns and rows and save the spreadsheet.
    • Create and format a spreadsheet using the main features of the formatting tools,
    • Perform the following calculations on a range of numbers: addition, subtraction, multiplication and division.
    • Use: sum, average, count, min and max on a range of numbers.
    • Present the data in a chart and print the spreadsheet

Course Content

  • Exploring the Microsoft Excel environment

    Exploring the user interface
    Exploring the ribbon
    Obtaining help
    Customising the quick access toolbar

  • Understanding Workbooks and Worksheets

    Creating a new workbook
    Saving a workbook
    Opening a workbook already created
    Navigating in Microsoft Excel
    Selecting and entering data
    Saving a workbook

  • Entering and Editing Specific Data

    Entering text and numbers
    Entering numbers as text
    Inputting dates and times
    Editing the contents of a cell
    Manipulating data
    Undo and redo buttons

  • Using and Understanding Cell Formats

    Cell Formats options
    Understanding the General Format
    Date and Time Formats
    Currency and Accounting Formats
    Text Formats
    Clearing and Resetting Formats

  • Ranges

    Selecting a range of cells
    Selecting more than one range
    Selecting an entire column and row
    Highlighting the entire worksheet

  • AutoFill

    Using Autofill to automate data entry
    Text AutoFill
    Number Autofill
    Date AutoFill
    Custom Lists
    FlashFill

  • Columns and rows

    Inserting and deleting cells, columns and rows
    Changing column widths and row heights
    Auto-fitting a column to its contents
    Changing back to standard widths
    Hiding and un-hiding a column or row
    Searching for data in a worksheet
    Freezing and unfreezing rows and columns

  • Developing a workbook

    Formatting worksheet tabs
    Repositioning worksheets in a workbook
    Inserting and deleting worksheets
    Copying and pasting worksheets

  • Formatting a worksheet

    Modifying fonts
    Merging cells
    Aligning cell contents
    Finding and replacing formats
    Applying borders to a selection
    Deleting borders around a selection of cells
    Changing the alignment of the contents of a cell
    Using the format painter
    Clearing cells (removing formats)

  • Cut, Copy and Paste

    Cut, Copy and Paste
    Shortcuts
    Copying and Pasting to different sheets
    Paste Options

  • Performing calculations

    Adding and Subtracting Numbers
    Multiplication and Division
    BODMAS
    Cell references
    SUM function
    AUTOSUM
    Useful Basic Functions AVERAGE, MIN, MAX and COUNT

  • Basic Sorting and Filtering Data

    Sorting data
    Filtering data

  • Basic Charts

    Chart types
    Simple Chart Customisations

  • Spelling and Printing

    Spell checker
    Print preview
    Printing the spreadsheet
    Printing a section of a worksheet
    Clearing a print area

Prerequisites

    • Delegates should be familiar with using computers and have used a mouse and keyboard. Delegates should be comfortable in the Windows environment and be able to use Windows to manage information on their computer.

Public Scheduled Course Dates

Prices per delegate. All prices exclude VAT.
22 Jul 2025
Newcastle
£375
30 Jul 2025
Virtual
£245
02 Sep 2025
Durham
£295
11 Sep 2025
Newcastle
£375
11 Sep 2025
Virtual
£245
07 Oct 2025
Virtual
£245
04 Nov 2025
Virtual
£245
25 Nov 2025
Durham
£295
04 Dec 2025
Virtual
£245
18 Dec 2025
Newcastle
£375
Get full course options and prices sent to you via email
 Book a place on a public course
Get an answer to a question via email
Recommending to everyone!

M.C. Sheard Packaging, Excel Level 1

Looking forward to putting what I've learnt into practice!

C.G. Northumbria University, Microsoft Power BI Desktop

An all round great course, thanks once again.

S.F. Nissan, Excel Level 2
Some of our clients include:
More information

Windows courses in Leeds

We provide Windows in Leeds , our Windows courses can be available as scheduled or private , meaning that you can benefit from training that fits your exact requirements. If you are unsure which Windows courses would suit you, or if you would like help deciding, please give us a call on 0191 377 8377 or contact us online, we will be happy to help.


Private courses in Leeds

Private courses the ultimate in flexible training. You choose the timescale, you choose the location, you choose the delegate(s) and you choose the content.


Public Scheduled courses

Scheduled courses, easy to book - we set the date, location and outline, so all you need to do is let us know which course you would like to attend. If a public scheduled course is not available for Windows in Leeds , we can provide private, onsite or virtual for you in Leeds . One way or another, contact us to let us know how we can help or to book your .

About Windows


Windows is a widely recognized operating system that serves as the foundation for many business operations, providing a stable and secure platform for a multitude of applications and tools. For users, Windows offers a familiar interface that is both versatile and user-friendly, allowing for efficient management of daily tasks and seamless integration with other Microsoft products. Its robust security features and regular updates ensure that business data is protected, while its scalability allows businesses of all sizes to grow and adapt to their changing needs. Whether it's for managing documents, analyzing data, or communicating with team members, Windows provides a reliable environment that supports productivity and collaboration.

About Leeds

Leeds is a vibrant city in the heart of the UK known for its dynamic business environment, rich history, and cultural diversity. As a business tourist, you'll find Leeds to be a hub of innovation and enterprise, with a strong financial and legal sector, and a growing digital and tech industry. The city boasts an array of modern conference facilities, luxury accommodations, and fine dining options to cater to your professional needs.
While you're here, you can take the opportunity to explore the historic architecture, including the grand Leeds Town Hall and the picturesque ruins of Kirkstall Abbey. The city centre is home to a variety of shops, from high-end boutiques to traditional markets, perfect for a leisurely stroll after.
Leeds is also known for its green spaces, such as Roundhay Park and the Leeds-Liverpool Canal, offering a peaceful retreat from the bustling city life. In the evenings, the city comes alive with a range of entertainment options, from the opera and ballet at the Leeds Grand Theatre to the lively bars and clubs.
Whether you're here for a short visit or an extended stay, Leeds is sure to leave a lasting impression with its blend of business acumen and cultural richness.

Leeds offers a variety of travel options to suit your needs. Whether you're looking for quick transportation or a leisurely tour around the city, you'll find an array of choices:
* Buses in Leeds: Leeds has an extensive bus network that connects various parts of the city and the surrounding areas. Regular services run from the bus station and around the city, making it a convenient option for getting to your destination.
* Taxis in Leeds: For a more direct route, taxis are readily available, especially outside the Leeds Station New Street Entrance. They offer a quick and comfortable ride to your location.
* Walking around Leeds: If you prefer to explore the city on foot, Leeds is well-equipped with pedestrian-friendly routes that allow you to take in the sights at your own pace.
* Cycling through Leeds: For those who enjoy biking, there are designated cycle routes throughout the city, providing a healthy and eco-friendly way to get around.
No matter your preference, Leeds ensures that you can navigate the city with ease and efficiency, allowing you to focus on your business and leisure activities.

Please note that the specific transport details and attractions are based on general information and may have evolved since our last update. It's always best to check the latest details before planning your visit.