ICT, Digital and Web & intranet skills

Microsoft (except Excel)

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
ESC/24/054	ESTDC, St Marys House	7th May 2024	09:30-12:30
ESC/24/055	ESTDC, St Marys House	17th Sept 2024	09:30-12:30
ESC/24/056	ESTDC, St Marys House	4th Dec 2024	09:30-12:30
ESC/24/057	ESTDC, St Marys House	13th Feb 2025	09:30-12:30
			Go to booking form

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

Work Smarter with Office365 and Windows 10

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/24/059	Remotely delivered via MS Teams	18 July 2024	13:30 - 15:00
ESC/24/060	Remotely delivered via MS Teams	8 October 2024	10:00 - 11:30
ESC/24/061	Remotely delivered via MS Teams	5 February 2025	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/24/050	Held remotely via MS Teams	20 June 2024	13:30 - 16:30
ESC/24/052	Held remotely via MS Teams	8 October 2024	13:30 - 16:30
ESC/24/053	Held remotely via MS Teams	26 March 2025	13:30 - 16: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
			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
ESC/24/48	Remote Via MS Teams	2nd May 2024	09:30-12:30
ESC/24/49	Remote Via MS Teams	26th Sept 2024	09:30-12:30
ESC/24/50	Remote Via MS Teams	23rd January 2025	09:30-12:30
			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/24/040	ESTDC, St Marys House	27th June 2024	09:30-12:30
ESC/24/041	ESTDC, St Marys House	3rd October 2024	09:30-12:30
ESC/24/042	ESTDC, St Marys House	12th March 2025	09:30-12:30
			Go to booking form

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

Back to top

---

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
ESC/24/016	St Marys House, Eastbourne	17 April 2024	09:30-16:30
ESC/24/017	St Marys House, Eastbourne	2 October 2024	09:30-16:30
ESC/24/018	Remotely delivered via MS Teams	16 July & 23 July 2024	09:30-12:30 (both days)
ESC/24/019	Remotely delivered via MS Teams	4 Feb & 11 Feb 2025	09:30-12:30 (both days)
			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 hours online)
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/24/022	Remotely delivered via MS Teams	20 June 2024	09:30 - 12:30
ESC/24/023	Remotely delivered via MS Teams	10 October 2024	09:30 - 12:30
ESC/24/024	Remotely delivered via MS Teams	11 March 2025	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	£80 (3 hour remote session via MS Teams)
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/24/034	Held remotely via MS Teams	8 May 2024	9:30-12:30
ESC/24/035	Held remotely via MS Teams	26 Nov 2024	9:30-12:30
ESC/24/036	Held remotely via MS Teams	28 Jan 2025	9:30-12: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	£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/24/032	Remotely delivered via MS Teams	14 May 2024	09:30 - 12:30
ESC/24/033	Remotely delivered via MS Teams	11 September 2024	09:30 - 12:30
			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 both face to face and MS remote 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/24/025	Remotely delivered via MS Teams	10 July 2024	09:30 - 12:30
ESC/24/026	Remotely delivered via MS Teams	20 November 2024	09:30 - 12:30
ESC/24/027	Remotely delivered via MS Teams	26 March 2025	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/24/028	ESTDC, St. Marys House	23 May 2024	09:30 - 16:30
ESC/24/029	ESTDC, St. Marys House	21 January 2025	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	corporate.training@eastsussex.gov.uk
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/24/030	ESTDC, St. Marys House	17 July 2024	09:30 - 16:30
ESC/24/031	ESTDC, St. Marys House	25 February 2025	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	£60 (90 minute remotely delivered session), £80 (3 hour both face to face and MS remote 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/24/037	Remotely delivered via MS Teams	26 June 2024	09:30-12:30
ESC/24/038	Remotely delivered via MS Teams	15 Oct 2024	09:30-12:30
ESC/24/039	Remotely delivered via MS Teams	19 March 2025	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	£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/24/043	Held remotely via MS Teams	18th July 2024	09:30-12:30
ESC/24/044	Held remotely via MS Teams	12th February 2025	09:30-12:30
			Go to booking form

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

Back to top

---

Powerpoint 365

PowerPoint Intermediate

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 can create and run simple presentations in PowerPoint 365 and wish to learn more about inserting, creating and formatting graphics and also running and distributing slideshows.
Training objectives	At the end of the course, you will:  be familiar with some of the different ways you can present information in PowerPoint, including using pictures and SmartArt diagrams.  be able to animate a slide and use hyperlinks to create an interactive presentation.
Learning outcomes	Change a presentation design  Apply a theme Edit the Slide Master Add pictures and Stock Images  Work with Microsoft Stock Images Format graphics Adjust and crop pictures Add an artistic effect Use SmartArt diagrams  Select a SmartArt design Add text Add extra shapes Format the diagram Animate a presentation  Use slide transitions Set up the Morph Transition Animate objects Set effect options Work with the animations pane Add multiple animations to an object Make a presentation interactive  Add a hyperlink to a slide Use Zoom to build a menu slide Create a custom show Use Presenter View  Set up a laptop to use Presenter View Run a show Use keyboard shortcuts to run a show Turn on captions Distribute a show  Record timings Create an unattended show
Additional information	Pre-requisites  The course assumes that you are familiar with creating presentations, adding slides and running slideshows.
Maximum places	11
Closing date	One day before course 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/24/045	Remotely delivered via MS Teams	1 May 2024	09:30 - 12:30
ESC/24/046	Remotely delivered via MS Teams	16 October 2024	09:30 - 12:30
ESC/24/047	Remotely delivered via MS Teams	13 March 2025	09:30 - 12:30
			Go to booking form

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

Back to top

---

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
			Go to booking form

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

Back to top

---

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/24/78	Remotely delivered via MS Teams	7 May 2024	10:00-12:00
ESC/24/79	Remotely delivered via MS Teams	10 July 2024	10:00-12:00
ESC/24/80	Remotely delivered via MS Teams	6 November 2024	10:00-12:00
ESC/24/81	Remotely delivered via MS Teams	4 February 2025	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/24/82	Remotely held via MS Teams	7 May 2024	14:00-16:00
ESC/24/83	Remotely held via MS Teams	10 July 2024	14:00-16:00
ESC/24/84	Remotely held via MS Teams	6 November 2024	14:00-16:00
ESC/24/85	Remotely held via MS Teams	4 February 2025	14:00-16:00
			Go to booking form

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

Back to top

---