title
Please take a moment to fill out this form. We will get back to you as soon as possible.
All fields marked with an asterisk (*) are mandatory.
Microsoft 365 Excel: Online
Duration
1 Day
Course
VS-mos6032
Available Formats
Classroom Training, Online Training
Course Description
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
Objectives
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.
Prerequisites
-
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.
Topics
Getting 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.
- Next, we explore how to use formulas and functions, how to work with data, rows, and columns, and how to sort and filter data.
- 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.
- In this lesson, students will focus on how to insert, rotate, resize, and delete pictures and how to insert and format shapes.
- 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.
- Then, we will teach students how to insert PivotTables, work with PivotTable data and how to sort and filter that data.
- 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.
Related Courses
-
Microsoft 365 Fundamentals
MOC-MS-900T01- Duration: 1 Day
- Delivery Format: Classroom Training, Online Training
- Price: 595.00 USD
-
Microsoft® Office 365™ Online (with Skype® for Business) note: for Office 2013, 2016, or later
LO-091029- Duration: 1 Day
- Delivery Format: Classroom Training, Online Training
- Price: 595.00 USD
Self-Paced Training Info
Learn at your own pace with anytime, anywhere training
- Same in-demand topics as instructor-led public and private classes.
- Standalone learning or supplemental reinforcement.
- e-Learning content varies by course and technology.
- View the Self-Paced version of this outline and what is included in the SPVC course.
- Learn more about e-Learning
Course Added To Shopping Cart
bla
bla
bla
bla
bla
bla
Self-Paced Training Terms & Conditions
??spvc-wbt-warning??
Exam Terms & Conditions
??exam-warning??
??group-training-form-area??
??how-can-we-help-you-area??
??personalized-form-area??
??request-quote-area??
Sorry, there are no classes that meet your criteria.
Please contact us to schedule a class.
STOP! Before You Leave
Save 0% on this course!
Take advantage of our online-only offer & save 0% on any course !
Promo Code skip0 will be applied to your registration
Nothing yet
Purchase Information
??elearning-coursenumber?? ??coursename??
View Cart
title
Please take a moment to fill out this form. We will get back to you as soon as possible.
All fields marked with an asterisk (*) are mandatory.