5475 Software courses delivered Online

Duration 3 Days 18 CPD hours This course is intended for Ideal candidates are Network Administrators who monitor and troubleshoot wireless networks, and Network and System Administrators responsible for installing and configuring network monitoring systems. Overview This hands-on course prepares you with the knowledge and experience required to install and use the AirWave Wireless Management Suite: AirWave Management Platform (AMP), RAPIDS, Visual RF, network health diagnostics, client troubleshooting, alerts and reporting.  In this course, you learn about AirWave?s capabilities in troubleshooting network health and client status via the various stages of association and authentication, as well as redundancy and master consoles for large networks. Introduction to AWMS Airwave Platform. Features and Benefits of AMP RAPIDS and Visual RF. Airwave products. Basic operations using AWMS Installing AWMS Installing AMP. Hardware requirements. Cent OS and AWMS software. Basic configuration steps. Upgrade AWMS software. Licensing AWMS. AWMS documentation Adding Device to AWMS Folders and Groups. Adding devices general process. Manually adding devices. Device discovery and managing device discovery. Moving a device to a folder. Troubleshooting IAP Organizaion and Groups Overview of IAP.Airwave integration. Golden configuration. IAP Organization options. IAP Whitelist Using Visual RF and Visual RF Plan Navigation. Setup. Heat-maps and location information. Import floorplan graphics. Plan deployments. Provision APs. Manage Visual RF performance Network Health Diagnostics page indicators. Network performance tabs. Source of issues. Network issues Troubleshooting Clients and Wireless Networks Searching for users and Diagnostics tab. Client issues. Network issues. AP issues. Switch/Controller issues. General Issues Rogue Detection and Using RAPIDS Why use RAPIDS. Threat Detection Methods. Rules. Classifications. IDS Events Report. New Rogue Devices Report. Visualization. PCI Compliance.WMS Offload Managing Administrative Access, Alerts, Triggers and Reporting Configure role-based administrative use access to the AMP system. Triggers. Alerts. Define and generate reports Scalability and Redundancy VM Redundancy. Failover for Redundancy. Master Console for large deployments. Multiple AMP Server deployments. Large Deployment example System Administration AMP Maintenance. Device Maintenance Wired Device Management Monitoring wired devices in AWMS. Wired device port and interface information. Wired device bandwith statistics and counters. Managing and configuring wired devices via AWMS templates AirWave Aruba Groups How AWMS configures devices. Using groups to control policies. Creating and controlling groups. Basic Group Design.Configuration Audits IAP Template Configuration Fetching a Template. Template Variables. Templates Configuration IAP GUI Configuration Golden configuration. GUI mode. GUI configuration Additional course details: Nexus Humans Managing Campus Networks with Aruba AirWave, Rev. 19.21 training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the Managing Campus Networks with Aruba AirWave, Rev. 19.21 course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

Duration 2 Days 12 CPD hours This course is intended for The intended audience for this comprehensive course on Information Assurance and STIGs includes professionals with roles such as: IT professionals - System administrators, network engineers, and security analysts who are responsible for maintaining and securing IT infrastructure and web applications. Developers - Software engineers and web developers who design, implement, and maintain web applications, and need to integrate security best practices throughout the development process. Project teams - Cross-functional teams that collaborate on application development projects, including members from development, testing, and deployment teams. Technical leads - Senior software engineers or architects who oversee technical aspects of projects and ensure the implementation of secure design and coding practices. Project managers - Professionals responsible for planning, executing, and closing projects, ensuring that security requirements are met throughout the project lifecycle. Overview Working in an interactive learning environment, guided by our application security expert, you'll explore: The concepts and terminology behind defensive coding Threat Modeling as a tool in identifying software vulnerabilities based on realistic threats against meaningful assets The entire spectrum of threats and attacks that take place against software applications in today's world The role that static code reviews and dynamic application testing to uncover vulnerabilities in applications The vulnerabilities of programming languages as well as how to harden installations The basics of Cryptography and Encryption and where they fit in the overall security picture The requirements and best practices for program management as specified in the STIGS The processes and measures associated with the Secure Software Development (SSD) The basics of security testing and planning Understand the concepts and terminology behind defensive coding Understand Threat Modeling as a tool in identifying software vulnerabilities based on realistic threats against meaningful assets Learn the entire spectrum of threats and attacks that take place against software applications in today's world Discuss the role that static code reviews and dynamic application testing to uncover vulnerabilities in applications Understand the vulnerabilities of programming language as well as how to harden installations Understand the basics of Cryptography and Encryption and where they fit in the overall security picture Understand the fundamentals of XML Digital Signature and XML Encryption as well as how they are used within the web services arena Understand the requirements and best practices for program management as specified in the STIGS Understand the processes and measures associated with the Secure Software Development (SSD) Understand the basics of security testing and planning The Information Assurance (STIG) Overview is a comprehensive two-day course that delves into the realm of Information Assurance, empowering you to enhance your cybersecurity skills, understand the essentials of STIGs, and discover cutting-edge web application security practices. This immersive experience is tailored for IT professionals, developers, project teams, technical leads, project managers, testing/QA personnel, and other key stakeholders who seek to expand their knowledge and expertise in the evolving cybersecurity landscape. The course focuses on the intricacies of best practices for design, implementation, and deployment, inspired by the diverse and powerful STIGs, ultimately helping participants become more proficient in application security.The first half of the course covers the foundations of DISA's Security Technical Implementation Guides (STIGs) and learn the ethical approach to bug hunting, while exploring the language of cybersecurity and dissecting real-life case studies. Our expert instrtors will guide you through the importance of respecting privacy, working with bug bounty programs, and avoiding common mistakes in the field.The next half delves into the core principles of information security and application protection, as you learn how to identify and mitigate authentication failures, SQL injections, and cryptographic vulnerabilities. You?ll gain experience with STIG walkthroughs and discover the crucial steps for securing web applications.Throughout the course, you'll also explore the fundamentals of application security and development, including checklists, common practices, and secure development lifecycle (SDL) processes. You?ll learn from recent incidents and acquire actionable strategies to strengthen your project teams and IT organizations. You'll also have the opportunity to explore asset analysis and design review methodologies to ensure your organization is prepared to face future cybersecurity challenges. DISA's Security Technical Implementation Guides (STIGs) The motivations behind STIGs Requirements that the various software development roles must meet Implementing STIG requirements and guidelines Why Hunt Bugs? The Language of CyberSecurity The Changing Cybersecurity Landscape AppSec Dissection of SolarWinds The Human Perimeter Interpreting the 2021 Verizon Data Breach Investigation Report First Axiom in Web Application Security Analysis First Axiom in Addressing ALL Security Concerns Lab: Case Study in Failure Safe and Appropriate Bug Hunting/Hacking Working Ethically Respecting Privacy Bug/Defect Notification Bug Bounty Programs Bug Hunting Mistakes to Avoid Principles of Information Security Secuity Is a Lifecycle Issue Minimize Attack Surface Area Layers of Defense: Tenacious D Compartmentalize Consider All Application States Do NOT Trust the Untrusted Identification and Authentication Failures Applicable STIGs Quality and Protection of Authentication Data Proper hashing of passwords Handling Passwords on Server Side Session Management HttpOnly and Security Headers Lab: STIG Walk-Throughs Injection Applicable STIGs Injection Flaws SQL Injection Attacks Evolve Drill Down on Stored Procedures Other Forms of Server-Side Injection Minimizing Injection Flaws Client-side Injection: XSS Persistent, Reflective, and DOM-Based XSS Best Practices for Untrusted Data Lab: STIG Walk-Throughs Applications: What Next? Common Vulnerabilities and Exposures CWE/SANS Top 25 Most Dangerous SW Errors Strength Training: Project Teams/Developers Strength Training: IT Organizations Cryptographic Failures Applicable STIGs Identifying Protection Needs Evolving Privacy Considerations Options for Protecting Data Transport/Message Level Security Weak Cryptographic Processing Keys and Key Management Threats of Quantum Computing Steal Now, Crack Later Threat Lab: STIG Walk-Throughs Application Security and Development Checklists Checklist Overview, Conventions, and Best Practices Leveraging Common AppSec Practices and Control Actionable Application Security Additional Tools for the Toolbox Strength Training: Project Teams/Developers Strength Training: IT Organizations Lab: Recent Incidents SDL Overview Attack Phases: Offensive Actions and Defensive Controls Secure Software Development Processes Shifting Left Actionable Items Moving Forward Lab: Design Study Review Asset Analysis Asset Analysis Process Types of Application-Related Assets Adding Risk Escalators Discovery and Recon Design Review Asset Inventory and Design Assets, Dataflows, and Trust Boundaries Risk Escalators in Designs Risk Mitigation Options

Duration 5 Days 30 CPD hours This course is intended for This course is primarily for Developers, Developer Consultants, Help Desk/COE Support, and Program/Project Managers. Overview Learn the fundamental concepts of the ABAP programming languageEfficiently use the ABAP Workbench toolsCreate simple application programs with user dialogs (list, selection screen, screens, Web Dynpro) and database dialogs (reading from the database) In this course, students gain knowledge of the fundamental concepts of ABAP and learn how to comfortably and efficiently work with the ABAP Workbench tools in order to undertake custom developments with confidence. Flow of an ABAP Program Describing the Processing of ABAP Programs ABAP Workbench Introduction Introducing the ABAP Development Environment Organizing ABAP Developments Developing Programs Finalizing Development Basic ABAP Language Elements Defining Elementary Data Objects Using Basic ABAP Statements Working with the ABAP Debugger Modularization Introducing Modularization Modularizing Using Subroutines Modularizing Using Function Modules Implementing Function Modules Modularizing Using BAPIs Modularizing Using Global Classes Implementing Simple Global Classes and Static Methods Modularizing Using Local Classes Complex Data Objects Working with Structures Working with Internal Tables Data Modeling and Data Retrieval Modeling Data Reading Single Database Records Reading Multiple Database Records Handling Other Aspects of Database Access Working with Authorization Checks Classic ABAP Report Implementing ABAP Lists Implementing Selection Screens Implementing Events of ABAP Reports Screen Creating Screens Creating Input/Output Fields Implementing Data Transport SAP List Viewer Using the SAP List Viewer Web Dynpro ABAP Describing Web Dynpro ABAP Implementing Navigation in Web Dynpro Implementing Data Transport in Web Dynpro Program Analysis Tools Using the Code Inspector ABAP Development Tools for SAP NetWeaver Describing ABAP Development Tools for SAP NetWeaver Creating an ABAP Project in Eclipse SAP Standard Software Adjustments Adjusting the SAP Standard Software Additional course details: Nexus Humans BC400 SAP ABAP Workbench Foundations training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the BC400 SAP ABAP Workbench Foundations course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

Whether you're an average Java Developer and looking for a course to master Java Design Patterns or want to get the insights into the core of Software Development principles and Design patterns, then taking this Java Design Patterns - The Complete Masterclass - Update '18 course will be perfect for you. With this course, learn the patterns for creating versatile, reusable objects, and discover example use cases, conclude with implementation guidance, tips and techniques for avoiding the challenges posed by an individual pattern Some of the popular creational patterns such as Builder, Singleton, Prototype, Factory Method, and Abstract Factory and other essential concepts like multithreading, hierarchies and mutability also discussed in this course. By the time you complete this course, you'll be able to implement each design pattern in your own Java projects efficiently. What you'll learn Master Java Design Patterns Apply Design Patterns to Real-World Projects Build Software that's Robust and Flexible Using Java Design Patterns Solve common Software architecture problems with Java Design Patterns Requirements Working Java or any OOP Programming Language Knowledge Understand Interfaces, Composition, Inheritance, Polymorphism Willingness to learn and work hard This is NOT a Beginners Course Who this course is for: Programmers with Intermediate to advanced Software development knowledge Developers who want to learn about Programming Design Patterns Introduction Introduction 00:03:00 What You'll Get from this Course 00:05:00 Value: $5000 USD - Download Your FREE Bundle 00:05:00 Download All of the Slides Used in the Course 00:30:00 Download all the Source code for this Course 00:05:00 The gang of Four - The origins of Design Patterns -Strategy Design Pattern The Concepts Behind Design Patterns 00:05:00 The Strategy Design Pattern - Introduction 00:06:00 The Strategy Design Pattern -Score System 00:15:00 The Strategy Design Pattern - Payment System 00:02:00 The Strategy Design Pattern - Payment System - Part 2 00:12:00 The Strategy Design Pattern - Payment System - Final 00:07:00 Resources 00:15:00 Strategy Pattern Exercise and Challenge 00:15:00 The Observer Design Pattern The Observer Design Pattern 00:04:00 The Observer Design Pattern - Classes Creation 00:12:00 The Observer Design Pattern - Final 00:13:00 Resources 2 00:05:00 Strategy Pattern Exercise and Challenge 11 00:15:00 The Java Decorator Design Pattern The Decorator Design Pattern - Introduction 00:04:00 The Decorator Design Pattern - Classes Creation 00:11:00 The Decorator Design Pattern - Final 88 00:09:00 Resources 88 1 00:10:00 The Factory and Simple Factory Design Pattern Introduction to Simple Factory Design Pattern 00:07:00 The Factory Design Pattern - Introduction 00:03:00 The Factory Design Pattern - Part 2 00:12:00 The Factory Design Pattern - Final 00:08:00 Resources 88 2 00:05:00 The Singleton Design Pattern The Singleton Design Pattern - Introduction 00:03:00 The Singleton Design Pattern -Our First Singleton Class 00:06:00 The Singleton Design Pattern - Synchronized Method 00:07:00 The Singleton Design Pattern - Eager Creation 00:04:00 The Singleton Design Pattern - Double-Check Locking Creation 00:06:00 Resources 88 3 00:05:00 The Command Design Pattern in java The Command Design Pattern - Introduction 00:09:00 The Command Design Pattern - Gameboy Example 00:06:00 The Command Design Pattern - Command Interfaces Creation 00:09:00 The Command Design Pattern - Final 00:16:00 Resources 88 4 00:05:00 The Adapter Design Pattern The Adapter Design Pattern - Introduction 00:04:00 The Adapter Design Pattern - Diagram and Class Creation 00:12:00 The Adapter Design Pattern - Object Adapter 00:05:00 The Adapter Design Pattern - Final 00:03:00 Resources 88 5 00:05:00 The Facade Design Pattern The Facade Design Pattern - Introduction 00:04:00 The Facade Design Pattern - Final 00:13:00 Resources 88 6 00:05:00 The Template Design Pattern The Template Method Design Pattern 00:04:00 The Template Method Design Pattern - Part 2 00:07:00 The Template Method Design Pattern - Final 00:12:00 Resources 88 7 00:05:00 The Iterator Design Pattern About Iterator Design Pattern - Introduction 00:06:00 The Problem and Obvious Solution 00:05:00 Iterator Design Pattern Example - Geeky and Dev Stores 888 00:14:00 Rolling our Own Iterator Class 00:08:00 The Java Iterator Class 00:09:00 The State Design Pattern Introduction to Design Patterns - The State Design Pattern 00:08:00 State Design Pattern- The Obvious Solution 00:12:00 State Design Pattern- The Obvious Solution - Part 2 00:06:00 State Design Pattern- The Correct Solution - Part 1 00:13:00 State Design Pattern- The Correct Solution - Part 2 00:12:00 State Design Pattern- The Correct Solution - Test drive - Final 00:09:00 Resources 88 9 00:05:00 The Proxy Design Pattern Introduction to Proxy Design Pattern 00:05:00 Remote Proxy Design Pattern Implementation 00:11:00 Resources 88 10 00:05:00 The MVC - Model View Controller Design Pattern Introduction to MVC Design Pattern 00:07:00 MVC - Class Creation 00:10:00 MVC - Implementation 00:08:00 The Builder Design Pattern Introduction to Builder Design Pattern 00:05:00 Builder Design Pattern Implementation 00:14:00 The Interface Builder Design Pattern - Part 1 00:09:00 The Interface Builder Design Pattern - Final 00:08:00 The Prototype Design Pattern Introduction to Prototype Design Pattern 00:04:00 Cloning Person and Dolphin Objects 00:10:00 Using the Java Cloneable Interface 00:10:00 The Mediator Design Pattern Introduction to Mediator Design Pattern 00:05:00 Meditator Project with Code - Part 1 00:09:00 Meditator Project with Code - Final 00:10:00 Resources 88 11 00:05:00 The Visitor Design Pattern Introduction to Visitor Design Pattern 00:05:00 The Visitor Design Pattern - Cont. 00:07:00 The Visitor Design Pattern - Final 00:10:00 Resources 88 12 00:05:00 The Memento Design Pattern Introduction to Memento Design Pattern 00:05:00 Memento Class Creation 00:06:00 Memento - Final 00:08:00 Resources 88 13 00:05:00 The Interpreter Design Pattern Introduction to the Interpreter Design Pattern 00:03:00 The Interface Interpreter Design Pattern - Final 00:12:00 Resources 88 14 00:05:00 The Chain of Responsibility Design Pattern Introduction to Chain of Responsibility Design Patterns 00:04:00 The Chain of Responsibility Design Pattern - cont 00:09:00 The Chain of Responsibility Design Pattern - Final 00:07:00 Resources 88 15 00:05:00 The Bridge Design Pattern Introduction to Bridge Design Pattern 00:04:00 Bridge Design Pattern - Classes Setup 00:07:00 Bridge Design Pattern - Final 00:03:00 Resources 88 16 00:05:00 The Flyweight Design Pattern Introduction to Flyweight Design Pattern 00:01:00 Flyweight - Final 00:12:00

Quality Guarantee: Promising training excellence, satisfaction gurantee Accredited by CPD UK & Quality License Scheme Tutor Support Unlimited support via email, till you complete the course Recognised Certification: Accepted by thousands of professional bodies Start Anytime With 1 year access to the course materials Online Learning Learn from anywhere, whenever you want This Screenwriting Course For Beginners is designed for aspiring scriptwriters where you will learn the art of storytelling, character development and dialogue. With expert guidance, you will understand the screenplay structure, formatting, and writing for different genres. This course at a glance Accredited by CPD UK Endorsed by Quality Licence Scheme Get the introduction of the screenwriting and its principle aspects Understand to outline a screenplay Develop the skills and knowledge required for screenplay writing Learn to write a script using a template Understand to write the pitcher letter of any screenplay Learn to use visual planning tools in screenwriting Get knowledge of the software planning tool and understand its usage Learn to analyse any screenplay Understand the complete process of writing a screenplay and performing the script beat analysis on a movie script Why Screenwriting Course For Beginners right for you? This screenwriting for beginners course is ideal for someone aspiring to give a start to their screenwriting. The online course covers all the significant aspects of screenwriting and helps the learners gain proficiency in the same. By taking this online screenwriting course, the learners will understand how to write the pitch letters of the screenplay. This Screenwriting Course For Beginners will also give the learners a comprehensive understanding of the tools used for screenwriting. This screenwriting course will help you gain expertise in the visual planning tool and the software planning tool. You also learn the process to analyse any screenplay and craft it into an engaging one with the help of this informative course. By the end of the online Screenwriting Course, you will have knowledge about screenwriting and also help you strengthen the skills required to become a professional screenwriter. Screenwriting Course For Beginners Details Accredited by CPD certificates are accepted by thousands of professional bodies and government regulators here in the UK and around the world. Many organisations look for employees with CPD requirements, which means, that by doing this course, you would be a potential candidate in your respective field.   The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. Course Curriculum How to Write a Screenplay Outline - Introduction How to Write a Screenplay Outline - Introduction How to Write a Screenplay -The Pitch Letter How to Outline a Screenplay - The Concept of Beats How to Write a Screenplay - Movie Beats Pages 1 to 55 How to Write a Screenplay - Movie Beats Pages 55 to 110 Screenplay Outline |Template - Movie Script Planning Tools How to Write a Screenplay Outline - Visual Planning Tool - The Corkboard How to Write a Screenplay - Create a Software Movie Beat Planning Tool How to Write a Screenplay - Completing The Software Planning Tool How to Write a Screenplay - Movie Script Beat Analysis - Looper How to Write a Screenplay - Conclusion Who should take this course? This online screenwriting course is perfect for those willing to establish their career in screenplay writing. Those aspiring to accelerate their career prospect in the writing industry can also opt for this online screenwriting course. Entry Requirements There are no academic entry requirements for this Screenwriting For Beginners course, and it is open to students of all academic backgrounds. However, you are required to have a laptop/desktop/tablet or smartphone and a good internet connection. Assessment Method This screenwriting for beginners course assesses learners through multiple-choice questions (MCQs). Upon successful completion of the modules, learners must answer MCQs to complete the assessment procedure. Through the MCQs, it is measured how much a learner could grasp from each section. In the assessment pass mark is 60%. You can also check out our Creative Writing Course and start exploring your imagination and creativity. With our expert guidance, you can develop your writing skills and create compelling stories that captivate your readers. Certification Endorsed Certificate from Quality Licence Scheme After successfully passing the MCQ exam you will be eligible to order the Endorsed Certificate by Quality Licence Scheme. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. It will give you a competitive advantage in your career, making you stand out from all other applicants and employees. There is a Quality Licence Scheme endorsement fee to obtain an endorsed certificate which is £65. Certificate of Achievement from Lead Academy After successfully passing the MCQ exam you will be eligible to order your certificate of achievement as proof of your new skill. The certificate of achievement is an official credential that confirms that you successfully finished a course with Lead Academy. Certificate can be obtained in PDF version at a cost of £12, and there is an additional fee to obtain a printed copy certificate which is £35. FAQs Is CPD a recognised qualification in the UK? CPD is globally recognised by employers, professional organisations and academic intuitions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. CPD-certified certificates are accepted by thousands of professional bodies and government regulators here in the UK and around the world. Are QLS courses recognised? Although QLS courses are not subject to Ofqual regulation, they must adhere to an extremely high level that is set and regulated independently across the globe. A course that has been approved by the Quality Licence Scheme simply indicates that it has been examined and evaluated in terms of quality and fulfils the predetermined quality standards. When will I receive my certificate? For CPD accredited PDF certificate it will take 24 hours, however for the hardcopy CPD certificate takes 5-7 business days and for the Quality License Scheme certificate it will take 7-9 business days. Can I pay by invoice? Yes, you can pay via Invoice or Purchase Order, please contact us at info@lead-academy.org for invoice payment. Can I pay via instalment? Yes, you can pay via instalments at checkout. How to take online classes from home? Our platform provides easy and comfortable access for all learners; all you need is a stable internet connection and a device such as a laptop, desktop PC, tablet, or mobile phone. The learning site is accessible 24/7, allowing you to take the course at your own pace while relaxing in the privacy of your home or workplace. Does age matter in online learning? No, there is no age limit for online learning. Online learning is accessible to people of all ages and requires no age-specific criteria to pursue a course of interest. As opposed to degrees pursued at university, online courses are designed to break the barriers of age limitation that aim to limit the learner's ability to learn new things, diversify their skills, and expand their horizons. When I will get the login details for my course? After successfully purchasing the course, you will receive an email within 24 hours with the login details of your course. Kindly check your inbox, junk or spam folder, or you can contact our client success team via info@lead-academy.org

Accelerate your Salesforce integration expertise and master SOAP, REST, BULK API, and Streaming. Gain hands-on experience with Postman and SOAP UI and set up your environment with Visual Studio Code. Tailored for developers and Salesforce certification aspirants, this course will elevate your skills technically. Enroll now to advance your career!

Course Objectives At the end of this course you will be able to: Work with advanced lookup and reference functions Create macros to automate common tasks Use advanced techniques to analyse data Create PivotTables and PivotCharts Work with data validation tools Import and export data ' Customer Feedback Best Training Ever! Just finished a bespoke 1-1 training course in Excel Advanced, Macros & VBA. Pedro is an excellent trainer, imparting his skills and knowledge in the best way - appropriately to audience skills, knowledge and ability. Pedro is always approachable, encouraging and supportive, giving delegates the optimum learning environment. I would not hesitate to recommend Pedro as a trainer, whatever your level of ability. Amanda Morris - Treasury & Systems Accountant at Reall - Real Equity for All The course was very interesting and engaging and will definitely be put to use. The trainer was very helpful and charismatic. Marving Lopez - AM Best Europe Pedro was excellent. Very knowledgeable, clear and great rapport with class. Darren Barkey - Direct Wines Great content and learnt a lot. Really enjoyable :) Kristie-Lee Ryan - Stirling Ackroyd 1 year email support service Take a closer look at the consistent excellent feedback from our growing corporate clients visiting our site ms-officetraining co uk With more than 20 years experience, we deliver courses on all levels of the Desktop version of Microsoft Office and Office 365; ranging from Beginner, Intermediate, Advanced to the VBA level. Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering public, one to one, tailored and bespoke courses. Our competitive rates start from £550.00 per day of training Tailored training courses: You can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs. Please visit our site (ms-officetraining co uk) to get a feel of the excellent feedback our courses have had and look at other courses you might be interested in. Advanced Functions COUNT, COUNTA, COUNTIF, COUNTBLANK, SUMIF, SUBTOTAL IF, OR, AND, IFERROR VLOOKUP to lookup Exact Values and Approximate values MATCH, INDIRECT, ROW/COLUMN, INDEX, OFFSET Analysing Data PMT function to calculate a monthly payment of a loan What If Analysis using Goal Seek Use scenarios to consider many different variables Using Solver Add-in to optimize variables PivotTables Create a PivotTable to analyse worksheet data Add or remove fields in a PivotTable Change the data source for a PivotTable Working with external data sources Using different Statistical Functions Calculate a Running Total, % of Grant Total, Difference From… Using the Slicer and Timeline to filter the PivotTable Using Filters in a PivotTable Group by Date, Auto Group by ranges of values, Custom Group Create a PivotChart The GETPIVOTDATA function Formula auditing Precedents and dependents Error checking Watch a formula and its result by using the Watch Window Evaluate a nested formula one step at a time Data Validation Number Validation Data List Validation Message Prompts and Alerts Conditional Data Validation Data Validation Errors Consolidation Consolidate data by position Consolidate data by category Use a formula to consolidate data Outline (group) data in a worksheet Create an outline of rows Create an outline of columns Copy outlined data Hide or remove an outline Connect external data to your workbook Using the Power Query Editor to import data From Text and CSV, From Access, From Web, From another Workbook Using the Power Query Editor to; Transform your data by Selecting which fields to import, by Splitting Columns, Changing Data Type and more. Deleting Applied Steps Refreshing your data Working with Form Controls; Buttons, Option Buttons and Scroll Bars Introduction to Macros Change Macro Security settings How to Record a macro Some Macro Examples Delete a macro Edit the macro to view the VBA code Copy part of a macro to create another macro Assign a macro to a button Who is this course for? Who is this course for? This course is intended to end users who want to develop their skills so they can use advanced techniques to analyse extensive and complex datasets in Excel and to automate simple tasks with the use of Macros. Requirements Requirements Preferably, delegates should have attended the Excel Intermediate course. Career path Career path Excel know-how can instantly increase your job prospects as well as your salary. 80 percent of job openings require spreadsheet and word-processing software skills Certificates Certificates Certificate of completion Digital certificate - Included

Learn to build highly interactive online and mobile courses with Articulate Storyline 360 that can be delivered through any learning management system or website. It's simple enough for beginners, but powerful enough for experts. A hands-on course containing live demonstrations of an excellent learning experience.

Starting with the basics, such as variables and operators, to advanced concepts, such as inheritance and encapsulation, this course covers the entire spectrum to help you gain the skills needed to start developing applications in TypeScript.

Course Objectives At the end of this course you will be able to: Identify the components of the Microsoft Project environment Create a new project plan Create the project schedule Use different views to analyse the project plan Create, allocate and manage resources in a project plan Finalise a project plan Track progress View and report project plan information ' 1 year email support service Customer Feedback Very good course. Learnt a lot. Looking forward to the next level. Alexandra - CIAL ' 1 year email support service Take a closer look at the consistent excellent feedback from our growing corporate clients visiting our site ms-officetraining co uk With more than 20 years experience, we deliver courses on all levels of the Desktop version of Microsoft Office and Office 365; ranging from Beginner, Intermediate, Advanced to the VBA level. Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering public, one to one, tailored and bespoke courses. Our competitive rates start from £550.00 per day of training Tailored training courses: You can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs. Introduction to Microsoft Project Recap on project management concepts Project environment overview The 3 databases: Tasks, Resources and Assignments Different ways of displaying the Project Plan Access Help Creating a Project Plan Create a New Project Plan Project Information Create and apply the project calendar Defining recurring exceptions to the calendar Defining the calendar's work weeks Create the Summary tasks Create the Work Breakdown Structure Task creation and scheduling Exploring the Entry Table and its fields Task editing and the Task Information window Task Durations Defining Milestones Manual Scheduling vs Automatic Scheduling Changing the Task's Calendar Create a split in a Task Create Task Relationships Adding Lag or Lead to a Relationship Identifying the Critical Path Adding Constraints and Deadlines to Tasks Create Recurring Activities Adding Notes and links to Tasks Managing Resources Exploring the Entry Table and its fields Resource editing and the Resource Information window Resource Types Fixed Costs vs Variable Costs Adding Resource Costs Defining when costs accrue Changing the Resource Calendar and Availability Project calendar vs Resource and Task Calendar Assigning Resources to Tasks Effort Driven Scheduling Resolving Resource Overallocation Tracking the Project Progress Setting a Project Baseline Entering Actuals Different ways of viewing the Progress Checking if the Project is on track Viewing and Reporting Project Detail Adding Tasks to the Timeline and sharing it Modifying the Timescale and Zoom level Formatting the Gantt View Filtering and Grouping Tasks Print and Troubleshoot the Gantt View Using built-in Reports in Microsoft Project Who is this course for? Who is this course for? This course is designed for a person who has an understanding of project management concepts, who is responsible for creating and modifying project plans, and who needs a tool to manage these project plans. Requirements Requirements General knowledge of the Windows OS Career path Career path Microsoft Office know-how can instantly increase your job prospects as well as your salary. 80 percent of job openings require spreadsheet and word-processing software skills