Basic Excel

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

Click along with our Course Tutor, complete practical and scenario-based activities, and dive deeper into basic tools and features of Microsoft Excel outlined below: 

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) 

Bring your own laptop or borrow one of ours on the day!  

Administration Fee: £10.00

Course Fee: £40.00

You are eligible for this course if you:

• are aged 19+

• are not in full time education

• can attend the entire session

• have some experience using Microsoft Excel

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