Course Outline

Excel is Microsoft’s powerful and easy-to-use spreadsheet program, which provides you with an extensive set of tools to organize, analyze, present, and store data.

This course is intended to help all novice computer users get up to speed with Excel quickly. We will cover different features including creating a new spreadsheet, working with basic formulas and functions, making a spreadsheet look professional and presentable, and saving and printing a spreadsheet. 

Getting Started

In this lesson, students will learn how to identify the elements of the Excel interface, create a basic worksheet, and use the help system.

Working with Data

This lesson covers using formulas and functions in a worksheet, working with data, rows and columns and, how to sort and filter data.

Modifying a Worksheet

Next, students will learn how to format text and cells and, how to align cell contents. Using Find & Select tools and, how to spell check a worksheet are also discussed.

Printing Workbook Contents

In this lesson, students will learn how to define the basic page layout for a workbook, refine the page layout and, apply print options.

Managing Large Workbooks

This lesson will teach students how to format worksheet tabs, manage worksheets and, manage the view of worksheets and workbooks.

Customizing the Excel Environment

In this final lesson, students will learn how to customize general, language, formula, proofing, and saving options. It also covers how to use Excel’s version control features, customize the ribbon and the Quick Access toolbar, enable add-ins and, customize advanced and Trust Center options.

Course Outline

This course is intended to help all users become familiar with the more advanced selection of features of Excel. We will cover how to create and use advanced formulas, analyze data, organize worksheet data with tables, visualize data with charts, work with graphical objects, and enhance workbooks. 

Creating Advanced Formulas

In this lesson, students will learn how to use range names in formulas and functions, as well as how to use specialized functions. 

Analyzing Data with Logical and Lookup functions

Next, students will learn how to analyze data by using text, logical, lookup, date and financial functions.

Organizing Worksheet Data with Tables

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

Visualizing Data with Charts

Students will learn how to create charts, as well as how to modify and format existing charts. They will also learn how to create a trendline and advanced charts.

Analyzing Data with PivotTables, Slicers, and PivotCharts

Creating a PivotTable, filtering data using slicers and, analyzing data using PivotCharts will be covered in this lesson.

Working with Graphical Objects

Next, students will learn how to insert, modify, layer, and group graphical objects. We will also take a look at how to incorporate SmartArt into workbooks. 

Enhancing Workbooks

In this final lesson, students will learn how to customize workbooks, manage themes, protect files and, prepare a workbook for multiple audiences.

Excel is Microsoft’s powerful and easy-to-use spreadsheet program. This third part of our Microsoft 35 Excel courseware is intended to help all users get up to speed quickly on the advanced features of Excel.

By the end of this course, students should be comfortable in both the online and desktop environments, using automating functions, analyzing and presenting data, auditing and error checking their work, working in multiple workbooks, and accessing and distributing data.

Excel Online

In the first lesson, students will learn about using both Excel Online and the Excel desktop application, and the differences between them. They will become comfortable managing workbooks in OneDrive, opening and editing them in both applications, and understanding the benefits and obstacles that can be presented by each.

Worksheet Automation

Next, we explore ways to automate worksheets and their functionality. We also look at ways to manage workbook properties, record and run basic macros, create and use templates, and about using data validation criteria. 

Auditing and Error Checking

This lesson covers using formula auditing tools to trace errors and evaluate formulas. Students will be taught how to track formulas using the Watch Window, and the Camera tool. We also cover how to arrange and display data using the Group commands. 

Data Analysis and Presentation

In this lesson, we take a closer look at using the Quick Analysis Tool, adding Sparklines and, get an understanding of the What-If Analysis tools and how to use them to explore different outcomes. 

Working with Multiple Workbooks

This lesson takes a look at arranging, viewing, and navigating between multiple workbooks. This lesson will teach students how to consolidate data from multiple sources, create and maintain links between different workbooks, and how to resolve broken connections.

Exporting and Sourcing Data

In the final lesson, students will be taught about the available file formats for exporting data, and how to create them. They will gain a good understanding of the different data sources that you can be accessed, and will learn the process of creating and sharing a Microsoft Form to support data collection.

Microsoft 365 Outlook incorporates some new features that will help make managing your email and personal information easier than ever. This course will help students get comfortable with the Microsoft 365 interface, creating and sending messages, managing contacts, using the calendar, managing tasks, and working with notes. 

Getting Started with Outlook 365

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

Composing Messages

This lesson 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.

Reading and Responding to Messages

Next, students will learn how to customize reading options, work with attachments, and manage message responses.

Managing Your Messages

This lesson focuses on managing messages using tags, flags, and other commands, as well as organizing messages using folders.

Managing Your Calendar

In this lesson, students will learn how to view and print the calendar, as well as how to manage appointments and meetings.

Managing Your Contacts

How to create, update, view, and organize contacts using the People workspace will be covered in this lesson. 

Working with Tasks and Notes

This lesson is all about managing tasks and notes.

Customizing the Outlook Environment

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

This course is intended to help all users get up to speed on the different features of Outlook and to become familiar with its more advanced selection of features. We will cover how to configure advanced message options, use advanced message management options, manage activities using tasks, and calendars, manage your contacts, share your workspaces with others, manage Outlook data files, and understand email security management.  

Configuring Advanced Message Options

This lesson gives students a look at how to insert advanced characters and objects, how to modify message settings, properties, and options, and how to use automatic replies.

Advanced Message Management

Several topics are covered in this lesson, including how to sort, filter, organize and search messages, managing junk mail, and managing your mailbox.

Advanced Calendar and Task Management

Here, students are introduced to managing advanced calendar options, managing additional calendars, managing meeting responses, and how to assign and manage tasks.

Advanced Contact Management

This lesson takes a look at dealing with contacts and how to edit an electronic business card, manage advanced contact options, and how to forward and export contacts.

Sharing Workspaces with Others

In this lesson, students are taught how to delegate access to mail folders, how to share a calendar, and how to share contacts.

Managing Outlook Data Files

This lesson covers how to back up Outlook data files and, how to change data file and account settings. 

Managing E-mail Security

Email security is the focus of this topic and, how to configure e-mail message security.

PowerPoint is Microsoft’s powerful and easy-to-use presentation program. This version of PowerPoint incorporates some new features in an effort to make collaboration and production as easy as possible. 

This course is intended to help all novice computer users get up to speed with PowerPoint quickly. We will cover different features of the interface; show users how to create, save, and present a basic presentation; cover the basics of formatting; and discuss how to add multimedia to a presentation.

 

Getting Started with PowerPoint

Students will learn how to navigate the PowerPoint environment, create and save a PowerPoint presentation, and use PowerPoint help. 

Developing a PowerPoint Presentation

This lesson 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. 

Performing Advanced Text Editing

This lesson provides techniques for formatting characters, paragraphs, and text boxes. 

Adding Graphical Elements to Your Presentation

Students will learn how to add images, screenshots, screen recordings, shapes, and WordArt to a presentation.

Modifying Objects in Your Presentation

Topics covered in this lesson include how to edit, format, group, and arrange objects. Students will also be introduced to PowerPoint’s animation features. 

Adding Tables to Your Presentation

This lesson focuses on how to create and format a table. Ways to add data from other Microsoft 365 applications are also discussed.

Adding Charts to Your Presentation

Next, students will learn how to create, format, and manipulate a chart. The lesson will conclude with a brief look at inserting a chart from Microsoft Excel.

Preparing to Deliver Your Presentation

In this final lesson, students will learn how to review, print, and deliver a presentation. Techniques for applying transitions to slides will also be covered.

Welcome to the second part of our Microsoft 365 PowerPoint courseware. This version of PowerPoint incorporates some new features and connectivity options in an effort to make collaboration and production as easy as possible.

This course is intended to help all users get up to speed on many of the different features found in PowerPoint and to become familiar with its more advanced selection of features. We will cover how to change the PowerPoint environment, create customized design templates, work with SmartArt, add media and customized animations, collaborate on presentations, customize slide shows, and more. 

Modifying the PowerPoint Environment

This lesson gives students a look at the PowerPoint environment and how to modify it. They will learn how to customize the user interface and how to set options.

Customizing Design Templates

Making the most of the customizability of PowerPoint is the focus of this lesson, templates in particular. This lesson gives your students a look at how to create and manage sections, modify slide masters and slide layouts, add headers and footers, and modify the notes master and the handout master.

Adding SmartArt to a Presentation

SmartArt can add so much to any presentation and help bring it to life. This lesson shows your students how to create and modify SmartArt.

Working with Media and Animations

Media and animations are items that can be used to enhance presentations. This lesson looks at how students can add audio and video to a presentation and how to customize animations and transitions.

Collaborating on a Presentation

Sometimes a presentation is the work of many hands and this lesson covers some of the collaboration tools and how they can be used to review a presentation in a collaborative manner. Students are also shown how to add comments to a presentation,  and how to store and share presentations on the web.

Customizing a Slide Show

Here’s where your students get a better grip on how to customize their slide shows. This lesson covers how to: annotate a presentation, set up a slide show, create a custom slide show, add hyperlinks and action buttons, and record a presentation. 

Securing and Distributing a Presentation

This course wraps up with the security and distribution of a presentation. Students will learn how to secure a presentation, present a slide show online, and about different exporting options for their presentations.

This course is intended to help all novice computer users get up to speed with Word quickly. We will cover different features of the interface, show users how to create a basic document, and introduce users to Word’s most important tools.

By the end of this course, students should be comfortable with creating, saving, and sharing a new document. Students will also become familiar with using and customizing the Microsoft Word interface.

Getting Started with Word

In the first lesson of 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.

Editing a Document

Next, we introduce students to Microsoft Word’s basic navigation and editing tools.

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 lesson wraps up with how to use the Reveal formatting task pane, clearing formatting from text and how to find and replace formatting.

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. 

Managing Lists

Next, students will learn how to manage lists to present text more effectively. Sorting lists, renumbering lists, and customizing list appearance are covered. 

Adding Graphics

Students will then learn how to insert symbols and special characters to a document. How to add images and media to improve a document’s visual appeal is also taught. 

Controlling Page Appearance

After this lesson, students should be able to add a watermark to a document, format a page using borders and colors, and add headers and footers to a document. They should also feel comfortable controlling page layout by modifying the margins, orientation, paper size, vertical alignment, and page breaks. 

Proofing a Document

Next, 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.

Advanced Topics

In this final lesson, students will learn a few different ways to customize the Microsoft Word interface, set save options, and how to manage other file types.

This intermediate-level course is designed to help users who are familiar with Word’s basic features to take their skills to the next level. By the end of this course, users should be comfortable with using tools such as styles, macros, templates, mail merge, and building blocks to automate tasks. Students will also understand how to create complex documents using tables, charts, and various types of illustrations. 

Working with Tables and Charts

In the first lesson, 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. 

Customizing Formats Using Styles and Themes

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

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. 

Creating Custom Graphic Elements

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

Inserting Content Using Quick Parts

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

Controlling Text Flow

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

Using Templates

Topics including creating, managing, modifying, and using template files are explored in this lesson. 

Using Mail Merge

This lesson 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. 

Using Macros

The final lesson of this course looks at automating tasks using macros.

This advanced Microsoft 365 course is designed to help users collaborate on documents and secure information. This course also covers techniques for creating complex documents, such as forms or documents that require reference pages. 

Collaborating on Documents

This lesson begins with a look at modifying user information and sharing documents. We also take a look at working with comments and comparing document changes. The lesson concludes with reviewing a document and, merging document changes. 

Adding Reference Marks and Notes

This lesson explores how to annotate documents with reference tools, such as captions, cross-references, bookmarks, hyperlinks, footnotes, endnotes, citations, and bibliographies. 

Simplifying and Managing Long Documents

This lesson looks at ways to enhance and streamline long documents. Topics include adding cover pages; creating an index, table of contents, and ancillary tables (such as a table of authorities); managing outlines; and working with master documents and subdocuments. 

Securing a Document

This lesson covers how to secure important documents, set editing restrictions, add a digital signature to a document, and restrict document access. 

Forms

In this lesson, students will learn how to create, and manipulate forms. Techniques for saving and exporting form data are also covered. 

Managing Document Versions

This final lesson focuses on creating, comparing, and combining document versions by using Microsoft SharePoint Server with Microsoft 365 Word.