Explore the many ways to add text and graphic objects in Word 365. In this course, learn how to use the clipboard, Quick Parts, and AutoText. Next, discover how to manage Quick Parts and re-use parts from other documents. Then you will be able to insert hyperlinks and insert and create linked objects, which is especially handy when you want to be instantly directed to the source. You will also discover how to insert and create an equation. Lastly, you will learn how to insert, format, label, and filter a chart in a document. In order to practice, you will find the video samples in the Resources section.

Analyze and present your Excel data in a more visually appealing way using Excel 365's various chart types. In this course, you will learn how to work with different chart types; and how to change a chart's appearance using the chart formatting tools. Next, you will learn how to edit a chart's data series and customize the chart's titles, labels, and axes. You will also see how to save a chart type or chart formatting choice as a template to make it easier to use and include in future spreadsheets. In order to practice what you have learned, you will find practice exercises and samples in the Course Contents pane or in the Resources section.

This course explores several Word 365 features to create mailings. Learn how to create envelopes and labels, and also create and edit a mailing list. You will also discover how to import and edit a mailing list. Next, this course will focus on refining a mailing list, which allows you to keep your contact list up to date. Similarly, learn how to create envelopes and labels with Mail Merge. Lastly, you will learn how to create and configure your Mail Merge document to increase the efficiency of sending mail. In order to practice, you will find the video samples in the Resources section.

You can analyze and present your Excel 365 data in a more visually appealing way using Excel 365's various chart types. In this course, you will learn how to work with different chart types; and how to change a chart's appearance using the chart formatting tools. Next, you will learn how to customize individual chart elements, including customizing chart axes, moving or combining two types of chart, and customizing the chart's titles, labels, and axes. You will also explore how to insert and customize trendlines that can be used for data ranges, movements, or correlations; as well as how to add and modify Sparklines, which are at-a-glance visualizations. In order to practice what you have learned, you will find practice exercises and samples in the Course Contents pane or in the Resources section.

In Excel 365, you can use the Visual Basic Editor to create and manage your macros. It's important to learn how to identify macro components, so you can start writing code for your Excel workbook. In this course, you will explore how to insert procedures and write code in the VBA Editor. You will also learn about using objects and even creating events to interact with those objects. Once you start creating macros, it's important to know how to identify and correct errors found in your code. In order to practice what you have learned, you will find practice exercises and samples in the Course Contents pane or in the Resources section.

This course explores several Word 365 features to manage your sources. Learn how to insert footnotes and endnotes as well as customize them. You will also discover how to insert line numbers and use Smart Lookup. Next, this course will focus on inserting line numbers, which allows you to easily discuss details of your work with others. Similarly, learn how to add research to your document and cite information. Lastly, you will learn how to insert and manage your bibliography to keep your citations up to date. In order to practice, you will find the video samples in the Resources section.

Once you have created your Excel PivotTables, you will need to know how to manage and work with the data contained in them. In this course, you will learn how to analyze, calculate, compare, and work with Excel PivotTables as well as use the timeline. Key concepts covered in this course include how to edit the source data and field setup in a PivotTable; how to organize data logically by creating data groups within a PivotTable; and how to incorporate data from external sources to analyze in an Excel 365 PivotTable. You will also learn how to use sort tools to change the display of data; use filter tools to show and hide data, and work with values for comparison calculations. Finally, you will discover how to troubleshoot common PivotTable issues in Excel 365. In order to practice what you have learned, you will find practice exercises and samples in the Course Contents pane or in the Resources section.

As a Microsoft 365 subscriber, you'll get constant updates on Office tools. In this Winter update, you'll learn how to input data in Excel 365 and save Excel content to OneDrive. Additionally, you'll discover how to use your address book as well as create and manage meetings in Outlook 365. Lastly, you will learn how to share a Word document via OneDrive.

As a Microsoft 365 subscriber, you'll get constant updates on Office tools. In this Fall update, you'll learn how to present slides from PowerPoint directly in Teams as well as share an email from Outlook to Teams. Discover the new ways to display the Ribbon and the Quick Access Toolbar in Outlook and Word. In this course, you'll also learn how to use PowerPoint recording tools and hide or remove duplicate values in Excel.

Explore how to make the most of your Excel 365 content by understanding the potential for data analysis and forecasting. Key concepts in this course include how to use formulas to estimate loan-related costs, and manage repayments. Learn how to insert a forecast worksheet to display trends and make predictions based on available historical data. You will find out how to combine the NPER function with the IF and OR functions to forecast data that meets one or more criteria; and observe how to use what-if, variable-based scenarios that, once created, let you adjust values and change your calculation options. Additionally, you will explore how to use the Analyze Data tool to analyze a dataset to look for patterns in the data and how to use the Power Query tool to import or connect to an external data source, such as a database. In order to practice what you have learned, you will find practice exercises and samples in the Course Contents pane or in the Resources section.

The Microsoft 365 subscription service proposes a set of tools that allow you to improve your collaboration with your colleagues. When switching from Office 2010, 2013 or 2016 to Microsoft 365 you'll see some interface changes that will be covered in this course. You'll discover the new interface features and see how the new Start screen works. This course will also show you how to add an account and connected services to work on your files online. You'll be able to save and manage your documents online as well as share them with you're colleagues. In order to improve collaboration Microsoft 365 allows you to comment on a file and see real-time changes made by other people. If you have documents saved in your computer you can easily transfer and sync them on Microsoft 365.

In Excel 365, it is easy to prevent and resolve issues when working with multiple workbooks. In this course, you will learn how to check whether your workbook has compatibility issues with older versions of Excel, whether it contains personal information that you may not want to share with others, as well as how to recover unsaved documents. Also, you will learn how to ensure formulas are updated automatically when changes are made. In order to practice what you have learned, you will find practice exercises and samples in the Course Contents pane or in the Resources section.

Conditional formulas let you perform calculations in Excel 365 on a range of values by specifying the criteria the data must meet. In this course, discover how to use built-in conditional formulas and create your own. Key concepts covered in this course include how to insert a conditional SUM formula to perform a sum calculation on certain data values; insert a conditional message formula that can be used to display one message if a condition is met, and another if a condition is not met; check if a value is not equal to another; and how to perform complex conditional formulas to create conditions based on calculations and analyze your data in a variety of different ways. You will also explore how to create multiple conditions; how to use IF and OR in conditional formulas; and how to use conditional formulas to count up value occurrences or call out data. Finally, you will learn to use reference positions in conditional formulas and analyze data ranges with conditional formulas. In order to practice what you have learned, you will find practice exercises and samples in the Course Contents pane or in the Resources section.

Word 365 offers different reference tools. First, learn how to insert a cover page to help introduce your document. Next, learn how to create and customize a table of contents. You can also insert bookmarks and create an index. In this course, you will discover how to insert a caption in order to clarify the details of inserted content. You will also learn how to create a table of figures as well as insert & use cross-references. Finally, use the Outline view to plan & reconstruct your document and create a master document. In order to practice, you will find the video samples in the Resources section.

This course explores Word 365's tools for using tables. Discover how to create a table and how to insert & delete items in a table. You will also learn how to resize your table, rows, and columns as well as align the text in your table so you can customize your table according to the information. Word also provides different tools for adjusting your table layout and borders, merging and splitting tables, and formatting your table. Learn how to sort the data in your table and perform a calculation. Lastly, you will discover how to insert items from Excel. For example, you can create a spread sheet in Excel and then quickly transfer that data into your Word document. In order to practice, you will find the video samples in the Resources section.

An Excel 365 worksheet can contain more than just numbers and text. In this course, you will discover how to make your worksheets more visually appealing using hyperlinks, images, screenshots, shapes, icons, special characters, as well as colors and themes. Start by learning how to insert an image or photograph, which can be used to illustrate your data, and then learn how to insert a screenshot. Discover how to edit an image once it has been inserted into your Excel spreadsheet. You will then explore how to adjust an image's brightness, contrast, saturation levels, apply a variety of artistic effects and even add a border. You can also create diagrams using shapes and insert icons to help illustrate a worksheet. You will explore the different types of links and hyperlinks you can insert into your document. You will learn how to insert special characters into a cell and see how to use colors and themes to help data stand out and make a table easier to read. Also, you will discover how to create and edit clean, professional-looking titles with WordArt. In order to practice what you have learned, you will find practice exercises and samples in the Course Contents pane or in the Resources section.

This course explores several Word 365 features to work with diagrams. Learn how to create a diagram with shapes, change the fill style of a shape, and create a custom shape. You will also discover how to use the selection pane and arrange items on a page. Next, this course will focus on creating a drawing canvas, which allows you to move a group of objects more easily. Similarly, learn how to insert and modify a SmartArt graphic. Lastly, you will learn how to format a SmartArt graphic to help your graphic stand out. In order to practice, you will find the video samples in the Resources section.