Clearly, you use Excel a lot in your role. Otherwise, you wouldn't be taking this course. By now, you're already familiar with Microsoft® Office Excel® 2021, its functions and formulas, a lot of its features and functionality, and its powerful data analysis tools. You are likely called upon to analyze and report on data frequently, work in collaboration with others to deliver actionable organizational intelligence and keep and maintain workbooks for all manner of purposes. At this level of use and collaboration, you have also likely encountered your fair share of issues and challenges. You're too busy, though, to waste time scouring over workbooks to resolve issues or to perform repetitive, monotonous tasks. You need to know how to get Excel to do more for you so you can focus on what's really important: staying ahead of the competition. That's exactly what this course aims to help you do.

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

This course builds upon the foundational and intermediate knowledge presented in the Microsoft® Office Excel® 2021-2024: Part 1 and Microsoft® Office Excel® 2021-2024: Part 2 courses to help you get the most of your Excel experience. The ability to collaborate with colleagues, automate complex or repetitive tasks, and use conditional logic and dynamic arrays to construct and apply elaborate formulas and functions will put the full power of Excel right at your fingertips. The more you learn about how to get Excel to do the hard work for you, the more you'll be able to focus on getting the answers you need from the vast amounts of data your organization generates.

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 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 enables you to output your content so your audience will be able to access and view the document just the way you intended.

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 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 enables you to output your content so your audience will be able to access and view the document just the way you intended.

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 puts the power of the Portable Document Format, literally, at your fingertips. By taking advantage of the functionality and features available in Acrobat's new-experience interface, 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.

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 puts the power of the Portable Document Format, literally, at your fingertips. By taking advantage of the functionality and features available in Acrobat's new-experience interface, 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.

This course is one of a series of Element K courseware titles that addresses Microsoft Office Specialist (MOS) certification skill sets. The MOS and certification program is for individuals who use Microsoft's business desktop software and who seek recognition for their expertise with specific Microsoft products

Clearly, you use Excel a lot in your role. Otherwise, you wouldn't be taking this course. By now, you're already familiar with Microsoft® Office Excel® 2021, its functions and formulas, a lot of its features and functionality, and its powerful data analysis tools. You are likely called upon to analyze and report on data frequently, work in collaboration with others to deliver actionable organizational intelligence and keep and maintain workbooks for all manner of purposes. At this level of use and collaboration, you have also likely encountered your fair share of issues and challenges. You're too busy, though, to waste time scouring over workbooks to resolve issues or to perform repetitive, monotonous tasks. You need to know how to get Excel to do more for you so you can focus on what's really important: staying ahead of the competition. That's exactly what this course aims to help you do.

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

This course builds upon the foundational and intermediate knowledge presented in the Microsoft® Office Excel® 2021-2024: Part 1 and Microsoft® Office Excel® 2021-2024: Part 2 courses to help you get the most of your Excel experience. The ability to collaborate with colleagues, automate complex or repetitive tasks, and use conditional logic and dynamic arrays to construct and apply elaborate formulas and functions will put the full power of Excel right at your fingertips. The more you learn about how to get Excel to do the hard work for you, the more you'll be able to focus on getting the answers you need from the vast amounts of data your organization generates.

In today's business environment, data is an abundant raw material, and successful organizations have found ways to extract insights from the data. With the abundance of computational power and storage, organizations and employees with many different roles and responsibilities can benefit from analyzing data to find timely insights and gain competitive advantage.

Whether you need to crunch numbers for sales, inventory, information technology, human resources, or other organizational purposes and departments, the ability to get the right information to the right people at the right time can create a powerful competitive advantage. After all, the world runs on data more than ever before and that's a trend not likely to change, or even slow down, any time soon. But with so much data available and being created on a nearly constant basis, the ability to make sense of that data becomes more critical and challenging with every passing day. You already know how to get Microsoft® Office Excel® to perform simple calculations and how to modify your workbooks and 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. In other words, when you have questions about your data, you need to know how to get Excel to provide the answers for you. And that's exactly what this course aims to help you do.

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

This course builds upon the foundational knowledge presented in the Microsoft® Office Excel® 2021-2024: Part 1 course and will help start you down the road to creating advanced workbooks and worksheets that can help deepen your understanding of organizational intelligence. The ability to analyze massive amounts of data, extract actionable information from it, and present that information to decision makers is at the foundation of a successful organization that is able to compete at a high level.

Whether you need to crunch numbers for sales, inventory, information technology, human resources, or other organizational purposes and departments, the ability to get the right information to the right people at the right time can create a powerful competitive advantage. After all, the world runs on data more than ever before and that's a trend not likely to change, or even slow down, any time soon. But with so much data available and being created on a nearly constant basis, the ability to make sense of that data becomes more critical and challenging with every passing day. You already know how to get Microsoft® Office Excel® to perform simple calculations and how to modify your workbooks and 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. In other words, when you have questions about your data, you need to know how to get Excel to provide the answers for you. And that's exactly what this course aims to help you do.

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

This course builds upon the foundational knowledge presented in the Microsoft® Office Excel® 2021-2024: Part 1 course and will help start you down the road to creating advanced workbooks and worksheets that can help deepen your understanding of organizational intelligence. The ability to analyze massive amounts of data, extract actionable information from it, and present that information to decision makers is at the foundation of a successful organization that is able to compete at a high level.

Welcome to PMP® Certification: Passing the 2021 Exam. This course provides the basic knowledge needed to learn the concepts and skills necessary to pass the 2021 Project Management Professional (PMP) exam administered by the Project Management Institute (PMI). It is intended to be used alongside the PMBOK® Guide, Sixth Edition, which is useful as an ancillary reference and glossary.

The new release of this course (R2.0) includes a new chapter on agile approaches to, and tools for, the project life cycle. These methods address projects that require an adaptive project environment, iterative activities, and changing requirements. The standard example of adaptive project needs is that of software development and revision; however, agile methods are used today in many different project environments, from architecture to medical equipment and services. The new chapter (Managing projects with agility) was inserted at the end of the book. There were no other changes to the rest of the content, including the Exam Prep add-on.

This course assumes that you have project management and other educational experience, as required by PMI, in order to take the exam. In addition, it’s expected either that you have already applied to take the exam, or that you plan to do so while taking this course or shortly thereafter; this course contains instructions for doing so.

Welcome to PMP® Certification: Passing the 2021 Exam. This course provides the basic knowledge needed to learn the concepts and skills necessary to pass the 2021 Project Management Professional (PMP) exam administered by the Project Management Institute (PMI). It is intended to be used alongside the PMBOK® Guide, Sixth Edition, which is useful as an ancillary reference and glossary.

The new release of this course (R2.0) includes a new chapter on agile approaches to, and tools for, the project life cycle. These methods address projects that require an adaptive project environment, iterative activities, and changing requirements. The standard example of adaptive project needs is that of software development and revision; however, agile methods are used today in many different project environments, from architecture to medical equipment and services. The new chapter (Managing projects with agility) was inserted at the end of the book. There were no other changes to the rest of the content, including the Exam Prep add-on.

This course assumes that you have project management and other educational experience, as required by PMI, in order to take the exam. In addition, it’s expected either that you have already applied to take the exam, or that you plan to do so while taking this course or shortly thereafter; this course contains instructions for doing so.

Organizations typically store their most critical information—the information used to manage day-to-day operations—within a database. The ability to retrieve and analyze this information is essential to the functioning of the organization. Structured Query Language (SQL) is the primary language used to accomplish such tasks. Essentially, SQL is the language you use to interact with a database.

The ability to write SQL is an essential job skill for those who need to manage large volumes of data, produce reports, mine data, or combine data from multiple sources. Even if someone else on your team creates reports for you, having a fundamental understanding of SQL querying will help you ask the right questions and know what you're looking for in your data analysis tools.

This course, SQL Querying: Fundamentals (Third Edition), will teach you to use SQL as a tool to retrieve the information you need from databases.

Organizations typically store their most critical information—the information used to manage day-to-day operations—within a database. The ability to retrieve and analyze this information is essential to the functioning of the organization. Structured Query Language (SQL) is the primary language used to accomplish such tasks. Essentially, SQL is the language you use to interact with a database.

The ability to write SQL is an essential job skill for those who need to manage large volumes of data, produce reports, mine data, or combine data from multiple sources. Even if someone else on your team creates reports for you, having a fundamental understanding of SQL querying will help you ask the right questions and know what you're looking for in your data analysis tools.

This course, SQL Querying: Fundamentals (Third Edition), will teach you to use SQL as a tool to retrieve the information you need from databases.

ELK-EB-94-029IG_rev1.0: SQL Querying–Fundamentals (Third Edition), Instructor Edition 

Organizations typically store their most critical information—the information used to manage day-to-day operations—within a database. The ability to retrieve and analyze this information is essential to the functioning of the organization. Structured Query Language (SQL) is the primary language used to accomplish such tasks. Essentially, SQL is the language you use to interact with a database.

The ability to write SQL is an essential job skill for those who need to manage large volumes of data, produce reports, mine data, or combine data from multiple sources. Even if someone else on your team creates reports for you, having a fundamental understanding of SQL querying will help you ask the right questions and know what you're looking for in your data analysis tools.

ELK-EB-94-029SG_rev1.0: SQL Querying–Fundamentals (Third Edition), Student Edition 

Organizations typically store their most critical information—the information used to manage day-to-day operations—within a database. The ability to retrieve and analyze this information is essential to the functioning of the organization. Structured Query Language (SQL) is the primary language used to accomplish such tasks. Essentially, SQL is the language you use to interact with a database.

The ability to write SQL is an essential job skill for those who need to manage large volumes of data, produce reports, mine data, or combine data from multiple sources. Even if someone else on your team creates reports for you, having a fundamental understanding of SQL querying will help you ask the right questions and know what you're looking for in your data analysis tools.

Successfully managing a project requires effective planning and adherence to the industry's best practices in every step of the process. By mastering the fundamentals of project management, you will be better prepared to initiate a project in your organization and position it for success. In this course, you will identify effective project management practices and their related processes.

Microsoft® SharePoint®, in conjunction with the Microsoft 365™ productivity and office automation suite, provides tools to create and manage a corporate intranet, facilitate content sharing and collaboration, and enable users to create, access, store, and track documents and data in a central location.

Users who already have experience as SharePoint site members and owners may be ready to move on to more advanced site-building tasks such as using custom site templates, custom themes, applying advanced permissions settings, improving security, and preparing sites to support governance and compliance.

Advanced site builders may be ready to undertake more advanced site management tasks, working in conjunction with their SharePoint Administrator to create and use custom site templates, term sets and metadata, manage information governance and compliance, and get deeper into SharePoint security configuration.