Multiple Dates

Digital Workshop Excel Level 1 (Beginners) - 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 1 (Beginners) workshop is aimed at staff who have little or no understanding of Excel functionality.

Basic Orientation
Understanding the purpose of spreadsheets
Introduction to the spreadsheet interface
Navigate through a worksheet
Creating a workbook
Saving a workbook
Cell referencing system
Understand the three types cell content
Understand the cursor types

Manipulating content in a spreadsheet
Entering Text/numbers/formulae
Copy and move cell content
Using a range of fill techniques

Managing Rows and Columns
Changing row heights and column widths using a range of techniques
Adding and removing rows and columns

Formatting Cells
Fonts, cells borders
Align cell content: orientation, text wrapping, centre across columns

Formatting Numbers
Change number formats, including: number types, thousands comma, number of decimal points

Managing Workbooks
Add, remove and hide worksheets
Name and rename worksheets
Move worksheet position
Colour worksheet tabs
Inserting Symbols
Using Find/Replace


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