Advanced JavaScript Training

In this Advanced JavaScript Programming class, students will learn advanced JavaScript techniques including advanced form validation with Regular Expressions, how to use the HTML DOM and how to create dynamic menus. In addition, students will learn how to manipulate CSS with JavaScript to create applications using DHTML. This course also teaches students how to use the XmlHttpRequest Object, how to use JSON in an application, how to position elements dynamically using JavaScript and much more. After completing this course, students will have a thorough understanding of the many ways JavaScript can be used in modern web development.

Angular Training

In this hands-on Angular Training course, students will obtain the foundation to get up and running with the latest version of Angular. Students will begin by learning about TypeScript – the language used in Angular. Students will then move on to create their first app, use the built-in components of Angular and then begin creating their own components. Next, the course moves onto intermediate concepts like using forms, APIs, routing to different pages and using Dependency Injection to organize code. In addition, students will learn how to test and deploy their Angular applications. This course is up-to-date through Angular 10.

Excel Power Pivot Training

Power Pivot is a powerful data exploration tool based on in-memory computing technologies that provides unmatched analytical performance to process billions of rows almost instantaneously. In this Microsoft Excel Power Pivot Training course, students will learn how to use Power Pivot to import and manipulate data, create Power Pivot reports, use DAX functions, create key performance indicators (KPI) and use slicers to enhance the visualization of data.

JavaScript Training

In addition to HTML and CSS, JavaScript represents one of the main tools web developers use to create rich, responsive web and mobile applications. Its use has expanded with the use of jQuery and AJAX and has evolved JavaScript to become much more than just a scripting language used to manipulate the user interface. In this three-day JavaScript Training course, students will learn to use the most recent, widely supported version of JavaScript. They will learn how to create basic statements in JavaScript, how to declare and use primitive and complex variables and data types (including objects), how to create and use Functions and Expressions and how to match patterns using Regular Expressions. In addition, students will see how to manipulate the Document Object Model (DOM), how to handle keyboard and screen events, how to validate form input with JavaScript and how to debug and handle errors in their JavaScript code.

HTML5 and CSS3 Training

This HTML5 and CSS3 Training course is intended for students new to web development with HTML5 and CSS3. Students will be introduced to basic web page development using HTML5, how to structure content on a web page, how to apply styles to a web page using Cascading Style Sheets (CSS3), how to work with tables in HTML5 and how to enable navigation within a website. In addition, students will learn how to test CSS, create CSS menus, incorporate multimedia and create advanced forms.

HTML5 CSS3 and JavaScript Training

In this HTML5 CSS3 and JavaScript Training course, students will quickly get up to speed on the latest standards for developing web applications for both browsers and touch-enabled devices. This course provides a quick introduction to the basics of HTML and then dives deep into new HTML5 tags and attributes. From there, students will learn the latest in CSS3 techniques to create unique and compelling interfaces for their web pages and applications. The course concludes by introducing JavaScript and showing students how to use it for client-side operations, storing data and manipulating graphics. The course also introduces debugging your web pages and applications and deploying them to various end-points. This course can also be used as preparation for students interested in taking the Microsoft Technology Associate Exam #98-375. It can also serve as a stepping stone to the Microsoft Certified Technology Specialist exams.

Microsoft Project Training

This Microsoft Project training course is designed to show students how to use Microsoft Project to effectively manage projects. The course covers the critical knowledge and skills a project manager, or other individual tasked with managing projects, needs to create a project plan with Microsoft Project and shows students how to utilize Microsoft Project to oversee the planning, execution, monitoring, and controlling phases of their projects. This course will enable students to utilize Microsoft Project to manage projects so that they are completed on time, within budget, and according to scope.

Students will learn how Microsoft Project calculates their project schedule using a project start or end date, task relationships, resource availability and project calendars. Students will also see how to use various views in Microsoft Project, including the Gantt chart view, to analyze the project progress. This course also shows students how to share the project plan with others who may not have Microsoft Project installed and how to create a Project template to speed the creation of future projects.

Microsoft Excel VBA Training

In this Microsoft Excel 2016 VBA Training course, students will learn to use VBA in Excel to create interactive worksheets and automate common worksheet tasks. Students will see how to generate VBA code from existing macros, gain an understanding of the different parts of the Visual Basic Editor, learn how code is organized in Projects, Modules and Procedures and become familiar using Objects, Properties and Methods in their code.

In addition, this course teaches students how to debug their VBA code to find and fix logic errors, interact with the user using dialog boxes, control formatting of the worksheet using VBA code and how to automate the addition and deletion of workbooks. Finally, students will see how to perform calculations in code and use built-in functions in Excel in VBA to quickly calculate large amounts of data.

Microsoft Access VBA Training

In this Microsoft Access VBA Training course, students will learn how to use the VBA (Visual Basic for Applications) programming language to automate their database applications. They will learn about creating Sub Procedures and Functions and see how to call these blocks of code from an event occurring in Microsoft Access, such as a button being clicked or a user saving a record. Students will be introduced to the Microsoft Access Object Model, which will allow them to control all aspects of the application, including things like closing or opening forms, printing reports or validating user data entry. Students will also be introduced to accessing data in the database through code by using Data Access Objects (DAO,) allowing the manipulation of data behind the scenes – with no user action needed. Finally, students will see how to debug their code and add error handling to ensure that unexpected errors don’t force an application shutdown. Although a programming environment, VBA is fun and easy to learn – even for students who have no programming experience!