Free

Multiple Dates

Digital Workshop - Excel Level 3 (Advanced) - 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 3 (Advanced) workshop is aimed at staff who want a challenge and to learn to harness and enhance their current advanced Excel skills.

What will be covered?

  • Linking spreadsheets and creating a control panel

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

  • Creating Pivot Tables

  • Using one-input or two-input data tables/what-if tables

  • Creating Macros to automate commonly used procedures

  • Using Conditional Formatting to highlight cells based on pre-determined criteria

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

Share with friends

Location

Computer Training Room 3

Newport

United Kingdom

Save This Event

Event Saved