Today's world runs on data more than ever before and that's a trend not likely to change, or even slow down, any time soon. With the tremendous amount of available data, the ability to make sense of it continues to be an ongoing challenge. You already know how to use Excel to perform simple calculations and modify worksheets to make them easier to read, interpret, and present to others. But Excel is capable of doing so much more.

To gain a truly competitive edge, you need to be able to extract actionable organizational intelligence from your raw data, and present it in a visually compelling format that enables decision makers to view key trends and gain insights. And that's exactly what this course aims to help you do.

In Adobe® InDesign® CC: Part 1 you were introduced to the many features that help you create professional looking documents. Now you need to create much lengthier interactive documents that need to be accessed across a range of devices. In Adobe® InDesign® CC: Part 2, you will learn advanced InDesign techniques to enhance the look and functionality of your documents.

Using Adobe InDesign, you can create interactive documents and export them for viewing in a web browser with various features such as buttons, page transitions, movies and audio files, hyperlinks, and animation. You have the ability to assign color profiles and establish print presets. In creating longer documents, you'll be able to include such features as a table of contents, footnotes, cross-references, and an index.

This course is a great component of your preparation for the Adobe Certified Professional Print & Digital Media Publication Using Adobe InDesign CC exam.

You have created simple artwork by using the basic drawing and painting tools available in Adobe® Illustrator®. You now want to use advanced tools, options, and effects to create complex artwork. In addition, you want to ensure that your artwork is ready for commercial printing and also save it for the web. In this course, you will draw complex illustrations and enhance them by using various painting options. You will also use painting tools, manage colors, format type, work with effects, prepare artwork for commercial printing, and prepare graphics for the web.

This course is a great component of your preparation for the Adobe Certified Professional in Graphic Design & Illustration Using Adobe Illustrator exam.

As a business professional, you have some experience using Adobe® Acrobat®. Now you're ready to take further advantage of all the features of Acrobat Pro DC to bring your documents to the next level. Whether you are creating PDFs for commercial printing or for viewing digital versions on a range of platforms, Adobe Acrobat Pro DC enables you to output your content so your audience will be able to access and view the document just the way you intended.

In this course, you will use Adobe Acrobat Pro DC to convert technical documents to PDF files, enhance PDF documents, create interactive PDF forms, and prepare PDF files for commercial printing.

Welcome to Microsoft® Project® 2019/2024/365: Part 1. This course is designed to familiarize you with the basic features and functions of Microsoft Project so you can effectively and efficiently manage projects in a real-world environment.

This course covers the critical knowledge and skills a project manager needs to create a project plan with Microsoft Project during the planning phase of a project. In other words, if your supervisor assigns you to lead a project, this course will enable you to draft a project plan with Microsoft Project and share it with your supervisor (and others) for review and approval.

The subject of this course is the Microsoft Project desktop app. A brief description of the Project for the web and the Project Online apps is presented in the Appendix.

Note: You can procure a license for the Project desktop app in one of two ways: purchasing a cloud-based subscription or an on-premises license. Project Online is included in both of the following purchase options:

• Cloud-based subscription: Project Plan 3 or 5. (Microsoft Project is not included in the Microsoft 365 plans. A separate subscription plan is required.)
• On-premises solution: Project Professional 2021.
  
  
  

Welcome to Microsoft® Project® 2019/2024/365: Part 1. This course is designed to familiarize you with the basic features and functions of Microsoft Project so you can effectively and efficiently manage projects in a real-world environment.

This course covers the critical knowledge and skills a project manager needs to create a project plan with Microsoft Project during the planning phase of a project. In other words, if your supervisor assigns you to lead a project, this course will enable you to draft a project plan with Microsoft Project and share it with your supervisor (and others) for review and approval.

The subject of this course is the Microsoft Project desktop app. A brief description of the Project for the web and the Project Online apps is presented in the Appendix.

Note: You can procure a license for the Project desktop app in one of two ways: purchasing a cloud-based subscription or an on-premises license. Project Online is included in both of the following purchase options:

• Cloud-based subscription: Project Plan 3 or 5. (Microsoft Project is not included in the Microsoft 365 plans. A separate subscription plan is required.)
• On-premises solution: Project Professional 2021.
  
  
  

In Adobe® InDesign® CC: Part 1 you were introduced to the many features that help you create professional looking documents. Now you need to create much lengthier interactive documents that need to be accessed across a range of devices. In Adobe® InDesign® CC: Part 2, you will learn advanced InDesign techniques to enhance the look and functionality of your documents.

Using Adobe InDesign, you can create interactive documents and export them for viewing in a web browser with various features such as buttons, page transitions, movies and audio files, hyperlinks, and animation. You have the ability to assign color profiles and establish print presets. In creating longer documents, you'll be able to include such features as a table of contents, footnotes, cross-references, and an index.

This course is a great component of your preparation for the Adobe Certified Professional Print & Digital Media Publication Using Adobe InDesign CC exam.

We are now living in the age of big data. Data is being collected all the time and for increasingly detailed transactions. This can lead to an overwhelming amount of data, which brings about a need for people who can analyze large amounts of data quickly. Fortunately, Microsoft® Excel® provides Power Pivot to help you organize, manipulate, and report on your data in the best way possible. Since a tool is only as good as the person using it, it is important to gain a solid understanding of Power Pivot to maximize your effectiveness when analyzing data.

We are now living in the age of big data. Data is being collected all the time and for increasingly detailed transactions. This can lead to an overwhelming amount of data, which brings about a need for people who can analyze large amounts of data quickly. Fortunately, Microsoft® Excel® provides Power Pivot to help you organize, manipulate, and report on your data in the best way possible. Since a tool is only as good as the person using it, it is important to gain a solid understanding of Power Pivot to maximize your effectiveness when analyzing data.

Welcome to Microsoft® Project® 2019-2024/365: Part 2. This course is designed to familiarize you with some of the advanced features and functions of Microsoft Project so you can use it effectively and efficiently in a real-world environment.

In Microsoft® Project® 2019/2021/365: Part 1, you learned the basic features of Microsoft Project during the planning phase of a project. This course covers the advanced knowledge and skills a project manager needs to update a project plan in Project during the execution, monitoring, and controlling phases of a project. In other words, once your project plan is approved by the project sponsor, this course will enable you to manage the project so that it is completed on time, within budget, and according to scope.

Note: You can procure a license for the Project desktop app in one of two ways: purchasing a cloud-based subscription or an on-premises license. Project Online is included in both of the following purchase options:

• Cloud-based subscription: Project Plan 3 or 5. (Microsoft Project is not included in the Microsoft 365 plans. A separate subscription plan is required.)
• On-premises solution: Project Professional 2021.

Welcome to Microsoft® Project® 2019-2024/365: Part 2. This course is designed to familiarize you with some of the advanced features and functions of Microsoft Project so you can use it effectively and efficiently in a real-world environment.

In Microsoft® Project® 2019/2021/365: Part 1, you learned the basic features of Microsoft Project during the planning phase of a project. This course covers the advanced knowledge and skills a project manager needs to update a project plan in Project during the execution, monitoring, and controlling phases of a project. In other words, once your project plan is approved by the project sponsor, this course will enable you to manage the project so that it is completed on time, within budget, and according to scope.

Note: You can procure a license for the Project desktop app in one of two ways: purchasing a cloud-based subscription or an on-premises license. Project Online is included in both of the following purchase options:

• Cloud-based subscription: Project Plan 3 or 5. (Microsoft Project is not included in the Microsoft 365 plans. A separate subscription plan is required.)
• On-premises solution: Project Professional 2021.

Giving your documents a well-designed, professional look will put you a step ahead in the marketplace cluttered with all kinds of communications. Paragraph and character styles that allow you to format pages of text uniformly, layout features that help you to build alternate size configurations of your document, and various panels that enable you to easily customize both text and graphics; Adobe® InDesign® has all the tools you need to elevate the look of your document and get it out to the people who need to see it, whether it be in print or on the web.

Giving your documents a well-designed, professional look will put you a step ahead in the marketplace cluttered with all kinds of communications. Paragraph and character styles that allow you to format pages of text uniformly, layout features that help you to build alternate size configurations of your document, and various panels that enable you to easily customize both text and graphics; Adobe® InDesign® has all the tools you need to elevate the look of your document and get it out to the people who need to see it, whether it be in print or on the web.

Microsoft® Visio® stands out among similar applications because of its unique ability to draw a wide variety of diagrams, flowcharts, workflows, and organization structures—anything that can be represented by shapes connected by lines. Most importantly, these shapes can be rearranged and with corresponding lines remaining intact. Visio has improved over the years as features common among Microsoft® Office applications have been added. Today, Visio is well integrated with other members of the Office family as well as Microsoft's cloud-based services. This greatly enriches the sharing and publishing of Visio drawings.

In Microsoft® Visio® 2019-2024: Part 1, you learned the basic skills needed to create and modify various Visio drawings. In Microsoft® Visio® 2019-2024: Part 2, you will learn about more advanced features—making you a more efficient and effective Visio user.

Microsoft® Visio® stands out among similar applications because of its unique ability to draw a wide variety of diagrams, flowcharts, workflows, and organization structures—anything that can be represented by shapes connected by lines. Most importantly, these shapes can be rearranged and with corresponding lines remaining intact. Visio has improved over the years as features common among Microsoft® Office applications have been added. Today, Visio is well integrated with other members of the Office family as well as Microsoft's cloud-based services. This greatly enriches the sharing and publishing of Visio drawings.

In Microsoft® Visio® 2019-2024: Part 1, you learned the basic skills needed to create and modify various Visio drawings. In Microsoft® Visio® 2019-2024: Part 2, you will learn about more advanced features—making you a more efficient and effective Visio user.

From the earliest eras of human existence, visual images have been used to represent knowledge, data, and information. Beginning with the Paleolithic cave paintings and continuing to today’s most complex computer networks, these images leverage the ability of the human brain to rapidly perceive patterns and trends from visual representations.

In today’s workplace, visual diagrams are an essential part of communication, from road maps to sales flows to process charts. Microsoft® Visio® provides you with an intuitive, customizable tool to easily create a professional-looking visual product by using its extensive gallery of shapes. By following the exercises in this course, you will create visually engaging diagrams, maps, and drawings, using graphical elements to make information easier to comprehend.

From the earliest eras of human existence, visual images have been used to represent knowledge, data, and information. Beginning with the Paleolithic cave paintings and continuing to today’s most complex computer networks, these images leverage the ability of the human brain to rapidly perceive patterns and trends from visual representations.

In today’s workplace, visual diagrams are an essential part of communication, from road maps to sales flows to process charts. Microsoft® Visio® provides you with an intuitive, customizable tool to easily create a professional-looking visual product by using its extensive gallery of shapes. By following the exercises in this course, you will create visually engaging diagrams, maps, and drawings, using graphical elements to make information easier to comprehend.

You've covered many of the basic functions of Microsoft® Office Access®, and now you're ready to learn advanced Access features such as database management, advanced form design, packaging a database, encrypting a database, preparing a database for multiple-user access, and more. Knowledge of these features separate database professionals from the casual database users or occasional designers.

This course is the third part of a three-course series that covers the skills needed to perform basic database design and development in Access 2019/2024.

• Microsoft ® Office Access ® 2019/2024: Part 1: Focuses on the design and construction of an Access database —viewing, navigating, searching, and entering data in a database, as well as basic relational database design and creating simple tables, queries, forms, and reports.
• Microsoft ® Office Access ® 2019/2024: Part 2: Focuses on optimization of an Access database, including optimizing performance and normalizing data; data validation; usability; and advanced queries, forms, and reports.
• Microsoft ® Office Access ® 2019/2024: Part 3 (this course): Focuses on managing the database and supporting complex database designs , including import and export of data; using action queries to manage data; creating complex forms and reports; macros and Visual Basic for Applications (VBA); and tools and strategies to manage, distribute, and secure a database.

This material will benefit users of any current Office version. The classroom environment setup is based on Office 2019.

This course covers Microsoft Office Specialist Program exam objectives to help you prepare for the Access Expert (Office 363 and Office 2019): Exam MO-500 certification.

You've covered many of the basic functions of Microsoft® Office Access®, and now you're ready to learn advanced Access features such as database management, advanced form design, packaging a database, encrypting a database, preparing a database for multiple-user access, and more. Knowledge of these features separate database professionals from the casual database users or occasional designers.

This course is the third part of a three-course series that covers the skills needed to perform basic database design and development in Access 2019/2024.

• Microsoft ® Office Access ® 2019/2024: Part 1: Focuses on the design and construction of an Access database —viewing, navigating, searching, and entering data in a database, as well as basic relational database design and creating simple tables, queries, forms, and reports.
• Microsoft ® Office Access ® 2019/2024: Part 2: Focuses on optimization of an Access database, including optimizing performance and normalizing data; data validation; usability; and advanced queries, forms, and reports.
• Microsoft ® Office Access ® 2019/2024: Part 3 (this course): Focuses on managing the database and supporting complex database designs , including import and export of data; using action queries to manage data; creating complex forms and reports; macros and Visual Basic for Applications (VBA); and tools and strategies to manage, distribute, and secure a database.

This material will benefit users of any current Office version. The classroom environment setup is based on Office 2019.

This course covers Microsoft Office Specialist Program exam objectives to help you prepare for the Access Expert (Office 363 and Office 2019): Exam MO-500 certification.

Today's world runs on data more than ever before and that's a trend not likely to change, or even slow down, any time soon. With the tremendous amount of available data, the ability to make sense of it continues to be an ongoing challenge. You already know how to use Excel to perform simple calculations and modify worksheets to make them easier to read, interpret, and present to others. But Excel is capable of doing so much more.

To gain a truly competitive edge, you need to be able to extract actionable organizational intelligence from your raw data, and present it in a visually compelling format that enables decision makers to view key trends and gain insights. And that's exactly what this course aims to help you do.

Communicating ideas and information is the cornerstone of organizational operations. And, electronic forms of communication have made the transfer of knowledge quick, easy, and inexpensive. The ability to harness the potential of electronic forms of communication is critical in nearly every type of organization. But, in many, if not most, organizations, people work with a wide variety of devices running on a wide variety of platforms. And sometimes, what works well or looks good on one device, won't work at all on another device. Or, your carefully designed and formatted document may end up looking like a jumbled mess on someone else's computer. So, how do you balance the need to communicate ideas to large groups of people with the enormous diversity found in today's electronic devices? The answer: you don't have to because Adobe® created the Portable Document Format (PDF) as a solution to incompatible document formats.

Adobe® Acrobat® Pro DC puts the power of the Portable Document Format, literally, at your fingertips. By taking advantage of the functionality and features available in Acrobat, you will ensure the integrity of your electronic documents regardless of who views them, on what devices, or with what operating systems. And that will give you the confidence and peace of mind that comes with knowing that what you meant to communicate is what your document recipients will see.

Email has become one of the most widely used methods of communication, whether for personal or business communications. In most organizations, large or small, email is the preferred form of communicating information amongst employees. As email grows in popularity and use, most organizations have found the need to implement a corporate mail management system such as Microsoft® Office Outlook® to handle the messages and meeting invitations sent among employees.

In this course, you will use Outlook to send, receive, and manage email messages, manage your contact information, schedule appointments and meetings, create tasks and notes for yourself, and customize the Outlook interface to suit your working style.

This material will benefit users of any current Office version. The classroom environment setup is based on Office 2019.

This course is the first in a series of two Microsoft® Office Outlook® 2019/2024 courses. It will provide you with the basic skills you need to start using Outlook 2019/2024 to manage your email communications, contact information, calendar events, tasks, and notes.

Email has become one of the most widely used methods of communication, whether for personal or business communications. In most organizations, large or small, email is the preferred form of communicating information amongst employees. As email grows in popularity and use, most organizations have found the need to implement a corporate mail management system such as Microsoft® Office Outlook® to handle the messages and meeting invitations sent among employees.

In this course, you will use Outlook to send, receive, and manage email messages, manage your contact information, schedule appointments and meetings, create tasks and notes for yourself, and customize the Outlook interface to suit your working style.

This material will benefit users of any current Office version. The classroom environment setup is based on Office 2019.

This course is the first in a series of two Microsoft® Office Outlook® 2019/2024 courses. It will provide you with the basic skills you need to start using Outlook 2019/2024 to manage your email communications, contact information, calendar events, tasks, and notes.

This course covers Microsoft Office Specialist Program exam objectives to help you prepare for the Outlook Associate (Office 365 and Office 2019): Exam MO-400 certification.

ELK-EB-91-083SG_rev1.2: MS Access 2019-2024–Part 1, Student Edition

Data is everywhere. Most job roles today involve some form of data management. Virtually everyone is affected in some way by the need to manage data. A relational database application such as Microsoft® Office Access® can help you and your organization with this task. This course is the first part of a three-course series that covers the skills needed to perform database design and development in Access.

Microsoft® Office Access® 2019/2024: Part 1 (this course): Focuses on the design and construction of an Access database —viewing, navigating, searching, and entering data in a database, as well as basic relational database design and creating simple tables, queries, forms, and reports.

Microsoft® Office Access® 2019/2024: Part 2: Focuses on optimization of an Access database, including optimizing performance and normalizing data, data validation, usability, and advanced queries, forms, and reports.

Microsoft® Office Access® 2019/2024: Part 3: Focuses on managing the database and supporting complex database designs , including import and export of data, using action queries to manage data, creating complex forms and reports, macros and VBA, and tools and strategies to manage, distribute, and secure a database.

This material will benefit users of any current Office version. The classroom environment setup is based on Office 2019.

This course covers Microsoft Office Specialist Program exam objectives to help you prepare for the Access Expert (Office 363 and Office 2019): Exam MO-500 certification.

Data is everywhere. Most job roles today involve some form of data management. Virtually everyone is affected in some way by the need to manage data. A relational database application such as Microsoft® Office Access® can help you and your organization with this task. This course is the first part of a three-course series that covers the skills needed to perform database design and development in Access.

Microsoft® Office Access® 2019/2024: Part 1 (this course): Focuses on the design and construction of an Access database —viewing, navigating, searching, and entering data in a database, as well as basic relational database design and creating simple tables, queries, forms, and reports.

Microsoft® Office Access® 2019/2024: Part 2: Focuses on optimization of an Access database, including optimizing performance and normalizing data, data validation, usability, and advanced queries, forms, and reports.

Microsoft® Office Access® 2019/2024: Part 3: Focuses on managing the database and supporting complex database designs , including import and export of data, using action queries to manage data, creating complex forms and reports, macros and VBA, and tools and strategies to manage, distribute, and secure a database.

This material will benefit users of any current Office version. The classroom environment setup is based on Office 2019.

This course covers Microsoft Office Specialist Program exam objectives to help you prepare for the Access Expert (Office 363 and Office 2019): Exam MO-500 certification.

Your training and experience using Microsoft® Office Access® has given you basic database management skills, such as creating tables, designing forms and reports, and building queries. In this course, you will expand your knowledge of relational database design; promote quality input from users; improve database efficiency and promote data integrity; and implement advanced features in tables, queries, forms, and reports. Extending your knowledge of Access will result in a robust, functional database for your users.

This course is the second part of a three-course series that covers the skills needed to perform database design and development in Access 2019/2024.

• Microsoft® Office Access® 2019/2024: Part 1: Focuses on the design and construction of an Access database —viewing, navigating, searching, and entering data in a database, as well as basic relational database design and creating simple tables, queries, forms, and reports.
• Microsoft® Office Access® 2019/2024: Part 2 (this course): Focuses on optimization of an Access database, including optimizing performance and normalizing data; data validation; usability; and advanced queries, forms, and reports.
• Microsoft® Office Access® 2019/2024: Part 3: Focuses on managing the database and supporting complex database designs , including import and export of data; using action queries to manage data; creating complex forms and reports; macros and Visual Basic for Applications (VBA); and tools and strategies to manage, distribute, and secure a database.

This material will benefit users of any current Office version. The classroom environment setup is based on Office 2019.

This course covers Microsoft Office Specialist Program exam objectives to help you prepare for the Access Expert (Office 363 and Office 2019): Exam MO-500 certification.

Your training and experience using Microsoft® Office Access® has given you basic database management skills, such as creating tables, designing forms and reports, and building queries. In this course, you will expand your knowledge of relational database design; promote quality input from users; improve database efficiency and promote data integrity; and implement advanced features in tables, queries, forms, and reports. Extending your knowledge of Access will result in a robust, functional database for your users.

This course is the second part of a three-course series that covers the skills needed to perform database design and development in Access 2019/2024.

• Microsoft® Office Access® 2019/2024: Part 1: Focuses on the design and construction of an Access database —viewing, navigating, searching, and entering data in a database, as well as basic relational database design and creating simple tables, queries, forms, and reports.
• Microsoft® Office Access® 2019/2024: Part 2 (this course): Focuses on optimization of an Access database, including optimizing performance and normalizing data; data validation; usability; and advanced queries, forms, and reports.
• Microsoft® Office Access® 2019/2024: Part 3: Focuses on managing the database and supporting complex database designs , including import and export of data; using action queries to manage data; creating complex forms and reports; macros and Visual Basic for Applications (VBA); and tools and strategies to manage, distribute, and secure a database.

This material will benefit users of any current Office version. The classroom environment setup is based on Office 2019.

This course covers Microsoft Office Specialist Program exam objectives to help you prepare for the Access Expert (Office 363 and Office 2019): Exam MO-500 certification.