Search results

Basic Functions
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

    • SUM

  • Summation, the addition of a...

    •
    Resizing Columns and Rows
    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.

    Click and drag a column or row header's boundary:

    To resize an individual column or row you can click...
    Number Formatting
    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...
    Freeze Panes
    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:

     

    Ribbon1.png

    This menu...
    Tables
    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;

  • Table data can be sorted and filtered faster and at the table...
    •
    Mathematical Operatives
    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...
    Excel Tutorials - Full Listing
    Excel Tutorials

    Below are a list of Excel guides currently available, these are a work in progress and will be added to as time goes on. If however you have a need for a tutorial that doesn't exist yet then please email ITSkills@chi.ac.uk to request it.

    Beginner

  • Excel...

    •
    Wrap Text & Merge and Centre
    Wrap Text & Merge and CentreWrap Text

    Microsoft Excel can wrap text so it appears on multiple lines in a cell. You can format the cell so the text wraps automatically, or enter a manual line break. But this will prevent you from a cell potentially taking up...
    Syncing a SharePoint storage area with your computer
    Accessing the SharePoint site

    SharePoint sites exist in a number of different ways and therefore accessing them for the purposes of syncing with your local PC are done differently according to their type:

  • SharePoint site -  e.g. 'UOC staff SharePoint' - Can be accessed by clicking the...
    •
    SNAH Polices and Operational Guidlines
    Please see the various SNAH documents
    Show All Results