Students Staff

Learning event search page

Results

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 then apply some conditional formatting and calculations, and finally produce some PivotCharts 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 using Outlook 2016 (desktop version). 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 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.