MS Excel
A guide to using Microsoft's spreadsheet program
-
Excel Beginner Tutorial -
Create & Open Workbooks -
Cell Basics -
Modifying -
Format Cells -
Number formats -
Conditional formatting -
Formulas -
Complex formulas -
Relative and absolute cell references -
Functions -
Freeze panes and views -
Tables -
Focus on...Pivot Tables- Summarising and Analysing your data -
Pivot Tables -
Doing more with pivot tables
Excel is an Electronic Spreadsheet Program.
An electronic spreadsheet is a computer software program that is used for storing, organising and manipulating data. Electronic spreadsheet programs were originally based on paper spreadsheets used for accounting. As such, the basic layout of computerised spreadsheets is the same as the paper ones.
This resource will teach you the fundamentals of Excel before moving on to more complex functionality such as constructing formulas, and using pivot tables to analyse data. Use the Guides section for detailed information and the Links section for online assistance.
This resource was last updated 20.07.20
Guides
Basics
- Getting started with Excel
- Useful Features in Excel
- MS Excel Mouse Pointer Basics
- MS Excel Keyboard Shortcuts
Functions & Formulas
Tables
Information
This resource was provided by Training and Documentation.
The Training and Documentation Team publish a range of user guides to help you use University IT facilities and supported software. They also run regular training sessions supporting MS Office applications (Word, Excel, Outlook, PowerPoint, and Teams), and OpenText CMS.