Excel Skills for Work

Course content

1. Format data within a worksheet including conditional formatting
2. Creating column and pie charts in Excel
3. Insert formulas and absolute referencing
4. Create and use drop down lists
5. Sort and organise data and use Pivot Tables

Description

From budgeting to complex calculations Excel can help at work in many different ways.

This course will focus on how you can use its different functions to support you in your role. We’ll specifically look at pivot tables, shortcuts, keys, calculations and formatting.

This course is perfect for anyone frequently using Excel at work.

Course content:

This course will focus on how you can use its different functions to support you in your role. We’ll specifically look at how to format data in Excel, sort and filter data using Pivot tables and drop down fields, use shortcut keys, create charts and work with functions and formulas.

This course is perfect for anyone frequently using Excel at work.

Requirements

Learners need to be confident finding their way around Windows and have a basic understanding of using MS Excel.

What do I need to do this course?

Pen and paper or note book (not essential)

Teaching Methods

Mix of tutor input; individual practical tasks; group discussions; computer and online practical tasks, smart board demonstrations

How is your progress checked?
Hand-outs/practical tasks and informal observation during sessions.
Extra study or practice required at home.
Not essential but would be advantageous to practise between lessons with resources given to you to keep your skill level up.

What can I do after this course?
IT / Digital Skills Courses leading to Entry level 3 or a L1 qualification