Welcome To Excel Intermediate 2013. To view the course outline click on Curriculum Tab.
To enrol on a course click on the “Buy This Course”. If you have already registered, it will take you to the course, if not, it will redirect you to the learner registration page were you will be required to fill in your details and create your free account.
To start with your course click on Curriculum tab and Read Instructions that follow
Course Features
- Lectures 41
- Quizzes 8
- Students 4
- Assessments Self
Curriculum
- 10 Sections
- 41 Lessons
- 10 Weeks
Expand all sectionsCollapse all sections
- Read InstructionsPlease read instructions below1
- Session OnePREPARE AND PRODUCE A SPREADSHEET TO PROVIDE A SOLUTION TO A GIVEN PROBLEM.4
- Session TwoADJUST SETTINGS TO CUSTOMISE THE VIEW AND PREFERENCES OF THE SPREADSHEET APPLICATION TO SUITE THE SOLUTION CREATED FOR THE GIVEN PROBLEM.8
- 3.1Toolbar menus are switched off and on. – Copy30 Minutes
- 3.2The view of the spreadsheet is enlarged and made smaller. – Copy30 Minutes
- 3.3The way that the spreadsheet is viewed is changed. – Copy30 Minutes
- 3.4Cells are frozen to prevent scrolling. – Copy30 Minutes
- 3.5The default file location is changed. – Copy30 Minutes
- 3.6A user name is added to the file. – Copy1 Hour
- 3.7Excel Int Session 2 – 201330 Minutes
- 3.8Excel 2 Quiz 2 – Copy30 Minutes0 Questions
- Session ThreeWORK WITH MULTIPLE WORKSHEETS TO SUITE THE SOLUTION TO THE GIVEN PROBLEM.7
- 4.1The purpose of using multiple worksheets within one spreadsheet file are explained with examples. – Copy30 Minutes
- 4.2New worksheets are opened. (Minimum 3 worksheets) – Copy30 Minutes
- 4.3Worksheets are renamed in terms of their purpose within the solution to the given problem. – Copy30 Minutes
- 4.4Cells are manipulated between worksheets. – Copy30 Minutes
- 4.5A worksheet within a workbook (or spreadsheet) is deleted. – Copy30 Minutes
- 4.6Excel Int Session 3 – 201330 Minutes
- 4.7Excel 2 Quiz 3 – Copy30 Minutes0 Questions
- Session FourAPPLY FORMULAE TO WORKSHEETS TO PROVIDE ALTERNATIVE SOLUTIONS TO THE GIVEN PROBLEM.8
- 5.1Formulae are entered taking into consideration the natural order of operation. – Copy30 Minutes
- 5.2Formulae are entered to deliberately change the natural order of operation. – Copy30 Minutes
- 5.3Formula error messages are correctly interpreted and the formula corrected accordingly. – Copy30 Minutes
- 5.4The difference between relative and absolute cell addressing is demonstrated by using it in a formula. – Copy30 Minutes
- 5.5Data are changed to test possible solutions to the given problem without having to change formulae. – Copy30 Minutes
- 5.6Scenarios are created that demonstrate different possible outcomes. – Copy30 Minutes
- 5.7Excel Int Session 4 – 201330 Minutes
- 5.8Excel 2 Quiz 4 – Copy30 Minutes0 Questions
- Session FiveAPPLY SIMPLE BUILT-IN FUNCTIONS OF THE SPREADSHEET APPLICATION TO THE GIVEN PROBLEM.5
- 6.1Functions are explained in terms of their purpose, use and construct. – Copy30 Minutes
- 6.2Simple Mathematical functions are applied to the given problem. – Copy30 Minutes
- 6.3Statistical functions are applied that achieve the anticipated result. – Copy30 Minutes
- 6.4Excel Int Session 5 – 201330 Minutes
- 6.5Excel 2 Quiz 5 – Copy30 Minutes0 Questions
- Session SixAPPLY FORMATTING TO A SPREADSHEET APPLICABLE TO THE GIVEN PROBLEM.6
- 7.1Methods of automatically formatting a spreadsheet are explained. – Copy30 Minutes
- 7.2A spreadsheet is created using a template. – Copy1 Hour
- 7.3Cells are formatted using styles. – Copy30 Minutes
- 7.4Formats are copied between cells. – Copy30 Minutes
- 7.5Excel Int Session 6 – 201330 Minutes
- 7.6Excel 2 Quiz 6 – Copy30 Minutes0 Questions
- Session SevenUSE SPECIAL EFFECTS TO IMPROVE THE PRESENTATION OF THE SPREADSHEET.6
- 8.1Text is centered across a cell range. – Copy30 Minutes
- 8.2Orientation of text within a cell is changed. – Copy30 Minutes
- 8.3A border is applied to cells and removed from cells. – Copy1 Hour
- 8.4Fill (shading) is applied to cells and removed from cells. – Copy30 Minutes
- 8.5Excel Int Session 7 – 201330 Minutes
- 8.6Excel 2 Quiz 7 – Copy30 Minutes0 Questions
- Session EightEVALUATE A SPREADSHEET TO COMPLY WITH THE GIVEN PROBLEM.4
- 9.1The spreadsheet is evaluated for compliance with a given problem, appropriate formatting, readability, legibility, presentation, accuracy, and data integrity. – Copy30 Minutes
- 9.2The spreadsheet is modified if required and compliance with the brief is confirmed. – Copy30 Minutes
- 9.3Excel Int Session 8 – 201330 Minutes
- 9.4Excel 2 Quiz 8 – Copy30 Minutes0 Questions
- Excel Intermediate Portfolio of Evidence (POE)1
