Excel Introduction

Build confidence with Excel from the ground up

Course Overview

For those who have never done anything in Excel or lack confidence in their computer skills. The focus of this course is to build a solid understanding of the basics using lots of exercises building from very simple ones to help you master the controls to more practical applications you have to deal with in the workplace.

Learning Outcomes

Understand what Excel is and its benefits in the workplace
Navigate confidently around the Excel workbook interface
Manage worksheets including inserting, deleting, and adjusting columns and rows
Apply formatting to improve the appearance and readability of data
Use number formatting and freeze panes effectively
Add, edit, move, and remove data efficiently
Sort and filter data to find information quickly
Create and edit basic formulas
Use essential functions including SUM, AVERAGE, MIN, MAX, and COUNT
Set up and print worksheets professionally

Course Curriculum

1
Welcome & Introduction
  • Course introduction and objectives
  • Housekeeping (connection issues, breaks, communication)
  • What you will need during the day
2
Getting Started with Excel
  • What is Excel?
  • Benefits of using Excel in the workplace
  • Accessing the application and workbooks
  • Overview of the workbook interface
  • Practice: Finding your way around Excel
3
Basic Controls & Concepts
  • Basic concepts related to the worksheet
  • Managing worksheets (tabs, adjust column/row size, insert/delete, hide/unhide)
  • Practice: Working with worksheets
4
Formatting
  • Best practice for formatting
  • Adjusting appearance (font, colour, alignment)
  • Practice: Formatting basics
  • Number formatting
  • Using Format Painter and AutoFormat
  • Using freeze panes
  • Practice: Number formatting and freeze panes
  • Overall practice: Comprehensive formatting exercise
5
Working with Data
  • Adding, editing, and removing data
  • Moving data
  • Practice: Data manipulation
  • Ordering (sorting) data
  • Filtering data
  • Practice: Sort and filter
  • Overall practice: Comprehensive data exercise
6
Functions & Formulas
  • Adding and editing formulas
  • Practice: Basic formulas
  • Using functions: SUM
  • Using functions: AVERAGE
  • Using functions: MIN and MAX
  • Using functions: COUNT
  • Practice: Working with functions
  • Overall practice: Comprehensive formulas and functions exercise
7
Printing
  • Page setup and print preview
  • Print options and settings
  • Practice: Printing a worksheet
8
Course Wrap-up
  • Recap of key learnings
  • Ongoing support details
  • Certificate information
  • Q&A

Course Details

From
£150.00
+ VAT

Duration

1 day

Who Should Attend

This course is ideal for complete beginners to Excel, those who have used Excel minimally and want to build confidence, anyone who struggles with IT-related tasks but needs to use spreadsheets, and employees who need to use Excel in their daily work but have had no formal training.

Prerequisites

No prior Excel experience required. Basic computer skills helpful but not essential.

What's Included

  • Comprehensive course materials
  • Hands-on exercises
  • Certificate of completion
  • 30-day post-course support
  • Lunch and refreshments

Need help? Call us on

0118 242 9868

Group Booking

Special rates for 4+ people

Available Training Sessions

Choose from our upcoming scheduled training sessions. All sessions are delivered by certified instructors and include comprehensive course materials.

No Upcoming Public Sessions

Private training and group bookings available on request.

Request Private Training Contact Us

Frequently Asked Questions

Booking & Scheduling

Courses & Content

Guarantee & Refunds

Pricing & Discounts