Course Overview
Welcome to our Microsoft 365 Excel Online courseware. Excel Online is Microsoft’s cloud-based, easy-to-use spreadsheet program.
This course is intended to help all users get up to speed with Excel Online. We will cover:
- Getting started with the app
- Working with formulas and functions
- Formatting parts of a worksheet
- Using pictures, tables, charts, and PivotTables
- Finalizing workbooks
What you’ll learn
By the end of this course, users should be comfortable with creating a new spreadsheet, working with basic formulas and functions, and making a spreadsheet look professional and presentable.
Requirements
- This manual is designed for users who are comfortable using Windows and Microsoft Edge. Students should complete the first part of our Microsoft 365 courseware before beginning this course.
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
Instructor
