Microsoft Excel 365 Part 1

Microsoft Excel 365 Part 1

SKU: MOS6002

Microsoft Excel 365 Part 1 for a Single Unique User Course (Online subscription only)

 

Course Outline

Excel 365 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 365 Online.

 

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.

 

Getting Started

The first lesson covers logging into Office 365 and Excel Online as well as how to navigate in the app. Students will learn how to open, save, share and print workbooks as well as how to use a few different help tools.
 

Working with Data

Next, we go over the basics of Excel formulas and functions and we introduce you to a few tools and techniques that can be used when working with formulas. Other topics covered in this lesson are how to modify rows and columns and, how to sort and filter data.
 

Formatting a Worksheet

In this lesson, students will learn how to format text and cells, align cell contents, use find and select tools and, how to apply conditional formatting.
 

Adding Pictures and Shapes

Next, students will learn how to insert and modify pictures and also how to insert and format shapes.
 

Organizing Worksheet Data with Tables and Charts

This lesson covers how to create and customize tables in an Excel document. Students will also learn how to insert charts and perform some basic tasks with them.

 

Using PivotTables

Students will learn what a PivotTable is and how to create one. They will also learn how to manipulate PivotTable data as well as how to sort and filter it.
 

Finalizing Workbooks

In the final lesson, students will learn all about comments and how to manage multiple worksheets.

    $325.00 Regular Price
    $81.25Sale Price
    V & Co..png 2.png
    • Luis Vizcarrondo LinkedIn page
    • Luis Vizcarrondo Facebook page

    © 2019 Vizcarrondo & Company LLC. Designed and developed by Smartners Business Services