Menu
Below is a glossary of training terms that you may come across when using Microsoft Office
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 you position your data – 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 chart is a pictorial representation of data (Microsoft Office, Crystal Reports), therefore helping you interpret your data more easily.
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, hence allowing easily for calculations.
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 – 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 you copy a formula with a relative reference to another cell, the reference will adjust itself relative to the new position (Microsoft Excel)
Row – A row is 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 which contains 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 hope you find this Glossary of Training terms useful.
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.