This seminar is for people who need to create and edit spreadsheets using a Graphical User Interface (GUI)-based spreadsheet application either as a user of computers or as basic knowledge for a career needing this competency, like the ICT industry.
The Microsoft Basic Excel Training course intended to provide learners with the knowledge and skills in:
• Demonstrating an understanding of the principles of spreadsheets.
• Create, open and save spreadsheets.
• Produce a spreadsheet from a given specification.
• Edit a spreadsheet.
• Format a spreadsheet.
• Check spelling in a spreadsheet.
• Print a spreadsheet using features specific to spreadsheets.
Course Outline
MODULE 1: DEMONSTRATE AN UNDERSTANDING OF THE PRINCIPLES OF SPREADSHEETS.
• Spreadsheet is defined in terms of its purpose and use.
• Examples of spreadsheets that can be produced using a spreadsheet application are provided.
• The benefits of using a spreadsheet application for producing and working with spreadsheets are explained.
• Examples of spreadsheet programs are named.
MODULE 2: CREATE, OPEN AND SAVE SPREADSHEETS.
• The spreadsheet application program is opened.
• A new spreadsheet is created
• Methods of moving the cell cursor are demonstrated in order to move about the spreadsheet.
• The spreadsheet is saved with a specific name in a specific folder.
• The spreadsheet is closed.
• Formula are entered to achieve the given specification
• The differences between data cells, label cells, and formula cells are explained.
• The spreadsheet is in accordance with the given specifications.
MODULE 3: EDIT A SPREADSHEET
• An existing spreadsheet is opened
• Cells are selected for manipulation and de-selected.
• Use the automatic fill feature to automatically enter data in cells.
MODULE 4: FORMAT A SPREADSHEET.
• Cells are formatted using formatting features of the spreadsheet application.
• Columns and rows are formatted.
MODULE 5: PRINT A SPREADSHEET USING FEATURES SPECIFIC TO SPREADSHEETS.
• The printing of gridlines is altered.
• Different ways of printing sheets within a spreadsheet are demonstrated, according to given specifications
MODULE 6: PREPARE AND PRODUCE A SPREADSHEET TO PROVIDE A SOLUTION TO A GIVEN PROBLEM.
• An outline solution is developed to meet the requirements of a given brief.
• The spreadsheet produced addresses the given problem.
MODULE 7: 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
• The view of the spreadsheet is enlarged and made smaller.
MODULE 8: USE SPECIAL EFFECTS TO IMPROVE THE PRESENTATION OF THE SPREADSHEET
• Text is centered across a cell range
• Fill (shading) is applied to cells and removed from cells.
MODULE 9: 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.
• The spreadsheet is modified if required and compliance with the brief is confirmed
MODULE 10: CREATE AND EDIT A GRAPH
• The major graph types are defined in terms of their purpose.
• A graph is created from a given data source.
MODULE 11: LOAD DATA FROM AN EXTERNAL DATA SOURCE TO PRODUCE A GIVEN SPREADSHEET RESULT.
• The external data file is checked to ensure that the input into a spreadsheet will achieve the required results.
• The format of the input file is determined to ensure correct input into a spreadsheet.
• The resulting spreadsheet is in accordance with the given spreadsheet result.
MODULE 12: INSERT AND EDIT OBJECTS INTO A SPREADSHEET.
• An object is inserted into a spreadsheet.
• A selected object is manipulated in a spreadsheet.
• Use a drawing tool to draw an object in the spreadsheet.