Students Staff

Learning event search page

Results

Excel: conditional formatting

Virtual and in-person sessions are available for this course. Please check when booking. This training is delivered on a Windows machine using the latest version of Excel from the Microsoft Office 365 suite. Participants wanting to follow along, should make sure they have the software installed before the session starts. Essex members can find instructions for downloading the software for free onto your personal device at: https://www.essex.ac.uk/staff/it-services/microsoft-office-365 OUTLINE Conditional formatting in Excel allows you to automatically apply formatting such as colours, icons, and data bars, to one or more cells, in order to highlight specific data in your spreadsheet. Applying conditional formatting to your data can not only help make your data easier to read, it will also allow you to isolate and then sort and filter your data to get specific results. In this training session you will follow a series of conditional formatting examples using both pre-set functions as well as applying a variety of formulas for more advanced formatting. - Naming ranges to use in formulas - Using pre-set conditional formatting rules - Modifying pre-set rules - Using a variety of formulas to create conditional formatting rules For those submitting CADENZA applications/PGCHEP portfolios, these sessions map to the following: UKPSF areas of activities: A2, K4 JISC framework: 1, 2 If spaces are available, please click on the white space below. ONLY add yourself to the waiting list if the date/s are not convenient.

Excel: pivot tables for dashboard reporting

Virtual and in-person sessions are available for this course. Please check when booking. Virtual sessions will be delivered via Zoom. Please make sure you install Zoom prior to the training session. Visit the Zoom web page for instructions: https://www.essex.ac.uk/staff/it-services/getting-started-with-zoom. This training is delivered on a Windows machine using the latest version of Excel from the Microsoft Office 365 suite. Participants wanting to follow along, should make sure they have the software installed before the session starts. Essex members can find instructions for downloading the software for free onto your personal device at: https://www.essex.ac.uk/staff/it-services/microsoft-office-365 OUTLINE PivotTables allow you to calculate, summarise, sort, and format your data quickly and easily to see comparisons, patterns and trends. In this session you’ll create and manipulate a variety of PivotTables to answer questions of your data, and finally produce some PivotCharts to create dashboards to visualise your data. - Creating a PivotTable - Configuring a PivotTable - Pivoting a PivotTable - Sorting/filtering data - Changing the data field summary - Creating and manipulating Pivot charts For those submitting CADENZA applications/PGCHEP portfolios, these sessions map to the following: UKPSF areas of activities: A2, K4 JISC framework: 1, 2 If spaces are available, please click on the white space below. ONLY add yourself to the waiting list if the date/s are not convenient.

New to Managing Programme

This four-day training programme explores the role of a manager at Essex and provides an opportunity to develop your knowledge on the different aspects of the first line management role. The programme has been designed for new managers, who have had not had any formal training and are new to the role of first line management. If you have any further questions about the programme or would like support with an individual learning need, please don’t hesitate to contact develop@essex.ac.uk prior to session to enable the trainer to support you as best as possible. Please note this programme includes multiple dates and you are required to attend all sessions. The training is delivered as a face-to-face programme. Outcomes: Day 1 - Understanding the role of management and situational leadership to motivate and support employees. Day 2 - Understanding solution-oriented risk management and recruitment essentials. Day 3 - Managing Absence and holding effective performance reviews. Day 4 - Managing difficult conversations and developing a cohesive team. If spaces are available, please click on the white space below. ONLY add yourself to the waiting list if the date/s are not convenient. If attending this event falls outside of your usual working hours, and you incur additional costs due to caring responsibilities, you may be able to claim towards this. One claim per year, of up to £150 is available through the Career Development Fund for Carers. Further information is available on the staff directory or speak to your Line Manager. https://www.essex.ac.uk/staff/pay-and-rewards/career-development-fund-for-carers

Outlook: managing a busy inbox

Virtual and in-person sessions are available for this course. Please check when booking. Virtual sessions will be delivered via Zoom. Please make sure you install Zoom prior to the training session. Visit the Zoom web page for instructions: https://www.essex.ac.uk/staff/it-services/getting-started-with-zoom. PREPARATION FOR THE TRAINING This training is delivered on a Windows machine using Outlook 365 (desktop version). Participants wanting to follow along, should make sure they have the software installed before the session starts. NB: Mac users please be aware that QuickSteps and Building Blocks functionality is not currently available on the Mac OS at this time. Essex members can find instructions for downloading the software for free onto your personal device at: https://www.essex.ac.uk/staff/it-services/microsoft-office-365 OUTLINE Find out how to use the automatic features in Outlook to help organise your workload and save precious time. - Using Auto correct for your own common words and phrases - Drag and drop to create mail, task and calendar items - Natural language dates - Setting your working hours pattern in your calendar - Using folders to process email - Creating rules and quick steps to process emails automatically - Assigning colour categories to emails - Working with tasks - Using building blocks and email templates for repetitive information - Using the search function and creating search folders to find content quickly and easily For those submitting CADENZA applications/PGCHEP portfolios, these sessions map to the following: UKPSF areas of activities: A2, K4 JISC framework: 1, 4 If spaces are available, please click on the white space below. ONLY add yourself to the waiting list if the date/s are not convenient.

PGR: Supervisor Training

Event information Supervising postgraduate research students is an incredibly rewarding role but it is also demanding and sometimes challenging. This workshop will provide a forum for new and experienced supervisors to review their role in light of these developments and existing good practice within their department and disciplinary context. The workshop consists of 3 elements – a set of videos, short individual tasks and attendance at a de-brief group meeting. Participants have much more flexibility and can watch the videos and complete the tasks independently over a period of two weeks before attending one of two possible group de-brief meetings. The training is suitable for both new supervisors who would like to increase their knowledge in supervision and those experienced colleagues who would like to refresh their knowledge and skills. Event learning outcomes • Explain the nature of the PhD in the contemporary HE context • Review the role and responsibilities of a supervisor including – o Assisting students at the beginning their PhD and planning their research projects o Use a variety of means to monitor and manage the performance and progression of their students o Conduct effective supervisory meetings • Consider your own style and approach to supervision within the disciplinary context • Be aware of what can go wrong and consider ways to prevent and deal with it • Support students in completing their doctoral studies and preparing for assessment Topics Covered • New to supervision o The changing nature of the PhD o Expectations – roles and responsibilities o Planning and managing a research project • Effective supervisory meetings and working within supervisory teams. • Supervision to Completion o Working with research students – coping with difficult situations, training and monitoring progress o Preparing for assessment, writing-up, the viva and the outcomes Workshop Design The workshop consists of three elements – engaging with all three components is required. 1. Viewing 7 short videos covering key topics (approx. 70 mins) Asynchronous 2. Completing a set of short, individual, tasks (approx. 2 hours) Asynchronous 3. Attend a 75 synchronous de-brief meeting Synchronous NB – The videos and tasks must be studied before attending the synchronous de-brief meeting Facilitator Dr Kate Exley. Kate is a Senior Academic Staff Development Officer at The University of Leeds and an Independent Consultant in Higher Education Development. She has delivered workshops and undertaken projects at more than 50 HE, FE, Medical and Research Institutions around the country and she is series editor of the new Routledge book series “Key Guides for Effective Teaching in Higher Education” and a National Teaching Fellow (2008). Important Information - Zoom links and how to access the online materials and tasks will be shared with those who book on the training three weeks ahead of the event. - If a session is full, please choose another date/time. If all sessions are booked, please add your name to the waiting list. We will let you know when we will offer this training again. - It is essential that you engage with the online materials and complete the relevant tasks. Therefore, if you are registered and but do not engage with these materials, you will be excluded from the event. So, please only book if you are planning to attend and complete the first two elements of the course. Any questions, please email develop@essex.ac.uk