2019 Feature updates

Microsoft Office 365 Bundle

R4,599.00 Ex.VAT 15%

Available!

Microsoft Office 365 2019 Feature Updates

This course is intended to help users of Office 365 understand feature updates made in 2019. It focuses on five Office 365 offerings — Word (word processing), Excel (spreadsheets), PowerPoint (presentations), Outlook (email and calendars), and Access (databases). By the end of this course, users should be comfortable using the new features of Word, Excel, PowerPoint, Outlook, and Access that were released in 2019 for the desktop version of Microsoft Office 365.

Microsoft Outlook 365: Level 1: Getting Started With Outlook 365

Microsoft Office Outlook 365 is a powerful and easy-to-use email client and scheduling manager. Outlook is used in many organizations worldwide and it has become one of the most commonly used email client software products on the market. While the incredible number of features that are available in this latest version of Outlook may seem daunting at first, once we cover the basics of working with it, you will be well on your way to becoming an Outlook master.

In this course, students will learn how to navigate the Outlook interface, perform basic e-mail functions, and use Outlook help (including the new Tell Me feature).

Microsoft 365 Outlook Level 1: Composing Messages

This module covers how to create an e-mail message, check spelling and grammar, and format message content. Then, students will learn about email attachments, enhancing messages, and managing automatic message content.

Microsoft 365 Outlook Level 1: Reading and Responding to Messages

Outlook 365 includes several different ways to read messages that you receive. While the default settings may work for most people, being familiar with all the available reading methods can come in handy. In this unit, you will learn how to customize reading options, work with attachments, and manage message responses.

Microsoft 365 Outlook Level 1: Managing Your Messages

As you continue to use Outlook 365 to manage emails, you may find that your inbox will quickly fill up. Without any way to differentiate important messages or identify messages that require follow-up, you can waste a lot of time. In this unit, you will learn about the various features in Outlook 365 that you can use to manage messages, using tags, flags, and other commands, as well as organizing messages using folders.

Microsoft 365 Outlook Level 1: Managing Your Calendar

The Calendar workspace provides you with a complete calendar as well as scheduling tools to help you schedule and view upcoming appointments and events. In this unit, you will learn about the calendar in Outlook and the various ways that you can view and print it, as well as how to view and print the calendar, as well as how to manage appointments and meetings.

Microsoft 365 Outlook Level 1: Managing Your Contacts

As the core functionality of Outlook 365 revolves around communication and interaction with other people, saving and managing contact information is very important. In this unit, you will learn all about contacts in Outlook 365, including how to manage them and how to import them from other sources.

Microsoft 365 Outlook Level 1: Working with Tasks and Notes

Outlook not only provides a central place to keep your messages, calendar, and contacts organized; it also gives you the ability to schedule and manage tasks. For example, if you need to review a presentation by a specific date, you can create a task that will remind you to do just that. In this unit, you will learn all about tasks and how to create them. This module is all about managing tasks and notes.

Microsoft 365 Outlook Level 1: Customizing the Outlook Environment

This course covers how to customize the Outlook interface, as well as creating and managing Quick Steps.

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.

Microsoft Word 365: Level 1: Getting Started with Word

In this course, you will become familiar with the components of the Microsoft Word interface, how to create a Word document and use document views, and how to get help in Microsoft Word

Microsoft Word 365: Level 1: Editing a Document

This course introduces you to editing a document, including navigating through a document; selecting and modifying text; and finding and replacing text.

Microsoft Word 365: Level 1: Formatting Text And Paragraphs

Character formatting, aligning text using tabs, displaying text as list items and, controlling paragraph layout are covered in this lesson. In addition to these formatting tools, students will learn how to apply borders, shading, and styles to a document. The module wraps up with how to use the Reveal formatting task pane, clearing formatting from text and how to find and replace formatting.

Microsoft Word 365: Level 1: Adding Tables

Students will then learn how to insert, modify and form tables. Then, how to use the Converting Text to Table and Converting Table to Text dialog boxes are covered.

Microsoft Word 365: Level 1: Managing Lists

Learn how to manage lists to present text more effectively. Sorting lists, renumbering lists, and customizing list appearance are covered.

Microsoft Word 365: Level 1: Adding Graphics

This course teaches about adding graphics to a Word document, which involves inserting symbols and special characters, and adding images and other media.

Microsoft Word 365: Level 1: Proofing a Document

This course entails proofing documents: students will learn about some of the tools on the Review tab, including spell check, the thesaurus, the translator, and word count. The Researcher, Smart Lookup, the Research Options dialog box and, how to use the Accessibility Checker are also looked at.

Microsoft Word 365: Level 1: Advanced Topics

In this course, advanced topics will be covered, such as customizing the Word interface, setting additional save options, and managing supplementary file types.

Microsoft Word 365: Level 2: Working with Tables and Charts

In this module, students will learn about various ways to manage numerical data in Microsoft Word. We take a look at how to sort table data, control cell layout, perform calculations in a table, and how to display numerical data as a chart or equation.

Word 365: Level 2: Using Styles and Themes

In this course, we cover how to create and modify text styles, create styles for lists and tables, and then we will apply and customize document themes.

Microsoft Word 365: Level 2: Using Images in a Document

Students will learn all about working with images in a document in this lesson. The lesson wraps up with information on integrating pictures and text and adding supplementary items to a document, such as screenshots, videos, and captions.

Microsoft Word 365: Level 2: Creating Custom Graphic Elements

Several other types of graphics are discussed in this module, including text boxes, shapes, WordArt, and SmartArt.

Microsoft Word 365: Level 2: Inserting Content Using Quick Parts

This module takes a closer look at Building Blocks, particularly Quick Parts and fields.

Microsoft Word 365: Level 2: Using Templates

Microsoft Word provides hundreds of pre-designed documents called templates, which can be used to create letters, brochures, and reports. You can add your own information to these documents, and have a completed file within minutes. In this topic, we will learn all about this useful tool.

Microsoft Word 365: Level 2: Controlling Text Flow

The four main techniques for controlling text flow are discussed in this module: setting paragraph options, using section breaks, formatting text as columns, and linking text boxes.

Microsoft Word 365: Level 2: Using Mail Merge

This course begins by discussing simple mail merges, moves on to creating envelopes and labels, and finishes by learning how to create a data source from scratch.

Microsoft Word 365: Level 2: Using Macros

If you frequently use the same series of commands over and over, you might want to consider creating a macro to save time and reduce errors. In their simplest form, macros may be thought of as several commands grouped together. This lets you perform an entire series of actions just by performing a single command. Learn how to automate tasks using macros.

 

Microsoft Access 365: Level 1: Getting Started with Access

In this course, students will learn how to get started with Microsoft Access, along with the components that are included in a database, such as opening and creating basic databases, as well as creating simple forms. They will also become familiar with the various objects that make up a database and how to use database templates.

Microsoft Access 365: Level 1: Working with Table Data

This course focuses on working with table data, how to modify data within a table, as well as how to sort and filter those records, we will also take a look at creating lookup fields to enhance the integrity of your data.

Microsoft Access 365: Level 1: Query a Database

This course examines how to query a database: joining data from different tables into a query, sorting and filtering data in a query, and performing calculations in a query.

Microsoft Access 365: Level 1: Create Advanced Queries

In this course, learn how to create advanced queries (parameter and action queries), along with summarizing data.

Microsoft Access 365: Level 1: Generate Reports

In this course, students will learn about reports and how they are used to display data in a more readable fashion. They will become comfortable creating basic reports, as well as adding controls to them. Also, changing the theme that a report uses, and preparing a report to be printed are covered.

Microsoft Access 365: Level 1: Design a Relational Database

Students will become familiar with the planning processes that must be followed to successfully create a database. The fundamentals of database design with a focus on relational databases, how to create tables, manage fields, and create relationships between fields in various tables are also taught.

Microsoft Access 365: Level 1: Joining Tables

Joining tables is the subject of this course, with lessons on creating query joins and working with subdatasheets and subqueries.

There are many ways that you can join tables and their contained data. In this lesson, creating basic query joins, as well as joining tables that do not have a common field are covered. Students will become comfortable working with self-joins, subdatasheets and,  also creating basic subqueries using SQL.

Microsoft Access 365: Level 1: Importing and Exporting Data

There are many ways that you can share Access data with other applications and export into a variety of different formats are covered. Exporting data as Excel files and text files, creating a basic mail merge, as well as importing data into Access are also covered.

Microsoft Access 365: Level 2: Implementing Advanced Form Design

This course takes a look at several topics to increase your students’ knowledge of Access 365. Here, students will learn how to add controls to forms, set form controls, create subforms, Organize Information with Tab Pages, Enhance Navigation with Forms, Format a Form, and Apply Conditional Formatting.

Microsoft Access 365: Level 2: Using Data Validation

In this course, the focus switches to data validation. Covered here is field validation along with form and record validation.

Microsoft Access 365: Level 2: Using Macros to Improve User Interface Design

This course turns to macros and using them to improve user interface design. Students will learn to create basic macros that use actions, conditions, arguments, and events to complete a task. They should also be able to create macros that complete basic validation and automation tasks, as well as convert existing macros to VBA.

Microsoft Access 365: Level 2: Using Advanced Database Management

Some advanced database management skills come under scrutiny in this course. Topics in this course teach students how to: link tables to external data sources, manage a database, determine object dependency, document a database, and analyze the performance of a database.

Microsoft Access 365: Level 2: Distributing and Securing a Database

In this course, students will learn about the many ways that you can distribute and secure a database. Topics covered are splitting a database, as well as implementing many of the security strategies that are available in Access. Students should feel comfortable converting a database into the ACCDE format and be able to package and digitally sign a database for distribution.

Microsoft Access 365: Level 2: Managing Switchboards

This course is all about switchboards. Students are taught how to create a database switchboard, how to modify a database switchboard, and how to set startup options.

Microsoft PowerPoint 365: Level 1: Getting Started

Students will learn how to log into Office 365 and launch PowerPoint before delving into how to create, edit and view presentations. Using Tell Me and how to access advanced help options are also covered.

Microsoft PowerPoint 365: Level 1: Developing a PowerPoint Presentation

This course covers the key steps in developing a PowerPoint presentation: selecting a presentation type, building the presentation itself, laying out the presentation, editing text, and viewing and navigating the presentation.

Microsoft PowerPoint 365: Level 1: Working with Images and Shapes

This Microsoft PowerPoint 365 course examines how to insert graphics; modify and format objects; and adjust image appearance.

Microsoft PowerPoint 365: Level 1: Working with SmartArt

In this module, students will learn about SmartArt and how versatile it is. They will become familiar with building and customizing a SmartArt diagram, creating modifying and editing.

 

Microsoft PowerPoint 365: Level 1: Working with Tables

Students will then learn how to add tables to a presentation as well as learn how to create, edit, modify, and format them.

 

Microsoft PowerPoint 365: Level 1: Finishing Your Presentation

In this module, we go over how to apply the finishing touches to a presentation, including animations, transitions, and designs. We also cover how to use comments, sharing features, and collaboration tools to co-author a presentation.

Microsoft PowerPoint 365: Level 2: Using Additional Features

In this course, learn how to review, collaborate and comment on a presentation, insert links and online video and, become more comfortable with using subtitles in a variety of languages.

Microsoft PowerPoint 365: Level 2: Integrating Versions of PowerPoint

In this course, learn how to use OneDrive and various versions of PowerPoint to improve flexibility and workflow while designing a presentation in PowerPoint.

Microsoft PowerPoint 365: Level 2: Unique ShortCuts

PowerPoint 365 includes several different keyboard shortcuts that can be used while presenting your slides. This course covers different ways to use shortcuts for presenting, navigating, and editing slides in your presentation.

Return to Store

Microsoft Teams

This course is intended to help all users get started with Teams, use messages and channels, communicate in different ways, and customize Teams settings. By the end of this course, users should be comfortable using the Teams app in their day-to-day workflow.

Microsoft Word 365 Level 1 and 2

In this course, students will learn how to identify components of the Microsoft Word interface and create a document. They will learn different ways to view documents, and how to get help.

Microsoft Excel 365 Level 1 and 2

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 PowerPoint 365: Level 1 and 2

In the first module, students will learn how to log into Office 365 and launch PowerPoint before delving into how to create, edit and view presentations. Using Tell Me and how to access advanced help options are also covered.

Microsoft Access 365: Level 1 and 2

In the first lesson, students will get comfortable opening and creating basic databases, as well as creating simple forms. They will also become familiar with the various objects that make up a database and how to use database templates.

Microsoft 365 Outlook Level 1

This module covers how to create an e-mail message, check spelling and grammar, and format message content. Then, students will learn about email attachments, enhancing messages, and managing automatic message content.

Microsoft Office 365 2019 Feature Updates

This course is intended to help users of Office 365 understand updates made in 2019. It focuses on five Office 365 offerings — Word, Excel, PowerPoint, Outlook, and Access.

Not found