Skip to main content

Subject LibGuides

Software all [Archive]: MS Excel

"Excel is everywhere. It is by far the most popular program in the history of business applications"

Michael Alexander & Dick Kusleika, Excel 2019 Bible

Microsoft Excel can be used to set up tables of information, both textual and numerical. It is particularly useful for calculating using formulas and functions (built-in more complex formulas). It can also be used to visualise numerical data with the use of charts and graphs. Excel can also be used as a simple database and can be queried and filtered to display only information meeting required criteria. This makes Microsoft Excel a very useful program for basic data analysis, statistics and graphs. 


Features and benefits of Excel

Microsoft Excel makes it possible to analyse, manage, and share information. You can do this by:

Using formulae and functions to carry out a variety of calculations, from simple arithmetic to complex logical and statistical tasks.

Creating a range of highly editable charts

Importing data from a variety of sources and using functions to clean and organise it.

Creating tables and lists that can be sorted and filtered.

Using standard MS Office tools such as shapes and SmartArt to create diagrams using your data.

Using macros to automate repetitive tasks.

You can also easily access your important data on the go from almost any Web browser, tablet or smartphone.


Online and video tutorials - getting started

Step-by-step


Video guides

Many also have step-by-step instructions below the video.

Online and video tutorials - more advanced features

Step-by-step


Video guides

Many also have step-by-step instructions below the video.