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

We can cover topics such as;

Enter and Organise Data

• Adjusting row height and column width, including autofit
• Hiding rows, columns and tabs
• Wrapping Text
• Merge and Centre
• Cell formatting
• Formatting as a Table
• Basic Conditional Formatting
• Absolute v Relative cell referencing, including mixed references
• Managing Comments
• Advanced Printing
• 2-Directional freezing of Panes / Split Panes 

Managing Data

• Filters
• Show Formulas
• Data Validation
• Data Checking – Circular cell references and tracing precedents and dependents

Intermediate Calculations, Functions and Formulas

• More complex calculations and using Indices
• IF Statements
• SumIf
• CountIf
• VLookup
• Concatenate

Basic Charts

• Bar Charts
• Pie Charts
• Line Charts
• Axis, Legends and Titles
• Move and resize

Basic Pivot Tables

• Creating Pivot Tables
• Managing Fields
• Basic sorting

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

This programme is funded through Multiply. To be eligible to enrol, you must:

• Be aged 19 or over
• Be able to provide evidence that you currently work and/live in Cardiff and the Vale e.g. ID, Utility Bill, Employment Contract with full address clearly stated.
• Be dedicated to attending the entire session/s Please upload your evidence when applying as applications will not be processed without this evidence.

Suitability Check:

• You have already attended our Basic Excel Training
• And/or are confident in Basic Excel functions, use excel regularly and wish to develop knowledge in topics outlined above in the What You Will Study section.

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