Excel is a powerhouse spreadsheet software used by companies small and large. Master this popular platform by completing the Excel 2016 - Part 3 course from New Horizons. This advanced Excel course builds off learnings from Excel 2016 - Parts 1 & 2 and prepares you to complete difficult Excel tasks such as LOOKUPS, macros and more. The course also covers Microsoft Office Specialist exam objectives to help you prep for the certification exam. This course may earn a Credly Badge.

Organizations the world over rely on information to make sound decisions regarding all manner of affairs. But with the amount of available data growing on a daily basis, the ability to make sense of all of that data is becoming more and more challenging. Fortunately, this is where the power of Microsoft Excel can help. Excel can help you organize, calculate, analyze, revise, update, and present your data in ways that will help the decision makers in your organization steer you in the right direction. It will also make these tasks much easier for you to accomplish, and in much less time, than if you used traditional pen-and-paper methods or non-specialized software. This course aims to provide you with a foundation for Excel knowledge and skills.

In this course, students will use Microsoft® Office Excel® 2013 to create spreadsheets and workbooks that they can use to store, manipulate, and share data.

This course aims to provide you with a foundation for Excel knowledge and skills, which you can build upon to eventually become an expert in data manipulation. Excel can help you organize, calculate, analyze, revise, update, and present your data in ways that will help the decision makers in your organization steer you in the right direction. It will also make these tasks much easier for you to accomplish, and in much less time, than if you used traditional pen-and-paper methods or non-specialized software.

Are you looking to become a proficient Excel user? Professional Excel training from New Horizons can get you on the path to mastering this popular data spreadsheet software. Through completing the introductory Excel 2016 training course, you’ll develop foundational data manipulation knowledge and skills that you can build upon through additional training and use. With the Excel 2016 - Part 1 course under your belt, you’ll feel confident using one of the world’s most powerful applications. This course may earn a Credly Badge.

Start your prep for the MO-200 exam with the Microsoft Excel 2019 course and lab. The lab is cloud-based, device-enabled, and can easily be integrated with an LMS. The Microsoft Excel certification course and labs thoroughly cover the MO-200 exam objectives and provide the ability to create and edit a workbook with multiple sheets and use a graphic element to represent data visually. The study guide provides hands-on learning on the basic and advanced concepts covered in the Microsoft Excel certification exam.

Technology and the data that it both collects and makes accessible is now interwoven with businesses and lives. The era of "big data" has exploded due to the rise of cloud computing, which provides an abundance of computational power and storage, enabling organizations of all sorts to capture and store data. Leveraging that data effectively can provide timely insights and competitive advantage. Analyzing data to find issues, insights, and opportunities is now a critical part of many job roles. Beyond the analysis, data analysts in all job roles must be able to effectively present and communicate their findings in visually compelling ways. Microsoft Excel is designed for this purpose. Excel can connect to a wide range of data sources, perform robust data analysis, and create diverse and robust data-driven visualizations to show insights and trends, as well as create reports. These capabilities enable people who use Excel for data analysis to turn data into thoughtful action.

You’ve mastered the basics of Excel. In Excel 2016 - Part 2 training, you’ll build upon your data manipulation skills and unlock more capabilities within the platform. Deepen your understanding of Excel by learning how to create advanced workbooks and worksheets. With Part 2 training from New Horizons under your belt, you’ll be ready to create custom formulas, apply built-in Excel functions and manipulate data to extract the insights you need. This course may earn a Credly Badge.

This course builds upon the foundational and intermediate knowledge presented in the Microsoft Office Excel 2019: Part 1 and Microsoft Office Excel 2019: 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 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.

Organizations the world over rely on information to make sound decisions regarding all manner of affairs. But with the amount of available data growing on a daily basis, the ability to make sense of all of that data is becoming more and more challenging. Fortunately, Microsoft Office Excel 2021 can help you organize, calculate, analyze, revise, update, and present your data in ways that will help the decision makers in your organization steer you in the right direction. This course aims to provide you with a foundation for Excel knowledge and skills, which you can build upon to eventually become an expert in data manipulation. This course covers Microsoft Office Specialist Program exam objectives to help you prepare for the Excel Associate (Office 365 and Office 2021): Exam MO-200 and Excel Expert (Office 365 and Office 2021): Exam MO-201 certifications. This course may earn a Credly Badge.

VBA (Visual Basic for Applications) enables you to enhance and extend the capabilities of Microsoft Excel and other applications in the Microsoft 365 application suite. You can use VBA to perform tasks that would be difficult or impossible to do using only worksheet functions, and you can automate a wide range of tasks so they can be performed faster, more consistently, and with less effort than performing them manually. This course will give you a good foundation for understanding, creating, and using VBA in your own Excel workbooks. You will learn how to use the macro recorder effectively, as well as how to write your own VBA code from scratch. You will use tools built into Excel to explore and learn VBA's capabilities and to optimize and debug your code.

Use the Data Analysis and Visualization with Excel course and lab to learn the skills of excel data visualization. The course and lab provide knowledge and skills required for analyzing data with formulas and functions; analyzing data with PivotTables, presenting visual insights with dashboards in excel, and many more. This course also provides knowledge related to analyzing data with the data analysis ToolPak, connecting to Data with Queries and many more.

This course builds upon the foundational knowledge presented in the Microsoft Office Excel 2019: 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.

VBA (Visual Basic for Applications) enables you to enhance and extend the capabilities of Microsoft Excel and other applications in the Microsoft 365 application suite. You can use VBA to perform tasks that would be difficult or impossible to do using only worksheet functions, and you can automate a wide range of tasks involving the collection, processing, analysis, and visualization of data. This course will give you a good foundation for understanding, creating, and using VBA in your own Excel workbooks, show you how to work with data across different applications, and how to package the macros and functions you create so you can back them up, move them to other computers, and share them with other users.

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.

Advances in technology have made it possible to store ever-increasing amounts of data. Along with this, the need to analyze that data and gain actionable insight is greater than ever. Participants already have experience working with Excel and creating basic PivotTables to summarize data. But Excel is capable of doing much more. Being able to harness the power of advanced PivotTable features and create PivotCharts will help participants gain a competitive edge. Participants will not only be able to summarize data to analyze, but also organize the data in a way that can be meaningfully presented to others. This leads to data-driven business decisions that have a better chance for success for everyone involved.

Being able to harness the power of PivotTable features & create PivotCharts will help students gain an edge. Not only will students be able to summarize data to analyze, but they can organize the data in a way that can be meaningfully presented to others.

This course builds upon the foundational knowledge presented in the Microsoft Office Excel 2016: Part 1 (Desktop/Office 365) or Microsoft Office Excel 2019: Part 1 courses and will help start participants down the road to creating advanced workbooks and worksheets that participants can use to create dashboards. The ability to analyze massive amounts of data, extract actionable intelligence from it, and present that information to decision makers is the cornerstone of driving a successful organization that is able to compete at a high level.

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 and a need to properly manage it. This course will empower you to analyze large amounts of data quickly using Power Pivot in Microsoft Excel. You will understand how to organize, manipulate, and report on your data in the best way possible. A tool is only as good as the person using it and this course will help you gain a solid understanding of Power Pivot to maximize your effectiveness when analyzing data. This course presents information and skills that are appropriate for users of Office 365 applications.

This course builds upon the foundational knowledge presented in the Microsoft Office Excel 2021: 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. This course covers Microsoft Office Specialist Program exam objectives to help you prepare for the Excel Associate (Office 365 and Office 2021): Exam MO-200 and Excel Expert (Office 365 and Office 2021): Exam MO-201 certifications. This course may earn a Credly Badge.

This course builds upon the foundational and intermediate knowledge presented in the Microsoft Office Excel 2021: Part 1 and Microsoft Office Excel 2021: 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. This course covers Microsoft Office Specialist Program exam objectives to help you prepare for the Excel Associate (Office 365 and Office 2021): Exam MO-200 and Excel Expert (Office 365 and Office 2021): Exam MO-201 certifications. This course may earn a Credly Badge.

Advances in technology have made it possible to store ever-increasing amounts of data. Along with this, the need to analyze data and gain actionable insight is greater than ever. You already have experience working with Microsoft Excel and creating basic PivotTables to summarize data. But Excel is capable of doing much more. Being able to harness the power of advanced PivotTable features and create PivotCharts will help you to gain a competitive edge. You will not only be able to summarize data for you to analyze, but also organize the data in a way that can be meaningfully presented to others. This leads to data-driven business decisions that have a better chance for success for everyone involved. This course presents information and skills that are appropriate for users of either the Office 2021 or Office 365 applications. However, the instructional environment for the delivery of this course utilizes Office 365. This course may earn a Credly Badge.

Clearly, you use Microsoft Excel a lot in your role. Otherwise, you wouldn't be taking this course. By now, you're already familiar with Excel, 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.

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

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 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 so much more.

As a customer service representative, you are expected to handle customer interactions in the best way possible. The expectations of both your company and your customers hinge on your ability to provide the right service in the right way. In this course, you will explore the background and techniques of customer interactions. Providing quality customer care ensures that every single contact with your company is a positive experience.

In this course, students are enabled to transform Excel workbooks into captivating dashboards for executives and business users.

R is a functional programming environment for business analysts and data scientists. It's a language that many non-programmers can easily work with, naturally extending a skill set that is common to high-end Excel users. It's the perfect tool for when the analyst has a statistical, numerical, or probabilities-based problem based on real data and they've pushed Excel past its limits. This course is a comprehensive hands-on look at the common scenarios encountered in analysis and presents practical solutions. In this course, special attention is paid to data science theory including AI grouping theory. A discussion of using R with AI libraries like Madlib are included.

The Microsoft Office 365 certification course offers interactive learning resources that help candidates learn how to use Office 365 application's different tools, including Outlook, OneDrive, Word, Excel, PowerPoint, OneNote, SharePoint, Microsoft Teams, Yammer, and more. The office 365 training course is targeted at professionals who have never worked with Office 365 before, or who have yet to move beyond its basic functions.

In this course, students will learn all of the key reporting skills and some planning skills that apply to both the SAP Business Planning and Consolidation, version for SAP NetWeaver and version for the Microsoft platform.

This three-day instructor-led course is about writing TSQL queries for the purpose of database reporting, analysis, and business intelligence. Specifically, this course presents TSQL within the context of data analysis in other words, making meaning from the data rather than transaction-oriented data-tier application development. The course starts with a brief discussion of levels of measurement and quantitative research methodogy, and integrates these concepts into each TSQL topic presented. The goal is to provide a consistent, direct, and purposeful learning path from RDBMS data retrieval through analytical tools such as SQL Server Reporting Services, PowerBI, Excel, R, SAS, and SPSS.

Organizations use reporting tools to access data sources and generate customized reports. SAP Crystal Reports 2020 enhances report building and report processing techniques with a variety of features that add value to a presentation. In this course, you will create a basic report by connecting to a database and modifying the report's presentation. Information is critical to making sound business decisions. Data presented without any formatting or structure holds little or no meaning for interpretation. Crystal Reports 2020 helps you build advanced reports with ease, presenting complex information in an understandable way. This course may earn a Credly Badge.

In this course, students will create a basic report by connecting to a database and modifying the report's presentation. This course may earn a Credly Badge.

The role of Data Analyst is more critical than ever. Central to an organization’s success, Data Analysts gather and report on data that helps drive project outcomes and influences business decisions. New Horizons Learning Journeys are prescribed training paths that provide the skills and competencies required to successfully perform specific job roles. The Data Analyst Learning Journey Foundation path provides the important first steps, from intermediate Excel to introductory Power Platform to essential Communication competencies, that can enhance the skill sets of individuals and teams.

The role of Data Analyst is more critical than ever. Central to an organization’s success, Data Analysts gather and report on data that helps drive project outcomes and influences business decisions. New Horizons Learning Journeys are prescribed training paths that provide the skills and competencies required to successfully perform specific job roles. The Data Analyst Learning Journey Foundation path provides the important first steps, from intermediate Excel to introductory Tableau to essential Communication competencies, that can enhance the skill sets of individuals and teams.

This course is designed to introduce you to advanced parallel job data processing techniques in DataStage v11.5. In this course you will develop data techniques for processing different types of complex data resources including relational data, unstructured data (Excel spreadsheets), and XML data. In addition, you will learn advanced techniques for processing data, including techniques for masking data and techniques for validating data using data rules. Finally, you will learn techniques for updating data in a star schema data warehouse using the DataStage SCD (Slowly Changing Dimensions) stage. Even if you are not working with all of these specific types of data, you will benefit from this course by learning advanced DataStage job design techniques, techniques that go beyond those utiliz

To maximize performance and foster a healthy environment, senior managers must also motivate others, nurturing and utilizing the distinctive skills of each team member. This course may earn a Credly Badge.

In this course, students practice skills and apply principles for providing face-to-face customer service to customers with technical issues.

In this course, you will apply important principles and skills you can use as a customer service professional. In addition to providing basic customer service, you'll also learn important principles and skills that will empower you to solve difficult and challenging customer interactions, encourage further sales, and take on leadership responsibilities. This course may earn a Credly Badge.

In this course, students learn the basic functions and navigation options of the Analysis edition for Microsoft Office. Students will also learn the special functions and layout design options of Analysis.

Gain hands-on experience to pass the IC3 certification exam with the Key Applications (IC3 GS5 Exam 2) course and lab. The lab provides a hands-on learning experience in a safe and online environment. This IC3 exam guide completely covers IC3 GS5 Key Applications exam objectives and includes topics such as exploring common application features in Microsoft Access, using Microsoft Word, Excel, PowerPoint, and Access, collaborating with others when working in Microsoft Office, and so on.

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. 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 this course, you learned the basic skills needed to create and modify various Visio drawings. In Microsoft Visio 2019: Part 2, you will learn about more advanced features—making you a more efficient and effective Visio user. This material will benefit users of any current Office version. This course may earn a Credly Badge.

This course introduces working with shared documents in the familiar Office 365 online apps—Word, PowerPoint, and Excel—as an alternative to installing the Microsoft Office desktop applications. This course also introduces several productivity apps including Yammer, Planner, and Delve that can be used in combination by teams for communication and collaboration.

In our fast-paced digital world, the need to capture ideas, meeting notes, and to-do items is ever present. Microsoft® Office OneNote for the Desktop provides a way for you to efficiently create and collect your notes in an electronic notebook. This course will introduce you to using OneNote notebooks to store a wide variety of content in an organized structure, access the content from anywhere, and also share it with others. Additionally, learning how OneNote and the other applications in the suite are integrated increases your productivity with Microsoft Office. This courseware is applicable to all users of the current OneNote desktop software. The classroom environment setup is based on the Office 2016 desktop application.

This is a lab intensive, hands-on course that provides participants with an excellent foundation for their automation journey, with a special focus on one of the most popular RPA tools: UiPath. Robotic Process Automation takes you on a journey from understanding the basics of RPA to advanced implementation techniques. You will become oriented in the UiPath interface and learn about its workflow. Once you are familiar with the environment, we will get hands-on with automating different applications such as Excel, SAP, Windows and web applications, screen and web scraping, working with user events, as well as understanding exceptions and debugging. By the end of the course, you'll not only be able to build your first software bot, but also, you'll wire it to perform various automation tasks with the help of best practices for bot deployment.

In our fast-paced digital world, the need to capture ideas, meeting notes, and to-do items is ever present. Microsoft's OneNote app provides a way for you to efficiently create and collect your notes in an electronic notebook. This course will help you use OneNote notebooks to store a wide variety of content in an organized structure, access the content from anywhere, and also share it with others. Additionally, learning how OneNote and other applications in the Microsoft 365 suite are integrated will increase your productivity.

This course is about writing TSQL queries for the purpose of database reporting, analysis, and business intelligence.

In Microsoft Visio 2016 : Part 2, students will learn about more advanced features, making themselves more efficient and effective as a Visio user. This course may earn a Credly Badge.

Candidates for this course automate time-consuming and repetitive tasks by using Microsoft Power Automate. They review solution requirements, create process documentation, and design, develop, troubleshoot, and evaluate solutions. Candidates work with business stakeholders to improve and automate business workflows. They collaborate with administrators to deploy solutions to production environments, and they support solutions.

This course guides students through the fundamentals of using IBM SPSS Statistics for typical data analysis. Students will learn the basics of reading data, data definition, data modification, data analysis, and presentation of analytical results. In addition to the fundamentals, students will learn shortcuts that will help them save time. This course uses the IBM SPSS Statistics Base; one section presents an add-on module, IBM SPSS Custom Tables.