Welcome to our training for our Sports Coaches!! Your friendly ITEs will be guiding you through your workshop topics. Have some fun!

The criteria for the Excel Badge are as follows:

Please make sure that you can do ALL of the items below. If you can't do it, please ask your friendly ITE for support. You have to be able to:

• Launch MS Excel
• Create a new workbook.
• Type text or numbers into a cell.
• Basic formula use (add, subtract, divide and
• multiply)
• Can resize columns and rows.
• Able to zoom in and out
• Able to select a cell, copy and paste or move it.
• Able to select a range of cells, copy and paste or move them.
• Open a recently used document.
• Print a document - fit entire worksheet on one page.
• Print a worksheet - fit all columns on one page.
• Save the workbook.
• Close MS Excel.
• All basic skills, including:
  • Place borders around a cell or range of cells.
  • Shade a cell or a range of cells.
  • Can use the Autofill feature.
  • Change font type, size and colour.
• Can use the following functions:
  • SUM, AVERAGE, MAX, MIN, COUNT
• Can use the apostrophe to prevent cells doing automatic date/time/dropped zero.
• Print/Export to PDF.
• Uses cell references instead of typing in values.
• Can sort a column, or range, numerically or alphabetically.
• Knows at least three keyboard shortcuts for MS Excel.
• Can access Help within Excel.
• Understands the differences between the various number, date and currency formats in the ‘Number’ group on the ribbon.

Activity 1: Performance of Excel Workthrough

Before diving into formatting and formulas, let’s get familiar with the Excel layout: rows, columns, and cells — the building blocks of every spreadsheet.

Instructions:

Step 1

• Open up an Excel workbook (How?)
• Save the spreadsheet under your name (File--> Save as--> KSA_YourNameYourSurname.xlsx)
• The part behind the file name tells us that it is an Excel spreadsheet (.xlsx)
• Are we ready? Let's go!

Step 2

• In A1, type:
  "Coach Performance Tracker – Rugby & Soccer"
  • Font size: 20
  • Font: Bold
  • Fill color: Light Green
  • Merge across columns A1:E1
  • Center-align

Step 3

• In Row 2, enter these headers:

A	B	C	D	E
Coach Name	Sport	Matches Coached	Players Trained	Years of Experience

Step 4
Apply formatting:

• Bold the column headers
• Fill color: Light Grey
• Font Size: 14

Enter Data (Example)

Coach Name	Sport	Matches Coached	Players Trained	Years of Experience
Rasie	Rugby	12	18	5
Tito	Soccer	15	22	3
Bill	Soccer	10	16	4
Tiny	Rugby	18	20	6

Step 5
Learn & Apply Formulas

In Row 8, label it as Totals / Stats

A8: "Totals/Stats" | leave blank | use formulas below

• Borders: All Borders around the table

Formulas:

• Total Matches Coached → =SUM(C3:C6)
• Average Players Trained → =AVERAGE(D3:D6)
• Most Experienced Coach → =MAX(E3:E6)
• Least Experienced Coach → =MIN(E3:E6)

Activity 2: Greenpoint Stadium Fever

Step 1
Set Up Your Excel Worksheet

1. Open Excel and create a new worksheet.
2. In Cell A1, type:
   "Springboks vs Barbarians Budget"
   • Font: Size 20, Bold
   • Fill color: Green
   • Merge & Center across columns A to F

Step 2
Enter Column Headers in Row 2

1. Format Row 2 (Headers):
   • Font: Size 18, Bold
   • Fill color: Yellow

A	B	C	D	E	F
Item	Vendor 1 Price	Vendor 2 Price	Average Price	Difference	Chosen Price

Step 3
Add Your Budget Items

Under the Item column, list:

Font: Size 16, Bold

Under the Item column, list:

• Transport
• Accommodation
• Supporter Shirt
• Food and Drinks
• Match Tickets

For each item:

• Enter prices from two vendors

Choose the best price and enter it in the "Chosen Price" column

Step 4
Apply Formulas

Difference (E3):
=B3-C3 (Shows if you saved or overspent)

Average Price (D3):
=AVERAGE(B3:C3)

Drag both formulas down for all rows.

Overall Avg Price (D9):
=AVERAGE(F3:F7)

Total Difference (E9):
=SUM(E3:E7)

Total Chosen Price (F9):
=SUM(F3:F7)

Step 5
Apply Borders

Apply All Borders around the table from A2 to F7

Step 6
 Set Currency Format

Select Columns B to F
→ Go to Home → Number Format → Currency (R)

Step 7
 Vendor Information Table

• Scroll to Cell A11, create this mini-table:

Item	Vendor 1 Name	Vendor 2 Name
Transport
Accommodation
Supporter Shirt
Food and Drinks
Match Tickets

• Add borders to match your main table.

Step 8
 Save & Review

• Save your file as:
  KSA_YourNameYourSurname.xlsx

Activity 3: GCF Excel Wrap-Up Challenge

1. Complete the excel GCFGlobal course.
2. Save it in your POE folder with the file name excelbadge_YournameYoursurname.pdf e.g. excelbadgeMaggieVerster.pdf. (Upload your certificate to your school (teacher) folder (ask your ITE for the POE link).
3. Create an email and attach your certificate to the email.
4. Make sure that you use the relevant formal email etiquette.
5. Send the email to:
   • admin.ksa@kilt.org.za and cc Sheveque (sheveque@kilt.org.za)