3033 Courses delivered Online

Duration 1 Days 6 CPD hours This course is intended for This course is primarily designed for students who want to gain the skills necessary to use VBA to automate tasks in Excel such as collecting data from external sources, cleaning, and manipulating data. The target student may also want to learn how to create custom worksheet functions to streamline worksheet formulas and make complex worksheets easier to support, maintain, and understand. Overview 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. VBA (Visual Basic for Applications) enables you to enhance and extend the capabilities of Microsoft Excel and other applications in the Microsoft 365 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 VBA's capabilities and to optimize and debug your code. Prerequisites To ensure your success in this course, you should be an experienced Excel user who is comfortable creating and working with Excel workbooks, including tasks such as entering worksheet formulas, using absolute and relative addressing, formatting cells, and creating pivot tables and charts. This level of skill could be acquired by taking the Microsoft Excel for Office 365 (Desktop or Online) courses, Parts 1, 2, and 3. 1. Using VBA to Solve Business Problems Use Macros to Automate Tasks in Excel Identify Components of Macro-Enabled Workbooks Configure the Excel VBA Environment 2. Recording a Macro Use the Macro Recorder to Create a VBA Macro Record a Macro with Relative Addressing Delete Macros and Modules Identify Strategies for Using the Macro Recorder 3. Writing VBA Code Directly Write VBA Code Discover Objects You Can Use Create a Custom Function 4. Solving Problems through Code Make Decisions in Code Work with Variables Perform Repetitive Tasks 5. Improving Your VBA Code Debug VBA Errors Deal with Errors Improve Macro Performance 6. Controlling How and When Macros Run Prompt the User for Information Configure Macros to Run Automatically Additional course details: Nexus Humans VBA with Microsoft Excel (v1.2) 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 VBA with Microsoft Excel (v1.2) 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.

This course touches every important and advanced concept of Python, including the features of the latest version of Python 3.8 and Python 3.9. You will get to grips with recursion, lambda functions, regular expressions, walrus operator, and a lot more.

This course will help you to get familiarized with the concepts of MySQL Server and MySQL Workbench needed for database development and management. From basic SQL queries and statements to handling relationships and aggregate functions, you will learn all that you need with the help of real-time activities.

ISDN training course description A comprehensive look at ISDN, as used in voice and data environments. What will you learn Recognise the issues and impacts of using dial up networks. Describe ISDN. Describe ISDN signalling in voice and data environments. Configure a Cisco router to use ISDN. ISDN training course details Who will benefit: Anyone working with ISDN. Prerequisites: Intro to data communications & networking Duration 2 days ISDN training course contents Introduction Dialup connectivity vs. leased lines vs. packet switched networks. ISDN offerings, services, benefits vs. modems. ISDN architectures Use of ISDN by routers, Dial up, top up, backup. Internet access, PCs and ISDN. BRI and PRI ISDN switches, B channels, D channel, ISDN functions and reference points, NT1, NT2, TE1, TE2, Terminal adapters, R,S,T,U interfaces, ISDN standards. PPP Encapsulation, PPP services, PAP and CHAP, Multilink PPP, BACP. ISDN and the seven layer model B channel layers versus D channel layers, the I standards, Q.921, Q.931. Configuration issues for ISDN E.164 addressing and IP addresses, ensuring only the correct traffic brings up the ISDN line. ISDN services Bearer services, teleservices, supplementary services, MSN, sub addressing, CLI…

Sale Ends Today JavaScript Application Programming - CPD Certified Admission Gifts FREE PDF & Hard Copy Certificate| PDF Transcripts| FREE Student ID| Assessment| Lifetime Access| Enrolment Letter Till date, JavaScript remains the backbone of interactive web applications worldwide, with over 95% of all websites using it in some form. In the rapidly evolving digital landscape, mastering JavaScript is more than a skill, rather, it's a necessity. The JavaScript Application Programming bundle is designed to transform you from a novice to a master developer, and elevate your programming skills to set the web on fire. The JavaScript Application Programming bundle provides a comprehensive exploration into JavaScript and its powerful ecosystem. Starting with JavaScript Foundations for Everyone, the course progressively covers advanced topics such as JavaScript Functions and JavaScript Promises, ensuring a deep understanding of core concepts. Additional modules like jQuery, WebGL 3D Programming, and Web GIS Application Development with ASP.NET CORE MVC expand your skillset into creating dynamic, data-driven web applications along with courses in other essential languages such as Python, C#, and SQL. Courses Are Included In This JavaScript Application Programming - CPD Certified Bundle: Course 01: JavaScript Foundations for Everyone Course 02: JavaScript Functions Course 03: JavaScript Promises Course 04: jQuery: JavaScript and AJAX Coding Bible Course 05: Java Certification Cryptography Architecture Course 06: Master JavaScript with Data Visualisation Course 07: Coding Essentials - Javascript, ASP. Net, C# - Bonus HTML Course 08: Kotlin Programming: Android Coding Bible Course 09: Secure Programming of Web Applications Course 10: Web GIS Application Development with C# ASP.NET CORE MVC and Leaflet Course 11: Mastering SQL Programming Course 12: Complete Microsoft SQL Server from Scratch: Bootcamp Course 13: Ultimate PHP & MySQL Web Development & OOP Coding Course 14: SQL for Data Science, Data Analytics and Data Visualisation Course 15: Quick Data Science Approach from Scratch Course 16: Python Programming Bible Course 17: Python Programming from Scratch with My SQL Database Course 18: Machine Learning with Python Course Course 19: HTML Web Development Crash Course Course 20: CSS Web Development Course 21: Three.js & WebGL 3D Programming Course 22: Basics of WordPress: Create Unlimited Websites Course 23: Masterclass Bootstrap 5 Course - Responsive Web Design Course 24: C++ Development: The Complete Coding Guide Course 25: C# Basics Course 26: C# Programming - Beginner to Advanced Course 27: Stripe with C# Course 28: C# Console and Windows Forms Development with LINQ & ADO.NET Course 29: Cyber Security Incident Handling and Incident Response Course 30: Computer Networks Security from Scratch to Advanced Don't miss the chance to become a versatile and highly skilled software developer with our JavaScript Application Programming course. Aim to start your own tech venture, work for a top tech company, or freelance as a developer, this course will provide you with the skills needed to succeed. Enrol today to take the first step towards a lucrative career in software development, where your ability to innovate and solve complex problems will shape the future of technology! Learning Outcomes of this Bundle: Master fundamental and advanced JavaScript programming techniques. Learn to implement interactive web features using jQuery and AJAX. Develop proficiency in data visualisation with JavaScript. Understand and apply Python, C#, and SQL in web development contexts. Create responsive and secure web applications using Bootstrap and C#. Manage and deploy sophisticated web-based GIS applications. With this JavaScript Application Programming - CPD Certified course, you will get 30 CPD Accredited PDF Certificates, a Hard Copy Certificate and our exclusive student ID card absolutely free. Why Prefer this Course? Get a Free CPD Accredited Certificate upon completion of the course Get a Free Student ID Card with this training program (£10 postal charge will be applicable for international delivery) The course is Affordable and Simple to understand Get Lifetime Access to the course materials The training program comes with 24/7 Tutor Support Start your learning journey straight away! The JavaScript Application Programming course bundle is an exceptional resource for those looking to dive deep into the world of modern web development. By mastering fundamental and advanced JavaScript programming techniques, learners will gain the ability to create dynamic and interactive web applications that are both efficient and visually appealing. This foundational knowledge is essential, as JavaScript remains a critical tool for front-end development, enabling developers to implement complex features that improve user experience and site functionality. Beyond the basics, the course introduces students to data visualisation with JavaScript, which is an increasingly important skill in the tech industry. Additionally, the inclusion of frameworks like jQuery and Bootstrap ensures that learners can streamline their coding process and design responsive layouts that adapt to different devices, a must-have in today's mobile-first world. Learners will also develop proficiency in other programming languages such as Python, C#, and SQL, which are integral to backend development and database management. Moreover, this diploma offers learners the opportunity to acquire a Recognised Qualification that is highly valued in the field of JavaScript. With this Certification, graduates are better positioned to pursue career advancement and higher responsibilities within the JavaScript setting. The skills and knowledge gained from this course will enable learners to make meaningful contributions to JavaScript related fields impacting their JavaScript experiences and long-term development. Course Curriculum Course 01: JavaScript Foundations for Everyone Module 01: About the Author Module 02: Introduction to JavaScript Module 03: Strengths and Weaknesses of JavaScript Module 04: Writing JavaScript in Chrome Module 05: JavaScript Variables Module 06: Demo of JavaScript Variables Module 07: Basic Types of JavaScript Module 08: JavaScript Boolean Module 09: JavaScript Strings Module 10: JavaScript Numbers Module 11: JavaScript Objects Module 12: Demo of JavaScript Objects Module 13: JavaScript Arrays Module 14: Demo of JavaScript Arrays Module 15: JavaScript Functions Module 16: Demo of JavaScript Functions Module 17: JavaScript Scope and Hoisting Module 18: Demo of JavaScript Scope and Hoisting Module 19: Currying Functions Module 20: Demo of Currying Functions Module 21: Timeouts and Callbacks Module 22: Demo of Timeouts and Callbacks Module 23: JavaScript Promises Module 24: Demo of JavaScript Promises Module 25: Demo of Javascript Async Module 26: Flow Control Module 27: Demo of Flow Control Module 28: JavaScript For Loop Module 29: Demo of JavaScript For Loop Module 30: Demo of Switch Statements Module 31: Error Handling Module 32: Demo Project Course 02: JavaScript Functions Module 01: Introduction Module 02: Defining And Invoking Functions Module 03: Function Scope Module 04: Composing Functions Module 05: Asynchronous Functions Course 03: JavaScript Promises Module 01: JavaScript Promises Module 02: Understanding Promises Module 03: Using Promises Module 04: Multiple Promises Module 05: Handling Errors With Promises =========>>>>> And 27 More Courses <<<<<========= How will I get my Certificate? After successfully completing the course, you will be able to order your Certificates as proof of your achievement. PDF Certificate: Free (Previously it was £12.99*30 = £390) CPD Hard Copy Certificate: Free (For The First Course: Previously it was £29.99) CPD 300 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone interested in learning more about the topic is advised to take this bundle. This bundle is ideal for: Aspiring software developers. Web developers. Computer science students. Tech industry professionals. Entrepreneurs in tech. Career changers. Requirements You will not need any prior background or expertise to enrol in this course. Career path After completing this bundle, you are to start your career or begin the next phase of your career. Web Developer: $40,000 - $85,000 Software Developer: $50,000 - $120,000 Full-Stack Developer: $60,000 - $120,000 Data Analyst: $45,000 - $85,000 Systems Engineer: $60,000 - $130,000 Cyber Security Analyst: $60,000 - $100,000 Certificates CPD Accredited Digital certificate Digital certificate - Included CPD Accredited e-Certificate - Free Enrolment Letter - Free Student ID Card - Free CPD Accredited Hard Copy Certificate Hard copy certificate - Included Please note that International students have to pay an additional £10 as a shipment fee.

SAFe® Lean Portfolio Management: In-House Training Create a culture of innovation, flexibility, and speed where all people in the portfolio can effectively execute as one unified team. In this course, you will gain the practical tools and techniques necessary to implement the Lean Portfolio Management functions of Strategy and Investment Funding, Agile Portfolio Operations, and Lean Governance. You will have the opportunity to capture the current and future state of the portfolio with the Portfolio Canvas tool and identify important business initiatives for achieving the future state. You'll be able to establish portfolio flow with the Portfolio Kanban and prioritize initiatives for maximum economic benefit. The course also provides insights on how to establish Value Stream Budgets and Lean Budget Guardrails and measure the Lean portfolio performance. What you will Learn Describe the importance of LPM Connect the portfolio to enterprise strategy Implement Lean budgeting and guardrails Establish portfolio flow with the Portfolio Kanban Support operational excellence with APMO and CoPs Coordinate Value Streams Measure the LPM performance Build a plan for LPM implementation Introducing Lean Portfolio Management (LPM) Establishing Strategy and Investment Funding Applying Agile Portfolio Operations Applying Lean Governance Implementing the LPM function

Mikrotik routers training course description A fast paced practical hands on introduction to Mikrotik routers concentrating on basic product knowledge needed for the real world. Starts with the basics of accessing the routers through configuring static routes, RIP and OSPF, ending with firewalls. Hands on sessions follow all the major chapters. What will you learn Use Winbox. Use the Mikrotik command line. Perform basic troubleshooting. Configure Interfaces, RIP and OSPF. Perform housekeeping tasks such as: - save and load configurations - upgrade the OS - recover lost passwords Mikrotik routers training course details Who will benefit: Anyone who will be working with Mikrotik routers. Prerequisites: TCP/IP foundation for engineers Duration 2 days Mikrotik routers training course content Mikrotik routers RouterOS, RouterBoard. System resources. Getting started Accessing the router, Winbox, Webfig, Quickset. telnet. The command line interface Contexts, online help, basic troubleshooting. Configuring Interfaces Basics, Enabling interfaces. Ethernet, loopback interfaces. Adding IP addresses. Static routes Why use static routes? Configuring static routes, default routes. Configuring RIP How RIP works, configuration, troubleshooting. OSPF Configuration and troubleshooting. Housekeeping Configuration management, offline editing and FTP usage. RouterOS upgrades. Packages. Bypassing passwords. Other functions DHCP server. Firewall Connections, chains, actions, filters.

Self-paced course to learn about the functions of the conscious & subconscious and how hypnosis can be used to treat a wide array of issues and conditions. Individual feedback on each module submission. Successful completion required to progress to practical course for professional qualification in Curative Hypnotherapy (LCH)

SAFe® Lean Portfolio Management: Virtual In-House Training Create a culture of innovation, flexibility, and speed where all people in the portfolio can effectively execute as one unified team. In this course, you will gain the practical tools and techniques necessary to implement the Lean Portfolio Management functions of Strategy and Investment Funding, Agile Portfolio Operations, and Lean Governance. You will have the opportunity to capture the current and future state of the portfolio with the Portfolio Canvas tool and identify important business initiatives for achieving the future state. You'll be able to establish portfolio flow with the Portfolio Kanban and prioritize initiatives for maximum economic benefit. The course also provides insights on how to establish Value Stream Budgets and Lean Budget Guardrails and measure the Lean portfolio performance. What you will Learn Describe the importance of LPM Connect the portfolio to enterprise strategy Implement Lean budgeting and guardrails Establish portfolio flow with the Portfolio Kanban Support operational excellence with APMO and CoPs Coordinate Value Streams Measure the LPM performance Build a plan for LPM implementation Introducing Lean Portfolio Management (LPM) Establishing Strategy and Investment Funding Applying Agile Portfolio Operations Applying Lean Governance Implementing the LPM function

Discover how to utilize VBA to automate procedures and effortlessly generate reports with a single button press. Streamline your tasks and achieve seamless productivity by performing various actions at the click of a button. No prior knowledge of VBA is required but familiarity with Excel will be an advantage.