Microsoft Excel Advanced

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

    Apply data protection to a worksheet or entire workbook

    Import data from other types of files including .txt, .csv, .accdb

    Work with Connected Data

    Export data to other formats

    Link data between worksheets and workbooks

    Create an Automatic Outline

    Create a Manual Group

    Create a Subtotalled Worksheet

    Create, display and merge Scenarios

    Define a PivotTable structure

    Use PivotTable Grand Totals

    Create Calculated fields in a PivotTable

    Use Advanced Filters

    Use Data Validation techniques

    Create a worksheet with Controls

    Share workbooks and use Track Changes

    Record, view and edit a Macro

    Scroll to Top