ECDL Excel 2010 4.2.1 Use sum, average, minimum, maximum, count, counta, round functions.
ECDL Excel 2010 2.2.2.
ECDL Excel 2010 1.1.5.
ECDL Excel 2010 1.1.1.
ECDL Excel 2010 1.2.2.
This video is for education and demonstration purposes only. This is a preview of the ECDL ICDL Microsoft Excel 2010 Diagnostic Sample Test. Microsoft Excel ...
ECDL Excel 2010 4.2.2 Use the logical function if - yielding one of two specific values - with comparison operators.
The 40 min video is designed as a pre exam session for Spreadsheets (Excel). It is best used with the resources available from school. The following resource ...
ECDL Excel 2010 7.2.1 Check and correct spreadsheet calculations and text.
ECDL Excel 2010 7.2.5 Print a selected cell range from a worksheet, an entire worksheet, number of copies of a worksheet, the entire spreadsheet, a selected ...
ECDL Excel 2010 3.2.4 Copy, move, rename a worksheet within a spreadsheet.
A guide to completing the worksheet.
ECDL Excel 2010 4.1.1 Recognize good practice in formula creation: refer to cell references rather than type numbers into formulas.
ECDL Excel 2010 2.2.5.
ECDL Excel 2010 3.1.1 3.1.1 Select a row, range of adjacent rows, range of non-adjacent rows. 3.1.2 Select a column, range of adjacent columns, range of ...
ECDL Excel 2010 7.2.4 Preview a worksheet.
ECDL Excel 2010 3.2.2 Insert a new worksheet, delete a worksheet.
ECDL Excel 2010 6.2.3 Change chart area background colour, legend fill colour.
ECDL Excel 2010 6.2.2 Add data labels to a chart: values/numbers, percentages.
ECDL Excel 2010 2.3.3 Move the content of a cell, cell range within a worksheet, between worksheets, between open spreadsheets.
ECDL Excel 2010 7.1.5 Insert and delete fields: page numbering information, date, time, file name, worksheet name into headers, footers.
ECDL Excel 2010 7.1.1 Change worksheet margins: top, bottom, left, right.
ECDL Excel 2010 1.1.3.
EXCEL BASICS - CREATE A BASIC SPREADSHEET - PART 1: MICROSOFT EXCEL 2010, ECDL, BTEC, GCSE, KS3, KS4 Subscibe to this channel...
ECDL Excel 2010 7.2.3 Apply automatic title row(s) printing on every page of a printed worksheet.
ECDL Excel 2010 7.2.2 Turn on, off display of gridlines, display of row and column headings for printing purposes.
ECDL Excel 2010 2.1.1.
ECDL Excel 2010 7.1.4 Add, edit, delete text in headers, footers in a worksheet.
ECDL Excel 2010 3.2.1 Switch between worksheets.
ECDL Excel 2010 4.1.3 Identify and understand standard error values associated with using formulas: #NAME?, #DIV/0!, #REF!.
ECDL Excel 2010 5.1.3 Format cells to display numbers as percentages.
ECDL Excel 2010 6.2.4 Change the column, bar, line, pie slice colours in the chart.
ECDL Excel 2010 1.2.3.
ECDL Excel 2010 4.1.4 Understand and use relative, absolute cell referencing in formulas.
ECDL Excel 2010 6.2.1 Add, remove, edit a chart title.
ECDL Excel 2010 6.1.1 Create different types of charts from spreadsheet data: column chart, bar chart, line chart, pie chart.
ECDL Excel 2010 5.2 5.2.1 Change cell content appearance: font sizes, font types. 5.2.2 Apply formatting to cell contents: bold, italic, underline, double ...
ECDL Excel 2010 4.1.2 Create formulas using cell references and arithmetic operators (addition, subtraction, multiplication, division).