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