-
Day 1
24th February 2027
9:15 am - 4:00 pm
Target Audience
- Supervisors and team leaders
- Customer service staff
- Sales and business support employees
- Career changers and return-to-work learners
- Individuals seeking employment
- Anyone wishing to improve their digital workplace skills
Course Overview
This programme provides learners with the fundamental knowledge and practical skills required to use Microsoft Excel confidently in a workplace environment. Participants will develop the skills needed to create, edit, format and manage spreadsheet information, perform calculations, organise data and present information professionally.
Designed for both employed and unemployed individuals, this programme supports career development, employability, workplace productivity and progression into administrative, customer service, business support, supervisory and management roles. It provides practical digital skills that can be applied immediately within a wide range of professional environments.
Learning Objectives
By the end of this programme, learners will be able to:
- Navigate and use the Microsoft Excel working environment efficiently.
- Create, save and manage spreadsheet files.
- Enter, edit and format information accurately.
- Create and manage worksheets within a workbook.
- Use formulas and functions to process numerical data.
- Sort and filter data to support reporting and analysis.
- Prepare spreadsheets for printing and professional distribution.
- Create charts to communicate information visually.
- Apply Excel skills confidently within workplace and employment settings.
Course Modules
Module 1: Using Excel and Managing Spreadsheet Information
Learning Outcomes
Learners will be able to:
- Identify key features of the Excel interface.
- Navigate workbooks and worksheets.
- Open, save and manage spreadsheet files effectively.
Topics Covered
- Introduction to Microsoft Excel
- Understanding workbooks and worksheets
- Working with rows, columns and cells
- Basic navigation techniques
- Saving and managing files
Module 2: Creating and Editing Spreadsheet Data
Learning Outcomes
Learners will be able to:
- Enter data accurately.
- Edit and update spreadsheet information.
- Structure information effectively.
Topics Covered
- Data entry techniques
- Editing cell contents
- Copying and moving data
- Inserting and deleting rows and columns
- Using AutoFill
Module 3: Creating, Editing and Formatting Information
Learning Outcomes
Learners will be able to:
- Improve the appearance of spreadsheets.
- Apply professional formatting techniques.
Topics Covered
- Font formatting
- Cell formatting
- Number formats
- Alignment options
- Format Painter
- Borders and shading
Module 4: Managing Worksheets and Workbook Structure
Learning Outcomes
Learners will be able to:
- Organise information across multiple worksheets.
- Manage workbook structures efficiently.
Topics Covered
- Creating worksheets
- Renaming worksheets
- Moving and copying worksheets
- Deleting worksheets
- Freeze Panes
Module 5: Processing Numerical Data Using Formulae and Functions
Learning Outcomes
Learners will be able to:
- Create basic calculations.
- Apply commonly used Excel functions.
- Improve data accuracy and efficiency.
Topics Covered
- Understanding formulas
- Cell references
- SUM
- AVERAGE
- MIN and MAX
- COUNTA
- TODAY
- Basic calculations
Module 6: Organising, Sorting and Filtering Information
Learning Outcomes
Learners will be able to:
- Organise spreadsheet data effectively.
- Locate and analyse information efficiently.
Topics Covered
- Sorting data
- Multi-level sorting
- Filtering records
- Working with data lists
- Paste Special
Module 7: Presenting and Sharing Spreadsheet Information
Learning Outcomes
Learners will be able to:
- Prepare spreadsheets for professional presentation.
- Configure workbooks for printing and distribution.
Topics Covered
- Page setup
- Print areas
- Headers and footers
- Page orientation
- Print preview
- Exporting and sharing files
Module 8: Creating and Editing Charts for Data Presentation
Learning Outcomes
Learners will be able to:
- Create visual representations of data.
- Select appropriate chart types for different purposes.
Topics Covered
- Creating charts
- Chart design and layout
- Editing chart elements
- Presenting information visually
Workplace and Employability Benefits
Following completion of this programme, learners will be able to apply their skills within:
- Administrative and office-based roles
- Customer service environments
- Business support functions
- Sales and reporting activities
- Finance and budgeting tasks
- Data entry and record management
- Job applications requiring digital skills
- Career progression opportunities and workplace development
Assessment Method
Learner achievement will be assessed through:
- Practical Excel exercises
- Tutor observation
- Knowledge checks
- Completion of workplace-based tasks and activities
Duration
1 Day Training Programme (6 Guided Learning Hours)
Target Audience
This course is suitable for:
- Individuals seeking employment
- Career changers and return-to-work learners
- Administrative professionals
- Customer service staff
- Supervisors and team leaders
- Sales and business support employees
- Anyone wishing to improve their digital workplace skills
Venue: BPI Consultancy Ltd
Venue Phone: 01685 884175
Venue Website: https://bpigroup.co.uk
Address: