Microsoft   

This hands-on course will teach beginners how to use Microsoft Access 2019/Office 365 to build a database and customize the way data is stored.

Virtually every industry can benefit from the use of Microsoft Access to organize, store, and document their essential information. Data ranging from inventory and customer information to orders details and vendors can be effectively organized with Microsoft's longstanding software. If you work with databases of any kind, learning how to use Access 2019 will add a valuable skill set to your professional profile.

This course will teach you one of the most useful skills for both job seekers and those looking for promotion. If you know how to use Microsoft Excel, learning Access informs and enhances your current skill set, allowing you to take a stronger role in database management.

Requirements:

Hardware Requirements:

• This course must be taken on a PC. Macs are not compatible.

Software Requirements:

• PC: Windows 10 or later.
• Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge is also compatible.
• Microsoft Access 2019: Available to download with a subscription to Microsoft 365, or with Microsoft Office Professional 2019 (not included in enrollment).
• Adobe Acrobat Reader.
• Software must be installed and fully operational before the course begins.

Other:

• Email capabilities and access to a personal email account.

Instructional Material Requirements:

The instructional materials required for this course are included in enrollment and will be available online.

Build, edit, and maintain databases in Microsoft Access 2019/Office 365 using tables, reports, forms, and queries to give you fast access to all your important information. This hands-on course for beginners provides the skills to create an effective database for any type of information at home or on the job.

Getting to Know Access 2019

In this lesson, you'll find out what Access is and how individuals, businesses, and organizations use it to store information. You'll begin to build an Access database, including all the components that turn a list of records into reports, forms, and queries. You'll start by opening the application and creating a new database.

Controlling Your Access Table Fields

It's time to lay down the law! In this lesson, you'll impose rules that automatically fill an Access table field with a preset value or that automatically insert the symbols commonly included in phone numbers. You'll also set up rules that require allow only certain kinds of data in certain fields. With just a few minutes of work, you can make data entry simpler, clearer, and practically error-frees.

Creating Tables and Relationships

You'll create additional tables for the class database, customize them along the way, and then build relationships between them. This all paves the way for later database features, such as reports, queries, and forms that draw from multiple tables in the database.

Building Powerful Forms

In this lesson, you'll use forms for data entry and for viewing records in your tables. You'll meet the Form Wizard, which makes form building fast and easy and which allows you to select one or more tables' fields to include. You'll also learn how to change the form layout.

Adding Versatility to Forms

In this lesson, you'll add buttons and controls to forms. You'll also adjust table relationships to support the creation of multi-table forms, which paves the way to creating queries and reports that draw data from more than one table.

Interviewing Your Database

Using queries to sort, filter, and search your database is one of the most important skills you'll master in this course. In this lesson, you'll create queries that search for specific data. You'll also customize how Access displays that data. By following the instructions step by step, you'll first become familiar with the process, and then you'll get to create a query on your own!

Taking Queries to the Next Level

A query that puts specific records in order or finds all the records that have a general piece of information in common is, well, pretty common. Being able to create that kind of query is a great foundation skill, but it won't help you find a very specific record. Nor will it let you search for records within a span of dates or other numeric values. It also won't help you exclude certain records, reducing a large pool of data to just those records you need to see. In this lesson, you'll create queries that give you true power to search your database.

Multi-Table Query Control

In this lesson, you'll learn to plan, build, and use queries that pull data from more than one table at a time. This gives you more power over your data and allows you to build a great foundation for truly customized reports.

Reporting on Your Tables

Reports are easy to create and to customize. In this lesson, you'll build a simple report using the Report Wizard. Then you'll change the report's appearance, using layout view and design view. These skills provide the foundation to create and design any report you may need on any data in your database.

Creating Query-Based Reports

In this lesson, you'll create reports that are based on the results of queries you create to sort and filter your database. Because queries can combine data from multiple tables, filter for specific data, and sort the results, your report reflects just the data that meet the query's criteria. This makes truly customized reporting possible—and quite simple.

Mastering Report Design

In this lesson, you'll plan and create a completely customized report, using a specialized query that controls which data the report includes. You'll add fields that perform calculations on your data. You'll customize your report's layout, too, using design view's many tools for controlling the structure and appearance of your data.

Automating Your Database With Macros

Building macros (short programs that perform a series of steps) helps you speed up and create consistency in your more repetitive Access tasks. From opening a form to running a report to building a new record in a table, macros eliminate redundant procedures by turning them into something you can do with one click.

What you will learn

• Planning and building a database consisting of multiple tables
• Creating logical relationships between database tables
• Designing effective and powerful data entry forms
• Building efficient and useful queries to find and organize records
• Generation of professional-looking reports

How you will benefit

• You will be able to build and customize Access databases
• Existing Access databases will make more sense
• Gain knowledge to take a stronger role in the database maintenance
• Design professional-looking forms and reports

Laurie Ulrich has been writing about and teaching people to use Microsoft Office for more than 20 years—including personally training thousands of students, writing hundreds of training manuals, and authoring and co-authoring more than 30 books on subjects including Word, Excel, PowerPoint, Outlook, and Access. Her books include 2000-page epics that document every button, bell, and whistle, as well as friendlier introductory and troubleshooting books for new users. Her most recent publication on Microsoft Access is Access 2016 for Dummies. In addition to writing and teaching, Laurie runs her own firm, Limehat & Company, providing training, marketing, graphic design, and web development services to clients throughout the world, with a focus on helping growing companies and non-profit organizations build their brand through effective promotions, outreach, and education.

This hands-on course will teach beginners how to use Microsoft Access 2019/Office 365 to build a database and customize the way data is stored.

Virtually every industry can benefit from the use of Microsoft Access to organize, store, and document their essential information. Data ranging from inventory and customer information to orders details and vendors can be effectively organized with Microsoft's longstanding software. If you work with databases of any kind, learning how to use Access 2019 will add a valuable skill set to your professional profile.

This course will teach you one of the most useful skills for both job seekers and those looking for promotion. If you know how to use Microsoft Excel, learning Access informs and enhances your current skill set, allowing you to take a stronger role in database management.

Requirements:

Hardware Requirements:

• This course must be taken on a PC. Macs are not compatible.

Software Requirements:

• PC: Windows 10 or later.
• Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge is also compatible.
• Microsoft Access 2019: Available to download with a subscription to Microsoft 365, or with Microsoft Office Professional 2019 (not included in enrollment).
• Adobe Acrobat Reader.
• Software must be installed and fully operational before the course begins.

Other:

• Email capabilities and access to a personal email account.

Instructional Material Requirements:

The instructional materials required for this course are included in enrollment and will be available online.

Build, edit, and maintain databases in Microsoft Access 2019/Office 365 using tables, reports, forms, and queries to give you fast access to all your important information. This hands-on course for beginners provides the skills to create an effective database for any type of information at home or on the job.

Getting to Know Access 2019

In this lesson, you'll find out what Access is and how individuals, businesses, and organizations use it to store information. You'll begin to build an Access database, including all the components that turn a list of records into reports, forms, and queries. You'll start by opening the application and creating a new database.

Controlling Your Access Table Fields

It's time to lay down the law! In this lesson, you'll impose rules that automatically fill an Access table field with a preset value or that automatically insert the symbols commonly included in phone numbers. You'll also set up rules that require allow only certain kinds of data in certain fields. With just a few minutes of work, you can make data entry simpler, clearer, and practically error-frees.

Creating Tables and Relationships

You'll create additional tables for the class database, customize them along the way, and then build relationships between them. This all paves the way for later database features, such as reports, queries, and forms that draw from multiple tables in the database.

Building Powerful Forms

In this lesson, you'll use forms for data entry and for viewing records in your tables. You'll meet the Form Wizard, which makes form building fast and easy and which allows you to select one or more tables' fields to include. You'll also learn how to change the form layout.

Adding Versatility to Forms

In this lesson, you'll add buttons and controls to forms. You'll also adjust table relationships to support the creation of multi-table forms, which paves the way to creating queries and reports that draw data from more than one table.

Interviewing Your Database

Using queries to sort, filter, and search your database is one of the most important skills you'll master in this course. In this lesson, you'll create queries that search for specific data. You'll also customize how Access displays that data. By following the instructions step by step, you'll first become familiar with the process, and then you'll get to create a query on your own!

Taking Queries to the Next Level

A query that puts specific records in order or finds all the records that have a general piece of information in common is, well, pretty common. Being able to create that kind of query is a great foundation skill, but it won't help you find a very specific record. Nor will it let you search for records within a span of dates or other numeric values. It also won't help you exclude certain records, reducing a large pool of data to just those records you need to see. In this lesson, you'll create queries that give you true power to search your database.

Multi-Table Query Control

In this lesson, you'll learn to plan, build, and use queries that pull data from more than one table at a time. This gives you more power over your data and allows you to build a great foundation for truly customized reports.

Reporting on Your Tables

Reports are easy to create and to customize. In this lesson, you'll build a simple report using the Report Wizard. Then you'll change the report's appearance, using layout view and design view. These skills provide the foundation to create and design any report you may need on any data in your database.

Creating Query-Based Reports

In this lesson, you'll create reports that are based on the results of queries you create to sort and filter your database. Because queries can combine data from multiple tables, filter for specific data, and sort the results, your report reflects just the data that meet the query's criteria. This makes truly customized reporting possible—and quite simple.

Mastering Report Design

In this lesson, you'll plan and create a completely customized report, using a specialized query that controls which data the report includes. You'll add fields that perform calculations on your data. You'll customize your report's layout, too, using design view's many tools for controlling the structure and appearance of your data.

Automating Your Database With Macros

Building macros (short programs that perform a series of steps) helps you speed up and create consistency in your more repetitive Access tasks. From opening a form to running a report to building a new record in a table, macros eliminate redundant procedures by turning them into something you can do with one click.

What you will learn

• Planning and building a database consisting of multiple tables
• Creating logical relationships between database tables
• Designing effective and powerful data entry forms
• Building efficient and useful queries to find and organize records
• Generation of professional-looking reports

How you will benefit

• You will be able to build and customize Access databases
• Existing Access databases will make more sense
• Gain knowledge to take a stronger role in the database maintenance
• Design professional-looking forms and reports

Laurie Ulrich has been writing about and teaching people to use Microsoft Office for more than 20 years—including personally training thousands of students, writing hundreds of training manuals, and authoring and co-authoring more than 30 books on subjects including Word, Excel, PowerPoint, Outlook, and Access. Her books include 2000-page epics that document every button, bell, and whistle, as well as friendlier introductory and troubleshooting books for new users. Her most recent publication on Microsoft Access is Access 2016 for Dummies. In addition to writing and teaching, Laurie runs her own firm, Limehat & Company, providing training, marketing, graphic design, and web development services to clients throughout the world, with a focus on helping growing companies and non-profit organizations build their brand through effective promotions, outreach, and education.

If you work with data of any kind, knowing how to create a spreadsheet is key to effectively managing and organizing information. This course will introduce you to Microsoft Excel 2019 and teach you how to use this powerful software.

Do you manage large sets of numbers, names, dates, or other pieces of information? If so, then you need to create worksheets to manage, store, organize, and even analyze this information. Excel, Microsoft's powerful spreadsheet software, is the most widely-used program to handle this task. In fact, most workplaces require that new employees have a basic level of understanding of Microsoft Excel.

If you want to learn the 2019 version of Microsoft Excel, this course will introduce you to the program's basic functions and uses. Through hands-on lessons, you will learn numerous shortcuts to quickly and efficiently set up worksheets. You will also learn how to use the function wizard to calculate statistics, future values, and more. In addition, you will get tips on sorting and analyzing data, creating three-dimensional workbooks, and automating frequently-repeated tasks with macros and buttons. By the time you're done, you will know how to use this vital Office 2019 tool.

Requirements:

Hardware Requirements:

• This course must be taken on a PC. It is not suitable for Macs or Chromebooks.

Software Requirements:

• PC: Windows 10 or later.
• Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge is also compatible.
• Microsoft Excel 2019 (desktop version), available to download with the desktop version of Microsoft 365, or Microsoft Office Home and Student 2019 (not included in enrollment).
• Note: The "Starter Version" and "Web App" versions of Microsoft will not work with the full version taught in this course.
• Adobe Acrobat Reader.
• Software must be installed and fully operational before the course begins.

Other:

• Email capabilities and access to a personal email account.

Instructional Material Requirements:

The instructional materials required for this course are included in enrollment and will be available online.

Learn to quickly and efficiently use Microsoft Excel 2019/Office 365 as you discover dozens of shortcuts and tricks for setting up fully formatted worksheets. This course, taught by an experience Microsoft Excel instructor, provides in-depth knowledge for beginners that will have you using Excel like a pro.

Excel Basics

In this lesson, you'll develop a solid understanding of the Excel interface. You'll become fluent in the secret language spoken only by Excel users, you'll discover the best way to correct just about any mistake you might make in Excel, and you'll find yourself gliding effortlessly from cell to cell, leaving behind expertly written labels, numbers, and formulas.

Creating a Worksheet

In this lesson, you'll learn five simple steps you should always follow to ensure that your worksheets are always well-planned, well-constructed, and beautifully formatted.

Time-Savers

This lesson will teach you the tricks of the Excel masters: a wide variety of useful shortcuts guaranteed to save you time, energy, and frustration. You'll also spend some time working with the Quick Analysis and Flash Fill tools. By the time you finish this lesson, you'll really start to feel like an Excel pro.

Relative, Absolute, Mixed, and Circular References

Do you know the difference between a relative reference, an absolute reference, a mixed reference, and a circular reference? You will after this lesson. In this lesson, you'll learn to write sophisticated formulas that can help ease you through some rather sticky scenarios.

Three-Dimensional Workbooks

With enough practice, most Excel users quickly become adept at organizing their worksheets across two dimensions: rows and columns. But only a select few will learn how to take their worksheets into the third dimension. In this lesson, you'll join that exclusive group. Prepare to have your socks knocked off as you gain hands-on experience in the construction of three-dimensional workbooks.

Sorting, Subtotaling, and Filtering

No Excel course would be complete without a discussion of Excel's amazing data-crunching capabilities. In this lesson, you'll learn how to build a table in Excel as well as how to subtotal, sort, and filter.

Charting Basics

In this lesson, you'll explore the exciting world of charts. You'll build your first graph and learn how easy it is to adjust the chart type, labels, titles, colors, and other aspects of your chart.

Advanced Charting Techniques

In this lesson, you'll dig deep into Excel's charting capabilities. You'll explore everything from bar charts and line charts to more prosaic graphs like the pie chart and 3D charts. You'll find out how to personalize your charts with photographs, text labels, and drawings. You'll also discover the best ways to format your chart for print or otherwise display the truly impressive charts that you'll be creating.

Intro to Excel's Statistical Functions

Excel includes many powerful functions that can automatically perform some very complicated tasks for you. In this lesson, you'll learn some very interesting ways to put these functions to work for you. You'll find out how to ask Excel to magically derive averages, modes, maximums, minimums, and other useful statistics from nothing more than a column or two of numbers.

Financial Functions

You'll continue your exploration of Excel functions with an in-depth look at Excel's handy financial functions. By the time this lesson is over, you'll be able to figure out how much money you'll have when you retire, when your kids reach college, or just before your next vacation. You'll be able to calculate the monthly payment on just about any type of loan, and you'll know how to figure out how long it will take to pay off your credit cards. You'll even create an amortization table of your very own, just like the one lenders use to track a loan's payoff amount over time.

Worksheet Automation

In this lesson, you'll find out how to automate just about any task you find tedious or time-consuming. You'll discover how to move your most frequently used commands from their present, obscure locations to a much more convenient place: the toolbar that's always perched at the very top of your screen. You'll also learn how you can use macros to reduce just about any complex task to a single keystroke.

Mastering Excel's IF Function

You'll be intrigued by the final lesson, in which you'll learn how to use Excel to aid you in decision making. You'll use a special function in Excel that allows it to make comparisons and use those comparisons as the basis for important decisions.

What you will learn

• How to create worksheets, charts, and graphs
• Methods for sorting and analyzing automating often repeated tasks
• How to parse data with Flash Fill
• Important keyboard shortcuts

How you will benefit

• Knowing how to use Excel 2019 will make you a more productive member of your organization
• Gain indispensable skills that will be useful for numbers-based reporting
• Develop skills that can be used to simplify your life of calculating and displaying numbers both personally and professionally

Chad Wambolt has spent his entire professional career in the finance field, working for both private and publicly-held companies with sales ranging from $500 million to $3 billion. He is a graduate of Boise State University, where he obtained his bachelor's degree in accounting. Through the course of his career, Wambolt became an expert user of Microsoft Excel. Since 1997, he has taught Excel to students of varying skill levels and helped organizations streamline internal processes.

If you work with data of any kind, knowing how to create a spreadsheet is key to effectively managing and organizing information. This course will introduce you to Microsoft Excel 2019 and teach you how to use this powerful software.

Do you manage large sets of numbers, names, dates, or other pieces of information? If so, then you need to create worksheets to manage, store, organize, and even analyze this information. Excel, Microsoft's powerful spreadsheet software, is the most widely-used program to handle this task. In fact, most workplaces require that new employees have a basic level of understanding of Microsoft Excel.

If you want to learn the 2019 version of Microsoft Excel, this course will introduce you to the program's basic functions and uses. Through hands-on lessons, you will learn numerous shortcuts to quickly and efficiently set up worksheets. You will also learn how to use the function wizard to calculate statistics, future values, and more. In addition, you will get tips on sorting and analyzing data, creating three-dimensional workbooks, and automating frequently-repeated tasks with macros and buttons. By the time you're done, you will know how to use this vital Office 2019 tool.

Requirements:

Hardware Requirements:

• This course must be taken on a PC. It is not suitable for Macs or Chromebooks.

Software Requirements:

• PC: Windows 10 or later.
• Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge is also compatible.
• Microsoft Excel 2019 (desktop version), available to download with the desktop version of Microsoft 365, or Microsoft Office Home and Student 2019 (not included in enrollment).
• Note: The "Starter Version" and "Web App" versions of Microsoft will not work with the full version taught in this course.
• Adobe Acrobat Reader.
• Software must be installed and fully operational before the course begins.

Other:

• Email capabilities and access to a personal email account.

Instructional Material Requirements:

The instructional materials required for this course are included in enrollment and will be available online.

Learn to quickly and efficiently use Microsoft Excel 2019/Office 365 as you discover dozens of shortcuts and tricks for setting up fully formatted worksheets. This course, taught by an experience Microsoft Excel instructor, provides in-depth knowledge for beginners that will have you using Excel like a pro.

Excel Basics

In this lesson, you'll develop a solid understanding of the Excel interface. You'll become fluent in the secret language spoken only by Excel users, you'll discover the best way to correct just about any mistake you might make in Excel, and you'll find yourself gliding effortlessly from cell to cell, leaving behind expertly written labels, numbers, and formulas.

Creating a Worksheet

In this lesson, you'll learn five simple steps you should always follow to ensure that your worksheets are always well-planned, well-constructed, and beautifully formatted.

Time-Savers

This lesson will teach you the tricks of the Excel masters: a wide variety of useful shortcuts guaranteed to save you time, energy, and frustration. You'll also spend some time working with the Quick Analysis and Flash Fill tools. By the time you finish this lesson, you'll really start to feel like an Excel pro.

Relative, Absolute, Mixed, and Circular References

Do you know the difference between a relative reference, an absolute reference, a mixed reference, and a circular reference? You will after this lesson. In this lesson, you'll learn to write sophisticated formulas that can help ease you through some rather sticky scenarios.

Three-Dimensional Workbooks

With enough practice, most Excel users quickly become adept at organizing their worksheets across two dimensions: rows and columns. But only a select few will learn how to take their worksheets into the third dimension. In this lesson, you'll join that exclusive group. Prepare to have your socks knocked off as you gain hands-on experience in the construction of three-dimensional workbooks.

Sorting, Subtotaling, and Filtering

No Excel course would be complete without a discussion of Excel's amazing data-crunching capabilities. In this lesson, you'll learn how to build a table in Excel as well as how to subtotal, sort, and filter.

Charting Basics

In this lesson, you'll explore the exciting world of charts. You'll build your first graph and learn how easy it is to adjust the chart type, labels, titles, colors, and other aspects of your chart.

Advanced Charting Techniques

In this lesson, you'll dig deep into Excel's charting capabilities. You'll explore everything from bar charts and line charts to more prosaic graphs like the pie chart and 3D charts. You'll find out how to personalize your charts with photographs, text labels, and drawings. You'll also discover the best ways to format your chart for print or otherwise display the truly impressive charts that you'll be creating.

Intro to Excel's Statistical Functions

Excel includes many powerful functions that can automatically perform some very complicated tasks for you. In this lesson, you'll learn some very interesting ways to put these functions to work for you. You'll find out how to ask Excel to magically derive averages, modes, maximums, minimums, and other useful statistics from nothing more than a column or two of numbers.

Financial Functions

You'll continue your exploration of Excel functions with an in-depth look at Excel's handy financial functions. By the time this lesson is over, you'll be able to figure out how much money you'll have when you retire, when your kids reach college, or just before your next vacation. You'll be able to calculate the monthly payment on just about any type of loan, and you'll know how to figure out how long it will take to pay off your credit cards. You'll even create an amortization table of your very own, just like the one lenders use to track a loan's payoff amount over time.

Worksheet Automation

In this lesson, you'll find out how to automate just about any task you find tedious or time-consuming. You'll discover how to move your most frequently used commands from their present, obscure locations to a much more convenient place: the toolbar that's always perched at the very top of your screen. You'll also learn how you can use macros to reduce just about any complex task to a single keystroke.

Mastering Excel's IF Function

You'll be intrigued by the final lesson, in which you'll learn how to use Excel to aid you in decision making. You'll use a special function in Excel that allows it to make comparisons and use those comparisons as the basis for important decisions.

What you will learn

• How to create worksheets, charts, and graphs
• Methods for sorting and analyzing automating often repeated tasks
• How to parse data with Flash Fill
• Important keyboard shortcuts

How you will benefit

• Knowing how to use Excel 2019 will make you a more productive member of your organization
• Gain indispensable skills that will be useful for numbers-based reporting
• Develop skills that can be used to simplify your life of calculating and displaying numbers both personally and professionally

Chad Wambolt has spent his entire professional career in the finance field, working for both private and publicly-held companies with sales ranging from $500 million to $3 billion. He is a graduate of Boise State University, where he obtained his bachelor's degree in accounting. Through the course of his career, Wambolt became an expert user of Microsoft Excel. Since 1997, he has taught Excel to students of varying skill levels and helped organizations streamline internal processes.

Are you overloaded with emails, meetings, and to-do lists? Make use of Microsoft Outlook 2019 functions, and you will rapidly increase your efficiency and productivity.

Whether for personal use or work, everyone needs to stay organized. In today's world, being organized means tracking email messages and appointments, storing names and contact information of important people, and creating to-do lists to help you complete various types of projects for yourself or your job.

Many people rely on Microsoft Outlook 2019, a unique tool to help you manage email, appointments, tasks, and contacts in a single program. In this course, you'll learn how to use Microsoft Outlook 2019 for Windows, which you can buy separately or through a subscription to Microsoft 365.

You will learn to save, sort, organize, and read email messages. Set appointments along with reminders, so you'll never miss an important date! Store and search through names of important people and their contact information, and create task lists to help you make progress on different projects. By the end of the course, you'll master how to effectively navigate Outlook's four main features: Mail, Appointments, People, and Tasks.

Besides learning how to create email messages, appointments, task lists, and contact information, you'll also learn how to search and find information and sort and organize data. Whether you need to manage your personal life or your professional world, the step-by-step lessons in this course will help you master Outlook for use at home or work.

Requirements:

Hardware Requirements:

• This course must be taken on a PC. Macs and Chromebooks are not compatible.

Software Requirements:

• PC: Windows 10 or later.
• Browser: The latest version of Google Chrome or Mozilla Firefox is preferred. Microsoft Edge is also compatible.
• Microsoft Office Outlook 2019 (not included in enrollment)
• Adobe Acrobat Reader.
• Software must be installed and fully operational before the course begins.

Other:

• Email capabilities and access to a personal email account.

Instructional Material Requirements:

The instructional materials required for this course are included in enrollment and will be available online.

This Microsoft Outlook training class introduces the 2019 interface and will get you up and running quickly, working effectively with messages, calendars, and contacts.

Getting Started with Outlook 2019

In this lesson, you'll get acquainted with Outlook. You'll go over the basics of what Outlook can do and how you can use it to save time and keep yourself organized. You'll also get familiar with Outlook's user interface to help you feel comfortable using the program. After you finish this lesson, you'll be ready to start using Outlook and switching between its different functions (Mail, Calendar, People, and Tasks).

Reading Email Messages

This lesson will help you make sense of all your email messages without forcing you to scroll through a long list of messages. You'll learn how to display, sort, and organize email messages. Since email is the most popular way to communicate with people anywhere globally, learning how to read and organize email in Outlook could be the feature you'll use most often.

Finding and Grouping Messages

Receiving email is always fun, but finding ways to search through all your email messages to find what you need can spell the difference between using email as a powerful communication tool or getting lost in the daily flood of email messages. In this lesson, you'll learn how to search, tag, and select email messages and move them to a folder. You will also explore strategies for labeling and organizing email messages.

Creating Email Messages

By receiving email messages and responding to them or simply writing new email messages all your own, you can turn your email account into a two-way communication medium to reach out to people anywhere around the world. In this lesson, you'll learn different ways to create and reply to messages. You will also identify ways to edit and send email messages.

Formatting Email Messages

In this lesson, you'll learn how to format text in your email messages to make your messages more appealing and readable. Formatting text doesn't just mean improving cosmetic appearances but can also mean displaying text in an organized fashion, so it's easier to read. You will identify ways to improve email messages through the use of different fonts, colors, and styles, as well as the use of spelling and grammar checks. You'll also learn how to use bulleted and numbered lists to ensure your emails are easy to read and understand.

Editing Email Messages

This lesson is all about polishing your text, so everything is correct. After all, your words may be powerful, but if there are typos or grammatical mistakes, your email message can look less valid and legitimate. In this lesson, you'll learn different ways to proofread and edit email messages. You'll explore the search and replace feature, learn how to create hyperlinks for email and website addresses, learn how to use the signature feature, and explore different styles for your email messages.

Sending Attachments to Email Messages

Sending email messages with file attachments lets you communicate with others using more than just what you can type. You can share a spreadsheet for others to edit, send someone an interesting PDF file to read, or give someone a short video of yourself wishing him a happy birthday. In this lesson, you'll learn how to add files such as word processor documents, spreadsheets, databases, or presentations along with video and audio files to your email messages. You'll also learn how to add images to email messages and edit these using word wrapping and other methods.

Dealing with Wanted and Unwanted Email

In this lesson, you'll learn how to deal with both wanted and unwanted email messages so you can focus your time on having fun and being productive. You'll learn how to delete and retrieve email messages, as well as how to archive them. Most of your email messages will likely be those you want to receive, but too many of them can make it difficult to find what you need, so you will also learn the benefits of creating rules for sorting emails so you can deal with junk email messages easier.

Storing Contact Information

Outlook offers a way to store names and contact information in a database. Not only can this database grow as large as necessary, but no matter how big it gets, Outlook still makes it easy for you to search and find the information you need quickly and accurately. In this lesson, you'll learn all about using Outlook to store contact information of the people most important to you for business and personal use. You'll learn how to create and keep contacts, sharing and search contacts, and group and sort contacts.

Using the Outlook Calendar

Everyone needs to meet people or be at a certain place at a specific time. For busier people, your scheduled appointments may become so numerous and varied that keeping track of your time can be cumbersome. In this lesson, you'll learn all about using Outlook's calendar feature to create and store appointments. You'll identify the different ways to view and use the calendar. You'll also explore setting and viewing appointments, as well as managing, editing, and sharing these appointments.

Creating Task Lists

In this lesson, you'll learn all about using Outlook to create tasks that can help you stay focused on achieving the goals you want to achieve. Outlook makes it easy to create and store your list of tasks that you can view whenever you use Outlook. In this lesson, you'll learn how to create a task list, tag and add details to a task, and manage your tasks. Outlook's task list is just one more tool to help you keep your life organized and focused.

Taking Notes and Customizing Outlook

Once you learn how to use Outlook's note-taking feature, you can learn different keystroke shortcuts and how to customize Outlook further to serve your particular needs better. In this lesson, you'll identify ways to create and modify notes. You'll also identify keystroke shortcuts and how to use these. Along with this, you'll learn different ways to customize Outlook's user interface and change Outlook's settings. You'll also have a chance to reflect on Outlook's various features you find most valuable and then decide how you plan to customize Outlook to make it easier for you.

What you will learn

• Understand the basics of the Outlook 2019 interface and how to navigate the program
• Create a standard Mail view to work from and learn the basics of sending and receiving email
• Get to know everything you need to know about Outlook's contacts, Contacts views, Contact Groups, and Address Books
• Learn how to link Outlook to social media sites, and find out how information from People can appear throughout Outlook
• Learn how to work with one or more Outlook Calendars and the associated items: appointments, meetings, and events.
• Learn how to work with Outlook tasks and to-dos
• Learn how to customize Outlook

How you will benefit

• Harness the full power of Outlook 2019 so you can be more productive
• Learn to better communicate and keep track of all your responsibilities

Wallace Wang is the author of over 40 computer books, including "Microsoft Office 2019 For Dummies." In addition to writing computer books, he has also co-authored "Breaking Into Acting for Dummies" and ghostwritten several books about investing in real estate, day trading stocks, and becoming an entrepreneur. Some of his past jobs have included teaching computer science courses at the University of Zimbabwe, performing stand-up comedy, and appearing on a weekly radio show.

Are you overloaded with emails, meetings, and to-do lists? Make use of Microsoft Outlook 2019 functions, and you will rapidly increase your efficiency and productivity.

Whether for personal use or work, everyone needs to stay organized. In today's world, being organized means tracking email messages and appointments, storing names and contact information of important people, and creating to-do lists to help you complete various types of projects for yourself or your job.

Many people rely on Microsoft Outlook 2019, a unique tool to help you manage email, appointments, tasks, and contacts in a single program. In this course, you'll learn how to use Microsoft Outlook 2019 for Windows, which you can buy separately or through a subscription to Microsoft 365.

You will learn to save, sort, organize, and read email messages. Set appointments along with reminders, so you'll never miss an important date! Store and search through names of important people and their contact information, and create task lists to help you make progress on different projects. By the end of the course, you'll master how to effectively navigate Outlook's four main features: Mail, Appointments, People, and Tasks.

Besides learning how to create email messages, appointments, task lists, and contact information, you'll also learn how to search and find information and sort and organize data. Whether you need to manage your personal life or your professional world, the step-by-step lessons in this course will help you master Outlook for use at home or work.

Requirements:

Hardware Requirements:

• This course must be taken on a PC. Macs and Chromebooks are not compatible.

Software Requirements:

• PC: Windows 10 or later.
• Browser: The latest version of Google Chrome or Mozilla Firefox is preferred. Microsoft Edge is also compatible.
• Microsoft Office Outlook 2019 (not included in enrollment)
• Adobe Acrobat Reader.
• Software must be installed and fully operational before the course begins.

Other:

• Email capabilities and access to a personal email account.

Instructional Material Requirements:

The instructional materials required for this course are included in enrollment and will be available online.

This Microsoft Outlook training class introduces the 2019 interface and will get you up and running quickly, working effectively with messages, calendars, and contacts.

Getting Started with Outlook 2019

In this lesson, you'll get acquainted with Outlook. You'll go over the basics of what Outlook can do and how you can use it to save time and keep yourself organized. You'll also get familiar with Outlook's user interface to help you feel comfortable using the program. After you finish this lesson, you'll be ready to start using Outlook and switching between its different functions (Mail, Calendar, People, and Tasks).

Reading Email Messages

This lesson will help you make sense of all your email messages without forcing you to scroll through a long list of messages. You'll learn how to display, sort, and organize email messages. Since email is the most popular way to communicate with people anywhere globally, learning how to read and organize email in Outlook could be the feature you'll use most often.

Finding and Grouping Messages

Receiving email is always fun, but finding ways to search through all your email messages to find what you need can spell the difference between using email as a powerful communication tool or getting lost in the daily flood of email messages. In this lesson, you'll learn how to search, tag, and select email messages and move them to a folder. You will also explore strategies for labeling and organizing email messages.

Creating Email Messages

By receiving email messages and responding to them or simply writing new email messages all your own, you can turn your email account into a two-way communication medium to reach out to people anywhere around the world. In this lesson, you'll learn different ways to create and reply to messages. You will also identify ways to edit and send email messages.

Formatting Email Messages

In this lesson, you'll learn how to format text in your email messages to make your messages more appealing and readable. Formatting text doesn't just mean improving cosmetic appearances but can also mean displaying text in an organized fashion, so it's easier to read. You will identify ways to improve email messages through the use of different fonts, colors, and styles, as well as the use of spelling and grammar checks. You'll also learn how to use bulleted and numbered lists to ensure your emails are easy to read and understand.

Editing Email Messages

This lesson is all about polishing your text, so everything is correct. After all, your words may be powerful, but if there are typos or grammatical mistakes, your email message can look less valid and legitimate. In this lesson, you'll learn different ways to proofread and edit email messages. You'll explore the search and replace feature, learn how to create hyperlinks for email and website addresses, learn how to use the signature feature, and explore different styles for your email messages.

Sending Attachments to Email Messages

Sending email messages with file attachments lets you communicate with others using more than just what you can type. You can share a spreadsheet for others to edit, send someone an interesting PDF file to read, or give someone a short video of yourself wishing him a happy birthday. In this lesson, you'll learn how to add files such as word processor documents, spreadsheets, databases, or presentations along with video and audio files to your email messages. You'll also learn how to add images to email messages and edit these using word wrapping and other methods.

Dealing with Wanted and Unwanted Email

In this lesson, you'll learn how to deal with both wanted and unwanted email messages so you can focus your time on having fun and being productive. You'll learn how to delete and retrieve email messages, as well as how to archive them. Most of your email messages will likely be those you want to receive, but too many of them can make it difficult to find what you need, so you will also learn the benefits of creating rules for sorting emails so you can deal with junk email messages easier.

Storing Contact Information

Outlook offers a way to store names and contact information in a database. Not only can this database grow as large as necessary, but no matter how big it gets, Outlook still makes it easy for you to search and find the information you need quickly and accurately. In this lesson, you'll learn all about using Outlook to store contact information of the people most important to you for business and personal use. You'll learn how to create and keep contacts, sharing and search contacts, and group and sort contacts.

Using the Outlook Calendar

Everyone needs to meet people or be at a certain place at a specific time. For busier people, your scheduled appointments may become so numerous and varied that keeping track of your time can be cumbersome. In this lesson, you'll learn all about using Outlook's calendar feature to create and store appointments. You'll identify the different ways to view and use the calendar. You'll also explore setting and viewing appointments, as well as managing, editing, and sharing these appointments.

Creating Task Lists

In this lesson, you'll learn all about using Outlook to create tasks that can help you stay focused on achieving the goals you want to achieve. Outlook makes it easy to create and store your list of tasks that you can view whenever you use Outlook. In this lesson, you'll learn how to create a task list, tag and add details to a task, and manage your tasks. Outlook's task list is just one more tool to help you keep your life organized and focused.

Taking Notes and Customizing Outlook

Once you learn how to use Outlook's note-taking feature, you can learn different keystroke shortcuts and how to customize Outlook further to serve your particular needs better. In this lesson, you'll identify ways to create and modify notes. You'll also identify keystroke shortcuts and how to use these. Along with this, you'll learn different ways to customize Outlook's user interface and change Outlook's settings. You'll also have a chance to reflect on Outlook's various features you find most valuable and then decide how you plan to customize Outlook to make it easier for you.

What you will learn

• Understand the basics of the Outlook 2019 interface and how to navigate the program
• Create a standard Mail view to work from and learn the basics of sending and receiving email
• Get to know everything you need to know about Outlook's contacts, Contacts views, Contact Groups, and Address Books
• Learn how to link Outlook to social media sites, and find out how information from People can appear throughout Outlook
• Learn how to work with one or more Outlook Calendars and the associated items: appointments, meetings, and events.
• Learn how to work with Outlook tasks and to-dos
• Learn how to customize Outlook

How you will benefit

• Harness the full power of Outlook 2019 so you can be more productive
• Learn to better communicate and keep track of all your responsibilities

Wallace Wang is the author of over 40 computer books, including "Microsoft Office 2019 For Dummies." In addition to writing computer books, he has also co-authored "Breaking Into Acting for Dummies" and ghostwritten several books about investing in real estate, day trading stocks, and becoming an entrepreneur. Some of his past jobs have included teaching computer science courses at the University of Zimbabwe, performing stand-up comedy, and appearing on a weekly radio show.

Learn how to use Microsoft PowerPoint 2016 (now available through Office 365) to create professional-looking presentations using slide and layout masters that make global changes in a snap.

Take your PowerPoint presentations from ordinary to extraordinary! In these lessons, you'll learn how to use Microsoft PowerPoint 2016 (now available through Office 365) to create professional-quality slide presentations that grab and hold your audience's attention from start to finish.

You'll see how to plan a presentation for your audience, format it with themes and color, and use the slide master and layout master to make global changes. You'll embellish your slides with text and objects, including pictures, shapes, WordArt, and SmartArt, and learn to add multimedia effects to create animated presentations and more. If you want to become a PowerPoint pro, this is the course for you!

Requirements:

Hardware Requirements:

• This course must be taken on a PC. It is not suitable for Macs.

Software Requirements:

• PC: Windows 8 or later.
• Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge is also compatible.
• Microsoft Office Home and Student 2016 or a subscription to Office 365 (not included in enrollment).
• Adobe Acrobat Reader.
• Software must be installed and fully operational before the course begins.

Other:

• Email capabilities and access to a personal email account.

Instructional Material Requirements:

The instructional materials required for this course are included in enrollment and will be available online.

Take your presentations from "so-so" to sensation with PowerPoint. This course will help you discover how to use Microsoft PowerPoint 2016 to create professional-quality slide presentations that grab attention from start to finish and make your message memorable.

The PowerPoint 2016 Interface

Come explore the basic features of Microsoft PowerPoint 2016! You'll learn about the Ribbon, which replaces the menu and toolbars so common in other programs written for the Windows operating system. You'll find out how to plan a presentation and start the PowerPoint program and practice working with different views, task panes, tabs, and templates.

Creating Presentations

Now that you know the basics of PowerPoint, it's time to create a presentation from scratch. You'll start by choosing a theme for the presentation and create slides with a variety of slide layouts. You'll find out about the Live Preview feature and learn how to save a file so that you can find it later. You'll also create and edit slides in the slide pane and in Outline view. Finally, the lesson will go over the ways to put on a slide show.

Creating and Editing Tables and Opening and Saving Files

Including tables in your presentation lets you present a lot of information in a little space. So in this lesson, you'll add, revise, and format tables. You'll also learn multiple ways to open a presentation. Then, the lesson will teach you how to preserve different versions of your work by saving with different filenames.

Creating and Printing Error-Free Presentations

This lesson will cover two topics: printing and proofreading. You'll learn to print your presentation as slides, handouts, an outline, and notes pages. This versatility will really help you connect with audience members! To make sure your printed presentation is as close to perfect as it can be, you'll explore the Spelling, AutoCorrect, and Thesaurus features, along with the new Smart Lookup feature.

Working With Saved and Online Images

You're going to switch gears in this lesson and work with images instead of text, which you'll probably enjoy. You'll see how to embellish your slides with media clips, which could include illustrations, clip art, and photographs. You'll even learn how to download an image from a website and insert the image on a slide.

WordArt, Shapes, and SmartArt

You're going to work with WordArt, Shapes, and SmartArt Graphics in this lesson, which is very exciting. It's fun to transform text into colorful WordArt objects and to draw and fill shapes with color and special effects. You'll learn to group and edit the objects you create and add visual sophistication to your text with SmartArt Graphics.

Creating and Editing a Chart

In this lesson, you'll create and edit a chart slide to illustrate statistical data. You'll find this lesson easy if you like working with numbers! If you don't enjoy math, that's okay—the lesson will walk you through everything you need to know and do to create a chart slide. It will also show you how to change the look of your chart by using the options on the Chart Tools contextual tab and the chart formatting buttons.

Making Global Changes to a Presentation

Making the same changes to dozens of PowerPoint slides is boring and time-consuming. In this lesson, you'll look at global changes you can make to your slides, handouts, and notes. For example, if you want to increase or decrease the font size on all the slides in a presentation, just make the change on the slide master. You'll also make global changes when you modify your presentation's theme colors or background.

Creating Links

In this lesson, you'll work with hyperlinks and action buttons. You'll enliven your presentation as you learn to create links from text or objects to other slides, presentations, documents, and web pages. You can even add sounds and 3D effects!

Applying Animation to Slides, Text, and Objects

Have you seen a presentation where text, images, or entire slides fly in from the top or push up from the bottom? That's animation. In this lesson, you'll learn about slide transitions, the options on the Transition tab, and you'll apply animation to text and objects on slides and the slide or layout master with the options on the Animations tab. You'll then find out how to add sound effects, such as chimes and whooshes, to slide transitions. Perhaps most important, you'll also learn how to avoid overdoing these effects!

Applying Advanced Animation Effects to Text and Objects

You already know how to apply animation to your slides as they transition. Now it's time to apply advanced animation effects to text and objects on slides and slide and layout masters. With the animation commands and the Animation Pane, you'll add and reorder animated text and objects on slides. You'll also add an audio clip to your presentation.

Sharing and Saving Your Presentations, Including OneDrive and Office Online

Now that you know so much about creating PowerPoint presentations, you'll focus on different ways to save and share them. You'll see how easy it is to export your presentation as a PDF file, so it'll be accessible on computers that don't have PowerPoint 2016. You'll learn to open, edit, and share your presentation online with a Windows OneDrive account and PowerPoint Online and how to turn your presentation into a video.

What you will learn

• Learn how to plan a presentation for your audience
• Understand how to format it with themes and color and use the slide master and layout master to make global changes
• Explore how to embellish your slides with text and objects, including pictures, shapes, WordArt, and SmartArt
• Learn to add multimedia effects to create animated presentations
• Explore the options on the PowerPoint Ribbon, including the new Online Pictures command, File menu options, and Backstage View
• Learn how to print slides, handouts, and even an outline
• Discover the best view for creating and editing your slides and running your presentations

How you will benefit

• Master PowerPoint skills that will help you produce better presentations
• Become an integral team member at your company with professional presentation design skills
• Gain skills that will transfer to any organization and will look great on your résumé

Kathy Van Pelt has taught computer courses at a community college for the past 25 years. She specializes in Microsoft Office applications, Google Drive and Google Applications, the Windows and Mac operating systems, and keyboarding. She spent seven years teaching word processing and business classes at a private business college and loves being in the ever-evolving educational field.

Learn how to use Microsoft PowerPoint 2016 (now available through Office 365) to create professional-looking presentations using slide and layout masters that make global changes in a snap.

Take your PowerPoint presentations from ordinary to extraordinary! In these lessons, you'll learn how to use Microsoft PowerPoint 2016 (now available through Office 365) to create professional-quality slide presentations that grab and hold your audience's attention from start to finish.

You'll see how to plan a presentation for your audience, format it with themes and color, and use the slide master and layout master to make global changes. You'll embellish your slides with text and objects, including pictures, shapes, WordArt, and SmartArt, and learn to add multimedia effects to create animated presentations and more. If you want to become a PowerPoint pro, this is the course for you!

Requirements:

Hardware Requirements:

• This course must be taken on a PC. It is not suitable for Macs.

Software Requirements:

• PC: Windows 8 or later.
• Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge is also compatible.
• Microsoft Office Home and Student 2016 or a subscription to Office 365 (not included in enrollment).
• Adobe Acrobat Reader.
• Software must be installed and fully operational before the course begins.

Other:

• Email capabilities and access to a personal email account.

Instructional Material Requirements:

The instructional materials required for this course are included in enrollment and will be available online.

Take your presentations from "so-so" to sensation with PowerPoint. This course will help you discover how to use Microsoft PowerPoint 2016 to create professional-quality slide presentations that grab attention from start to finish and make your message memorable.

The PowerPoint 2016 Interface

Come explore the basic features of Microsoft PowerPoint 2016! You'll learn about the Ribbon, which replaces the menu and toolbars so common in other programs written for the Windows operating system. You'll find out how to plan a presentation and start the PowerPoint program and practice working with different views, task panes, tabs, and templates.

Creating Presentations

Now that you know the basics of PowerPoint, it's time to create a presentation from scratch. You'll start by choosing a theme for the presentation and create slides with a variety of slide layouts. You'll find out about the Live Preview feature and learn how to save a file so that you can find it later. You'll also create and edit slides in the slide pane and in Outline view. Finally, the lesson will go over the ways to put on a slide show.

Creating and Editing Tables and Opening and Saving Files

Including tables in your presentation lets you present a lot of information in a little space. So in this lesson, you'll add, revise, and format tables. You'll also learn multiple ways to open a presentation. Then, the lesson will teach you how to preserve different versions of your work by saving with different filenames.

Creating and Printing Error-Free Presentations

This lesson will cover two topics: printing and proofreading. You'll learn to print your presentation as slides, handouts, an outline, and notes pages. This versatility will really help you connect with audience members! To make sure your printed presentation is as close to perfect as it can be, you'll explore the Spelling, AutoCorrect, and Thesaurus features, along with the new Smart Lookup feature.

Working With Saved and Online Images

You're going to switch gears in this lesson and work with images instead of text, which you'll probably enjoy. You'll see how to embellish your slides with media clips, which could include illustrations, clip art, and photographs. You'll even learn how to download an image from a website and insert the image on a slide.

WordArt, Shapes, and SmartArt

You're going to work with WordArt, Shapes, and SmartArt Graphics in this lesson, which is very exciting. It's fun to transform text into colorful WordArt objects and to draw and fill shapes with color and special effects. You'll learn to group and edit the objects you create and add visual sophistication to your text with SmartArt Graphics.

Creating and Editing a Chart

In this lesson, you'll create and edit a chart slide to illustrate statistical data. You'll find this lesson easy if you like working with numbers! If you don't enjoy math, that's okay—the lesson will walk you through everything you need to know and do to create a chart slide. It will also show you how to change the look of your chart by using the options on the Chart Tools contextual tab and the chart formatting buttons.

Making Global Changes to a Presentation

Making the same changes to dozens of PowerPoint slides is boring and time-consuming. In this lesson, you'll look at global changes you can make to your slides, handouts, and notes. For example, if you want to increase or decrease the font size on all the slides in a presentation, just make the change on the slide master. You'll also make global changes when you modify your presentation's theme colors or background.

Creating Links

In this lesson, you'll work with hyperlinks and action buttons. You'll enliven your presentation as you learn to create links from text or objects to other slides, presentations, documents, and web pages. You can even add sounds and 3D effects!

Applying Animation to Slides, Text, and Objects

Have you seen a presentation where text, images, or entire slides fly in from the top or push up from the bottom? That's animation. In this lesson, you'll learn about slide transitions, the options on the Transition tab, and you'll apply animation to text and objects on slides and the slide or layout master with the options on the Animations tab. You'll then find out how to add sound effects, such as chimes and whooshes, to slide transitions. Perhaps most important, you'll also learn how to avoid overdoing these effects!

Applying Advanced Animation Effects to Text and Objects

You already know how to apply animation to your slides as they transition. Now it's time to apply advanced animation effects to text and objects on slides and slide and layout masters. With the animation commands and the Animation Pane, you'll add and reorder animated text and objects on slides. You'll also add an audio clip to your presentation.

Sharing and Saving Your Presentations, Including OneDrive and Office Online

Now that you know so much about creating PowerPoint presentations, you'll focus on different ways to save and share them. You'll see how easy it is to export your presentation as a PDF file, so it'll be accessible on computers that don't have PowerPoint 2016. You'll learn to open, edit, and share your presentation online with a Windows OneDrive account and PowerPoint Online and how to turn your presentation into a video.

What you will learn

• Learn how to plan a presentation for your audience
• Understand how to format it with themes and color and use the slide master and layout master to make global changes
• Explore how to embellish your slides with text and objects, including pictures, shapes, WordArt, and SmartArt
• Learn to add multimedia effects to create animated presentations
• Explore the options on the PowerPoint Ribbon, including the new Online Pictures command, File menu options, and Backstage View
• Learn how to print slides, handouts, and even an outline
• Discover the best view for creating and editing your slides and running your presentations

How you will benefit

• Master PowerPoint skills that will help you produce better presentations
• Become an integral team member at your company with professional presentation design skills
• Gain skills that will transfer to any organization and will look great on your résumé

Kathy Van Pelt has taught computer courses at a community college for the past 25 years. She specializes in Microsoft Office applications, Google Drive and Google Applications, the Windows and Mac operating systems, and keyboarding. She spent seven years teaching word processing and business classes at a private business college and loves being in the ever-evolving educational field.

Discover how to effectively plan and implement projects using the world's most popular project management software, Microsoft Project 2019.

Microsoft Project is a staple for project management and remains the most widely-used project management software across all industries. If you manage projects in your organization, learning how to use this longstanding resource is key to successfully and effectively seeing your projects through to completion.

In this course, you will discover how to effectively plan, implement, and control projects using Microsoft Project 2019. From sequencing tasks, producing a baseline, and assigning resources and costs, to tracking progress and revising your project plan, Microsoft Project can help you organize all your project's details.

Armed with this information, you will avoid stalling or overloading your schedule. If you encounter trouble, you will know how to best utilize Project 2019 to get your project back on track.

Requirements:

Hardware Requirements:

• This course must be taken on a PC. Macs are not compatible.

Software Requirements:

• PC: Windows 10 or later.
• Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge is also compatible.
• Microsoft Project 2019 (not included in enrollment).
• Adobe Acrobat Reader.
• Software must be installed and fully operational before the course begins.

Other:

• Email capabilities and access to a personal email account.

Instructional Material Requirements:

The instructional materials required for this course are included in enrollment and will be available online.

Learn to effectively plan, implement, and control projects using Microsoft Project 2019/Office 365. This course will help you master the basics to create and share a project schedule, track costs and resources, produce reports, and resolve problems to keep your projects on track.

Overview of Microsoft Project

Microsoft Project can help you manage your project's schedule, costs, and scope in a way that you've never dreamed of. Too often, Project users never use this powerful tool to its fullest potential. In this lesson, you'll discover how to improve your project by adopting a formal management approach. You'll get a quick overview of Project Management, and then you'll learn the basics of Microsoft Project, including a summary of the Gantt Chart view and ways to create and enter project tasks.

Creating a Solid Foundation

If you're looking for ways to keep organized, you'll see just how to do that in this lesson! You'll go through the steps to create a project schedule in no time flat. Once you create and enter tasks in Project's Gantt Chart view, you'll set a schedule by using a calendar and assigning lead times. Then, you'll need to create task dependencies, sometimes known as links. You'll see how to perform these activities and, in the process, you'll become comfortable using Project's many dialog boxes. Before you know it, you'll be creating schedules for all your projects with little effort.

Creating and Managing Resources

You won't get too far with your project without adding resources. While tasks create the backbone of your project, you'll also need people, equipment, and materials to bring your project to life. In this lesson, you'll find out how to apply two types of Project resources—work resources, and material resources. You'll look at two more dialog boxes—Resource Information and Assign Resources—and you'll learn how to analyze resources by using the Resource Sheet and Resource Usage views.

Defining and Assigning Costs

No matter what project you work on, the bottom line is always important. So, get ready to add the final piece to your basic project schedule—costs. You'll start things off by looking through a brief overview of cost accounting, exploring fixed, variable, relevant, and accrued costs. After this review, you'll learn how to assign costs by using the Resource Sheet. You'll even discover how to assign different costs for the same resource and analyze the overall costs for your project by using the Cost Table.

Project Templates, Security, and Constraints

Successful project managers are known for their efficiency and for safeguarding private information. Microsoft Project provides two excellent methods to help you in these areas: project templates and project security. You'll find out how to use some of the many templates Project has to offer, including the Residential Construction template and the New Product template. You'll also learn how to protect your project information with backups, passwords, and write protection. Then you'll discover how to put Project's task constraints to good use.

Working With Views and Managing Information

In this lesson, you'll discover how easy it is to modify your basic schedules and work with project data. You'll look at the various Project views, such as the Calendar, Leveling Gantt, and the Network Diagram. If you don't like the default colors or fonts in your schedule or table, you'll be well-prepared to make changes. You'll even learn how and why you might want to create a combination view; add notes to your project; or sort, filter, and group data.

Fine-Tuning Your Project Plan

Many projects experience schedule compression when management or clients ask that the project be completed sooner and for less. In this lesson, you'll discover how to improve your schedule's performance. You'll explore the Project Statistics dialog box, and you'll learn how to determine the ideal starting point in terms of planned costs and completion dates. You'll see how to change task dependencies to speed up your project and also find out how to split tasks to add more lead time. You'll also learn how to create recurring tasks and attach notes to your project's taskbars.

Baselines and Tracking

Before you implement your project, you need to create a baseline. This will help you track actual results against what you originally set out to accomplish. Microsoft Project makes it possible to set up a baseline with a few mouse clicks. You'll learn how to create a baseline and then see a variety of ways, including using the Tracking toolbar, to record your actual project results.

Managing Variances

Here's where things really start to come together! You'll learn how to compare actual results to your baseline by using the Gantt Chart and reviewing a table. You'll discover how useful status identifiers and progress lines can be to quickly gain information about your project's position. You'll also begin using the Tracking Gantt and filters to automatically identify slipping tasks. You'll also take a stroll through the basics of variance analysis by discussing the Start and Finish Date, Resources, and Work Variance Tables.

Closing Your Project

No project is complete until it's officially closed. In this final lesson, you'll find out how to close your project and use the Organizer to help you customize and copy views for future projects.

Printing Views

Now that you're using reports to share project information, you'll occasionally need to print various views and tables. In this lesson, you'll delve into printing Microsoft Project documents. You'll be a master at creating different views of your project with the Page Setup dialog box, and you'll clearly understand the mechanics of the Print dialog box and the Print Preview.

Using and Creating Reports

Once your project gets rolling, outsiders will probably want to know how things are going. It can be a real time drain answering each request individually. When others request information from you, Microsoft Project offers the perfect solution: Reports. You'll go over a representative sample of the standard reports as well as discuss how to modify and create new reports in this lesson. By the time you finish, you'll be well acquainted with Project's reporting capabilities and also know how to create Visual Reports as Project automatically exports data to Microsoft Excel and Visio.

What you will learn

• Effective planning, implementation, and control projects using Microsoft Project
• How to enhance your project in the areas of efficiency and security
• The importance of setting a project baseline and tracking actual results
• Generate several standard project reports and a wide variety of visual project reports

How you will benefit

• Know how to the use of the world's most popular project management software
• Gain transferable skills
• Replace informal project plans with plans based on logic and structures reflective

Tony Swaim has helped many clients, colleagues, and students reach their professional and personal goals. He has been an online instructor since 1998 and has taught at colleges and universities across the United States since 1981. His focus areas are project management, Six Sigma, and supply chain management. Tony manages a successful consulting firm, and his industry experience includes 20 years of supply chain management. He earned a Doctorate in Business Administration from Kennesaw State University and holds professional certifications in six disciplines, including the Project Management Professional (PMP)® certification from the Project Management Institute (PMI)® and Certified Six Sigma Black Belt (CSSBB)® from the American Society for Quality (ASQ)®.

Discover how to effectively plan and implement projects using the world's most popular project management software, Microsoft Project 2019.

Microsoft Project is a staple for project management and remains the most widely-used project management software across all industries. If you manage projects in your organization, learning how to use this longstanding resource is key to successfully and effectively seeing your projects through to completion.

In this course, you will discover how to effectively plan, implement, and control projects using Microsoft Project 2019. From sequencing tasks, producing a baseline, and assigning resources and costs, to tracking progress and revising your project plan, Microsoft Project can help you organize all your project's details.

Armed with this information, you will avoid stalling or overloading your schedule. If you encounter trouble, you will know how to best utilize Project 2019 to get your project back on track.

Requirements:

Hardware Requirements:

• This course must be taken on a PC. Macs are not compatible.

Software Requirements:

• PC: Windows 10 or later.
• Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge is also compatible.
• Microsoft Project 2019 (not included in enrollment).
• Adobe Acrobat Reader.
• Software must be installed and fully operational before the course begins.

Other:

• Email capabilities and access to a personal email account.

Instructional Material Requirements:

The instructional materials required for this course are included in enrollment and will be available online.

Learn to effectively plan, implement, and control projects using Microsoft Project 2019/Office 365. This course will help you master the basics to create and share a project schedule, track costs and resources, produce reports, and resolve problems to keep your projects on track.

Overview of Microsoft Project

Microsoft Project can help you manage your project's schedule, costs, and scope in a way that you've never dreamed of. Too often, Project users never use this powerful tool to its fullest potential. In this lesson, you'll discover how to improve your project by adopting a formal management approach. You'll get a quick overview of Project Management, and then you'll learn the basics of Microsoft Project, including a summary of the Gantt Chart view and ways to create and enter project tasks.

Creating a Solid Foundation

If you're looking for ways to keep organized, you'll see just how to do that in this lesson! You'll go through the steps to create a project schedule in no time flat. Once you create and enter tasks in Project's Gantt Chart view, you'll set a schedule by using a calendar and assigning lead times. Then, you'll need to create task dependencies, sometimes known as links. You'll see how to perform these activities and, in the process, you'll become comfortable using Project's many dialog boxes. Before you know it, you'll be creating schedules for all your projects with little effort.

Creating and Managing Resources

You won't get too far with your project without adding resources. While tasks create the backbone of your project, you'll also need people, equipment, and materials to bring your project to life. In this lesson, you'll find out how to apply two types of Project resources—work resources, and material resources. You'll look at two more dialog boxes—Resource Information and Assign Resources—and you'll learn how to analyze resources by using the Resource Sheet and Resource Usage views.

Defining and Assigning Costs

No matter what project you work on, the bottom line is always important. So, get ready to add the final piece to your basic project schedule—costs. You'll start things off by looking through a brief overview of cost accounting, exploring fixed, variable, relevant, and accrued costs. After this review, you'll learn how to assign costs by using the Resource Sheet. You'll even discover how to assign different costs for the same resource and analyze the overall costs for your project by using the Cost Table.

Project Templates, Security, and Constraints

Successful project managers are known for their efficiency and for safeguarding private information. Microsoft Project provides two excellent methods to help you in these areas: project templates and project security. You'll find out how to use some of the many templates Project has to offer, including the Residential Construction template and the New Product template. You'll also learn how to protect your project information with backups, passwords, and write protection. Then you'll discover how to put Project's task constraints to good use.

Working With Views and Managing Information

In this lesson, you'll discover how easy it is to modify your basic schedules and work with project data. You'll look at the various Project views, such as the Calendar, Leveling Gantt, and the Network Diagram. If you don't like the default colors or fonts in your schedule or table, you'll be well-prepared to make changes. You'll even learn how and why you might want to create a combination view; add notes to your project; or sort, filter, and group data.

Fine-Tuning Your Project Plan

Many projects experience schedule compression when management or clients ask that the project be completed sooner and for less. In this lesson, you'll discover how to improve your schedule's performance. You'll explore the Project Statistics dialog box, and you'll learn how to determine the ideal starting point in terms of planned costs and completion dates. You'll see how to change task dependencies to speed up your project and also find out how to split tasks to add more lead time. You'll also learn how to create recurring tasks and attach notes to your project's taskbars.

Baselines and Tracking

Before you implement your project, you need to create a baseline. This will help you track actual results against what you originally set out to accomplish. Microsoft Project makes it possible to set up a baseline with a few mouse clicks. You'll learn how to create a baseline and then see a variety of ways, including using the Tracking toolbar, to record your actual project results.

Managing Variances

Here's where things really start to come together! You'll learn how to compare actual results to your baseline by using the Gantt Chart and reviewing a table. You'll discover how useful status identifiers and progress lines can be to quickly gain information about your project's position. You'll also begin using the Tracking Gantt and filters to automatically identify slipping tasks. You'll also take a stroll through the basics of variance analysis by discussing the Start and Finish Date, Resources, and Work Variance Tables.

Closing Your Project

No project is complete until it's officially closed. In this final lesson, you'll find out how to close your project and use the Organizer to help you customize and copy views for future projects.

Printing Views

Now that you're using reports to share project information, you'll occasionally need to print various views and tables. In this lesson, you'll delve into printing Microsoft Project documents. You'll be a master at creating different views of your project with the Page Setup dialog box, and you'll clearly understand the mechanics of the Print dialog box and the Print Preview.

Using and Creating Reports

Once your project gets rolling, outsiders will probably want to know how things are going. It can be a real time drain answering each request individually. When others request information from you, Microsoft Project offers the perfect solution: Reports. You'll go over a representative sample of the standard reports as well as discuss how to modify and create new reports in this lesson. By the time you finish, you'll be well acquainted with Project's reporting capabilities and also know how to create Visual Reports as Project automatically exports data to Microsoft Excel and Visio.

What you will learn

• Effective planning, implementation, and control projects using Microsoft Project
• How to enhance your project in the areas of efficiency and security
• The importance of setting a project baseline and tracking actual results
• Generate several standard project reports and a wide variety of visual project reports

How you will benefit

• Know how to the use of the world's most popular project management software
• Gain transferable skills
• Replace informal project plans with plans based on logic and structures reflective

Tony Swaim has helped many clients, colleagues, and students reach their professional and personal goals. He has been an online instructor since 1998 and has taught at colleges and universities across the United States since 1981. His focus areas are project management, Six Sigma, and supply chain management. Tony manages a successful consulting firm, and his industry experience includes 20 years of supply chain management. He earned a Doctorate in Business Administration from Kennesaw State University and holds professional certifications in six disciplines, including the Project Management Professional (PMP)® certification from the Project Management Institute (PMI)® and Certified Six Sigma Black Belt (CSSBB)® from the American Society for Quality (ASQ)®.

Learn to create your own newsletters, calendars, brochures, greeting cards, and more with Publisher, the desktop publishing app included in the Microsoft 365 suite. 

Desktop publishing is not just for design professionals! Microsoft Publisher puts desktop publishing within everyone’s reach, with easy-to-use templates and designs that help you create dozens of different publication types, including greeting cards, banners, flyers, and booklets. Best of all, if you have a Microsoft 365 subscription on a Windows PC, Publisher is available at no extra cost.

The online Introduction to Microsoft Publisher course teaches you how to use Microsoft Publisher through a series of engaging and useful projects. With each project, you not only learn about a new publication type, but you also build a set of core application skills that will carry through to your own future projects, no matter what type of publication you need. By course completion, you will know how to create a brochure, design business cards, and much more!

Requirements:

Hardware Requirements:

This course can be taken on either a PC, Mac, or Chromebook device.

Software Requirements:

• PC: Windows 10 or later operating systems.
• Mac: OS 10.6 or later.
• Browser: The latest version of Google Chrome or Mozilla Firefox is preferred. Microsoft Edge and Safari are also compatible.
• Microsoft Office 365 suite with Publisher (not included)
• Microsoft Word Online
• Adobe Acrobat Reader
• Software must be installed and fully operational before the course begins.

Other:

• Email capabilities and access to a personal email account.

Instructional Material Requirements:

The instructional materials required for this course are included in enrollment and will be available online.

Ready to get creative? With Microsoft Publisher, anyone can master desktop publishing. Through dozens of hands-on exercises, you will create newsletters, calendars, greeting cards, brochures, and many other publications you can use for business, clubs, schools, and more. 

Learning Your Way Around Publisher

New to Microsoft Publisher? This lesson provides a gentle, no-experience-required introduction. You will learn how Publisher compares to other apps, such as word processors like Word and higher-end desktop publication programs like Adobe InDesign. You will find out how to create, save, close, and open publication files, and how to get around in the Publisher interface. You will also create your first publication here, and in the process, you will learn about color schemes and font schemes.

Creating a Simple Publication

This lesson introduces some fundamental skills that will apply to almost every publication you will create going forward, including business information sets, text boxes, pictures, and shapes. You will start out by using a template to create a flyer that contains text and graphics, and then change its template and its content. Then you will create an award certificate that contains text and drawn shapes, and you will learn how to stack and group objects.

Creating a Publication from Scratch

Templates are great, but sometimes it is easier to start with a blank slate. In this lesson, you will learn how to create blank publications of various sizes, and how to insert and delete pages in them. You will also get a closer look at how text boxes work, and practice creating, resizing, and moving text boxes, as well as formatting the text within them. You will also learn how to add borders and shading to a text box and adjust its margins and padding.

Creating a Publication using Imported Content

You might sometimes have content created in a different application that you want to use in Publisher. No problem! In this lesson you will learn how to import text from a variety of sources. You will find out how to clear any old formatting from the imported text, and how to make text flow seamlessly from one text box to another. Pictures are another type of content you might want to import, and in this lesson, you will learn how to import a picture and then format it in various ways, including moving and resizing it, applying a border, and applying filters, effects, and color corrections that can improve the picture's original appearance. You will also find out how to control the relationship between text and graphics when they overlap.

Sharing a Publication

What do we create publications for, if not for sharing them with people? In this lesson you will learn all about printing your publications, as well as how to save publications in other digital formats such as PDF and HTML. Then you will learn how to send a publication via an email message in several different ways, including attaching the publication as a PDF or XPS file and sending a publication in the body of a message.

Creating Publications of Different Sizes

Not all publications fit neatly on a standard letter-size sheet of paper. This lesson focuses on three different kinds of publications that all break the size mold in different ways. First you will create a business card and learn about layout options that enable you to print multiple copies per sheet of paper (or cardstock). Then you will learn how to create large banners in Publisher and then either have them professionally printed or piece together a makeshift banner using multiple sheets of paper and a roll of tape. Finally, you will learn how to create advertisements for print publications using whatever size you need to fit the publication's requirements.

Creating Folded Publications

In this lesson, you will learn about three kinds of publications that have one thing in common: they are designed to be folded. You will first create a trifold brochure and discover how to make a brochure layout without interfering with the folds. Then you will plan and create a greeting card (and save yourself a fortune in buying store-bought cards!) Finally, you will create a booklet and learn about setting up mirrored pages and adding headers and footers.

Creating a Newsletter

This lesson is devoted to a single project: a newsletter. You will discover some common newsletter elements and learn how to plan for double-sided printing. Then you will flow text between pages and create notations that help readers find the second part of a story that starts on page 1. Finally, you will learn how to add pictures, design access, and page parts, and how to print a double-sided newsletter using an ordinary home printer that prints on only one side of the paper at once.

Ensuring Consistency

Publisher includes several features that help you make sure your work stays consistently formatted from page to page (and even between publications). You will start out by learning about master pages, which are page templates that help you repeat certain elements and positioning guides on every page of a multi-page publication. Next, you will learn about styles, which apply consistent character and paragraph formatting to text. You will also practice creating and using personal templates, which can be reusable models that can contain both master pages and styles. Finally, you will learn about building blocks, which are saved content snippets you can reuse over and over again.

Creating Magazines and Calendars

This lesson takes your design skills to the next level! You will plan and create a magazine cover that includes a full-page bleed, graphics, text boxes, and other elements. You will learn how to align objects precisely on a page, and how to control character spacing and kerning. Next, you will design a table of contents for a magazine, and in the process, you will learn about Publisher's Tables feature. Finally, you will learn how to create two kinds of calendars: a small one that's part of a larger publication, and a whole publication devoted to a multi-month calendar that you could have professionally printed.

Creating Mail-Merged Letters and Email

Mail merge. The name can sound intimidating, but it's really not that hard! In this lesson, you will create two kinds of mail mergers: a letter to be mailed and an email message to be sent electronically. You will learn about the elements of any mail merge, including a data file, a main document, and merge fields, and you will find out how to combine those elements to make a merge happen.

Creating Labels and Envelopes

In this final lesson, you will learn how to print envelopes and address labels, continuing your exploration of mail mergers. You will first create a single envelope and then expand it into a set of merged envelopes. Then you will first create a single self-stick label and print a whole sheet of the same one (for return-address labels), and then you will expand that into a mail-merged set of address labels for sending out cards or packages. Finally, you will put all your skills together and try out some projects that enable you to showcase what you have learned in the course.

What you will learn

• Create single-page publications like award certificates, flyers, and signs
• Make folded publications, including greeting cards and brochures
• Produce varied sizes of publications, from business cards to banners
• Design multi-page, two-sided publications like booklets, newsletters, and magazines
• Use mail merge to personalize each copy of a publication

How you will benefit

• Become the go-to desktop MS Publisher pro for your business, school, or organization
• Save money by designing and printing your own printed materials
• Express your creativity by creating original publication projects
• Open the door to new career opportunities or potential promotions 

Curt Simmons

Curt Simmons, B.A., M.Ed, is a best-selling author, trainer, and multi-media expert. He holds degrees in English and communication studies and has more than 10 years of experience teaching English and writing in the classroom. Additionally, Simmons has authored numerous books on a wide variety of technology topics and has been a technical editor for numerous other titles.

Learn to create your own newsletters, calendars, brochures, greeting cards, and more with Publisher, the desktop publishing app included in the Microsoft 365 suite. 

Desktop publishing is not just for design professionals! Microsoft Publisher puts desktop publishing within everyone’s reach, with easy-to-use templates and designs that help you create dozens of different publication types, including greeting cards, banners, flyers, and booklets. Best of all, if you have a Microsoft 365 subscription on a Windows PC, Publisher is available at no extra cost.

The online Introduction to Microsoft Publisher course teaches you how to use Microsoft Publisher through a series of engaging and useful projects. With each project, you not only learn about a new publication type, but you also build a set of core application skills that will carry through to your own future projects, no matter what type of publication you need. By course completion, you will know how to create a brochure, design business cards, and much more!

Requirements:

Hardware Requirements:

This course can be taken on either a PC, Mac, or Chromebook device.

Software Requirements:

• PC: Windows 10 or later operating systems.
• Mac: OS 10.6 or later.
• Browser: The latest version of Google Chrome or Mozilla Firefox is preferred. Microsoft Edge and Safari are also compatible.
• Microsoft Office 365 suite with Publisher (not included)
• Microsoft Word Online
• Adobe Acrobat Reader
• Software must be installed and fully operational before the course begins.

Other:

• Email capabilities and access to a personal email account.

Instructional Material Requirements:

The instructional materials required for this course are included in enrollment and will be available online.

Ready to get creative? With Microsoft Publisher, anyone can master desktop publishing. Through dozens of hands-on exercises, you will create newsletters, calendars, greeting cards, brochures, and many other publications you can use for business, clubs, schools, and more. 

Learning Your Way Around Publisher

New to Microsoft Publisher? This lesson provides a gentle, no-experience-required introduction. You will learn how Publisher compares to other apps, such as word processors like Word and higher-end desktop publication programs like Adobe InDesign. You will find out how to create, save, close, and open publication files, and how to get around in the Publisher interface. You will also create your first publication here, and in the process, you will learn about color schemes and font schemes.

Creating a Simple Publication

This lesson introduces some fundamental skills that will apply to almost every publication you will create going forward, including business information sets, text boxes, pictures, and shapes. You will start out by using a template to create a flyer that contains text and graphics, and then change its template and its content. Then you will create an award certificate that contains text and drawn shapes, and you will learn how to stack and group objects.

Creating a Publication from Scratch

Templates are great, but sometimes it is easier to start with a blank slate. In this lesson, you will learn how to create blank publications of various sizes, and how to insert and delete pages in them. You will also get a closer look at how text boxes work, and practice creating, resizing, and moving text boxes, as well as formatting the text within them. You will also learn how to add borders and shading to a text box and adjust its margins and padding.

Creating a Publication using Imported Content

You might sometimes have content created in a different application that you want to use in Publisher. No problem! In this lesson you will learn how to import text from a variety of sources. You will find out how to clear any old formatting from the imported text, and how to make text flow seamlessly from one text box to another. Pictures are another type of content you might want to import, and in this lesson, you will learn how to import a picture and then format it in various ways, including moving and resizing it, applying a border, and applying filters, effects, and color corrections that can improve the picture's original appearance. You will also find out how to control the relationship between text and graphics when they overlap.

Sharing a Publication

What do we create publications for, if not for sharing them with people? In this lesson you will learn all about printing your publications, as well as how to save publications in other digital formats such as PDF and HTML. Then you will learn how to send a publication via an email message in several different ways, including attaching the publication as a PDF or XPS file and sending a publication in the body of a message.

Creating Publications of Different Sizes

Not all publications fit neatly on a standard letter-size sheet of paper. This lesson focuses on three different kinds of publications that all break the size mold in different ways. First you will create a business card and learn about layout options that enable you to print multiple copies per sheet of paper (or cardstock). Then you will learn how to create large banners in Publisher and then either have them professionally printed or piece together a makeshift banner using multiple sheets of paper and a roll of tape. Finally, you will learn how to create advertisements for print publications using whatever size you need to fit the publication's requirements.

Creating Folded Publications

In this lesson, you will learn about three kinds of publications that have one thing in common: they are designed to be folded. You will first create a trifold brochure and discover how to make a brochure layout without interfering with the folds. Then you will plan and create a greeting card (and save yourself a fortune in buying store-bought cards!) Finally, you will create a booklet and learn about setting up mirrored pages and adding headers and footers.

Creating a Newsletter

This lesson is devoted to a single project: a newsletter. You will discover some common newsletter elements and learn how to plan for double-sided printing. Then you will flow text between pages and create notations that help readers find the second part of a story that starts on page 1. Finally, you will learn how to add pictures, design access, and page parts, and how to print a double-sided newsletter using an ordinary home printer that prints on only one side of the paper at once.

Ensuring Consistency

Publisher includes several features that help you make sure your work stays consistently formatted from page to page (and even between publications). You will start out by learning about master pages, which are page templates that help you repeat certain elements and positioning guides on every page of a multi-page publication. Next, you will learn about styles, which apply consistent character and paragraph formatting to text. You will also practice creating and using personal templates, which can be reusable models that can contain both master pages and styles. Finally, you will learn about building blocks, which are saved content snippets you can reuse over and over again.

Creating Magazines and Calendars

This lesson takes your design skills to the next level! You will plan and create a magazine cover that includes a full-page bleed, graphics, text boxes, and other elements. You will learn how to align objects precisely on a page, and how to control character spacing and kerning. Next, you will design a table of contents for a magazine, and in the process, you will learn about Publisher's Tables feature. Finally, you will learn how to create two kinds of calendars: a small one that's part of a larger publication, and a whole publication devoted to a multi-month calendar that you could have professionally printed.

Creating Mail-Merged Letters and Email

Mail merge. The name can sound intimidating, but it's really not that hard! In this lesson, you will create two kinds of mail mergers: a letter to be mailed and an email message to be sent electronically. You will learn about the elements of any mail merge, including a data file, a main document, and merge fields, and you will find out how to combine those elements to make a merge happen.

Creating Labels and Envelopes

In this final lesson, you will learn how to print envelopes and address labels, continuing your exploration of mail mergers. You will first create a single envelope and then expand it into a set of merged envelopes. Then you will first create a single self-stick label and print a whole sheet of the same one (for return-address labels), and then you will expand that into a mail-merged set of address labels for sending out cards or packages. Finally, you will put all your skills together and try out some projects that enable you to showcase what you have learned in the course.

What you will learn

• Create single-page publications like award certificates, flyers, and signs
• Make folded publications, including greeting cards and brochures
• Produce varied sizes of publications, from business cards to banners
• Design multi-page, two-sided publications like booklets, newsletters, and magazines
• Use mail merge to personalize each copy of a publication

How you will benefit

• Become the go-to desktop MS Publisher pro for your business, school, or organization
• Save money by designing and printing your own printed materials
• Express your creativity by creating original publication projects
• Open the door to new career opportunities or potential promotions 

Curt Simmons

Curt Simmons, B.A., M.Ed, is a best-selling author, trainer, and multi-media expert. He holds degrees in English and communication studies and has more than 10 years of experience teaching English and writing in the classroom. Additionally, Simmons has authored numerous books on a wide variety of technology topics and has been a technical editor for numerous other titles.

Learn how the foundational skills needed to utilize Microsoft Word 2019 in Office 365. This course will teach you how to create professional-looking letters, reports, and documents.

Across all industries, the ability to create documents in a word processor is essential in day-to-day functions. From writing reports to Knowing how to use Microsoft Word, the most widely-used word processing program, adds an important skill set to your professional profile.

This course will introduce you to the 2019 version of Microsoft Word, available with the Microsoft 365 platform. You will learn the basics of Word 2019 needed to write and edit text and to create, format, and organize documents. By the time you're done with these hands-on activities, you will be able to use Word confidently at home or on the job.

Requirements:

Hardware Requirements:

• This course must be taken on a PC. Macs and Chromebooks are not compatible.

Software Requirements:

• PC: Windows 10 or later.
• Browser: The latest version of Google Chrome or Mozilla Firefox is preferred. Microsoft Edge is also compatible.
• Microsoft Word 2019 (desktop version) available with the desktop version of Microsoft 365, or Microsoft Office Home and Student 2019 (not included in enrollment)
• Adobe Acrobat Reader.
• Software must be installed and fully operational before the course begins.

Other:

• Email capabilities and access to a personal email account.

Instructional Material Requirements:

The instructional materials required for this course are included in enrollment and will be available online.

Learn to create professional-looking letters, reports, and documents using Microsoft Word 2019/Office 365. This hands-on course will help you master the basic features of this powerful word-processing program to type, edit, and format text, and spell check and print documents like a pro.

Getting Started

In this introductory lesson, you'll learn how to use the different parts of Word 2019's user interface, how to look at your document in different types of views, how to zoom in and out to magnify or shrink your text, and how to change the margins of individual paragraphs.

Typing and Navigation

The whole purpose of Word is to let you create and edit text, so in this lesson, you'll go over the basics of moving the Insertion Pointer, or Cursor, and deleting text. Pressing the BACKSPACE and DELETE keys can delete text one character at a time. The keyboard lets you move the cursor one character, one word, or one line at a time. The mouse lets you quickly move the cursor and scroll through large documents far faster than the keyboard. By knowing the pros and cons of navigating through a document with the keyboard and mouse, you can use both to help you work faster in Word.

File Management

In this lesson, you're going to learn how to save the documents you create in Word. You'll learn how to save documents with unique names, as well as in other formats so that you can share your documents with people using different word processors or even different computers. Finally, you'll learn how to rename, copy, and even delete any files you've created so that you'll always be in complete control of all the files you create.

Editing Text

After you've typed some text in a Word document, you may need to edit that text. The easiest way to edit is to delete individual characters using the BACKSPACE or DELETE keys. Another option is using Word's Overtype mode by typing over text you no longer need. If you ever delete anything by mistake, don't panic! Word's handy Undo and Redo commands retrieve unintentionally deleted text. You may also want to delete large chunks of text. Use your keyboard or mouse in tandem with the BACKSPACE or DELETE keys to efficiently remove entire sections of text. By learning how to delete text and undo mistakes, you can edit your documents quickly using Word.

Working With Multiple Documents

Most people use Word to view and edit a single document at a time, but Word actually lets you open and view two or more documents at the same time. This can be handy for copying text from one document to another, comparing two different drafts of the same document, or simply using one document as a reference while writing in the second one. By learning how to open, switch between, and view multiple documents, you can increase your productivity with Word.

Text Formatting and Alignment

Once you know how to add, delete, copy, and move text, the next step to modifying your document is to change the physical appearance of your text. You can make text appear in different colors or background highlighting, change the actual size of text, alter the alignment of text, and even choose different fonts to modify the way individual letters look. As you can see, Word provides plenty of ways to help you both edit text and change it so it looks visually appealing.

Printing

Most people use Word to print letters and reports. But Word also helps you get creative by letting you choose different paper sizes and orientations. For example, you can print a letter in portrait orientation or print a sign in landscape orientation. Just think of turning a page up so its height is taller than its width (portrait orientation) or turning the page on its side so its width is wider than its height (landscape orientation). Word also lets you choose to print on different paper sizes, such as envelopes, just as long as you can run those odd-shaped paper sheets in your printer. With Word's ability to print on different types of paper sizes and orientation, you can create more than just typical documents using Word.

Margins, Tabs, and Page Numbering

Most of the time when you create a document, you can use the default page settings. But sometimes you may want to modify those settings to change margins around a page to give you more (or less) space on the top, bottom, left, or right sides of a page. By knowing how to set and use margins, you can modify an entire document or just a single page. By using tabs, you can modify how individual paragraphs look on a page. Finally, you'll also learn how to add page numbers to the top or bottom of a page to keep track of the right page order when you print out your document.

Paragraph Formatting

Word can be handy for typing and formatting text, but once you've written several paragraphs worth of text, you may need to format individual paragraphs separately from the rest of your document. Word provides ways to change the appearance of a paragraph's first line, line spacing within a paragraph, and line spacing between paragraphs. In addition, Word lets you create bullet and numbered lists, so you can display short bits of information in a visual manner. With Word's various paragraph-formatting options, you can customize the appearance of all your paragraphs.

Language Tools

It's not enough just to write and format your text. After you're done writing, you may need to check your spelling, change your words, and even hyphenate your text to make your entire document look the best it can. For important documents, you may even need to collaborate with others. To keep track of all the changes multiple authors may make to a single document, Word offers a Track Changes feature, so you can see exactly what and who changed the document. With so many ways to polish your document, there's no reason not to write exactly what you want to say with Word.

Customizing Word

Word can easily handle any characters you type with a keyboard, but sometimes you may need to type an occasional foreign language character, a mathematical symbol, or another unusual character that doesn't appear on your keyboard. With Word, you can press different types of keystrokes or search and click the symbol you want to use. This lets you add practically any type of unusual character to your documents, even smiley faces. You probably won't need to type all of these characters regularly, so just find the ones you'll likely need and remember how to use them. Word lets you type practically anything you want, regardless of the limitation of the keys on your keyboard.

Making a Word Document Pretty and Organized

Writing involves more than just typing and editing text. With Word's advanced features, you can insert page breaks and cover pages to adjust how your text appears when you print it out. To make text on each page look its best, you can use drop caps and styles. Finally, you can use outlines to organize your text and quickly move chunks of text within a document just by rearranging an outline heading. By learning these advanced features of Word, you can make each document display text in the most appealing way possible.

What you will learn

• Fundamentals of one of the most crucial software applications in the modern workplace
• Skills and tools needed to adjust margins, spacing, layout, and design of any Word document
• How to work on multiple projects at once and become faster and more efficient in a variety of Microsoft Word tasks
• Techniques for modifying the appearance of your documents in order to suit your needs

How you will benefit

• Gain the confidence needed to make the most of this indispensable software application
• Learn how to make the perfect layout for useful documents of any occasion - resumes, invitations, letters, articles, training materials, and much more
• Save time and avoid frustration by familiarizing yourself with the wide variety of tools at your disposal in Word 2019
• Become more proficient with one of the most widely used software programs in history

Wallace Wang is the author of over 40 computer books including "Microsoft Office 2019 For Dummies." In addition to writing computer books, he has also co-authored "Breaking Into Acting for Dummies" and ghost written several books about investing in real estate, day trading stocks, and becoming an entrepreneur. Some of his past jobs have included teaching computer science courses at the University of Zimbabwe, performing stand-up comedy, and appearing on a weekly radio show.

Learn how the foundational skills needed to utilize Microsoft Word 2019 in Office 365. This course will teach you how to create professional-looking letters, reports, and documents.

Across all industries, the ability to create documents in a word processor is essential in day-to-day functions. From writing reports to Knowing how to use Microsoft Word, the most widely-used word processing program, adds an important skill set to your professional profile.

This course will introduce you to the 2019 version of Microsoft Word, available with the Microsoft 365 platform. You will learn the basics of Word 2019 needed to write and edit text and to create, format, and organize documents. By the time you're done with these hands-on activities, you will be able to use Word confidently at home or on the job.

Requirements:

Hardware Requirements:

• This course must be taken on a PC. Macs and Chromebooks are not compatible.

Software Requirements:

• PC: Windows 10 or later.
• Browser: The latest version of Google Chrome or Mozilla Firefox is preferred. Microsoft Edge is also compatible.
• Microsoft Word 2019 (desktop version) available with the desktop version of Microsoft 365, or Microsoft Office Home and Student 2019 (not included in enrollment)
• Adobe Acrobat Reader.
• Software must be installed and fully operational before the course begins.

Other:

• Email capabilities and access to a personal email account.

Instructional Material Requirements:

The instructional materials required for this course are included in enrollment and will be available online.

Learn to create professional-looking letters, reports, and documents using Microsoft Word 2019/Office 365. This hands-on course will help you master the basic features of this powerful word-processing program to type, edit, and format text, and spell check and print documents like a pro.

Getting Started

In this introductory lesson, you'll learn how to use the different parts of Word 2019's user interface, how to look at your document in different types of views, how to zoom in and out to magnify or shrink your text, and how to change the margins of individual paragraphs.

Typing and Navigation

The whole purpose of Word is to let you create and edit text, so in this lesson, you'll go over the basics of moving the Insertion Pointer, or Cursor, and deleting text. Pressing the BACKSPACE and DELETE keys can delete text one character at a time. The keyboard lets you move the cursor one character, one word, or one line at a time. The mouse lets you quickly move the cursor and scroll through large documents far faster than the keyboard. By knowing the pros and cons of navigating through a document with the keyboard and mouse, you can use both to help you work faster in Word.

File Management

In this lesson, you're going to learn how to save the documents you create in Word. You'll learn how to save documents with unique names, as well as in other formats so that you can share your documents with people using different word processors or even different computers. Finally, you'll learn how to rename, copy, and even delete any files you've created so that you'll always be in complete control of all the files you create.

Editing Text

After you've typed some text in a Word document, you may need to edit that text. The easiest way to edit is to delete individual characters using the BACKSPACE or DELETE keys. Another option is using Word's Overtype mode by typing over text you no longer need. If you ever delete anything by mistake, don't panic! Word's handy Undo and Redo commands retrieve unintentionally deleted text. You may also want to delete large chunks of text. Use your keyboard or mouse in tandem with the BACKSPACE or DELETE keys to efficiently remove entire sections of text. By learning how to delete text and undo mistakes, you can edit your documents quickly using Word.

Working With Multiple Documents

Most people use Word to view and edit a single document at a time, but Word actually lets you open and view two or more documents at the same time. This can be handy for copying text from one document to another, comparing two different drafts of the same document, or simply using one document as a reference while writing in the second one. By learning how to open, switch between, and view multiple documents, you can increase your productivity with Word.

Text Formatting and Alignment

Once you know how to add, delete, copy, and move text, the next step to modifying your document is to change the physical appearance of your text. You can make text appear in different colors or background highlighting, change the actual size of text, alter the alignment of text, and even choose different fonts to modify the way individual letters look. As you can see, Word provides plenty of ways to help you both edit text and change it so it looks visually appealing.

Printing

Most people use Word to print letters and reports. But Word also helps you get creative by letting you choose different paper sizes and orientations. For example, you can print a letter in portrait orientation or print a sign in landscape orientation. Just think of turning a page up so its height is taller than its width (portrait orientation) or turning the page on its side so its width is wider than its height (landscape orientation). Word also lets you choose to print on different paper sizes, such as envelopes, just as long as you can run those odd-shaped paper sheets in your printer. With Word's ability to print on different types of paper sizes and orientation, you can create more than just typical documents using Word.

Margins, Tabs, and Page Numbering

Most of the time when you create a document, you can use the default page settings. But sometimes you may want to modify those settings to change margins around a page to give you more (or less) space on the top, bottom, left, or right sides of a page. By knowing how to set and use margins, you can modify an entire document or just a single page. By using tabs, you can modify how individual paragraphs look on a page. Finally, you'll also learn how to add page numbers to the top or bottom of a page to keep track of the right page order when you print out your document.

Paragraph Formatting

Word can be handy for typing and formatting text, but once you've written several paragraphs worth of text, you may need to format individual paragraphs separately from the rest of your document. Word provides ways to change the appearance of a paragraph's first line, line spacing within a paragraph, and line spacing between paragraphs. In addition, Word lets you create bullet and numbered lists, so you can display short bits of information in a visual manner. With Word's various paragraph-formatting options, you can customize the appearance of all your paragraphs.

Language Tools

It's not enough just to write and format your text. After you're done writing, you may need to check your spelling, change your words, and even hyphenate your text to make your entire document look the best it can. For important documents, you may even need to collaborate with others. To keep track of all the changes multiple authors may make to a single document, Word offers a Track Changes feature, so you can see exactly what and who changed the document. With so many ways to polish your document, there's no reason not to write exactly what you want to say with Word.

Customizing Word

Word can easily handle any characters you type with a keyboard, but sometimes you may need to type an occasional foreign language character, a mathematical symbol, or another unusual character that doesn't appear on your keyboard. With Word, you can press different types of keystrokes or search and click the symbol you want to use. This lets you add practically any type of unusual character to your documents, even smiley faces. You probably won't need to type all of these characters regularly, so just find the ones you'll likely need and remember how to use them. Word lets you type practically anything you want, regardless of the limitation of the keys on your keyboard.

Making a Word Document Pretty and Organized

Writing involves more than just typing and editing text. With Word's advanced features, you can insert page breaks and cover pages to adjust how your text appears when you print it out. To make text on each page look its best, you can use drop caps and styles. Finally, you can use outlines to organize your text and quickly move chunks of text within a document just by rearranging an outline heading. By learning these advanced features of Word, you can make each document display text in the most appealing way possible.

What you will learn

• Fundamentals of one of the most crucial software applications in the modern workplace
• Skills and tools needed to adjust margins, spacing, layout, and design of any Word document
• How to work on multiple projects at once and become faster and more efficient in a variety of Microsoft Word tasks
• Techniques for modifying the appearance of your documents in order to suit your needs

How you will benefit

• Gain the confidence needed to make the most of this indispensable software application
• Learn how to make the perfect layout for useful documents of any occasion - resumes, invitations, letters, articles, training materials, and much more
• Save time and avoid frustration by familiarizing yourself with the wide variety of tools at your disposal in Word 2019
• Become more proficient with one of the most widely used software programs in history

Wallace Wang is the author of over 40 computer books including "Microsoft Office 2019 For Dummies." In addition to writing computer books, he has also co-authored "Breaking Into Acting for Dummies" and ghost written several books about investing in real estate, day trading stocks, and becoming an entrepreneur. Some of his past jobs have included teaching computer science courses at the University of Zimbabwe, performing stand-up comedy, and appearing on a weekly radio show.

Learn to use this powerful new operating system, including how to customize your desktop, manage files and folders, and navigate the web with the new Microsoft Edge browser.

Welcome to Windows 10, the completely new operating system from Microsoft, which offers a more robust, more powerful, and completely unique computing experience. In this course, you will gain the foundation you need to get started right away using Windows 10.

File Explorer can help you manage your files and create basic text documents using WordPad. From managing files and editing photos to working with external drives, you will learn everything you need to know about getting the most from this operating system. Additionally, since security is important, you will also learn how to protect your files and how to protect and update Windows 10.

By the time you finish this course, you will have mastered the basic skills you need to get the most from Windows 10 for both work and play.

Requirements:

Hardware Requirements:

• This course must be taken on a PC. Macs are not compatible.

Software Requirements:

• PC: Windows 10 or later.
• Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge is also compatible.
• Adobe Acrobat Reader.
• Software must be installed and fully operational before the course begins.

Other:

• Email capabilities and access to a personal email account.

Instructional Material Requirements:

The instructional materials required for this course are included in enrollment and will be available online.

Master the basic skills you need to get the most from Windows 10 for both work and play. This course will help you learn to use this powerful new operating system, including customizing your desktop, managing files and folders, and navigating the web with the new Microsoft Edge browser.

Getting Started

Learn the basics that every computer user must know in order to use a computer with minimal frustration followed by the most important skills and terminology that allow you to control what you see on your screen at all times. Then, explore the revised Start Menu and Apps in Windows 10.

Use the Start Menu and Apps

This lesson explores the revised Start Menu and Apps in Windows 10. You will explore the Windows Store and learn how to customize the Start Menu.

Personalizing Your Windows Desktop

In this lesson, you will have fun personalizing your computer by choosing your own desktop pictures, window colors, and sound scheme. The skills you learn in this lesson will go a long way to helping you gain complete control of your computer.

Working With Text and Files

No matter how you intend to use your computer, there will be times when there's some typing involved. It might be for writing email messages, memos, or letters, or it might be for taking notes in a course, or for chatting with others on a website. Whatever the reason, this lesson will teach you all the tricks for making typing quick and easy.

Exploring Your System

Everything that's in your computer is stored on its hard drive. The hard drive is like a filing cabinet containing files organized into folders. Finding files that you have saved is a matter of opening the filing cabinet, so to speak, and then locating the correct folder. In this lesson, you will learn how it all works.

Using OneDrive and Cortana

In this lesson, you will explore two Windows 10 features: OneDrive and Cortana. OneDrive is a cloud storage solution that lets you store files and folders both on your PC as well as the Microsoft cloud. Cortana is Microsoft's personal digital assistant that can help find files, folders, apps, and settings on your PC as well as information on the Internet.

Manage and Edit Your Photos

In this lesson, you will learn how to organize your photos and view them using Windows 10's Photos App. You will see how to view individual photos, draw and rotate, and auto-enhance your shots. You will also learn about the Photos App editing tools for adjusting brightness and contrast, cropping, and more.

Using Edge

It's likely that you have seen references to .com sites in ads and elsewhere. This lesson introduces Edge, the program that provides access to websites like Facebook, Twitter, Google, and many others.

Managing Files and Folders

This lesson will explore managing files and folders. In many work and school environments, people just assume you know how to manage files, and they rarely provide any details on copying, moving, or renaming files and folders.

More Fun With File Management

In this lesson, you will expand your file management skills by learning how to delete and recover files. You will learn how to select multiple files to work with, so you don't always have to manage your files one at a time.

Protect Your Valuable Files

This lesson is all about using the tools and techniques built into Windows to help you protect your valuable files. Your computer is an investment of money, and the pictures and other files you store on your computer are an investment of time.

Tips, Tricks, and Shortcuts

In your final lesson, you will learn some more techniques for protecting your computer, including using resources for free protection from viruses and spyware. You will learn how to remove programs you no longer want or need and discover some great timesaving tips and shortcuts to help you make the most out of Windows 10.

What you will learn

• Find your way around Windows 10 with the desktop, Start menu, and system settings
• Learn to customize features and personalize your desktop
• Discover how File Explorer can help you manage files and learn to create basic text documents using WordPad
• Learn how to protect your files and update Windows 10

How you will benefit

• Gain confidence in your use of the Windows 10 operating system for personal and business use
• Learn how to use your PC effectively, starting with Windows
• Experience reduced frustration and setbacks by learning to operating your computer properly
• Become a more independent computer user

Curt Simmons, B.A., M.Ed, is a best-selling author, trainer, and multi-media expert. He holds degrees in English and communication studies and has more than 10 years of experience teaching English and writing in the classroom. Additionally, Simmons has authored numerous books on a wide variety of technology topics and has been a technical editor for numerous other titles.

Learn to use this powerful new operating system, including how to customize your desktop, manage files and folders, and navigate the web with the new Microsoft Edge browser.

Welcome to Windows 10, the completely new operating system from Microsoft, which offers a more robust, more powerful, and completely unique computing experience. In this course, you will gain the foundation you need to get started right away using Windows 10.

File Explorer can help you manage your files and create basic text documents using WordPad. From managing files and editing photos to working with external drives, you will learn everything you need to know about getting the most from this operating system. Additionally, since security is important, you will also learn how to protect your files and how to protect and update Windows 10.

By the time you finish this course, you will have mastered the basic skills you need to get the most from Windows 10 for both work and play.

Requirements:

Hardware Requirements:

• This course must be taken on a PC. Macs are not compatible.

Software Requirements:

• PC: Windows 10 or later.
• Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge is also compatible.
• Adobe Acrobat Reader.
• Software must be installed and fully operational before the course begins.

Other:

• Email capabilities and access to a personal email account.

Instructional Material Requirements:

The instructional materials required for this course are included in enrollment and will be available online.

Master the basic skills you need to get the most from Windows 10 for both work and play. This course will help you learn to use this powerful new operating system, including customizing your desktop, managing files and folders, and navigating the web with the new Microsoft Edge browser.

Getting Started

Learn the basics that every computer user must know in order to use a computer with minimal frustration followed by the most important skills and terminology that allow you to control what you see on your screen at all times. Then, explore the revised Start Menu and Apps in Windows 10.

Use the Start Menu and Apps

This lesson explores the revised Start Menu and Apps in Windows 10. You will explore the Windows Store and learn how to customize the Start Menu.

Personalizing Your Windows Desktop

In this lesson, you will have fun personalizing your computer by choosing your own desktop pictures, window colors, and sound scheme. The skills you learn in this lesson will go a long way to helping you gain complete control of your computer.

Working With Text and Files

No matter how you intend to use your computer, there will be times when there's some typing involved. It might be for writing email messages, memos, or letters, or it might be for taking notes in a course, or for chatting with others on a website. Whatever the reason, this lesson will teach you all the tricks for making typing quick and easy.

Exploring Your System

Everything that's in your computer is stored on its hard drive. The hard drive is like a filing cabinet containing files organized into folders. Finding files that you have saved is a matter of opening the filing cabinet, so to speak, and then locating the correct folder. In this lesson, you will learn how it all works.

Using OneDrive and Cortana

In this lesson, you will explore two Windows 10 features: OneDrive and Cortana. OneDrive is a cloud storage solution that lets you store files and folders both on your PC as well as the Microsoft cloud. Cortana is Microsoft's personal digital assistant that can help find files, folders, apps, and settings on your PC as well as information on the Internet.

Manage and Edit Your Photos

In this lesson, you will learn how to organize your photos and view them using Windows 10's Photos App. You will see how to view individual photos, draw and rotate, and auto-enhance your shots. You will also learn about the Photos App editing tools for adjusting brightness and contrast, cropping, and more.

Using Edge

It's likely that you have seen references to .com sites in ads and elsewhere. This lesson introduces Edge, the program that provides access to websites like Facebook, Twitter, Google, and many others.

Managing Files and Folders

This lesson will explore managing files and folders. In many work and school environments, people just assume you know how to manage files, and they rarely provide any details on copying, moving, or renaming files and folders.

More Fun With File Management

In this lesson, you will expand your file management skills by learning how to delete and recover files. You will learn how to select multiple files to work with, so you don't always have to manage your files one at a time.

Protect Your Valuable Files

This lesson is all about using the tools and techniques built into Windows to help you protect your valuable files. Your computer is an investment of money, and the pictures and other files you store on your computer are an investment of time.

Tips, Tricks, and Shortcuts

In your final lesson, you will learn some more techniques for protecting your computer, including using resources for free protection from viruses and spyware. You will learn how to remove programs you no longer want or need and discover some great timesaving tips and shortcuts to help you make the most out of Windows 10.

What you will learn

• Find your way around Windows 10 with the desktop, Start menu, and system settings
• Learn to customize features and personalize your desktop
• Discover how File Explorer can help you manage files and learn to create basic text documents using WordPad
• Learn how to protect your files and update Windows 10

How you will benefit

• Gain confidence in your use of the Windows 10 operating system for personal and business use
• Learn how to use your PC effectively, starting with Windows
• Experience reduced frustration and setbacks by learning to operating your computer properly
• Become a more independent computer user

Curt Simmons, B.A., M.Ed, is a best-selling author, trainer, and multi-media expert. He holds degrees in English and communication studies and has more than 10 years of experience teaching English and writing in the classroom. Additionally, Simmons has authored numerous books on a wide variety of technology topics and has been a technical editor for numerous other titles.

Earning Microsoft Offices Specialist certification is an important career steppingstone if you work with Office products. This course will prepare you for the Microsoft Office Specialist Access Certification exam.

Requirements:

Hardware Requirements:

• This course must be taken on a PC. Macs are not compatible.

Software Requirements:

• PC: Windows 10 or later.
• Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge is also compatible.
• Microsoft Access 2019 or Microsoft Access 365 (not included in enrollment). While Microsoft Access 2019 is ideal, you can use the version of Access included in the desktop version of Microsoft 365. Please note: There may be some differences between your version of Access and what you see in the course.
• Adobe Acrobat Reader.
• Software must be installed and fully operational before the course begins.

Other:

• Email capabilities and access to a personal email account.

Instructional Material Requirements:

The instructional materials required for this course are included in enrollment.

Most employers seek candidates with a working knowledge of Microsoft Office. Being a certified Microsoft Office Specialist (MOS) gives your resume a boost and the potential to earn a higher salary than your non-certified peers. If you work with Access regularly, it's time to bring your skills to the next level by earning your Microsoft Office Specialist Access certification.

This Microsoft Access Training course will prepare you for the Microsoft Office Specialist Access certification exam. You will first learn foundational database concepts. You will then learn to create databases and tables, query those tables, and create reports. By course completion, you will be able to design, customize, and fully optimize an Access database. These key skills are fundamental to passing the MOS MO-500 exam and earning your certification.

This course offers enrollment with or without a voucher. The voucher is prepaid access to sit for the certifying exam upon eligibility.

1. Introduction to Microsoft Access     
   1. Quick Overview of the Access User Interface
   2. Fundamentals
   3. Tables and Their Views
   4. Tables
   5. Queries
   6. Forms
   7. Reports
   8. Introduction to Microsoft Access Final Exam
2. Advanced Microsoft Access     
   1. Relationships
   2. Queries
   3. Table Functions
   4. Forms
   5. Reports
   6. Macros
   7. Completing the Desktop Application
   8. Advanced Microsoft Access Final Exam
3. Microsoft Access Final Exam

What you will learn

• Database concepts, interface and terminology
• Table views, queries, forms, reports, and macros
• Database design fundamentals
• Forms, reports, table relationship and desktop application with the navigation form

How you will benefit

• Become prepared to take the Microsoft Office Specialist Access Certification exam
• Become a vital asset to any business by mastering database management and creation
• Discover advanced Microsoft Access techniques that will set you apart from competitors

Tracy Berry has been a senior graphic designer/programmer, instructor, and consultant since 1993 and has developed hundreds of logos, marketing materials, websites, and multimedia solutions for customers worldwide. She was also involved in several large corporate software rollouts. She has helped many organizations optimize and streamline data solutions. She teaches both onsite and online courses and has her CTT (Certified Technical Trainer) certification. Tracy specializes in teaching graphics, desktop publishing, web design, and reporting/productivity applications.

Earning Microsoft Offices Specialist certification is an important career steppingstone if you work with Office products. This course will prepare you for the Microsoft Office Specialist Access Certification exam.

Requirements:

Hardware Requirements:

• This course must be taken on a PC. Macs are not compatible.

Software Requirements:

• PC: Windows 10 or later.
• Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge is also compatible.
• Microsoft Access 2019 or Microsoft Access 365 (not included in enrollment). While Microsoft Access 2019 is ideal, you can use the version of Access included in the desktop version of Microsoft 365. Please note: There may be some differences between your version of Access and what you see in the course.
• Adobe Acrobat Reader.
• Software must be installed and fully operational before the course begins.

Other:

• Email capabilities and access to a personal email account.

Instructional Material Requirements:

The instructional materials required for this course are included in enrollment.

Most employers seek candidates with a working knowledge of Microsoft Office. Being a certified Microsoft Office Specialist (MOS) gives your resume a boost and the potential to earn a higher salary than your non-certified peers. If you work with Access regularly, it's time to bring your skills to the next level by earning your Microsoft Office Specialist Access certification.

This Microsoft Access Training course will prepare you for the Microsoft Office Specialist Access certification exam. You will first learn foundational database concepts. You will then learn to create databases and tables, query those tables, and create reports. By course completion, you will be able to design, customize, and fully optimize an Access database. These key skills are fundamental to passing the MOS MO-500 exam and earning your certification.

This course offers enrollment with or without a voucher. The voucher is prepaid access to sit for the certifying exam upon eligibility.

1. Introduction to Microsoft Access     
   1. Quick Overview of the Access User Interface
   2. Fundamentals
   3. Tables and Their Views
   4. Tables
   5. Queries
   6. Forms
   7. Reports
   8. Introduction to Microsoft Access Final Exam
2. Advanced Microsoft Access     
   1. Relationships
   2. Queries
   3. Table Functions
   4. Forms
   5. Reports
   6. Macros
   7. Completing the Desktop Application
   8. Advanced Microsoft Access Final Exam
3. Microsoft Access Final Exam

What you will learn

• Database concepts, interface and terminology
• Table views, queries, forms, reports, and macros
• Database design fundamentals
• Forms, reports, table relationship and desktop application with the navigation form

How you will benefit

• Become prepared to take the Microsoft Office Specialist Access Certification exam
• Become a vital asset to any business by mastering database management and creation
• Discover advanced Microsoft Access techniques that will set you apart from competitors

Tracy Berry has been a senior graphic designer/programmer, instructor, and consultant since 1993 and has developed hundreds of logos, marketing materials, websites, and multimedia solutions for customers worldwide. She was also involved in several large corporate software rollouts. She has helped many organizations optimize and streamline data solutions. She teaches both onsite and online courses and has her CTT (Certified Technical Trainer) certification. Tracy specializes in teaching graphics, desktop publishing, web design, and reporting/productivity applications.

Becoming a certified Microsoft Office Specialist (MOS) Expert demonstrates your mastery of Microsoft Office products. This course prepares you for the Microsoft Office Specialist Expert certification exam for Microsoft Excel.

Requirements:

Hardware Requirements:

• This course must be taken on a PC. Macs are not compatible.

Software Requirements:

• PC: Windows 10 or later.
• Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge is also compatible.
• Microsoft Excel 2019 or Microsoft Excel 365 (not included in enrollment). While Microsoft Excel 2019 is ideal, you can use the version of Excel included in the desktop version of Microsoft 365. Please note: There may be some differences between your version of Excel and what you see in the course.
• Adobe Acrobat Reader.
• Software must be installed and fully operational before the course begins.

Other:

• Email capabilities and access to a personal email account.

Instructional Material Requirements:

The instructional materials required for this course are included in enrollment.

If your organization uses lists of any kind, you need to know how to use Microsoft Excel. Earning Microsoft Office Specialist Excel Expert certification sets your professional skill set apart from other Excel users. The course will prepare you for the Microsoft Office Specialist: Microsoft Excel Expert exam.

You will first learn to use Excel to create, modify, and format Excel worksheets, perform calculations, and print Excel workbooks. The course then moves on to teach you how to use advanced formulas, work with lists, work with illustrations and charts, and use advanced formatting techniques. You will also learn Excel's advanced features, such as pivot tables, audit worksheets, data tools, macros, and collaboration methods.

Upon completion of this course, you will be prepared for the Microsoft Excel Expert certification exam, Exam MO-201. This course offers enrollment with or without a voucher. The voucher is prepaid access to sit for the certifying exam upon eligibility. Proctor fees may apply, which are not included.

What you will learn

• To create, modify, and manage Excel workbooks
• To use formulas, functions and work with tables
• To convert, sort, filter, and manage lists
• To use conditional formatting and styles
• To create pivot tables and charts
• To import and export data

How you will benefit

• Become a certified Microsoft Office Specialist (MOS) Expert in Excel
• Use these skills in most workplace situations
• Manipulate data faster by learning helpful formulas and tricks

Tracy Berry has been a senior graphic designer/programmer, instructor, and consultant since 1993 and has developed hundreds of logos, marketing materials, websites, and multimedia solutions for customers worldwide. She was also involved in several large corporate software rollouts. She has helped many organizations optimize and streamline data solutions. She teaches both onsite and online courses and has her CTT (Certified Technical Trainer) certification. Tracy specializes in teaching graphics, desktop publishing, web design, and reporting/productivity applications.

Becoming a certified Microsoft Office Specialist (MOS) Expert demonstrates your mastery of Microsoft Office products. This course prepares you for the Microsoft Office Specialist Expert certification exam for Microsoft Excel.

Requirements:

Hardware Requirements:

• This course must be taken on a PC. Macs are not compatible.

Software Requirements:

• PC: Windows 10 or later.
• Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge is also compatible.
• Microsoft Excel 2019 or Microsoft Excel 365 (not included in enrollment). While Microsoft Excel 2019 is ideal, you can use the version of Excel included in the desktop version of Microsoft 365. Please note: There may be some differences between your version of Excel and what you see in the course.
• Adobe Acrobat Reader.
• Software must be installed and fully operational before the course begins.

Other:

• Email capabilities and access to a personal email account.

Instructional Material Requirements:

The instructional materials required for this course are included in enrollment.

If your organization uses lists of any kind, you need to know how to use Microsoft Excel. Earning Microsoft Office Specialist Excel Expert certification sets your professional skill set apart from other Excel users. The course will prepare you for the Microsoft Office Specialist: Microsoft Excel Expert exam.

You will first learn to use Excel to create, modify, and format Excel worksheets, perform calculations, and print Excel workbooks. The course then moves on to teach you how to use advanced formulas, work with lists, work with illustrations and charts, and use advanced formatting techniques. You will also learn Excel's advanced features, such as pivot tables, audit worksheets, data tools, macros, and collaboration methods.

Upon completion of this course, you will be prepared for the Microsoft Excel Expert certification exam, Exam MO-201. This course offers enrollment with or without a voucher. The voucher is prepaid access to sit for the certifying exam upon eligibility. Proctor fees may apply, which are not included.

What you will learn

• To create, modify, and manage Excel workbooks
• To use formulas, functions and work with tables
• To convert, sort, filter, and manage lists
• To use conditional formatting and styles
• To create pivot tables and charts
• To import and export data

How you will benefit

• Become a certified Microsoft Office Specialist (MOS) Expert in Excel
• Use these skills in most workplace situations
• Manipulate data faster by learning helpful formulas and tricks

Tracy Berry has been a senior graphic designer/programmer, instructor, and consultant since 1993 and has developed hundreds of logos, marketing materials, websites, and multimedia solutions for customers worldwide. She was also involved in several large corporate software rollouts. She has helped many organizations optimize and streamline data solutions. She teaches both onsite and online courses and has her CTT (Certified Technical Trainer) certification. Tracy specializes in teaching graphics, desktop publishing, web design, and reporting/productivity applications.

The Microsoft Office Specialist (MOS) Associate Certification Training course will prepare you to take the Microsoft Office Specialist certification exams for Word, Excel, PowerPoint, and Outlook. Exam fees are included in the course cost.

Requirements:

Hardware Requirements:

• This course must be taken on a PC. Macs are not compatible.

Software Requirements:

• PC: Windows 10 or later.
• Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge is also compatible.
• Microsoft Word, Excel, PowerPoint, and Outlook 2019 or Microsoft Office 365 (not included in enrollment). While Microsoft Word, Excel, PowerPoint, and Outlook 2019 are ideal, you can use the desktop versions of each included with Microsoft 365. Please note: There may be some differences between your version of these programs and what you see in the course.
• Adobe Acrobat Reader.
• Software must be installed and fully operational before the course begins.

Other:

• Email capabilities and access to a personal email account.

Instructional Material Requirements:

The instructional materials required for this course are included in enrollment and will be available online. Manuals are included as downloadable PDFs throughout the course.

While proficiency in Microsoft Office is essential in most professional settings, earning a Microsoft Office Associate certification signifies that you have a deep level of skills needed to use the Office suite.

The Microsoft Office Specialist (MOS) Associate Certification Training course will teach you how to use the Microsoft Office suite at an advanced level. You will build your expertise through hands-on exercises, in-depth course material, and supplemental video demonstrations. You will also prepare for the certification exams for Word, Excel, PowerPoint, and Outlook. As you prepare for each exam, you will test your skills at regular intervals with quizzes and exams.

By course completion, you will be fully prepared to take the MO-200 and MO-201 (Excel), MO-100 and MO-101 (Word), MO-300 (PowerPoint), and MO-400 (Outlook) exams. To earn the  Microsoft Office Specialist (MOS) Associate Certification, you must successfully complete the MO-100 (Word), MO-200 (Excel) , and MO-300 (PowerPoint). 

This course offers enrollment with or without vouchers. The vouchers are prepaid access to sit for the certifying exams upon eligibility. Proctor fees may apply, which are not included.

1. Microsoft Word  
   1. Introduction to Microsoft Word
      1. Creating a Microsoft Word Document
      2. The Ribbon
      3. The File Tab
      4. The Quick Access Toolbar
      5. Formatting Microsoft Word Documents
      6. Editing Documents
      7. Finalizing Microsoft Word Documents
      8. Introduction to Microsoft Word Exam
   2. Intermediate Microsoft Word
      1. Advanced Formatting
      2. Working with Tables
      3. Working with Images
      4. Page Layout
      5. Working with Illustrations
      6. Viewing Your Document(s)
      7. Intermediate Microsoft Word Exam
   3. Advanced Microsoft Word
      1. Working with Long Documents
      2. Reviewing and Collaborating on Documents
      3. Comparing and Combining Documents
      4. Managing Mailings
      5. Protecting Documents
      6. Random Useful Items
      7. Advanced Microsoft Word Exam
   4. Microsoft Word Final Exam
2. Microsoft Excel  
   1. Introduction to Microsoft Excel
      1. Creating a Microsoft Excel Workbook
      2. The Ribbon
      3. The Backstage View (The File Menu)
      4. Entering Data in Microsoft Excel Worksheets
      5. Formatting Microsoft Excel Worksheets
      6. Using Formulas in Microsoft Excel
      7. Working with Rows and Columns
      8. Editing Worksheets
      9. Finalizing Microsoft Excel Worksheets
      10. Introduction to Microsoft Excel Exam
   2. Intermediate Microsoft Excel
      1. Advanced Formulas
      2. Working with Lists
      3. Working with Illustrations
      4. Visualizing Your Data
      5. Working with Tables
      6. Advanced Formatting
      7. Intermediate Microsoft Excel Exam
   3. Advanced Microsoft Excel
      1. Using Pivot Tables
      2. Auditing Worksheets
      3. Data Tools
      4. Working with Others
      5. Recording and Using Macros
      6. Random Useful Items
      7. Advanced Microsoft Excel Exam
   4. Microsoft Excel Final Exam
3. Microsoft PowerPoint  
   1. Introduction to Microsoft PowerPoint
      1. Creating a PowerPoint Presentation
      2. The Ribbon
      3. The Quick Access Toolbar
      4. The Backstage View (The File Menu)
      5. Formatting Microsoft PowerPoint Presentations
      6. Working with Images
      7. Working with Tables and Charts
      8. Finalizing Microsoft PowerPoint Presentations
      9. Introduction to Microsoft PowerPoint Final Exam
   2. Advanced Microsoft PowerPoint
      1. Customizing Presentations
      2. Presentation Masters
      3. Working with Special Effects
      4. Using SmartArt
      5. Multimedia
      6. Setting Up the Slide Show
      7. Outlines and Slides
      8. Managing Multiple Presentations
      9. Sharing and Securing a Presentation
      10. Advanced Microsoft PowerPoint Final Exam
   3. Microsoft PowerPoint Final Exam
4. Microsoft Outlook     
   1. Introduction to Microsoft Outlook
      1. The Outlook Interface
      2. Performing Popular Tasks in Outlook
      3. Working with Messages
      4. Working with the Calendar
      5. Organizing Contacts
      6. Introduction to Microsoft Outlook Exam
   2. Advanced Microsoft Outlook
      1. Working with Tasks and Notes
      2. Using Signature and Themes
      3. Managing Your Inbox
      4. Working with Multiple Email Accounts
      5. Advanced Microsoft Outlook Exam
   3. Microsoft Outlook Final Exam

What you will learn

• Learn the most advanced skills and techniques to best use Microsoft Office programs Word, Excel, PowerPoint, and Outlook
• Create professional Word documents
• Present information in a compelling way using PowerPoint
• Organize lists, utilize spreadsheets, and manage other data with Excel
• Send messages, manage calendars, and collaborate with coworkers across Outlook

How you will benefit

• Prepare to take the Microsoft Office Specialist (MOS) Associate certification exams
• Demonstrate your advanced understanding of the most commonly used Microsoft Office products

Tracy Berry has been a senior graphic designer/programmer, instructor, and consultant since 1993 and has developed hundreds of logos, marketing materials, websites, and multimedia solutions for customers worldwide. She was also involved in several large corporate software rollouts. She has helped many organizations optimize and streamline data solutions. She teaches both onsite and online courses and has her CTT (Certified Technical Trainer) certification. Tracy specializes in teaching graphics, desktop publishing, web design, and reporting/productivity applications.

The Microsoft Office Specialist (MOS) Associate Certification Training course will prepare you to take the Microsoft Office Specialist certification exams for Word, Excel, PowerPoint, and Outlook. Exam fees are included in the course cost.

Requirements:

Hardware Requirements:

• This course must be taken on a PC. Macs are not compatible.

Software Requirements:

• PC: Windows 10 or later.
• Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge is also compatible.
• Microsoft Word, Excel, PowerPoint, and Outlook 2019 or Microsoft Office 365 (not included in enrollment). While Microsoft Word, Excel, PowerPoint, and Outlook 2019 are ideal, you can use the desktop versions of each included with Microsoft 365. Please note: There may be some differences between your version of these programs and what you see in the course.
• Adobe Acrobat Reader.
• Software must be installed and fully operational before the course begins.

Other:

• Email capabilities and access to a personal email account.

Instructional Material Requirements:

The instructional materials required for this course are included in enrollment and will be available online. Manuals are included as downloadable PDFs throughout the course.

While proficiency in Microsoft Office is essential in most professional settings, earning a Microsoft Office Associate certification signifies that you have a deep level of skills needed to use the Office suite.

The Microsoft Office Specialist (MOS) Associate Certification Training course will teach you how to use the Microsoft Office suite at an advanced level. You will build your expertise through hands-on exercises, in-depth course material, and supplemental video demonstrations. You will also prepare for the certification exams for Word, Excel, PowerPoint, and Outlook. As you prepare for each exam, you will test your skills at regular intervals with quizzes and exams.

By course completion, you will be fully prepared to take the MO-200 and MO-201 (Excel), MO-100 and MO-101 (Word), MO-300 (PowerPoint), and MO-400 (Outlook) exams. To earn the  Microsoft Office Specialist (MOS) Associate Certification, you must successfully complete the MO-100 (Word), MO-200 (Excel) , and MO-300 (PowerPoint). 

This course offers enrollment with or without vouchers. The vouchers are prepaid access to sit for the certifying exams upon eligibility. Proctor fees may apply, which are not included.

1. Microsoft Word  
   1. Introduction to Microsoft Word
      1. Creating a Microsoft Word Document
      2. The Ribbon
      3. The File Tab
      4. The Quick Access Toolbar
      5. Formatting Microsoft Word Documents
      6. Editing Documents
      7. Finalizing Microsoft Word Documents
      8. Introduction to Microsoft Word Exam
   2. Intermediate Microsoft Word
      1. Advanced Formatting
      2. Working with Tables
      3. Working with Images
      4. Page Layout
      5. Working with Illustrations
      6. Viewing Your Document(s)
      7. Intermediate Microsoft Word Exam
   3. Advanced Microsoft Word
      1. Working with Long Documents
      2. Reviewing and Collaborating on Documents
      3. Comparing and Combining Documents
      4. Managing Mailings
      5. Protecting Documents
      6. Random Useful Items
      7. Advanced Microsoft Word Exam
   4. Microsoft Word Final Exam
2. Microsoft Excel  
   1. Introduction to Microsoft Excel
      1. Creating a Microsoft Excel Workbook
      2. The Ribbon
      3. The Backstage View (The File Menu)
      4. Entering Data in Microsoft Excel Worksheets
      5. Formatting Microsoft Excel Worksheets
      6. Using Formulas in Microsoft Excel
      7. Working with Rows and Columns
      8. Editing Worksheets
      9. Finalizing Microsoft Excel Worksheets
      10. Introduction to Microsoft Excel Exam
   2. Intermediate Microsoft Excel
      1. Advanced Formulas
      2. Working with Lists
      3. Working with Illustrations
      4. Visualizing Your Data
      5. Working with Tables
      6. Advanced Formatting
      7. Intermediate Microsoft Excel Exam
   3. Advanced Microsoft Excel
      1. Using Pivot Tables
      2. Auditing Worksheets
      3. Data Tools
      4. Working with Others
      5. Recording and Using Macros
      6. Random Useful Items
      7. Advanced Microsoft Excel Exam
   4. Microsoft Excel Final Exam
3. Microsoft PowerPoint  
   1. Introduction to Microsoft PowerPoint
      1. Creating a PowerPoint Presentation
      2. The Ribbon
      3. The Quick Access Toolbar
      4. The Backstage View (The File Menu)
      5. Formatting Microsoft PowerPoint Presentations
      6. Working with Images
      7. Working with Tables and Charts
      8. Finalizing Microsoft PowerPoint Presentations
      9. Introduction to Microsoft PowerPoint Final Exam
   2. Advanced Microsoft PowerPoint
      1. Customizing Presentations
      2. Presentation Masters
      3. Working with Special Effects
      4. Using SmartArt
      5. Multimedia
      6. Setting Up the Slide Show
      7. Outlines and Slides
      8. Managing Multiple Presentations
      9. Sharing and Securing a Presentation
      10. Advanced Microsoft PowerPoint Final Exam
   3. Microsoft PowerPoint Final Exam
4. Microsoft Outlook     
   1. Introduction to Microsoft Outlook
      1. The Outlook Interface
      2. Performing Popular Tasks in Outlook
      3. Working with Messages
      4. Working with the Calendar
      5. Organizing Contacts
      6. Introduction to Microsoft Outlook Exam
   2. Advanced Microsoft Outlook
      1. Working with Tasks and Notes
      2. Using Signature and Themes
      3. Managing Your Inbox
      4. Working with Multiple Email Accounts
      5. Advanced Microsoft Outlook Exam
   3. Microsoft Outlook Final Exam

What you will learn

• Learn the most advanced skills and techniques to best use Microsoft Office programs Word, Excel, PowerPoint, and Outlook
• Create professional Word documents
• Present information in a compelling way using PowerPoint
• Organize lists, utilize spreadsheets, and manage other data with Excel
• Send messages, manage calendars, and collaborate with coworkers across Outlook

How you will benefit

• Prepare to take the Microsoft Office Specialist (MOS) Associate certification exams
• Demonstrate your advanced understanding of the most commonly used Microsoft Office products

Tracy Berry has been a senior graphic designer/programmer, instructor, and consultant since 1993 and has developed hundreds of logos, marketing materials, websites, and multimedia solutions for customers worldwide. She was also involved in several large corporate software rollouts. She has helped many organizations optimize and streamline data solutions. She teaches both onsite and online courses and has her CTT (Certified Technical Trainer) certification. Tracy specializes in teaching graphics, desktop publishing, web design, and reporting/productivity applications.

Prepare for the Microsoft Office Specialist (MOS) certification exams for Word, Excel, PowerPoint, Outlook, and Access and earn your Microsoft Office Specialist (MOS) Expert Certification. Exam fees included for five exams.

Requirements:

Hardware Requirements:

• This course must be taken on a PC. Macs are not compatible.

Software Requirements:

• PC: Windows 10 or later.
• Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge is also compatible.
• Microsoft Word, Excel, PowerPoint, Outlook and Access 2019 or Microsoft Office 365 (not included in enrollment). While Microsoft Word, Excel, PowerPoint, Outlook, and Access 2019 are ideal, you can use the desktop versions of each included with Microsoft 365. Please note: There may be some differences between your version of these and what you see in the course.
• Adobe Acrobat Reader.
• Software must be installed and fully operational before the course begins.

Other:

• Email capabilities and access to a personal email account.

Instructional Material Requirements:

The instructional materials required for this course are included in enrollment and available online.

Microsoft Office is the most widely used business productivity suite. Knowing how to use its products, including Word, Excel, and PowerPoint, is valuable in any professional setting. Earning your Microsoft Office Specialist (MOS) Expert certification demonstrates your knowledge of the applications and proves that you're ready to make an immediate impact at your organization.

This course prepares you for the Microsoft Office Specialist (MOS) certification exams for Word, Excel, PowerPoint, Access, and Outlook. You will build your expertise in these programs through hands-on exercises, in-depth course material, and supplemental video demonstrations. As you prepare for each exam, you will test your skills at regular intervals with quizzes and exams.

By course completion, you will be fully prepared to take the MOS Certification Exams MO-100 and MO-101 (Word), MO-200 and MO-201 (Excel), MO-300 (PowerPoint), MO-400 (Outlook), and MO-500 (Access) exams. 

This course offers enrollment with or without vouchers. The vouchers are prepaid access to sit for the certifying exams upon eligibility. Proctor fees may apply, which are not included.

1. Microsoft Word  
   1. Introduction to Microsoft Word
      1. Creating a Microsoft Word Document
      2. The Ribbon
      3. The File Tab
      4. The Quick Access Toolbar
      5. Formatting Microsoft Word Documents
      6. Editing Documents
      7. Finalizing Microsoft Word Documents
      8. Introduction to Microsoft Word Exam
   2. Intermediate Microsoft Word
      1. Advanced Formatting
      2. Working with Tables
      3. Working with Images
      4. Page Layout
      5. Working with Illustrations
      6. Viewing Your Document(s)
      7. Intermediate Microsoft Word  Exam
   3. Advanced Microsoft Word
      1. Working with Long Documents
      2. Reviewing and Collaborating on Documents
      3. Comparing and Combining Documents
      4. Managing Mailings
      5. Protecting Documents
      6. Random Useful Items
      7. Advanced Microsoft Word Exam
   4. Microsoft Word Final Exam
2. Microsoft Excel  
   1. Introduction to Microsoft Excel
      1. Creating a Microsoft Excel Workbook
      2. The Ribbon
      3. The Backstage View (The File Menu)
      4. Entering Data in Microsoft Excel Worksheets
      5. Formatting Microsoft Excel Worksheets
      6. Using Formulas in Microsoft Excel
      7. Working with Rows and Columns
      8. Editing Worksheets
      9. Finalizing Microsoft Excel Worksheets
      10. Introduction to Microsoft Excel Exam
   2. Intermediate Microsoft Excel
      1. Advanced Formulas
      2. Working with Lists
      3. Working with Illustrations
      4. Visualizing Your Data
      5. Working with Tables
      6. Advanced Formatting
      7. Intermediate Microsoft Excel Exam
   3. Advanced Microsoft Excel
      1. Using Pivot Tables
      2. Auditing Worksheets
      3. Data Tools
      4. Working with Others
      5. Recording and Using Macros
      6. Random Useful Items
      7. Advanced Microsoft Excel Exam
   4. Microsoft Excel Final Exam
3. Microsoft PowerPoint
   1. Introduction to Microsoft PowerPoint
      1. Creating a PowerPoint Presentation
      2. The Ribbon
      3. The Quick Access Toolbar
      4. The Backstage View (The File Menu)
      5. Formatting Microsoft PowerPoint Presentations
      6. Working with Images
      7. Working with Tables and Charts
      8. Finalizing Microsoft PowerPoint Presentations
      9. Introduction to Microsoft PowerPoint Final Exam
   2. Advanced Microsoft PowerPoint
      1. Customizing Presentations
      2. Presentation Masters
      3. Working with Special Effects
      4. Using SmartArt
      5. Multimedia
      6. Setting Up the Slide Show
      7. Outlines and Slides
      8. Managing Multiple Presentations
      9. Sharing and Securing a Presentation
      10. Advanced Microsoft PowerPoint Final Exam
   3. Microsoft PowerPoint Final Exam
4. Microsoft Outlook
   1. Introduction to Microsoft Outlook
      1. The Outlook Interface
      2. Performing Popular Tasks in Outlook
      3. Working with Messages
      4. Working with the Calendar
      5. Organizing Contacts
      6. Introduction to Microsoft Outlook Exam
   2. Advanced Microsoft Outlook
      1. Working with Tasks and Notes
      2. Using Signature and Themes
      3. Managing Your Inbox
      4. Working with Multiple Email Accounts
      5. Advanced Microsoft Outlook Exam
      6. Advanced Microsoft PowerPoint Final Exam
   3. Microsoft Outlook Final Exam
5. Microsoft Access
   1. Introduction to Microsoft Access
      1. Quick Overview of the Access User Interface
      2. Fundamentals
      3. Tables and Their Views
      4. Tables
      5. Queries
      6. Forms
      7. Reports
      8. Introduction to Microsoft Access Final Exam
   2. Advanced Microsoft Access
      1. Relationships
      2. Queries
      3. Table Functions
      4. Forms
      5. Reports
      6. Macros
      7. Completing the Desktop Application
      8. Advanced Microsoft Access Final Exam
   3. Microsoft Access Final Exam

What you will learn

• Learn essential skills required of the Microsoft Office suite including Word, Excel, PowerPoint, Access, and Outlook
• Know how to create and edit a Word document
• Present information in a compelling way via Excel or PowerPoint
• Manage databases and improve efficiency using Access
• Send messages, manage calendars, and collaborate with coworkers across Outlook

How you will benefit

• Prepare to take the Microsoft Office Specialist (MOS) Certification exams Word, Excel, PowerPoint, Outlook, and Access
• Learn how to efficiently use the Microsoft Office suite and take these skills with you to any workplace
• Develop your professional communication skills and understand office etiquette
• Understand the best ways to create and send information or data for the most impact

Tracy Berry has been a senior graphic designer/programmer, instructor, and consultant since 1993 and has developed hundreds of logos, marketing materials, websites, and multimedia solutions for customers worldwide. She was also involved in several large corporate software rollouts. She has helped many organizations optimize and streamline data solutions. She teaches both onsite and online courses and has her CTT (Certified Technical Trainer) certification. Tracy specializes in teaching graphics, desktop publishing, web design, and reporting/productivity applications.

Prepare for the Microsoft Office Specialist (MOS) certification exams for Word, Excel, PowerPoint, Outlook, and Access and earn your Microsoft Office Specialist (MOS) Expert Certification. Exam fees included for five exams.

Requirements:

Hardware Requirements:

• This course must be taken on a PC. Macs are not compatible.

Software Requirements:

• PC: Windows 10 or later.
• Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge is also compatible.
• Microsoft Word, Excel, PowerPoint, Outlook and Access 2019 or Microsoft Office 365 (not included in enrollment). While Microsoft Word, Excel, PowerPoint, Outlook, and Access 2019 are ideal, you can use the desktop versions of each included with Microsoft 365. Please note: There may be some differences between your version of these and what you see in the course.
• Adobe Acrobat Reader.
• Software must be installed and fully operational before the course begins.

Other:

• Email capabilities and access to a personal email account.

Instructional Material Requirements:

The instructional materials required for this course are included in enrollment and available online.

Microsoft Office is the most widely used business productivity suite. Knowing how to use its products, including Word, Excel, and PowerPoint, is valuable in any professional setting. Earning your Microsoft Office Specialist (MOS) Expert certification demonstrates your knowledge of the applications and proves that you're ready to make an immediate impact at your organization.

This course prepares you for the Microsoft Office Specialist (MOS) certification exams for Word, Excel, PowerPoint, Access, and Outlook. You will build your expertise in these programs through hands-on exercises, in-depth course material, and supplemental video demonstrations. As you prepare for each exam, you will test your skills at regular intervals with quizzes and exams.

By course completion, you will be fully prepared to take the MOS Certification Exams MO-100 and MO-101 (Word), MO-200 and MO-201 (Excel), MO-300 (PowerPoint), MO-400 (Outlook), and MO-500 (Access) exams. 

This course offers enrollment with or without vouchers. The vouchers are prepaid access to sit for the certifying exams upon eligibility. Proctor fees may apply, which are not included.

1. Microsoft Word  
   1. Introduction to Microsoft Word
      1. Creating a Microsoft Word Document
      2. The Ribbon
      3. The File Tab
      4. The Quick Access Toolbar
      5. Formatting Microsoft Word Documents
      6. Editing Documents
      7. Finalizing Microsoft Word Documents
      8. Introduction to Microsoft Word Exam
   2. Intermediate Microsoft Word
      1. Advanced Formatting
      2. Working with Tables
      3. Working with Images
      4. Page Layout
      5. Working with Illustrations
      6. Viewing Your Document(s)
      7. Intermediate Microsoft Word  Exam
   3. Advanced Microsoft Word
      1. Working with Long Documents
      2. Reviewing and Collaborating on Documents
      3. Comparing and Combining Documents
      4. Managing Mailings
      5. Protecting Documents
      6. Random Useful Items
      7. Advanced Microsoft Word Exam
   4. Microsoft Word Final Exam
2. Microsoft Excel  
   1. Introduction to Microsoft Excel
      1. Creating a Microsoft Excel Workbook
      2. The Ribbon
      3. The Backstage View (The File Menu)
      4. Entering Data in Microsoft Excel Worksheets
      5. Formatting Microsoft Excel Worksheets
      6. Using Formulas in Microsoft Excel
      7. Working with Rows and Columns
      8. Editing Worksheets
      9. Finalizing Microsoft Excel Worksheets
      10. Introduction to Microsoft Excel Exam
   2. Intermediate Microsoft Excel
      1. Advanced Formulas
      2. Working with Lists
      3. Working with Illustrations
      4. Visualizing Your Data
      5. Working with Tables
      6. Advanced Formatting
      7. Intermediate Microsoft Excel Exam
   3. Advanced Microsoft Excel
      1. Using Pivot Tables
      2. Auditing Worksheets
      3. Data Tools
      4. Working with Others
      5. Recording and Using Macros
      6. Random Useful Items
      7. Advanced Microsoft Excel Exam
   4. Microsoft Excel Final Exam
3. Microsoft PowerPoint
   1. Introduction to Microsoft PowerPoint
      1. Creating a PowerPoint Presentation
      2. The Ribbon
      3. The Quick Access Toolbar
      4. The Backstage View (The File Menu)
      5. Formatting Microsoft PowerPoint Presentations
      6. Working with Images
      7. Working with Tables and Charts
      8. Finalizing Microsoft PowerPoint Presentations
      9. Introduction to Microsoft PowerPoint Final Exam
   2. Advanced Microsoft PowerPoint
      1. Customizing Presentations
      2. Presentation Masters
      3. Working with Special Effects
      4. Using SmartArt
      5. Multimedia
      6. Setting Up the Slide Show
      7. Outlines and Slides
      8. Managing Multiple Presentations
      9. Sharing and Securing a Presentation
      10. Advanced Microsoft PowerPoint Final Exam
   3. Microsoft PowerPoint Final Exam
4. Microsoft Outlook
   1. Introduction to Microsoft Outlook
      1. The Outlook Interface
      2. Performing Popular Tasks in Outlook
      3. Working with Messages
      4. Working with the Calendar
      5. Organizing Contacts
      6. Introduction to Microsoft Outlook Exam
   2. Advanced Microsoft Outlook
      1. Working with Tasks and Notes
      2. Using Signature and Themes
      3. Managing Your Inbox
      4. Working with Multiple Email Accounts
      5. Advanced Microsoft Outlook Exam
      6. Advanced Microsoft PowerPoint Final Exam
   3. Microsoft Outlook Final Exam
5. Microsoft Access
   1. Introduction to Microsoft Access
      1. Quick Overview of the Access User Interface
      2. Fundamentals
      3. Tables and Their Views
      4. Tables
      5. Queries
      6. Forms
      7. Reports
      8. Introduction to Microsoft Access Final Exam
   2. Advanced Microsoft Access
      1. Relationships
      2. Queries
      3. Table Functions
      4. Forms
      5. Reports
      6. Macros
      7. Completing the Desktop Application
      8. Advanced Microsoft Access Final Exam
   3. Microsoft Access Final Exam

What you will learn

• Learn essential skills required of the Microsoft Office suite including Word, Excel, PowerPoint, Access, and Outlook
• Know how to create and edit a Word document
• Present information in a compelling way via Excel or PowerPoint
• Manage databases and improve efficiency using Access
• Send messages, manage calendars, and collaborate with coworkers across Outlook

How you will benefit

• Prepare to take the Microsoft Office Specialist (MOS) Certification exams Word, Excel, PowerPoint, Outlook, and Access
• Learn how to efficiently use the Microsoft Office suite and take these skills with you to any workplace
• Develop your professional communication skills and understand office etiquette
• Understand the best ways to create and send information or data for the most impact

Tracy Berry has been a senior graphic designer/programmer, instructor, and consultant since 1993 and has developed hundreds of logos, marketing materials, websites, and multimedia solutions for customers worldwide. She was also involved in several large corporate software rollouts. She has helped many organizations optimize and streamline data solutions. She teaches both onsite and online courses and has her CTT (Certified Technical Trainer) certification. Tracy specializes in teaching graphics, desktop publishing, web design, and reporting/productivity applications.

This comprehensive training course will teach you how to use Microsoft Project 2019's newest features for project planning, tracking, and reporting.

Requirements:

Hardware Requirements:

• This course must be taken on a PC. Macs are not compatible.

Software Requirements:

• PC: Windows 10 or later.
• Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge is also compatible.
• Microsoft Project 2019 (not included in enrollment) *Note: Please verify you have access to Microsoft Project 2019 before enrolling due to limited software availability. 
• Adobe Acrobat Reader.
• Software must be installed and fully operational before the course begins.

Other:

• Email capabilities and access to a personal email account.

Instructional Material Requirements:

The instructional materials required for this course are included in enrollment. The following textbooks will be shipped to you approximately 7-10 business days after enrollment:

• Mastering Project 2019 Step By Step

From the construction industry to the information technology sector, project managers are using Microsoft Project to plan, track, and collaborate on business projects. Staying up-to-date with this project management software is important for your professional success.

This online project management course will train you to use Microsoft Project 2019. After learning the software's functions through interactive assignments and milestone quizzes, you will create a master project plan for your capstone. In addition, this course will provide training hours for PDUs needed to maintain PMI qualified certifications.

*Note: Please verify you have access to Microsoft Project 2019 before enrolling due to limited software availability. 

1. Course Introduction
   1. Project in Action
   2. Getting Setup
2. Establishing a Good Project Management Foundation
   1. Documentation
   2. The Scope Statement
   3. Understanding your Project Deliverables
   4. The Work Breakdown Structure (WBS)
3. Schedule Terminology and Methodology
   1. Scheduling Terms and Concepts
   2. Schedule Analysis
   3. Understanding Float
4. Navigating to MS Project 2019
   1. Ribbon Menu Navigation
   2. The Backstage View
   3. Templates
5. MS Project Terminology
   1. Views
   2. Resource Views
   3. Tables
   4. Forms
6. Understanding Default Settings
   1. The Purpose of Default Settings
   2. Finding Default Settings
   3. File>Options>Schedule
   4. File>Options>Save
7. Setting Up Calendars
   1. Base Calendars
   2. Resource Calendars
   3. Task Calendars
   4. Tips and Guidelines
8. Task Terminology & Creating Task List
   1. Tasks Defined
   2. More Tasks Defined
   3. Creating a Task List
   4. Organizing your Tasks
9. Schedule Development
   1. Types of Estimates
   2. Modeling Tasks & Relationships
   3. Schedule Development
10. Advanced Task Functionalities
    1. Task Types and Calculations
    2. Advanced Task Functionalities
    3. Managing Deadlines
    4. Task Information
11. Introduction to Resources
    1. Resource Terminology
    2. Resource Types
    3. Setting up a Resource Sheet
    4. Best Practices for Setting Up Work Resources
12. Assigning Resources
    1. Assigning Resources to Tasks
    2. Work Resources and Calculations
    3. Assigning Material and Cost Resources
    4. Resource Planning Guidelines
13. Managing Resource Assignments
    1. Resource Graph View
    2. Resource Usage View
    3. Team Planner
14. Customizing Project Views
    1. Customizing Views
    2. Sorts
    3. Filters
    4. Groups
15. Project Plan Review
    1. Sanity Check #1: Schedule Structure
    2. Sanity Check #2: Project Scope
    3. Sanity Check #3: Estimates and Resources
    4. Sanity Check #4: Estimates and Resources
16. Statusing Your Project
    1. Baselines
    2. Statusing Basics
    3. Applying Actual Work with Statusing Methods
17. Tracking Project Performance
    1. Viewing Status
    2. Reporting Status
    3. Applying Earned Value
    4. Getting Back on Track
18. Format and Customize
    1. Advanced Formatting
    2. The Organizer
    3. Making Macros
19. Create Master Project Files
    1. Importing and Exporting Project Data
    2. Managing Multiple Projects
    3. Sharing Resources Across Projects

What you will learn

• Using Microsoft Project to plan, implement, and track project performance
• Identify various Microsoft Project elements and functions to enhance schedule development
• Examining implemented project schedules to assess progress and take corrective action
• Preparing and communicating project information using views and reports
• Identifying how to manage master projects using shared resources

How you will benefit

• Complete a capstone project to add to your professional portfolio
• Understand Microsoft Project's new functions and features
• Earn training hours for PDUs to maintain your PMI qualified certifications

Nikki Choyce, PMP has been involved in the project management field for almost 20 years and has worked as a consultant and trainer for much of that time. She is a Project Management Professional (PMP) and very active in the project management community. She has worked in a variety of industries, including Information Technology, Insurance, Manufacturing, Marketing, Aerospace, Construction, and Telecommunications. She has worked with Microsoft Project for over 10 years.

This comprehensive training course will teach you how to use Microsoft Project 2019's newest features for project planning, tracking, and reporting.

Requirements:

Hardware Requirements:

• This course must be taken on a PC. Macs are not compatible.

Software Requirements:

• PC: Windows 10 or later.
• Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge is also compatible.
• Microsoft Project 2019 (not included in enrollment) *Note: Please verify you have access to Microsoft Project 2019 before enrolling due to limited software availability. 
• Adobe Acrobat Reader.
• Software must be installed and fully operational before the course begins.

Other:

• Email capabilities and access to a personal email account.

Instructional Material Requirements:

The instructional materials required for this course are included in enrollment. The following textbooks will be shipped to you approximately 7-10 business days after enrollment:

• Mastering Project 2019 Step By Step

From the construction industry to the information technology sector, project managers are using Microsoft Project to plan, track, and collaborate on business projects. Staying up-to-date with this project management software is important for your professional success.

This online project management course will train you to use Microsoft Project 2019. After learning the software's functions through interactive assignments and milestone quizzes, you will create a master project plan for your capstone. In addition, this course will provide training hours for PDUs needed to maintain PMI qualified certifications.

*Note: Please verify you have access to Microsoft Project 2019 before enrolling due to limited software availability. 

1. Course Introduction
   1. Project in Action
   2. Getting Setup
2. Establishing a Good Project Management Foundation
   1. Documentation
   2. The Scope Statement
   3. Understanding your Project Deliverables
   4. The Work Breakdown Structure (WBS)
3. Schedule Terminology and Methodology
   1. Scheduling Terms and Concepts
   2. Schedule Analysis
   3. Understanding Float
4. Navigating to MS Project 2019
   1. Ribbon Menu Navigation
   2. The Backstage View
   3. Templates
5. MS Project Terminology
   1. Views
   2. Resource Views
   3. Tables
   4. Forms
6. Understanding Default Settings
   1. The Purpose of Default Settings
   2. Finding Default Settings
   3. File>Options>Schedule
   4. File>Options>Save
7. Setting Up Calendars
   1. Base Calendars
   2. Resource Calendars
   3. Task Calendars
   4. Tips and Guidelines
8. Task Terminology & Creating Task List
   1. Tasks Defined
   2. More Tasks Defined
   3. Creating a Task List
   4. Organizing your Tasks
9. Schedule Development
   1. Types of Estimates
   2. Modeling Tasks & Relationships
   3. Schedule Development
10. Advanced Task Functionalities
    1. Task Types and Calculations
    2. Advanced Task Functionalities
    3. Managing Deadlines
    4. Task Information
11. Introduction to Resources
    1. Resource Terminology
    2. Resource Types
    3. Setting up a Resource Sheet
    4. Best Practices for Setting Up Work Resources
12. Assigning Resources
    1. Assigning Resources to Tasks
    2. Work Resources and Calculations
    3. Assigning Material and Cost Resources
    4. Resource Planning Guidelines
13. Managing Resource Assignments
    1. Resource Graph View
    2. Resource Usage View
    3. Team Planner
14. Customizing Project Views
    1. Customizing Views
    2. Sorts
    3. Filters
    4. Groups
15. Project Plan Review
    1. Sanity Check #1: Schedule Structure
    2. Sanity Check #2: Project Scope
    3. Sanity Check #3: Estimates and Resources
    4. Sanity Check #4: Estimates and Resources
16. Statusing Your Project
    1. Baselines
    2. Statusing Basics
    3. Applying Actual Work with Statusing Methods
17. Tracking Project Performance
    1. Viewing Status
    2. Reporting Status
    3. Applying Earned Value
    4. Getting Back on Track
18. Format and Customize
    1. Advanced Formatting
    2. The Organizer
    3. Making Macros
19. Create Master Project Files
    1. Importing and Exporting Project Data
    2. Managing Multiple Projects
    3. Sharing Resources Across Projects

What you will learn

• Using Microsoft Project to plan, implement, and track project performance
• Identify various Microsoft Project elements and functions to enhance schedule development
• Examining implemented project schedules to assess progress and take corrective action
• Preparing and communicating project information using views and reports
• Identifying how to manage master projects using shared resources

How you will benefit

• Complete a capstone project to add to your professional portfolio
• Understand Microsoft Project's new functions and features
• Earn training hours for PDUs to maintain your PMI qualified certifications

Nikki Choyce, PMP has been involved in the project management field for almost 20 years and has worked as a consultant and trainer for much of that time. She is a Project Management Professional (PMP) and very active in the project management community. She has worked in a variety of industries, including Information Technology, Insurance, Manufacturing, Marketing, Aerospace, Construction, and Telecommunications. She has worked with Microsoft Project for over 10 years.

This Microsoft Certification training course prepares you for the Microsoft Office Specialist Expert exam for Microsoft Word. Exam voucher included.

Requirements:

Hardware Requirements:

• This course must be taken on a PC. Macs are not compatible.

Software Requirements:

• PC: Windows 10 or later.
• Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge is also compatible.
• Microsoft Word 2019 or Microsoft Word 365 (not included in enrollment). While Microsoft Word 2019 is ideal, you can use the version of Word included in the desktop version of Microsoft 365. Please note: There may be some differences between your version of Word and what you see in the course.
• Adobe Acrobat Reader.
• Software must be installed and fully operational before the course begins.

Other:

• Email capabilities and access to a personal email account.

Instructional Material Requirements:

The instructional materials required for this course are included in enrollment.

Proficiency in Microsoft Word is the one of the most requested workplace skills. Earning the Microsoft Office Specialist Expert certification for Microsoft Word sets your professional profile apart from the casual Word user. To add this credential to your resume, you must pass the Microsoft Office Specialist (MOS) Expert certification exam.

This course will prepare you for the MOS Expert certification exam for Microsoft Word. You will learn to create, edit, format, and print Microsoft Word documents. You will then move on to learn advanced formatting, use Word drawing tools, create and manage tables, and work with column layouts. You will also learn more advanced techniques, such as working with tables of contents, footnotes, and endnotes, adding comments, tracking changes, comparing and combining documents, creating envelopes and labels, using Mail Merge, and protecting documents.

Upon completion of this course, you will be prepared for the Microsoft Office Specialist Expert certification exam for Word. This course offers enrollment with or without a voucher. The voucher is prepaid access to sit for the certifying exam upon eligibility.

1. Introduction to Microsoft Word     
   1. Creating a Microsoft Word Document
   2. The Ribbon
   3. The File Tab
   4. The Quick Access Toolbar
   5. Formatting Microsoft Word Documents
   6. Editing Documents
   7. Finalizing Microsoft Word Documents
   8. Introduction to Microsoft Word Exam
2. Intermediate Microsoft Word     
   1. Advanced Formatting
   2. Working with Tables
   3. Working with Images
   4. Page Layout
   5. Working with Illustrations
   6. Viewing Your Document(s)
   7. Intermediate Microsoft Word Exam
3. Advanced Microsoft Word  
   1. Working with Long Documents
   2. Reviewing and Collaborating on Documents
   3. Comparing and Combining Documents
   4. Managing Mailings
   5. Protecting Documents
   6. Random Useful Items
   7. Advanced Microsoft Word Exam
4. Microsoft Word Final Exam

What you will learn

• Create, edit, and share documents within Microsoft Word
• Develop the skills needed to process documents
• Fundamental and advanced functions of Microsoft Word

How you will benefit

• Be prepared for the Microsoft Office Specialist Word Expert certification exam
• Add Microsoft verified credential to your resume
• Become a valuable asset in any workplace setting

Tracy Berry has been a senior graphic designer/programmer, instructor, and consultant since 1993 and has developed hundreds of logos, marketing materials, websites, and multimedia solutions for customers worldwide. She was also involved in several large corporate software rollouts. She has helped many organizations optimize and streamline data solutions. She teaches both onsite and online courses and has her CTT (Certified Technical Trainer) certification. Tracy specializes in teaching graphics, desktop publishing, web design, and reporting/productivity applications.

This Microsoft Certification training course prepares you for the Microsoft Office Specialist Expert exam for Microsoft Word. Exam voucher included.

Requirements:

Hardware Requirements:

• This course must be taken on a PC. Macs are not compatible.

Software Requirements:

• PC: Windows 10 or later.
• Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge is also compatible.
• Microsoft Word 2019 or Microsoft Word 365 (not included in enrollment). While Microsoft Word 2019 is ideal, you can use the version of Word included in the desktop version of Microsoft 365. Please note: There may be some differences between your version of Word and what you see in the course.
• Adobe Acrobat Reader.
• Software must be installed and fully operational before the course begins.

Other:

• Email capabilities and access to a personal email account.

Instructional Material Requirements:

The instructional materials required for this course are included in enrollment.

Proficiency in Microsoft Word is the one of the most requested workplace skills. Earning the Microsoft Office Specialist Expert certification for Microsoft Word sets your professional profile apart from the casual Word user. To add this credential to your resume, you must pass the Microsoft Office Specialist (MOS) Expert certification exam.

This course will prepare you for the MOS Expert certification exam for Microsoft Word. You will learn to create, edit, format, and print Microsoft Word documents. You will then move on to learn advanced formatting, use Word drawing tools, create and manage tables, and work with column layouts. You will also learn more advanced techniques, such as working with tables of contents, footnotes, and endnotes, adding comments, tracking changes, comparing and combining documents, creating envelopes and labels, using Mail Merge, and protecting documents.

Upon completion of this course, you will be prepared for the Microsoft Office Specialist Expert certification exam for Word. This course offers enrollment with or without a voucher. The voucher is prepaid access to sit for the certifying exam upon eligibility.

1. Introduction to Microsoft Word     
   1. Creating a Microsoft Word Document
   2. The Ribbon
   3. The File Tab
   4. The Quick Access Toolbar
   5. Formatting Microsoft Word Documents
   6. Editing Documents
   7. Finalizing Microsoft Word Documents
   8. Introduction to Microsoft Word Exam
2. Intermediate Microsoft Word     
   1. Advanced Formatting
   2. Working with Tables
   3. Working with Images
   4. Page Layout
   5. Working with Illustrations
   6. Viewing Your Document(s)
   7. Intermediate Microsoft Word Exam
3. Advanced Microsoft Word  
   1. Working with Long Documents
   2. Reviewing and Collaborating on Documents
   3. Comparing and Combining Documents
   4. Managing Mailings
   5. Protecting Documents
   6. Random Useful Items
   7. Advanced Microsoft Word Exam
4. Microsoft Word Final Exam

What you will learn

• Create, edit, and share documents within Microsoft Word
• Develop the skills needed to process documents
• Fundamental and advanced functions of Microsoft Word

How you will benefit

• Be prepared for the Microsoft Office Specialist Word Expert certification exam
• Add Microsoft verified credential to your resume
• Become a valuable asset in any workplace setting

Tracy Berry has been a senior graphic designer/programmer, instructor, and consultant since 1993 and has developed hundreds of logos, marketing materials, websites, and multimedia solutions for customers worldwide. She was also involved in several large corporate software rollouts. She has helped many organizations optimize and streamline data solutions. She teaches both onsite and online courses and has her CTT (Certified Technical Trainer) certification. Tracy specializes in teaching graphics, desktop publishing, web design, and reporting/productivity applications.

This hands-on course will teach beginners how to use Microsoft Access 2019/Office 365 to build a database and customize the way data is stored.

Virtually every industry can benefit from the use of Microsoft Access to organize, store, and document their essential information. Data ranging from inventory and customer information to orders details and vendors can be effectively organized with Microsoft's longstanding software. If you work with databases of any kind, learning how to use Access 2019 will add a valuable skill set to your professional profile.

This course will teach you one of the most useful skills for both job seekers and those looking for promotion. If you know how to use Microsoft Excel, learning Access informs and enhances your current skill set, allowing you to take a stronger role in database management.

Requirements:

Hardware Requirements:

• This course must be taken on a PC. Macs are not compatible.

Software Requirements:

• PC: Windows 10 or later.
• Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge is also compatible.
• Microsoft Access 2019: Available to download with a subscription to Microsoft 365, or with Microsoft Office Professional 2019 (not included in enrollment).
• Adobe Acrobat Reader.
• Software must be installed and fully operational before the course begins.

Other:

• Email capabilities and access to a personal email account.

Instructional Material Requirements:

The instructional materials required for this course are included in enrollment and will be available online.

Build, edit, and maintain databases in Microsoft Access 2019/Office 365 using tables, reports, forms, and queries to give you fast access to all your important information. This hands-on course for beginners provides the skills to create an effective database for any type of information at home or on the job.

Getting to Know Access 2019

In this lesson, you'll find out what Access is and how individuals, businesses, and organizations use it to store information. You'll begin to build an Access database, including all the components that turn a list of records into reports, forms, and queries. You'll start by opening the application and creating a new database.

Controlling Your Access Table Fields

It's time to lay down the law! In this lesson, you'll impose rules that automatically fill an Access table field with a preset value or that automatically insert the symbols commonly included in phone numbers. You'll also set up rules that require allow only certain kinds of data in certain fields. With just a few minutes of work, you can make data entry simpler, clearer, and practically error-frees.

Creating Tables and Relationships

You'll create additional tables for the class database, customize them along the way, and then build relationships between them. This all paves the way for later database features, such as reports, queries, and forms that draw from multiple tables in the database.

Building Powerful Forms

In this lesson, you'll use forms for data entry and for viewing records in your tables. You'll meet the Form Wizard, which makes form building fast and easy and which allows you to select one or more tables' fields to include. You'll also learn how to change the form layout.

Adding Versatility to Forms

In this lesson, you'll add buttons and controls to forms. You'll also adjust table relationships to support the creation of multi-table forms, which paves the way to creating queries and reports that draw data from more than one table.

Interviewing Your Database

Using queries to sort, filter, and search your database is one of the most important skills you'll master in this course. In this lesson, you'll create queries that search for specific data. You'll also customize how Access displays that data. By following the instructions step by step, you'll first become familiar with the process, and then you'll get to create a query on your own!

Taking Queries to the Next Level

A query that puts specific records in order or finds all the records that have a general piece of information in common is, well, pretty common. Being able to create that kind of query is a great foundation skill, but it won't help you find a very specific record. Nor will it let you search for records within a span of dates or other numeric values. It also won't help you exclude certain records, reducing a large pool of data to just those records you need to see. In this lesson, you'll create queries that give you true power to search your database.

Multi-Table Query Control

In this lesson, you'll learn to plan, build, and use queries that pull data from more than one table at a time. This gives you more power over your data and allows you to build a great foundation for truly customized reports.

Reporting on Your Tables

Reports are easy to create and to customize. In this lesson, you'll build a simple report using the Report Wizard. Then you'll change the report's appearance, using layout view and design view. These skills provide the foundation to create and design any report you may need on any data in your database.

Creating Query-Based Reports

In this lesson, you'll create reports that are based on the results of queries you create to sort and filter your database. Because queries can combine data from multiple tables, filter for specific data, and sort the results, your report reflects just the data that meet the query's criteria. This makes truly customized reporting possible—and quite simple.

Mastering Report Design

In this lesson, you'll plan and create a completely customized report, using a specialized query that controls which data the report includes. You'll add fields that perform calculations on your data. You'll customize your report's layout, too, using design view's many tools for controlling the structure and appearance of your data.

Automating Your Database With Macros

Building macros (short programs that perform a series of steps) helps you speed up and create consistency in your more repetitive Access tasks. From opening a form to running a report to building a new record in a table, macros eliminate redundant procedures by turning them into something you can do with one click.

What you will learn

• Planning and building a database consisting of multiple tables
• Creating logical relationships between database tables
• Designing effective and powerful data entry forms
• Building efficient and useful queries to find and organize records
• Generation of professional-looking reports

How you will benefit

• You will be able to build and customize Access databases
• Existing Access databases will make more sense
• Gain knowledge to take a stronger role in the database maintenance
• Design professional-looking forms and reports

Laurie Ulrich has been writing about and teaching people to use Microsoft Office for more than 20 years—including personally training thousands of students, writing hundreds of training manuals, and authoring and co-authoring more than 30 books on subjects including Word, Excel, PowerPoint, Outlook, and Access. Her books include 2000-page epics that document every button, bell, and whistle, as well as friendlier introductory and troubleshooting books for new users. Her most recent publication on Microsoft Access is Access 2016 for Dummies. In addition to writing and teaching, Laurie runs her own firm, Limehat & Company, providing training, marketing, graphic design, and web development services to clients throughout the world, with a focus on helping growing companies and non-profit organizations build their brand through effective promotions, outreach, and education.

This hands-on course will teach beginners how to use Microsoft Access 2019/Office 365 to build a database and customize the way data is stored.

Virtually every industry can benefit from the use of Microsoft Access to organize, store, and document their essential information. Data ranging from inventory and customer information to orders details and vendors can be effectively organized with Microsoft's longstanding software. If you work with databases of any kind, learning how to use Access 2019 will add a valuable skill set to your professional profile.

This course will teach you one of the most useful skills for both job seekers and those looking for promotion. If you know how to use Microsoft Excel, learning Access informs and enhances your current skill set, allowing you to take a stronger role in database management.

Requirements:

Hardware Requirements:

• This course must be taken on a PC. Macs are not compatible.

Software Requirements:

• PC: Windows 10 or later.
• Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge is also compatible.
• Microsoft Access 2019: Available to download with a subscription to Microsoft 365, or with Microsoft Office Professional 2019 (not included in enrollment).
• Adobe Acrobat Reader.
• Software must be installed and fully operational before the course begins.

Other:

• Email capabilities and access to a personal email account.

Instructional Material Requirements:

The instructional materials required for this course are included in enrollment and will be available online.

Build, edit, and maintain databases in Microsoft Access 2019/Office 365 using tables, reports, forms, and queries to give you fast access to all your important information. This hands-on course for beginners provides the skills to create an effective database for any type of information at home or on the job.

Getting to Know Access 2019

In this lesson, you'll find out what Access is and how individuals, businesses, and organizations use it to store information. You'll begin to build an Access database, including all the components that turn a list of records into reports, forms, and queries. You'll start by opening the application and creating a new database.

Controlling Your Access Table Fields

It's time to lay down the law! In this lesson, you'll impose rules that automatically fill an Access table field with a preset value or that automatically insert the symbols commonly included in phone numbers. You'll also set up rules that require allow only certain kinds of data in certain fields. With just a few minutes of work, you can make data entry simpler, clearer, and practically error-frees.

Creating Tables and Relationships

You'll create additional tables for the class database, customize them along the way, and then build relationships between them. This all paves the way for later database features, such as reports, queries, and forms that draw from multiple tables in the database.

Building Powerful Forms

In this lesson, you'll use forms for data entry and for viewing records in your tables. You'll meet the Form Wizard, which makes form building fast and easy and which allows you to select one or more tables' fields to include. You'll also learn how to change the form layout.

Adding Versatility to Forms

In this lesson, you'll add buttons and controls to forms. You'll also adjust table relationships to support the creation of multi-table forms, which paves the way to creating queries and reports that draw data from more than one table.

Interviewing Your Database

Using queries to sort, filter, and search your database is one of the most important skills you'll master in this course. In this lesson, you'll create queries that search for specific data. You'll also customize how Access displays that data. By following the instructions step by step, you'll first become familiar with the process, and then you'll get to create a query on your own!

Taking Queries to the Next Level

A query that puts specific records in order or finds all the records that have a general piece of information in common is, well, pretty common. Being able to create that kind of query is a great foundation skill, but it won't help you find a very specific record. Nor will it let you search for records within a span of dates or other numeric values. It also won't help you exclude certain records, reducing a large pool of data to just those records you need to see. In this lesson, you'll create queries that give you true power to search your database.

Multi-Table Query Control

In this lesson, you'll learn to plan, build, and use queries that pull data from more than one table at a time. This gives you more power over your data and allows you to build a great foundation for truly customized reports.

Reporting on Your Tables

Reports are easy to create and to customize. In this lesson, you'll build a simple report using the Report Wizard. Then you'll change the report's appearance, using layout view and design view. These skills provide the foundation to create and design any report you may need on any data in your database.

Creating Query-Based Reports

In this lesson, you'll create reports that are based on the results of queries you create to sort and filter your database. Because queries can combine data from multiple tables, filter for specific data, and sort the results, your report reflects just the data that meet the query's criteria. This makes truly customized reporting possible—and quite simple.

Mastering Report Design

In this lesson, you'll plan and create a completely customized report, using a specialized query that controls which data the report includes. You'll add fields that perform calculations on your data. You'll customize your report's layout, too, using design view's many tools for controlling the structure and appearance of your data.

Automating Your Database With Macros

Building macros (short programs that perform a series of steps) helps you speed up and create consistency in your more repetitive Access tasks. From opening a form to running a report to building a new record in a table, macros eliminate redundant procedures by turning them into something you can do with one click.

What you will learn

• Planning and building a database consisting of multiple tables
• Creating logical relationships between database tables
• Designing effective and powerful data entry forms
• Building efficient and useful queries to find and organize records
• Generation of professional-looking reports

How you will benefit

• You will be able to build and customize Access databases
• Existing Access databases will make more sense
• Gain knowledge to take a stronger role in the database maintenance
• Design professional-looking forms and reports

Laurie Ulrich has been writing about and teaching people to use Microsoft Office for more than 20 years—including personally training thousands of students, writing hundreds of training manuals, and authoring and co-authoring more than 30 books on subjects including Word, Excel, PowerPoint, Outlook, and Access. Her books include 2000-page epics that document every button, bell, and whistle, as well as friendlier introductory and troubleshooting books for new users. Her most recent publication on Microsoft Access is Access 2016 for Dummies. In addition to writing and teaching, Laurie runs her own firm, Limehat & Company, providing training, marketing, graphic design, and web development services to clients throughout the world, with a focus on helping growing companies and non-profit organizations build their brand through effective promotions, outreach, and education.

If you work with data of any kind, knowing how to create a spreadsheet is key to effectively managing and organizing information. This course will introduce you to Microsoft Excel 2019 and teach you how to use this powerful software.

Do you manage large sets of numbers, names, dates, or other pieces of information? If so, then you need to create worksheets to manage, store, organize, and even analyze this information. Excel, Microsoft's powerful spreadsheet software, is the most widely-used program to handle this task. In fact, most workplaces require that new employees have a basic level of understanding of Microsoft Excel.

If you want to learn the 2019 version of Microsoft Excel, this course will introduce you to the program's basic functions and uses. Through hands-on lessons, you will learn numerous shortcuts to quickly and efficiently set up worksheets. You will also learn how to use the function wizard to calculate statistics, future values, and more. In addition, you will get tips on sorting and analyzing data, creating three-dimensional workbooks, and automating frequently-repeated tasks with macros and buttons. By the time you're done, you will know how to use this vital Office 2019 tool.

Requirements:

Hardware Requirements:

• This course must be taken on a PC. It is not suitable for Macs or Chromebooks.

Software Requirements:

• PC: Windows 10 or later.
• Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge is also compatible.
• Microsoft Excel 2019 (desktop version), available to download with the desktop version of Microsoft 365, or Microsoft Office Home and Student 2019 (not included in enrollment).
• Note: The "Starter Version" and "Web App" versions of Microsoft will not work with the full version taught in this course.
• Adobe Acrobat Reader.
• Software must be installed and fully operational before the course begins.

Other:

• Email capabilities and access to a personal email account.

Instructional Material Requirements:

The instructional materials required for this course are included in enrollment and will be available online.

Learn to quickly and efficiently use Microsoft Excel 2019/Office 365 as you discover dozens of shortcuts and tricks for setting up fully formatted worksheets. This course, taught by an experience Microsoft Excel instructor, provides in-depth knowledge for beginners that will have you using Excel like a pro.

Excel Basics

In this lesson, you'll develop a solid understanding of the Excel interface. You'll become fluent in the secret language spoken only by Excel users, you'll discover the best way to correct just about any mistake you might make in Excel, and you'll find yourself gliding effortlessly from cell to cell, leaving behind expertly written labels, numbers, and formulas.

Creating a Worksheet

In this lesson, you'll learn five simple steps you should always follow to ensure that your worksheets are always well-planned, well-constructed, and beautifully formatted.

Time-Savers

This lesson will teach you the tricks of the Excel masters: a wide variety of useful shortcuts guaranteed to save you time, energy, and frustration. You'll also spend some time working with the Quick Analysis and Flash Fill tools. By the time you finish this lesson, you'll really start to feel like an Excel pro.

Relative, Absolute, Mixed, and Circular References

Do you know the difference between a relative reference, an absolute reference, a mixed reference, and a circular reference? You will after this lesson. In this lesson, you'll learn to write sophisticated formulas that can help ease you through some rather sticky scenarios.

Three-Dimensional Workbooks

With enough practice, most Excel users quickly become adept at organizing their worksheets across two dimensions: rows and columns. But only a select few will learn how to take their worksheets into the third dimension. In this lesson, you'll join that exclusive group. Prepare to have your socks knocked off as you gain hands-on experience in the construction of three-dimensional workbooks.

Sorting, Subtotaling, and Filtering

No Excel course would be complete without a discussion of Excel's amazing data-crunching capabilities. In this lesson, you'll learn how to build a table in Excel as well as how to subtotal, sort, and filter.

Charting Basics

In this lesson, you'll explore the exciting world of charts. You'll build your first graph and learn how easy it is to adjust the chart type, labels, titles, colors, and other aspects of your chart.

Advanced Charting Techniques

In this lesson, you'll dig deep into Excel's charting capabilities. You'll explore everything from bar charts and line charts to more prosaic graphs like the pie chart and 3D charts. You'll find out how to personalize your charts with photographs, text labels, and drawings. You'll also discover the best ways to format your chart for print or otherwise display the truly impressive charts that you'll be creating.

Intro to Excel's Statistical Functions

Excel includes many powerful functions that can automatically perform some very complicated tasks for you. In this lesson, you'll learn some very interesting ways to put these functions to work for you. You'll find out how to ask Excel to magically derive averages, modes, maximums, minimums, and other useful statistics from nothing more than a column or two of numbers.

Financial Functions

You'll continue your exploration of Excel functions with an in-depth look at Excel's handy financial functions. By the time this lesson is over, you'll be able to figure out how much money you'll have when you retire, when your kids reach college, or just before your next vacation. You'll be able to calculate the monthly payment on just about any type of loan, and you'll know how to figure out how long it will take to pay off your credit cards. You'll even create an amortization table of your very own, just like the one lenders use to track a loan's payoff amount over time.

Worksheet Automation

In this lesson, you'll find out how to automate just about any task you find tedious or time-consuming. You'll discover how to move your most frequently used commands from their present, obscure locations to a much more convenient place: the toolbar that's always perched at the very top of your screen. You'll also learn how you can use macros to reduce just about any complex task to a single keystroke.

Mastering Excel's IF Function

You'll be intrigued by the final lesson, in which you'll learn how to use Excel to aid you in decision making. You'll use a special function in Excel that allows it to make comparisons and use those comparisons as the basis for important decisions.

What you will learn

• How to create worksheets, charts, and graphs
• Methods for sorting and analyzing automating often repeated tasks
• How to parse data with Flash Fill
• Important keyboard shortcuts

How you will benefit

• Knowing how to use Excel 2019 will make you a more productive member of your organization
• Gain indispensable skills that will be useful for numbers-based reporting
• Develop skills that can be used to simplify your life of calculating and displaying numbers both personally and professionally

Chad Wambolt has spent his entire professional career in the finance field, working for both private and publicly-held companies with sales ranging from $500 million to $3 billion. He is a graduate of Boise State University, where he obtained his bachelor's degree in accounting. Through the course of his career, Wambolt became an expert user of Microsoft Excel. Since 1997, he has taught Excel to students of varying skill levels and helped organizations streamline internal processes.

If you work with data of any kind, knowing how to create a spreadsheet is key to effectively managing and organizing information. This course will introduce you to Microsoft Excel 2019 and teach you how to use this powerful software.

Do you manage large sets of numbers, names, dates, or other pieces of information? If so, then you need to create worksheets to manage, store, organize, and even analyze this information. Excel, Microsoft's powerful spreadsheet software, is the most widely-used program to handle this task. In fact, most workplaces require that new employees have a basic level of understanding of Microsoft Excel.

If you want to learn the 2019 version of Microsoft Excel, this course will introduce you to the program's basic functions and uses. Through hands-on lessons, you will learn numerous shortcuts to quickly and efficiently set up worksheets. You will also learn how to use the function wizard to calculate statistics, future values, and more. In addition, you will get tips on sorting and analyzing data, creating three-dimensional workbooks, and automating frequently-repeated tasks with macros and buttons. By the time you're done, you will know how to use this vital Office 2019 tool.

Requirements:

Hardware Requirements:

• This course must be taken on a PC. It is not suitable for Macs or Chromebooks.

Software Requirements:

• PC: Windows 10 or later.
• Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge is also compatible.
• Microsoft Excel 2019 (desktop version), available to download with the desktop version of Microsoft 365, or Microsoft Office Home and Student 2019 (not included in enrollment).
• Note: The "Starter Version" and "Web App" versions of Microsoft will not work with the full version taught in this course.
• Adobe Acrobat Reader.
• Software must be installed and fully operational before the course begins.

Other:

• Email capabilities and access to a personal email account.

Instructional Material Requirements:

The instructional materials required for this course are included in enrollment and will be available online.

Learn to quickly and efficiently use Microsoft Excel 2019/Office 365 as you discover dozens of shortcuts and tricks for setting up fully formatted worksheets. This course, taught by an experience Microsoft Excel instructor, provides in-depth knowledge for beginners that will have you using Excel like a pro.

Excel Basics

In this lesson, you'll develop a solid understanding of the Excel interface. You'll become fluent in the secret language spoken only by Excel users, you'll discover the best way to correct just about any mistake you might make in Excel, and you'll find yourself gliding effortlessly from cell to cell, leaving behind expertly written labels, numbers, and formulas.

Creating a Worksheet

In this lesson, you'll learn five simple steps you should always follow to ensure that your worksheets are always well-planned, well-constructed, and beautifully formatted.

Time-Savers

This lesson will teach you the tricks of the Excel masters: a wide variety of useful shortcuts guaranteed to save you time, energy, and frustration. You'll also spend some time working with the Quick Analysis and Flash Fill tools. By the time you finish this lesson, you'll really start to feel like an Excel pro.

Relative, Absolute, Mixed, and Circular References

Do you know the difference between a relative reference, an absolute reference, a mixed reference, and a circular reference? You will after this lesson. In this lesson, you'll learn to write sophisticated formulas that can help ease you through some rather sticky scenarios.

Three-Dimensional Workbooks

With enough practice, most Excel users quickly become adept at organizing their worksheets across two dimensions: rows and columns. But only a select few will learn how to take their worksheets into the third dimension. In this lesson, you'll join that exclusive group. Prepare to have your socks knocked off as you gain hands-on experience in the construction of three-dimensional workbooks.

Sorting, Subtotaling, and Filtering

No Excel course would be complete without a discussion of Excel's amazing data-crunching capabilities. In this lesson, you'll learn how to build a table in Excel as well as how to subtotal, sort, and filter.

Charting Basics

In this lesson, you'll explore the exciting world of charts. You'll build your first graph and learn how easy it is to adjust the chart type, labels, titles, colors, and other aspects of your chart.

Advanced Charting Techniques

In this lesson, you'll dig deep into Excel's charting capabilities. You'll explore everything from bar charts and line charts to more prosaic graphs like the pie chart and 3D charts. You'll find out how to personalize your charts with photographs, text labels, and drawings. You'll also discover the best ways to format your chart for print or otherwise display the truly impressive charts that you'll be creating.

Intro to Excel's Statistical Functions

Excel includes many powerful functions that can automatically perform some very complicated tasks for you. In this lesson, you'll learn some very interesting ways to put these functions to work for you. You'll find out how to ask Excel to magically derive averages, modes, maximums, minimums, and other useful statistics from nothing more than a column or two of numbers.

Financial Functions

You'll continue your exploration of Excel functions with an in-depth look at Excel's handy financial functions. By the time this lesson is over, you'll be able to figure out how much money you'll have when you retire, when your kids reach college, or just before your next vacation. You'll be able to calculate the monthly payment on just about any type of loan, and you'll know how to figure out how long it will take to pay off your credit cards. You'll even create an amortization table of your very own, just like the one lenders use to track a loan's payoff amount over time.

Worksheet Automation

In this lesson, you'll find out how to automate just about any task you find tedious or time-consuming. You'll discover how to move your most frequently used commands from their present, obscure locations to a much more convenient place: the toolbar that's always perched at the very top of your screen. You'll also learn how you can use macros to reduce just about any complex task to a single keystroke.

Mastering Excel's IF Function

You'll be intrigued by the final lesson, in which you'll learn how to use Excel to aid you in decision making. You'll use a special function in Excel that allows it to make comparisons and use those comparisons as the basis for important decisions.

What you will learn

• How to create worksheets, charts, and graphs
• Methods for sorting and analyzing automating often repeated tasks
• How to parse data with Flash Fill
• Important keyboard shortcuts

How you will benefit

• Knowing how to use Excel 2019 will make you a more productive member of your organization
• Gain indispensable skills that will be useful for numbers-based reporting
• Develop skills that can be used to simplify your life of calculating and displaying numbers both personally and professionally

Chad Wambolt has spent his entire professional career in the finance field, working for both private and publicly-held companies with sales ranging from $500 million to $3 billion. He is a graduate of Boise State University, where he obtained his bachelor's degree in accounting. Through the course of his career, Wambolt became an expert user of Microsoft Excel. Since 1997, he has taught Excel to students of varying skill levels and helped organizations streamline internal processes.

Are you overloaded with emails, meetings, and to-do lists? Make use of Microsoft Outlook 2019 functions, and you will rapidly increase your efficiency and productivity.

Whether for personal use or work, everyone needs to stay organized. In today's world, being organized means tracking email messages and appointments, storing names and contact information of important people, and creating to-do lists to help you complete various types of projects for yourself or your job.

Many people rely on Microsoft Outlook 2019, a unique tool to help you manage email, appointments, tasks, and contacts in a single program. In this course, you'll learn how to use Microsoft Outlook 2019 for Windows, which you can buy separately or through a subscription to Microsoft 365.

You will learn to save, sort, organize, and read email messages. Set appointments along with reminders, so you'll never miss an important date! Store and search through names of important people and their contact information, and create task lists to help you make progress on different projects. By the end of the course, you'll master how to effectively navigate Outlook's four main features: Mail, Appointments, People, and Tasks.

Besides learning how to create email messages, appointments, task lists, and contact information, you'll also learn how to search and find information and sort and organize data. Whether you need to manage your personal life or your professional world, the step-by-step lessons in this course will help you master Outlook for use at home or work.

Requirements:

Hardware Requirements:

• This course must be taken on a PC. Macs and Chromebooks are not compatible.

Software Requirements:

• PC: Windows 10 or later.
• Browser: The latest version of Google Chrome or Mozilla Firefox is preferred. Microsoft Edge is also compatible.
• Microsoft Office Outlook 2019 (not included in enrollment)
• Adobe Acrobat Reader.
• Software must be installed and fully operational before the course begins.

Other:

• Email capabilities and access to a personal email account.

Instructional Material Requirements:

The instructional materials required for this course are included in enrollment and will be available online.

This Microsoft Outlook training class introduces the 2019 interface and will get you up and running quickly, working effectively with messages, calendars, and contacts.

Getting Started with Outlook 2019

In this lesson, you'll get acquainted with Outlook. You'll go over the basics of what Outlook can do and how you can use it to save time and keep yourself organized. You'll also get familiar with Outlook's user interface to help you feel comfortable using the program. After you finish this lesson, you'll be ready to start using Outlook and switching between its different functions (Mail, Calendar, People, and Tasks).

Reading Email Messages

This lesson will help you make sense of all your email messages without forcing you to scroll through a long list of messages. You'll learn how to display, sort, and organize email messages. Since email is the most popular way to communicate with people anywhere globally, learning how to read and organize email in Outlook could be the feature you'll use most often.

Finding and Grouping Messages

Receiving email is always fun, but finding ways to search through all your email messages to find what you need can spell the difference between using email as a powerful communication tool or getting lost in the daily flood of email messages. In this lesson, you'll learn how to search, tag, and select email messages and move them to a folder. You will also explore strategies for labeling and organizing email messages.

Creating Email Messages

By receiving email messages and responding to them or simply writing new email messages all your own, you can turn your email account into a two-way communication medium to reach out to people anywhere around the world. In this lesson, you'll learn different ways to create and reply to messages. You will also identify ways to edit and send email messages.

Formatting Email Messages

In this lesson, you'll learn how to format text in your email messages to make your messages more appealing and readable. Formatting text doesn't just mean improving cosmetic appearances but can also mean displaying text in an organized fashion, so it's easier to read. You will identify ways to improve email messages through the use of different fonts, colors, and styles, as well as the use of spelling and grammar checks. You'll also learn how to use bulleted and numbered lists to ensure your emails are easy to read and understand.

Editing Email Messages

This lesson is all about polishing your text, so everything is correct. After all, your words may be powerful, but if there are typos or grammatical mistakes, your email message can look less valid and legitimate. In this lesson, you'll learn different ways to proofread and edit email messages. You'll explore the search and replace feature, learn how to create hyperlinks for email and website addresses, learn how to use the signature feature, and explore different styles for your email messages.

Sending Attachments to Email Messages

Sending email messages with file attachments lets you communicate with others using more than just what you can type. You can share a spreadsheet for others to edit, send someone an interesting PDF file to read, or give someone a short video of yourself wishing him a happy birthday. In this lesson, you'll learn how to add files such as word processor documents, spreadsheets, databases, or presentations along with video and audio files to your email messages. You'll also learn how to add images to email messages and edit these using word wrapping and other methods.

Dealing with Wanted and Unwanted Email

In this lesson, you'll learn how to deal with both wanted and unwanted email messages so you can focus your time on having fun and being productive. You'll learn how to delete and retrieve email messages, as well as how to archive them. Most of your email messages will likely be those you want to receive, but too many of them can make it difficult to find what you need, so you will also learn the benefits of creating rules for sorting emails so you can deal with junk email messages easier.

Storing Contact Information

Outlook offers a way to store names and contact information in a database. Not only can this database grow as large as necessary, but no matter how big it gets, Outlook still makes it easy for you to search and find the information you need quickly and accurately. In this lesson, you'll learn all about using Outlook to store contact information of the people most important to you for business and personal use. You'll learn how to create and keep contacts, sharing and search contacts, and group and sort contacts.

Using the Outlook Calendar

Everyone needs to meet people or be at a certain place at a specific time. For busier people, your scheduled appointments may become so numerous and varied that keeping track of your time can be cumbersome. In this lesson, you'll learn all about using Outlook's calendar feature to create and store appointments. You'll identify the different ways to view and use the calendar. You'll also explore setting and viewing appointments, as well as managing, editing, and sharing these appointments.

Creating Task Lists

In this lesson, you'll learn all about using Outlook to create tasks that can help you stay focused on achieving the goals you want to achieve. Outlook makes it easy to create and store your list of tasks that you can view whenever you use Outlook. In this lesson, you'll learn how to create a task list, tag and add details to a task, and manage your tasks. Outlook's task list is just one more tool to help you keep your life organized and focused.

Taking Notes and Customizing Outlook

Once you learn how to use Outlook's note-taking feature, you can learn different keystroke shortcuts and how to customize Outlook further to serve your particular needs better. In this lesson, you'll identify ways to create and modify notes. You'll also identify keystroke shortcuts and how to use these. Along with this, you'll learn different ways to customize Outlook's user interface and change Outlook's settings. You'll also have a chance to reflect on Outlook's various features you find most valuable and then decide how you plan to customize Outlook to make it easier for you.

What you will learn

• Understand the basics of the Outlook 2019 interface and how to navigate the program
• Create a standard Mail view to work from and learn the basics of sending and receiving email
• Get to know everything you need to know about Outlook's contacts, Contacts views, Contact Groups, and Address Books
• Learn how to link Outlook to social media sites, and find out how information from People can appear throughout Outlook
• Learn how to work with one or more Outlook Calendars and the associated items: appointments, meetings, and events.
• Learn how to work with Outlook tasks and to-dos
• Learn how to customize Outlook

How you will benefit

• Harness the full power of Outlook 2019 so you can be more productive
• Learn to better communicate and keep track of all your responsibilities

Wallace Wang is the author of over 40 computer books, including "Microsoft Office 2019 For Dummies." In addition to writing computer books, he has also co-authored "Breaking Into Acting for Dummies" and ghostwritten several books about investing in real estate, day trading stocks, and becoming an entrepreneur. Some of his past jobs have included teaching computer science courses at the University of Zimbabwe, performing stand-up comedy, and appearing on a weekly radio show.

Are you overloaded with emails, meetings, and to-do lists? Make use of Microsoft Outlook 2019 functions, and you will rapidly increase your efficiency and productivity.

Whether for personal use or work, everyone needs to stay organized. In today's world, being organized means tracking email messages and appointments, storing names and contact information of important people, and creating to-do lists to help you complete various types of projects for yourself or your job.

Many people rely on Microsoft Outlook 2019, a unique tool to help you manage email, appointments, tasks, and contacts in a single program. In this course, you'll learn how to use Microsoft Outlook 2019 for Windows, which you can buy separately or through a subscription to Microsoft 365.

You will learn to save, sort, organize, and read email messages. Set appointments along with reminders, so you'll never miss an important date! Store and search through names of important people and their contact information, and create task lists to help you make progress on different projects. By the end of the course, you'll master how to effectively navigate Outlook's four main features: Mail, Appointments, People, and Tasks.

Besides learning how to create email messages, appointments, task lists, and contact information, you'll also learn how to search and find information and sort and organize data. Whether you need to manage your personal life or your professional world, the step-by-step lessons in this course will help you master Outlook for use at home or work.

Requirements:

Hardware Requirements:

• This course must be taken on a PC. Macs and Chromebooks are not compatible.

Software Requirements:

• PC: Windows 10 or later.
• Browser: The latest version of Google Chrome or Mozilla Firefox is preferred. Microsoft Edge is also compatible.
• Microsoft Office Outlook 2019 (not included in enrollment)
• Adobe Acrobat Reader.
• Software must be installed and fully operational before the course begins.

Other:

• Email capabilities and access to a personal email account.

Instructional Material Requirements:

The instructional materials required for this course are included in enrollment and will be available online.

This Microsoft Outlook training class introduces the 2019 interface and will get you up and running quickly, working effectively with messages, calendars, and contacts.

Getting Started with Outlook 2019

In this lesson, you'll get acquainted with Outlook. You'll go over the basics of what Outlook can do and how you can use it to save time and keep yourself organized. You'll also get familiar with Outlook's user interface to help you feel comfortable using the program. After you finish this lesson, you'll be ready to start using Outlook and switching between its different functions (Mail, Calendar, People, and Tasks).

Reading Email Messages

This lesson will help you make sense of all your email messages without forcing you to scroll through a long list of messages. You'll learn how to display, sort, and organize email messages. Since email is the most popular way to communicate with people anywhere globally, learning how to read and organize email in Outlook could be the feature you'll use most often.

Finding and Grouping Messages

Receiving email is always fun, but finding ways to search through all your email messages to find what you need can spell the difference between using email as a powerful communication tool or getting lost in the daily flood of email messages. In this lesson, you'll learn how to search, tag, and select email messages and move them to a folder. You will also explore strategies for labeling and organizing email messages.

Creating Email Messages

By receiving email messages and responding to them or simply writing new email messages all your own, you can turn your email account into a two-way communication medium to reach out to people anywhere around the world. In this lesson, you'll learn different ways to create and reply to messages. You will also identify ways to edit and send email messages.

Formatting Email Messages

In this lesson, you'll learn how to format text in your email messages to make your messages more appealing and readable. Formatting text doesn't just mean improving cosmetic appearances but can also mean displaying text in an organized fashion, so it's easier to read. You will identify ways to improve email messages through the use of different fonts, colors, and styles, as well as the use of spelling and grammar checks. You'll also learn how to use bulleted and numbered lists to ensure your emails are easy to read and understand.

Editing Email Messages

This lesson is all about polishing your text, so everything is correct. After all, your words may be powerful, but if there are typos or grammatical mistakes, your email message can look less valid and legitimate. In this lesson, you'll learn different ways to proofread and edit email messages. You'll explore the search and replace feature, learn how to create hyperlinks for email and website addresses, learn how to use the signature feature, and explore different styles for your email messages.

Sending Attachments to Email Messages

Sending email messages with file attachments lets you communicate with others using more than just what you can type. You can share a spreadsheet for others to edit, send someone an interesting PDF file to read, or give someone a short video of yourself wishing him a happy birthday. In this lesson, you'll learn how to add files such as word processor documents, spreadsheets, databases, or presentations along with video and audio files to your email messages. You'll also learn how to add images to email messages and edit these using word wrapping and other methods.

Dealing with Wanted and Unwanted Email

In this lesson, you'll learn how to deal with both wanted and unwanted email messages so you can focus your time on having fun and being productive. You'll learn how to delete and retrieve email messages, as well as how to archive them. Most of your email messages will likely be those you want to receive, but too many of them can make it difficult to find what you need, so you will also learn the benefits of creating rules for sorting emails so you can deal with junk email messages easier.

Storing Contact Information

Outlook offers a way to store names and contact information in a database. Not only can this database grow as large as necessary, but no matter how big it gets, Outlook still makes it easy for you to search and find the information you need quickly and accurately. In this lesson, you'll learn all about using Outlook to store contact information of the people most important to you for business and personal use. You'll learn how to create and keep contacts, sharing and search contacts, and group and sort contacts.

Using the Outlook Calendar

Everyone needs to meet people or be at a certain place at a specific time. For busier people, your scheduled appointments may become so numerous and varied that keeping track of your time can be cumbersome. In this lesson, you'll learn all about using Outlook's calendar feature to create and store appointments. You'll identify the different ways to view and use the calendar. You'll also explore setting and viewing appointments, as well as managing, editing, and sharing these appointments.

Creating Task Lists

In this lesson, you'll learn all about using Outlook to create tasks that can help you stay focused on achieving the goals you want to achieve. Outlook makes it easy to create and store your list of tasks that you can view whenever you use Outlook. In this lesson, you'll learn how to create a task list, tag and add details to a task, and manage your tasks. Outlook's task list is just one more tool to help you keep your life organized and focused.

Taking Notes and Customizing Outlook

Once you learn how to use Outlook's note-taking feature, you can learn different keystroke shortcuts and how to customize Outlook further to serve your particular needs better. In this lesson, you'll identify ways to create and modify notes. You'll also identify keystroke shortcuts and how to use these. Along with this, you'll learn different ways to customize Outlook's user interface and change Outlook's settings. You'll also have a chance to reflect on Outlook's various features you find most valuable and then decide how you plan to customize Outlook to make it easier for you.

What you will learn

• Understand the basics of the Outlook 2019 interface and how to navigate the program
• Create a standard Mail view to work from and learn the basics of sending and receiving email
• Get to know everything you need to know about Outlook's contacts, Contacts views, Contact Groups, and Address Books
• Learn how to link Outlook to social media sites, and find out how information from People can appear throughout Outlook
• Learn how to work with one or more Outlook Calendars and the associated items: appointments, meetings, and events.
• Learn how to work with Outlook tasks and to-dos
• Learn how to customize Outlook

How you will benefit

• Harness the full power of Outlook 2019 so you can be more productive
• Learn to better communicate and keep track of all your responsibilities

Wallace Wang is the author of over 40 computer books, including "Microsoft Office 2019 For Dummies." In addition to writing computer books, he has also co-authored "Breaking Into Acting for Dummies" and ghostwritten several books about investing in real estate, day trading stocks, and becoming an entrepreneur. Some of his past jobs have included teaching computer science courses at the University of Zimbabwe, performing stand-up comedy, and appearing on a weekly radio show.

Learn how to use Microsoft PowerPoint 2016 (now available through Office 365) to create professional-looking presentations using slide and layout masters that make global changes in a snap.

Take your PowerPoint presentations from ordinary to extraordinary! In these lessons, you'll learn how to use Microsoft PowerPoint 2016 (now available through Office 365) to create professional-quality slide presentations that grab and hold your audience's attention from start to finish.

You'll see how to plan a presentation for your audience, format it with themes and color, and use the slide master and layout master to make global changes. You'll embellish your slides with text and objects, including pictures, shapes, WordArt, and SmartArt, and learn to add multimedia effects to create animated presentations and more. If you want to become a PowerPoint pro, this is the course for you!

Requirements:

Hardware Requirements:

• This course must be taken on a PC. It is not suitable for Macs.

Software Requirements:

• PC: Windows 8 or later.
• Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge is also compatible.
• Microsoft Office Home and Student 2016 or a subscription to Office 365 (not included in enrollment).
• Adobe Acrobat Reader.
• Software must be installed and fully operational before the course begins.

Other:

• Email capabilities and access to a personal email account.

Instructional Material Requirements:

The instructional materials required for this course are included in enrollment and will be available online.

Take your presentations from "so-so" to sensation with PowerPoint. This course will help you discover how to use Microsoft PowerPoint 2016 to create professional-quality slide presentations that grab attention from start to finish and make your message memorable.

The PowerPoint 2016 Interface

Come explore the basic features of Microsoft PowerPoint 2016! You'll learn about the Ribbon, which replaces the menu and toolbars so common in other programs written for the Windows operating system. You'll find out how to plan a presentation and start the PowerPoint program and practice working with different views, task panes, tabs, and templates.

Creating Presentations

Now that you know the basics of PowerPoint, it's time to create a presentation from scratch. You'll start by choosing a theme for the presentation and create slides with a variety of slide layouts. You'll find out about the Live Preview feature and learn how to save a file so that you can find it later. You'll also create and edit slides in the slide pane and in Outline view. Finally, the lesson will go over the ways to put on a slide show.

Creating and Editing Tables and Opening and Saving Files

Including tables in your presentation lets you present a lot of information in a little space. So in this lesson, you'll add, revise, and format tables. You'll also learn multiple ways to open a presentation. Then, the lesson will teach you how to preserve different versions of your work by saving with different filenames.

Creating and Printing Error-Free Presentations

This lesson will cover two topics: printing and proofreading. You'll learn to print your presentation as slides, handouts, an outline, and notes pages. This versatility will really help you connect with audience members! To make sure your printed presentation is as close to perfect as it can be, you'll explore the Spelling, AutoCorrect, and Thesaurus features, along with the new Smart Lookup feature.

Working With Saved and Online Images

You're going to switch gears in this lesson and work with images instead of text, which you'll probably enjoy. You'll see how to embellish your slides with media clips, which could include illustrations, clip art, and photographs. You'll even learn how to download an image from a website and insert the image on a slide.

WordArt, Shapes, and SmartArt

You're going to work with WordArt, Shapes, and SmartArt Graphics in this lesson, which is very exciting. It's fun to transform text into colorful WordArt objects and to draw and fill shapes with color and special effects. You'll learn to group and edit the objects you create and add visual sophistication to your text with SmartArt Graphics.

Creating and Editing a Chart

In this lesson, you'll create and edit a chart slide to illustrate statistical data. You'll find this lesson easy if you like working with numbers! If you don't enjoy math, that's okay—the lesson will walk you through everything you need to know and do to create a chart slide. It will also show you how to change the look of your chart by using the options on the Chart Tools contextual tab and the chart formatting buttons.

Making Global Changes to a Presentation

Making the same changes to dozens of PowerPoint slides is boring and time-consuming. In this lesson, you'll look at global changes you can make to your slides, handouts, and notes. For example, if you want to increase or decrease the font size on all the slides in a presentation, just make the change on the slide master. You'll also make global changes when you modify your presentation's theme colors or background.

Creating Links

In this lesson, you'll work with hyperlinks and action buttons. You'll enliven your presentation as you learn to create links from text or objects to other slides, presentations, documents, and web pages. You can even add sounds and 3D effects!

Applying Animation to Slides, Text, and Objects

Have you seen a presentation where text, images, or entire slides fly in from the top or push up from the bottom? That's animation. In this lesson, you'll learn about slide transitions, the options on the Transition tab, and you'll apply animation to text and objects on slides and the slide or layout master with the options on the Animations tab. You'll then find out how to add sound effects, such as chimes and whooshes, to slide transitions. Perhaps most important, you'll also learn how to avoid overdoing these effects!

Applying Advanced Animation Effects to Text and Objects

You already know how to apply animation to your slides as they transition. Now it's time to apply advanced animation effects to text and objects on slides and slide and layout masters. With the animation commands and the Animation Pane, you'll add and reorder animated text and objects on slides. You'll also add an audio clip to your presentation.

Sharing and Saving Your Presentations, Including OneDrive and Office Online

Now that you know so much about creating PowerPoint presentations, you'll focus on different ways to save and share them. You'll see how easy it is to export your presentation as a PDF file, so it'll be accessible on computers that don't have PowerPoint 2016. You'll learn to open, edit, and share your presentation online with a Windows OneDrive account and PowerPoint Online and how to turn your presentation into a video.

What you will learn

• Learn how to plan a presentation for your audience
• Understand how to format it with themes and color and use the slide master and layout master to make global changes
• Explore how to embellish your slides with text and objects, including pictures, shapes, WordArt, and SmartArt
• Learn to add multimedia effects to create animated presentations
• Explore the options on the PowerPoint Ribbon, including the new Online Pictures command, File menu options, and Backstage View
• Learn how to print slides, handouts, and even an outline
• Discover the best view for creating and editing your slides and running your presentations

How you will benefit

• Master PowerPoint skills that will help you produce better presentations
• Become an integral team member at your company with professional presentation design skills
• Gain skills that will transfer to any organization and will look great on your résumé

Kathy Van Pelt has taught computer courses at a community college for the past 25 years. She specializes in Microsoft Office applications, Google Drive and Google Applications, the Windows and Mac operating systems, and keyboarding. She spent seven years teaching word processing and business classes at a private business college and loves being in the ever-evolving educational field.

Learn how to use Microsoft PowerPoint 2016 (now available through Office 365) to create professional-looking presentations using slide and layout masters that make global changes in a snap.

Take your PowerPoint presentations from ordinary to extraordinary! In these lessons, you'll learn how to use Microsoft PowerPoint 2016 (now available through Office 365) to create professional-quality slide presentations that grab and hold your audience's attention from start to finish.

You'll see how to plan a presentation for your audience, format it with themes and color, and use the slide master and layout master to make global changes. You'll embellish your slides with text and objects, including pictures, shapes, WordArt, and SmartArt, and learn to add multimedia effects to create animated presentations and more. If you want to become a PowerPoint pro, this is the course for you!

Requirements:

Hardware Requirements:

• This course must be taken on a PC. It is not suitable for Macs.

Software Requirements:

• PC: Windows 8 or later.
• Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge is also compatible.
• Microsoft Office Home and Student 2016 or a subscription to Office 365 (not included in enrollment).
• Adobe Acrobat Reader.
• Software must be installed and fully operational before the course begins.

Other:

• Email capabilities and access to a personal email account.

Instructional Material Requirements:

The instructional materials required for this course are included in enrollment and will be available online.

Take your presentations from "so-so" to sensation with PowerPoint. This course will help you discover how to use Microsoft PowerPoint 2016 to create professional-quality slide presentations that grab attention from start to finish and make your message memorable.

The PowerPoint 2016 Interface

Come explore the basic features of Microsoft PowerPoint 2016! You'll learn about the Ribbon, which replaces the menu and toolbars so common in other programs written for the Windows operating system. You'll find out how to plan a presentation and start the PowerPoint program and practice working with different views, task panes, tabs, and templates.

Creating Presentations

Now that you know the basics of PowerPoint, it's time to create a presentation from scratch. You'll start by choosing a theme for the presentation and create slides with a variety of slide layouts. You'll find out about the Live Preview feature and learn how to save a file so that you can find it later. You'll also create and edit slides in the slide pane and in Outline view. Finally, the lesson will go over the ways to put on a slide show.

Creating and Editing Tables and Opening and Saving Files

Including tables in your presentation lets you present a lot of information in a little space. So in this lesson, you'll add, revise, and format tables. You'll also learn multiple ways to open a presentation. Then, the lesson will teach you how to preserve different versions of your work by saving with different filenames.

Creating and Printing Error-Free Presentations

This lesson will cover two topics: printing and proofreading. You'll learn to print your presentation as slides, handouts, an outline, and notes pages. This versatility will really help you connect with audience members! To make sure your printed presentation is as close to perfect as it can be, you'll explore the Spelling, AutoCorrect, and Thesaurus features, along with the new Smart Lookup feature.

Working With Saved and Online Images

You're going to switch gears in this lesson and work with images instead of text, which you'll probably enjoy. You'll see how to embellish your slides with media clips, which could include illustrations, clip art, and photographs. You'll even learn how to download an image from a website and insert the image on a slide.

WordArt, Shapes, and SmartArt

You're going to work with WordArt, Shapes, and SmartArt Graphics in this lesson, which is very exciting. It's fun to transform text into colorful WordArt objects and to draw and fill shapes with color and special effects. You'll learn to group and edit the objects you create and add visual sophistication to your text with SmartArt Graphics.

Creating and Editing a Chart

In this lesson, you'll create and edit a chart slide to illustrate statistical data. You'll find this lesson easy if you like working with numbers! If you don't enjoy math, that's okay—the lesson will walk you through everything you need to know and do to create a chart slide. It will also show you how to change the look of your chart by using the options on the Chart Tools contextual tab and the chart formatting buttons.

Making Global Changes to a Presentation

Making the same changes to dozens of PowerPoint slides is boring and time-consuming. In this lesson, you'll look at global changes you can make to your slides, handouts, and notes. For example, if you want to increase or decrease the font size on all the slides in a presentation, just make the change on the slide master. You'll also make global changes when you modify your presentation's theme colors or background.

Creating Links

In this lesson, you'll work with hyperlinks and action buttons. You'll enliven your presentation as you learn to create links from text or objects to other slides, presentations, documents, and web pages. You can even add sounds and 3D effects!

Applying Animation to Slides, Text, and Objects

Have you seen a presentation where text, images, or entire slides fly in from the top or push up from the bottom? That's animation. In this lesson, you'll learn about slide transitions, the options on the Transition tab, and you'll apply animation to text and objects on slides and the slide or layout master with the options on the Animations tab. You'll then find out how to add sound effects, such as chimes and whooshes, to slide transitions. Perhaps most important, you'll also learn how to avoid overdoing these effects!

Applying Advanced Animation Effects to Text and Objects

You already know how to apply animation to your slides as they transition. Now it's time to apply advanced animation effects to text and objects on slides and slide and layout masters. With the animation commands and the Animation Pane, you'll add and reorder animated text and objects on slides. You'll also add an audio clip to your presentation.

Sharing and Saving Your Presentations, Including OneDrive and Office Online

Now that you know so much about creating PowerPoint presentations, you'll focus on different ways to save and share them. You'll see how easy it is to export your presentation as a PDF file, so it'll be accessible on computers that don't have PowerPoint 2016. You'll learn to open, edit, and share your presentation online with a Windows OneDrive account and PowerPoint Online and how to turn your presentation into a video.

What you will learn

• Learn how to plan a presentation for your audience
• Understand how to format it with themes and color and use the slide master and layout master to make global changes
• Explore how to embellish your slides with text and objects, including pictures, shapes, WordArt, and SmartArt
• Learn to add multimedia effects to create animated presentations
• Explore the options on the PowerPoint Ribbon, including the new Online Pictures command, File menu options, and Backstage View
• Learn how to print slides, handouts, and even an outline
• Discover the best view for creating and editing your slides and running your presentations

How you will benefit

• Master PowerPoint skills that will help you produce better presentations
• Become an integral team member at your company with professional presentation design skills
• Gain skills that will transfer to any organization and will look great on your résumé

Kathy Van Pelt has taught computer courses at a community college for the past 25 years. She specializes in Microsoft Office applications, Google Drive and Google Applications, the Windows and Mac operating systems, and keyboarding. She spent seven years teaching word processing and business classes at a private business college and loves being in the ever-evolving educational field.

Discover how to effectively plan and implement projects using the world's most popular project management software, Microsoft Project 2019.

Microsoft Project is a staple for project management and remains the most widely-used project management software across all industries. If you manage projects in your organization, learning how to use this longstanding resource is key to successfully and effectively seeing your projects through to completion.

In this course, you will discover how to effectively plan, implement, and control projects using Microsoft Project 2019. From sequencing tasks, producing a baseline, and assigning resources and costs, to tracking progress and revising your project plan, Microsoft Project can help you organize all your project's details.

Armed with this information, you will avoid stalling or overloading your schedule. If you encounter trouble, you will know how to best utilize Project 2019 to get your project back on track.

Requirements:

Hardware Requirements:

• This course must be taken on a PC. Macs are not compatible.

Software Requirements:

• PC: Windows 10 or later.
• Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge is also compatible.
• Microsoft Project 2019 (not included in enrollment).
• Adobe Acrobat Reader.
• Software must be installed and fully operational before the course begins.

Other:

• Email capabilities and access to a personal email account.

Instructional Material Requirements:

The instructional materials required for this course are included in enrollment and will be available online.

Learn to effectively plan, implement, and control projects using Microsoft Project 2019/Office 365. This course will help you master the basics to create and share a project schedule, track costs and resources, produce reports, and resolve problems to keep your projects on track.

Overview of Microsoft Project

Microsoft Project can help you manage your project's schedule, costs, and scope in a way that you've never dreamed of. Too often, Project users never use this powerful tool to its fullest potential. In this lesson, you'll discover how to improve your project by adopting a formal management approach. You'll get a quick overview of Project Management, and then you'll learn the basics of Microsoft Project, including a summary of the Gantt Chart view and ways to create and enter project tasks.

Creating a Solid Foundation

If you're looking for ways to keep organized, you'll see just how to do that in this lesson! You'll go through the steps to create a project schedule in no time flat. Once you create and enter tasks in Project's Gantt Chart view, you'll set a schedule by using a calendar and assigning lead times. Then, you'll need to create task dependencies, sometimes known as links. You'll see how to perform these activities and, in the process, you'll become comfortable using Project's many dialog boxes. Before you know it, you'll be creating schedules for all your projects with little effort.

Creating and Managing Resources

You won't get too far with your project without adding resources. While tasks create the backbone of your project, you'll also need people, equipment, and materials to bring your project to life. In this lesson, you'll find out how to apply two types of Project resources—work resources, and material resources. You'll look at two more dialog boxes—Resource Information and Assign Resources—and you'll learn how to analyze resources by using the Resource Sheet and Resource Usage views.

Defining and Assigning Costs

No matter what project you work on, the bottom line is always important. So, get ready to add the final piece to your basic project schedule—costs. You'll start things off by looking through a brief overview of cost accounting, exploring fixed, variable, relevant, and accrued costs. After this review, you'll learn how to assign costs by using the Resource Sheet. You'll even discover how to assign different costs for the same resource and analyze the overall costs for your project by using the Cost Table.

Project Templates, Security, and Constraints

Successful project managers are known for their efficiency and for safeguarding private information. Microsoft Project provides two excellent methods to help you in these areas: project templates and project security. You'll find out how to use some of the many templates Project has to offer, including the Residential Construction template and the New Product template. You'll also learn how to protect your project information with backups, passwords, and write protection. Then you'll discover how to put Project's task constraints to good use.

Working With Views and Managing Information

In this lesson, you'll discover how easy it is to modify your basic schedules and work with project data. You'll look at the various Project views, such as the Calendar, Leveling Gantt, and the Network Diagram. If you don't like the default colors or fonts in your schedule or table, you'll be well-prepared to make changes. You'll even learn how and why you might want to create a combination view; add notes to your project; or sort, filter, and group data.

Fine-Tuning Your Project Plan

Many projects experience schedule compression when management or clients ask that the project be completed sooner and for less. In this lesson, you'll discover how to improve your schedule's performance. You'll explore the Project Statistics dialog box, and you'll learn how to determine the ideal starting point in terms of planned costs and completion dates. You'll see how to change task dependencies to speed up your project and also find out how to split tasks to add more lead time. You'll also learn how to create recurring tasks and attach notes to your project's taskbars.

Baselines and Tracking

Before you implement your project, you need to create a baseline. This will help you track actual results against what you originally set out to accomplish. Microsoft Project makes it possible to set up a baseline with a few mouse clicks. You'll learn how to create a baseline and then see a variety of ways, including using the Tracking toolbar, to record your actual project results.

Managing Variances

Here's where things really start to come together! You'll learn how to compare actual results to your baseline by using the Gantt Chart and reviewing a table. You'll discover how useful status identifiers and progress lines can be to quickly gain information about your project's position. You'll also begin using the Tracking Gantt and filters to automatically identify slipping tasks. You'll also take a stroll through the basics of variance analysis by discussing the Start and Finish Date, Resources, and Work Variance Tables.

Closing Your Project

No project is complete until it's officially closed. In this final lesson, you'll find out how to close your project and use the Organizer to help you customize and copy views for future projects.

Printing Views

Now that you're using reports to share project information, you'll occasionally need to print various views and tables. In this lesson, you'll delve into printing Microsoft Project documents. You'll be a master at creating different views of your project with the Page Setup dialog box, and you'll clearly understand the mechanics of the Print dialog box and the Print Preview.

Using and Creating Reports

Once your project gets rolling, outsiders will probably want to know how things are going. It can be a real time drain answering each request individually. When others request information from you, Microsoft Project offers the perfect solution: Reports. You'll go over a representative sample of the standard reports as well as discuss how to modify and create new reports in this lesson. By the time you finish, you'll be well acquainted with Project's reporting capabilities and also know how to create Visual Reports as Project automatically exports data to Microsoft Excel and Visio.

What you will learn

• Effective planning, implementation, and control projects using Microsoft Project
• How to enhance your project in the areas of efficiency and security
• The importance of setting a project baseline and tracking actual results
• Generate several standard project reports and a wide variety of visual project reports

How you will benefit

• Know how to the use of the world's most popular project management software
• Gain transferable skills
• Replace informal project plans with plans based on logic and structures reflective

Tony Swaim has helped many clients, colleagues, and students reach their professional and personal goals. He has been an online instructor since 1998 and has taught at colleges and universities across the United States since 1981. His focus areas are project management, Six Sigma, and supply chain management. Tony manages a successful consulting firm, and his industry experience includes 20 years of supply chain management. He earned a Doctorate in Business Administration from Kennesaw State University and holds professional certifications in six disciplines, including the Project Management Professional (PMP)® certification from the Project Management Institute (PMI)® and Certified Six Sigma Black Belt (CSSBB)® from the American Society for Quality (ASQ)®.

Discover how to effectively plan and implement projects using the world's most popular project management software, Microsoft Project 2019.

Microsoft Project is a staple for project management and remains the most widely-used project management software across all industries. If you manage projects in your organization, learning how to use this longstanding resource is key to successfully and effectively seeing your projects through to completion.

In this course, you will discover how to effectively plan, implement, and control projects using Microsoft Project 2019. From sequencing tasks, producing a baseline, and assigning resources and costs, to tracking progress and revising your project plan, Microsoft Project can help you organize all your project's details.

Armed with this information, you will avoid stalling or overloading your schedule. If you encounter trouble, you will know how to best utilize Project 2019 to get your project back on track.

Requirements:

Hardware Requirements:

• This course must be taken on a PC. Macs are not compatible.

Software Requirements:

• PC: Windows 10 or later.
• Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge is also compatible.
• Microsoft Project 2019 (not included in enrollment).
• Adobe Acrobat Reader.
• Software must be installed and fully operational before the course begins.

Other:

• Email capabilities and access to a personal email account.

Instructional Material Requirements:

The instructional materials required for this course are included in enrollment and will be available online.

Learn to effectively plan, implement, and control projects using Microsoft Project 2019/Office 365. This course will help you master the basics to create and share a project schedule, track costs and resources, produce reports, and resolve problems to keep your projects on track.

Overview of Microsoft Project

Microsoft Project can help you manage your project's schedule, costs, and scope in a way that you've never dreamed of. Too often, Project users never use this powerful tool to its fullest potential. In this lesson, you'll discover how to improve your project by adopting a formal management approach. You'll get a quick overview of Project Management, and then you'll learn the basics of Microsoft Project, including a summary of the Gantt Chart view and ways to create and enter project tasks.

Creating a Solid Foundation

If you're looking for ways to keep organized, you'll see just how to do that in this lesson! You'll go through the steps to create a project schedule in no time flat. Once you create and enter tasks in Project's Gantt Chart view, you'll set a schedule by using a calendar and assigning lead times. Then, you'll need to create task dependencies, sometimes known as links. You'll see how to perform these activities and, in the process, you'll become comfortable using Project's many dialog boxes. Before you know it, you'll be creating schedules for all your projects with little effort.

Creating and Managing Resources

You won't get too far with your project without adding resources. While tasks create the backbone of your project, you'll also need people, equipment, and materials to bring your project to life. In this lesson, you'll find out how to apply two types of Project resources—work resources, and material resources. You'll look at two more dialog boxes—Resource Information and Assign Resources—and you'll learn how to analyze resources by using the Resource Sheet and Resource Usage views.

Defining and Assigning Costs

No matter what project you work on, the bottom line is always important. So, get ready to add the final piece to your basic project schedule—costs. You'll start things off by looking through a brief overview of cost accounting, exploring fixed, variable, relevant, and accrued costs. After this review, you'll learn how to assign costs by using the Resource Sheet. You'll even discover how to assign different costs for the same resource and analyze the overall costs for your project by using the Cost Table.

Project Templates, Security, and Constraints

Successful project managers are known for their efficiency and for safeguarding private information. Microsoft Project provides two excellent methods to help you in these areas: project templates and project security. You'll find out how to use some of the many templates Project has to offer, including the Residential Construction template and the New Product template. You'll also learn how to protect your project information with backups, passwords, and write protection. Then you'll discover how to put Project's task constraints to good use.

Working With Views and Managing Information

In this lesson, you'll discover how easy it is to modify your basic schedules and work with project data. You'll look at the various Project views, such as the Calendar, Leveling Gantt, and the Network Diagram. If you don't like the default colors or fonts in your schedule or table, you'll be well-prepared to make changes. You'll even learn how and why you might want to create a combination view; add notes to your project; or sort, filter, and group data.

Fine-Tuning Your Project Plan

Many projects experience schedule compression when management or clients ask that the project be completed sooner and for less. In this lesson, you'll discover how to improve your schedule's performance. You'll explore the Project Statistics dialog box, and you'll learn how to determine the ideal starting point in terms of planned costs and completion dates. You'll see how to change task dependencies to speed up your project and also find out how to split tasks to add more lead time. You'll also learn how to create recurring tasks and attach notes to your project's taskbars.

Baselines and Tracking

Before you implement your project, you need to create a baseline. This will help you track actual results against what you originally set out to accomplish. Microsoft Project makes it possible to set up a baseline with a few mouse clicks. You'll learn how to create a baseline and then see a variety of ways, including using the Tracking toolbar, to record your actual project results.

Managing Variances

Here's where things really start to come together! You'll learn how to compare actual results to your baseline by using the Gantt Chart and reviewing a table. You'll discover how useful status identifiers and progress lines can be to quickly gain information about your project's position. You'll also begin using the Tracking Gantt and filters to automatically identify slipping tasks. You'll also take a stroll through the basics of variance analysis by discussing the Start and Finish Date, Resources, and Work Variance Tables.

Closing Your Project

No project is complete until it's officially closed. In this final lesson, you'll find out how to close your project and use the Organizer to help you customize and copy views for future projects.

Printing Views

Now that you're using reports to share project information, you'll occasionally need to print various views and tables. In this lesson, you'll delve into printing Microsoft Project documents. You'll be a master at creating different views of your project with the Page Setup dialog box, and you'll clearly understand the mechanics of the Print dialog box and the Print Preview.

Using and Creating Reports

Once your project gets rolling, outsiders will probably want to know how things are going. It can be a real time drain answering each request individually. When others request information from you, Microsoft Project offers the perfect solution: Reports. You'll go over a representative sample of the standard reports as well as discuss how to modify and create new reports in this lesson. By the time you finish, you'll be well acquainted with Project's reporting capabilities and also know how to create Visual Reports as Project automatically exports data to Microsoft Excel and Visio.

What you will learn

• Effective planning, implementation, and control projects using Microsoft Project
• How to enhance your project in the areas of efficiency and security
• The importance of setting a project baseline and tracking actual results
• Generate several standard project reports and a wide variety of visual project reports

How you will benefit

• Know how to the use of the world's most popular project management software
• Gain transferable skills
• Replace informal project plans with plans based on logic and structures reflective

Tony Swaim has helped many clients, colleagues, and students reach their professional and personal goals. He has been an online instructor since 1998 and has taught at colleges and universities across the United States since 1981. His focus areas are project management, Six Sigma, and supply chain management. Tony manages a successful consulting firm, and his industry experience includes 20 years of supply chain management. He earned a Doctorate in Business Administration from Kennesaw State University and holds professional certifications in six disciplines, including the Project Management Professional (PMP)® certification from the Project Management Institute (PMI)® and Certified Six Sigma Black Belt (CSSBB)® from the American Society for Quality (ASQ)®.

Learn to create your own newsletters, calendars, brochures, greeting cards, and more with Publisher, the desktop publishing app included in the Microsoft 365 suite. 

Desktop publishing is not just for design professionals! Microsoft Publisher puts desktop publishing within everyone’s reach, with easy-to-use templates and designs that help you create dozens of different publication types, including greeting cards, banners, flyers, and booklets. Best of all, if you have a Microsoft 365 subscription on a Windows PC, Publisher is available at no extra cost.

The online Introduction to Microsoft Publisher course teaches you how to use Microsoft Publisher through a series of engaging and useful projects. With each project, you not only learn about a new publication type, but you also build a set of core application skills that will carry through to your own future projects, no matter what type of publication you need. By course completion, you will know how to create a brochure, design business cards, and much more!

Requirements:

Hardware Requirements:

This course can be taken on either a PC, Mac, or Chromebook device.

Software Requirements:

• PC: Windows 10 or later operating systems.
• Mac: OS 10.6 or later.
• Browser: The latest version of Google Chrome or Mozilla Firefox is preferred. Microsoft Edge and Safari are also compatible.
• Microsoft Office 365 suite with Publisher (not included)
• Microsoft Word Online
• Adobe Acrobat Reader
• Software must be installed and fully operational before the course begins.

Other:

• Email capabilities and access to a personal email account.

Instructional Material Requirements:

The instructional materials required for this course are included in enrollment and will be available online.

Ready to get creative? With Microsoft Publisher, anyone can master desktop publishing. Through dozens of hands-on exercises, you will create newsletters, calendars, greeting cards, brochures, and many other publications you can use for business, clubs, schools, and more. 

Learning Your Way Around Publisher

New to Microsoft Publisher? This lesson provides a gentle, no-experience-required introduction. You will learn how Publisher compares to other apps, such as word processors like Word and higher-end desktop publication programs like Adobe InDesign. You will find out how to create, save, close, and open publication files, and how to get around in the Publisher interface. You will also create your first publication here, and in the process, you will learn about color schemes and font schemes.

Creating a Simple Publication

This lesson introduces some fundamental skills that will apply to almost every publication you will create going forward, including business information sets, text boxes, pictures, and shapes. You will start out by using a template to create a flyer that contains text and graphics, and then change its template and its content. Then you will create an award certificate that contains text and drawn shapes, and you will learn how to stack and group objects.

Creating a Publication from Scratch

Templates are great, but sometimes it is easier to start with a blank slate. In this lesson, you will learn how to create blank publications of various sizes, and how to insert and delete pages in them. You will also get a closer look at how text boxes work, and practice creating, resizing, and moving text boxes, as well as formatting the text within them. You will also learn how to add borders and shading to a text box and adjust its margins and padding.

Creating a Publication using Imported Content

You might sometimes have content created in a different application that you want to use in Publisher. No problem! In this lesson you will learn how to import text from a variety of sources. You will find out how to clear any old formatting from the imported text, and how to make text flow seamlessly from one text box to another. Pictures are another type of content you might want to import, and in this lesson, you will learn how to import a picture and then format it in various ways, including moving and resizing it, applying a border, and applying filters, effects, and color corrections that can improve the picture's original appearance. You will also find out how to control the relationship between text and graphics when they overlap.

Sharing a Publication

What do we create publications for, if not for sharing them with people? In this lesson you will learn all about printing your publications, as well as how to save publications in other digital formats such as PDF and HTML. Then you will learn how to send a publication via an email message in several different ways, including attaching the publication as a PDF or XPS file and sending a publication in the body of a message.

Creating Publications of Different Sizes

Not all publications fit neatly on a standard letter-size sheet of paper. This lesson focuses on three different kinds of publications that all break the size mold in different ways. First you will create a business card and learn about layout options that enable you to print multiple copies per sheet of paper (or cardstock). Then you will learn how to create large banners in Publisher and then either have them professionally printed or piece together a makeshift banner using multiple sheets of paper and a roll of tape. Finally, you will learn how to create advertisements for print publications using whatever size you need to fit the publication's requirements.

Creating Folded Publications

In this lesson, you will learn about three kinds of publications that have one thing in common: they are designed to be folded. You will first create a trifold brochure and discover how to make a brochure layout without interfering with the folds. Then you will plan and create a greeting card (and save yourself a fortune in buying store-bought cards!) Finally, you will create a booklet and learn about setting up mirrored pages and adding headers and footers.

Creating a Newsletter

This lesson is devoted to a single project: a newsletter. You will discover some common newsletter elements and learn how to plan for double-sided printing. Then you will flow text between pages and create notations that help readers find the second part of a story that starts on page 1. Finally, you will learn how to add pictures, design access, and page parts, and how to print a double-sided newsletter using an ordinary home printer that prints on only one side of the paper at once.

Ensuring Consistency

Publisher includes several features that help you make sure your work stays consistently formatted from page to page (and even between publications). You will start out by learning about master pages, which are page templates that help you repeat certain elements and positioning guides on every page of a multi-page publication. Next, you will learn about styles, which apply consistent character and paragraph formatting to text. You will also practice creating and using personal templates, which can be reusable models that can contain both master pages and styles. Finally, you will learn about building blocks, which are saved content snippets you can reuse over and over again.

Creating Magazines and Calendars

This lesson takes your design skills to the next level! You will plan and create a magazine cover that includes a full-page bleed, graphics, text boxes, and other elements. You will learn how to align objects precisely on a page, and how to control character spacing and kerning. Next, you will design a table of contents for a magazine, and in the process, you will learn about Publisher's Tables feature. Finally, you will learn how to create two kinds of calendars: a small one that's part of a larger publication, and a whole publication devoted to a multi-month calendar that you could have professionally printed.

Creating Mail-Merged Letters and Email

Mail merge. The name can sound intimidating, but it's really not that hard! In this lesson, you will create two kinds of mail mergers: a letter to be mailed and an email message to be sent electronically. You will learn about the elements of any mail merge, including a data file, a main document, and merge fields, and you will find out how to combine those elements to make a merge happen.

Creating Labels and Envelopes

In this final lesson, you will learn how to print envelopes and address labels, continuing your exploration of mail mergers. You will first create a single envelope and then expand it into a set of merged envelopes. Then you will first create a single self-stick label and print a whole sheet of the same one (for return-address labels), and then you will expand that into a mail-merged set of address labels for sending out cards or packages. Finally, you will put all your skills together and try out some projects that enable you to showcase what you have learned in the course.

What you will learn

• Create single-page publications like award certificates, flyers, and signs
• Make folded publications, including greeting cards and brochures
• Produce varied sizes of publications, from business cards to banners
• Design multi-page, two-sided publications like booklets, newsletters, and magazines
• Use mail merge to personalize each copy of a publication

How you will benefit

• Become the go-to desktop MS Publisher pro for your business, school, or organization
• Save money by designing and printing your own printed materials
• Express your creativity by creating original publication projects
• Open the door to new career opportunities or potential promotions 

Curt Simmons

Curt Simmons, B.A., M.Ed, is a best-selling author, trainer, and multi-media expert. He holds degrees in English and communication studies and has more than 10 years of experience teaching English and writing in the classroom. Additionally, Simmons has authored numerous books on a wide variety of technology topics and has been a technical editor for numerous other titles.

Learn to create your own newsletters, calendars, brochures, greeting cards, and more with Publisher, the desktop publishing app included in the Microsoft 365 suite. 

Desktop publishing is not just for design professionals! Microsoft Publisher puts desktop publishing within everyone’s reach, with easy-to-use templates and designs that help you create dozens of different publication types, including greeting cards, banners, flyers, and booklets. Best of all, if you have a Microsoft 365 subscription on a Windows PC, Publisher is available at no extra cost.

The online Introduction to Microsoft Publisher course teaches you how to use Microsoft Publisher through a series of engaging and useful projects. With each project, you not only learn about a new publication type, but you also build a set of core application skills that will carry through to your own future projects, no matter what type of publication you need. By course completion, you will know how to create a brochure, design business cards, and much more!

Requirements:

Hardware Requirements:

This course can be taken on either a PC, Mac, or Chromebook device.

Software Requirements:

• PC: Windows 10 or later operating systems.
• Mac: OS 10.6 or later.
• Browser: The latest version of Google Chrome or Mozilla Firefox is preferred. Microsoft Edge and Safari are also compatible.
• Microsoft Office 365 suite with Publisher (not included)
• Microsoft Word Online
• Adobe Acrobat Reader
• Software must be installed and fully operational before the course begins.

Other:

• Email capabilities and access to a personal email account.

Instructional Material Requirements:

The instructional materials required for this course are included in enrollment and will be available online.

Ready to get creative? With Microsoft Publisher, anyone can master desktop publishing. Through dozens of hands-on exercises, you will create newsletters, calendars, greeting cards, brochures, and many other publications you can use for business, clubs, schools, and more. 

Learning Your Way Around Publisher

New to Microsoft Publisher? This lesson provides a gentle, no-experience-required introduction. You will learn how Publisher compares to other apps, such as word processors like Word and higher-end desktop publication programs like Adobe InDesign. You will find out how to create, save, close, and open publication files, and how to get around in the Publisher interface. You will also create your first publication here, and in the process, you will learn about color schemes and font schemes.

Creating a Simple Publication

This lesson introduces some fundamental skills that will apply to almost every publication you will create going forward, including business information sets, text boxes, pictures, and shapes. You will start out by using a template to create a flyer that contains text and graphics, and then change its template and its content. Then you will create an award certificate that contains text and drawn shapes, and you will learn how to stack and group objects.

Creating a Publication from Scratch

Templates are great, but sometimes it is easier to start with a blank slate. In this lesson, you will learn how to create blank publications of various sizes, and how to insert and delete pages in them. You will also get a closer look at how text boxes work, and practice creating, resizing, and moving text boxes, as well as formatting the text within them. You will also learn how to add borders and shading to a text box and adjust its margins and padding.

Creating a Publication using Imported Content

You might sometimes have content created in a different application that you want to use in Publisher. No problem! In this lesson you will learn how to import text from a variety of sources. You will find out how to clear any old formatting from the imported text, and how to make text flow seamlessly from one text box to another. Pictures are another type of content you might want to import, and in this lesson, you will learn how to import a picture and then format it in various ways, including moving and resizing it, applying a border, and applying filters, effects, and color corrections that can improve the picture's original appearance. You will also find out how to control the relationship between text and graphics when they overlap.

Sharing a Publication

What do we create publications for, if not for sharing them with people? In this lesson you will learn all about printing your publications, as well as how to save publications in other digital formats such as PDF and HTML. Then you will learn how to send a publication via an email message in several different ways, including attaching the publication as a PDF or XPS file and sending a publication in the body of a message.

Creating Publications of Different Sizes

Not all publications fit neatly on a standard letter-size sheet of paper. This lesson focuses on three different kinds of publications that all break the size mold in different ways. First you will create a business card and learn about layout options that enable you to print multiple copies per sheet of paper (or cardstock). Then you will learn how to create large banners in Publisher and then either have them professionally printed or piece together a makeshift banner using multiple sheets of paper and a roll of tape. Finally, you will learn how to create advertisements for print publications using whatever size you need to fit the publication's requirements.

Creating Folded Publications

In this lesson, you will learn about three kinds of publications that have one thing in common: they are designed to be folded. You will first create a trifold brochure and discover how to make a brochure layout without interfering with the folds. Then you will plan and create a greeting card (and save yourself a fortune in buying store-bought cards!) Finally, you will create a booklet and learn about setting up mirrored pages and adding headers and footers.

Creating a Newsletter

This lesson is devoted to a single project: a newsletter. You will discover some common newsletter elements and learn how to plan for double-sided printing. Then you will flow text between pages and create notations that help readers find the second part of a story that starts on page 1. Finally, you will learn how to add pictures, design access, and page parts, and how to print a double-sided newsletter using an ordinary home printer that prints on only one side of the paper at once.

Ensuring Consistency

Publisher includes several features that help you make sure your work stays consistently formatted from page to page (and even between publications). You will start out by learning about master pages, which are page templates that help you repeat certain elements and positioning guides on every page of a multi-page publication. Next, you will learn about styles, which apply consistent character and paragraph formatting to text. You will also practice creating and using personal templates, which can be reusable models that can contain both master pages and styles. Finally, you will learn about building blocks, which are saved content snippets you can reuse over and over again.

Creating Magazines and Calendars

This lesson takes your design skills to the next level! You will plan and create a magazine cover that includes a full-page bleed, graphics, text boxes, and other elements. You will learn how to align objects precisely on a page, and how to control character spacing and kerning. Next, you will design a table of contents for a magazine, and in the process, you will learn about Publisher's Tables feature. Finally, you will learn how to create two kinds of calendars: a small one that's part of a larger publication, and a whole publication devoted to a multi-month calendar that you could have professionally printed.

Creating Mail-Merged Letters and Email

Mail merge. The name can sound intimidating, but it's really not that hard! In this lesson, you will create two kinds of mail mergers: a letter to be mailed and an email message to be sent electronically. You will learn about the elements of any mail merge, including a data file, a main document, and merge fields, and you will find out how to combine those elements to make a merge happen.

Creating Labels and Envelopes

In this final lesson, you will learn how to print envelopes and address labels, continuing your exploration of mail mergers. You will first create a single envelope and then expand it into a set of merged envelopes. Then you will first create a single self-stick label and print a whole sheet of the same one (for return-address labels), and then you will expand that into a mail-merged set of address labels for sending out cards or packages. Finally, you will put all your skills together and try out some projects that enable you to showcase what you have learned in the course.

What you will learn

• Create single-page publications like award certificates, flyers, and signs
• Make folded publications, including greeting cards and brochures
• Produce varied sizes of publications, from business cards to banners
• Design multi-page, two-sided publications like booklets, newsletters, and magazines
• Use mail merge to personalize each copy of a publication

How you will benefit

• Become the go-to desktop MS Publisher pro for your business, school, or organization
• Save money by designing and printing your own printed materials
• Express your creativity by creating original publication projects
• Open the door to new career opportunities or potential promotions 

Curt Simmons

Curt Simmons, B.A., M.Ed, is a best-selling author, trainer, and multi-media expert. He holds degrees in English and communication studies and has more than 10 years of experience teaching English and writing in the classroom. Additionally, Simmons has authored numerous books on a wide variety of technology topics and has been a technical editor for numerous other titles.

Learn how the foundational skills needed to utilize Microsoft Word 2019 in Office 365. This course will teach you how to create professional-looking letters, reports, and documents.

Across all industries, the ability to create documents in a word processor is essential in day-to-day functions. From writing reports to Knowing how to use Microsoft Word, the most widely-used word processing program, adds an important skill set to your professional profile.

This course will introduce you to the 2019 version of Microsoft Word, available with the Microsoft 365 platform. You will learn the basics of Word 2019 needed to write and edit text and to create, format, and organize documents. By the time you're done with these hands-on activities, you will be able to use Word confidently at home or on the job.

Requirements:

Hardware Requirements:

• This course must be taken on a PC. Macs and Chromebooks are not compatible.

Software Requirements:

• PC: Windows 10 or later.
• Browser: The latest version of Google Chrome or Mozilla Firefox is preferred. Microsoft Edge is also compatible.
• Microsoft Word 2019 (desktop version) available with the desktop version of Microsoft 365, or Microsoft Office Home and Student 2019 (not included in enrollment)
• Adobe Acrobat Reader.
• Software must be installed and fully operational before the course begins.

Other:

• Email capabilities and access to a personal email account.

Instructional Material Requirements:

The instructional materials required for this course are included in enrollment and will be available online.

Learn to create professional-looking letters, reports, and documents using Microsoft Word 2019/Office 365. This hands-on course will help you master the basic features of this powerful word-processing program to type, edit, and format text, and spell check and print documents like a pro.

Getting Started

In this introductory lesson, you'll learn how to use the different parts of Word 2019's user interface, how to look at your document in different types of views, how to zoom in and out to magnify or shrink your text, and how to change the margins of individual paragraphs.

Typing and Navigation

The whole purpose of Word is to let you create and edit text, so in this lesson, you'll go over the basics of moving the Insertion Pointer, or Cursor, and deleting text. Pressing the BACKSPACE and DELETE keys can delete text one character at a time. The keyboard lets you move the cursor one character, one word, or one line at a time. The mouse lets you quickly move the cursor and scroll through large documents far faster than the keyboard. By knowing the pros and cons of navigating through a document with the keyboard and mouse, you can use both to help you work faster in Word.

File Management

In this lesson, you're going to learn how to save the documents you create in Word. You'll learn how to save documents with unique names, as well as in other formats so that you can share your documents with people using different word processors or even different computers. Finally, you'll learn how to rename, copy, and even delete any files you've created so that you'll always be in complete control of all the files you create.

Editing Text

After you've typed some text in a Word document, you may need to edit that text. The easiest way to edit is to delete individual characters using the BACKSPACE or DELETE keys. Another option is using Word's Overtype mode by typing over text you no longer need. If you ever delete anything by mistake, don't panic! Word's handy Undo and Redo commands retrieve unintentionally deleted text. You may also want to delete large chunks of text. Use your keyboard or mouse in tandem with the BACKSPACE or DELETE keys to efficiently remove entire sections of text. By learning how to delete text and undo mistakes, you can edit your documents quickly using Word.

Working With Multiple Documents

Most people use Word to view and edit a single document at a time, but Word actually lets you open and view two or more documents at the same time. This can be handy for copying text from one document to another, comparing two different drafts of the same document, or simply using one document as a reference while writing in the second one. By learning how to open, switch between, and view multiple documents, you can increase your productivity with Word.

Text Formatting and Alignment

Once you know how to add, delete, copy, and move text, the next step to modifying your document is to change the physical appearance of your text. You can make text appear in different colors or background highlighting, change the actual size of text, alter the alignment of text, and even choose different fonts to modify the way individual letters look. As you can see, Word provides plenty of ways to help you both edit text and change it so it looks visually appealing.

Printing

Most people use Word to print letters and reports. But Word also helps you get creative by letting you choose different paper sizes and orientations. For example, you can print a letter in portrait orientation or print a sign in landscape orientation. Just think of turning a page up so its height is taller than its width (portrait orientation) or turning the page on its side so its width is wider than its height (landscape orientation). Word also lets you choose to print on different paper sizes, such as envelopes, just as long as you can run those odd-shaped paper sheets in your printer. With Word's ability to print on different types of paper sizes and orientation, you can create more than just typical documents using Word.

Margins, Tabs, and Page Numbering

Most of the time when you create a document, you can use the default page settings. But sometimes you may want to modify those settings to change margins around a page to give you more (or less) space on the top, bottom, left, or right sides of a page. By knowing how to set and use margins, you can modify an entire document or just a single page. By using tabs, you can modify how individual paragraphs look on a page. Finally, you'll also learn how to add page numbers to the top or bottom of a page to keep track of the right page order when you print out your document.

Paragraph Formatting

Word can be handy for typing and formatting text, but once you've written several paragraphs worth of text, you may need to format individual paragraphs separately from the rest of your document. Word provides ways to change the appearance of a paragraph's first line, line spacing within a paragraph, and line spacing between paragraphs. In addition, Word lets you create bullet and numbered lists, so you can display short bits of information in a visual manner. With Word's various paragraph-formatting options, you can customize the appearance of all your paragraphs.

Language Tools

It's not enough just to write and format your text. After you're done writing, you may need to check your spelling, change your words, and even hyphenate your text to make your entire document look the best it can. For important documents, you may even need to collaborate with others. To keep track of all the changes multiple authors may make to a single document, Word offers a Track Changes feature, so you can see exactly what and who changed the document. With so many ways to polish your document, there's no reason not to write exactly what you want to say with Word.

Customizing Word

Word can easily handle any characters you type with a keyboard, but sometimes you may need to type an occasional foreign language character, a mathematical symbol, or another unusual character that doesn't appear on your keyboard. With Word, you can press different types of keystrokes or search and click the symbol you want to use. This lets you add practically any type of unusual character to your documents, even smiley faces. You probably won't need to type all of these characters regularly, so just find the ones you'll likely need and remember how to use them. Word lets you type practically anything you want, regardless of the limitation of the keys on your keyboard.

Making a Word Document Pretty and Organized

Writing involves more than just typing and editing text. With Word's advanced features, you can insert page breaks and cover pages to adjust how your text appears when you print it out. To make text on each page look its best, you can use drop caps and styles. Finally, you can use outlines to organize your text and quickly move chunks of text within a document just by rearranging an outline heading. By learning these advanced features of Word, you can make each document display text in the most appealing way possible.

What you will learn

• Fundamentals of one of the most crucial software applications in the modern workplace
• Skills and tools needed to adjust margins, spacing, layout, and design of any Word document
• How to work on multiple projects at once and become faster and more efficient in a variety of Microsoft Word tasks
• Techniques for modifying the appearance of your documents in order to suit your needs

How you will benefit

• Gain the confidence needed to make the most of this indispensable software application
• Learn how to make the perfect layout for useful documents of any occasion - resumes, invitations, letters, articles, training materials, and much more
• Save time and avoid frustration by familiarizing yourself with the wide variety of tools at your disposal in Word 2019
• Become more proficient with one of the most widely used software programs in history

Wallace Wang is the author of over 40 computer books including "Microsoft Office 2019 For Dummies." In addition to writing computer books, he has also co-authored "Breaking Into Acting for Dummies" and ghost written several books about investing in real estate, day trading stocks, and becoming an entrepreneur. Some of his past jobs have included teaching computer science courses at the University of Zimbabwe, performing stand-up comedy, and appearing on a weekly radio show.

Learn how the foundational skills needed to utilize Microsoft Word 2019 in Office 365. This course will teach you how to create professional-looking letters, reports, and documents.

Across all industries, the ability to create documents in a word processor is essential in day-to-day functions. From writing reports to Knowing how to use Microsoft Word, the most widely-used word processing program, adds an important skill set to your professional profile.

This course will introduce you to the 2019 version of Microsoft Word, available with the Microsoft 365 platform. You will learn the basics of Word 2019 needed to write and edit text and to create, format, and organize documents. By the time you're done with these hands-on activities, you will be able to use Word confidently at home or on the job.

Requirements:

Hardware Requirements:

• This course must be taken on a PC. Macs and Chromebooks are not compatible.

Software Requirements:

• PC: Windows 10 or later.
• Browser: The latest version of Google Chrome or Mozilla Firefox is preferred. Microsoft Edge is also compatible.
• Microsoft Word 2019 (desktop version) available with the desktop version of Microsoft 365, or Microsoft Office Home and Student 2019 (not included in enrollment)
• Adobe Acrobat Reader.
• Software must be installed and fully operational before the course begins.

Other:

• Email capabilities and access to a personal email account.

Instructional Material Requirements:

The instructional materials required for this course are included in enrollment and will be available online.

Learn to create professional-looking letters, reports, and documents using Microsoft Word 2019/Office 365. This hands-on course will help you master the basic features of this powerful word-processing program to type, edit, and format text, and spell check and print documents like a pro.

Getting Started

In this introductory lesson, you'll learn how to use the different parts of Word 2019's user interface, how to look at your document in different types of views, how to zoom in and out to magnify or shrink your text, and how to change the margins of individual paragraphs.

Typing and Navigation

The whole purpose of Word is to let you create and edit text, so in this lesson, you'll go over the basics of moving the Insertion Pointer, or Cursor, and deleting text. Pressing the BACKSPACE and DELETE keys can delete text one character at a time. The keyboard lets you move the cursor one character, one word, or one line at a time. The mouse lets you quickly move the cursor and scroll through large documents far faster than the keyboard. By knowing the pros and cons of navigating through a document with the keyboard and mouse, you can use both to help you work faster in Word.

File Management

In this lesson, you're going to learn how to save the documents you create in Word. You'll learn how to save documents with unique names, as well as in other formats so that you can share your documents with people using different word processors or even different computers. Finally, you'll learn how to rename, copy, and even delete any files you've created so that you'll always be in complete control of all the files you create.

Editing Text

After you've typed some text in a Word document, you may need to edit that text. The easiest way to edit is to delete individual characters using the BACKSPACE or DELETE keys. Another option is using Word's Overtype mode by typing over text you no longer need. If you ever delete anything by mistake, don't panic! Word's handy Undo and Redo commands retrieve unintentionally deleted text. You may also want to delete large chunks of text. Use your keyboard or mouse in tandem with the BACKSPACE or DELETE keys to efficiently remove entire sections of text. By learning how to delete text and undo mistakes, you can edit your documents quickly using Word.

Working With Multiple Documents

Most people use Word to view and edit a single document at a time, but Word actually lets you open and view two or more documents at the same time. This can be handy for copying text from one document to another, comparing two different drafts of the same document, or simply using one document as a reference while writing in the second one. By learning how to open, switch between, and view multiple documents, you can increase your productivity with Word.

Text Formatting and Alignment

Once you know how to add, delete, copy, and move text, the next step to modifying your document is to change the physical appearance of your text. You can make text appear in different colors or background highlighting, change the actual size of text, alter the alignment of text, and even choose different fonts to modify the way individual letters look. As you can see, Word provides plenty of ways to help you both edit text and change it so it looks visually appealing.

Printing

Most people use Word to print letters and reports. But Word also helps you get creative by letting you choose different paper sizes and orientations. For example, you can print a letter in portrait orientation or print a sign in landscape orientation. Just think of turning a page up so its height is taller than its width (portrait orientation) or turning the page on its side so its width is wider than its height (landscape orientation). Word also lets you choose to print on different paper sizes, such as envelopes, just as long as you can run those odd-shaped paper sheets in your printer. With Word's ability to print on different types of paper sizes and orientation, you can create more than just typical documents using Word.

Margins, Tabs, and Page Numbering

Most of the time when you create a document, you can use the default page settings. But sometimes you may want to modify those settings to change margins around a page to give you more (or less) space on the top, bottom, left, or right sides of a page. By knowing how to set and use margins, you can modify an entire document or just a single page. By using tabs, you can modify how individual paragraphs look on a page. Finally, you'll also learn how to add page numbers to the top or bottom of a page to keep track of the right page order when you print out your document.

Paragraph Formatting

Word can be handy for typing and formatting text, but once you've written several paragraphs worth of text, you may need to format individual paragraphs separately from the rest of your document. Word provides ways to change the appearance of a paragraph's first line, line spacing within a paragraph, and line spacing between paragraphs. In addition, Word lets you create bullet and numbered lists, so you can display short bits of information in a visual manner. With Word's various paragraph-formatting options, you can customize the appearance of all your paragraphs.

Language Tools

It's not enough just to write and format your text. After you're done writing, you may need to check your spelling, change your words, and even hyphenate your text to make your entire document look the best it can. For important documents, you may even need to collaborate with others. To keep track of all the changes multiple authors may make to a single document, Word offers a Track Changes feature, so you can see exactly what and who changed the document. With so many ways to polish your document, there's no reason not to write exactly what you want to say with Word.

Customizing Word

Word can easily handle any characters you type with a keyboard, but sometimes you may need to type an occasional foreign language character, a mathematical symbol, or another unusual character that doesn't appear on your keyboard. With Word, you can press different types of keystrokes or search and click the symbol you want to use. This lets you add practically any type of unusual character to your documents, even smiley faces. You probably won't need to type all of these characters regularly, so just find the ones you'll likely need and remember how to use them. Word lets you type practically anything you want, regardless of the limitation of the keys on your keyboard.

Making a Word Document Pretty and Organized

Writing involves more than just typing and editing text. With Word's advanced features, you can insert page breaks and cover pages to adjust how your text appears when you print it out. To make text on each page look its best, you can use drop caps and styles. Finally, you can use outlines to organize your text and quickly move chunks of text within a document just by rearranging an outline heading. By learning these advanced features of Word, you can make each document display text in the most appealing way possible.

What you will learn

• Fundamentals of one of the most crucial software applications in the modern workplace
• Skills and tools needed to adjust margins, spacing, layout, and design of any Word document
• How to work on multiple projects at once and become faster and more efficient in a variety of Microsoft Word tasks
• Techniques for modifying the appearance of your documents in order to suit your needs

How you will benefit

• Gain the confidence needed to make the most of this indispensable software application
• Learn how to make the perfect layout for useful documents of any occasion - resumes, invitations, letters, articles, training materials, and much more
• Save time and avoid frustration by familiarizing yourself with the wide variety of tools at your disposal in Word 2019
• Become more proficient with one of the most widely used software programs in history

Wallace Wang is the author of over 40 computer books including "Microsoft Office 2019 For Dummies." In addition to writing computer books, he has also co-authored "Breaking Into Acting for Dummies" and ghost written several books about investing in real estate, day trading stocks, and becoming an entrepreneur. Some of his past jobs have included teaching computer science courses at the University of Zimbabwe, performing stand-up comedy, and appearing on a weekly radio show.

Learn to use this powerful new operating system, including how to customize your desktop, manage files and folders, and navigate the web with the new Microsoft Edge browser.

Welcome to Windows 10, the completely new operating system from Microsoft, which offers a more robust, more powerful, and completely unique computing experience. In this course, you will gain the foundation you need to get started right away using Windows 10.

File Explorer can help you manage your files and create basic text documents using WordPad. From managing files and editing photos to working with external drives, you will learn everything you need to know about getting the most from this operating system. Additionally, since security is important, you will also learn how to protect your files and how to protect and update Windows 10.

By the time you finish this course, you will have mastered the basic skills you need to get the most from Windows 10 for both work and play.

Requirements:

Hardware Requirements:

• This course must be taken on a PC. Macs are not compatible.

Software Requirements:

• PC: Windows 10 or later.
• Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge is also compatible.
• Adobe Acrobat Reader.
• Software must be installed and fully operational before the course begins.

Other:

• Email capabilities and access to a personal email account.

Instructional Material Requirements:

The instructional materials required for this course are included in enrollment and will be available online.

Master the basic skills you need to get the most from Windows 10 for both work and play. This course will help you learn to use this powerful new operating system, including customizing your desktop, managing files and folders, and navigating the web with the new Microsoft Edge browser.

Getting Started

Learn the basics that every computer user must know in order to use a computer with minimal frustration followed by the most important skills and terminology that allow you to control what you see on your screen at all times. Then, explore the revised Start Menu and Apps in Windows 10.

Use the Start Menu and Apps

This lesson explores the revised Start Menu and Apps in Windows 10. You will explore the Windows Store and learn how to customize the Start Menu.

Personalizing Your Windows Desktop

In this lesson, you will have fun personalizing your computer by choosing your own desktop pictures, window colors, and sound scheme. The skills you learn in this lesson will go a long way to helping you gain complete control of your computer.

Working With Text and Files

No matter how you intend to use your computer, there will be times when there's some typing involved. It might be for writing email messages, memos, or letters, or it might be for taking notes in a course, or for chatting with others on a website. Whatever the reason, this lesson will teach you all the tricks for making typing quick and easy.

Exploring Your System

Everything that's in your computer is stored on its hard drive. The hard drive is like a filing cabinet containing files organized into folders. Finding files that you have saved is a matter of opening the filing cabinet, so to speak, and then locating the correct folder. In this lesson, you will learn how it all works.

Using OneDrive and Cortana

In this lesson, you will explore two Windows 10 features: OneDrive and Cortana. OneDrive is a cloud storage solution that lets you store files and folders both on your PC as well as the Microsoft cloud. Cortana is Microsoft's personal digital assistant that can help find files, folders, apps, and settings on your PC as well as information on the Internet.

Manage and Edit Your Photos

In this lesson, you will learn how to organize your photos and view them using Windows 10's Photos App. You will see how to view individual photos, draw and rotate, and auto-enhance your shots. You will also learn about the Photos App editing tools for adjusting brightness and contrast, cropping, and more.

Using Edge

It's likely that you have seen references to .com sites in ads and elsewhere. This lesson introduces Edge, the program that provides access to websites like Facebook, Twitter, Google, and many others.

Managing Files and Folders

This lesson will explore managing files and folders. In many work and school environments, people just assume you know how to manage files, and they rarely provide any details on copying, moving, or renaming files and folders.

More Fun With File Management

In this lesson, you will expand your file management skills by learning how to delete and recover files. You will learn how to select multiple files to work with, so you don't always have to manage your files one at a time.

Protect Your Valuable Files

This lesson is all about using the tools and techniques built into Windows to help you protect your valuable files. Your computer is an investment of money, and the pictures and other files you store on your computer are an investment of time.

Tips, Tricks, and Shortcuts

In your final lesson, you will learn some more techniques for protecting your computer, including using resources for free protection from viruses and spyware. You will learn how to remove programs you no longer want or need and discover some great timesaving tips and shortcuts to help you make the most out of Windows 10.

What you will learn

• Find your way around Windows 10 with the desktop, Start menu, and system settings
• Learn to customize features and personalize your desktop
• Discover how File Explorer can help you manage files and learn to create basic text documents using WordPad
• Learn how to protect your files and update Windows 10

How you will benefit

• Gain confidence in your use of the Windows 10 operating system for personal and business use
• Learn how to use your PC effectively, starting with Windows
• Experience reduced frustration and setbacks by learning to operating your computer properly
• Become a more independent computer user

Curt Simmons, B.A., M.Ed, is a best-selling author, trainer, and multi-media expert. He holds degrees in English and communication studies and has more than 10 years of experience teaching English and writing in the classroom. Additionally, Simmons has authored numerous books on a wide variety of technology topics and has been a technical editor for numerous other titles.

Learn to use this powerful new operating system, including how to customize your desktop, manage files and folders, and navigate the web with the new Microsoft Edge browser.

Welcome to Windows 10, the completely new operating system from Microsoft, which offers a more robust, more powerful, and completely unique computing experience. In this course, you will gain the foundation you need to get started right away using Windows 10.

File Explorer can help you manage your files and create basic text documents using WordPad. From managing files and editing photos to working with external drives, you will learn everything you need to know about getting the most from this operating system. Additionally, since security is important, you will also learn how to protect your files and how to protect and update Windows 10.

By the time you finish this course, you will have mastered the basic skills you need to get the most from Windows 10 for both work and play.

Requirements:

Hardware Requirements:

• This course must be taken on a PC. Macs are not compatible.

Software Requirements:

• PC: Windows 10 or later.
• Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge is also compatible.
• Adobe Acrobat Reader.
• Software must be installed and fully operational before the course begins.

Other:

• Email capabilities and access to a personal email account.

Instructional Material Requirements:

The instructional materials required for this course are included in enrollment and will be available online.

Master the basic skills you need to get the most from Windows 10 for both work and play. This course will help you learn to use this powerful new operating system, including customizing your desktop, managing files and folders, and navigating the web with the new Microsoft Edge browser.

Getting Started

Learn the basics that every computer user must know in order to use a computer with minimal frustration followed by the most important skills and terminology that allow you to control what you see on your screen at all times. Then, explore the revised Start Menu and Apps in Windows 10.

Use the Start Menu and Apps

This lesson explores the revised Start Menu and Apps in Windows 10. You will explore the Windows Store and learn how to customize the Start Menu.

Personalizing Your Windows Desktop

In this lesson, you will have fun personalizing your computer by choosing your own desktop pictures, window colors, and sound scheme. The skills you learn in this lesson will go a long way to helping you gain complete control of your computer.

Working With Text and Files

No matter how you intend to use your computer, there will be times when there's some typing involved. It might be for writing email messages, memos, or letters, or it might be for taking notes in a course, or for chatting with others on a website. Whatever the reason, this lesson will teach you all the tricks for making typing quick and easy.

Exploring Your System

Everything that's in your computer is stored on its hard drive. The hard drive is like a filing cabinet containing files organized into folders. Finding files that you have saved is a matter of opening the filing cabinet, so to speak, and then locating the correct folder. In this lesson, you will learn how it all works.

Using OneDrive and Cortana

In this lesson, you will explore two Windows 10 features: OneDrive and Cortana. OneDrive is a cloud storage solution that lets you store files and folders both on your PC as well as the Microsoft cloud. Cortana is Microsoft's personal digital assistant that can help find files, folders, apps, and settings on your PC as well as information on the Internet.

Manage and Edit Your Photos

In this lesson, you will learn how to organize your photos and view them using Windows 10's Photos App. You will see how to view individual photos, draw and rotate, and auto-enhance your shots. You will also learn about the Photos App editing tools for adjusting brightness and contrast, cropping, and more.

Using Edge

It's likely that you have seen references to .com sites in ads and elsewhere. This lesson introduces Edge, the program that provides access to websites like Facebook, Twitter, Google, and many others.

Managing Files and Folders

This lesson will explore managing files and folders. In many work and school environments, people just assume you know how to manage files, and they rarely provide any details on copying, moving, or renaming files and folders.

More Fun With File Management

In this lesson, you will expand your file management skills by learning how to delete and recover files. You will learn how to select multiple files to work with, so you don't always have to manage your files one at a time.

Protect Your Valuable Files

This lesson is all about using the tools and techniques built into Windows to help you protect your valuable files. Your computer is an investment of money, and the pictures and other files you store on your computer are an investment of time.

Tips, Tricks, and Shortcuts

In your final lesson, you will learn some more techniques for protecting your computer, including using resources for free protection from viruses and spyware. You will learn how to remove programs you no longer want or need and discover some great timesaving tips and shortcuts to help you make the most out of Windows 10.

What you will learn

• Find your way around Windows 10 with the desktop, Start menu, and system settings
• Learn to customize features and personalize your desktop
• Discover how File Explorer can help you manage files and learn to create basic text documents using WordPad
• Learn how to protect your files and update Windows 10

How you will benefit

• Gain confidence in your use of the Windows 10 operating system for personal and business use
• Learn how to use your PC effectively, starting with Windows
• Experience reduced frustration and setbacks by learning to operating your computer properly
• Become a more independent computer user

Curt Simmons, B.A., M.Ed, is a best-selling author, trainer, and multi-media expert. He holds degrees in English and communication studies and has more than 10 years of experience teaching English and writing in the classroom. Additionally, Simmons has authored numerous books on a wide variety of technology topics and has been a technical editor for numerous other titles.