Microsoft Excel for The Workplace: CPD Level 1 Beginner

About Course

Start Your Excel Journey with Confidence!

Unlock the power of Microsoft Excel with our comprehensive, CPD Certified, Level 1 Beginner course. Designed for newcomers, this course walks you step-by-step through Excel’s core features, from navigating the interface and managing worksheets to creating formulas, formatting data, and crafting professional charts. By the end, you’ll have the knowledge and skills to operate Excel efficiently at a workplace standard, empowering you to tackle real-world tasks with ease and precision.

Navigate the Excel interface with confidence
Create and manage workbooks and worksheets
Enter, edit, and organize data efficiently
Format data clearly and professionally
Use basic formulas and essential functions
Sort, filter, and work with tables
Create charts and visuals
Prepare, share, and print Excel workbooks

Course Content

Introduction

Course Overview

06:16
Course Introduction

Topic 1 – The Excel Interface
In this topic, we’ll explore key parts of the Excel interface: the Backstage View, the Ribbon, and the Worksheet Interface—essential for navigating Excel efficiently.

Topic 2 – Creating and modifying worksheets and workbooks
In this topic, you will learn the essential skills needed to create, modify, and manage worksheets and workbooks in Excel.

Topic 3 – Rows, columns, and cells
In this topic, you will learn how to work with the fundamental elements of Excel—rows, columns, and cells. We will explore how these building blocks interact to organize and store data.

Topic 4 – Formatting and styling data
In this topic, you will learn how to format and style your data to make your Excel worksheets more visually appealing and easier to understand.

Topic 5 – Copying and pasting data
In this topic, you will learn how to efficiently copy, cut, and paste data in Excel using various methods. These essential skills will help you manage and rearrange data in your worksheets with ease.

Topic 6 – Finding and replacing data
In this topic, you will learn how to efficiently locate and modify data within your Excel worksheets using the Find and Replace features.

Topic 7 – Basics of formulas and functions
In this topic, you will learn how to create and work with formulas and functions in Excel, which are essential for performing calculations and analyzing data.

Topic 8 – Autofill
In this topic, you will learn how to use Excel’s Autofill feature to automatically extend data, fill series, and apply formulas across multiple cells.

Topic 9 – Working with data and tables
In this topic we will equip you with the essential skills to manage your data, by using features like sorting, filtering, and Excel tables.

Topic 10 – Charts and images
In this topic, you will learn how to create, modify, and format charts in Excel to effectively present data visually. You’ll also explore how to insert and customize images and shapes, enhancing your worksheets with clear, professional-looking visual elements.

Topic 11 – Viewing data
In this topic, you will learn how to adjust and optimize the way you view data in Excel, ensuring accessibility and efficiency when working with large worksheets. You’ll explore various zooming techniques, workbook views, navigation tools, and the freeze panes feature to enhance your ability to interact with and manage your data effectively.

Topic 12 – Page setup and printing
In this topic, you will learn how to set up and print Excel workbooks effectively by adjusting key page and print settings. From configuring page layout options to fine-tuning print settings, you will gain the skills needed to ensure your worksheets print exactly as intended.

Topic 13 – Sharing workbooks
In this topic, you will learn how to export Excel workbooks to different file types, such as PDFs and text files, collaborate with others by granting workbook access and creating shareable links, and use comments for clear communication with your colleagues.

Topic 14 – Getting help
Topic 14 focuses on using Excel's built-in support tools to find help when needed. You’ll learn how to use the search bar to locate data, commands, and online resources, and explore the help pane for function guides, support options, and feedback features.

Conclusion

Complete the course and receive a CPD-accredited certificate to showcase your professional development.

About Course

What Will You Learn?

Course Content

Introduction

Course Overview

Course Introduction

Topic 1 – The Excel Interface In this topic, we’ll explore key parts of the Excel interface: the Backstage View, the Ribbon, and the Worksheet Interface—essential for navigating Excel efficiently.

Topic 1 Overview

Lesson 1.1 – The Backstage View

Lesson 1.2 – The Ribbon

Lesson 1.3 – The Worksheet Interface

Topic 1 Quiz

Topic 2 – Creating and modifying worksheets and workbooks In this topic, you will learn the essential skills needed to create, modify, and manage worksheets and workbooks in Excel.

Topic 2 Overview

Lesson 2.1 – Creating worksheets and workbooks

Lesson 2.2 – Modifying Worksheets

Lesson 2.3 – Moving worksheets

Lesson 2.4 – Saving and opening workbooks

Lesson 2.5 – Undo, redo, repeat, and version history

Topic 2 Quiz

Topic 3 – Rows, columns, and cells In this topic, you will learn how to work with the fundamental elements of Excel—rows, columns, and cells. We will explore how these building blocks interact to organize and store data.

Topic 3 Overview

Lesson 3.1 – Understanding rows, columns, and cells

Lesson 3.2 – Inserting rows, columns, and cells

Lesson 3.3 – Adjusting rows, columns, and cells

Lesson 3.4 – Deleting rows, columns, and cells

Lesson 3.5 – Merging and unmerging cells

Lesson 3.6 – Hiding and unhiding rows and columns

Topic 3 Quiz

Topic 4 – Formatting and styling data In this topic, you will learn how to format and style your data to make your Excel worksheets more visually appealing and easier to understand.

Topic 4 Overview

Lesson 4.1 – Cell formatting

Lesson 4.2 – Number formats

Lesson 4.3 – Cell styles

Lesson 4.4 – Conditional formatting

Lesson 4.5 – Themes

Topic 4 Quiz

Topic 5 – Copying and pasting data In this topic, you will learn how to efficiently copy, cut, and paste data in Excel using various methods. These essential skills will help you manage and rearrange data in your worksheets with ease.

Topic 5 – Overview

Lesson 5.1 – Copying, cutting, and pasting data

Lesson 5.2 – Paste options

Lesson 5.3 – The Clipboard

Topic 5 Quiz

Topic 6 – Finding and replacing data In this topic, you will learn how to efficiently locate and modify data within your Excel worksheets using the Find and Replace features.

Topic 6 – Overview

Lesson 6.1 – Finding data

Lesson 6.2 – Replacing data

Topic 6 Quiz

Topic 7 – Basics of formulas and functions In this topic, you will learn how to create and work with formulas and functions in Excel, which are essential for performing calculations and analyzing data.

Topic 7 – Overview

Lesson 7.1 – Formula basics

Lesson 7.2 – Cell referencing

Lesson 7.3 – Function basics

Topic 7 Quiz

Topic 8 – Autofill In this topic, you will learn how to use Excel’s Autofill feature to automatically extend data, fill series, and apply formulas across multiple cells.

Topic 8 – Overview

Lesson 8.1 – Filling values, dates, and patterns

Lesson 8.2 – Adjusting Autofill

Lesson 8.3 – Filling formulas

Topic 8 Quiz

Topic 9 – Working with data and tables In this topic we will equip you with the essential skills to manage your data, by using features like sorting, filtering, and Excel tables.

Topic 9 – Overview

Lesson 9.1 – Sorting data

Lesson 9.2 – Filtering data

Lesson 9.3 – Table basics

Lesson 9.4 – Adjusting tables

Topic 9 Quiz

Topic 10 – Charts and images In this topic, you will learn how to create, modify, and format charts in Excel to effectively present data visually. You’ll also explore how to insert and customize images and shapes, enhancing your worksheets with clear, professional-looking visual elements.

Topic 10 – Overview

Lesson 10.1 – Creating basic charts

Lesson 10.2 – Adjusting chart data

Lesson 10.3 – Modifying and formatting charts

Lesson 10.4 – Inserting images and objects

Topic 10 Quiz

Topic 11 – Overview

Lesson 11.1 – Zooming

Lesson 11.2 – Workbook views

Lesson 11.3 – Navigation

Lesson 11.4 – Freezing panes

Topic 11 Quiz