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