Microsoft   

Master advanced features and functions of Microsoft Excel 2016, including data analysis tools, data tables and databases, PivotTables, custom controls, importing external data, and conditional formatting.

Wouldn't it be great to learn how to effectively use all the advanced Excel features? In this practical and information-packed Microsoft Excel training, you'll see how to truly maximize this program's functions and capabilities. After all, most organizations rely heavily on Excel to consolidate, analyze, and report data and want their employees to be proficient in this important program. This Excel training class gives you the skills you need to impress your current or future employer—and its online format means you can take this class from anywhere, at any time.

With exercises, quizzes, expert instructors, and all the latest information, the best online Excel training is right here at ed2go. We'll simplify some of those tricky Excel concepts that might seem hard to grasp, so you can discover how Excel 2016 table tools actually take the complexity out of spreadsheet creation and management. When you've completed this course, you'll be able to accomplish just about everything Microsoft Excel has to offer in displaying, analyzing, reporting, and tracking data—and you'll understand it so well, you'll even be able to share your newfound skills with your friends and colleagues.

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 (not included in enrollment).
• Note that the "Starter Version" and "Web App" versions of Microsoft Excel will not work with the full version of Excel 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.

1. Customizing Excel
2. Table Management
3. Data Validation
4. Custom Controls
5. Conditional Formatting
6. Consolidating and Outlining
7. Excel Functions and Nesting
8. Import External Data
9. Data Tables
10. What-If Analysis Tools
11. Advanced PivotTables
12. Analysis ToolPak, Advanced Filter, Array Formulas, and More!

This hands-on course will teach you Microsoft Excel 2019's advanced functions and often-overlooked features, including data analysis tools, data tables and databases, custom controls, and PivotTables.

Across industries, most organizations use Microsoft Excel to consolidate, analyze, and report financial information and other important data. If you work with data of any kind, learning Excel's advanced functions strengthens your professional portfolio.

The Advanced Microsoft Excel 2019 course will teach you Excel's advanced functions, which most users don't know exist. You will learn how to use formula-based conditional formatting as a creative solution to common issues. You will also learn how to leverage Excel's Power Query tool to import and transform data from any data source.

By course completion, you will be an expert in Microsoft Excel 2019.

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.

Customizing Excel

To kick things off, your first lesson explores different ways you can modify Excel to streamline processes and make your work easier. You will use the Excel Options dialog box to customize some of Excel's behind-the-scenes behavior and set up your Quick Access Toolbar.

Table Management

This lesson explores Excel's table management features, using data forms with Excel databases, and alternative database techniques. You will be glad to know that formatting and working with tables has gotten much easier in this latest version of Excel.

Data Validation

In this lesson, you will tackle data validation techniques—your first line of defense against incorrect or missing data and the logical next step after data forms. You will practice using whole number, decimal, date, time, list, and other forms of validation.

Custom Controls

This lesson will introduce you to custom controls—graphical objects that help facilitate data input and are sure to impress users. You will learn how to create standard and drop-down list boxes, check boxes, option buttons, and group boxes.

Conditional Formatting

This lesson will teach you how to use conditional formatting. You will learn how to use conditional formatting to hide errors, to highlight records based on multiple criteria, to track and alert you about due dates, to find the differences between two lists, to shade every other row, and more.

Consolidating and Outlining

In this lesson, you will learn how to use Excel's consolidation function to efficiently summarize data from multiple sources. Many Excel users do this the hard way, but with Excel's automatic consolidation feature, you will no longer need to develop a web of formula links to multiple sources.

Excel Functions and Nesting

Excel's functions are too numerous to cover in just one lesson, so this lesson focuses on a few important ones spanning four categories: Logical, Database, Math & Trig, and Lookup & Reference.

Import External Data

This lesson focuses on importing external data. You will learn how to use the built-in Query Editor using Excel's powerful Power Query tool and import external database that combines two database tables into a single import.

Data Tables

Data tables are very powerful what-if analysis tools that are great for analyzing potential outcomes of personal or business financial decisions. In this lesson, you will learn how to use two different types of data tables.

What-If Analysis Tools

This lesson explores three more of Excel's what-if analysis tools: Goal Seek, Scenario Manager, and Solver.

Advanced PivotTables

In this lesson, you will discover how to use PivotTables, which are excellent for summarizing massive amounts of data and viewing different cuts of the information quickly. There are two methods for creating PivotTables, and you will practice using both.

Analysis ToolPak, Advanced Filter, Array Formulas, and More!

Your final lesson with a look at the functions available in the Analysis ToolPak, including Moving Average and Sampling tools. You will learn how to use the View Side by Side tool and how to use the Watch Window to keep tabs on your data when you're updating a workbook.

You will learn to manage Azure subscriptions and resources, implement and manage storage, deploy and manage virtual machines (VMs), configure and manage virtual networks, and manage identities.

Requirements:

Hardware Requirements:

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

Software Requirements:

• PC: Windows 8 or later.
• Mac: macOS 10.6 or later.
• Browser: The latest version of Google Chrome or Mozilla Firefox is preferred. Microsoft Edge and Safari are also compatible.
• 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.

The Microsoft Azure Administrator course is intended for those who are either looking to gain more knowledge about administering Azure cloud services, security, networking, and compute cloud abilities or who are looking to pass the AZ-104 exam and complete their Microsoft Certified: Azure Administrator certification.

You will learn to Implement access management with Azure users, groups, and role-based access control. This is in addition to creating Windows virtual machines in the Azure Portal, with Azure PowerShell, or using ARM Templates. You will also implement Azure Active Directory, Self-Service Password Reset, Azure AD Identity Protection, and integrated SaaS applications, understand virtual networking components, IP addressing, network routing options, and much more.

Furthermore, you will learn to use Azure Monitor to configure Azure alerts and review the Azure Activity Log, explain virtual machine usage cases, storage options, pricing, operating systems, networking capabilities, and general planning considerations. You will also discover how to optimize your use of Azure tools like the Azure portal, Azure PowerShell, Cloud Shell, and the Azure CLI.

By course completion, you will have the AZ-104 training needed to sit for the AZ-104: Microsoft Azure Administrator Exam. This course offers enrollment with a voucher. The voucher is prepaid access to sit for the certifying exam upon eligibility.

1. Azure Subscriptions, Resources & Billing
2. Azure Policies
3. Azure Users & Groups
4. Azure Logging & Monitoring
5. Azure Resource Management
6. Azure User & Groups
7. Azure Logging & Monitoring
8. Azure Resource Management
9. Azure Storage Accounts & Types
10. Azure Virtual Machines
11. Shared Access Signature, backup & File
12. Deploy & Manage Virtual Machines
13. Azure Containers
14. Configure & Manage Victual Networks
15. Manage Identities

What you will learn

• Query and analyze Log Analytics data
• Deploy resources with ARM templates and organize Azure resources
• Create Azure storage accounts for different data replication, pricing, and content scenarios
• Implement virtual machine storage, blob storage, Azure files, and structured storage
• Secure and manage storage with shared access keys, Azure backup, and Azure File Sync
• Store and access data using Azure Content Delivery Network, and the Import and Export service
• Deploy custom server images and Linux virtual machines
• Configure virtual machine networking and storage options
• Implement virtual machine high availability, scalability, and custom scripts extensions
• Backup, restore, and monitor virtual machines
• Implement Azure DNS domains, zones, record types, and resolution methods
• Configure network security groups, service endpoints, logging, and network troubleshooting
• Implement site connectivity schemas, including VNet-to-VNet connections and virtual network peering
• Configure domains and tenants, users and groups, roles, and devices
• Implement and manage Azure Active Directory integration options and Azure AD Application Proxy
• Implement and configure Azure Load Balancer, Azure Traffic Manager, and Azure Application Gateway
• Use Azure RBAC to grant a granular level of access based on an administrator's assigned tasks
• Use Azure Multi-Factor Authentication to configure a strong authentication for users at sign-in

How you will benefit

• You will be prepared for the AZ-104: Microsoft Azure Administrator Exam
• Grow your IT career and open new job opportunities

Doug Bassett

Doug Bassett is an IT instructor specializing in Microsoft Azure, Server 2016/19, and Exchange messaging. He holds many highly sought-after IT certifications, including Microsoft MCSE, Microsoft MCSA, CompTIA Network+, Cisco CCNA, and Microsoft MCT. In addition to his certifications, Doug has expert knowledge of Microsoft Server 2000, 2003, 2008/2012/2016/2019, Exchange Server and Exchange Online, and Networking structure and applications. As an instructor, Doug is deeply involved in helping his students understand complex concepts and loves to approach teaching a subject from multiple angles.

This course is intended for Azure and Microsoft server security professionals and those who are looking to take and pass the AZ-500: Microsoft Azure Security Technologies exam.

Requirements:

Hardware Requirements:

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

Software Requirements:

• PC: Windows 8 or later.
• Mac: macOS 10.6 or later.
• Browser: The latest version of Google Chrome or Mozilla Firefox is preferred. Microsoft Edge and Safari are also compatible.
• 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.

Take the next step towards getting your Azure security certification. In this online training course, you will gain the knowledge and skills needed to implement security controls, maintain the security posture, and identify and remediate vulnerabilities by using a variety of security tools. This course also covers scripting and automation, virtualization, and cloud N-tier architecture while you study for the AZ-500 certification.

By course completion, you will be prepared to sit for the AZ-500: Microsoft Azure Security Technologies Exam. This course offers enrollment with a voucher. The voucher is prepaid access to sit for the certifying exam upon eligibility.

1. Azure AD Identities
2. Securing Access
3. Securing Application Access
4. Access Control
5. Network Security
6. Azure Security Center
7. Azure Containers
8. Azure Vulnerability
9. Security Operations
10. Secure Applications & Data

What you will learn

• Describe specialized data classifications on Azure
• Identify Azure data protection mechanisms
• Implement Azure data encryption methods
• Secure Internet protocols and how to implement them on Azure
• Describe Azure security services and features

How you will benefit

• You will be prepared for the AZ-500: Microsoft Azure Security Technologies Exam
• Grow your IT career and open new job opportunities

Doug Bassett

Doug Bassett is an IT instructor specializing in Microsoft Azure, Server 2016/19, and Exchange messaging. He holds many highly sought-after IT certifications, including Microsoft MCSE, Microsoft MCSA, CompTIA Network+, Cisco CCNA, and Microsoft MCT. In addition to his certifications, Doug has expert knowledge of Microsoft Server 2000, 2003, 2008/2012/2016/2019, Exchange Server and Exchange Online, and Networking structure and applications. As an instructor, Doug is deeply involved in helping his students understand complex concepts and loves to approach teaching a subject from multiple angles.

You will learn foundational level knowledge on cloud concepts; core Microsoft Azure services; security, privacy, compliance, and trust; and Azure pricing and support. You will also learn to manage Azure subscriptions and resources, implement and manage storage, deploy and manage virtual machines (VMs), configure and manage virtual networks, and manage identities.

Requirements:

Hardware Requirements:

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

Software Requirements:

• PC: Windows 8 or later.
• Mac: macOS 10.6 or later.
• Browser: The latest version of Google Chrome or Mozilla Firefox is preferred. Microsoft Edge and Safari are also compatible.
• 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.

This comprehensive course bundle is designed to provide you with the Microsoft Azure training needed to take your career to the next level. Optimize your use of Azure tools, learn virtual machine (VM) storage and implement best practices, understand related essential functions and components, and much more, all on your own time.

The Microsoft Azure Fundamentals course is intended for entry-level Azure professionals and builds the groundwork needed to properly administer and subscribe to Microsoft Azure. From networking and cloud concepts to Azure workloads, security, privacy, and more, you will master the training needed to take your career to the next level. By course completion, you will be prepared to sit for the AZ-900 exam and achieve your Microsoft Certified: Azure Fundamentals certification.

The Microsoft Azure Administrator course is intended for those who are either looking to gain more knowledge about administering Azure cloud services, security, networking, and compute cloud abilities or who are looking to pass the AZ-104 exam and complete their Microsoft Certified: Azure Administrator certification. Whatever your motivation, this course will help you become an Azure admin pro in six months or less!

The course will also prepare you to sit for the AZ-900: Microsoft Azure Fundamentals and the AZ-104: Microsoft Azure Administrator Exams. This course offers enrollment with vouchers. The vouchers are prepaid access to sit for the certifying exam upon eligibility.

1. Microsoft Azure Fundamentals
1. Using Cloud Services
2. Differences between IaaS, PaaS, and SaaS
3. Differences Between Public, Private, and Hybrid Clouds
4. Core Azure Architecture Components
5. Core Products Available and Subscriptions in Azure
6. Azure Management and Monitoring Tools
7. Securing Network Connectivity in Azure
8. Core Azure Identity Services
9. Security Tools and Features of Azure
10. Azure Governance Methodologies
11. Conditional Access
12. Using Profiles
13. Privacy Standards
14. Azure Service Level Agreements (SLAs)
15. Mobile Application Management (MDM)
16. Windows Defender Tools
2. Microsoft Azure Administrator
1. Azure Subscriptions, Resources & Billing
2. Azure Policies
3. Azure Users & Groups
4. Azure Logging & Monitoring
5. Azure Resource Management
6. Azure User & Groups
7. Azure Logging & Monitoring
8. Azure Resource Management
9. Azure Storage Accounts & Types
10. Azure Virtual Machines
11. Shared Access Signature, backup & File
12. Deploy & Manage Virtual Machines
13. Azure Containers
14. Configure & Manage Victual Networks
15. Manage Identities

What you will learn

• Understand Azure workloads and subscriptions
• Security and privacy in Azure
• Implement access management with Azure users, groups, and role-based access control
• Use Azure Monitor to configure Azure alerts and review the Azure Activity Log
• Query and analyze Log Analytics data
• Deploy resources with ARM templates and organize Azure resources
• Store and access data using Azure Content Delivery Network, and the Import and Export service
• Deploy custom server images and Linux virtual machines
• Implement Azure DNS domains, zones, record types, and resolution methods
• Implement site connectivity schemas including VNet-to-VNet connections and virtual network peering
• Implement Azure Active Directory, Self-Service Password Reset, Azure AD Identity Protection, and integrated SaaS applications
• Configure domains and tenants, users and groups, roles, and devices
• Implement and manage Azure Active Directory integration options and Azure AD Application Proxy
• Implement and configure Azure Load Balancer, Azure Traffic Manager, and Azure Application Gateway
• Use Azure RBAC to grant a granular level of access based on an administrator's assigned tasks
• Use Azure Multi-Factor Authentication to configure a strong authentication for users at sign-in

How you will benefit

• You will be prepared for the AZ-900: Microsoft Azure Fundamentals and AZ-104: Microsoft Azure Administrator Exams
• Learn key concepts, applications, and skills that can help broaden your career working with cloud-based solutions and services

Will Panek

Will Panek is a worldwide recognized Microsoft instructor and author. Will is a 5-time Microsoft MVP and has published over 30 titles on Microsoft technologies. Will is a passionate and authoritative instructor and makes sure that his students can implement Microsoft technologies and get themselves certified along the way. Outside the class and authorship, you'd be likely to find Will at the forge smithing his latest creation.

Doug Bassett

Doug Bassett is an IT instructor specializing in Microsoft Azure, Server 2016/19, and Exchange messaging. He holds many highly sought-after IT certifications, including Microsoft MCSE, Microsoft MCSA, CompTIA Network+, Cisco CCNA, and Microsoft MCT. In addition to his certifications, Doug has expert knowledge of Microsoft Server 2000, 2003, 2008/2012/2016/2019, Exchange Server and Exchange Online, and Networking structure and applications. As an instructor, Doug is deeply involved in helping his students understand complex concepts and loves to approach teaching a subject from multiple angles.

You will learn foundational level knowledge on cloud concepts; core Microsoft Azure services; security, privacy, compliance, and trust; and Azure pricing and support. You will also learn to manage Azure subscriptions and resources, implement and manage storage, deploy and manage virtual machines (VMs), configure and manage virtual networks, and manage identities.

Requirements:

Hardware Requirements:

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

Software Requirements:

• PC: Windows 8 or later.
• Mac: macOS 10.6 or later.
• Browser: The latest version of Google Chrome or Mozilla Firefox is preferred. Microsoft Edge and Safari are also compatible.
• 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.

The Microsoft Azure Fundamentals course is intended for entry-level Azure professionals and builds the groundwork needed for you to properly administer and subscribe to Microsoft Azure. From networking and cloud concepts to Azure workloads, cloud security, privacy, and more, you will master the training needed to take your career to the next level. By course completion, you will be prepared to achieve your Microsoft Azure certification.

The Microsoft Azure Security Technologies course will help you gain the knowledge and skills needed to implement security controls, maintain the security posture, and identify and remediate vulnerabilities by using a variety of security tools. This course also covers scripting and automation, virtualization, and cloud N-tier architecture. Upon completion, you will have the fundamental knowledge required of a Microsoft cloud app security professional.

The course will also prepare you to sit for the AZ-900: Microsoft Azure Fundamentals and the AZ-500: Microsoft Azure Security Technologies Exams. This course offers enrollment with vouchers. The vouchers are prepaid access to sit for the certifying exam upon eligibility.

1. Microsoft Azure Fundamentals
   1. Using Cloud Services
   2. Differences between IaaS, PaaS, and SaaS
   3. Differences Between Public, Private, and Hybrid Clouds
   4. Core Azure Architecture Components
   5. Core Products Available and Subscriptions in Azure
   6. Azure Management and Monitoring Tools
   7. Securing Network Connectivity in Azure
   8. Core Azure Identity Services
   9. Security Tools and Features of Azure
   10. Azure Governance Methodologies
   11. Conditional Access
   12. Using Profiles
   13. Privacy Standards
   14. Azure Service Level Agreements (SLAs)
   15. Mobile Application Management (MDM)
   16. Windows Defender Tools
2. Microsoft Azure Security Technologies
1. Azure AD Identities
2. Securing Access
3. Securing Application Access
4. Access Control
5. Network Security
6. Azure Security Center
7. Azure Containers
8. Azure Vulnerability
9. Security Operations
10. Secure Applications & Data

What you will learn

• Concepts of onsite networking
• Cloud and cloud-based networking concepts
• Azure workloads, security, and subscriptions
• Concepts of hybrid networking
• Azure application support
• How to manage and monitor Azure Services
• Describe specialized data classifications on Azure
• Identify Azure data protection mechanisms
• Implement Azure data encryption methods
• Secure Internet protocols and how to implement them on Azure

How you will benefit

• You will be prepared for the AZ-900: Microsoft Azure Fundamentals and AZ-500: Microsoft Azure Security Technologies Exams
• Expand your career opportunities as an IT professional

Will Panek

Will Panek is a worldwide recognized Microsoft instructor and author. Will is a 5-time Microsoft MVP and has published over 30 titles on Microsoft technologies. Will is a passionate and authoritative instructor and makes sure that his students can implement Microsoft technologies and get themselves certified along the way. Outside the class and authorship, you'd be likely to find Will at the forge smithing his latest creation.

Doug Bassett

Doug Bassett is an IT instructor specializing in Microsoft Azure, Server 2016/19, and Exchange messaging. He holds many highly sought-after IT certifications, including Microsoft MCSE, Microsoft MCSA, CompTIA Network+, Cisco CCNA, and Microsoft MCT. In addition to his certifications, Doug has expert knowledge of Microsoft Server 2000, 2003, 2008/2012/2016/2019, Exchange Server and Exchange Online, and Networking structure and applications. As an instructor, Doug is deeply involved in helping his students understand complex concepts and loves to approach teaching a subject from multiple angles.

You will learn foundational level knowledge on cloud concepts; core Microsoft Azure services; security, privacy, compliance, and trust; and Azure pricing and support.

Requirements:

Hardware Requirements:

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

Software Requirements:

• PC: Windows 8 or later.
• Mac: macOS 10.6 or later.
• Browser: The latest version of Google Chrome or Mozilla Firefox is preferred. Microsoft Edge and Safari are also compatible.
• 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.

The Microsoft Azure Fundamentals course is intended for entry-level Azure professionals and builds the groundwork needed to properly administer and subscribe to Microsoft Azure. From networking and cloud concepts to Azure workloads, security, privacy, and more, you will master the training needed to take your career to the next level. By course completion, you will be prepared to achieve your Microsoft Azure certification.

The course will also prepare you to sit for the AZ-900: Microsoft Azure Fundamentals Exam. This course offers enrollment with a voucher. The voucher is prepaid access to sit for the certifying exam upon eligibility.

1. Onsite Networking
2. Benefits and Considerations of Using Cloud Services
3. Differences between IaaS, PaaS, and SaaS
4. Differences Between Public, Private, and Hybrid Clouds
5. Core Azure Architecture Components
6. Core Products Available and Subscriptions in Azure
7. Azure Management and Monitoring Tools
8. Securing Network Connectivity in Azure
9. Core Azure Identity Services
10. Security Tools and Features of Azure
11. Azure Governance Methodologies
12. Conditional Access
13. Using Profiles
14. Privacy Standards
15. Azure Service Level Agreements (SLAs)
16. Mobile Application Management (MDM)
17. Windows Defender Tools

What you will learn

• Concepts of onsite networking
• Cloud concepts
• Concepts of cloud-based networking
• Azure workloads
• Security and privacy in Azure
• Azure subscriptions
• Concepts of hybrid networking
• Azure application support
• How to manage and monitor Azure Services

How you will benefit

• You will be prepared for the AZ-900: Microsoft Azure Fundamentals Exam
• Increase your career opportunities as an IT professional

Will Panek

Will Panek is a worldwide recognized Microsoft instructor and author. Will Panek is a 5-time Microsoft MVP and has published over 30 titles on Microsoft technologies. Will is a passionate and authoritative instructor and makes sure that his students can implement Microsoft technologies and get themselves certified along the way. Outside the class and authorship, you'd be likely to find Will at the forge smithing his latest creation.

This hands-on course will teach you how to use Microsoft Access 2019 efficiently and effectively. You will learn how to manage databases and advance your understanding of this powerful software.

As one of the most widely-used information management systems, Microsoft Access helps many organizations streamline their database needs. This hands-on course will help you master the powerful database software as you build an entire database project from scratch.

Intermediate Microsoft Access 2019 will teach you advanced techniques for using Access, including importing Excel spreadsheets as tables, creating query calculations to crunch numbers, and using Visual Basic to automate common tasks. By course completion, you will know the most effective way to build and present reports with Access. This course is appropriate for Access versions 2019, 2021 and 365.

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, 2021 and Office 365 desktop (not included in enrollment). Available to download with a subscription to Microsoft 365, or with Microsoft Office Professional. Microsoft Access 2016 is also acceptable. Please note: There may be some differences between your version of Access and what you see in the course.
• Adobe Acrobat Reader.

Other:

• Email capabilities and access to a personal email account.
• Software must be installed and fully operational before the course begins.

Instructional Material Requirements:

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

Reviewing Terms and Importing Data

In this first lesson, we'll review Access key concepts and terminology. You'll also learn how to import or share, data between Access and other applications without retyping. The objects you import in this lesson will be the basis of a project that we'll work on for the rest of the course.

Key Fields and Action Queries

You'll learn how to set up key fields in tables, plus you'll use action queries to quickly and easily manipulate multiple-table records with one command.

Relationships of the Database Kind

What are table relationships? And what does referential integrity mean? It's time to find out how and why to use these features.

Creating and Modifying Forms

Forms are the user-friendly gateway to Access table data. In this lesson, you'll learn how to create and modify forms and make them easy to use.

Subforms and the Tab Control

In this lesson, you'll learn how to add a subform to the main form without the wizard, and you'll use the Tab control to arrange form data.

Queries

You've already learned to put data into your database in an efficient way. In this lesson, you'll learn about query joins and data functions. These tools will help you get timely, high-quality data out of your database, so you see all the data you want and none of the data you don't want.

Query Calculations

Suppose your boss tells you, "I want a list of the customers who placed the most orders and a separate list of the customers who spent the most overall." How can you find these answers quickly and accurately? Access comes to your rescue again! In this lesson, you'll explore Access functions, crunch numbers with the best of them, and even design a mathematical formula of your own. And don't worry if math makes you nervous . . . I'll walk you through every step!

Summary Queries

In this lesson, you'll build powerful, fast summary queries that total, count, or average the values in a set of records. You'll also discover the power of the crosstab query, which can not only summarize data but also rearrange it so that it becomes easier to understand. Finally, you'll add query parameters that allow you to change a query's criteria without altering its design.

Building Reports That Pinpoint Key Information

Today you'll use the Report Wizard to build a basic report. Then you'll fine-tune what you've built, and I'll share some tips and tricks I've developed after building thousands of Access reports. Finally, you'll learn about a fantastic tool—conditional formatting, which allows you to visually identify key report data. With a few clicks, your report will change from a mass of numbers to a map of trends and changes that affect your business.

Run Reports from a Custom Dialog Box

Just about every time you run a report, you'll want to limit the data it displays. You might want to see only a certain customer or a particular month and year. In this lesson, you'll build a dialog box that allows the user to run reports based on custom-built criteria.

Using Visual Basic to Automate the Reports Dialog Box

Visual Basic is a powerful programming language that allows database developers to automate simple and complex tasks. In this lesson, you'll learn a little bit about Visual Basic, using it to make the reports dialog box you built earlier fully functional.

Putting It All Together

If you're creating a database for others, you must make it easy to use—and as you may remember, Access can look intimidating to a newbie! In this lesson, you'll build a navigation form that directs users to the forms and reports they need. You'll also set up a database for shared use and modify the start-up options.

Master more advanced techniques for this powerful database program, including importing Excel spreadsheets as tables, creating query calculations to crunch numbers, and using Visual Basic to automate common tasks.

Do you want to take your Microsoft Access skills to the next level? In this course, you'll master more advanced techniques for this powerful database program and build an entire database project from scratch.

From building reports to using conditional formatting, you'll see how to present your data and gain techniques for using Visual Basic to automate common tasks. Finally, you'll build a navigation form to make it easy for your users to find their way around your database. By the time you've completed the course, you'll have a fully functional database that tracks customer and order information.

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 Access 2016 (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.

1. Reviewing Terms and Importing Data
2. Key Fields and Action Queries
3. Relationships of the Database Kind
4. Creating and Modifying Forms
5. Subforms and the Tab Control
6. Queries
7. Query Calculations
8. Summary Queries
9. Building Reports That Pinpoint Key Information
10. Run Reports From a Custom Dialog Box
11. Using Visual Basic to Automate the Reports Dialog Box
12. Putting It All Together

Take your Microsoft Excel 2016 skills to the next level as you master charts, graphs, PivotTables, Slicers, Sparklines, AutoFilter, macros, and other advanced Excel functions.

In this hands-on course, you will learn how to create informative, eye-catching charts and graphs, and harness the power of Excel's data analysis tools and AutoFilter commands. In addition, you will find out how easy it is to create macros that let you manipulate data with the push of a button. You will also discover how to use Goal Seek and Solver and apply them to real-world problems. Set yourself apart from the casual Excel user by adding VLOOKUP, INDEX & MATCH, and other time-saving functions to your repertoire.

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 (not included in enrollment).
• Note that the "Starter Version" and "Web App" versions of Microsoft Excel will not work with the full version of Excel 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.

Excel Charts and Graphs

In your first lesson, you will discover why Excel 2016 is such a powerful charting tool. To you, a workbook's numbers might tell an interesting story; to others, that story may not be obvious. You will learn how to choose the right chart for your story and then how to create, format, and edit your chart.

More Excel Charts

This lesson continues exploring Excel's charting options—this time looking at the lesser-known options that are available to you. Even though they may not be well-known, these options can add tremendous value to your worksheets in the right situations.

AutoFilter and Sorting

Working with data in Excel can be quite easy when you know about the tools that are available in a table format. One of these great tools is the Auto Filter command. This lesson will teach you how to use Auto Filter to limit your table information to just the records you want.

Goal Seeking

If you know what formulas you want but don't know how to get there, Excel's Goal Seek is exactly what you need. In this lesson, you will learn how to utilize this tool to avoid the trial-and-error approach that most Excel users go through to get to the right answer.

PivotTables

This lesson will teach you how to use one of the best features of Excel: the PivotTable. There's no greater "what-if" analysis tool to summarize, reorganize, and report data.

Advanced PivotTables

Just like charting, Excel's PivotTables are too big a topic to fit into one lesson. This lesson takes a tour through some of Excel's more advanced techniques, like the PivotTable filtering tool Slicer. You will also learn how a PivotTable can serve as your source for the PivotChart.

Solver

Have you ever worked with a financial model in Excel and wondered how you could speculate different outcomes by changing different input amounts? The Excel Solver can do just that. In this lesson, you will learn how to use Solver to solve a complex problem based on criteria and constraints.

Sparklines

There's nothing more exciting than learning how to master a new feature in Excel. This lesson focuses on creating three types of Sparklines, as well as formatting options for each. By the end of the lesson, you will have the skills to create dashboard-style mini charts.

Macros

In this lesson, you will find out how to use macros to turn repetitive and often time-consuming tasks into automated Excel functions. You will also learn how to record a macro that performs time-consuming task in seconds with the click of a button.

Introduction to Functions

If you have used Excel for a while, you know there are hundreds of functions at your disposal. The last three lessons of this course will cover how and why you would use these functions. This lesson introduces creating various functions with the Text category.

Math/Trig Functions

Next to learning how to create macros, most students want to learn as much as they can about Excel functions. This lesson covers on more complex functions of the "Math & Trig" category, focusing on the SUMIF and COUNTIF functions in particular.

VLOOKUP, INDEX, and MATCH Functions

Since functions are such an integral part of using Excel, your final lesson will cover advanced features. In this lesson, you will learn how to use the VLOOKUP, INDEX, and MATCH functions.

This self-paced course will bring your Microsoft Excel skills to the next level. You will learn how to use several powerful features in this long-standing spreadsheet software.

Microsoft Excel is considered the industry standard for spreadsheets, providing organizations will an easy-to-use solution for managing budgets, scheduling, tracking, and more. This course will teach you the software's often-overlooked features and functions.

You will learn how to harness the power of Excel's data analysis tools and AutoFilter commands and how to create macros that eliminate repetitive tasks. You will also add VLOOKUP, INDEX & MATCH, and other intermediate functions to your professional skill set.

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 (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 Excel will not work with the full version of Excel 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.

Excel Charts and Graphs

In this first lesson, you'll discover why Excel is such a powerful and user-friendly charting tool. To you, a workbook's numbers might tell an interesting story. But to others, that story might not be quite so obvious—they might just see plain old numbers. So, today, you'll find out how to choose the right chart for telling your story and then how to create, format, and edit your chart to help others clearly visualize that story.

More Excel Charts

There are so many great charting features and enhancements in Excel 2019, there's no way we could cover all of them in a single lesson. So, today, we'll continue exploring Excel's charting options—this time looking at the lesser-known options that are available to you. Even though they aren't well-known, these options can add tremendous value to your worksheets in the right situations. We'll walk through a few of them step-by-step, so you'll see the value for yourself.

AutoFilter and Sorting

Working with data in Excel can be quite easy—and sometimes even fun—when you know about the extra tools that are available once you have your data arranged in a table format. One of these great tools is the Auto Filter command. In today's lesson, you'll learn how to use Auto Filter to limit your table information to just the records you want. Not only does Auto Filter allow for finding exact matches, but it can also filter and sort based on cell shading or font color. How great is that?

Goal Seeking

Normally, you'll use your Excel workbooks as a place to enter formulas and get answers. But what if the formula isn't returning the answer you want? If you know what you want, but you just don't know what formula will get you there, then Excel's Goal Seek is exactly what you need. This tool will help you avoid the trial-and-error approach that most Excel users go through to get to the right answer. In this lesson, we'll walk through multiple examples together, exploring several ways to apply this great feature.

PivotTables

Today, you'll learn how to use one of the best features of Excel: the PivotTable. If you've heard about PivotTables before, then you know what I mean. There's no greater what-if analysis tool to summarize, reorganize, and report data. When we practice creating a PivotTable, you'll discover how "pivoting" your data helps you gain valuable insights by seeing the same information from a different perspective. This is a lesson you won't want to miss!

Advanced PivotTables

Just like charting, Excel's PivotTables are too big a topic to fit into one lesson. So, today, we'll take PivotTables to the next level by taking a tour through some of Excel's more advanced techniques. You'll learn how quick and easy it is to group your data to give your PivotTable even more power. Then you'll find out how a PivotTable can serve as your source and inspiration for some really nice charts, specifically, the PivotChart. Last, you'll become an expert in using the Excel PivotTable filtering tool called Slicer.

Solver

Have you ever worked with a financial model in Excel and wondered how you could speculate different outcomes by changing different input amounts? The Excel Solver can do just that. In this lesson, you'll learn how to use Solver to solve a complex problem based on the criteria and constraints we provide it. If you liked the Goal Seek lesson, then this Solver lesson is going to knock your socks off.

Sparklines

There's nothing more exciting than learning how to master a useful and eye-catching feature in Excel. In today's lesson, we'll explore in detail how to create all three types of Sparklines, as well as formatting options for each. By the end of the lesson, you'll have the skills to create dashboard-like mini charts sure to make you the envy of your office. If you enjoy creating charts, you'll really enjoy this lesson.

Macros

Today's topic is a student (and instructor) favorite. In this lesson, you'll find out how to use macros to turn boring, repetitive, time-consuming tasks into automated Excel functions. Tired of doing the same formatting on the same report month after month? Here's your chance to see how to record a macro that performs that time-consuming task in seconds with just one swift click of a button! How will you spend all the extra time that this lesson will save you?

Introduction to Functions

If you've used Excel for a while, you know there are hundreds of functions at your disposal. We're going to spend the last three lessons of this course going over exactly how and why you'd use them. We'll start today by going through a quick overview of all the categories of functions and the different methods you can use to create them. Then, later in the lesson, we'll ease into creating various functions using some from the Text category.

Math/Trig Functions

Next to learning how to create macros, most students want to learn as much as they can about Excel functions. In today's lesson, we'll dig a little deeper into using some of the slightly more complex functions that you'll find in the Math & Trig category. Specifically, we'll look at two of my favorites, the SUMIF, and COUNTIF functions, and discuss how to use one of the more complex functions, SUMIFS. If one of your objectives in taking this course is to learn more about functions, you're in for a treat!

VLOOKUP, INDEX, and MATCH Functions

Since functions are such an important and integral part of using Excel, we'll spend our final lesson going over a few more of them. Today, you're going to learn how to use the extremely popular VLOOKUP function. If you're already accustomed to using VLOOKUP, don't feel short-changed, because we're going to add to the complexity. We're going to use the INDEX and MATCH functions to do something just short of amazing. This is another lesson you won't want to miss!

Learn how to use the more advanced features of Microsoft Word 2016 (now available through Office 365) including how to add graphics, use templates, and merge data.

Go beyond the basics of word processing and master the more advanced features of Microsoft Word 2016 (now available through Office 365). In this course, you'll learn how to automate Word 2016 using shortcuts to help you write more while typing less. From signs, newsletters, and greeting cards to long documents, you'll learn how to create whatever you need—quickly and with professional-looking results.

You'll also learn how to create and organize text in tables, mix graphics and text together to turn Word into a simple desktop publishing program, and merge spreadsheet and database data to create mailing labels and form letters. Along the way, you'll go through lots of examples and exercises so you can see how Word's advanced features work; but more importantly, you'll see how you can use these advanced features at home and on the job. By the end of this course, you'll know how to use Word more effectively and take advantage of all its many features so you can get your work done more quickly and more easily than you ever thought possible.

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 Word 2016 (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.

1. Shortcuts and Time-Savers in Word 2016
2. Text and Paragraph Formatting Methods
3. Templates
4. Graphics: Part 1
5. Graphics: Part 2, and Columns
6. Sections and Notes
7. Tables
8. Envelopes and Odd-Size Pages
9. Desktop Publishing: Part 1
10. Desktop Publishing: Part 2
11. Merging Data with Documents
12. Final Touches

This course will teach you intermediate techniques for Microsoft Word, the world's most popular word processing software. You will learn how to use Microsoft Word 2019's often overlooked functions such as desktop publishing and mail merging.

Most organization worldwide use Microsoft Word for their word processing needs. However, only a fraction of the software's features are used. This online self-paced course will teach you how to use Microsoft Word 2019's intermediate features.

You will learn how to create and modify boilerplate templates as well as several time-saving techniques, such as macros and keystroke shortcuts. By course completion, you will be able to create professional documents that demonstrate your intermediate knowledge of Microsoft Word 2019.

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

Timesavers in Word 2019

We've come a long way since the days of the typewriter. What used to take hours can now be done in seconds with Microsoft Word 2019. And the less time you spend typing, the more time you can spend being creative and having fun. In this lesson, you'll learn shortcuts in Word that can help you create documents faster and more accurately than ever before. Not only will these shortcuts save you time, but they'll help you create letters and reports more easily than you might have thought possible.

Methods to Streamline Text Formatting

What you write is half of communication. The other half is getting people to read what you write. One way to make your writing more appealing is to make it look presentable with formatting. Of course, formatting text is easy, but applying different types of formatting repeatedly can get tedious. In this lesson, you'll learn a fast and easy way to format chunks of text quickly and consistently using something called styles. You'll find out what a style is, how to apply it, and—more important—how to create and save your own styles to use in any document. By the end of this lesson, you'll be able to make any document look presentable with just the click of your mouse.

Working with Templates

A template stores the formatting of a document so that you can apply it to another document. Templates let you format entire documents as easily as formatting a single word. Word offers lots of convenient templates stored right on your computer or available over the Internet. In this lesson, you'll learn about how to search and use Word templates, and you'll also discover how you can create your own.

Adding Graphics to Your Word Documents

They say a picture is worth a thousand words, so what better way to spice up your documents than by adding pictures? In this lesson, you'll learn how to add your own digital photographs to a document so that you can show everyone your vacation pictures, family holidays, or just interesting sights you've captured with your own camera. In addition to adding your own photos, you can also add clip art from Word's massive library of free graphics. And you'll find out how to resize, rotate, and style your pictures, as well as wrap your document text around them. By the end of this lesson, you'll see why Word documents are about much more than words!

Creating Text-Based Graphics in Word

Digital photographs and clip art are just the beginning of what you can do with graphics in Word. In this lesson, you'll discover how to add a variety of informational graphics, including charts, graphs, and WordArt, which allows you to display text as a graphic image. Not only will you learn how to add these graphics, but you'll also find out how to edit them when your data changes. You'll finish off the lesson by seeing how Word allows us to format documents with multiple columns—a handy skill for creating newsletters and publications!

Organizing Your Text with Columns and Sections

Do you often create long documents? If so, you'll appreciate this lesson, which shows you how to divide a large document into parts called sections. Sections allow you to format part of a document a certain way without that formatting affecting the rest of your text. For example, you may want headers and footers to appear on some pages but not others. Sections make this easy! You'll also spend some time inserting footnotes and end-notes in a document. If you need to write research papers or other academic content, Word makes it a snap to add and format these previously pesky notes!

Creating Tables in Word

If you've ever seen a spreadsheet, you know how rows and columns let you organize numbers and text on the screen. Well, tables do the same thing in Word. In this lesson, you'll see how to create tables of all different sizes right in a Word document! You'll cover how to modify tables, too. And don't think Excel users get to have all the fun—you can even enter formulas to perform calculations in your tables, sort them, and style them for a customized look. Your data has never looked so appealing!

Creating Stationary in Word

You probably print most of your documents on standard letter-size paper. While this is great for ordinary letters or business reports, sometimes you may want to get creative with your paper sizes. But then there's the trouble of printing. In this lesson, you'll see how you can define the dimensions of the paper you're using, so Word will print everything correctly. You'll also learn how to print names and addresses directly on envelopes of any size. After this lesson, you won't feel confined to a boring 8 1/2 x 11-inch paper anymore!

Creating Business Stationary in Word

As you've probably already figured out, Word can do more than write letters. It can also function as a simple desktop publishing program for creating greeting cards, calendars, or newsletters. In this lesson, you'll find out how text boxes are the key to simple desktop publishing, and you'll see how other elements come into play in customized documents. Along the way, we'll look at business cards and greeting cards to get a feel for how desktop publishing works. If you've always wanted to create a document that combines text and graphics in an artistic or visually appealing way, you'll find out how to do that and much more.

Desktop Publishing

With the basics down, it's time to take your desktop publishing skills to the next level. In this lesson, you'll discover the magic of linked text boxes that give you the power to move your text anywhere you want on the page and keep it flowing. You'll see how to create, position, resize, and group text boxes so that you have total control over your text.

Merging Data with Documents

Did you ever get one of those "personalized" letters from a company in the mail? You can be sure that nobody typed the entire sales letter from scratch. Instead, the company used a form letter, and something called mail merging. In this lesson, you'll learn how to store long lists of names and addresses that you can reuse in a form letter. Just create a document once, leave blanks for inserting information such as names and addresses, and let Word personalize each letter for you. Now, you too can create personalized letters for business or personal use, such as sending out holiday greetings to family members and friends.

Creating Summative Lists of What's in Your Document

Look in most books, and you'll find a table of contents at the beginning and an index in the back. Often, these are the last components added to a document, since they need to have accurate titles and page numbers. Thankfully, Word takes a lot of the tedious work out of creating these components. In this final lesson, you'll see how you can use Styles to make creating a table of contents a snap, and you'll explore how to tag index terms so that Word knows what page they're on, even if they move later. Word can also help you keep track of any figures, such as charts, illustrations, or graphs, in your document. By letting Word worry about the details, you can create an accurate table of contents, index, or list of figures with very little extra effort on your part. These finishing touches will make your most important documents shine!

This online, self-paced course is perfect for beginners that want to learn how to use Microsoft Access. By course completion, you will know how to build a database and customize data storage.

Microsoft Access is a powerful tool for organizing, storing, and documenting their essential data. This program is used to organize data ranging from inventory and customer information to orders details. Learning how to use Access 2019 will add a valuable skill set to your professional profile.

Introduction to Microsoft Access 2019 will introduce you to the commonly used data management software and teach you how to use its basic functions. By course completion, you will know how to build a database with multiple tables, design effective data entry forms, and generate in-depth reports. This course is appropriate for Access versions 2019, 2021 and 365.

Requirements:

Hardware Requirements:

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

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, 2021 and Office 365 desktop (not included in enrollment). Available to download with a subscription to Microsoft 365, or with Microsoft Office Professional. Microsoft Access 2016 is also acceptable. 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 and will be available online.

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. We'll start by opening the application and creating a new database.

Controlling Your Access Table Fields

It's time to lay down the law! Today 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. Also, you'll 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-free.

Creating Tables and Relationships

Today you'll create additional tables for our class database, customizing 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 determine 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. You'll follow instructions step by step, so you gain confidence with the process. Then I'll turn you loose 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.

Learn to build, edit, and maintain a database in Microsoft Access 2016, complete with tables, reports, forms, macros, and queries to give you fast access to all your important information.

Take control of your data! In this course, you'll learn how to harness the power of Microsoft Access 2016 to organize, store, edit, manage, and report on hundreds of thousands of records.

Through easy-to-follow, step-by-step instructions, this course will help you master Access and put it to creative, confident use. You'll develop not only strong Access skills, but a solid understanding of good database design concepts. By the time you've finished the course, you'll know how to organize and assemble an effective database for any kind of information you need to store, document, and manage

Requirements:

Hardware Requirements:

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

Software Requirements:

• PC: Windows 8 or later.
• Mac: macOS 10.6 or later.
• Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge is also compatible.
• Microsoft Access 2016 (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.

1. Getting to Know Access 2016
2. Controlling Your Access Table Fields
3. Creating Tables and Relationships
4. Building Powerful Forms
5. Adding Versatility to Forms
6. Interviewing Your Database
7. Taking Queries to the Next Level
8. Multi-Table Query Control
9. Reporting on Your Tables
10. Creating Query-Based Reports
11. Mastering Report Design
12. Automating Your Database With Macros

Discover how to create worksheets, workbooks, charts, and graphs quickly and efficiently in Microsoft Excel 2016, now available through Office 365.

If you work with numbers, you need to master Microsoft Excel 2016! This hands-on course will teach you dozens of shortcuts and tricks for setting up fully-formatted worksheets quickly and efficiently. You will also learn the secrets behind writing powerful mathematical formulas and discover how to use the function wizard to quickly and automatically calculate statistics, loan payments, future value, and more.

In addition, you will get tips on sorting and analyzing data, designing custom charts and graphs, creating three-dimensional workbooks, building links between files, endowing your worksheets with decision-making capabilities, and automating frequently-repeated tasks with macros and buttons. You will also learn Excel 2016 features, including Quick Analysis, Flash Fill, and new charting capabilities.

This is not a tutorial, but an in-depth class developed by experienced Microsoft Excel instructor. By the time you're done, you will be using this vital Office 2016 application like a pro.

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 (not included in enrollment).
• Note that the "Starter Version" and "Web App" versions of Microsoft Excel will not work with the full version of Excel 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.

Excel Basics

Your first lesson will help you develop a solid understanding of the Excel interface. You will become fluent in the secret language spoken only by Excel users and discover the best way to correct any mistake you made in Excel.

Creating a Worksheet

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

Time-Savers

Your third 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 will also spend some time working with the Quick Analysis and Flash Fill tools, introduced in Excel 2013.

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. This lesson focuses on writing formulas that can help ease through some rather sticky scenarios.

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

Sorting, Subtotaling, and Filtering

No Excel course would be complete without a lesson on Excel's data-crunching capabilities. In this lesson, you will not only learn how to build a database in Excel, but how to subtotal, sort, and filter.

Charting Basics

This lesson introduces the various charts available in Excel. You will build your first graph in this lesson, and you will learn how easy it is to adjust the chart type, labels, titles, colors, and many other aspects of your chart.

Advanced Charting Techniques

This lesson explores everything from bar charts and line charts to more prosaic graphs like the pie chart, the bubble chart, and 3-D charts. You will find out how to personalize your charts and discover the best ways to print or otherwise display the truly impressive charts that you will be creating.

Intro to Excel's Statistical Functions

Excel includes many powerful functions that can automatically perform complicated tasks for you. This lesson introduces helpful ways to put these functions to work. You will find out how to ask Excel to magically derive averages, modes, maximums, minimums, and other useful statistics.

Financial Functions

This lesson provides an in-depth look at Excel's financial functions. By the time this lesson is over, you will be able to figure out how much money you will have when you retire, when your kids reach college, or just before your next vacation.

Worksheet Automation

This lesson introduces automation. You will discover how to move your most frequently used commands from their present locations to a much more convenient place: the toolbar. You will also learn how macros can be used to reduce just about any complex task to a single keystroke.

Mastering Excel's IF Function

In your final lesson, you will learn how to teach Excel to make and act on certain decisions. You will learn how to utilize a function that allows Excel to make comparisons and use that comparison as the basis for important decisions.

Knowing how to create a spreadsheet with Microsoft Excel is key to effectively managing and organizing information. This online, self-paced course will introduce you to Microsoft Excel 2019 and teach you basic Excel skills.

If you work with numbers, names, dates, or other important data, you need to create spreadsheets to manage this information. Microsoft Excel is the most widely-used spreadsheet software to organize, store, and optimize data. If you're ready to learn Excel 2019, this course will teach you the basics.

You will learn how to create a spreadsheet using several time-saving functions. You will also learn how to use macros and buttons, how to sort and analyze your data, and more. By course completion, you will know how to best organize large sets of data into a spreadsheet with this powerful business productivity 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 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.

Excel Basics

In our first 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

Our third lesson will teach you the tricks of the Excel masters: a wide variety of useful shortcuts guaranteed to save you time, energy, and frustration. We'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. Today, we focus on writing sophisticated formulas that can help ease us through some rather sticky scenarios.

3-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. Today, 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. Today, you'll not only learn how to build a table in Excel, but you'll also learn how to subtotal, sort, and filter.

Charting Basics

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

Advanced Charting Techniques

Today, 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 3-D 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 today's 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

We'll continue our exploration of Excel functions with an in-depth look at Excel's handy financial functions today. 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

Students often rank this lesson as one of their favorites. Today, 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

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

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.

That's why so 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.

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.

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 available online.

Getting Started with Outlook 201

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.

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 slide and layout masters 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.

1. The PowerPoint 2016 Interface
2. Creating Presentations
3. Creating and Editing Tables and Opening and Saving Files
4. Creating and Printing Error-free Presentations
5. Working With Saved and Online Images
6. WordArt, Shapes, and SmartArt
7. Creating and Editing a Chart
8. Making Global Changes to a Presentation
9. Creating Links
10. Applying Animation to Slides, Text, and Objects
11. Applying Advanced Animation Effects to Text and Objects
12. Sharing and Saving Your Presentations, Including OneDrive and Office Online

Microsoft PowerPoint is the most commonly used presentation software. This online, self-paced course will teach you how to effectively use Microsoft PowerPoint 2019 to create professional presentations.

Across industries, Microsoft PowerPoint is the most widely used business software for presentations. Knowing how to use PowerPoint 2019, and its online Office 365 counterpart, adds a vital workplace skill to your professional profile.

The Introduction to Microsoft PowerPoint 2019/Office 365 course will introduce you to PowerPoint 2019 and teach you how to use its basic tools and features. By the time you finish these hands-on lessons, you will know how to create engaging, dynamic presentations.

Requirements:

Hardware Requirements:

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

Software Requirements:

• PC: Windows 10 or later. PowerPoint 2019 is not compatible with earlier Windows versions.
• Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge is also compatible.
• Microsoft PowerPoint 2019: Available to download with a subscription to Microsoft 365, or with 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.

The PowerPoint 2019 Interface

This lesson explores the basic features of Microsoft PowerPoint 2019. You'll explore the Ribbon and learn how to start the PowerPoint program and plan a presentation. And you'll 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. We'll start by choosing a theme for a presentation and create slides with a variety of slide layouts. You'll explore the Live Preview feature, and we'll discuss how to save a file for future use. You'll also create and edit slides in Slide pane and Outline view. Finally, we'll explore ways to play a slide show.

Working with Files and Creating and Editing Tables

Including tables in your presentation lets you present a lot of information in a compact space. In this lesson, you'll add, revise and format tables. You'll also explore multiple ways to open a presentation. Then, you'll learn how to preserve different versions of your work by saving with new file names.

Creating Professional Presentations

This lesson covers two topics: proofreading and printing. We'll explore the Spelling, AutoCorrect, Thesaurus and Smart Lookup feature. You'll learn to print your presentation as slides, an outline, handouts and notes pages. This versatility really helps you connect with audience members!

Working with the Images Group

This lesson switches gears and works with images instead of text. You'll learn how to embellish your slides with media images, including online pictures, Icons, 3D models and photographs. You'll also learn how to download an image from a website and insert the image on a slide.

WordArt and the Illustrations Group

This lesson includes instructions for using WordArt, Shapes, Icons, 3D Models and SmartArt Graphics. You'll learn how to transform text into colorful WordArt objects and add Icons and 3D Models. You'll also practice drawing and filling shapes with color and special effects. You'll learn to group and edit the objects you create. And you'll add visual sophistication to your text with SmartArt Graphics.

All About Charts

In this lesson, you'll create a chart to illustrate statistical data. You'll explore chart components and learn how to add and edit specific chart elements. You'll discover how to change the look of your chart by using options on the Chart Tools contextual tab and the chart formatting buttons.

Making Global Changes to a Presentation

Making duplicate changes to dozens of PowerPoint slides is boring and time-consuming. This lesson focuses on making global changes to slides, handouts, and notes. You'll also make global changes to modify your presentation's background or theme colors.

Creating Links

In this lesson, we'll work with hyperlinks and action buttons. Enliven your presentation as you create links from text or objects to other slides, presentations, documents, and Web pages. You can add sounds and 3-D effects if desired. Also introduced is the Zoom feature which sets up presenter-driven links between slides in a presentation.

Applying Animation to Slides, Text, and Objects

This lesson explores slide transitions and Transition tab options. You'll apply animation to text and slide objects and use the Animations tab to add animation to slide or layout masters. You'll also find out how to add sound effects, such as chime or coin, to slide transitions.

Adding Advanced Animation Effects to Text and Objects

Using the Animation Pane, you'll add and reorder animated text and objects on slides. You'll discover how to apply advanced animation effects to text and objects on slides, and slide and layout masters. You'll also add an audio clip to your presentation.

Sharing and Saving Your Presentations

In this lesson, you'll focus on different ways to save and share a presentation. You'll practice converting a presentation into a PDF file, so it's accessible on computers without PowerPoint 2019. You'll learn to open, edit, and share your presentation online with PowerPoint Online and a Windows OneDrive account. Last, you'll learn how to transform your presentation into a video.

This online, self-paced course will teach you how to effectively plan and implement with Microsoft Project, the world's most popular project management software.

Microsoft Project is one of the most widely used project management resources. If you oversee projects in your organization or plan to take on a project management role, knowing how to use Microsoft Project 2019 adds a valuable skill to your professional profile.

Introduction to Microsoft Project 2019/365 will teach how to effectively plan, implement, and control projects. You will learn how to organize all your project's details, including task assignments, resource allocation, and progression and timeline. 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.

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 your first 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 today's lesson! We'll walk through 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 plan 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, people, equipment, and material 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. We'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 project schedule—costs. You'll start things off by looking through a brief overview of cost accounting, exploring fixed, variable, relevant, and accrued charges. After this review, you'll learn how to assign costs by using the Resource Sheet. You'll even discover how to attach different fees 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. And 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 is completed sooner and for less. In today's 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 initially 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 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 gain information about your project's position quickly. You'll also begin using the Tracking Gantt and filters to identify slipping tasks automatically. 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 aspects 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 today's lesson. By the time you finish, you'll be well acquainted with Project's reporting capabilities and also know how to develop Visual Reports as Project automatically exports data to Microsoft Excel and Visio.

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.

Software Requirements:

• PC: Windows 10 or later.
• Mac: macOS 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.

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

Learn to use the basic features of Word 2016 (now available through Office 365) to type, edit, format, spell check, and print professional-looking documents, letters, and reports.

One of the most basic skills needed in any job is writing reports and letters using Microsoft Word 2016, now available through Office 365. In this course, you will gain the foundational skills you need to make the most of this powerful program.

Through hands-on instructions, you will learn how to add and edit text; move words from one part of your document to another; work on two or more documents simultaneously; and format your text. You will also see how to save, retrieve, copy, organize, and print your documents.

You will learn dozens of ways to modify the appearance and content of your documents by adjusting page margins, paragraph tab settings, and line spacing to create great-looking documents quickly and easily. If you need to type foreign language characters or symbols, you can do that in Word too.

By using Word's spell and grammar checker, you can catch typos and grammatical mistakes before you print or share your document with others. You will also explore the program's thesaurus feature, which can help you find exactly the right word. By the time you're done with the step-by-step lessons and hands-on activities in this course, 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. 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 Word 2016 (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.

Getting Started

In this introductory lesson, you will learn how to use the different parts of Word 2016's user interface, how to look at your document from 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. This lesson introduces the basics of moving the insertion point and deleting text. 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 will learn how to save the documents you create in Word. You will also learn how to rename, copy, and even delete any files you have created, so you will 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. This lesson focuses on editing text. The easiest way to edit text is to delete it, but a more sophisticated way to edit text is to copy text and paste a duplicate of that text in another location.

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 lesson will teach you how to open, switch between, and view multiple documents.

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 text size and alignment, and even modify fonts.

Printing

Most people use Word to print letters and reports. In this lesson, you will learn about the different ways you can print a document, such as portrait orientation or landscape orientation. With Word's ability to print on different types of paper sizes and orientation, you can create more than just typical documents.

Margins, Tabs, and Page Numbering

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 will also learn how to add page numbers to the top or bottom of a page to keep track of page order.

Paragraph Formatting

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 number lists, so you can display short bits of information in a visual manner.

Language Tools

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.

Customizing Word

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

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.

Learn how the foundational skills needed to utilize Microsoft Word 2019. 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. 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.

1. Getting Started
2. Typing and Navigation
3. File Management
4. Editing Text
5. Working With Multiple Documents
6. Text Formatting and Alignment
7. Printing
8. Margins, Tabs, and Page Numbering
9. Paragraph Formatting
10. Language Tools
11. Customizing Word
12. Making a Word Document Pretty and Organized

Obtain valuable skills working with data in Excel in this self-paced, online course.

Master the VLOOKUP function in Microsoft Excel and gain valuable skills applicable in any workplace where data is used when you complete this self-paced, online course. You will learn to work with data more effectively using the VLOOKUP functions and other helpful features in 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 is preferred. Microsoft Edge is also compatible.
• Microsoft Excel (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.

1. Microsoft Excel LOOKUP Functions
2. Using the VLOOKUP Function
3. Things to Know when Using VLOOKUP
4. Excel Features that are Helpful when Using VLOOKUP
5. Exercise: Using an Absolute Reference
6. Named Ranges
7. Exercise: Using Named Ranges in Formulas
8. And Function
9. Exercise: Use VLOOKUP to Add a Product Description and Price
10. Exercise: Use Absolute References within VLOOKUP
11. Exercise: Use VLOOKUP to Obtain Letter Grades
12. Exercise: Use VLOOKUP to Add Employee Information
13. Exercise: Use VLOOKUP to Add Employee Phone Numbers
14. Exercise: Use a Commission Table
15. Exercise: Use Named Ranges to Merge Data

What you will learn

• How to effectively use the LOOKUP functions
• Understand Excel features that are helpful when using VLOOKUP

How you will benefit

• Gain more in-depth Excel skills
• Increase your employability and value within any company
• Gain confidence in your ability to used advanced Excel functions and features

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 and Chromebooks are not compatible.

Software Requirements:

• PC: Windows 10 or later. (Windows 11 users, it is recommended to have 8-16GB of RAM for best results.)
• Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge is also compatible.
• Microsoft Access 365, 2021, or 2019 (not included in enrollment). You can use any of these versions of Access for the course. Please note: The course is designed using Microsoft Access 365, which is updated regularly, so there may be some slight differences between your version and what you see in the course, but the core concepts and functionalities covered will remain consistent across all versions.
• 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 Certification 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. Microsoft Access
   1. Introduction to Microsoft Access Training
      1. Databases and Access Terms
      2. Quick Overview Access Interface
      3. Fundamentals
      4. Tables and Their Views
      5. Tables
      6. Queries
      7. Forms
      8. Reports
      9. EXAM: Introduction to Microsoft Access Exam
   2. Advanced Microsoft Access Training
      1. Relationships
      2. Advanced Queries
      3. Table Functions
      4. Advanced Forms
      5. Advanced Reports
      6. Macros
      7. Completing the Desktop Application
      8. EXAM: Advanced Microsoft Access Exam
   3. FINAL EXAM: 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

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 and Chromebooks are not compatible.

Software Requirements:

• PC: Windows 10 or later.(Windows 11 users, it is recommended to have 8-16GB of RAM for best results.)
• Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge is also compatible.
• Microsoft Access 365, 2021, or 2019 (not included in enrollment). You can use any of these versions of Access for the course. Please note: The course is designed using Microsoft Access 365, which is updated regularly, so there may be some slight differences between your version and what you see in the course, but the core concepts and functionalities covered will remain consistent across all versions.
• 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. Microsoft Access
1. Introduction to Microsoft Access Training
   1. Databases and Access Terms
   2. Quick Overview Access Interface
   3. Fundamentals
   4. Tables and Their Views
   5. Tables
   6. Queries
   7. Forms
   8. Reports
   9. EXAM: Introduction to Microsoft Access Exam
2. Advanced Microsoft Access Training
   1. Relationships
   2. Advanced Queries
   3. Table Functions
   4. Advanced Forms
   5. Advanced Reports
   6. Macros
   7. Completing the Desktop Application
   8. EXAM: Advanced Microsoft Access Exam
3. FINAL EXAM: 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

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.

Master all the features of Excel pivot tables, including little-known options and settings, layouts, calculated fields, multi-level subtotals, Pivot Charts, Timelines, and Slicers.

Wouldn't it be great to learn how to effectively use all the advanced Excel pivot table features? In this practical and information-packed course, you will learn how to maximize this program's functions and capabilities.

Most organizations rely heavily on Microsoft Excel pivot tables to analyze and report financial information. Your company is probably no exception. By learning these advanced techniques, you can become more valuable to your organization.

This course will teach you how to utilize the numerous pivot tables to develop useful analysis models and reports within your company. Impress your coworkers by learning how to create functional and eye-catching interactive dashboards using a combination of pivot tables, Pivot Charts, and Slicers. You will discover advanced techniques for pivot tables, like creating Timelines, calculated fields, and calculated items. You will learn how to use Excel's Table function to efficiently manage changes to the pivot table's source data in order to avoid reporting mistakes when data is added or deleted.

Requirements:

Hardware Requirements:

• This course can be taken on either a PC or Mac.

Software Requirements:

• PC: Windows 8 or later.
• Mac: macOS 10.6 or later.
• Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge and Safari are also compatible.
• Microsoft Excel 2016, Microsoft Excel 2019, Microsoft Excel 2021, or Microsoft Office 365 (not included in enrollment).
• Note that a free 30-day trial of Office 365 Home Premium may be available at Office Online. Afterwards, a subscription can be purchased for as little as $6.99 per month.
• The "Starter", "Web App", and "Office Mac Home" versions of Microsoft Excel will not work with the full version of Excel 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.

Pivot Table Concepts

In your first lesson, you will develop a solid understanding of the requirements to use pivot tables. This lesson introduces the foundational elements needed to understand and get the most out of pivot tables.

Creating a Pivot Table

Not all data is created equal. In this lesson, you will learn what's required to make sure your data is organized well enough to be used in a pivot table. You will discover a very common issue that occurs when the source data changes and you how to easily eliminate that issue.

Pivot Table Analyze and Design Tabs

Working efficiently with pivot tables requires knowing where to find the proper pivot table feature without searching high and low for it. Most pivot table features reside on one of the two pivot table-specific Ribbon tabs. This lesson introduces the different features that are grouped and what each one provides.

Pivot Table Formatting Inside and Out

Formatting a pivot table report can be challenging if you don't know all the secrets. In this lesson, you will learn how to format cells and numbers, as well as how to handle empty cells or errors in your source data. In addition, you will get some exposure to renaming fields and how to sort and filter data within your pivot table report.

Pivot Table Options and Field Settings

Most users may not know that there are certain options and settings that provide little-known but extremely useful features. Most of these features are accessed through the pivot table Ribbon tabs, but some are not. In this lesson, you will learn how to use some of the more obscure settings in the Pivot Table Options and Field Settings dialog boxes.

Value Field Settings

Similar to the Field Settings, the Values section of a pivot table report have unique settings and summarization options. For most people, simply summing or counting the data within the Values section is enough. But once you learn how to use these lesser-known settings, you will go from an average pivot table user to an expert.

Grouping Pivot Table Fields

A pivot table is ideal for analyzing and summarizing data. By default, the table does an excellent job at summarizing the data within the various fields, but there is a way to summarize the data even further. In This lesson will show you how to group ordinary pivot table fields, which will create new fields that you can use within the pivot table or as a Slicer. In addition, you will learn how to expand and collapse fields to help in summarizing the pivot table data.

Data-Integrity Checks and Report Filters

A pivot table is a great way to locate data anomalies in large data sets that would otherwise be hard to find scanning through the source table. In addition, the proper use of report filters can assist in any data investigation, as well as providing a great tool to create multiple reports from a single pivot table report. You will learn all about these tools in this lesson.

Cloning a Pivot Table and the Wonderful World of Slicers

Pivot tables are extremely useful and flexible for data analysis and reporting. It's easy to add, remove, or simply move fields to create different-looking reports from the same source data. This lesson focuses on creating different versions of reports and the different techniques needed to do so.

Calculated Fields and Items

Pivot tables are great for analyzing and reporting information, but they're limited in their functionality when your source data is missing needed information. Or, perhaps the information isn't needed in the source data and is only needed for analysis for a short time. This lesson will demonstrate how to use Excel's Calculated Items and Fields feature to create items that are missing from the source data.

Working with Slicers and Pivot Charts

Your pivot table isn't complete without a Slicer and pivot chart. In order to create an effective dashboard, a pivot table and pivot chart controlled by multiple Slicers is a must. This lesson focuses on creating and managing Slicers and Pivot Charts.

Timelines and Dashboard Development

In the final lesson, you will learn about the many interactive tools and techniques available to make pivot tables and pivot charts fun to use. Similar to a Slicer, Excel offers a tool called Timelines. Timelines are available when a field available in your pivot table or chart is a date. Within a dashboard, using the Timeline feature can be useful and eye catching to the users.

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 and Chromebooks 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 Office 365, 2021 or 2019 (not included in enrollment). While you can use an older version of Microsoft Office, if you do, there will be some differences between your version 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.

Get the Excel training you need to achieve success so you can manipulate data faster and more efficiently in most workplace situations. If your organization uses lists of any kind, you need to know how to use Microsoft Excel. Earning the 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.

In this online Excel course, you will first learn 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 (for Microsoft Office 2019/2021 users), or Exam MO-211 (for Microsoft Office 365 users.) 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.

1. Introduction to Excel
   1. Microsoft Office Basics
   2. Creating a Microsoft Excel Workbook
   3. The Ribbon
   4. The Backstage View (The File Menu)
   5. The Quick Access Toolbar
   6. Entering Data in Microsoft Excel Worksheets
   7. Formatting Microsoft Excel Worksheets
   8. Editing Worksheets
   9. Working with Rows and Columns
   10. Using Formulas in Microsoft Excel
   11. Finalizing Microsoft Excel Worksheets
   12. Introduction to Excel Exam
2. Intermediate Excel
   1. Common Functions
   2. Working with Lists
   3. Visualizing Your Data
   4. Working with Tables
   5. Advanced Formatting
   6. Intermediate Excel Exam
3. Advanced Excel
   1. Using PivotTables
   2. Advanced Functions
   3. Auditing Workbooks
   4. Data Tools
   5. Working with Others
   6. Recording and Using Macros
   7. Advanced Excel Exam
4. Final Exam

What you will learn

• Modify and format data in Excel to create clear, presentable worksheets
• Perform calculations, write formulas, manage workbooks, and save time with Excel shortcuts
• Use Excel database functions and logic functions to work with information in large datasets, and leverage Excel's statistical functions to analyze data
• Visualize your data using charts to show trends, create comparisons, and demonstrate other meaningful insights
• Convert, sort, filter, and manage lists to keep your data organized
• Insert and modify illustrations, logos, or shapes to create professional reports
• Emphasize interesting and unusual data with conditional formatting and save time by using styles to apply formatting instantly
• Create PivotTables and charts to quickly summarize large amounts of data
• Learn to trace precedents and dependents to learn about the data connected to your active cell
• Convert blocks of text, analyze data using tables, and leverage validation tools to control the data entered into your worksheet. Consolidate data from various sources into one master worksheet for easy summary and review
• How to protect your worksheets and workbooks for safe and secure collaboration
• Work with other applications by importing and exporting data, charts, and files

How you will benefit

• Enhance your resume with widely-recognized and in-demand Microsoft Excel skills, making you more attractive to potential employers
• Leverage Excel's powerful data analysis capabilities to make informed data-driven decisions
• Use Excel to automate repetitive tasks, saving you valuable time and reducing the risk of manual errors
• Generate sophisticated reports and visualizations using Excel to better understand your data and communicate your findings
• Master Excel's tools and shortcuts to boost your efficiency and. you to complete your tasks more quickly

Tracy Berry

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 and Chromebooks 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 Office 365, 2021 or 2019 (not included in enrollment). While you can use an older version of Microsoft Office, if you do, there will be some differences between your version 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.

Get the Excel training you need to achieve success so you can manipulate data faster and more efficiently in most workplace situations. If your organization uses lists of any kind, you need to know how to use Microsoft Excel. Earning the 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.

In this online Excel course, you will first learn 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 (for Microsoft Office 2019/2021 users), or Exam MO-211 (for Microsoft Office 365 users.) 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.

1. Introduction to Excel
   1. Microsoft Office Basics
   2. Creating a Microsoft Excel Workbook
   3. The Ribbon
   4. The Backstage View (The File Menu)
   5. The Quick Access Toolbar
   6. Entering Data in Microsoft Excel Worksheets
   7. Formatting Microsoft Excel Worksheets
   8. Editing Worksheets
   9. Working with Rows and Columns
   10. Using Formulas in Microsoft Excel
   11. Finalizing Microsoft Excel Worksheets
   12. Introduction to Excel Exam
2. Intermediate Excel
   1. Common Functions
   2. Working with Lists
   3. Visualizing Your Data
   4. Working with Tables
   5. Advanced Formatting
   6. Intermediate Excel Exam
3. Advanced Excel
   1. Using PivotTables
   2. Advanced Functions
   3. Auditing Workbooks
   4. Data Tools
   5. Working with Others
   6. Recording and Using Macros
   7. Advanced Excel Exam
4. Final Exam

What you will learn

• Modify and format data in Excel to create clear, presentable worksheets
• Perform calculations, write formulas, manage workbooks, and save time with Excel shortcuts
• Use Excel database functions and logic functions to work with information in large datasets, and leverage Excel's statistical functions to analyze data
• Visualize your data using charts to show trends, create comparisons, and demonstrate other meaningful insights
• Convert, sort, filter, and manage lists to keep your data organized
• Insert and modify illustrations, logos, or shapes to create professional reports
• Emphasize interesting and unusual data with conditional formatting and save time by using styles to apply formatting instantly
• Create PivotTables and charts to quickly summarize large amounts of data
• Learn to trace precedents and dependents to learn about the data connected to your active cell
• Convert blocks of text, analyze data using tables, and leverage validation tools to control the data entered into your worksheet. Consolidate data from various sources into one master worksheet for easy summary and review
• How to protect your worksheets and workbooks for safe and secure collaboration
• Work with other applications by importing and exporting data, charts, and files

How you will benefit

• Enhance your resume with widely-recognized and in-demand Microsoft Excel skills, making you more attractive to potential employers
• Leverage Excel's powerful data analysis capabilities to make informed data-driven decisions
• Use Excel to automate repetitive tasks, saving you valuable time and reducing the risk of manual errors
• Generate sophisticated reports and visualizations using Excel to better understand your data and communicate your findings
• Master Excel's tools and shortcuts to boost your efficiency to complete your tasks more quickly

Tracy Berry

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.

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 are preferred. Microsoft Edge is also compatible.
• Microsoft Office 365 or 2021 (not included in enrollment). While you can use an older version of Microsoft Office, if you do, there will be some differences between your version 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.

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 and MO-310 (PowerPoint), and MO-400 (Outlook) exams. To earn the Microsoft Office Specialist (MOS) Associate Certification, you must successfully complete 3 Associate level exams of your choosing.

1. Introduction to Excel
   1. Microsoft Office Basics
   2. Creating a Microsoft Excel Workbook
   3. The Ribbon
   4. The Backstage View (The File Menu)
   5. The Quick Access Toolbar
   6. Entering Data in Microsoft Excel Worksheets
   7. Formatting Microsoft Excel Worksheets
   8. Editing Worksheets
   9. Working with Rows and Columns
   10. Using Formulas in Microsoft Excel
   11. Finalizing Microsoft Excel Worksheets
   12. Introduction to Excel Exam
2. Intermediate Excel
   1. Common Functions
   2. Working with Lists
   3. Visualizing Your Data
   4. Working with Tables
   5. Advanced Formatting
   6. Intermediate Excel Exam
3. Advanced Excel
   1. Using PivotTables
   2. Advanced Functions
   3. Auditing Workbooks
   4. Data Tools
   5. Working with Others
   6. Recording and Using Macros
   7. Advanced Excel Exam
   8. Final Excel Exam
4. Introduction to Word
   1. Microsoft Office Basics
   2. Creating a Microsoft Word Document
   3. The Ribbon
   4. The Backstage View (The File Menu)
   5. The Quick Access Toolbar
   6. Formatting Microsoft Word Documents
   7. Editing Documents
   8. Finalizing Microsoft Word Documents
   9. Introduction to Word Exam
5. Intermediate Word
   1. Advanced Formatting
   2. Working with Tables
   3. Working with Images
   4. Page Layout
   5. Working with Illustrations
   6. Viewing Your Documents
   7. Intermediate Word Exam
6. Advanced Word
   1. Working with Long Documents
   2. Reviewing and Collaborating on Documents
   3. Comparing and Combining Documents
   4. Forms
   5. Managing Mailings
   6. Protecting Documents
   7. Macros
   8. Advanced Word Exam
   9. Final Word Exam
7. Introduction to PowerPoint
   1. Microsoft Office Basics
   2. Creating a Presentation
   3. The Ribbon
   4. The Backstage View (The File Menu)
   5. The Quick Access Toolbar
   6. Formatting Presentations
   7. Working with Images
   8. Working with Tables and Charts
   9. Preparing and Presenting
   10. Introduction to PowerPoint Exam
8. Advanced 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. Finalizing Presentations
   10. Advanced PowerPoint Exam
   11. Final PowerPoint Exam
9. Introduction to Microsoft Outlook
   1. The Outlook Interface
   2. Working with Messages
   3. Working with the Calendar
   4. Organizing Contacts
   5. Working with Groups
   6. Introduction to Microsoft Outlook Exam
10. Advanced Microsoft Outlook
    1. Performing Popular Tasks
    2. Working with Tasks and Notes
    3. Using Signature and Themes
    4. Managing Your Inbox
    5. Working with Multiple Email Accounts
    6. Advanced Microsoft Outlook Exam
    7. Final Outlook Exam

What you will learn

• Master the crucial Microsoft Office suite skills: Word, Excel, PowerPoint, and Outlook to enhance your productivity
• Craft and refine Word documents with ease and precision
• Create visually stunning Excel spreadsheets to make data analysis engaging
• Design persuasive PowerPoint presentations to captivate audiences
• Streamline communication, scheduling, and collaboration using Outlook's powerful features

How you will benefit

• Increased employability: Enhance your resume with the widely-recognized and in-demand Microsoft Office skills, making you more attractive to potential employers
• Improved productivity: Streamline your daily tasks and processes by utilizing the various tools and features available in the Office suite
• Enhanced communication: Craft professional and visually appealing documents, presentations, and emails to clearly convey your message to colleagues and clients
• Data-driven decision-making: Leverage Excel's powerful data analysis capabilities to make informed decisions based on quantitative insights
• Efficient collaboration: Utilize Outlook and other Office applications to seamlessly collaborate with team members, share documents, and keep everyone on the same page
• Time-saving automation: Use Excel to automate repetitive tasks, saving you valuable time and reducing the risk of manual errors
• Customized solutions: Tailor PowerPoint presentations and Word documents to suit various audiences and purposes, adapting to the specific needs of your projects
• Superior organization: Manage your schedule, tasks, and contacts effectively using Outlook's calendar and task management features, ensuring you stay on top of your commitments
• Advanced reporting: Generate sophisticated reports and visualizations using Excel to better understand your data and communicate your findings
• Professional growth: Continuously develop your skills and stay relevant in the ever-evolving workplace by mastering the latest updates and features within the Microsoft Office suite

Tracy Berry

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 and Chromebooks 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 Office 365 or 2021(not included in enrollment). While you can use an older version of Microsoft Office, if you do, there will be some differences between your version 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.

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 and MO-310 (PowerPoint), and MO-400 (Outlook) exams. To earn the Microsoft Office Specialist (MOS) Associate Certification, you must successfully complete 3 Associate level exams of your choosing.

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. Introduction to Excel
   1. Microsoft Office Basics
   2. Creating a Microsoft Excel Workbook
   3. The Ribbon
   4. The Backstage View (The File Menu)
   5. The Quick Access Toolbar
   6. Entering Data in Microsoft Excel Worksheets
   7. Formatting Microsoft Excel Worksheets
   8. Editing Worksheets
   9. Working with Rows and Columns
   10. Using Formulas in Microsoft Excel
   11. Finalizing Microsoft Excel Worksheets
   12. Introduction to Excel Exam
2. Intermediate Excel
   1. Common Functions
   2. Working with Lists
   3. Visualizing Your Data
   4. Working with Tables
   5. Advanced Formatting
   6. Intermediate Excel Exam
3. Advanced Excel
   1. Using PivotTables
   2. Advanced Functions
   3. Auditing Workbooks
   4. Data Tools
   5. Working with Others
   6. Recording and Using Macros
   7. Advanced Excel Exam
   8. Final Excel Exam
4. Introduction to Word
   1. Microsoft Office Basics
   2. Creating a Microsoft Word Document
   3. The Ribbon
   4. The Backstage View (The File Menu)
   5. The Quick Access Toolbar
   6. Formatting Microsoft Word Documents
   7. Editing Documents
   8. Finalizing Microsoft Word Documents
   9. Introduction to Word Exam
5. Intermediate Word
   1. Advanced Formatting
   2. Working with Tables
   3. Working with Images
   4. Page Layout
   5. Working with Illustrations
   6. Viewing Your Documents
   7. Intermediate Word Exam
6. Advanced Word
   1. Working with Long Documents
   2. Reviewing and Collaborating on Documents
   3. Comparing and Combining Documents
   4. Forms
   5. Managing Mailings
   6. Protecting Documents
   7. Macros
   8. Advanced Word Exam
   9. Final Word Exam
7. Introduction to PowerPoint
   1. Microsoft Office Basics
   2. Creating a Presentation
   3. The Ribbon
   4. The Backstage View (The File Menu)
   5. The Quick Access Toolbar
   6. Formatting Presentations
   7. Working with Images
   8. Working with Tables and Charts
   9. Preparing and Presenting
   10. Introduction to PowerPoint Exam
8. Advanced 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. Finalizing Presentations
   10. Advanced PowerPoint Exam
   11. Final PowerPoint Exam
9. Introduction to Microsoft Outlook
   1. The Outlook Interface
   2. Working with Messages
   3. Working with the Calendar
   4. Organizing Contacts
   5. Working with Groups
   6. Introduction to Microsoft Outlook Exam
10. Advanced Microsoft Outlook
    1. Performing Popular Tasks
    2. Working with Tasks and Notes
    3. Using Signature and Themes
    4. Managing Your Inbox
    5. Working with Multiple Email Accounts
    6. Advanced Microsoft Outlook Exam
    7. Final Outlook Exam

What you will learn

• Master the crucial Microsoft Office suite skills: Word, Excel, PowerPoint, and Outlook to enhance your productivity
• Craft and refine Word documents with ease and precision
• Create visually stunning Excel spreadsheets to make data analysis engaging
• Design persuasive PowerPoint presentations to captivate audiences
• Streamline communication, scheduling, and collaboration using Outlook's powerful features

How you will benefit

• Increased employability: Enhance your resume with the widely-recognized and in-demand Microsoft Office skills, making you more attractive to potential employers
• Improved productivity: Streamline your daily tasks and processes by utilizing the various tools and features available in the Office suite
• Enhanced communication: Craft professional and visually appealing documents, presentations, and emails to clearly convey your message to colleagues and clients
• Data-driven decision-making: Leverage Excel's powerful data analysis capabilities to make informed decisions based on quantitative insights
• Efficient collaboration: Utilize Outlook and other Office applications to seamlessly collaborate with team members, share documents, and keep everyone on the same page
• Time-saving automation: Use Excel to automate repetitive tasks, saving you valuable time and reducing the risk of manual errors
• Customized solutions: Tailor PowerPoint presentations and Word documents to suit various audiences and purposes, adapting to the specific needs of your projects
• Superior organization: Manage your schedule, tasks, and contacts effectively using Outlook's calendar and task management features, ensuring you stay on top of your commitments
• Advanced reporting: Generate sophisticated reports and visualizations using Excel to better understand your data and communicate your findings
• Professional growth: Continuously develop your skills and stay relevant in the ever-evolving workplace by mastering the latest updates and features within the Microsoft Office suite

Tracy Berry

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 in-depth course will prepare you to sit for and pass the Microsoft Office Specialist (MOS) certification exams for Word, Excel, PowerPoint, Access, and Outlook and earn your Microsoft Office Specialist (MOS) Expert Certification.

Requirements:

Hardware Requirements:

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

Software Requirements:

• PC: Windows 10 or later.(Windows 11 users, it is recommended to have 8-16GB of RAM for best results.)
• Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge is also compatible.
• Microsoft Office 365 or 2021 (not included in enrollment). While you can use an older version of Microsoft Office, if you do, there will be some differences between your version 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.

1. Introduction to Excel
   1. Microsoft Office Basics
   2. Creating a Microsoft Excel Workbook
   3. The Ribbon
   4. The Backstage View (The File Menu)
   5. The Quick Access Toolbar
   6. Entering Data in Microsoft Excel Worksheets
   7. Formatting Microsoft Excel Worksheets
   8. Editing Worksheets
   9. Working with Rows and Columns
   10. Using Formulas in Microsoft Excel
   11. Finalizing Microsoft Excel Worksheets
   12. Introduction to Excel Exam
2. Intermediate Excel
   1. Common Functions
   2. Working with Lists
   3. Visualizing Your Data
   4. Working with Tables
   5. Advanced Formatting
   6. Intermediate Excel Exam
3. Advanced Excel
   1. Using PivotTables
   2. Advanced Functions
   3. Auditing Workbooks
   4. Data Tools
   5. Working with Others
   6. Recording and Using Macros
   7. Advanced Excel Exam
   8. Final Excel Exam
4. Introduction to Word
   1. Microsoft Office Basics
   2. Creating a Microsoft Word Document
   3. The Ribbon
   4. The Quick Access Toolbar
   5. Formatting Microsoft Word Documents
   6. Editing Documents
   7. Finalizing Microsoft Word Documents
   8. Introduction to Word Exam
5. Intermediate Word
   1. Advanced Formatting
   2. Working with Tables
   3. Working with Images
   4. Page Layout
   5. Working with Illustrations
   6. Viewing Your Documents
   7. Intermediate Word Exam
6. Advanced Word
   1. Working with Long Documents
   2. Reviewing and Collaborating on Documents
   3. Comparing and Combining Documents
   4. Forms
   5. Managing Mailings
   6. Protecting Documents
   7. Macros
   8. Advanced Word Exam
   9. Final Word Exam
7. Introduction to PowerPoint
   1. Microsoft Office Basics
   2. Creating a Presentation
   3. The Ribbon
   4. The Quick Access Toolbar
   5. Formatting Presentations
   6. Working with Images
   7. Working with Tables and Charts
   8. Preparing and Presenting
   9. Introduction to PowerPoint Exam
8. Advanced 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. Finalizing Presentations
   10. Advanced PowerPoint Exam
   11. Final PowerPoint Exam
9. Introduction to Microsoft Outlook
   1. The Outlook Interface
   2. Working with Messages
   3. Working with the Calendar
   4. Organizing Contacts
   5. Working with Groups
   6. Introduction to Microsoft Outlook Exam
10. Advanced Microsoft Outlook
    1. Performing Popular Tasks
    2. Working with Tasks and Notes
    3. Using Signature and Themes
    4. Managing Your Inbox
    5. Working with Multiple Email Accounts
    6. Advanced Microsoft Outlook Exam
    7. Final Outlook Exam
11. Introduction to Microsoft Access
    1. Databases and Access Terms
    2. Quick Overview of the Access User Interface
    3. Fundamentals
    4. Tables and Their Views
    5. Tables
    6. Queries
    7. Forms
    8. Reports
    9. Introduction to Access Final Exam
12. Advanced Microsoft Access
    1. Relationships
    2. Queries
    3. Table Functions
    4. Advanced Forms
    5. Advanced Reports
    6. Macros
    7. Completing the Desktop Application
    8. Advanced Access Final Exam
    9. Access Final Access Exam

What you will learn

• Master the crucial Microsoft Office suite skills: Word, Excel, PowerPoint, Access, and Outlook to enhance your productivity
• Craft and refine Word documents with ease and precision
• Create visually stunning Excel spreadsheets to make data analysis engaging
• Design persuasive PowerPoint presentations to captivate audiences
• Optimize database management and boost efficiency with Access
• Streamline communication, scheduling, and collaboration using Outlook's powerful features

How you will benefit

• Increased employability: Enhance your resume with the widely-recognized and in-demand Microsoft Office skills, making you more attractive to potential employers
• Improved productivity: Streamline your daily tasks and processes by utilizing the various tools and features available in the Office suite
• Enhanced communication: Craft professional and visually appealing documents, presentations, and emails to clearly convey your message to colleagues and clients
• Data-driven decision-making: Leverage Excel's powerful data analysis capabilities to make informed decisions based on quantitative insights
• Efficient collaboration: Utilize Outlook and other Office applications to seamlessly collaborate with team members, share documents, and keep everyone on the same page
• Time-saving automation: Use Excel and Access to automate repetitive tasks, saving you valuable time and reducing the risk of manual errors
• Customized solutions: Tailor PowerPoint presentations and Word documents to suit various audiences and purposes, adapting to the specific needs of your projects
• Superior organization: Manage your schedule, tasks, and contacts effectively using Outlook's calendar and task management features, ensuring you stay on top of your commitments
• Advanced reporting: Generate sophisticated reports and visualizations using Excel and Access to better understand your data and communicate your findings
• Professional growth: Continuously develop your skills and stay relevant in the ever-evolving workplace by mastering the latest updates and features within the Microsoft Office suite

Tracy Berry

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 and Chromebooks are not compatible.

Software Requirements:

• PC: Windows 10 or later.(Windows 11 users, it is recommended to have 8-16GB of RAM for best results.)
• Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge is also compatible.
• Microsoft Office 365 or 2021 (not included in enrollment). While you can use an older version of Microsoft Office, if you do, there will be some differences between your version 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 are 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.

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

1. Introduction to Excel
   1. Microsoft Office Basics
   2. Creating a Microsoft Excel Workbook
   3. The Ribbon
   4. The Backstage View (The File Menu)
   5. The Quick Access Toolbar
   6. Entering Data in Microsoft Excel Worksheets
   7. Formatting Microsoft Excel Worksheets
   8. Editing Worksheets
   9. Working with Rows and Columns
   10. Using Formulas in Microsoft Excel
   11. Finalizing Microsoft Excel Worksheets
   12. Introduction to Excel Exam
2. Intermediate Excel
   1. Common Functions
   2. Working with Lists
   3. Visualizing Your Data
   4. Working with Tables
   5. Advanced Formatting
   6. Intermediate Excel Exam
3. Advanced Excel
   1. Using PivotTables
   2. Advanced Functions
   3. Auditing Workbooks
   4. Data Tools
   5. Working with Others
   6. Recording and Using Macros
   7. Advanced Excel Exam
   8. Final Excel Exam
4. Introduction to Word
   1. Microsoft Office Basics
   2. Creating a Microsoft Word Document
   3. The Ribbon
   4. The Quick Access Toolbar
   5. Formatting Microsoft Word Documents
   6. Editing Documents
   7. Finalizing Microsoft Word Documents
   8. Introduction to Word Exam
5. Intermediate Word
   1. Advanced Formatting
   2. Working with Tables
   3. Working with Images
   4. Page Layout
   5. Working with Illustrations
   6. Viewing Your Documents
   7. Intermediate Word Exam
6. Advanced Word
   1. Working with Long Documents
   2. Reviewing and Collaborating on Documents
   3. Comparing and Combining Documents
   4. Forms
   5. Managing Mailings
   6. Protecting Documents
   7. Macros
   8. Advanced Word Exam
   9. Final Word Exam
7. Introduction to PowerPoint
   1. Microsoft Office Basics
   2. Creating a Presentation
   3. The Ribbon
   4. The Quick Access Toolbar
   5. Formatting Presentations
   6. Working with Images
   7. Working with Tables and Charts
   8. Preparing and Presenting
   9. Introduction to PowerPoint Exam
8. Advanced 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. Finalizing Presentations
   10. Advanced PowerPoint Exam
   11. Final PowerPoint Exam
9. Introduction to Microsoft Outlook
   1. The Outlook Interface
   2. Working with Messages
   3. Working with the Calendar
   4. Organizing Contacts
   5. Working with Groups
   6. Introduction to Microsoft Outlook Exam
10. Advanced Microsoft Outlook
    1. Performing Popular Tasks
    2. Working with Tasks and Notes
    3. Using Signature and Themes
    4. Managing Your Inbox
    5. Working with Multiple Email Accounts
    6. Advanced Microsoft Outlook Exam
    7. Final Outlook Exam
11. Introduction to Microsoft Access
    1. Databases and Access Terms
    2. Quick Overview of the Access User Interface
    3. Fundamentals
    4. Tables and Their Views
    5. Tables
    6. Queries
    7. Forms
    8. Reports
    9. Introduction to Access Final Exam
12. Advanced Microsoft Access
    1. Relationships
    2. Queries
    3. Table Functions
    4. Advanced Forms
    5. Advanced Reports
    6. Macros
    7. Completing the Desktop Application
    8. Advanced Access Final Exam
    9. Access Final Access Exam

What you will learn

• Master the crucial Microsoft Office suite skills: Word, Excel, PowerPoint, Access, and Outlook to enhance your productivity
• Craft and refine Word documents with ease and precision
• Create visually stunning Excel spreadsheets to make data analysis engaging
• Design persuasive PowerPoint presentations to captivate audiences
• Optimize database management and boost efficiency with Access
• Streamline communication, scheduling, and collaboration using Outlook's powerful features

How you will benefit

• Increased employability: Enhance your resume with the widely-recognized and in-demand Microsoft Office skills, making you more attractive to potential employers
• Improved productivity: Streamline your daily tasks and processes by utilizing the various tools and features available in the Office suite
• Enhanced communication: Craft professional and visually appealing documents, presentations, and emails to clearly convey your message to colleagues and clients
• Data-driven decision-making: Leverage Excel's powerful data analysis capabilities to make informed decisions based on quantitative insights
• Efficient collaboration: Utilize Outlook and other Office applications to seamlessly collaborate with team members, share documents, and keep everyone on the same page
• Time-saving automation: Use Excel and Access to automate repetitive tasks, saving you valuable time and reducing the risk of manual errors
• Customized solutions: Tailor PowerPoint presentations and Word documents to suit various audiences and purposes, adapting to the specific needs of your projects
• Superior organization: Manage your schedule, tasks, and contacts effectively using Outlook's calendar and task management features, ensuring you stay on top of your commitments
• Advanced reporting: Generate sophisticated reports and visualizations using Excel and Access to better understand your data and communicate your findings
• Professional growth: Continuously develop your skills and stay relevant in the ever-evolving workplace by mastering the latest updates and features within the Microsoft Office suite

Tracy Berry

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.