Students Staff

Learning event search page

Results

EndNote

MPORTANT UPDATE In response to COVID-19 this training is now being delivered remotely using 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. Recurring Zoom link for all sessions is: https://essex-university.zoom.us/j/97391299960 With the exception of: 23 June which is: https://essex-university.zoom.us/j/98063555242 This training is delivered using EndNote 20. Participants wanting to follow along, should make sure they have the software installed before the session starts. Find instructions for downloading the software for free onto your personal device at: https://www.essex.ac.uk/student/it-services/endnote OUTLINE EndNote is the University’s free, recommended and supported reference management tool. EndNote will save you valuable time by removing the manual labour associated with creating and formatting references. You can now access the fully-featured desktop software (from software.essex.ac.uk) and manage your EndNote library from multiple computers including your personal device (via myendnoteweb.com). In this course you will learn how to use EndNote to collect, organise and then use references in your Word documents. In this training session, you’ll work through the following exercises: - Collect references from websites like Google Scholar, Albert Sloman Library, Web of Science etc - Find references using the online search feature from within the program - Create your own reference - Create basic groups and search groups to organise your references - Find and remove duplicates - Locate and attach full text articles, then annotate them - Import PDFs - Insert references into Word - Create categories for your references in your bibliography - Trouble shoot common problems - Sync with the online account For those submitting CADENZA applications/PGCHEP portfolios, these sessions map to the following: UKPSF areas of activities: A2, K4 JISC framework: 1, 2, 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.

Excel: conditional formatting

IMPORTANT UPDATE In response to COVID-19 this training is now being delivered remotely using 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 The Zoom link is: https://essex-university.zoom.us/j/92161555447 Task workbook: https://essexuniversity.box.com/s/pzb3oc98lzbc634a1mbq20afj6ppoj7z This training is delivered using Excel 2016. 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: further functions

IMPORTANT UPDATE In response to COVID-19 this training is now being delivered remotely using 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 The Zoom link is: https://essex-university.zoom.us/j/98578993558 Task workbook: https://essexuniversity.box.com/s/ar2rspxvvprt932i6g6b67rf5hxl9z23 This training is delivered using Excel 2016. 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 Improve the efficiency and productivity of your Spreadsheets by learning how to construct functions, manipulate data and format outputs. In this training session, you’ll work through a series of exercises using the following: - Autofill, paste special and format painter - Tables vs named ranges - Relative vs absolute referencing - Basic functions eg SUM, MAX, MIN, DATE eg TODAY() - Concatenate / text to tables - IF functions eg IF, SUMIF, SUMIFS, COUNTIF, COUNTIFS, AVERAGEIF etc - Strings eg LEFT, MID, RIGHT - VLOOKUP, XLOOKUP 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

IMPORTANT UPDATE In response to COVID-19 this training is now being delivered remotely using 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 The Zoom link is: https://essex-university.zoom.us/j/96925927663 This training is delivered using Excel 2016. 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.

Outlook: managing a busy inbox

IMPORTANT UPDATE In response to COVID-19 this training is now being delivered remotely using 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 The Zoom link is: https://essex-university.zoom.us/j/98004721956 This training is delivered on a Windows machine using Outlook 2016 (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.