Excel Intermediate 2013
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 0
- Certificate Yes
- Assessments Self
Read Instructions
Please read instructions below
Session One
PREPARE AND PRODUCE A SPREADSHEET TO PROVIDE A SOLUTION TO A GIVEN PROBLEM.
Session Two
ADJUST SETTINGS TO CUSTOMISE THE VIEW AND PREFERENCES OF THE SPREADSHEET APPLICATION TO SUITE THE SOLUTION CREATED FOR THE GIVEN PROBLEM.
- Toolbar menus are switched off and on. – Copy
- The view of the spreadsheet is enlarged and made smaller. – Copy
- The way that the spreadsheet is viewed is changed. – Copy
- Cells are frozen to prevent scrolling. – Copy
- The default file location is changed. – Copy
- A user name is added to the file. – Copy
- Excel Int Session 2 – 2013
- Excel 2 Quiz 2 – Copy
Session Three
WORK WITH MULTIPLE WORKSHEETS TO SUITE THE SOLUTION TO THE GIVEN PROBLEM.
- The purpose of using multiple worksheets within one spreadsheet file are explained with examples. – Copy
- New worksheets are opened. (Minimum 3 worksheets) – Copy
- Worksheets are renamed in terms of their purpose within the solution to the given problem. – Copy
- Cells are manipulated between worksheets. – Copy
- A worksheet within a workbook (or spreadsheet) is deleted. – Copy
- Excel Int Session 3 – 2013
- Excel 2 Quiz 3 – Copy
Session Four
APPLY FORMULAE TO WORKSHEETS TO PROVIDE ALTERNATIVE SOLUTIONS TO THE GIVEN PROBLEM.
- Formulae are entered taking into consideration the natural order of operation. – Copy
- Formulae are entered to deliberately change the natural order of operation. – Copy
- Formula error messages are correctly interpreted and the formula corrected accordingly. – Copy
- The difference between relative and absolute cell addressing is demonstrated by using it in a formula. – Copy
- Data are changed to test possible solutions to the given problem without having to change formulae. – Copy
- Scenarios are created that demonstrate different possible outcomes. – Copy
- Excel Int Session 4 – 2013
- Excel 2 Quiz 4 – Copy
Session Five
APPLY SIMPLE BUILT-IN FUNCTIONS OF THE SPREADSHEET APPLICATION TO THE GIVEN PROBLEM.
Session Six
APPLY FORMATTING TO A SPREADSHEET APPLICABLE TO THE GIVEN PROBLEM.
Session Seven
USE SPECIAL EFFECTS TO IMPROVE THE PRESENTATION OF THE SPREADSHEET.
Session Eight
EVALUATE A SPREADSHEET TO COMPLY WITH THE GIVEN PROBLEM.
- The spreadsheet is evaluated for compliance with a given problem, appropriate formatting, readability, legibility, presentation, accuracy, and data integrity. – Copy
- The spreadsheet is modified if required and compliance with the brief is confirmed. – Copy
- Excel Int Session 8 – 2013
- Excel 2 Quiz 8 – Copy
