Microsoft Excel Intermediate

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

    Use custom fill lists and Flash Fill extraction techniques

    Insert, copy, rename, and hide worksheets

    Use Print techniques to customise how content is printed

    Adjust default page margins and page layout options

    Use Page Breaks

    Apply borders

    Create and use IF functions

    Create more complex Formulas including SUMIF and VLOOKUP

    Copy and use Nested Formulas

    Use Date and Time formulas including TODAY, NOW, and DATE

    Define Names for a range of cells

    Create Custom Number Formats

    Use Conditional Formatting to apply formatting rules

    Use the Quick Analysis Tools

    Create and work with Tables

    Create and customise Sparklines

    Scroll to Top