IT Services

Microsoft Excel

Microsoft Excel is an application that allows you to organise, format and calculate data with formulas within a spreadsheet system.

Microsoft Excel will allow you to:

• Input and store data that can be used in a variety of ways,
• Analyse your data; using filters to focus on smaller sections of large data sets and determining statistics,
• Perform accounting and budgeting tasks using the software’s wide range of formulas and functions,
• Report on your data and visualise the results, making the identification of trends and patterns an easier task,
• Collaborate with others working on the same spreadsheets.

There are a number of short videos you can view to help you understand how to use the application and get the most out of it:

• What is Excel?
• Add information
• Apply formatting
• Clear v Delete
• Create and manipulate pivot tables
• Formula basics
• IF
• Insert tables
• Linking workbooks
• Look ups
• Mobile app
• Move linked workbooks
• Print
• Using functions
• Working with charts
• Working with large workbooks