Intermediate Excel
About this course
Ready to move beyond the basics?
Building on existing knowledge you will be introduced to a wide range of intermediate practical tools to help manage data more efficiently, perform more powerful calculations and start working with dynamic features like VLOOKUP, charts and pivot tables.
Expect hands-on learning that boosts both your skillset and the confidence to explore advanced Excel training.
Click the subheadings below for more information!
What you will study
This course is delivered at our City Centre Campus from 9.30am – 4:00pm.
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
- 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
Bring your own laptop or borrow one of ours on the day!
Course fees
Administration Fee: £10.00
Course Fee: £40.00
Entry requirements
You are eligible for this course if you:
• are aged 19+
• are not in full time education
• can attend the entire session
• have experience using Microsoft Excel for data management
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.
Start date
End date
Time of day
Course code
Qualification
Facilities
Career prospects & further study
7%
This course leads on to the Microsoft Excel Advanced course, which expands and builds upon the knowledge covered.