About this course
Take your Microsoft Excel skills to the next level!
This Advanced Excel Training is designed to build upon a solid intermediate foundation, to take your knowledge to the next level and unlock the tools for tackling complex, real-world challenges with confidence and creativity.
Explore features such as advanced data organisation and management, cell protection and sparklines, as well as sophisticated formulas and functions like RANK. By the end of the course, you will have the confidence to experiment and explore visual tools such as charts, pivot tables and pivot charts.
Click the subheadings below for more information!
What you will study
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 tools and features of Microsoft Excel outlined below:
Enter and Organise Data
-
Insert, copy, delete and hide tabs
-
Change tab colour
-
Cell styles
-
Linking Worksheets and Workbooks
-
Cell Protection and restricting data entry
-
Protecting Worksheets
-
Protecting Workbooks
-
Named Ranges
-
Naming Tables
-
Page Setup and Repeating rows and columns
Managing Data
-
Data Validation
-
Sub-totals
-
What if – Goal seek
-
Filters and Slicers
-
Sparklines
Functions and Formulas
-
IF Statements - Advanced
-
SumIfs
-
CountIfs
-
CountA and CountBlank
-
RoundUp and RoundDown
-
Rank
Charts, Pivot Tables and Pivot Charts
-
Managing Charts
-
Creating Pivot Tables and Pivot Charts
-
Managing Fields
-
Filtering and sorting
-
Drill Down
Bring your own laptop or use one of ours on day!
Course fees
Administration Fee: £10.00
Course Fee: £35.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 in-depth 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%
What’s next after Advanced Excel?
-
Power BI
-
Microsoft Office Specialist (MOS) Certification