Excel 365

Microsoft Excel 365 Level 1 and 2 Bundle

R799.00 Ex.VAT 15%

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.

Microsoft Excel 365: Level 2: Analyzing Data with Logical and Lookup Functions

In this course, students will learn how to use text functions to manage and manipulate text, as well as date functions to return date information. Additionally, they will learn about the many different financial functions that are available and how they operate.

Microsoft Excel 365: Level 2: Organizing Worksheet Data with Tables

This course covers how to create, format, and modify tables. We also cover using structured references, as well as the subtotal and database functions.

Microsoft Excel 365: Level 2: Visualizing Data with Charts

Students will learn about the wide variety of charts that are available and how to insert them. They will also learn about the best way to modify and format charts.

Microsoft Excel 365: Level 2: Enhancing Workbooks

In this course, customizing workbooks using comments, hyperlinks and pictures are covered. We also go over modifying worksheets using the accessibility checker, managing fonts, and how to add alternative text to objects.

Return to Store
Not found