Overview
Welcome to CNA
An advanced course for existing Excel users covering formulas, pivot tables, automation, and data analysis techniques used in real workplace reporting.
Welcome to CNA
For existing Excel users ready to go beyond the basics — advanced formulas, pivot tables, data validation, and simple automation techniques used in real workplace reporting.
The course assumes comfort with basic Excel already and moves quickly into the tools that separate a confident Excel user from an advanced one.
INDEX/MATCH, XLOOKUP, and nested logical functions for complex calculations
summarising and visualising large datasets quickly and accurately
keeping a spreadsheet's data reliable as more people work in it
recording and using simple macros to save time on repetitive tasks
combining formulas, formatting, and charts into a single, usable reporting view
Key information about the course at a glance.
Working knowledge of basic Excel
3-4 Weeks
Certificate of completion issued by CNA Training Institute.
Please contact us for current fee.
Flexible payment options available.
Work towards Certificate of completion issued by CNA Training Institute, issued on successful completion of the programme.
Skills and understanding you can apply directly in real Computer & Digital Technologies settings.
Delivered in the classroom or online over 3-4 weeks, so study fits around existing commitments.
A firm base for further study and continued career development within Computer & Digital Technologies.
A qualification you can evidence — Certificate of completion issued by CNA Training Institute.
A working understanding of day-to-day practice in Computer & Digital Technologies.
Practical techniques you can put to use immediately.
The confidence to take on more responsibility at work.
Tutor guidance and structured materials throughout the course.
A recognised step towards further study in the same field.
Find quick answers to the most common questions about our courses,
enrollment process and more.
Working knowledge of basic Excel
3-4 Weeks
The number of face to face taught sessions will be confirmed.
Please contact us for current fee.; Flexible payment options available.
Flexible payment options are available — speak to our admissions team about instalment plans.
Certificate of completion issued by CNA Training Institute.
No hidden costs.; All charges will be communicated clearly at the time of enrolment.
Academic guidance, tutor support and learning resources throughout your course.
