Course Title and Level
Introduction to Data Analysis using Microsoft Tools – Level 2
Course Summary
This course is designed for learners who want to develop practical data analysis skills using industry-standard Microsoft tools. You’ll gain hands-on experience with real-world data and learn how to organise, transform, and present information using Excel and Power BI. Covering the full data analysis process, from understanding raw data to creating meaningful visuals and reports, this course builds essential skills to support your work, career development, or further study.
Who is the course for?
This course is for confident users of Excel, who are able to create formulas, charts and filter and sort data. It is designed for individuals who want to acquire essential skills for data analysis and reporting. These skills are in demand when looking for work.
What will I learn on this course?
By the end of the course, you will be able to:
• Understand what data analysis is and how it’s used.
• Carry out data analysis using Microsoft Excel and Power BI.
• Work with Excel tools including PivotTables, PivotCharts, formulas, and Power Query.
• Use Power BI to build data models, create visuals, and apply basic DAX calculations.
• Clean and transform data from different sources.
• Choose visuals to suit your audience and message.
• Structure and deliver a clear data presentation.
Progression Opportunities
After completing this course, you can progress to further CALAT courses such as
Introduction to AI: Practical Applications in the Real World (Level 2) or pursue digital or data-related qualifications with other providers. These skills are valuable across a wide range of sectors, including administration, business, and customer service.
Course Entry Requirements
You should have completed Level 2 Digital Skills at CALAT. External applicants should be confident using Excel, including formulas, tables, and charts. Full attendance is expected as each session builds on the last.
Course Location / Delivery Method
CALAT Clock Tower / Classroom-based learning in a small group setting (maximum 12 learners). The course runs for 9 weeks, with one weekly session lasting 5 hours. Some practice at home is encouraged to support learning.
Additional Information (equipment etc.)
Please bring a pen, notebook, and folder to each session.
Exams / Accreditation
This is a non-accredited course with no formal exam. However, you’ll be expected to submit some work to show how you’ve developed your skills. A certificate of attendance will be awarded on completion.
Joining Instructions
Click the ENROL button below or, for more information email CALAT-ICT@croydon.gov.uk or call 020 8726 6000 (Extension 28230).
Before you enrol, you’ll need to attend a Digital Skills Taster session, where you'll complete a short assessment to help determine your suitability for the course. If needed, we’ll recommend a more appropriate option.
Courses
Digital Skills - Introduction to Data Analysis using Microsoft Tools (Level 2)
- Reference CTC191-25
- Location: CALAT Central Croydon Centre
- Start Date: 17 Sep 2025
- End Date: 19 Nov 2025
- Course Duration: 9 weeks
- Time: Wed 09:30-12:30, 13:00-15:00
- 8 places available
Fee Band | Amount |
Full Fee | 315.00 |
Remission | 0.00 |
Overseas | 645.75 |