Step Into Learning
  • 5
  • Adult Learning
  • 5
  • Using Excel Spreadsheet Software – Basic, Intermediate & Advanced

Using Excel Spreadsheet Software

These courses will allow you to develop your skills using spreadsheet software. The courses are offered at three different levels so you can choose the one that suits your current level – basic, intermediate or advanced. Build your knowledge, confidence and skillset.

Course Summary

Level: Basic, Intermediate or Advanced Duration: 1 day (6 hours including breaks)
Start Date: Please enquire Type: Online in ‘live’ classroom or face to face
Location: Online or Suitable Venue Agreed by Learner & Step Into Learning
Price: £120 – payment required upfront. Potential additional venue and travel charges if face to face Age Range: 19+
Funding: N/a Awarding Organisation: N/A

Who is this course for?

These courses are for everyone, whether you’re looking to start building your spreadsheet skills, need a refresher or are looking to move on to a more advanced level – we have an option for you! The course is available at three levels – basic, intermediate and advanced.

Entry Requirements

There are no formal qualifications required to undertake this course. To find out about available dates and secure your place, please complete the application form below. After this, we will be in touch to arrange next steps.

Why should I do this qualification?

This course is for you if you want to start, build or enhance your spreadsheet skills

What will I learn?

Learners will develop their understanding, knowledge and skills using spreadsheet software:

Basic Level:

  • Navigation
  • Text – alignment
  • Cell formatting
  • Introduction to mathematical formulae
  • Tables and helpful tools
  • Charts
  • Pivot tables
  • Copying between workbooks

Intermediate Level:

  • More complex formulae
  • Splitting cell content
  • Linking cells
  • Functions (IF, AND, OR)
  • Nesting functions
  • Conditional formatting
  • Combo charts
  • Managing large spreadsheets – including multi select
  • Freezing views
  • Printing

Advanced Formula:

  • Understand and construct formulae with absolute cell references
  • Understand and construct some logical functions
  • Understand and construct a combination of some logical functions
  • Understand and construct VLookup and HLookup functions
  • Effectively use the built in auditing tools available
  • Understand and construct data validation to restrict types of data entry
  • Consolidate data using pivot table and charts
  • Understand and construct some common functions
  • Use different methods to convert text into columns
  • Use advanced formatting techniques
  • Use advanced conditional formatting
  • Be able to apply and remove protection to workbooks and individual worksheets
  • Printing large spreadsheets

Advanced Desktop App:

  • Macros
  • Protecting workbooks/worksheets
  • More topics can be added if required

How will I be assessed?

These courses are completed in one day and there is no assessment – tasks will be given and completed throughout the session. We will provide a certificate of attendance.

Need some answers?

We're here to help.

Call us on: 01566 770729
Or email us at: info@stepintolearning.org.uk

Got a Question?

Excited to get Started

If you’re happy with what you’ve seen, why delay, apply today.

Course Application Form - Apply Now!

16-24 with an EHCP Step Into Supported Internships Application Form 2027-28

    Education (required)
    Health & Medical Information
    Parent / Guardian / Carer Information
    Application Questions
    Skill Assessment - please tick one box per row (required)











    Interests - please tick one box per row (required)









    Reference 1
    Reference 2
    Applicant Declaration
    For information please read our privacy policy here.


    Related Courses

    No Results Found

    The page you requested could not be found. Try refining your search, or use the navigation above to locate the post.