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

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

Date and Time

Location

Computer Training Room 3

Newport

United Kingdom

Save This Event

Event Saved