COURSE DESCRIPTION:
Students learn how to create and manipulate spreadsheets using Microsoft Excel, a platform where they can organize, analyze and present all kinds of data. The course is focused on the creation of neat-looking workbooks with colors and tables. Also, students learn how to calculate additional data from inputs, and how the results change when inputs are changed. For the duration of the course, students will learn a few topics within basic science & math, and will use them as motivation for the development of an Excel application as a final project.
CERTIFICATION:
MS Excel: Level I.
LEARNING OUTCOMES:
How to create colorful presentations using Excel worksheets.
How to fill text and numbers in a worksheet and how to modify them using formulas and formats.
How to create tables and how to format them.
How to use formulas with numbers, and how to create conditions in workbooks.
How to apply conditional formatting to tables.
Course Features
- Lectures 13
- Quizzes 1
- Duration 12 weeks
- Skill level All levels
- Language English
- Students 0
- Certificate No
- Assessments Yes
Curriculum
- 12 Sections
- 13 Lessons
- 12 Weeks
- CLASS 1 - EXCEL BYTEStudents learn how to create a workbook, the basic Excel interface and how to load and save documents.1
- CLASS 2 - EXCEL BYTEStudents learn about data entry and practice with a fun data set.1
- CLASS 3 - EXCEL BYTEStudents use the calculator and basic math functions.1
- CLASS 4 - EXCEL BYTEStudents combine and align cells and learn about number formatting.1
- CLASS 5 - EXCEL BYTEStudents create tables and pie charts.1
- CLASS 6 - EXCEL BYTEStudents learn about simple division and primitive decimal numbers and their formatting.1
- CLASS 7 - EXCEL BYTEStudents learn about conditionals and conditional formatting1
- CLASS 8 - EXCEL BYTEStudents brainstorm Project ideas and draw out their development plan.1
- CLASS 9 - EXCEL BYTEStudents learn to use more functions like if, count, etc. Students keep working on their projects3
- CLASS 10 - EXCEL KILOBYTEStudents keep developing their final project and learn to format plots.1
- CLASS 11 - EXCEL BYTECorrections and quality checks on project.1
- CLASS 12 - EXCEL BYTEStudents complete project and present.2
