The Global Education Cluster’s Core Skills Course requires that all participants have a basic level of theoretical and practical knowledge and skills related to coordination prior to arriving to the face-to-face training.
We have therefore prepared FOUR modules with accompanying assignments to be completed and submitted according to the specified due dates.
Each module will contain a theory-based assignment as well as a practical, Information Management (IM)-based assignment.
To qualify to attend the face-to-face portion of this course, you must complete and submit all assignments in Modules 1-4 on time.
All assignments and assignment-related questions should be sent to the Education Cluster at ([email protected]).
Assignment: Review the lessons, walkthroughs, videos, and challenges in this module and then complete the Exercise at the end of the lesson. You can access the Exercise by clicking on 'Next' at the bottom of this page.
PLEASE NOTE: If you feel you have already mastered the skills described in a particular lesson within this module, feel free to SKIP IT. You must, however, complete and submit your completed Exercise.
1.1 Getting Started
Lesson 1.1.A: Navigate Excel
Lesson 1.1.B: Explore/customise your Excel environment
Lesson 1.1.C: Create and Open Workbooks
Challenge: Try completing 1.1 Challenge to try out your new skills
1.2 Cell Basics
Lesson 1.2.A: How to select cells, insert content, delete cells, delete cell content; cut, copy, and paste cells; drag and drop cells; fill cells using the fill handle.
Lesson 1.2.B: How to ‘Paste Special’ and ‘Paste Values’
Lesson 1.2.C: How to Paste a Word table into Excel
Challenge: Try completing 1.2 Challenge to try out your new skills
1.3 Modifying Columns, Rows and Cells
How to change row height and column width, insert and delete rows and columns, wrap text in a cell, and merge cells.
Challenge: Try completing 1.3 Challenge to try out your new skills
1.4 Freeze Panes
How to freeze rows and columns in your worksheet.
Lesson 1.4.A: Freeze the first row and the first column of your worksheet.
Lesson 1.4.B: Freeze more than just the first column and first row of your worksheet.
1.5 Formatting Cells
How to change the colour and style of text and cells, align text, and apply special formatting to numbers and dates.
Challenge: Try completing 1.5 Challenge to try out your new skills
1.6 Sorting Data
How to sort data to better view and organize the contents of your spreadsheet. Sorting is a common task that allows you to change or customize the order of your spreadsheet data.
Challenge: Try completing 1.6 Challenge to try out your new skills