Skip to content

Microsoft Excel and Google Sheets Training for Beginners

Interactive Video Lessons | Free E-Certificate | Tutor Support

Frontier Education


£12 inc VAT
Study method
Online, self-paced
Course format What's this?
4 hours
Access to content
365 days
No formal qualification
  • Certification of Completion - Free
Additional info
  • Tutor is available to students

5 students purchased this course

Add to basket or enquire


The "Microsoft Excel and Google Sheets Training for Beginners" course is designed to provide individuals with a solid foundation in spreadsheet software. This online course covers the essential features and functions of both Microsoft Excel and Google Sheets, enabling participants to create, format, and analyze data effectively. The course includes hands-on exercises and practical examples to reinforce learning. Participants will learn how to navigate the software, work with worksheets and formulas, create charts and graphs, and utilize data analysis tools. By completing this course, individuals will gain proficiency in using spreadsheet software and enhance their data management and analysis skills.


Module 1: Introduction to Spreadsheets and Spreadsheet Software

- Overview of spreadsheets and their applications

- Introduction to Microsoft Excel and Google Sheets interfaces

- Navigating worksheets and workbooks

Module 2: Data Entry and Formatting

- Entering and editing data in cells

- Formatting cells, rows, and columns

- Working with fonts, colors, and styles

Module 3: Basic Formulas and Functions

- Understanding formulas and cell references

- Using basic mathematical functions (e.g., SUM, AVERAGE)

- Applying functions for text manipulation and data analysis

Module 4: Working with Worksheets and Workbooks

- Creating and managing worksheets

- Linking and referencing data between worksheets

- Organizing and grouping data with workbooks

Module 5: Data Visualization with Charts and Graphs

- Creating and customizing charts and graphs

- Choosing appropriate chart types for different data sets

- Adding titles, labels, and formatting options to enhance visual representation

Module 6: Sorting and Filtering Data

- Sorting data based on criteria

- Applying filters to display specific data subsets

- Using advanced filtering options for complex data analysis

Module 7: Data Analysis Tools

- Utilizing data analysis tools for statistical calculations

- Creating pivot tables to summarize and analyze data

- Applying conditional formatting to highlight trends and patterns

Module 8: Collaboration and Sharing Features

- Collaborating on spreadsheets with multiple users

- Sharing spreadsheets securely and controlling access

- Tracking changes and comments in collaborative environments

Module 9: Automating Tasks with Macros (Excel only)

- Introduction to macros and automation in Excel

- Recording and editing macros for repetitive tasks

- Assigning macros to buttons or shortcuts for quick execution

Module 10: Assessment and Certification

- Final assessment to evaluate understanding and competency

- Certification of completion

Who is this course for?

  1. Collecting, organizing, and analyzing data using spreadsheet software.
  2. Developing reports, dashboards, and data visualizations to present findings.
  3. Performing data cleaning, validation, and quality checks.
  4. Creating complex formulas and functions to automate data analysis tasks.
  5. Conducting statistical analysis and generating insights from data sets.
  6. Developing and maintaining data models and databases.
  7. Collaborating with stakeholders to understand data requirements and deliver actionable insights.


No prior knowledge or experience required

Career path

  1. Designing and implementing data analysis workflows and processes.
  2. Providing training and support to colleagues on spreadsheet software and data analysis techniques.
  3. Keeping up to date with new features and functionalities of spreadsheet software

Questions and answers

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


Certification of Completion

Digital certificate - Included


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


What does study method mean?

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.

What are CPD hours/points?

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.

What is a ‘regulated qualification’?

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.

What is an ‘endorsed’ course?

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.