1. Home
  2. Jobs
  3. Learning Portal
  4. Corporate Training
  5. ICT, Digital and Web & intranet skills

ICT, Digital and Web & intranet skills

Microsoft (except Excel)

Outlook 365 Level 2 Work Smarter with Outlook 365

Course details
Contact corporate.training@eastsussex.gov.uk
Target audience All users
Subject  ICT & Digital Skills
Course description Is this course for you? You are familiar with sending and receiving emails, using Outlook or another program. You want to explore some of the new features in Outlook 365 and find more effective ways of using the software.
Training objectives At the end of the course, you will be able to use Outlook to manage your mail more effectively. You will know how to: organise and file messages; speed up routine processes; work with appointments and meetings; create tasks to be done and assign them to others. A handout covering the main course topics will be provided.
Learning outcomes New features in Outlook 365
  • Switch between Simplified and Classic Ribbon
  • Pin buttons to the Simplified Ribbon
  • Use Quick Peeks
  • Use Focused Inbox
  • Work with attachments
  • Send links to SharePoint/OneDrive files
  • Use @Mentions in emails
Manage messages
  • Assign a category to a message
  • Flag a message for later attention
  • Re-send a message
  • Search for messages
Automating mail handling
  • Create a Quick Step
Contacts
  • Create a contact
  • Create a Contact Group
The Outlook 365 Calendar
  • Select a date or dates to display
  • Change the calendar view
  • Create an appointment
  • Move or copy an appointment
Organise meetings with Outlook
  • Schedule a meeting
  • Deal with meeting invitations
Share calendars
  • Change calendar permissions
  • Overlay calendars
Use tasks in Outlook
  • Create a task
  • Assign a task to a colleague
Additional information
Maximum places 10
Closing date 1 day ahead of the training
Cost £80 face to face/ £60 remote
Number of sessions 1
Course dates, venue and times
Please make a note of the course code and date, you will need this to book.
Course code Venue Course dates Time
Go to booking form

To cancel a course booking, please use the Learning Portal - cancellation form.

Work Smarter with Office and Windows 365

Course details
Contact corporate.training@eastsussex.gov.uk
Target audience All users
Subject  ICT & Digital Skills
Course description Is this course for you? You have been upgraded to Office 365 and Windows 10 and want to use some of the new facilities and keyboard shortcuts to work more effectively. This course is delivered as a demonstration. The course is currently only available online.
Training objectives At the end of the course, you will be familiar with some of the new features in Windows, including taskbar buttons and Jump Lists. You will be able to use time-saving techniques to perform routine tasks in Word, Excel and Outlook and be able to collaborate remotely with other users on documents. A handout covering the main course topics will be provided.
Learning outcomes Save time with Windows
    • Search for programs on the Start button
    • Add a program button to the Task Bar
    • Access a program’s Jump List
    • Dock program windows on the screen
    • View recent documents with File Explorer
    • Use Windows key shortcuts
    • Take a screen grab and mark it up
Microsoft Edge
    • Use the Immersive Reader on web pages
Work with Word
    • Use the new Search box
    • Use keyboard shortcuts to move around and select text
    • Save frequently-used text and graphics as AutoText and Quick Parts
Work with Excel
    • AutoFill numbers and dates
    • Use Flash Fill to extract data
Collaborate with others
    • Share an Office document with multiple users
    • Add comments, replies and @mentions
Work with Outlook
    • Switch between Simplified and Classic Ribbon
    • Pin buttons to the Simplified Ribbon
    • Work with Focused Inbox
    • Use @Mentions in emails
    • Attach a link to a SharePoint or OneDrive document rather than a copy of the file
    • Sort mail folders
Additional information
Maximum places 10
Closing date 1 day ahead of the training
Cost £80 face to face and £60 remote
Number of sessions 1
Course dates, venue and times
Please make a note of the course code and date, you will need this to book.
Course code Venue Course dates Time
ESC/23/41 Delivered remotely via MS Teams 7 March 2023 10:00 - 11:30
Go to booking form

To cancel a course booking, please use the Learning Portal - cancellation form.

Word 365 level 2 Work with Longer Documents

Course details
Contact corporate.training@eastsussex.gov.uk
Target audience All users
Subject  ICT & Digital Skills
Course description Is this course for you? You need to create longer documents and ensure that they are easy and convenient to read online and accessible to people with disabilities.
Training objectives At the end of the course, you will be able to create longer documents, setting up styles to ensure consistent formatting. You will know how to add links leading readers to information elsewhere in your document or on the web. You will be aware of accessibility issues you need to consider when preparing a document for online viewing

A handout covering the main course topics will be provided.
Learning outcomes Create and use Styles to format text
  • What are styles?
  • Apply a style from the Quick Style gallery
  • Understand the importance of Heading styles
  • Modify a style
  • Create a new style
  • Add a style to the Quick Style gallery
  • Save styles as a Style set
  • Save formatting and content in a template
Work with document sections
  • Add a section break
  • Turn one page of a document to landscape
Add links to documents
  • Insert a hyperlink
  • Create a cross reference to another page
  • Update cross references
Create a Table of Contents (ToC)
  • Add a ToC to a document
  • Update the ToC
Create accessible documents
  • Issues to consider when creating documents for online viewing
Additional information
Maximum places 11
Closing date 1 day ahead of the training
Cost £80
Number of sessions 1
Course dates, venue and times
Please make a note of the course code and date, you will need this to book.
Course code Venue Course dates Time
ESC/23/40 ESTDC St Mary's House, Eastbourne 1 March 2023 09:30 - 12:30
Go to booking form

To cancel a course booking, please use the Learning Portal - cancellation form.

Word 365 Level 3 Collaborate on documents

Course details
Contact corporate.training@eastsussex.gov.uk
Target audience All users
Subject ICT & Digital Skills
Course description You will learn how to collaborate on documents with others and look for more effective ways of working together
Training objectives At the end of the course, you will be able to use Track Changes to deal with edits that others have made to your documents. You will know how to protect a document so that only certain areas can be edited, how to add document content using Fields and Quick Parts and how to invite others to collaborate on an open document. A handout covering the main course topics will be provided.
Learning outcomes Track changes in a document
  • Turn on Track Changes
  • Lock Track Changes on
  • Work in a tracked document
  • Switch between views of a tracked document
  • Accept and reject changes
Compare two versions of a document
  • Use Compare to see how two versions of a document differ
  • Merge multiple versions of a document together
Prepare a document for publication
  • Run the Document Inspector
  • Check accessibility issues
  • Rollback to a previous version of a SharePoint/OneDrive document
Protect a document
  • Mark a document as Final
  • Restrict editing in particular areas of a document
  • Encrypt a document with a password
Use Quick Parts
  • Create an AutoText entry
  • Use AutoText in a document
  • Understand Building Blocks
  • Create a Quick Table
  • Use the Building Block Manager
Work with fields
  • Understand fields in Word
  • Insert a field in a document
  • Toggle field codes
  • Update fields
Work together
  • Invite others to collaborate on an open SharePoint/OneDrive document
  • Add and respond to comments
Additional information
Maximum places 11
Closing date 1 day ahead of the training
Cost £80
Number of sessions 1
Course dates, venue and times
Please make a note of the course code and date, you will need this to book.
Course code Venue Course dates Time
ESC/23/45 ESTDC St Mary's House, Eastbourne 29 March 2023 09:30 - 12:30
Go to booking form

To cancel a course booking, please use the Learning Portal - cancellation form.

Word 365 Level 2 Laying out documents

Course details
Contact corporate.training@eastsussex.gov.uk
Target audience All users
Subject  ICT & Digital Skills
Course description Is this course for you? You are familiar with creating, editing and saving simple documents using Microsoft Word and now want to improve layout of your documents using tables, bullets, borders and paragraph formatting.
Training objectives At the end of the course, you will be able to layout information in Word in more creative and appealing ways. Your documents will be easier to read and understand. Among the techniques you’ll learn about are using paragraph formatting to change text layout and spacing, using bullets and numbering, and adding borders and shading to text for emphasis. You will also learn how to present information using a table and how to layout and format the table for best results. A handout covering the main course topics will be provided.
Learning outcomes Get started
Convert old format documents
Turn on non-printing characters
Add buttons to the Quick Access Toolbar
Format paragraphs
Understand margins and indents
Change paragraph indents
Add an extra indent to the first line of a paragraph
Add spacing before and after paragraphs
Use borders and shading for emphasis
Add borders to a paragraph
Change the style of paragraph borders
Turn parts of the border off
Add shading to a paragraph
Use bullets
Add bullets to a list
Adjust how bulleted lists are indented
Number a list
Number items in a list
Restart and stop numbering
Change numbering format
Create Outline Numbered lists
Apply outline numbering
Change numbering level
Present information in a table
Create a table in a document
Add data
Change table layout
Insert and delete rows and columns
Change cell height and width
Add borders and shading
Repeat table headings over several pages
Additional information
Maximum places 8
Closing date 1 day ahead of the training
Cost £80
Number of sessions 1
Course dates, venue and times
Please make a note of the course code and date, you will need this to book.
Course code Venue Course dates Time
Go to booking form

To cancel a course booking, please use the Learning Portal - cancellation form.

OneNote

Course details
Contact corporate.training@eastsussex.gov.uk
Target audience All users
Subject ICT & Digital Skills
Course description Is this course for you?
You want to create an electronic Notebook to store and organise notes you create or collect from the web, or from other documents in your filing system 
You may wish to share your Notebook with others so you can collaborate on a project, or easily share information.
This course uses material from the OneNote classroom-based course
Training objectives At the end of the course, you will know how to create and share Notebooks. You will be able to add content from a variety of sources. You will know how to manage, organise and search your Notebook content, and be able to set up a shared notebook to collaborate with others.
Learning outcomes Create a Notebook
    • Choose a location for your Notebook
    • Create a page
    • Enter and format text

Organise a notebook
    • Create sections
    • Move and delete pages

Format pages
    • Change the page colour and add ruled lines
    • Change paper size of a page

Add content
    • Insert pictures
    • Copy and paste material
    • Add a screenshot
    • Attach a file
    • Insert a hyperlink

Work with Outlook
    • Import details from Outlook objects
    • Create a linked Outlook task
    • E-mail a OneNote page

Recover material
    • Restore a deleted page

Share a Notebook
    • Invite others to a shared Notebook
    • View changes made by others
Additional information
Maximum places 11
Closing date 1 day ahead of the start date
Cost £80
Number of sessions 1
Course dates, venue and times
Please make a note of the course code and date, you will need this to book.
Course code Venue Course dates Time
ESC/23/35 ESTDC St. Mary's House, Eastbourne 2 March 2023 09:30 - 12:30
Go to booking form

To cancel a course booking, please use the Learning Portal - cancellation form.


Excel 365

Excel 365 Foundation

Course details
Contact corporate.training@eastsussex.gov.uk
Target audience All users
Subject ICT & Digital Skills
Course description Is this course for you? You are new to Excel or want to find out more about basic techniques such as data entry, formatting, entering simple formulas and printing.
Training objectives At the end of the course, you will be able to create, save and print workbooks in Excel 365. You will know how to enter, edit, and format data and perform simple calculations. You will be able to set up a worksheet to store data and use sort and filter on data tables. A handout covering the main course topics will be provided.
Learning outcomes Find your way round Excel 365
  • The Excel screen
  • Using the Ribbon
  • Open, save and print workbooks
Getting help
  • Using Excel Help
Creating a workbook
  • Create a table of data on a worksheet
  • Enter and edit data
Formatting data
  • Adjust column widths
  • Select cells
  • Format data using the Ribbon
  • Use Format Cells
Manage worksheets
  • Insert and delete rows and columns
  • Insert and delete worksheets
  • Re-arrange worksheets in a book
Perform calculations
  • Add up a column of figures with AutoSum
  • Enter formulas to carry out simple calculations
  • Use AutoFill to copy formulas
  • Use AutoFill to speed data entry
Work with tables of data
  • Check your data follows the rules
  • Sort and filter data
Cut, copy and paste Excel data
  • Paste formulas
  • Use Paste Options to paste values
Print worksheets
  • Prepare a document for printing
  • Add table titles at the top of each page
  • Add headers and footers
  • Print a worksheet
Collaborate with others
  • Invite others to work on a SharePoint/One Drive document
  • Add comments and @Mentions
Additional information
Maximum places 11
Closing date 1 day ahead of the start date
Cost £160 
Number of sessions 1
Course dates, venue and times
Please make a note of the course code and date, you will need this to book.
Course code Venue Course dates Time
Go to booking form

To cancel a course booking, please use the Learning Portal - cancellation form.

Excel 365 Level 2 Functions 1

Course details
Contact corporate.training@eastsussex.gov.uk
Target audience All users
Subject ICT, Digital and Web and intranet skills
Course description You can enter simple formulas in a workbook, and wish to extend your skills using functions to perform tasks such as: finding the average of a set of data; counting data entries which match specified conditions; looking up data entries in a table.
Training objectives At the end of the course, you will be able to use Excel functions including AVERAGE, COUNTIFS and VLOOKUP. You will also know how to search for a function to perform a particular task, and be able to use the help available in Excel to complete a function's arguments.
Learning outcomes
Additional information
Maximum places 10
Closing date One day before course date
Cost £60 (90 minutes online) £80 (3 hour face to face sessions)
Number of sessions 1
Course dates, venue and times
Please make a note of the course code and date, you will need this to book.
Course code Venue Course dates Time
ESC/23/37 ESTDC (St Mary's House, Eastbourne) 8 February 2023 09:30 - 12:30
Go to booking form

To cancel a course booking, please use the Learning Portal - cancellation form.

Excel 365 Level 2 Presenting Information

Course details
Contact corporate.training@eastsussex.gov.uk
Target audience All users
Subject ICT, Digital and Web and intranet skills
Course description You are familiar with basic Excel techniques, such as entering data, writing simple formulas, and applying basic formatting. You now want to find different ways of presenting your data, so it is effective and eye-catching.
Training objectives At the end of the course, you will be able to apply conditional formatting to data, making cells change colour depending on their values. You will understand Excel theme colours and know how to add and format icons on a worksheet. You will be able to create a chart and apply formatting to it in order to present your information effectively.
Learning outcomes You will be able to work with; Theme Colours: Icons; Conditional Formatting; Excel Charts
Additional information
Maximum places 12
Closing date One day before course start date
Cost £60 (90 minute online session), £80 (3 hour face to face session)
Number of sessions 1
Course dates, venue and times
Please make a note of the course code and date, you will need this to book.
Course code Venue Course dates Time
ESC/23/36 Delivered remotely via MS Teams 7 February 2023 10:00 - 11:30
Go to booking form

To cancel a course booking, please use the Learning Portal - cancellation form.

Excel 365 Level 2 Performing Calculations

Course details
Contact corporate.training@eastsussex.gov.uk
Target audience
All users
Subject ICT & Digital Skills
Course description Is this course for you? You are familiar with basic Excel techniques, including entering and editing data, saving and printing workbooks. You wish to start using and editing formulas to perform calculations in your workbook.
Training objectives At the end of the course, you will:
  • be able to enter worksheet formulas using the three basic calculation tools in Excel.
  • also understand when to use brackets, when you need to lock cells and be able to enter formulas using dates.
  • be able to write formulas which use data on other worksheets and in other workbooks.
Learning outcomes Create a formula
  • Enter a formula starting with =
  • Build a formula using the operators +,-,* and /
  • Understand BODMAS
  • Use brackets in more complex formulas
AutoSum
  • Add up rows or columns of data with AutoSum
  • Edit the formula to change data being added
  • Check formula results with AutoCalculate
AutoFill
  • Understand how AutoFill works
  • Copy formulas to other cells by dragging
Absolute cell references
  • Understand why dragging formulas might not work
  • Use Absolute Cell references to fix formula problems
Name cells
  • Assign a name to a cell or a range
  • Use names in formulas
  • Edit names
Work with multiple sheets
  • Create a summary sheet using data from other worksheets
  • Use data from another workbook in a formula
Work with dates
  • Understand how Excel stores dates
  • Calculate days between two dates
Work with text
  • Use Flash Fill to extract and join text
Additional information
Maximum places 10
Closing date 1 day ahead of the start date
Cost Face to Face training £80 / Remote £60 
Number of sessions 1
Course dates, venue and times
Please make a note of the course code and date, you will need this to book.
Course code Venue Course dates Time
Go to booking form

To cancel a course booking, please use the Learning Portal - cancellation form.

Excel 365 Level 3 Functions 2

Course details
Contact corporate.training@eastsussex.gov.uk
Target audience All users
Subject ICT, Digital and Web and intranet skills
Course description We want to broaden your knowledge of Excel functions. As well as IF, this course covers functions which are new in this version of Excel, including IFS and XLOOKUP (a superior version of VLOOKUP), and dynamic arrays, which mark the biggest change to Excel formulas in 30 years.
Training objectives At the end of the course, you will be able to use XLOOKUP to perform lookups in tables of data, and IF and IFS to take decisions depending on data values. You will also be able to enter and edit Spill formulas and use the FILTER, UNIQUE and SORT functions to build dynamic arrays.
Learning outcomes Compatibility issues
  • Publish Excel worksheets as pdf
Take decisions with IF and IFS
  • Construct a logical test
  • Write a formula using the IF function
  • Combine multiple tests with IFS
Use Tables in formulas
  • Create a Table from a set of data
  • Build a formula using Table data
Look up data with XLOOKUP
  • Advantages of XLOOKUP over VLOOKUP
  • Write formulas using XLOOKUP
Spill formulas
  • Understand spill formulas
  • Return multiple answers from one formula
  • Deal with the #SPILL! error
FILTER
  • Use the FILTER function to extract data matching a condition
SORT
  • Generate a dynamic sorted list from a data table
UNIQUE
  • Generate a dynamic list of unique values from a data table
Nest functions
  • Use one function as an argument in a second function
Additional information
Maximum places 11
Closing date One day before course start date
Cost £60 (90 minute remotely delivered session), £80 (3 hour face to face session)
Number of sessions 1
Course dates, venue and times
Please make a note of the course code and date, you will need this to book.
Course code Venue Course dates Time
ESC/23/42 ESTDC St.Mary's House, Eastbourne 9 March 2023 09:30 - 12:30
Go to booking form

To cancel a course booking, please use the Learning Portal - cancellation form.

Excel 365 Level 4 Macros I

Course details
Contact corporate.training@eastsussex.gov.uk
Target audience All users
Subject ICT & Digital Skills
Course description Is this course for you? You are familiar with entering formulas and analysing data in Excel and want to write code to automate Excel tasks such as formatting a report and perform operations which can't be done using conventional Excel commands.
Training objectives The course covers recording, writing and editing macros. By the end of the course:
  • you will be familiar with the VBA Editor and will be able to record a macro or create a macro in the code window.
  • you will know how to use variables, how to display messages and ask for simple user input, and how to use IF to decide which lines of code to run.
Learning outcomes Introducing macros
  • Why use macros?
  • Check macro security settings
  • Save a file containing macros
The VBA Editor
  • Switch between VBA and Excel
  • Work with the VBA windows
  • Understand Object Oriented code
Create a macro
  • Create a macro in the code window
  • Use the Macro Recorder
  • Run a macro
  • Run a macro one line at a time
  • Test code in the Immediate window
Write and edit code
  • Understand methods and properties
  • Get help building code
  • Use Intellisense to complete code
  • Set parameters to control behaviour
Work with VBA variables
  • Understand data types
  • Declare a variable
  • Work with date variables
  • Force variable declaration in a module
  • Use an object variable
Interact with users
  • Display information in a Message Box
  • Use InputBox to ask user for data
Branching code
  • Use IF...THEN to determine code to run
  • Use IF to validate user input
Work with cell ranges
  • Define cell ranges
  • Select the last used cell in a column
Work with formulas
  • Use VBA to add a formula to a worksheet cell
Additional information
Maximum places 11
Closing date 1 day ahead of the start date
Cost £160
Number of sessions 1
Course dates, venue and times
Please make a note of the course code and date, you will need this to book.
Course code Venue Course dates Time
ESC/23/39 ESTDC St. Mary's House, Eastbourne 21 February 2023  09:30 - 16:30
Go to booking form

To cancel a course booking, please use the Learning Portal - cancellation form.

Excel 365 Level 4 Macros II

Course details
Contact
Target audience All users
Subject ICT & Digital Skills 
Course description You are familiar with the topics covered in the Macros I course and want to further develop your coding skills in Excel
Training objectives This course builds on the skills learnt in the Macros I course. By the end of the session, you will know how to develop more complex macros, how to open and close files and how to loop through sections of code repeatedly until a condition is met. You will be able to handle errors that occur when your code is running, write your own functions to use in worksheet formulas and program Excel to respond to events such as right-clicking on a worksheet.
Learning outcomes Develop a macro
  • Create a flow chart
  • Consider assumptions in your code
  • Test a macro
File handling with code
  • Write code to open a workbook
  • Use the Open File dialog box
  • Create a workbook
  • Close a workbook
Build loops in code
  • Understand the different types of loop
  • Code a loop to repeat code a specified number of times
  • Run code on each worksheet in a workbook
  • Loop through code until a condition is met
Handle errors
  • Ignore errors when your code is running
  • Use an error handler to deal with errors
  • Clear error codes
User-defined functions (UDFs)
  • Understand the limitations of UDFs
  • Create a UDF
  • Specify arguments for the UDF
  • Use a UDF in a worksheet formula
Event procedures
  • Understand workbook events
  • Create code to run automatically when a particular event occurs
  • Limitations of procedures
  • Stop Excel responding to events
Make a macro more user-friendly
  • Use buttons and icons in message boxes
  • Stop screen flicker when a macro runs
Additional information A handout covering the main course topics will be provided.
Maximum places 6
Closing date 1 day ahead of the closing date
Cost £160.00
Number of sessions 1
Course dates, venue and times
Please make a note of the course code and date, you will need this to book.
Course code Venue Course dates Time
ESC/23/44 ESTDC St. Mary's House, Eastbourne  22 March 2023 09:30 - 16:30
Go to booking form

To cancel a course booking, please use the Learning Portal - cancellation form.

Excel 365 Tables and Pivot Tables

Course details
Contact corporate.training@eastsussex.gov.uk
Target audience
All users
Subject ICT & Digital Skills
Course description Is this course for you?
You work with tables of data which you need to summarise and analyse.
Training objectives At the end of the course, you will be able to create an Excel Table, change its formatting and create a formula using Table data. You will know how to create Pivot Tables, change the analysis a Pivot Table performs and present the data in a Pivot Chart
Learning outcomes Work with tables of data
  • Understand rules for storing data
  • Analyse data with Quick Analysis
  • Freeze panes
Excel Tables
  • Create an Excel Table
  • Use data from a Table in a formula
Analyse data with Pivot Tables
  • Create a Pivot Table
  • Re-pivot the table, using different fields
  • Sort a Pivot Table
  • Drill down to see underlying data
  • Refresh a Pivot Table
Filter data
  • Use a Slicer to filter data
  • Use the Filters box to apply a filter
  • Check what filters are applied to a Pivot Table
Change how a Pivot Table analyses data
  • Summarise data in different ways
  • Present results as percentages
  • Present data with a Pivot Chart
  • Add a slicer to create an interactive chart
Additional information
Maximum places 11
Closing date 1 day ahead of the start date
Cost £80 face to face / £60 remote
Number of sessions 1
Course dates, venue and times
Please make a note of the course code and date, you will need this to book.
Course code Venue Course dates Time
ESC/23/43 ESTDC St Mary's House, Eastbourne 16 March 2023 09:30 - 12:30
Go to booking form

To cancel a course booking, please use the Learning Portal - cancellation form.

Excel 365 Level 3 Power Query and the Data Model

Course details
Contact corporate.training@eastsussex.gov.uk
Target audience All users
Subject ICT, Digital and Web and intranet skills
Course description Is this course for you? You are familiar with creating simple Pivot Tables from Excel data. You want to find ways of quickly cleaning up and merging data for use in a Pivot Table, or you have data in several different tables which you want to analyse in one Pivot Table. This course includes topics from the Excel Advanced course.
Training objectives At the end of the course, you will:
  • understand the Excel data model. You will be able to import data into Power Query and use tools to clean it up before saving the data in the Data Model.
  • be able to refresh your query when the data changes, and know how to create relationships between data tables, so you can build a Pivot Table using fields from multiple tables.
Learning outcomes The Data Model
  • Advantages of using the Data Model
  • View and edit data in the Model
  • Importance of key fields
Pivot Tables
  • Create a Pivot Table using data in the Data Model
  • Use data from multiple tables
  • Create relationships between tables
Understand Excel data flow
  • See how Excel's data handling and analysis tools fit together
Get and Transform data
  • Import data from different sources
  • Load data into Power Query
Power Query
  • Use Power Query tools to prepare and clean your data
  • Merge data from multiple files in the same folder
  • Load the data into the Excel Data model
  • Refresh a query to automatically process changed data
Build a dashboard
  • Link a slicer to multiple Pivot Tables
Additional information
Maximum places 10
Closing date One day before course start date
Cost £60
Number of sessions 1
Course dates, venue and times
Please make a note of the course code and date, you will need this to book.
Course code Venue Course dates Time
ESC/23/38 Remotely Delivered via MS Teams 14 February 2023 10:00 - 11:30
Go to booking form

To cancel a course booking, please use the Learning Portal - cancellation form.


Web and Intranet skills

Writing for the Web

Course details
Contact corporate.training@eastsussex.gov.uk
Target audience All users
Subject ICT & Digital Skills
Course description Writing for the Web training – standards and conventions for writing online.
Training objectives Staff with responsibility for content on the ESCC Website (internet) and intranet – you will become a web author for your department. You will also have to do the Website & Intranet CMS Training. Although not essential for becoming a web author, you may also be interested in the 'Publishing Accessible Documents' training.
Learning outcomes By the end of this course delegates will be able to:
  • understand the differences in writing for print and screen
  • consider the needs of busy online readers and what they need to know
  • learn how to write effective headlines and summary links
  • be able to break down content visually on a screen
  • be able to improve readability through design, layout and typography
  • write clearly and avoid bureaucratic jargon
  • know how to use hyper linking to avoid lengthy pages
  • encourage reader feedback and interaction
  • be able to repurpose content from other sources and avoiding downloadable documents
  • consider aspects of accessibility
  • understand the importance of protecting the corporate brand; discuss tone of voice and verbal branding issues
  • be able to maintain web communication standards and quality control
Additional information If you are in Adult Social Care and require funding for this course please contact sara.lewis@eastsussex.gov.uk
Maximum places 11
Closing date 1 day ahead of the start date
Cost Face to Face £80 / Remote £60
Number of sessions 1
Course dates, venue and times
Please make a note of the course code and date, you will need this to book.
Course code Venue Course dates Time
ESC/23/84 Remotely delivered via MS Teams 20 April 2023 10:00 - 12:00
ESC/23/87 Remotely delivered via MS Teams 1 June 2023 10:00 - 12:00
Go to booking form

To cancel a course booking, please use the Learning Portal - cancellation form.

Website & Intranet CMS Training

Course details
Contact corporate.training@eastsussex.gov.uk
Target audience All users
Subject ICT & Digital Skills
Course description This short course gives a general introduction on using our content management system (CMS) Umbraco to update East Sussex County Council's external, public-facing website for residents and businesses: www.eastsussex.gov.uk It also covers some features on the staff intranet. You will also have to complete the Writing for the Web Training
Training objectives This course is for staff with responsibility for content on the ESCC corporate Website or intranet. You will become a web author for your department. The course itself focuses on the ESCC website, but the same system and templates are used for the intranet. It covers:
  • difference between public website and back office
  • edit existing content in a ‘topic’ page
  • create a new ‘task’ page
  • add a document and link to it
  • add links to other pages and websites
  • how to add ‘latest’ news and social media to a page
Learning outcomes By the end of this course, you will be able to:
  • understand the key difference between public and back-office sites
  • understand the basic structure of the public facing site
  • edit existing content
  • create new pages using at least 3 templates
  • replace documents currently on the site
  • amend & add metadata & page properties
  • understand and use links and headings in web content
  • follow ESCC style guidelines and conventions
  • understand ESCC content principles
  There is follow-up online training showing you how to create other types of website pages, as well as separate guidance for Czone web authors.
Additional information Please note: Adult Social Care web authors only update the website.  To update ASC intranet content please email ASC Staff Info Guidance If you manage Czone please email czone@eastsussex.gov.uk
Maximum places 10
Closing date 1 day ahead of the start date
Cost Face to face £80 / Remote £60 
Number of sessions 1
Course dates, venue and times
Please make a note of the course code and date, you will need this to book.
Course code Venue Course dates Time
ESC/23/85 Remotely delivered via MS Teams 26 April 2023 10:00 - 12:00
ESC/23/88 Remotely delivered via MS Teams 6 June 2023 10:00 - 12:00
Go to booking form

To cancel a course booking, please use the Learning Portal - cancellation form.


Publishing accessible documents

Course details
Contact corporate.training@eastsussex.gov.uk
Target audience All users
Subject ICT, Digital and Web and Intranet skills
Course description Learn how to publish accessible documents to meet the needs of all users under the accessibility regulations.
Training objectives By the end of the session you will understand
• What ‘accessibility’ is and how your content meets user needs
• What your organisation’s Accessible Document Policy is and how to find it
• How to create accessible documents using your organisation’s existing tools
• How to work with existing or inherited PDF documents
Learning outcomes
Additional information On confirmation of your place please view the following pre course video Publishing Accessible Documents - getting the basics right
Maximum places 12
Closing date 1 day ahead of start date
Cost £60
Number of sessions 1
Course dates, venue and times
Please make a note of the course code and date, you will need this to book.
Course code Venue Course dates Time
ESC/22/64 Delivered remotely via MS Teams 22 February 2023 10:00 - 12:00
ESC/23/86 Delivered remotely via MS Teams 27 April 2023 10:00 - 12:00
ESC/23/89 Delivered remotely via MS Teams 22 June 2023 10:00 - 12:00
Go to booking form

To cancel a course booking, please use the Learning Portal - cancellation form.