Curriculum
- 1 Section
- 7 Lessons
- 1 Day
Expand all sectionsCollapse all sections
- Topics7
- 1.1Getting Started In the first lesson, students will learn how to identify the components of the Excel Online interface as well as some Excel terminology and how to navigate the app. We also take a look at the basic options for managing workbooks and how to get help in Excel Online.
- 1.2Working with Data Next, we explore how to use formulas and functions, how to work with data, rows, and columns, and how to sort and filter data.
- 1.3Formatting a Worksheet Then, we teach students how to format text and cells, align cell contents, use find and select tools and how to apply, customize and clear conditional formatting.
- 1.4Adding Pictures and Shapes In this lesson, students will focus on how to insert, rotate, resize, and delete pictures and how to insert and format shapes.
- 1.5Organizing Worksheet Data with Tables and Charts Next, we take a look at how to create and customize tables, how to insert charts and customize them to ensure data is displayed properly.
- 1.6Using Pivot-Tables Then, we will teach students how to insert PivotTables, work with PivotTable data and how to sort and filter that data.
- 1.7Finalizing Workbooks In the final lesson, we cover how to insert, edit, and delete comments. Creating and customizing additional worksheets, and some of the ways to customize the view options of each workbook are also discussed
Adding Pictures and Shapes In this lesson, students will focus on how to insert, rotate, resize, and delete pictures and how to insert and format shapes.
Prev
Using Pivot-Tables Then, we will teach students how to insert PivotTables, work with PivotTable data and how to sort and filter that data.
Next