IT skills and training

Basic functions formulae (SUM, AVERAGE, COUNT, MAX & MIN)

This page will cover the 5 basic functions found in the auto-sum drop-down menu:

• SUM

• AVERAGE

• COUNT NUMBERS

• MAX

• MIN

What is a Mathematical operator?

This page will guide you through using Excel to create basic mathematical operations. This is very similar to creating a function or formula except that we are not using the function's operative such as (=Sum) or (=Average) or any of the other function operative.

If we wanted the sub-total for a given range we can use the function operative (SUM):

=Sum(A1:A10)

Creating a Table

When you input data into Excel it is initially a 'data array' and although it is perfectly fine to leave data in this format it is sometimes easier or better to convert it to Table for the following reasons;

Freeze Panes

Freeze Panes can be used to lock specific columns or rows in place so that you may see them where-ever you are within the data. 

In the view tab of the ribbon you will find the "freeze panes" drop down menu:

Number Formatting in Excel

Excel can handle lots of different format types of numbers, but you must regularly choose what type of number format you wish to be expressed on the cells containing those numbers. If you don't, you may suffer problem when calculating functions or expressing the data in a specific way.

Examples:

• Date
• Time
• Percentage
• Monetary value
• fraction
• text

Resizing Columns and Rows in Excel

There are several ways to re-size a column or row, each has a specific use and will benefit you in different ways depending on what you wish to accomplish.

Excel Quick Selection Techniques

In Excel to highlight/select data you can "click and drag" around the data to select it, there are in fact several different ways you can highlight/select data a lot faster or more effciently. Esspecially when you have large ammounts of data. 

I shall outline the selection methods you can use here:

In order to reduce the file size of any Microsoft document (Word, Powerpoint or Excel) there are a few steps we can take without removing content.

Quick links

1. Check the assessment criteria
2. Academic study skills support
3. Formatting your assignment
4. Submitting your assignment
5. Using Turnitin to check references
6. Collecting feedback in ChiView

1. Check the assessment criteria

Your module's Moodle page will have all the details you'll need regarding any assessments.

This should include:

MAF Online (Module Assessment Feedback) is where tutors add feedback and grades/marks for all summative assignments.

Feedback can take the form of;

• written feedback
• attached Microsoft Word
• attached PDF files
• attached mp3 files
• links to Panopto recordings (audio and/or video)

Via the MAF Admin Database, Faculty Administrators can see this feedback and view reports.