In a world where technology is ever-growing and is used in every industry, it has never been more important to have IT skills. Microsoft Office Excel module will help you understand the concept of spreadsheets, basic spreadsheet functions to produce standard documents e.g. Open, create, save, formatting. And slightly more advanced functions such as insert/delete rows and columns, sort data, basic formulas, document setup. Printing Charts, graphs etc.
Microsoft Office Excel module will help you understand the concept of spreadsheets, basic spreadsheet functions to produce standard documents e.g. Open, create, save, formatting. And slightly more advanced functions such as insert/delete rows and columns, sort data, basic formulas, document setup. Printing Charts, graphs etc. Once the course is completed, you will be able to accomplish tasks associated with developing, formatting, modifying and using a spreadsheet of limited scope ready for distribution. The module will cover how to generate and apply standard mathematical and logical formulas using standard formulas and functions, and will include how to create and format graphs and charts.
The Spreadsheets course consists of 7 modules in which you will cover the following areas:
1. The Excel application: This lesson is divided into two topics. In the first topic, Working with spreadsheets, you will learn about workbooks and worksheets and the steps to create a new workbook. This topic will also introduce you to the steps to open, save and close the spreadsheet application. In addition, you will also learn to switch between open worksheets and spreadsheets. In the next topic Enhancing productivity, you will learn to set basic user preferences and use the Help function and the zoom or magnification tools. The topic will also discuss elements of the Excel ribbon, the steps to maximise or minimise the ribbon. Steps for displaying or hiding toolbars will also be explained in this topic.
- Working with spreadsheets
- Enhancing productivity
2. Cell basics: This lesson is divided into three topics. In the first topic, Working with cells, you will learn about the best practices for creating lists, such as inserting a blank rows and ensuring cell bordering lists are blank and so on. You will also be introduced to the step for selecting a cell, range of cells and range of adjacent and non-adjacent cells and selecting an entire worksheet. In the next topic, Editing and Sorting data in cells, you will learn to edit and modify existing cell content by using the redo, undo and replace commands. You will also learn to sort a cell range by alphabetical and numeric order and ascending and descending order. In the third and final topic of the lesson, Copying, moving and deleting data, you will learn how to copy and move the content of the cell and cell range within a worksheet.
- Working with cells
- Editing and sorting data in cells
- Copying, moving and deleting data
3. Managing worksheets: This lesson is divided into two topics. In the first topic, Rows and columns, you will learn to select, insert and delete rows and columns. You will also learn how to modify column widths and row heights to a specified value, and to optimal width or height. In the second topic, Worksheets you will learn how to switch between worksheets, insert a new worksheet and delete a worksheet. Lastly you will also learn to copy, move and rename a worksheet.
- Rows and columns
4. Formulae and functions: This lesson is divided into two topics. In the first topic, Arithmetic Formulae, you will learn about creating formulae, using cell references and arithmetic operators, and defining and identifying standard error values. You’ll also learn about the good practices for formula creation. In the second topic of the lesson, Working with functions you’ll learn to use various function such as sum, average, minimum, maximum, count, counta, round function and the logical function if.
- Arithmetic Formulae
- Working with functions
5. Formatting: This lesson is divided into three topics. In the first topic, Numbers and Dates, you will learn to format cells to display numbers with or without a separator to indicate thousands, and to a specific number of decimals. In addition, you’ll learn to format cells to display a date style and currency symbol. In addition to this, you will also learn the process for formatting cells to display numbers and percentages. In the next topic, Text formatting, you will learn to change cell content appearance by changing font sizes and types. In the third and final topic, Alignment, borders and effects, you will learn to apply text wrapping to contents within a cell or cell range. You’ll also learn to align cell contents horizontally and vertically and adjust cell content orientation. In addition, you’ll learn to merge cells and centre a title in a merged cell. Lastly, you’ll learn to add border effects to a cell or cell range with respect to lines and colours.
- Number and dates
- Text formatting
- Alignments, border and effects
6. Charts: This lesson is divided into two topics. In the first topic, Creating charts, you will learn to create different types of chars from spreadsheet data such as a column chart, bar chart, line chart and pie chart. You’ll also learn to select a chart, change the chart type and move, resize and delete a chart. In the next topic, Editing charts, you will learn to add, remove and edit a chart title and add data labels to a chart that includes values or numbers and percentages. In addition, you’ll learn to change chart area background colour, legend fill colour and the slice colours in a column bar, line and pie chart.
- Creating charts
- Editing charts
7. Prepare outputs: This lesson is divided into two topics. In the first topic, Customising worksheets, you will learn about customising worksheets by changing margins and orientation and adding and modifying headers and footers. In the second topic, Checking and printing worksheets, you will learn about checking textual errors and formulae inside worksheets and printing worksheets.
- Customising worksheets
- Checking and printing worksheets
This is an online self-learning and self-facilitated course only and in order to obtain a qualification, you must take and pass ECDL Exams. Please visit our BCS ECDL Extra Exams section for further information.
Successful candidates will gain ECDL Certificate in IT User Skills (QCF) Level 2 qualification.
The duration of this course will be 2 months from the day of enrolment. Learning account will be automatically closed on the end date regardless of the progress you have made.
Self-funded, self-learning and self-facilitated online Microsoft Word Module costs £60.
Please note that no refund will be offered under any circumstances
ECDL EXTRA EXAMS: Please note that the cost of taking the BCS ECDL Extra exams will be separate. Please visit BCS ECDL Extra Certificate section for further details.
FUNDED ECDL EXTRA PROGRAMME & EXAMS: Please note that Intech Centre also provides government funded IT Level 2 (ECDL Extra) programme where both the learning and exam will be funded, subject to eligibility criteria. Please visit our IT Level 2 (ECDL Extra) section for further details
To find out more about this course and to book an appointment with one of our advisers, please call us on 020 7354 5655.
Please be advised that full cost of the course must be cleared and you need to bring your Passport or Driving Licence for the enrolment.