| Course Name |
Hours |
CEUs |
Content |
| 10975 - Introduction to Programming |
35.00 |
3.50 |
|
Description: In this 5-day course, students will learn the basics of computer programming through the use of Microsoft Visual Studio 2013 and either the Visual C or Visual Basic programming languages. The course assumes no prior programming experience and introduces the concepts needed to progress to the intermediate courses on programming, such as 20483B: Programming in C.
The focus will be on core programming concepts such as computer storage, data types, decision structures, and repetition by using loops. The course also covers an introduction to object-oriented programming covering classes, encapsulation, inheritance, and polymorphism. Coverage is also included around exception handling, application security, performance, and memory management.
# of Days:
|
| 55265AC - Microsoft PowerApps |
14.00 |
1.40 |
|
Description: This course delivers an instructor-led breakdown of Microsoft PowerApps. Students will be taught how to design, test and publish new apps that work with a variety of data sources. We will take users through a selection of well-crafted lessons to help them build new applications for their business.
# of Days:
|
| 55268AC - Microsoft Power Automate/Flow for End Users |
7.00 |
0.70 |
|
Description: This course delivers an instructor-led product showcase for Microsoft Flow from start to finish in an engaging and practical way. Flow is a diverse product, turning business processes into automated, consistent and visual workflows. Flow is designed to interweave the various products in Office 365 as well as connect to other on-premises and web-based solutions. This course will give you the confidence to select the right actions and workflow logic for your business workflows.
# of Days:
|
| Access 2016 Level 2 for Windows |
7.00 |
0.70 |
|
Description: Your training and experience using Microsoft Access 2016 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, write advanced queries, structure existing data, validate data entered into a database, and customize reports. Extending your knowledge of Microsoft Access 2016 will result in a robust, functional database for your users. You can also use the course to prepare for the Microsoft Office Specialist (MOS) Certification exam for Microsoft Access 2016. Extending your knowledge of Microsoft Access 2016 will result in a robust, functional database for your users.
At the end of this course, you will have experience creating and managing an Access 2016 database, as well as the following:
Design a relational database.
Join tables to retrieve data from unrelated tables.
Validate data entered into a database.
Use advanced queries to manipulate your data.
Organize a database for efficiency and performance, and to maintain data integrity.
Customize reports to organize the displayed information and produce specific print layouts.
# of Days:
|
| Access 2016 Level 3 for Windows |
7.00 |
0.70 |
|
Description: Youve covered many of the basic functions of Microsoft Office Access 2016, and now youre ready to learn advanced Access features such as database management, advanced form design, packaging a database, encrypting a database, preparing a database for multi-user access, and more. Knowledge of these features separate database professionals from the casual database users or occasional designers.
This training, added to that which youve gained from the Microsoft Office Access 2016 Level 1 and Microsoft Office Access 2016 Level 2 courses, rounds out your Access education and provides you with marketable job skills.
At the completion of this course, you will have learned how to create and manage a fundamental Access 2016 database, as well as the following:
Customize a form layout to improve usability and efficiency of data entry.
Share data across applications.
Use macros to improve user interface design.
Use VBA to enhance tasks.
Organize data into appropriate tables to ensure data dependency and minimize redundancy.
Lock down and prepare a database for distribution to multiple users.
Create and modify a database switchboard and set the startup options.
# of Days:
|
| ArcGIS Fundamentals 10.x |
16.00 |
1.60 |
|
Description: ArcGIS is a powerful and complex tool for viewing and analyzing data. With so much functionality available in the software, it can be difficult to get started. This 2-day class teaches essential skills for being efficient with ArcGIS. Explore GIS data through ArcMap and create maps to illustrate relationships in the data. Learn methods of displaying data with symbols and text. See how to ask questions of the data and get answers.
# of Days:
|
| ArcGIS Intermediate Concepts 10.x |
24.00 |
2.40 |
|
Description: ArcGIS has much more functionality than simple map display and navigation. It has many tools for collecting, creating and analyzing data. This 3-day class teaches finer skills for using ArcGIS. See how to connect information between tables and mark locations on the map. Learn methods for creating complex labels and assigning images to a location on the earth. Practice managing data files, creating new data, and putting the data to work to generate answers to questions.
# of Days:
|
| ArcGIS Pro Intermediate |
24.00 |
2.40 |
|
Description: One of the things that makes ArcGIS so useful is the tremendous amount of data available to map and analyze. In this course, you will learn to find, connect to, create, manage, and analyze that data. You will learn to search government sites for available GIS data, import non-GIS data formats, and to connect your maps to non-spatial spreadsheets, database tables, and other file formats. For example, linking parcels to scanned documents like deeds, and attaching photographs to road hazard locations. You will also learn to create, maintain, and manipulate your organizations internal data to keep the data relevant, up-to-date, and useful. Finally, this course also teaches you how to present your GIS data, by focusing on map labeling techniques and layout skills.
# of Days:
|
| ArcGIS Pro Introduction |
16.00 |
1.60 |
|
Description: This course introduces participants to the ArcGIS Pro software. The class begins with the basics of navigating the map and walks through the process of creating maps, optimizing the display of the data, and performing spatial analysis. At the completion of this course, those attending should have a strong foundation in the basic use of ArcGIS Pro and have an understanding of the strengths of performing spatial analysis with a GIS.
# of Days:
|
| Business Analysis: Advanced Business Analysis |
21.00 |
2.10 |
|
Description: In this course, you will cover a case study to help you explore two standard approaches to conceptual modeling: the Unified Modeling Language and information Engineering. It is designed to be prescriptive as well as descriptive. This means that best practice will be emphasized through explanation and application. You will discover what should be done as well as how to do it, and why.
# of Days:
|
| Certified ScrumMaster (CSM) |
14.00 |
1.40 |
|
Description: The Certified ScrumMaster (CSM) course is a two-day, entry-level course taught by a Certified Scrum Trainer. The CSM course is designed to cover all the basics of Scrum so you can begin to fulfill the ScrumMaster role.
In the CSM course, you will learn about:
Scrum basics and core values
How the Scrum framework compares to other methods, such as waterfall
How to identify when to use Scrum
A Scrum teams three roles and responsibilities
Scrum meetings, including the Sprint Review, Sprint Retrospective and Release Planning
Sprint Backlog and Product Backlog
Scrum artifacts, including the Product Backlog, Sprint Backlog and Burndown Charts
Upon completing this course:
Qualification for Certified ScrumMaster (CSM) Certification after passing a short certification exam
Two year membership in the Scrum Alliance
14 PDUs from PMI (Project Management Institute)
PMI-ACPSM: This course counts as 14 of the 21 contact hours for the PMI-ACP certification
# of Days:
|
| Change Management and Leading Change |
7.00 |
0.70 |
|
Description: Change is a constant in many of our lives. All around us, technologies, processes, people, ideas, and methods often change, affecting the way we perform daily tasks and live our lives. Having a smooth transition when change occurs is important in any situation and your participants will gain some valuable skills through this workshop.
The Change Management workshop will give any leader tools to implement changes more smoothly and to have those changes better accepted. This workshop will also give all participants an understanding of how change is implemented and some tools for managing their reactions to change.
# of Days:
|
| CompTIA: Security+ Certification |
35.00 |
3.50 |
|
Description: Security+ Certification is the primary course you will need to take if your job responsibilities include securing network services, network devices and network traffic. It is also the main course you will take to prepare for the CompTIA Security+ examination. Topics covered include: identification of security threats, hardening internal systems and services, hardening internetwork devices and services, securing network communications, managing a PKI, managing certificates, enforcing an organizational security policy monitoring the security infrastructure.
# of Days:
|
| Excel 2016 Data Analysis |
7.00 |
0.70 |
|
Description: In this course, you will cover creating and modifying table elements, adding and deleting records and fields, and using Data forms and Slicers with table data. You will import data from Access and Excel objects as well as text file types. Proper data management will be discussed to determine structure requirements, sorting, filtering, using flash fill, auto filter and advanced filtering features. The database functions will allow the user to extract data from a large list of content with precision based on specific criteria. Finally, the data modeling features will examine how to take spreadsheet data and create one to many relationships which will expand the functionality of a pivot table for a greater understanding of the data.
# of Days:
|
| Excel 2016 Formulas |
6.00 |
0.60 |
|
Description: In this course, you will cover how to: build a formula, use function formulas, work with range names in a formula, use Logical and Lookup function formulas, use Financial function formulas, use the Concatenate function formula, work with the Date, Proper, Upper and Lower function formulas, create a function formulas from scratch work with data tables.
# of Days:
|
| Excel 2016 Level 1 for Windows |
7.00 |
0.70 |
|
Description: The Computer Workshop writes their own curriculum for Excel making it easy to customize a class specific to your needs. Many think they are past the basics, but our course has many valuable shortcuts and quick data entry methods built in to give you a good foundation. So even if you have used Excel for a number of years, it is worth taking the Level 1 class. Our course will make ordinary tasks much easier for you to accomplish, and in much less time.
Upon successful completion of this course, you will be able to create and develop Excel worksheets and workbooks in order to work with and analyze the data that is critical to the success of your organization.
You will:
? Get started with Microsoft Office Excel 2016.
? Perform calculations.
? Modify a worksheet.
? Format a worksheet.
? Print workbooks.
? Manage workbooks.
Prepares you for the Microsoft Office Specialist exam for Excel 2016 and the Excel 2016 Expert Exam.
# of Days:
|
| Excel 2016 Level 2 for Windows |
7.00 |
0.70 |
|
Description: In this course, you will cover how to work with large worksheets in Microsoft Excel 2016, and use multiple worksheets and workbooks efficiently. You will sort and filter data, use conditional formatting, and create and format tables and charts. You will learn how to protect worksheets and files, as well as referring to data in other workbooks thru 3D formulas. Finally, you will create names, customize a template, and work with comments and clipart.
# of Days:
|
| Excel 2016 Level 3 for Windows |
7.00 |
0.70 |
|
Description: In this course, you will cover how to create and work with Macros and VBA Programming, as well as how to add Form Controls and how to assign a Macro to a Form Control. In addition, you will learn about formula auditing, and will learn about common errors, how to correct them, and how to use the Watch Window to see changes in formulas. You will work with creating and modifying hyperlinks, get data from the internet, as well as learn how to save workbooks, worksheets, charts and ranges as web pages. You will create custom styles and learn how to use advanced conditional formatting. Finally you will learn how to create and use a shared workbook, including how to protect, consolidate and resolve editing conflicts in a shared workbook.
# of Days:
|
| Excel 2016 Pivot Tables |
4.00 |
0.40 |
|
Description: In this course you will learn how to create and modify PivotTables and PivotCharts, as well as how to filter and modify fields to format and group data. In addition you will learn to use the advanced features of PivotTables, such as consolidating multiple workbooks as well as creating and using page fields. Finally, you will learn how to generate PivotTables using imported data from external data sources. This information could be in Access, SQL Tables, the Internet, or other database programs. Understanding how to work with PivotTables and PivotCharts to achieve the results you want is one of the most powerful tools in Excel.
# of Days:
|
| Excel 2019 Formulas |
6.00 |
0.60 |
|
Description: In this course, you will cover how to: name cells and ranges, use those names in formulas, use Logical and Lookup function formulas, use the IF and IFS formulas, Data Validation, use Match and Indexing formulas, work with Date and Time formulas, and use the formula auditing tools to trouble shot problems in formulas.
# of Days:
|
| Excel 2019 Level 1 |
7.00 |
0.70 |
|
Description: The Computer Workshop writes their own curriculum for Excel making it easy to customize a class specific to your needs. Many think they are past the basics, but our course has many valuable shortcuts and quick data entry methods built in to give you a good foundation. So even if you have used Excel for a number of years, it is worth taking the Level 1 class. Our course will make ordinary tasks much easier for you to accomplish, and in much less time.
Upon successful completion of this course, you will be able to customize the interface to better suit your needs, create lists, efficiently develop Excel worksheets and workbooks, use basic excel function formulas, apply formatting to content, create customize number formats, control how spreadsheets are printed, as well as be able to find and replace content.
You will:
Get started with Microsoft Office Excel 2019
Customize the interface
Perform calculations
Modify a worksheet
Format a worksheet
Print workbooks
Edit contents
# of Days:
|
| Excel 2019 Level 3 |
7.00 |
0.70 |
|
Description: In this course, you will cover how to create and work with Macros and VBA Programming, as well as how to add Form Controls and how to assign a Macro to a Form Control. In addition, you will learn about formula auditing, and will learn about common errors, how to correct them, and how to use the Watch Window to see changes in formulas. You will work with creating and modifying hyperlinks, get data from the internet, as well as learn how to save workbooks, worksheets, charts and ranges as web pages. You will create custom styles and learn how to use advanced conditional formatting. Finally you will learn how to create and use a shared workbook, including how to protect, consolidate and resolve editing conflicts in a shared workbook.
# of Days:
|
| Excel 2019 VBA Programming |
7.00 |
0.70 |
|
Description: VBA (Visual Basic for Applications) enables you to enhance and extend the capabilities of Microsoft Excel and other applications in the Microsoft Office 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 VBAs capabilities and to optimize and debug your code.
At Course Completion:
After competing this course, student will be able to:
Identify general components of VBA and their appropriate use in solving business solutions.
Record VBA macros to automate repetitive tasks.
Write VBA code to create VBA subroutines and functions.
Use various programming elements to solve problems through code, including variables, objects, conditional statements, and loops.
Eliminate, avoid, or handle errors in VBA code, and optimize its performance.
# of Days:
|
| HTML 5 Level 1 for Windows |
7.00 |
0.70 |
|
Description: In this course, you will cover how use HTML5 elements and attributes to structure Web content. They will learn how to create semantically meaningful page structures and use CSS to control design and layout properties. Students will also learn how to work with lists and tables, create and format links, and work with images and background images.
# of Days:
|
| HTML 5 Level 2 for Windows |
7.00 |
0.70 |
|
Description: Building on the concepts in HTML 5: Basic, this ILT series course is designed for students with limited or outdated HTML experience who want to learn some of the more advanced elements and techniques of HTML5. In this course, students will explore effective web site planning and authoring principles, and they will learn how to create a semantic document structure. They will learn how to build interactive forms, apply native data validation, and embed HTML5 audio and video. Students will also learn some advanced CSS techniques, including using pseudo classes and pseudo elements. Finally, students will learn how to incorporate special fonts by linking to cloud services, and they will learn how to use the local storage feature in modern browsers.
# of Days:
|
| Influencing Up |
4.00 |
0.40 |
|
Description:
Learn to overcome your difficulties with a boss who is uninterested in your concerns, or resistant to giving needed support. Or discover how to win the cooperation of senior managers who are hard to reach, and hard to sell on your ideas, products, or services. In their classic book, Influence Without Authority, Allan Cohen and David Bradford provided a universal model of how to influence someone you dont control. Influencing Up applies those ideas to problematic bosses and other powerful people, with sophisticated tactics for building partnerships with them. If youre afraid of retaliation or just unclear as to how to change a senior persons behavior, dont stay paralyzed. Influencing Up gives you the tools to bridge the power gap. Offers practical advice about how to turn your relationship with your boss into a partnership in which both parties benefit Explains what powerful people care about Shows how to overcome power gaps by developing more partner-like relationships
# of Days:
|
| Introduction to Python 3.x |
28.00 |
2.80 |
|
Description: This four day course leads the student from the basics of writing and running Python scripts to more advanced features such as file operations, regular expressions, working with binary data, and using the extensive functionality of Python modules. Extra emphasis is placed on features unique to Python, such as tuples, array slices, and output formatting. This is a hands-on programming class. All concepts are reinforced by informal practice during the lecture followed by graduated lab exercises. Python Programming is a practical introduction to a working programming language, not an academic overview of syntax and grammar. Students will immediately be able to use Python to complete tasks in the real world.
# of Days:
|
| Microsoft Power BI: Data Analysis Professional |
21.00 |
2.10 |
|
Description: The creation of data-backed visualizations is a key way data scientists, or any professional, can explore, analyze, and report insights and trends from data. Microsoft Power BI software is designed for this purpose. Power BI was built to connect to a wide range of data sources, and allows users to quickly create visualizations of connected data to gain insights, show trends, and create reports. Power BIs data connection capabilities and visualization features go far beyond those that can be found in spreadsheets, allowing users to create compelling and interactive worksheets, dashboards, and stories that bring data to life and turn data into thoughtful action.
# of Days:
|
| MS-900: Microsoft 365 Fundamentals |
7.00 |
0.70 |
|
Description: This course provides foundational knowledge on the considerations and benefits of adopting cloud services and the Software as a Service (SaaS) cloud model, with a specific focus on Microsoft 365 cloud service offerings. You will begin by learning about cloud fundamentals, including an overview of cloud computing and specifically Microsoft cloud services. You will be introduced to Microsoft Azure, and you will examine the differences between Microsoft 365 and Office 365. You will then perform an in-depth review of Microsoft 365, including a comparison of Microsoft on-premises services versus Microsoft 365 cloud services, a review of enterprise mobility in Microsoft 365, and an analysis of how Microsoft 365 services provide collaboration. The course then analyzes how security, compliance, privacy, and trust are handled in Microsoft 365, and it concludes with a review of Microsoft 365 subscriptions, licenses, billing, and support.
# of Days:
|
| Outlook 2016 Level 2 for Windows |
7.00 |
0.70 |
|
Description: In this course, you will customize command sets, configure mail accounts, set global options, perform advanced searches, apply filters to intercept mail and control spam, create rules to automate many management tasks, work with calendars and contacts, manage tasks, protect data with archiving and data files, as well as share and delegate access to your workspaces.
This course builds upon the foundational knowledge presented in the Microsoft Office Outlook 2016 Level 1 course and will help you customize a communication system well-suited to your work styles. In addition, this course will help you prepare for the Microsoft Office Specialist (MOS) Certification exam for Microsoft Outlook 2016. In this course, you will use Outlooks advanced features to customize and manage your email communications, including using advanced features to organize emails; managing calendar settings and options; managing contact information; scheduling tasks; and managing Outlook backups and data file settings.
You will:
Modify messages and set global options.
Organize, search, and manage messages.
Manage your mailbox.
Automate message management.
Work with calendar settings.
Manage contacts and groups.
Manage activities by using tasks.
Share workspaces with others.
Manage Outlook data files.
# of Days:
|
| Project Management Essentials |
7.00 |
0.70 |
|
Description: In this course, you will cover: defining a project, project objectives and planning, project activities including activity analysis and activity estimation, project schedule development, CPM and PERT, project change control, fundamentals of cost estimating, organizational financial systems, measuring project performance reporting project performance.
# of Days:
|
| SharePoint Server 2016 Power End User |
24.00 |
2.40 |
|
Description: This 3-day class is a comprehensive training that will present students with a ground-up understanding for how to use, operate and build sites in a SharePoint Server 2016 environment. SharePoint 2016 brings forward many of the tools that we know and love from SharePoint 2013, but also adds many new attributes. This module discusses new elements to help users migrating to SharePoint 2016 quickly get up to speed with new terminology, and make the best use of the newest tools.
# of Days:
|
| SQL Level 1 for Windows |
7.00 |
0.70 |
|
Description: In this course you will cover how to: connect to the SQL Server database and execute a simple query, include a search condition in a simple query, use various functions to perform calculations on data, organize data, retrieve data by combining information from multiple tables present query results in a report.
# of Days:
|
| SQL Level 2 for Windows |
7.00 |
0.70 |
|
Description: In this course you will cover advanced techniques for querying a database including how to: code subqueries to generate query output, manipulate table data by inserting, updating and deleting records in a table, create a simple table, create tables with constraints, modify the table structure, and delete tables, create views, manipulate data through views, modify the view structure and drop views index data.
# of Days:
|
| Storytelling with Data Using Excel |
7.00 |
0.70 |
|
Description: The Storytelling with Data course teaches you the fundamentals of data visualization and how to communicate effectively with data. Youll discover the power of storytelling and the way to make data a pivotal point in your story. The lessons in this illuminative text are grounded in theory, but made accessible through numerous real-world examplesready for immediate application to your next graph or presentation.
Storytelling is not an inherent skill, especially when it comes to data visualization, and the tools at our disposal dont make it any easier. This book demonstrates how to go beyond conventional tools to reach the root of your data, and how to use your data to create an engaging, informative, compelling story.
Specifically, youll learn how to:
Understand the importance of context
Determine the appropriate type of graph
Recognize and eliminate the clutter
Direct your audiences attention
Think like a designer when visualizing data
Leverage the power of storytelling to help your message resonate with your audience
# of Days:
|
| Tableau Advanced |
14.00 |
1.40 |
|
Description: This two day course is designed to provide you with the skills required to become a Tableau power user. The course is designed for the professional who has solid working experience with Tableau and wants to take it to the next level. You should have a deep understanding of all the fundamental concepts of building worksheets and dashboards, but may scratch your head when working with more complex issues.
# of Days:
|
| Tableau Introduction |
14.00 |
1.40 |
|
Description: Tableau 9 Introduction is the latest version of the leading data visualization toolset that lets you visualize virtually any kind of data. In this course, students will learn how to work with Tableau Server, write custom programs, and publish their results to the web. Students will connect Tableau to a variety of databases and data sources, answer questions about trends, exceptions, and hidden insights by going through the steps of framing. Students will learn quick initial visualization options, and the deeper fine points to really maximize their use of Tableau.
# of Days:
|
| The Machine Learning Pipeline on AWS |
28.00 |
2.80 |
|
Description: Learn how to use the machine learning (ML) pipeline with Amazon SageMaker with hands-on exercises and four days of instruction. You will learn how to frame your business problems as ML problems and use Amazon SageMaker to train, evaluate, tune, and deploy ML models. Hands-on learning is a key component of this course, so youll choose a project to work on, and then apply the knowledge and skills you learn to your chosen project in each phase of the pipeline. Youll have a choice of projects: fraud detection, recommendation engines, or flight delays.
# of Days:
|
| Word 2016 Level 3 for Windows |
7.00 |
0.70 |
|
Description: Microsoft Word 2016 enables you to do far more than simple word processing. Word includes advanced image manipulation tools, collaboration features, cross-referencing and linking tools, entry forms and data collection, security features, and tools to automate document production.
This course covers Microsoft Office Specialist exam objectives to help students prepare for the Word 2016 Exam and the Word 2016 Expert Exam. You will:
Use images in a document.
Create custom graphic elements.
Collaborate on documents.
Add reference marks and notes.
Secure a document.
Create and manipulate forms.
Create macros to automate tasks.
# of Days:
|
| WS-011T00: Windows Server 2019 Administration |
35.00 |
3.50 |
|
Description: This five-day instructor-led course is designed primarily for IT professionals who have some experience with Windows Server. It is designed for professionals who will be responsible for managing identity, networking, storage and compute by using Windows Server 2019, and who need to understand the scenarios, requirements, and options that are available and applicable to Windows Server 2019. The course teaches IT professionals the fundamental administration skills required to deploy and support Windows Server 2019 in most organizations.
Audience profile
This course is intended for Information Technology (IT) Professionals who have some experiencing working with Windows Server and are looking for a single five-day course that covers core administration components and technologies in Windows Server 2019. This course also helps server administrators from previous Windows Server versions to update their knowledge and skills related to Windows Server 2019. Additionally, this course can help individuals looking for preparation materials to pass exams related to Windows Server. The course is also to individuals from a service desk role who wish to transition into server maintenance.
# of Days:
|