Microsoft Office 365 Bundle

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 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).

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.

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.

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.

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.

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.

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.

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.

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

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

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.

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

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

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.

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.

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

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

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.

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

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.

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.

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.

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

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

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.

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.

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.

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.

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.

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.

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.

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

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.

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.

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.

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.

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.

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

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.

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.

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.

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

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.

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.

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

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.