Spreadsheets and Excel

The use of a spreadsheets and Excel is prevalent in many jobs in the 21st century, and an important skill to have both in the workplace and at home, be you managing your home budget, or creating complex models at work. Throughout our short two hour courses, available in both beginner and advanced, you will learn the basics of spreadsheets, how to use your choice of spreadsheet program, introduction to the programs, formatting cells, adding in pictures and graphs, complex formulae and much more. 

Combining lectures with practical work so you have the opportunity to apply what you have learned.

Beginner

Lesson 1 - Excel Layout and Introduction

Lesson 2 - Formatting Spreadsheets And Cells

Lesson 3 - Sorting, Formula And Functions

Lesson 4 - Charts and Printing

Lesson 5 - Practice Tasks

Lesson 6 - Reflection

Advanced

Lesson 1 - Spreadsheets Recap

Lesson 2 - Advanced Formulas and Functions

Lesson 3 - Vlookup

Lesson 4 - Pivot Tables

Lesson 5 - Multiple Worksheets and Graphs

Lesson 6 - Practice Task

Lesson 7 - Reflection

excel logo
Excel Beginner and Advanced

Course Length: 2 Hours

Beginner Course:

Learn to use Spreadsheets:

  • Enter text and numbers
  • Save spreadsheets and workbooks
  • Enter formula (BODMAS)
  • Make changes to data
  • Add, delete and resize cells
  • Copy data and formula
  • Sort data
  • Format numbers
  • View and print formula.
  • Includes exercises so you can practice what you have learnt.

Advanced Course:

Using Microsoft Excel you will construct a complex spreadsheet from scratch using:

  • Advanced formula and functions including - Count, CountIF, CountA
  • Understand and use Vlookup
  • Introduce Pivot tables
  • Use multiple worksheets in a spreadsheet workbook
  • And graphs.
  • Includes exercises so you can practice what you have learnt.

Check Out Some Of Our Programmes

Featuring This Course

Featuring This Course

The Beginner IT Programme

The Beginner IT Programme is the all in one programme to help you get started with computers. Helping you to learn the basics of internet and email, word processing, spreadsheets and presentations. This programme takes you step-by-step through the whole process.

Find Out More

The Advanced IT Programme

The Advanced IT Programme is the all in one programme to help you take your computer skills to the next level. Helping you to learn advanced techniques with Microsoft Work, Excel and PowerPoint. This programme takes you step-by-step through the whole process.

Find Out More

The Business Start-Up Programme

The Business Start-up Programme is the all in one programme to help you start your own business. Helping you with your business plan, registering your business, keeping records and more. This programme takes you step-by-step through the whole process.

Find Out More