Intermediate Excel

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.

You must meet at least 1 of the 2 Entry Requirement points below;

- 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 (Please note that this point is a self-assessment and therefore we will take this at face value upon receipt of your application).

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.