Excel 365

Microsoft Excel 365 Level 1 Bundle

R450.00 Ex.VAT 15%

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.

Available!

Microsoft Excel 365: Level 1: 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.

Microsoft Excel 365: Level 1: Working with Data

This course introduces you to many different aspects of working with data, beginning with a look at formulas and functions. You will then look at working with data as a whole and managing rows and columns. Finally, you will learn how to customize data display with sort and filter.

Microsoft Excel 365: Level 1: Formatting a Worksheet

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

Microsoft Excel 365: Level 1: Adding Pictures and Shapes

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

Microsoft Excel 365: Level 1: Organizing Worksheet Data with Tables and Charts

In this course, learn how to organize worksheet data with tables and charts. With these tools, you will learn more about your data.

Microsoft Excel 365: Level 1: Using Pivot-Tables

This course teaches about PivotTables — inserting, modifying, and using PivotTables, along with sorting and filtering PivotTable data.

Microsoft Excel 365: Level 1: Finalizing Workbooks

In this course, you will learn about finalizing workbooks, including the use of comments, managing worksheets, and changing view options.

Return to Store

Getting Started
The first module 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 module, 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 module 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 module, students will learn all about comments and how to manage multiple worksheets.

Certificate: Certificate of completion will be issued once course is completed.
Duration: 6 Hours

 

Not found