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)

    Introduction

    Understand spreadsheet concepts and terminology

    Confidently locate and open workbooks on the computer

    Customise the Excel environment

    Use Freeze Panes

    Edit existing data

    Highlight columns or rows; adjacent OR not adjacent to each other

    Resize a column or row / hide columns or rows

    Use cut, copy & paste

    Create a data or number pattern using AutoFill

    Use the Flash Fill feature for data cleanup

    Sort text, numbers and dates

    Apply filters to columns

    Create formulas to add, subtract, multiply and divide

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

    Print a worksheet, range or entire workbook

    Insert, copy, rename, and hide worksheets

    Apply number formatting including date, currency and percentage

    Use Format Painter

    Create a basic chart using different chart types

    Intermediate

    Create Custom Number Formats

    Create a custom list for sorting and filling data

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

    Define a Name for a range of cells

    Use the IF function

    Create more complex Formulas including SUMIF, VLOOKUP and XLOOKUP.

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

    Use Page Breaks

    Create custom Header & Footers

    Use Conditional Formatting to apply formatting rules

    Create and customise Sparklines

    Create and work with Tables

    Advanced

    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 and display Scenarios

    Create a PivotTable from scratch

    Display SUM and COUNT in a PivotTable

    Create Calculated fields in a PivotTable

    Use Text based functions including UPPER, LOWER, PROPER.

    Use Data Validation techniques

    Record, view and edit a Macro

    Create a worksheet with form controls

    Scroll to Top