Search for Learning and Development Services and Pathways

Course Type
42 courses found

Code: ESC/20/697 LCS/EHM (Liquid Logic Children’s) Search and View

LCS Search and View is a half day of training for East Sussex County Council users to familiarise themselves with the Children’s Liquid Logic platform. This course is designed to show you how to navigate Liquid Logic, find clients and view case data and includes viewing scanned images held within ECaseFile. 

This course is for anyone joining an ESCC team that uses LCS or EHM whether to view client data or input data into the system. 

As a new staff member your manager must request that a Liquid Logic account is created for you before attending this course. When the account is created you will receive an e-mail invitation to book onto this course. Existing users are welcome to book if they wish to refresh their skills. 

You must complete this training in order to be able to access the LIVE system. The trainer will activate your account on attendance.

Essential Information
Session Session Date Session Time Session Venue Map
1 28 January 2021 09:30 - 12:30 Remote Corporate Training Map

Code: ESC/21/38 Excel 365 Level 2 Functions 1

Delegates' email addresses as registered on the portal will be provided to the trainer for the purpose of conducting this training only.

Delegates should ensure that their work (not personal) email addresses are recorded - check and update as necessary through 'My Profile and Bookings/Change Contact Details'.


The training is expected to be delivered through Microsoft Teams.

Is this course for you?


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.
This course includes topics from the Excel Performing Calculations and the Excel Advanced Calculations courses

 

Essential Information
Session Session Date Session Time Session Venue Map
1 04 February 2021 10:00 - 11:30 Remote Corporate Training Map

Code: ESC/21/23 Microsoft Excel 2010: Advanced Calculations (Cancelled)

This course is for you if you can perform calculations in Excel using formulas and simple functions and now want to use some of Excel’s more advanced calculation features.

Essential Information
Session Session Date Session Time Session Venue Map
1 04 February 2021 13:30 - 16:30 East Sussex Training & Development Centre (St Mary's House) Map

Code: ESC/21/21 Microsoft Excel 2010: Performing Calculations Level 2 (Cancelled)

 This course is for you if you currently enter data on worksheets, but want to be able to perform calculations using Excel’s formulas and functions.

Essential Information
Session Session Date Session Time Session Venue Map
1 04 February 2021 09:30 - 12:30 East Sussex Training & Development Centre (St Mary's House) Map

Code: ESC/21/39 Excel 365 Level 2 Presenting Information

Please note - this is a "remote" session, and if applying, you should note the additional information in "full details" regarding joining the session.

Is this course for you?

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.
This course includes topics from the Excel Presenting Information course

Pre-requisites

The course assumes that delegates are familiar with: entering data and simple formulas in Excel.
To take part in this course, delegates will need an internet-connected device with camera and microphone, and an internet connection which can stream video in reasonable quality.

Essential Information
Session Session Date Session Time Session Venue Map
1 10 February 2021 10:00 - 11:30 Remote Corporate Training Map

Code: ESC/21/22 Microsoft OneNote (Cancelled)

This course is for you if you want to be able to create electronic notebooks to store and organise notes you collect from the web or other documents in your filing system. You can use a Notebook to plan a project, assemble research resources for a report you are writing, or just to store ideas and information you would normally jot down on paper. Notebooks can be shared with others, allowing you to easily collaborate on projects.

Essential Information
Session Session Date Session Time Session Venue Map
1 11 February 2021 09:30 - 12:30 East Sussex Training & Development Centre (St Mary's House) Map

Code: ESC/21/40 Excel 365: Analysing Data

This course is for you if you use Excel to store tables of data and want to extract information and produce reports from that data.

Essential Information
Session Session Date Session Time Session Venue Map
1 16 February 2021 10:00 - 12:30 Remote Corporate Training Map

Code: ESC/21/20 Microsoft Excel 2010: Analysing Data (Cancelled)

This course is for you if you use Excel to store tables of data and want to extract information and produce reports from that data.

Essential Information
Session Session Date Session Time Session Venue Map
1 03 March 2021 09:30 - 12:30 East Sussex Training & Development Centre (St Mary's House) Map

Code: ESC/21/25 Microsoft Excel 365 Level 4; Advanced Data Handling and Analysis (Cancelled)

Do you handle large amounts of data in the course of your work?

Do you spend a lot of time cleaning up data and preparing it for analysis?

Do you need to combine data from different data sets?

This new course covers two major Excel 365 tools which should make your job easier– Power Query and Power Pivot.

The course is for you if you are familiar with the topics covered in the Excel Analysing Data course, in particular creating and manipulating Pivot Tables, and can create worksheet formulas and use Excel functions such as IF and VLOOKUP

Essential Information
Session Session Date Session Time Session Venue Map
1 03 March 2021 13:30 - 16:30 East Sussex Training & Development Centre (St Mary's House) Map

Code: ESC/21/41 Excel 365 Level 3 Power Query and the Data Model

Please note - this is a "remote" session, and if applying, you should note the additional information in "full details" regarding joining the session.

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

Pre-requisites
The course assumes that delegates are familiar with: creating Pivot Tables in Excel.


To take part in this course, delegates will need an internet-connected device with camera and microphone, and an internet connection which can stream video in reasonable quality.

Essential Information
Session Session Date Session Time Session Venue Map
1 09 March 2021 10:00 - 11:30 Remote Corporate Training Map