Information Technology Training Classes and Seminars In Winnipeg, MB

For an optimal experience with this course, we recommend Excel 2016 and later. Windows platform preferred....

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

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 Associate (ACA) Print & Digital Media Publication Using Adobe InDesign CC exam....

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 the fundamentals of SQL querying will help you ask the right questions and know what you're looking for in your data analysis tools. Organizations use large SQL databases to store information about clients, products, or sales. However, that data is locked into those databases until it is accessed by a business intelligence tool such as Power BI, Tableau or Crystal Reports. With the proper permissions, analysts can use SQL to select the data they need for additional analysis and reporting. This class, SQL - Fundamentals of Querying, provides an overview of the SQL commands that can be used to access that data....

Until now, you have used SAP® Crystal Reports® to build and modify reports. You want to use the advanced functionality of Crystal Reports to generate reports in the format you desire. In this course, you will create complex reports and data sources using the tools in Crystal Reports 2020. You will not only create more sophisticated reports, including subreports and cross-tabs, but you will also increase the speed and efficiency of your reports by using SQL queries. Even though you are familiar with Crystal Reports, you may take some time to study its various tools that enable you to generate reports with the desired data using advanced methods such as SQL querying. This way, you won't be slowed down by large databases or databases with which you are unfamiliar. By creating subreports, cross-tabs, and running totals, you will turn raw data into meaningful, customized reports that will help your business run more smoothly. If you work with large databases, you may find yourself faced with performance issues. In this course, you will also learn to use tools that can increase the speed with which data is retrieved....

This interactive workshop explains common SQA misconceptions and the six functions SQA should perform to provide far greater value, analyzes why SQA groups so frequently have failed in IS, and presents practical approaches for successfully using SQA effectively throughout any life cycle to produce high quality systems. Because some distinguish SQA as reviewing documents vs. testing’s executing code, key concepts and techniques are presented for reviewing requirements and designs. And, because some still expect an SQA course to be about testing, half of this class does describe testing content more briefly than in our Effective Methods of Software Testing Workshop....

This five-day instructor-led course is intended for IT professionals who wish to use the Transact-SQL language to query and configure Microsoft SQL Server. Students are typically database developers and database administrators, but might also be Business Intelligence developers, report creators, or application developers. In this course, students learn how to query single tables, join data from multiple tables, filter and sort data, modify data, use procedures and functions, and implement error handling....

Microsoft® SharePoint®, in conjunction with the Microsoft 365 suite of productivity and office automation tools, 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. By default, SharePoint provides end users with a generous set of permissions, enabling users to create and customize their own sites as site owners, and create and collaborate on team site content. Users who have grown comfortable with these fundamental content-authoring capabilities may want to move on to more advanced features, such as connecting multiple SharePoint sites through a hub, importing list data from external sources, implementing user input validation features, applying conditional formatting, and using Power Apps® to provide custom user interfaces for data collected in SharePoint. This course focuses on issues related to planning and implementing an intranet with multiple communication sites and team sites interconnected through a hub site to provide unified navigation search, and formatting....

In many professional environments, people work collaboratively in teams. Information technology and applications facilitate this by enabling people to easily share, access, edit, and save information. Microsoft® SharePoint® is a platform specifically designed to facilitate communication and collaboration, enabling people to use familiar applications and web-based tools to create, access, store, and track documents and data in a central location. In this course, you will use SharePoint to access, store, share, and collaborate with information and documents....

240 Hours of training. Master key tools like TSQL, Python, Tableau, and more to enhance your data analytics expertise. Gain valuable insights and career advice through networking with industry experts and mentorship opportunities. Learn to identify gaps and innovate solutions, enhancing product development and business processes. Acquire skills in real-time optimization to predict and react optimally to various business scenarios. Benefit from 12 weeks of instructor...

The new version 8.0 of MySQL added a significant number of administrative features to the MySQL database including improved error logging, password policies, privileges, accounts, and backup and recovery. Students will perform these administration functions using the MySQL workbench and command line utilities during the course of training. The course may be taken by itself as a one day course of training or as a four day course which includes the topics from this course and the topics from the three day Querying MySQL course....

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. In this course, you will create visually engaging diagrams, maps, and drawings, using graphical elements to make information easier to comprehend....

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 Visio® Introduction, you learned the basic skills needed to create and modify various Visio drawings. In Visio® Advanced, you will learn about more advanced features—making you a more efficient and effective Visio user....

This 3-day course is designed as an introduction to HTML and CSS for those who want to learn to develop standards-compliant web content, with a focus on current HTML5 and CSS3 standards. It focuses on the features of HTML5, covering how to create HTML5 and CSS3 markup that will work well on the widest possible variety of web browsers....

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 is a deep dive course for experienced Java programmers who are looking to take their Java skills to the next professional level. Students will learn: object-oriented design principles; how to make best use of Java libraries; multithreading and concurrent processing; Network, Java GUI, and Functional programming; advanced data processing; and the best design and programming practices....

Welcome to Using Microsoft® Windows® 10. Whether you’re new to computers or have used them in the past, this class will help you become more comfortable using a personal computer (PC) and, more specifically, the Windows 10 interface. This course will help you to define what a PC is, and familiarize you with the Windows 10 user interface and its basic capabilities. In this course, you will explore Windows 10 and learn how to create documents, send email, browse the Internet, and share information between applications and with other users....

With its focus on iterative and incremental approach to project development, Agile is becoming the preferred project management methodology in many industries. While our PMI-ACP® course will help you pass the Agile certification exam, our Agile in Action course focuses on applying Agile principles in your every day work, to help you be better prepared to use these concepts to improve project success and efficiency. This course will focus on critical components of Agile project management and will go beyond PMI-ACP® content by addressing areas most important for project managers to get right. Learners will gain an understanding of best practices, discuss project issues incurred and identify potential solutions. This is an interactive course where participants will provide insight on best practices and learn from each other. Note: This course has been approved by PMI for 5 PDUs....

Discover the powerful mail merge feature from Outlook to quickly build customized emails, labels, and letters. Create and set up data files from scratch or connect to names in Excel or Outlook.?...

Explore how to quickly locate email messages. Learn to use advanced efficiency features of Outlook.

In this 5-day course, professional web developers will learn to develop advanced ASP.NET Core applications using .NET tools and technologies. The focus will be on coding activities that enhance the performance and scalability of the Web site application....

This course covers fundamental AWS cloud security concepts, including AWS access control, data encryption methods, and how network access to your AWS infrastructure can be secured. Based on the AWS Shared Security Model, you learn where you are responsible for implementing security in the AWS Cloud and what security-oriented services are available to you and why and how the security services can help meet the security needs of your organization....

As data acquisition, access, analysis, and reporting are interwoven with our businesses and lives, more and more data is collected about business and personal activities. This abundance of data and the computing power to analyze it has increased the use of data analysis and data visualization across a broad range of job roles. Decision makers of all types, including managers and executives, must interact with, interpret, and develop reports based on data and analysis provided to them. Microsoft Power BI software is designed for data analysis and the creation of visualizations. Data analysts prepare data, perform initial analysis, and create visualizations that are then passed to business data decision makers. These decision makers can use Power BI's tools to explore the data, perform further analysis to find new insights, make decisions, and create customized reports to share their findings....

Modern organizations depend heavily on the web to perform core business operations such as marketing, advertising, and selling products, providing services, and communicating with customers, partner organizations, and employees. Whatever you're creating on the web, HTML, CSS, and JavaScript™ likely play an important role. These three languages provide the core toolkit for anyone looking to perform web development work. This course covers the fundamentals of web development using these three languages....