MS Excel

A guide to using Microsoft's spreadsheet program

Focus on...Using Lookup functions to retrieve data

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.

_{Related resources | SPSS | NVivo | MATLAB | Microsoft 365 Apps & Services}

Last updated on 06 December 2024

Guides
Info
Links

Guides

Basics

Functions & Formulas

Tables

Information

This resource was provided by IT Services.

With over 180 members of staff across four divisions, we are responsible for the management, operation and support of the University’s wired and wireless networks, server infrastructure, IT classrooms, telecommunications, audio visual and media services, software and hardware, email and calendaring, web resources, corporate applications, medical illustration, IT training and supporting documentation.

You can email us at servicedesk@abdn.ac.uk for support with IT issues.