Basic Excel

L2 Level 2
3 February 2027 — 3 February 2027
City Centre Campus, Cardiff

About this course

Excel Essentials: Build Skills, Boost Confidence

Ready to unlock the power of Excel? This beginner-friendly course is the perfect starting point for anyone new to spreadsheets. The course covers topics like how to enter, organise and manage data, create calculations and formulas, and use essential Excel functions with confidence. Through practical, hands-on activities, you'll develop valuable skills that can be applied immediately in the workplace. By the end of the course, you'll have the confidence to work independently in Excel and a solid foundation to progress to our Intermediate Excel course.

What you will study

This course is delivered at our City Centre Campus from 9.30am – 4pm.  

If you do not have a laptop, one will be made available for you to use on the day.

Enter and Organise Data

  • New; Open; Save; Save as
  • Menu tabs
  • Cells; Rows; Columns; Tabs; Cell fill colour; Cell format
  • Pointers and Fill Handles
  • Text; Bold; Italic; Underline; Text colour; Centre; Left and Right justify
  • Quick Access Toolbar
  • Cut; Copy; Paste; Snipping tool; Spell check
  • Managing views; Normal; Page break; Freeze panes; Split panes; Show Formula bar, Gridlines and Headings
  • Page layout and orientation; Print area; Print preview; Page setup; Headers and Footers

Managing Data

  • Basic sorting
  • Find and replace
  • Save as CSV / Excel Workbook
  • Insert from CSV / Text

Basic Calculations and Formulas

  • Basic calculations, including the impact of cell formatting
  • BODMAS and using brackets
  • Formatting numbers; Decimal places; Currency, Percentages etc.
  • Linked calculations
  • The impact of negative numbers on calculations

Basic Functions

  • Sum and Autosum
  • Min
  • Max
  • Average
  • Count
  • Round (Especially for use with currency and linked calculations)

Practical Activities

Further scenario based activities to put into practice topics previously covered.

Course fees

Course Fee: £150.00

Entry requirements

You are eligible for this course if you:

  • are aged 19+
  • can attend the entire session
  • have some experience using Microsoft Excel

Important points

  • The College welcomes contact with parents/guardians of students who are under 18.
  • Additional support is available for students with learning difficulties and disabilities.
  • Cardiff and Vale College is committed to inclusion and values diversity. We are determined to promote equality of opportunity and to treat everyone fairly and with respect.
  • Cardiff and Vale College reserves the right to make changes to this course without prior notice.
  • Course fees are subject to change. Your fee will be confirmed prior to enrolment.
  • All courses are accurate at the time of upload or print.
  • Courses can only run if there are sufficient numbers.
  • Please note, if you choose three or more course choices, then you may be referred for a careers appointment first. This does not apply to A Level or GCSE choices.
Key information

Start date

3 February 2027

End date

3 February 2027

Time of day

Day Time

Location

City Centre Campus, Cardiff
Maps & directions

Course code

CSBE2P01
L2

Qualification

Basic Excel

Career prospects & further study

This course ideally leads on to the Excel Intermediate course, which expands and builds upon the knowledge covered.

Locations

City Centre Campus, Cardiff
City Centre Campus, Cardiff

City Centre Campus,

Dumballs Road,

Cardiff,

CF10 5FE