Excel Training

Skip to content

Induction

4

Student induction
Staff induction
Partner induction
Visitors

Hot Topics

5

Opening times (Learning Resource Centres and SIZ)
Start of semester checklist for Moodle
Using AI in your studies
Mobile App – My UoC
Reporting suspicious online activity

Calendar

4

Sharing your calendar Outlook
Sharing your calendar Office 365
Using Outlook – Email and Calendar
Sharing your calendar

Learning and Teaching

34

Learning & Teaching Innovation
Using AI in your studies
Moodle overview for students
Moodle overview for staff
Skills and training
Academic skills
Microsoft Clipchamp
Video/Multimedia assignments
Study spaces around the campuses
Working from home
Working with External Examiners
University Social Media Channels
Turnitin for students
Using social media responsibly
Staying safe online
Setting up a link for formative assignments or document collation
Reduce a Microsoft office document’s file size
Microsoft Forms
Microsoft To Do
Managing your digital footprint
IT Health and Safety
Importing S1 and S2 content to an AY module page
How to set up a group submission
How to grant an extension
How to allocate submissions to specific markers
Exporting a PDF from Microsoft documents
eStream video platform
Enabling and Configuring Browser-Based Spellcheckers
BDC tool staff login
Student Assignment Checklist
Allocating markers to submissions
MAF Online (new 2024)
Using OneNote class notebook for student ePortfolio
Distance learning student support

Email

14

Using Outlook – Email and Calendar
Accessing a generic account or another user’s mailbox in Outlook
Using the scheduling assistant to plan a meeting in Outlook
Turn off the Auto-Complete in Outlook
Outlook – Sharing your generic account mailbox
Setting up your staff signature on your University email
Setting up an automatic reply for your email
Outlook – Managing your Emails
Outlook – Managing a Shared mailbox
Outlook – Managing a Generic account’s mailbox (Delegate access)
How to update or change your Microsoft 365 account’s time zone
How to send personal data securely using email encryption
Emailing centralised groups or all staff / all students
Sending all staff / student emails

IT Services

106

Generative AI
What are scams?
Connecting to eduroam Wi-Fi
Multi-Factor Authentication (MFA)
How to book booths, study rooms, and edit suites
Video/Multimedia assignments
Password manager
Get Ready for University: Academic Skills
Microsoft Clipchamp
Moodle overview for staff
Turnitin Originality (similarity) report
Wi-Fi for older devices – global sign certificate installation
Wi-Fi for guests
Virus scanning
Using your laptop in open access areas – security
Using a University Windows Laptop off campus
Student MFA Help page
Using headphones and dvds on open access computers
Uploading a Solidworks file for marking
University SIP telephones – overview and how to (including logging on / off)
Telephone user guides and insert templates
Telephones
Support me portal
Support Me – Estate Management Requests
Student attendance management (SAM)
Staff – log into your student account from your staff profile (or vice versa)
Setting up your voicemail and message notification
SAM user guides
SAM department coordinators
Reporting suspicious online activity
Remote login for staff (e.g. working from home)
Reading encrypted emails sent from University staff
Personal data breaches
Passwords
Partners: how to unlock your account
Partners: how to reset your password
Online timetables (Publish)
Microsoft Wireless Display Adapter
MATLAB on a personal device
Open access computer bookings
Managed Software Centre
Logging into Creative Cloud and Adobe products
Lists of equipment available through Equipment Loans
Booking resources: computers, booths, study spaces, edit suites, rooms, and equipment
Listening to voicemail messages and managing messages
Jisc online Surveys
Installing Microsoft Office 365 on Windows 10 S
Installing Adobe Creative Cloud Applications on a University Computer
HR self service – Updating your personal email address
How to use IT provisioning online
Graduation
Finding the serial number of a computer
FAQs about the HEAR
FAQs about the Equipment Loans service
eTranscript/HEAR
ESports – Recording gameplay footage
ESports FAQ
Email scam and virus advice
Discounts
Data breaches
Customising your voicemail
Connecting to the internet in halls of residence
ChiView – Updating your personal email address
ChiView
Changing your name – IT accounts (staff)
Changing your name – IT accounts & other resources (students)
Changing the default pdf viewer (to Adobe Reader)
Clearing your browser data (including cache)
Borrowing, collecting and returning equipment from Equipment Loans
Booking a specific open access computer
Booking a randomly allocated open access computer (quick booking)
BOC Creative Suites
Are you eligible to receive a HEAR?
Alumni – Backing up your University data
Alumni information for those graduating in 2018 or 2019
Alumni information for those graduated in 2017 or earlier
Alumni information
Adding attachments in MAF
Adding a calendar from the university directory
Access your university email via the Microsoft Outlook mobile app
eTranscript/HEAR
Accessing Media Storage
Accessing the Business School Web Server
Teaching Timetables
Summary of University Encryption & Cryptographic Controls
UoC Social Media
Resource Booker
Accessing University Desktops from Home (Remote Access)
Academic partner process
Online Surveys – Students
Mimecast
Microsoft Office for students and staff
MFA – Using a personal email address
Staff MFA Help page
MFA – PingID mobile app
MFA – Ping Desktop App
MFA – Authenticator app
Alumni MFA Help page
MAF upgrade / integration into ChiView
External MFA Help Page
Equipment Loans
Data breach summary
Classroom technical support
Mobile App – My UoC
Accessing University services on your personal Windows device (Staff)
Accessing University services on your personal Android device (Staff)

Excel

1

Excel Tutorials – Full Listing

Library

11

How to contact the library team
ChiReadingLists
Library Services
Library loans
Visitor access to our Library Services
Special collections and archives
Learning resource centre (LRC) etiquette
Interlibrary loans
Mendeley
Copyright safe image sources
Art and early years at the Bishop Otter College and Bognor Teacher Training College

21

Excel Tutorials – Full Listing
Excel – Text to Columns
Excel – Unique Function
Excel – Sort Function
Excel – Charts and Graphs
Excel – Vlookup & Hlookup
Excel – Pivot Tables
Excel – Drop-down lists
Excel – Conditional formatting
Excel – Mathematical Operatives (Order or operations)
Excel – Quick selection Techniques
Excel – Resizing Columns and Rows
Excel – Number Formatting
Excel – Flash fill and the fill handle
Excel – Freeze Panes
Excel – Creating a Table
Excel – Cell Referencing
Excel – Find and Replace
Excel – Sparklines
Excel – Basic functions or formulae (SUM, AVERAGE, COUNT)
Excel – IF Functions

File Storage

8

Using OneDrive
OneDrive – Sharing and Version History
USB Storage Devices
Syncing a SharePoint storage area with your computer
OneDrive – Syncing with a device
Restoring files
Restoring a deleted file or folder
Scanning to OneDrive

IT Skills

12

IT skills
Word Tutorials – Full Listing
PowerPoint Tutorials – Full listing
Excel Tutorials – Full Listing
Microsoft Office for students and staff
Using OneDrive
OneDrive – Uploading files
OneDrive – Sharing and Version History
Using Outlook – Email and Calendar
Outlook – Sharing your generic account mailbox
Outlook – Managing a Shared mailbox
Outlook – Managing a Generic account’s mailbox (Delegate access)

SIZ

11

Opening times (Learning Resource Centres and SIZ)
How to find us
Student Health Anaphylaxis
Winter Holiday Support
Diabetes RAP
Council tax
Contact SIZ
Appointments
SIZ – Charges, Payments & Fines
The Support & Information Zone
Let us know

General

25

Tenders and contracts
Emergencies (including first aid)
Transport
Staff Hub Locker loans
Academic Year Roll-Over Processes
Practice Assessment Documents
NMC Documents
Mitigating circumstances
FND RAP
Fire Incident report form
Filming on campus
COVID-19 Guidance
Common Placement Assessment Forms
University of Chichester – Bus information
Bus timetables
BOC LRC Locker Loans
Summary of the University’s Physical Access Controls
Staff Hub BRC
Staff Hub BOC
SNAH Polices and Operational Guidlines
Royal Literary Fund Fellows
The Prevent Programme
Near miss reporting – ‘oops cards’
Electric Vehicles updated
Academic Building Locker Loan

IT Policies

1

Equipment Loans – Terms and Conditions

Library Policies

4

Stock retention, withdrawal and donation policy
Reading List Policy
LRC Code of Conduct
Library Regulations

Moodle

10

Submitting an assignment in Moodle
Start of semester checklist for Moodle
Sending university wide emails from Moodle
Orphaned sections in Moodle
Moodle overview for students
Moodle accessibility tool
How to edit your Moodle Profile
Creating accessible content for Moodle
Accessing your modules through My Pages in Moodle
Moodle Guidance for Notetakers

PowerPoint

1

PowerPoint Tutorials – Full listing

PowerPoint Tutorials

13

Powerpoint – Animations
PowerPoint – Adding Notes to your presentation (Presenter View)
PowerPoint – Working with Shapes
PowerPoint – Layouts, Design Theme and Slide Size
PowerPoint – Slide Master (Template slides)
Powerpoint – Adding Media (Audio)
PowerPoint – SmartArt
PowerPoint – Textboxes
PowerPoint – Removing an image’s background
PowerPoint – Making a recording
PowerPoint – Adding media (Images)
PowerPoint – Grouping
PowerPoint – Adding Media (Video)

Printing

8

Reporting a printer problem
PrintShop: dissertation and binding service
Print and Imaging Service (PrintShop)
Printing from a Personal Device
Printing from an open access computer
Printing costs
Multiple cost centres for printing
Adding print credit

Academic Registry

7

Academic Registry
Change in Registration
Student Reports in ChiView
Module Registration
Module De-Registration
Module Coordinator Updates
Academic Transcript Requests

Privacy Policies

3

Mobile App Privacy Policy
Privacy policy: Supportworks and SupportMe self-service portal
Estates Call Management System and SupportMe self-service portal

Student Support and Wellbeing

18

Wellbeing Services
Student Support and Wellbeing
Money advice: general
Wellbeing Counselling Service
Wellbeing Referrals
Sexual health advice
Money advice: money worries
Intermission – Student Support Information
Help and support after sexual assault
Health advice: general
Care leavers
Academic Advisor – Student Support Information
Student Money Team
The Student Health Service
Self-harm resources
Guidance for students accused of sexual violence or misconduct
Chichester International Advice
The Chaplaincy – Faith at the University

SIZ Policies

9

SIZ Equipment Borrowing:Terms & Conditions
SIZ Engagement Strategy
SIZ Confidentiality Statement
LRC Promotional and Advertising Guidelines
Lost Property Guide
Customer Service Standards
Customer Services Charter
Complaints Policy
Charges

Accessibility and Inclusion

20

Disability and Dyslexia Service
Assistive technology training and support
Accessibility
Built in accessibility options in Windows (Ease of Access Centre)
Working with someone who is deaf or hard of hearing
Working with someone with a visual impairment
Working with someone with a physical or motor disability
Working with someone with dyslexia
Working with someone on the autistic spectrum
Working with someone with anxiety
Texthelp Read & Write
SensusAccess
Screening for specific learning differences such as dyslexia and dyspraxia
Microsoft Immersive reader (accessibility tool)
Disability and dyslexia support
Inspiration software
If you’re working with someone who’s visually impaired
If you’re working with someone who’s hearing impaired
Creating accessible images using ALT text
Apple accessibility options

General Policies

5

Strategy & Policies
Social Media Policy
Vulnerability Responsible Disclosure Policy
Privacy policy: Moodle
Personal Devices

Teams

1

University Teams Backgrounds

Teams Overview

2

Microsoft Teams Overview
Changing Voicemail Settings

UOC Food: Catering

8

UOC Food: Catering
Upcoming events: Catering
New for 2026!
Catering service hours
Catered Meal Deal
Catered Cards
BRC Menus
BOC Menus

Word

17

Exporting a PDF from Microsoft documents
Word Tutorials – Full Listing
Word – Track Changes
Word – Tables
Word – Styles
Word – Show hidden formatting
Word – Page view options
Word – Page Numbering
Word – Images, Icons and Text Wrapping
Word – Page & Section Breaks
Word – Format Painter
Word – Dictation and Transcription
Word – Comments
Word – Automatic table of figures
Word – Automatic Table of Contents
PowerPoint – Footnotes and Endnotes
Word – Change the background colour

Offline

2

Server maintenance
Font Awesome icons

Home
Docs
Excel Training

Excel Training

21 Docs

Excel – IF Functions

❮
1
2
3

Quick Links

Assistive technology
Reset my password
Support Me (self service)
WiFi
Access email
Accessibility Statement

More

Give us feedback
Cookie information
Campus maps

Contact

University of Chichester
College Lane
Chichester
West Sussex
PO19 6PE

Telephone: +44 1243 816000
Email: help@chi.ac.uk