Multiple Dates

Excel Level 2 (Intermediate) - For BDOD staff only (NPT)

Event Information

Share this event

Date and Time

Location

Location

Computer Training Room 3

Newport

United Kingdom

Event description

Description

THIS IS AN ONS EVENT FOR BDOD STAFF ONLY


Following the digital capability assessment carried out back in January, we are now able to offer digital workshops. This workshop forms part of the My Digital Learning Commitment (MDLC). We are committed to supporting an increase in digitial capability across BDOD.


This Excel Level 2 (Intermediate) workshop is aimed at staff who already have a basic understanding of Excel functionality but would like to increase their knowledge and move up a level.

What will be covered?

Create simple formulae

Understand cell error messages

Relative referencing

Absolute referencing

Create formulae that use functions: Sum, Count, Average, Min,, Max

Linking spreadsheets and creating a control panel

Functions: COUNTA, COUNTIF, IF, VLOOKUP, HLOOKUP,

Name range techniques – relating to Cell referencing, navigation and cell range control
Understanding syntax – relating to functions

Sumif, sumifs, And, Or, Today etc – most used functions

Data bar – visual aid

Please refer to the original Digital Workshop email sent by Tracy Davies which contains a word document for this workshop detailing all aspects of the course.


If you have any accessibility requirements, or any queries regarding this event, please contact staff.development.team@ons.gov.uk or call 01329447095
This event was created by; BDOD Staff Development Team

Location

Computer Training Room 3

Newport

United Kingdom

Save This Event

Event Saved