Menu

    Call us on:
    020 8892 5637

3-D formula – Formula created to perform calculations across several worksheets (Microsoft Excel)

Absolute reference – when you copy a formula an absolute cell reference or range address remains unchanged. (Microsoft Excel)

Alignment – Where data is positioned  – left, centered, right, justified (Microsoft Office, Crystal Reports)

Cell – The intersection of a row and a column in an Excel worksheet; contains various types of data that can be formatted, sorted and analysed.

Chart – a pictorial representation of data (Microsoft Office, Crystal Reports)

Column – A vertical group of cells in an Excel spreadsheet

Field – A column of data in a database (Microsoft Excel, Microsoft Access, Crystal Reports)

Function – A pre-defined formula that performs string operations or calculations. Functions are used in Excel spreadsheets, Access queries and reports and Crystal reports

PivotTable – In Microsoft Excel or Microsoft Access, an interactive table that you can use to summarise, organise and compare large sets of data. The rows and columns of a PivotTable can be rotated to create different views of the same data

Query In Microsoft Access, a query extracts data from one or more tables and displays their results

Quick Access toolbar – In Office 2007 and Office 2010, displays commands for saving the current file, undoing the last action and repeating the last action. It can be customised by adding buttons for frequently used commands.

Relative cell reference – When copying a formula this type of cell or range address is updated in relation to the location of the formula (Microsoft Excel)

Row – A horizontal group of cells in an Excel spreadsheet

Template – A file with predefined settings on which you can base new files.

Workbook – An Excel file containing several worksheets; by default a workbook contains three worksheets

Worksheet – Part of an Excel workbook consisting of rows and columns that intersect to form cells which contain data

Workspace – An arrangement of Excel worksheets which when saved will open in exactly the same arrangement

 

We provide  Microsoft Office training courses, other IT training courses  and Personal Development training courses in London, Richmond, Twickenham, Kingston, Hounslow, Brentford, Putney, Kingston, Wimbledon, Walton-on-Thames, Chiswick, Teddington, Hampton, Feltham, Acton, Ealing, Heathrow, Egham, Staines, Hanwell, Sunbury, Hammersmith, Fulham, Greenford, Clapham, Chertsey, Woking, Weybridge, Wandsworth, Middlesex, Surrey, the M25 corridor, High Wycombe and beyond. We will travel further if expenses are covered.