• 0208 432 6218
  • WhatsApp
  • AI Assistant
  • Register

Microsoft Excel for Beginners

Learn Spreadsheets, Formulas, Functions, Data Organisation and Charts

Regular Price: £120
Batch Price: From £105   📅  View Dates & Prices

Group Booking Discount: From £75 per person  🧮 Calculate & Book

1-to-1 Training: £150  📋 Booking Request Form

Course Overview

Microsoft Excel is one of the most widely used spreadsheet applications for organising information, performing calculations, analysing data and creating reports. It is used across many areas of work, including administration, finance, sales, marketing, operations, education and general business.

Our Microsoft Excel for Beginners course is designed for people who are new to Excel or who have used spreadsheets before but want to develop a stronger understanding of the essential features. The course provides practical, instructor-led training to help you create and manage spreadsheets confidently.

You will learn how to navigate the Excel interface, enter and organise data, format worksheets, create calculations using formulas and functions, work with rows and columns, sort and filter information, create Excel tables and present data using charts.

The course also introduces useful productivity features such as AutoFill, keyboard shortcuts, Freeze Panes, worksheet management and sharing workbooks. Practical exercises are used throughout the session so that you can apply the skills as you learn them.

By the end of the course, you should be able to create professional spreadsheets, perform common calculations, organise and present data effectively, and use Excel more confidently for work, study or everyday tasks.


Requirements

No previous Microsoft Excel experience is required. This course is designed for complete beginners and users who want to strengthen their basic Excel skills.

Participants should have basic computer skills, such as using a keyboard and mouse, opening and saving files, and navigating folders.

You will need Microsoft Excel installed on your computer. Microsoft 365 or a recent desktop version of Excel is recommended. Participants attending live online training should also have a reliable internet connection and be able to join the instructor-led session using the online meeting platform provided.


Course Content

  1. Introduction to Microsoft Excel
    • What Microsoft Excel is and how it is used
    • Common workplace uses of spreadsheets
    • Understanding workbooks and worksheets
    • Rows, columns, cells and cell references
    • Creating, opening and saving Excel workbooks
  2. Understanding the Excel Interface
    • The Ribbon, tabs and command groups
    • Formula Bar and Name Box
    • Quick Access Toolbar
    • Worksheet tabs
    • Status Bar and workbook views
    • Zooming and navigating large worksheets
  3. Entering and Managing Data
    • Entering text, numbers and dates
    • Editing and deleting cell contents
    • Copy, cut and paste
    • Using AutoFill and the Fill Handle
    • Inserting and deleting rows and columns
    • Adjusting column width and row height
    • Moving and copying data
  4. Formatting Worksheets
    • Formatting fonts, colours and cell backgrounds
    • Text alignment and wrapping
    • Borders and cell styles
    • Formatting numbers, currency, percentages and dates
    • Using Format Painter
    • Creating clear and professional worksheet layouts
  5. Introduction to Formulas
    • Understanding how Excel formulas work
    • Using mathematical operators
    • Creating addition, subtraction, multiplication and division formulas
    • Using cell references in calculations
    • Copying formulas using AutoFill
    • Understanding relative cell references
    • Common formula errors and how to correct them
  6. Essential Excel Functions
    • Understanding functions and function syntax
    • SUM
    • AVERAGE
    • MIN and MAX
    • COUNT and COUNTA
    • Using AutoSum
    • Combining functions with cell ranges
  7. Organising and Working with Data
    • Sorting data in ascending and descending order
    • Sorting text, numbers and dates
    • Filtering worksheet data
    • Creating and formatting Excel tables
    • Using table headers and filter controls
    • Finding and replacing information
  8. Managing Worksheets and Workbooks
    • Adding, renaming and deleting worksheets
    • Moving and copying worksheets
    • Changing worksheet tab organisation
    • Freezing rows and columns using Freeze Panes
    • Working with multiple worksheets
  9. Creating Charts
    • Understanding when to use charts
    • Selecting data for a chart
    • Creating basic column, bar, line and pie charts
    • Adding chart titles and labels
    • Changing chart layouts and formatting
    • Moving and resizing charts
  10. Printing and Page Layout
    • Using Print Preview
    • Setting page orientation
    • Adjusting margins and scaling
    • Selecting a print area
    • Preparing worksheets for printing or PDF export


Course Dates, Prices & Enrolment

Scroll right for more details
Classroom Training
29 Nov 2026 - 29 Nov 2026
Sunday
10:00 AM - 01:00 PM BT
£120
Online Training using Zoom
29 Nov 2026 - 29 Nov 2026
Sunday
10:00 AM - 01:00 PM BT
£105 £120
Classroom Training
01 Dec 2026 - 01 Dec 2026
Tuesday
11:00 AM - 02:00 PM BT
£120
Online Training using Zoom
01 Dec 2026 - 01 Dec 2026
Tuesday
11:00 AM - 02:00 PM BT
£105 £120
Classroom Training
07 Jan 2027 - 07 Jan 2027
Tuesday
11:00 AM - 02:00 PM BT
£120
Classroom Training
23 Jan 2027 - 23 Jan 2027
Saturday
10:00 AM - 01:00 PM BT
£120

Price Calculator & Booking Request Form

Calculate prices for Corporate, 1-on-1 or group training and request a booking.

Do you have a special training requirement or unable to find any suitable training date? Please complete and submit the booking request form, if you want to:

  • book a course on different dates
  • book for a group of delegates
  • book corporate training
  • book a customised training
  • book a one-on-one training

The price person is less when you book a course for more people. You can find the price per person and the total cost by changing the values of the training hours and the number of people below:

Part of a Structured Career Pathway

This course is a key milestone within our professional learning pathways. Complete the recommended track to develop job-ready skills.

BI Professional Path

Learn how to become a Business Intelligence (BI) Professional with training in Power BI, SQL, Excel, Python, data modelling, dashboards, reporting, and business analytics. Explore BI career opportunities and learning pathways.

Explore Full Pathway Track

Data Analyst Career Path

Follow a practical Data Analyst career path with instructor-led training in Excel, SQL, Power BI, Python, Pandas and data visualisation skills.

Explore Full Pathway Track

Frequently Asked Questions

No prior Excel experience is required. This course is designed for beginners who want to learn how to use Microsoft Excel confidently from scratch.

Yes, this course is beginner-friendly and introduces Excel step by step using practical examples and exercises.

Yes, the course covers creating charts, sorting tables, and organising data effectively within spreadsheets.

Most modern versions of Microsoft Excel are suitable for this course, including Microsoft 365 and recent desktop versions of Excel.

Yes, Excel is widely used in workplaces, education, finance, administration, and many other fields. This course helps build essential spreadsheet and data-handling skills.

The course is instructor-led and can be attended live online, in person at our London training centre, or delivered on-site at your organisation for corporate training.

Yes, participants will receive a certificate of completion after successfully finishing the course.

You will learn the basics of Microsoft Excel, including creating spreadsheets, formatting worksheets, using formulas and functions, sorting data, creating charts, and working with tables.

Yes, the course includes an introduction to Excel formulas and functions, helping you perform calculations and work more efficiently with data.

You will need Microsoft Excel installed on your computer before attending the course.

Yes, the course includes practical hands-on exercises to help you apply what you learn and build confidence using Excel.

Yes, Excel is commonly used for organising, analysing, and visualising data, especially for reporting, budgeting, and basic data analysis tasks.

Yes, the instructor will provide guidance and support throughout the session, and participants can ask questions during the training.

After completing this course, you can progress to more advanced Excel topics, data analysis, Power BI, SQL, or other business and data-related courses.

Related Posts

What Our Participants Say

“My tutor was friendly and helpful. I managed to get through a lot of information and learn many Excel skills. It was an intense three hours, but I think it will be helpful for my work.

My one bit of feedback for improvement might be that you could have some of the example tables already on the computer, so the student just has to manipulate the info and not actually type in the cells as well

But it was great! Thanks! I might enrol in some of your other courses.”

Ruth 23 July 2025

What we do?

At London Academy of IT, we provide instructor-led online and in-person IT training in Data Analytics, SQL, Python, Power BI, and more. Our cutting-edge courses are designed to boost performance and enhance employability, providing the competitive edge employers look for.

Our Contacts

London Academy of IT
64 Broadway
Stratford
London E15 1NT
United Kingdom

Regional Training

2012 - 2026 © London Academy of IT Limited. All Rights Reserved.
UKPRN: 10045491. Registered in England & Wales with company no. 07923992.