MS Excel

A guide to using Microsoft's spreadsheet program

Microsoft Excel is a spreadsheet application used for organizing, analyzing, and visualizing data. It can be used for a wide range of tasks, from simple calculations and budgeting to complex financial analysis, and includes features like formulas, charts, and PivotTables. It is part of the Microsoft 365 Apps and Services which you have access to as a student or staff member at the University.

We've included a few videos to make it easy to get started, but for more in-depth tutorials you may find the following training helpful:

University Excel Courses - Free courses, in person and online, covering fundamentals, charts, advanced functions, pivot tables, lookup functions and much more. Simply log in to the course booking system and search for Excel, or view 'Focus On' webinars in the video player.

Learnit Training For Beginners - A free half-day course covering the basics of cell functions, formulas, functions, tables and includes downloadable project files.

Microsoft's Tips for Students - A video playlist explaining frequently used features and highlights shortcuts that students may find useful.

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

Last updated on 21 October 2025

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.