Beginners Excel

Digital Skills & Photography

Overview

Spreadsheet basics introduce the Excel interface and its key features. Participants learn about the workbook structure, worksheets, and cells. They familiarise themselves with the various ribbon tabs and commands used to perform basic tasks like saving, opening, and printing workbooks. This foundation ensures individuals have a solid understanding of the Excel environment and can navigate it confidently.

Participants learn how to input data into cells, adjust column widths and row heights, and apply formatting options like font styles, cell borders, and background colours. They also explore features like conditional formatting to visually highlight specific data patterns. These skills enable individuals to present data in a clear and professional manner.

Formulas and functions address the heart of Excel's power—the ability to perform calculations and automate tasks. Participants learn how to create formulas using mathematical operators and functions like SUM, AVERAGE, and COUNT. They understand how to use cell references to perform calculations across multiple cells. Additionally, participants explore logical functions like IF and VLOOKUP, which allow for more advanced data manipulation and decision-making. These skills enable individuals to perform basic calculations and automate repetitive tasks efficiently.

Participants learn how to sort and filter data to extract specific information, use charts and graphs to visually represent data trends, and apply basic data analysis tools like PivotTables. They also explore data validation to ensure data integrity and learn how to create basic dashboards.

Participants learn how to create and modify simple macros to automate repetitive tasks. They understand how to assign macros to buttons for quick access and explore the concept of conditional formatting rules. This knowledge enables individuals to save time and increase efficiency by automating routine operations in Excel.

Proficiency in Excel is highly valued across various industries, and this course equips individuals with the necessary skills sought by employers. It provides a solid foundation for individuals pursuing careers in finance, data analysis, project management, and other fields where Excel is widely used.

Excel is a versatile tool that can be applied in numerous personal and professional contexts. By mastering the basics of Excel, individuals can better organise their personal finances, manage inventories, create schedules and budgets, and perform various tasks more efficiently.

Price

FREE

Course Type / Level

Beginners

Category

Digital Skills & Photography

Who is this for?

This course is for people who are new to Microsoft Excel.
You should be able to turn a computer on and off, be able to use a mouse and keyboard, everything else we will teach you.

Entry Requirements

Age 19 +
EU/UK resident for the last 3 Years
Basic IT skills – be able to turn a computer on and off, be able to use a mouse and keyboard, everything else we will teach you.

Dates and Duration

Start Date: 03 March 2025
Time: 09:15 - 12:15
Day: Monday
Duration: 5 Weeks

Location

Billingham Community Centre
The Causeway, Billingham
TS23 2DA

Progression Route

You could progress onto another one of our digital skills courses including Intermediate Excel, or Functional Skills ICT

Share this page:

Request More Information

Form Fields

Read about our Privacy Policy.

Related Courses

Digital Skills & Photography image
Digital Skills & Photography

The Beginners Excel Course is a program designed to introduce individuals to the fundamentals of Microsoft Excel, a powerful spreadsheet application widely used in various industries and professions. This course is tailored for individuals with little to no prior experience with Excel and aims to equip them with the essential skills needed to navigate, manipulate, and analyse data effectively. The Beginners Excel Course covers key areas, including spreadsheet basics, data entry and formatting, formulas and functions, data analysis and visualisation, and basic automation. You should have completed a beginners computing course before embarking on this class.

Learn More