Microsoft Excel Introduction

Complete your details below and submit your skills analysis for review.

    Your Name (required)

    Company Name (required)

    Your Email (required)

    Skills Analysis
    (please select the relevant answer from the drop down menu provided)

    Understand spreadsheet concepts and terminology

    Confidently locate and open workbooks on the computer

    Customise the Excel environment

    Edit existing data including being able to overwrite cell contents

    Highlight columns or rows adjacent OR not adjacent to each other

    Use copy techniques to duplicate or move content

    Create formulas to add, subtract, multiply and divide

    Use Functions including SUM, COUNT, AVERAGE, MIN and MAX

    Use Relative (B4) and Absolute ($B$4) cell references

    Use various formatting functions including Format Painter

    Create a series or pattern using AutoFill

    Use the Flash Fill feature to extract or combine data

    Apply number formatting including currency and percentage

    Customise column and row heights and hide columns or rows

    Perform number and text column sorting

    Apply filters to columns

    Print a worksheet, range or entire workbook

    Create a basic chart using different chart types

    Scroll to Top