2379 Courses delivered Online

Duration 3 Days 18 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 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 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 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 Topic A: Use Macros to Automate Tasks in Excel Topic B: Identify Components of Macro-Enabled Workbooks Topic C: Configure the Excel VBA Environment 2 - Automating Repetitive Tasks Topic A: Use the Macro Recorder to Create a VBA Macro Topic B: Record a Macro with Relative Addressing Topic C: Delete Macros and Modules Topic D: Identify Strategies for Using the Macro Recorder 3 - Getting Help on VBA Topic A: Use VBA Help Topic B: Use the Object Browser to Discover Objects You Can Use in VBA Topic C: Use the Immediate Window to Explore Object Properties and Methods 4 - Creating Custom Worksheet Functions Topic A: Create a Custom Function Topic B: Make Decisions in Code Topic C: Work with Variables Topic D: Perform Repetitive Tasks 5 - Improving Your VBA Code Topic A: Debug VBA Errors Topic B: Deal with Errors Topic C: Improve Macro Performance 6 - Controlling How and When Macros Run Topic A: Prompt the User for Information Topic B: Configure Macros to Run Automatically 7 - Developing Custom Forms Topic A: Display a Custom Dialog Box Topic B: Program Form Events 8 - Using VBA to Work with Files Topic A: Use VBA to Get File and Directory Structure Topic B: Use VBA to Read Text Files Topic C: Use VBA to Write Text Files 9 - Using VBA to Clean and Transform Data Topic A: Automate Power Query Topic B: Transform Data Using VBA and Workbook Functions Topic C: Use Regular Expressions Topic D: Manage Errors in Data 10 - Extending the Programming Environment Beyond the Workbook Topic A: Run Other Programs and Commands Topic B: Share Your VBA Projects

OCA Prep Included

This Level 2 Certificate in C++ Programming will be of great interest to those who wish to further their knowledge of advanced C++ programming concepts and techniques. With this Level 2 Certificate in C++ Programming you will learn about some of the advanced but key features of C++ programing such as creating and using references, and polymorphism and inheritance which are two very important parts of any Object orientated program.  Why choose this course Earn an e-certificate upon successful completion. Accessible, informative modules taught by expert instructors Study in your own time, at your own pace, through your computer tablet or mobile device Benefit from instant feedback through mock exams and multiple-choice assessments Get 24/7 help or advice from our email and live chat teams Full Tutor Support on Weekdays Course Design The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace. You are taught through a combination of Video lessons Online study materials Mock exams Multiple-choice assessment Certification After the successful completion of the final assessment, you will receive a CPD-accredited certificate of achievement. The PDF certificate is for £9.99, and it will be sent to you immediately after through e-mail. You can get the hard copy for £15.99, which will reach your doorsteps by post. Who is this course for? Level 2 Certificate in C++ Programming is suitable for anyone who want to gain extensive knowledge, potential experience and professional skills in the related field. This is a great opportunity for all student from any academic backgrounds to learn more on this subject. Course Content Module 01 Introduction 00:29:00 Starter Examples 00:33:00 Learning C Concepts 00:13:00 Module 02 Data Types and Inference 00:20:00 Sizeof and IEEE 754 00:33:00 Constants L and R Values 00:11:00 Operators and Precedence 00:25:00 Literals 00:26:00 Mock Exam Mock Exam- Level 2 Certificate in C++ Programming 00:20:00 Final Exam Final Exam- Level 2 Certificate in C++ Programming 00:20:00 Order your Certificates & Transcripts Order your Certificates & Transcripts 00:00:00 Frequently Asked Questions Are there any prerequisites for taking the course? There are no specific prerequisites for this course, nor are there any formal entry requirements. All you need is an internet connection, a good understanding of English and a passion for learning for this course. Can I access the course at any time, or is there a set schedule? You have the flexibility to access the course at any time that suits your schedule. Our courses are self-paced, allowing you to study at your own pace and convenience. How long will I have access to the course? For this course, you will have access to the course materials for 1 year only. This means you can review the content as often as you like within the year, even after you've completed the course. However, if you buy Lifetime Access for the course, you will be able to access the course for a lifetime. Is there a certificate of completion provided after completing the course? Yes, upon successfully completing the course, you will receive a certificate of completion. This certificate can be a valuable addition to your professional portfolio and can be shared on your various social networks. Can I switch courses or get a refund if I'm not satisfied with the course? We want you to have a positive learning experience. If you're not satisfied with the course, you can request a course transfer or refund within 14 days of the initial purchase. How do I track my progress in the course? Our platform provides tracking tools and progress indicators for each course. You can monitor your progress, completed lessons, and assessments through your learner dashboard for the course. What if I have technical issues or difficulties with the course? If you encounter technical issues or content-related difficulties with the course, our support team is available to assist you. You can reach out to them for prompt resolution.

Overview This comprehensive course on Kotlin Programming : Android Coding will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Kotlin Programming : Android Coding comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this Kotlin Programming : Android Coding. It is available to all students, of all academic backgrounds. Requirements Our Kotlin Programming : Android Coding is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 11 sections • 73 lectures • 05:38:00 total length •Introduction To This Course: 00:02:00 •Windows Setup: 00:13:00 •Mac Setup: 00:10:00 •Linux Setup: 00:12:00 •Online Code Editor: 00:02:00 •Variables: 00:06:00 •Data Types: 00:06:00 •String: 00:05:00 •Array: 00:07:00 •Data Type Conversion: 00:05:00 •Comments: 00:04:00 •Arithmetic Operators: 00:07:00 •Relational Operators: 00:06:00 •Assignment Operators: 00:06:00 •Unary Operators: 00:05:00 •Bitwise Operators: 00:09:00 •Logical Operators: 00:04:00 •Input & Output: 00:03:00 •Conditional if Statement: 00:05:00 •when Statement: 00:07:00 •For Loop: 00:04:00 •while Loop: 00:04:00 •do while Loop: 00:04:00 •Break Statement: 00:04:00 •Continue Statement: 00:04:00 •Basic Functions: 00:03:00 •Function Parameters: 00:04:00 •Return Values: 00:04:00 •Recursion: 00:04:00 •Default & Named Arguments: 00:06:00 •Lambda Function: 00:04:00 •Higher Order Function: 00:05:00 •Inline Function: 00:02:00 •Try Catch Block: 00:04:00 •Try Catch Expression: 00:05:00 •Multiple Catch Block: 00:05:00 •Nested Try Catch Block: 00:05:00 •Finally Block: 00:02:00 •Throw Keyword: 00:02:00 •Nullable & Non Nullable Types: 00:03:00 •Smart Cast: 00:02:00 •Unsafe and Safe Cast: 00:03:00 •Elvis Operator: 00:04:00 •List: listOf Function: 00:06:00 •List: mutableListOf Function: 00:05:00 •List: arrayListOf Function: 00:06:00 •Map: mapOf Function: 00:07:00 •Map: HashMap: 00:08:00 •Map: hashMapOf Function: 00:05:00 •Map: mutableMapOf Function: 00:04:00 •Set: setOf Function: 00:04:00 •Set: mutableSetOf Function: 00:04:00 •Set: HashSet: 00:04:00 •Basic Example: 00:07:00 •Nested and Inner Class: 00:06:00 •Constructors: 00:05:00 •Visibility Modifiers: 00:06:00 •Inheritance: 00:05:00 •Method Overriding: 00:04:00 •Property Overriding: 00:02:00 •Abstract Class: 00:03:00 •Superclass: 00:03:00 •Data Class: 00:05:00 •Multiple Class Inheritance & Interfaces: 00:03:00 •Sealed Class: 00:03:00 •Extension Function: 00:03:00 •Generics: 00:05:00 •Integer Type Range: 00:05:00 •Regex: 00:04:00 •Call Java from Kotlin: 00:03:00 •Call Kotlin from Java: 00:02:00 •Resource: 00:00:00 •Assignment - Kotlin Masterclass Programming Course: Android Coding Bible: 00:00:00

In this course, we will explore some features introduced recently in the language and a few important things that should be kept in mind while programming JavaScript. Learn some important JavaScript concepts and hacks to eliminate your fear of coding and improve your JavaScript coding skills. This course expects a fair understanding of JavaScript to start with.

Learning Outcomes Get an introduction to Python programming Know how to do conditional branching with Python Deepen your knowledge of importing external/internal libraries in Python Learn about project rock, paper and scissors as well as strings operation, time and date in Python Acquire more knowledge about data storage structures, tuples, lists and dictionary Enhance your understanding of import tricks, import operating systems and platforms and exception handling in Python Learn how to instal Packages and Scheduling in Python Description Python is a highly multi-purposeful still easy-to-understand programming language, which is why it is more adaptable all over the world. Whether to make a web application in data science, software engineering, mobile app development, or artificial intelligence - every industry uses Python to accomplish its work. Therefore, if you are planning to pursue a career in these sectors, develop your Python skills with the Diploma In Python Programming course. We made this course with an aim of enhancing your programming language skills in Python and making you job ready. Therefore, this course includes some easy-to-digest modules on topics such as - conditional branching with Python, writing user functions in Python, file handling, reading and writing using Python and many more. Moreover, we will introduce you to the procedure of data storage structures, tuples, lists and dictionaries through Python. Further topics will be discussed in the modules for which you need to enrol in our comprehensive course. So, join this course now to acquire the exclusive knowledge of Python and a CPD certificate of achievement after completing this course. Certificate of Achievement After the successful completion of the final assessment, you will receive a CPD-accredited certificate of achievement. The PDF certificate is for 9.99, and it will be sent to you immediately after through e-mail. You can get the hard copy for 15.99, which will reach your doorsteps by post. Method of Assessment After completing this course, you will be provided with some assessment questions. To pass that assessment you need to score at least 60%. Our experts will check your assessment and give you feedback accordingly. Career path After finishing this course you will get the expertise to aim for a career in the following positions: Web Developer Software Engineer Data Scientist Machine Learning Engineer Data Analyst Course Content Unit 01: Introduction to Python Programming Module 01: Course Introduction 00:02:00 Unit 02: Getting Started with Python Module 01: Software Installation 00:02:00 Module 02: Hello World Program 00:06:00 Module 03: Input and Output 00:07:00 Module 04: Calculating Average of 5 Numbers 00:03:00 Unit 03: Conditional Branching with Python Module 01: If Loop In Python 00:06:00 Module 02: Program Using If Else part 1 00:03:00 Module 03: Program Using If Else part 2 00:08:00 Module 04: Program for Calculator 00:02:00 Module 05: Program Using For Loop 00:08:00 Module 06: For Table 00:05:00 Module 07: For loop and Mathematical Operator in Python 00:04:00 Module 08: Factorial of Number Using Python 00:06:00 Module 09: Program Using While 00:05:00 Module 10: While Loop Example 00:07:00 Module 11: Tasks for Practice 00:02:00 Unit 04: Importing external/internal library in python Module 01: Importing Library in Python 00:07:00 Unit 05: Project Rock Paper and Scissors Module 01: Rock Paper and Scissor Game 00:06:00 Unit 06: Strings Operation in Python Module 01: Program Using String part 1 00:05:00 Module 02: Program using String 2 00:06:00 Module 03: Program Using String 3 00:06:00 Module 04: Program Using String part 4 00:03:00 Unit 07: Date and time in Python Module 01: Use of Date and Time part 1 00:05:00 Module 02: Use of Date and Time part 2 00:05:00 Unit 08: File Handling, read and write using Python Module 01: File Handling Part 1 00:08:00 Module 02: File Handling Part 2 00:07:00 Unit 09: Data Storage Structures, Tuple, List and Dictionary Module 01: Tuple in Python Part 1 00:10:00 Module 02: Tuple in Python Part 2 00:07:00 Module 03: Using Lists part 1 00:07:00 Module 04: Using List part 2 00:12:00 Module 05: Using Lists part 3 mm 00:06:00 Module 06: Using Lists part 4 00:08:00 Module 07: Using Lists part 5 00:02:00 Module 08: Use of Dictionary Part 1 00:04:00 Module 09: Use of Dictionary Part 2 00:05:00 Module 10: Use of Dictionary Part 3 00:08:00 Module 11: Use of Dictionary Part 4 00:07:00 Unit 10: Writing user functions in Python Module 01: Function in Python Part 1 00:06:00 Module 02: Function in Python Part 2 00:05:00 Module 03: Function in Python Part 3 00:04:00 Module 04: Function in Python Part 4 00:07:00 Module 05: Function in Python Part 5 00:08:00 Unit 11: Sending mail Module 01: Send Email 00:09:00 Unit 12: Import Tricks in Python Module 01: Import Study part 1 00:07:00 Module 02: Import Study part 2 00:03:00 Unit 13: Import Operating System and Platform Module 01: Importing OS 00:06:00 Module 02: Import Platform 00:05:00 Unit 14: Exceptions handling in python Module 01: Exception in Python part 1 00:11:00 Module 02: Exception in Python part 2 00:07:00 Module 03: Exception in Python part 3 00:05:00 Unit 15: Installing Packages and Scheduling In Python Module 01: Installing Packages using built in package manager 00:08:00 Module 02: Scheduler in Python 00:05:00 Unit 16: Data Base In Python using sqlite Module 01: Data Base 1 00:08:00 Module 02: Data Base 2 00:09:00 Module 03: Data Base 3 00:08:00 Module 04: Data base 4 00:07:00 Module 05: Data Base 5 00:06:00 Unit 17: Running Program from Command Prompt and jupyter Notebook Module 01: IDE_1 00:05:00 Module 02: IDE_2 00:07:00 Unit 18: Conclusion Module 01: Conclusion 00:02:00 Resources Resources - Diploma in Python Programming 00:00:00 Recommended Materials Workbook - Diploma in Python Programming 00:00:00 Order your Certificates & Transcripts Order your Certificates & Transcripts 00:00:00

Overview This comprehensive course on Secure Programming of Web Applications will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Secure Programming of Web Applications comes with accredited certification, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? After successfully completing the course you will be able to order your certificate, these are included in the price. Who is This course for? There is no experience or previous qualifications required for enrolment on this Secure Programming of Web Applications. It is available to all students, of all academic backgrounds. Requirements Our Secure Programming of Web Applications is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management, Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 3 sections • 18 lectures • 01:14:00 total length •Introduction and motivation: 00:02:00 •Well-known Vulnerabilities Overview: 00:02:00 •Causes & Background: 00:09:00 •Secure Programming in general: 00:03:00 •Code/Command Injection: 00:03:00 •(No)SQL Code Injection: 00:04:00 •Cross-Site Request Forgery (CSRF): 00:05:00 •Cross-Site Scripting (XSS): 00:05:00 •Open Redirection: 00:04:00 •File Inclusion / Directory Traversal: 00:05:00 •Clickjacking: 00:04:00 •Session-Hijacking: 00:07:00 •Information Disclosure: 00:03:00 •Authentification: 00:07:00 •Denial of Service: 00:05:00 •Middleware: 00:01:00 •Third-Party Software: 00:01:00 •Conclusion and Summary: 00:04:00

This is a very comprehensive introduction to Spring Boot Test, which includes Mockito, JUnit, JSONassert, Spring Data JPA, REST, design pattern, and many more. You will learn to write JUnit tests with Spring Boot and Mockito for RESTful services.

QLS Endorsed + CPD QS Accredited - Dual Certification | Instant Access | 24/7 Tutor Support

Course Overview Develop in-demand A-Frame programming skills and learn the fundamentals of virtual reality design, in this complete tutorial training course. The A-Frame Web VR Programming Tutorial Series (Virtual Reality) course will walk you through how to create incredible virtual reality experiences for websites, Oculus Rift and HTC Vive. You will gain the skills to create cross-platform games/applications from scratch, step-by-step, through the guidance of an expert instructor. Through this course, you will gain an in-depth understanding of virtual design philosophies, with full guidance on how to perform a wide range of tasks such as interacting with objects and creating animations. Kickstart a successful career in game development and enrol as a part-time or full-time student today. This best selling A-Frame Web VR Programming Tutorial Series (Virtual Reality) has been developed by industry professionals and has already been completed by hundreds of satisfied students. This in-depth A-Frame Web VR Programming Tutorial Series (Virtual Reality) is suitable for anyone who wants to build their professional skill set and improve their expert knowledge. The A-Frame Web VR Programming Tutorial Series (Virtual Reality) is CPD-accredited, so you can be confident you're completing a quality training course will boost your CV and enhance your career potential. The A-Frame Web VR Programming Tutorial Series (Virtual Reality) is made up of several information-packed modules which break down each topic into bite-sized chunks to ensure you understand and retain everything you learn. After successfully completing the A-Frame Web VR Programming Tutorial Series (Virtual Reality), you will be awarded a certificate of completion as proof of your new skills. If you are looking to pursue a new career and want to build your professional skills to excel in your chosen field, the certificate of completion from the A-Frame Web VR Programming Tutorial Series (Virtual Reality) will help you stand out from the crowd. You can also validate your certification on our website. We know that you are busy and that time is precious, so we have designed the A-Frame Web VR Programming Tutorial Series (Virtual Reality) to be completed at your own pace, whether that's part-time or full-time. Get full course access upon registration and access the course materials from anywhere in the world, at any time, from any internet-enabled device.  Our experienced tutors are here to support you through the entire learning process and answer any queries you may have via email.