2455 Courses delivered Online

Automate your Excel workflow, accelerate your productivity, and master the fundamentals of programming with VBA!

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

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

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

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

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.

OCA Prep Included

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.

Gain the skills and credentials to kickstart a successful career and learn from the experts with this step-by-step