Course Name |
Hours |
List Price |
Content |
55039 - Windows PowerShell Scripting and Toolmaking |
35.00 |
$2,899.00 |
|
Description: This five-day instructor-led course is intended for IT Professionals who have a working knowledge of Windows PowerShell 3.0 techniques and technologies, and who want to build reusable tools by using Windows PowerShell 3.0. Students of this course may administer a wide variety of server and client products and technologies that offer Windows PowerShell integration, including Microsoft Exchange Server, Microsoft Windows Active Directory Domain Services, Microsoft SharePoint Server and more. This course focuses on the Windows PowerShell scripting language and on the concepts and techniques needed to produce reusable, professional tools.
# of Days:
Setting:
|
55371AC Windows Server Administration |
35.00 |
$2,899.00 |
|
Description: In this course, you will cover the fundamental administration skills required to deploy and support Windows Server in most organizations. This course is a replacement for WS-011.
# of Days:
Setting:
|
Angular: Introduction to Angular 12 |
21.00 |
$2,295.00 |
|
Description: Learn Angular 12, the latest production release of Googles popular TypeScript-based web framework!
The Introduction to Angular 12 Programming Training course covers all the essential topics and is designed to get students up and running with Angular 12 development in the shortest amount of time.
Developers and Application Designers as well as those who are tasked with supporting Angular 12 applications will gain valuable knowledge required for success in their job roles while taking this course.
Get started with the new Angular 12 today!
# of Days:
Setting:
|
ArcGIS Pro Intermediate |
21.00 |
$1,689.00 |
|
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:
Setting:
|
Autodesk Revit: Fundamentals for Mechanical and Plumbing |
21.00 |
$1,595.00 |
|
Description: In this course, you will cover the concepts and principles of creating 3D parametric models of Mechanical and Plumbing systems from engineering design through construction documentation to take full advantage of Building Information Modeling.
This training course is intended to introduce users to the softwares user interface and the basic HVAC, and piping/plumbing components that make the Autodesk Revit software a powerful and flexible engineering modeling tool. The course will also familiarize users with the tools required to create floor plans, populate construction documents as well as print the parametric model. The examples and practices are designed to take users through the basics of a Mechanical and Plumbing project from the initial process of linking in various discipline (i.e., architectural, structural) models to generating construction documents.
The Autodesk Revit Fundamentals for Mechanical and Plumbing Systems training course contains in-class exercises that are specific to both disciplines.
# of Days:
Setting:
|
AZ-104T00: Microsoft Azure Administrator |
28.00 |
$2,399.00 |
|
Description: This course teaches IT Professionals how to manage their Azure subscriptions, secure identities, administer the infrastructure, configure virtual networking, connect Azure and on-premises sites, manage network traffic, implement storage solutions, create and scale virtual machines, implement web apps and containers, back up and share data, and monitor your solution.
Audience Profile
This course is for Azure Administrators. The Azure Administrator implements, manages, and monitors identity, governance, storage, compute, and virtual networks in a cloud environment. The Azure Administrator will provision, size, monitor, and adjust resources as appropriate.
# of Days:
Setting:
|
CompTIA: Network+ |
35.00 |
$2,499.00 |
|
Description: In this course, you will cover: basic network theory; network connectivity; advanced network theory such as the OSI Model, Ethernet and FDDI; common network protocols; TCP/IP services; alternate network protocols including IPX/SPX and Appletalk; Network LAN Infrastructure; Network WAN Infrastructure; remote networking; network security; disaster recovery; advanced data storage techniques; network troubleshooting network operating systems.
This course is intended for entry-level computer support professionals with a basic knowledge of computer hardware, software, and operating systems to prepare for the CompTIA Network+ (Exam N10-005), or who wish to increase their knowledge and understanding of networking concepts and acquire the required skills to prepare for a career in network support or administration. A typical student taking up the CompTIA Network+ (Exam N10-005) course should have a minimum of nine months or more of professional computer support experience as a PC or help desk technician. Networking experience is helpful but not mandatory; A+ certification or equivalent skills and knowledge is helpful but not mandatory.
You will describe the major networking technologies, systems, skills, and tools in use in modern networks.
Upon successful completion of this course, students will be able to:
Identify the basic network theory concepts.
Identify the major network communications methods.
Describe network media and hardware components.
Identify the major types of network implementations.
Identify the components of a TCP/IP network implementation.
Identify TCP/IP addressing and data delivery methods.
Identify the major services deployed on TCP/IP networks.
Identify the components of a LAN implementation.
Identify the infrastructure of a WAN implementation.
Identify the components of a remote network implementation.
Identify the major issues and methods to secure systems on a network.
Identify the major issues and technologies in network security.
Identify network security threats and attacks.
Identify the tools, methods, and techniques used in managing a network.
Describe troubleshooting of issues on a network.
# of Days:
Setting:
|
CompTIA: Project+ Certification |
35.00 |
$2,499.00 |
|
Description: Project+ Certification prepares students for the current CompTIA Project+ Certification exam. It covers the full range of skills and concepts students need to know to plan and implement projects. The project initiation and planning process is covered in-depth, culminating in the creation of a project schedule. Learning how to manage business concerns such as cost and risk is balanced by thorough coverage of best practices in managing people and resources. Students will also learn how to manage change and the steps necessary in closing a project.
# of Days:
Setting:
|
CompTIA: Security+ Certification |
35.00 |
$2,499.00 |
|
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:
Setting:
|
CompTIA: Server+ Certification Course |
35.00 |
$2,499.00 |
|
Description: In this course you will cover: different types of servers; identification of hardware and software components used in servers; installation of servers in a network environment; configuring servers and checking and upgrading BIOS and firmware levels; preventative maintenance measures including setting SNMP thresholds; upgrading server hardware and software; exploration of environmental issues surrounding servers; troubleshooting servers exploring disaster recovery concepts and techniques.
# of Days:
Setting:
|
Excel 2016 Dashboards |
7.00 |
$299.00 |
|
Description: In this Microsoft Excel Dashboards course, students will give you the skills to use Excel Dashboards at an advanced level. Microsoft Excel Dashboards are a reporting mechanism that can deliver Business Intelligence (BI) in graphical form. Dashboards take raw data; allow it to be analyzed and presented in a form that is of most benefit to the end user. Participants in this course must have an Intermediate working knowledge of Excel.
Course Objectives:
- Differentiate between Reports and dashboards
- Discuss the benefits of an Excel dashboard
- Assemble all data needed for a dashboard
- Identify ground rules for creating effective dashboards
- Create dynamic charts
- Create Pivot tables
- Create Pivot Charts
- Modify Pivot tables and charts
- Apply conditional formatting to a dashboard
- Identify and apply Excel functions (IF, CHOOSE and VLOOKUP)
- Design and build a dashboard from raw data to the finished product
# of Days:
Setting:
|
Excel 2019 Charts |
4.00 |
$219.00 |
|
Description: In this course, you will cover the many different types of charts available in Excel, how to modify and redefine chart data, as well as how to move, layout, and style a chart. In addition, you will learn about chart elements and how to add, remove, and format chart elements, as well as how to save a chart template. Finally, you will learn about sparklines, trendlines, error bars, and advanced chart types.
# of Days:
Setting:
|
Excel 2019 Data Analysis |
7.00 |
$289.00 |
|
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:
Setting:
|
Excel 2019 Data Analysis with Power Pivot |
4.00 |
$219.00 |
|
Description: 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.
# of Days:
Setting:
|
Excel 2019 Formulas |
6.00 |
$279.00 |
|
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 shoot problems in formulas.
# of Days:
Setting:
|
Excel 2019 Level 1 |
7.00 |
$279.00 |
|
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:
Setting:
|
Excel 2019 Level 2 |
7.00 |
$289.00 |
|
Description: In this course, you will cover how to work with large worksheets in Microsoft Excel 2019, 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 graphics.
# of Days:
Setting:
|
Excel 2019 Level 3 |
7.00 |
$299.00 |
|
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:
Setting:
|
Excel 2019 Pivot Tables |
4.00 |
$219.00 |
|
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:
Setting:
|
Illustrator CC Professional |
21.00 |
$1,199.00 |
|
Description: This course offers a comprehensive overview Adobe Illustrator. Through step-by-step lessons you will
move from fundamental concepts and progress to the softwares full set of features. - including an
illustrated tutorial on how to draw with the Pen tool that you wont find in any other book. This new
edition highlights extensive coverage of important and exciting new features, including dramatic
improvements to Illustrators built-in tracing utility and a major upgrade for creating patterns.
# of Days:
Setting:
|
InDesign CC Basic |
7.00 |
$399.00 |
|
Description: 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 CC (2017) 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.
This course is a great component of your preparation for the Adobe Certified Expert (ACE) InDesign CC exam and the Adobe Certified Associate (ACA) Print Digital Media Publication Using Adobe InDesign exam.
# of Days:
Setting:
|
Information Technology Management and Leadership Professional (ITMLP) |
21.00 |
$2,295.00 |
|
Description: In this course, you will cover the ITMLP components which specialize in a set of key IT topics designed to increase the effectiveness of new and would-be IT managers by widening their knowledge of IT, discussing techniques to enhance user support and satisfaction, providing insights into motivating technical professionals, and providing information on the use of various IT best-practices.
This certification contains the rigorous, down-to-earth practical advice, and IT applicable case scenarios needed to help you distinguish yourself as a superior leader in the highly technical, yet people-driven world of information technology.
Developed by an experienced CIO, and then vetted by a board of senior IT industry executives, the ITMLP shows that those who successfully complete the ITMLP Final Exam bring credible and validated industry knowledge to the organizations they serve.
# of Days:
Setting:
|
Interpersonal Skills |
7.00 |
$275.00 |
|
Description: The Interpersonal Skills course will help participants improve job and professional productivity by focusing on working with others whether in a one-on-one or group setting. Key topics include: improving your people skills, handling conflict successfully, thinking on your feet, and empowering yourself effectively. Participants will learn successful techniques that will help advance personal career goals.
# of Days:
Setting:
|
Introduction to Jira Workshop |
7.00 |
$750.00 |
|
Description: In this hands-on 1 day workshop for Agile Teams, Jira experts will lead you through setting up your first Jira Project, setting up your Team Board, entering work and tracking progress.
# of Days:
Setting:
|
Introduction to Python 3.x |
28.00 |
$2,399.00 |
|
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:
Setting:
|
ITIL 4 Foundation |
14.00 |
$1,979.00 |
|
Description: ITIL is the worlds leading best practice framework for implementing IT service management. Organizations use ITIL to plan, implement, support, and improve services and create value for their customers. In this course, you will learn the foundational knowledge and skills for adopting and adapting best practices for IT service management (ITSM) in your organization.
# of Days:
Setting:
|
jMeter Performance Testing |
28.00 |
$3,549.00 |
|
Description: The Apache JMeter application is a 100 pure Java application designed to load test functional behavior and measure performance. Use JMeter to test performance both on static and dynamic resources, and Web dynamic applications. Use JMeter to simulate load on a server, group of servers, network or object to test its strength and analyze overall performance under different load types. This workshop provides a rich interactive learning experience with incremental lessons and labs that build upon one another.
# of Days:
Setting:
|
Managing Projects using Azure Board |
7.00 |
$695.00 |
|
Description: Azure DevOps provides a set of cloud-hosted tools that software teams can use as an end-to-end solution to plan, develop, test, and deliver value in the form of working software. Azure Boards enable an agile team to plan, track, and discuss work across the entire development effort. This one day course will demonstrate how an agile team can configure and use Azure Boards effectively. To maximize learning, students will work in teams, in a common team project, on a common case study.
# of Days:
Setting:
|
Microsoft Office 365 Online with Teams for the Desktop |
7.00 |
$399.00 |
|
Description: This course is an introduction to Microsoft Office 365 with Teams in a cloud-based environment. It can be used as an orientation to the full suite of Office 365 cloud-based tools, or the Teams lessons can be presented separately in a seminar-length presentation with the remaining material available for later student reference.
Using the Office 365 suite of productivity apps, users can easily communicate and collaborate together through Microsoft Outlook mail and Teams messaging and meeting functionality. Additionally, the Microsoft SharePoint team site provides a central storage location for accessing and modifying shared documents. This course introduces working with shared documents in the familiar Office 365 online appsWord, PowerPoint, and Excelas 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 this course, you will build upon your knowledge of the Microsoft Office desktop application suite to work productively in the cloud-based Microsoft Office 365 environment.
You will:
Sign in, navigate, and identify components of the Office 365 environment.
Create, edit, and share documents with team members using the Office Online apps, SharePoint, OneDrive for Business, and Delve.
Collaborate and work with colleagues using the Yammer and Planner apps.
Use email and manage contacts with Outlook on the web.
Collaborate using Teams.
Configure Teams.
# of Days:
Setting:
|
Microsoft Power BI: Data Analysis Practitioner |
14.00 |
$1,159.00 |
|
Description: As technology progresses and becomes more interwoven with our businesses and lives, more data is collected about business and personal activities. This era of big data has exploded due to the rise of cloud computing, which provides an abundance of computational power and storage, allowing organizations of all sorts to capture and store data. Leveraging that data effectively can provide timely insights and a competitive advantage.
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:
Setting:
|
MS-100T00: Microsoft 365 Identity and Services |
35.00 |
$2,899.00 |
|
Description: In this course you will learn about Office 365 Management, including key components of Office 365, how to move your organization to Office 365, how to configure Office 365, and how to manage Office 365 ProPlus deployments. You will explore Microsoft 365 Tenant and Service Management, including how to plan, manage, and customize your organizations Microsoft 365 tenant and services. Finally, you will learn about Microsoft 365 Identity Management, including how to manage user security groups and licenses for cloud identities, and how to plan and implement identity synchronization, federated identities, applications, and external access.
# of Days:
Setting:
|
MS-900T01: Microsoft 365 Fundamentals |
7.00 |
$579.00 |
|
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:
Setting:
|
OneNote for Windows 10 |
7.00 |
$279.00 |
|
Description: In our fast-paced digital world, the need to capture ideas, meeting notes, and to-do items is ever present. Microsoft OneNote for Windows 10 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.
# of Days:
Setting:
|
Photoshop Creative Cloud (CC) Level 2 for Windows |
28.00 |
$1,599.00 |
|
Description: In this course you will cover: introduction to the Photoshop Creative Cloud (CC) work area, basic photo corrections, working with selections, layer basics, masks and channels, correcting and enhancing digital photographs, typographic design, vector drawing techniques, advanced layering, advanced compositing, painting with the mixer brush, editing video, working with camera raw files, preparing files for the web, producing and printing consistent color, and printing 3D files!
In this course, creative professionals seeking the fastest, easiest, most comprehensive way to learn Adobe Photoshop CC, will be instructor led through 15 project-based lessons. Students will be shown step-by-step, key techniques for working in Photoshop CC, and how to manipulate images, edit motion-based content, and create image composites.
# of Days:
Setting:
|
PL-300: Microsoft Power BI Data Analyst |
21.00 |
$1,739.00 |
|
Description: This course will discuss the various methods and best practices that are in line with business and technical requirements for modeling, visualizing, and analyzing data with Power BI. The course will also show how to access and process data from a range of data sources including both relational and non-relational data. This course will also explore how to implement proper security standards and policies across the Power BI spectrum including datasets and groups. The course will also discuss how to manage and deploy reports and dashboards for sharing and content distribution.
Audience Profile
The audience for this course are data professionals and business intelligence professionals who want to learn how to accurately perform data analysis using Power BI. This course is also targeted toward those individuals who develop reports that visualize data from the data platform technologies that exist on both in the cloud and on-premises.
At Course Completion
After completing this course, students will be able to:
Ingest, clean, and transform data
Model data for performance and scalability
Design and create reports for data analysis
Apply and perform advanced report analytics
Manage and share report assets
# of Days:
Setting:
|
PMI Agile Certified Practitioner (PMI-ACP) |
21.00 |
$2,399.00 |
|
Description: This course is designed to teach individuals Agile and Agile approaches. You will learn how to understand how a Scrum project and team operate, and the key principles and techniques that lead to project success. You will also learn the roles and responsibilities of a Scrum team and be able to understand how to coach Agile teams.
At Course Completion students will be able to:
Traditional / waterfall development versus Agile development
Planning an Agile project
Executing an Agile project
Agile monitoring, metrics, and improvement
Coaching Agile teams
Agile methodologies
Testing strategies
# of Days:
Setting:
|
PowerPoint 2019 Level 1 for Windows |
7.00 |
$279.00 |
|
Description: Its hard to imagine a day going by without people passing along large amounts of information. With so much communication to contend with, it can be difficult to grab peoples attention. But, we are often called upon to do just that. So, how do you grab and maintain an audiences focus when youre asked to present important information? By being clear, organized, and engaging. And, that is exactly what Microsoft Office PowerPoint 2019 can help you do.
Gone are the days of flip charts or drawing on a white board to illustrate your point. Todays audiences are tech savvy, accustomed to high-impact multimedia content, and stretched for time. By learning how to use the vast array of features and functionality contained within PowerPoint 2019, you will gain the ability to organize your content, enhance it with high-impact visuals, and deliver it with a punch. In this course, you will use PowerPoint 2019 to begin creating engaging, dynamic multimedia presentations.
This course covers Microsoft Office Specialist Program exam objectives to help you prepare for the PowerPoint Associate (Office 365 and Office 2019): Exam MO-300.
# of Days:
Setting:
|
PowerPoint 2019 Level 2 for Windows |
7.00 |
$289.00 |
|
Description: Meetings, instruction, training, pitches; these are all a part of our daily lives. We are often called upon to deliver presentations with little notice, at multiple venues, and with varying requirements. And, some of these presentations include sensitive information that needs to be guarded. Given all the variables, it may seem an overwhelming task to deliver your content, on time, to all audiences, and to only those who need to see it. Oh, and by the way, you need to make it interesting, informative, and memorable. So, how do you do it? Without the help of a robust set of tools, it would be nearly impossible. But Microsoft Office PowerPoint 2019 provides you with a variety of such tools that can help you deliver content in nearly any situation, while saving time and effort. By taking advantage of these tools, you will be creating presentations that not only stand out from the crowd, but also dont consume all of your available time.
This course covers Microsoft Office Specialist Program exam objectives to help you prepare for the PowerPoint Associate (Office 365 and Office 2019): Exam MO-300.
# of Days:
Setting:
|
Programming and Data Wrangling with VBA and Excel |
21.00 |
$897.00 |
|
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 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.
Course Objectives:
In this course, you will develop and deploy VBA modules to solve business problems. You will:
Identify general components of VBA and their appropriate use in solving business solutions.
Record VBA macros to automate repetitive tasks.
Use reference tools built into Excel to get help on VBA programming language and objects used in the Excel VBA environment.
Write VBA code to create a custom worksheet function.
Eliminate, avoid, or handle errors in VBA code, and optimize its performance.
Control how and when macros run.
Develop UserForm objects to create custom dialog boxes and windows.
Use VBA to read and write data from local files and cloud services.
Use VBA to clean and transform data.
Run programs and commands outside of Excel and share VBA projects with other users.
# of Days:
Setting:
|
Project Management Professional (PMP) Certification Preparation |
35.00 |
$2,899.00 |
|
Description: In this course, you will cover: initiating a project, defining the project scope, developing a schedule and cost performance baselines for a project, planning project quality, staffing and communications, analyzing project risks, defining
project procurement requirements, executing the project, controlling the project closing the project. This course is designed for experienced project managers who desire to increase management skills and apply a standards-based approach to project management.
# of Days:
Setting:
|
React JavaScript Programming |
21.00 |
$1,795.00 |
|
Description: Our React class introduces the React JavaScript framework, sometimes referred to as React or React.JS. React is a popular component-based JavaScript framework used for easy creation of powerful, interactive UIs.
This React class will provide an introduction to the benefits of the React JavaScript framework, so course participants can start to develop applications quickly using the framework.
# of Days:
Setting:
|
SAFe for Architects |
21.00 |
$2,500.00 |
|
Description: Attendees can improve collaboration and alignment in a SAFe Lean-Agile enterprise when they become a SAFe 5 Architect. The SAFe for Architects course prepares System, Solution, and Enterprise Architects to engage across the organization as effective leaders and change agents who collaboratively deliver architectural solutions.
During this three-day course, attendees will explore the roles, responsibilities, and mindset of Agile Architects, and appreciate how to align architecture with business value and drive continuous flow to large systems-of-systems while supporting SAFe program execution.
This course is for senior technical contributors who need to understand the role of System, Solution, and Enterprise Architects in Lean-Agile enterprises. The course is also appropriate for individuals desiring a deeper view into how architecture enables continuous value flow and how architects engage in, and contribute to, a Lean-Agile enterprise.
# of Days:
Setting:
|
SQL Level 1 for Windows |
7.00 |
$399.00 |
|
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:
Setting:
|
SQL Level 2 for Windows |
7.00 |
$399.00 |
|
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:
Setting:
|
Storytelling with Data Using Excel |
7.00 |
$399.00 |
|
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 course 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:
Setting:
|
Tableau Introduction |
14.00 |
$1,299.00 |
|
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. Tableau software is designed for this purpose. Tableau 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. Tableaus 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:
Setting:
|
Windows 10 Level 1 |
7.00 |
$279.00 |
|
Description: Whether youre 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 e-mail, browse the Internet, and share information between applications and with other users.
# of Days:
Setting:
|