Skip to content
  1. Online
  2. Business
  3. Data analysis

Basic Data Handling & Visualisation with Excel & Google Sheets
One Education

CPD Accredited Training with 24/7 Tutor Support, Webinars, Case Studies, Roadmap and Career-Ready Skills

Summary

Price
£109 inc VAT
Or £36.33/mo. for 3 months...
Study method
Online
Duration
2 hours · Self-paced
Access to content
1 year
Qualification
No formal qualification
CPD
10 CPD hours / points
CPD What's this?
Certificates
  • Digital certificate - Free
  • Hard copy certificate - Free
Additional info
  • Tutor is available to students

Overview

Data analysis and visualisation are essential skills across almost every industry, from finance and marketing to healthcare and education. Organisations rely on accurate, insightful data to make informed decisions, and the ability to clean, manipulate, and visualise datasets is highly sought after by employers.

This course has been designed to give learners the knowledge, confidence, and practical skills to handle data efficiently using Microsoft Excel and Google Sheets. Unlike short, basic tutorials, this programme covers essential topics employers expect: spreadsheet foundations, data cleaning, formula mastery, visualisation techniques, dashboards, collaboration, and real-world projects. You’ll gain the ability to work confidently with raw datasets, turn insights into visuals, and present information clearly for decision-making.

Delivered entirely online, the course allows you to study anytime, anywhere. With 24/7 access to structured learning materials, you can progress at your own pace — ideal for students, professionals, or anyone looking to upskill. On completion, you’ll receive a CPD QS Accredited certificate to showcase your proficiency to employers and enhance your career opportunities.

Exclusive Bonus Bundle — included at no extra cost when you enrol (you won’t find this complete package elsewhere):

  • 12 Webinars: monthly live sessions with Q&A that turn learning into practical skills, explore data handling best practices, and provide tips for career-ready data projects.
  • Career & Study Roadmap: a step-by-step plan for mastering data analysis skills and targeting roles where Excel/Sheets expertise is required.
  • Future Field Progression Roadmap: guidance for advancing your data skills over 12–24 months, including advanced analytics, dashboards, and business intelligence tools.
  • 2 Case Studies: practical exercises that simulate real-world data scenarios, from cleaning and analysis to visualisation and reporting.
  • Course & Module Mindmap: visual summaries at the end of each module, plus a master end-of-course mindmap for fast revision.
  • Additional Templates & Printable Forms: pre-formatted spreadsheets, dashboards, and checklists to apply immediately in professional settings.

These bonuses are designed to accelerate learning, demonstrate your readiness to employers, and provide tools you can use immediately in real data-driven environments.

Certificates

CPD

10 CPD hours / points
Accredited by CPD Quality Standards

Course media

Description

This course is structured to mirror the key tasks performed by data analysts, administrative staff, and business intelligence professionals. Each module is designed to build practical skills, develop confidence, and prepare you for real-world data handling and visualisation tasks.

What you’ll study:

  • Spreadsheet Foundations & Data Setup – learn Excel & Google Sheets basics, navigate interfaces, structure datasets, and maintain data hygiene to avoid common errors.
  • Data Cleaning & Validation – apply validation rules, handle missing or duplicate data, use text and date cleaning functions, and highlight patterns with conditional formatting.
  • Core Formulas & Functions – master arithmetic, aggregation, logical operations, lookup functions, and error-handling best practices.
  • Sorting, Filtering & Summarising Data – organise data with sorts and filters, create grouped summaries, and build pivot tables for deeper insights.
  • Visualisation Basics – understand data storytelling, create charts, customise visuals, and use sparklines for quick insights.
  • Dashboards & Interactive Reports – design dashboards, implement interactivity, build in Excel and Google Sheets, and publish/share results effectively.
  • Collaboration, Integration & Real-World Projects – work with shared spreadsheets, collaborate in real time, integrate with other tools, and complete a capstone project from raw data to final presentation.
Key features of this course include:
  • 24/7 online access so you can study at your own pace.
  • Clear, structured modules aligned with industry expectations.
  • Engaging content designed by subject matter experts.
  • Tutor support to help guide your learning.
  • Certificate included upon completion.

By the end of the course, you will not only understand how to manage, analyse, and visualise data but also be able to demonstrate practical skills that make a difference to employers. This course is your stepping stone into a career in data analysis, business intelligence, or any role that requires Excel and Google Sheets expertise.

Who is this course for?

  • Job seekers looking to start a career in data analysis or office administration.
  • Professionals aiming to enhance Excel & Sheets skills for workplace efficiency.
  • Students preparing for roles requiring data handling, reporting, or analytics.
  • Individuals seeking to improve decision-making through effective data visualisation.

Requirements

  • No prior experience required, but basic computer literacy is recommended.
  • Access to a computer, laptop, or tablet with internet connection.
  • Willingness to learn, practise, and apply spreadsheet and data visualisation skills.

Career path

This course supports career progression across various industries where data analysis and reporting are key. Average UK annual salaries include:

  • Data Entry / Office Administrator – £18,000 to £24,000
  • Junior Data Analyst – £22,000 to £30,000
  • Reporting Analyst – £25,000 to £32,000
  • Business Analyst (Entry Level) – £28,000 to £35,000
  • Operations / Project Coordinator – £24,000 to £32,000

Questions and answers

There are currently no Q&As for this course. Be the first to ask a question.

Ask a question

Reviews

Currently there are no reviews for this course. Be the first to leave a review.

Leave a review

Legal information

This course is advertised on Reed.co.uk by the Course Provider, whose terms and conditions apply. Purchases are made directly from the Course Provider, and as such, content and materials are supplied by the Course Provider directly. Reed is acting as agent and not reseller in relation to this course. Reed's only responsibility is to facilitate your payment for the course. It is your responsibility to review and agree to the Course Provider's terms and conditions and satisfy yourself as to the suitability of the course you intend to purchase. Reed will not have any responsibility for the content of the course and/or associated materials.

FAQs

Study method describes the format in which the course will be delivered. At Reed Courses, courses are delivered in a number of ways, including online courses, where the course content can be accessed online remotely, and classroom courses, where courses are delivered in person at a classroom venue.

CPD stands for Continuing Professional Development. If you work in certain professions or for certain companies, your employer may require you to complete a number of CPD hours or points, per year. You can find a range of CPD courses on Reed Courses, many of which can be completed online.

A regulated qualification is delivered by a learning institution which is regulated by a government body. In England, the government body which regulates courses is Ofqual. Ofqual regulated qualifications sit on the Regulated Qualifications Framework (RQF), which can help students understand how different qualifications in different fields compare to each other. The framework also helps students to understand what qualifications they need to progress towards a higher learning goal, such as a university degree or equivalent higher education award.

An endorsed course is a skills based course which has been checked over and approved by an independent awarding body. Endorsed courses are not regulated so do not result in a qualification - however, the student can usually purchase a certificate showing the awarding body's logo if they wish. Certain awarding bodies - such as Quality Licence Scheme and TQUK - have developed endorsement schemes as a way to help students select the best skills based courses for them.
View all
Related searches: Online courses

Interest free credit agreements provided by Zopa Bank Limited trading as DivideBuy are not regulated by the Financial Conduct Authority and do not fall under the jurisdiction of the Financial Ombudsman Service. Zopa Bank Limited trading as DivideBuy is authorised by the Prudential Regulation Authority and regulated by the Financial Conduct Authority and the Prudential Regulation Authority, and entered on the Financial Services Register (800542). Zopa Bank Limited (10627575) is incorporated in England & Wales and has its registered office at: 1st Floor, Cottons Centre, Tooley Street, London, SE1 2QG. VAT Number 281765280. DivideBuy's trading address is First Floor, Brunswick Court, Brunswick Street, Newcastle-under-Lyme, ST5 1HH. © Zopa Bank Limited 2026. All rights reserved.