ICT Spreadsheet Essentials

Hours: 8 / Access Length: 12 Months / Delivery: Online, Self-Paced
Online Hours: 8
Retail Price: $104.00

Course Overview:

The ICT Spreadsheet Essentials course focuses on fundamentals of creating and using spreadsheets.

In this course, students will:

  • Learn about the purpose of spreadsheets
  • Identify spreadsheet elements
  • Learn how to insert, format, copy and move cell data, and format columns and rows
  • Create tables and charts, and modify chart elements according to the spreadsheet data
  • Learn functions, formulas and conditional formatting

Course Outline:

Lesson 1: Introduction to Spreadsheet
  • Spreadsheet Basics
  • Creating and Managing Spreadsheet Data
  • Sorting and Filtering Spreadsheet Data
  • Formatting Cells, Columns and Rows
  • Printing Your Spreadsheet
Lesson 2: Working with Charts
  • Utilizing Spreadsheet Charts
Lesson 3: Working with Formulas and Functions
  • Using Common Spreadsheet Formulas
  • Exploring Common Spreadsheet Functions
  • Working with Conditional Formatting

All necessary course materials are included.


System Requirements:

Internet Connectivity

  • Connection Type: Broadband (Cable, Fiber, DSL) or LEO Satellite (e.g., Starlink)
  • Minimum Speed: 10 Mbps download / 5 Mbps upload

Note: While cellular hotspots may allow basic access, high latency and fluctuating speeds can cause disconnects during videos, quizzes, or live sessions. Cellular hotspots are not recommended as a primary connection.

Hardware

  • Processor: Dual-core 2.0 GHz or higher
  • Memory (RAM): 8 GB or higher (4 GB minimum)
  • Display Resolution: 1280 x 720 minimum (1920 x 1080 recommended)
  • Audio/Video: Speakers or headphones; microphone and webcam (recommended for Live Online sessions)

Operating Systems

  • Windows: Windows 10 or Windows 11
  • Mac: macOS 13 (Ventura) or newer
  • ChromeOS / Linux: Latest supported release

Note: While courses may load on iOS and Android devices, phones and small tablets are not recommended. Their smaller screen sizes and mobile browsers do not provide an optimal environment for coursework or live online sessions.

Web Browsers

  • Google Chrome (Latest version — Recommended)
  • Mozilla Firefox (Latest version)
  • Microsoft Edge (Latest version)
  • Apple Safari (Latest version)

Tip: Ensure JavaScript and cookies are enabled, and pop-up blockers are disabled for the learning portal.

Recommended Software

The following software is recommended for viewing and completing general course materials (individual courses may require additional software as noted in the course outline above):

  • Productivity Suite: Microsoft 365/Office, Google Workspace, or LibreOffice
  • PDF Reader: Adobe Acrobat Reader, Foxit PDF Reader, or a built-in browser PDF viewer


** The course outlines displayed on this website are subject to change at any time without prior notice. **