ICT Spreadsheet Essentials

Hours: 8 / Access Length: 12 Months / Delivery: Online, Self-Paced

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 Requirements:

• Cable, Fiber, DSL, or LEO Satellite (i.e. Starlink) internet with speeds of at least 10mb/sec download and 5mb/sec upload are recommended for the best experience.

NOTE: While cellular hotspots may allow access to our courses, users may experience connectivity issues by trying to access our learning management system.  This is due to the potential high download and upload latency of cellular connections.   Therefore, it is not recommended that students use a cellular hotspot as their primary way of accessing their courses.

Hardware Requirements:

• CPU: 1 GHz or higher
• RAM: 4 GB or higher
• Resolution: 1280 x 720 or higher.  1920x1080 resolution is recommended for the best experience.
• Speakers / Headphones
• Microphone for Webinar or Live Online sessions.

Operating System Requirements:

• Windows 7 or higher.
• Mac OSX 10 or higher.
• Latest Chrome OS
• Latest Linux Distributions
  

NOTE: While we understand that our courses can be viewed on Android and iPhone devices, we do not recommend the use of these devices for our courses. The size of these devices do not provide a good learning environment for students taking online or live online based courses.

Web Browser Requirements:

• Latest Google Chrome is recommended for the best experience.
• Latest Mozilla FireFox
• Latest Microsoft Edge
• Latest Apple Safari

Basic Software Requirements (These are recommendations of software to use):

• Office suite software (Microsoft Office, OpenOffice, or LibreOffice)
• PDF reader program (Adobe Reader, FoxIt)
• Courses may require other software that is described in the above course outline.