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
1.7 Filtering Data
How to filter the data in your worksheet to display only the information you need. Filters can be used to narrow down the data in your worksheet and hide parts of it from view.
Challenge: Try completing 1.7 Challenge to try out your new skills
1.8 Formatting Tables
How to format your data as a table in Excel. Here are ten reasons why it is a good idea format your data as a table.
Challenge: Try completing 1.8 Challenge to try out your new skills
How to use the Save and Save As commands, save as an Excel 97-2003 compatible workbook, and save as a PDF.
Challenge: Try completing 1.9 Challenge to try out your new skills
Your Cluster has been provided with a very ugly contact list in Word. After recovering from almost fainting at the fact that people are still creating contact lists in Word, you decide to clean up the list and put it into an Excel database.
Using the skills learned in the various lessons of Module 1, follow the steps below to create a shiny, beautiful database in Excel.
Watch this video if you would like to receive step-by-step guidance on how to complete the following exercise.