Basic Excel

Every session is designed to mould to the level of experience of those attending each session. 

We can cover topics such as;

How to 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 Excel Functions

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

This 1-day course is delivered onsite from 9.30am – 4:00pm.

Suitable for those who either have little Microsoft Excel knowledge/experience, or those who wish to refresh their current knowledge in the above topics.

This course is funded via the UK Government’s Multiply project so you will be requested to complete a Declaration form when you attend.

• 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.