18924 Courses

🚀 Unlock the Power of Microsoft Excel with Our Excel VBA Programming Training Course! 📊 Are you ready to take your Excel skills to the next level? Dive deep into the world of Excel VBA programming and unleash the full potential of this powerful tool! Our comprehensive online course, 'Microsoft Excel VBA Programming Training,' is designed to equip you with the expertise needed to automate tasks, streamline processes, and boost productivity within Excel. Here's what you'll learn in this dynamic course: 📌 Section 1: Introduction Get acquainted with the fundamentals of Excel VBA programming. Understand its significance and explore the vast possibilities it offers to transform your Excel experience. 📌 Section 2: Macros Master the art of creating and executing macros to automate repetitive tasks and significantly reduce manual work. Learn to streamline your workflow like a pro! 📌 Section 3: VBA Editor Navigate the VBA Editor seamlessly. Gain proficiency in using this interface to write, edit, and debug your VBA code effectively. 📌 Section 4: Variables and Procedures Understand the concept of variables and procedures in VBA. Learn how to declare, assign, and utilize them efficiently to optimize your coding process. 📌 Section 5: Loops and IF Statements Discover the power of loops and conditional IF statements. Harness these constructs to create dynamic and responsive Excel applications. 📌 Section 6: Error Handling Learn robust error-handling techniques to troubleshoot issues and create resilient VBA programs. 📌 Section 7: User Defined Functions Unlock the potential of creating custom functions tailored to your specific needs, enhancing Excel's capabilities beyond its default functions. 📌 Section 8: Assignments Apply your newfound knowledge through hands-on assignments and practical exercises to reinforce your skills. 📌 Section 9: Creating Forms Explore the creation of user-friendly forms and interfaces within Excel, making interactions more intuitive and efficient. Whether you're a beginner or have some experience in Excel, this course is tailored to suit your learning needs. With comprehensive modules, real-world examples, and expert guidance, you'll gain the confidence to create powerful VBA scripts and automate Excel operations like never before! Join us today and embark on a transformative journey in mastering Microsoft Excel VBA programming. Elevate your Excel skills and become a proficient VBA programmer! Enroll now and excel in Excel VBA programming! 💡📈✨ Course Curriculum Section 1 - Introduction What is VBA 00:00 Object Orientated Programming 00:00 Section 2 - Macros Macros Initial Setup 00:00 Recording a Macro 00:00 Saving a Macro 00:00 Section 3 - VBA Editor Launching VBA 00:00 VB Editor 00:00 Custom Menu 00:00 Naming Projects 00:00 Modules 00:00 Code Window 00:00 Comments 00:00 Section 4 - Variables and Procedures Introduction 00:00 Vraibales 00:00 Variable Exercise 00:00 What are Procedures 00:00 What are Procedures - Part Two 00:00 What are Procedures - Part Three 00:00 Message Boxes 00:00 Input Box 00:00 Input Box - Part Two 00:00 Basic Navigation 00:00 Sheets 00:00 Draft LessonCell Navigation 00:00 Advanced Sheets 00:00 Offset 00:00 Section 5 - Loops and IF Statements Introduction 00:00 Operators 00:00 Using Variables 00:00 What is Automation 00:00 For Loop 00:00 Do Loops 00:00 IF Statements 00:00 IF Statements - Part Two 00:00 Select Case 00:00 Section 6 - Error Handling Debugging 00:00 Section 7 - User Defined Functions UDFs 00:00 Section 8 - Assignments Introduction 00:00 Exercise 1 - Record a Macro 00:00 Exercise 2 - Duplicating Data 00:00 Exercise 3 - Generate a Report 00:00 Generate a Report - Part Two 00:00 Exercise 4 - Inner and Outer Loops 00:00 Inner and Outer Loops - Part Two 00:00 Inner and Outer Loops - Part Three 00:00 Inner and Outer Loops - Part Four 00:00 Inner and Outer Loops - Part Five 00:00 Section 9 - Creating Forms Form Controls 00:00 Building the Form 00:00 Initialize the Form 00:00 Command Buttons 00:00 Command Buttons - Part Two 00:00

Register on the Advanced Diploma in PHP Web Development with MySQL, GitHub & Heroku today and build the experience, skills and knowledge you need to enhance your professional development and work towards your dream job. Study this course through online learning and take the first steps towards a long-term career. The course consists of a number of easy to digest, in-depth modules, designed to provide you with a detailed, expert level of knowledge. Learn through a mixture of instructional video lessons and online study materials. Receive online tutor support as you study the course, to ensure you are supported every step of the way. Get an e-certificate as proof of your course completion. The Advanced Diploma in PHP Web Development with MySQL, GitHub & Heroku is incredibly great value and allows you to study at your own pace. Access the course modules from any internet-enabled device, including computers, tablet, and smartphones. The course is designed to increase your employability and equip you with everything you need to be a success. Enrol on the now and start learning instantly! What You Get With The Advanced Diploma in PHP Web Development with MySQL, GitHub & Heroku Receive a e-certificate upon successful completion of the course Get taught by experienced, professional instructors Study at a time and pace that suits your learning style Get instant feedback on assessments 24/7 help and advice via email or live chat Get full tutor support on weekdays (Monday to Friday) 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 Certification Upon successful completion of the course, you will be able to obtain your course completion e-certificate free of cost. Print copy by post is also available at an additional cost of £9.99 and PDF Certificate at £4.99. Who Is This Course For: The course is ideal for those who already work in this sector or are an aspiring professional. This course is designed to enhance your expertise and boost your CV. Learn key skills and gain a professional qualification to prove your newly-acquired knowledge. Requirements: The online training is open to all students and has no formal entry requirements. To study the Advanced Diploma in PHP Web Development with MySQL, GitHub & Heroku, all your need is a passion for learning, a good understanding of English, numeracy, and IT skills. You must also be over the age of 16.  Course Content Unit 01: Introduction Introduction 00:06:00 Unit 02: Environment Configuration Module 01: Setup a PHP Environment using XAMPP 00:16:00 Module 02: Install Composer Package Manager 00:03:00 Module 03: Visual Studio Code - Web Development Add ons 00:12:00 Module 04: Create a GitHub Account 00:13:00 Module 05: Create a Heroku Account 00:08:00 Unit 03: PHP Basics and Syntax Module 01: How PHP Works 00:29:00 Module 02: IFELSE Statements 00:19:00 Module 03: Switch Statements 00:09:00 Module 04: FOR Loop 00:10:00 Module 05: WHILE AND DOWHILE Loops 00:14:00 Module 06: PHP Arrays and Manipulation 00:13:00 Module 07: String Manipulation Functions 00:28:00 Module 08: Date and Time Manipulation Functions 00:15:00 Module 09: User Defined Functions 00:22:00 Module 10: PHP Include and Require 00:22:00 Module 11: PHP Website Layout - With Bootstrap 00:23:00 Module 12: Add Project to Github 00:08:00 Module 13: Publish Website to Heroku 00:20:00 Unit 04: PHP Forms and MySQL and User Authentication Module 01: Project and Website Setup 00:21:00 Module 02: Create a Bootstrap 4 Form 00:28:00 Module 03: PHP Form - $_GET Action 00:23:00 Module 04: PHP Form - $_POST Action 00:11:00 Module 05: Design Database with phpMyAdmin 00:19:00 Module 06: Connect to Database using PHP PDO 00:18:00 Module 07: Save Records to Database 00:38:00 Module 08: View Database Records 00:36:00 Module 09: View One Record's Details 00:28:00 Module 10: Update Database Records 00:34:00 Module 11: Delete Database Records 00:11:00 Module 12: Final Touches: Form Validation, Error Messages, Success Messages 00:17:00 Module 13: Create Heroku App and Remote Database 00:21:00 Module 14: Setup Authentication Tables in Database 00:20:00 Module 15: Setup Login and Authentication 00:29:00 Module 16: Control User Access 00:08:00 Module 17: Sending Confirmation Emails 00:31:00 Module 18: Upload Profile Pictures 00:31:00 Module 19: Final Touches 00:14:00 Resources Resources - Modern PHP Web Development w/ MySQL GitHub & Heroku 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.

Running a Sprint Agile methods are becoming increasingly prevalent, and have facilitated projects in reducing time to market, being adaptive to changing customer requirements, and increasing value provided to customers and organizations. These benefits have been implemented in both IT and non-IT environments to help all types of projects. The Sprint is where it all comes together to deliver the value to the customer in the form of a finished product. This course builds on the knowledge of the 3 Scrum roles, 3 artifacts and 5 events and adds the necessary Agile techniques to get to 'Done'. In addition, you will relate the three Scrum tenets transparency, inspection and adaptation to the overall Sprint process. What you will Learn At the end of this program, you will be able to: Identify the different roles, events & artifacts Understand Basics of a Sprint Transition a managed team to a self-managing team Understand different technical practices Bring visibility into Project Status Understand Do's & Don'ts during a Sprint Sprint Basics Review Self-Organization Technical Practices Transparency Sprint Review and Retrospectives

Confidence On Camera Certification On the off chance that the prospect of showing up in movie form fills you with fear, you're in good company. Numerous individuals despise being before the camera, in any event, when they are talking about a natural subject. This course will show you how to feel calm before the camera and make a connecting with film. You Will Learn: The most effective method to seem valid on camera Why great readiness is fundamental Instructions to put your best self forward on camera The most effective method to get your anxious spasms leveled out What to do in the event that you commit an error during shooting Advantages of Taking This Course: In the event that you have been approached to show up in a special video, this course will help you feel less reluctant about the interaction. In the event that you have been approached to give a discussion or discourse that will be recorded, this course will assist you with setting up the occasion. In the event that you need to set up your own online media channel, this course will assist you with making content. In the event that you need to utilize recordings as a component of your advertising system, this course will assist you with setting up your representatives ahead of shooting.

This comprehensive, hands-on course empowers beginners with essential web development skills. From HTML, CSS, and JavaScript to GitHub and Bootstrap, master the tools of the trade. Learn to build, style, and deploy websites effortlessly. No prior knowledge of programming or web development is needed.

Course Overview Learn the sneaky ways to create a high conversion landing page with the Best Landing Page Design & Conversion Rate Optimization course. In this course, you will learn the steps for creating your very first landing page without writing a single line of code! In this Best Landing Page Design & Conversion Rate Optimization course, you will learn the best practices to boost landing page conversion. You will explore the principles of high converting landing pages that you need to convert your website visitors into leads. You will also learn the principles of persuasion in landing pages and enhance your ability to design and build landing pages in Unbounce. Finally, you will know what exactly your landing page should include to generate traffic on your website and get your customers to take action!  Enroll today and prepare yourself for a fascinating career in the Digital Marketing Industry!  Learning Outcomes  Gain the in-demand skills in landing page design and optimization Learn the steps to increase your landing page conversion rate Identify the most common types of business models Learn the principles for good landing page design Be able to apply psychological persuasion frameworks to your landing pages Learn step-by-step how to design and build landing pages in Unbounce Know how to use scarcity on your landing page to boost conversion Who Is This Course For? This Best Landing Page Design & Conversion Rate Optimization course is beneficial for highly motivated learners interested in creating high conversion landing pages. Entry Requirement This course is available to all learners of all academic backgrounds. Learners should be aged 16 or over. Good understanding of English language, numeracy and ICT skills are required to take this course. Certification After you have successfully completed the course, you will obtain an Accredited Certificate of Achievement. And, you will also receive a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hardcopy for £39 or in PDF format at the cost of £24. PDF certificate's turnaround time is 24 hours, and for the hardcopy certificate, it is 3-9 working days. Why Choose Us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos and materials from the industry-leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; United Kingdom & internationally recognized accredited qualification; Access to course content on mobile, tablet and desktop from anywhere, anytime; Substantial career advancement opportunities; 24/7 student support via email. Career Path The Best Landing Page Design & Conversion Rate Optimization course provides essential skills that will make you more effective in your role. It would be beneficial for any related profession in the industry, such as Digital Marketing Manager Campaign Executive Digital Designer Digital Design and Content Lead Module 01: Landing Page Design and Optimisation Fundamentals Download all Section One Slides 00:48:00 Welcome to this course! Let's lay the groundwork for good landing page design 00:13:00 The Myth Of The Perfect Landing Page Conversion Rate 00:12:00 The 3 Main Types of Landing Pages and How To Use Them Effectively 00:19:00 Common Business Models and Understanding Your Conversion Actions 00:19:00 The AIDA Sales Funnel and The Online Decision Making Process 00:17:00 The Awareness Stage of the Funnel: Where It All Begins 00:18:00 The Interest Stage of the Funnel Tell Me More 00:14:00 The Desire Stage of the Funnel I Want What You Sell 00:13:00 The Action Stage of the Funnel I'm Going to Buy What You Sell 00:09:00 The Fogg Behavior Model and how it Applies to Good Landing Page Design 00:20:00 Making Your Landing Page Design Memorable 00:14:00 Module 02: Principles of Good Landing Page Design: Examples, Case Studies & Best Practices Download all Section Two Slides 00:06:00 The Primacy of Product and The Concept of Usability in Landing Page Design 00:15:00 Eschew Obfuscation: Clarity and the Quest for Fewer Question Marks 00:11:00 The 5 Second Usability Test in Landing Page Design (and how you can use it now) 00:13:00 The Art and Science Behind Designing High-Converting Calls To Action (CTA's) 00:19:00 Readability and Visual Hierarchy Landing Page Design 00:19:00 Respecting Web Conventions in Landing Page Design 00:13:00 Using Videos, Graphics and Imagery to Increase Landing Page Conversion Rates 00:20:00 Information Architecture and Accessibility - Landing Page Design Best Practices 00:20:00 Trust, Safety and Credibility (Part 1) Landing Page Design Best Practices 00:16:00 Trust, Safety and Credibility (Part 2) Landing Page Design Best Practices 00:09:00 Dedicated Landing Page Design Best Practices (Part 1) 00:15:00 Dedicated Landing Page Design Best Practices (Part 2) 00:12:00 Module 03: Principles of Persuasion in Landing Page Design Download all Section Three Slides 00:32:00 Using Scarcity to Improve Conversion Rates on Your Landing Pages 00:10:00 Principles of Persuasion - Reciprocal Concessions & Reciprocity in Landing Pages 00:12:00 Principles of Persuasion Anchoring and Cognitive Dissonance Theory 00:19:00 Module 04: Designing and Building a Landing Page Step by Step in Unbounce My Favorite Landing Page Builders and Getting Started With Our Unbounce Page 00:10:00 Getting Familiar With the Unbounce Page Builder and Adding Our Header Section 00:07:00 Creating a Logo in Photoshop and Using the Unbounce Image Uploader Tool 00:16:00 Working With Background Imagery in Landing Pages and Developing Our Hero Section 00:16:00 Creating a Form, Action Block, and Finishing the Hero Section in Unbounce 00:19:00 Discussing Landing Page Design Changes and Creating our Primary Content Section 00:16:00 Finishing Page Content, Adding Icons, Footer and Working With Buttons Unbounce 00:11:00 Publishing Your Unbounce Landing Page on Your Custom Domain 00:04:00 Adding Custom CSS in Unbounce to Create Professional Drop Shadows 00:06:00 Making Your Landing Page Design Work Better With Custom Javascript Snippets 00:08:00 Mobile Site Layout in Unbounce Based on Mobile Landing Page Design Guidelines 00:03:00 Designing Your Form Confirmation Dialogue in Unbounce and Testing Your Live Form 00:04:00 Assigning A/B Testing Variants in Unbounce and Assigning Traffic Weights 00:12:00 Integrating Your Unbounce Form Submissions With Your Mailchimp Account 00:09:00 Module 05: Bonus Goodbye For Now I Will Miss You Dearly 00:03:00 Module 06: Bonus Content: Real-Life Audits - Landing Page Design Best Practices Western Computer Audit Part 1 00:08:00 Western Computer Audit Part 2 00:09:00 Western Computer Audit Part 3 00:15:00 Western Computer Audit Part 4 00:14:00 Certificate & Transcript Order Your Certificates and Transcripts 00:00:00

Excellent course to enter a train driver job with the 'Train Driver Training for Beginners' Course. Learn Train Driver Required Skills and Attitudes.

Identify some of the unique challenges women face in their personal and professional lives, and understand how to support and empower females in the workplace.

Understand what is meant by the term menopause and why we need to talk about it. Know how menopause can affect someone at work, and how to support colleagues experiencing it.

THE NVQ HAS NO SET DATES. ONCE REGISTERED YOU WILL BE ENROLLED ON THE SYSTEM WITH COMPLETION TIMES BELOW What is an NVQ? An NVQ is a competence-based qualification. The qualification is an International recognised work-based qualification. Once qualified, it will demonstrate to employers that you are skilled and able to perform well in your role at work. This is where you will be able to demonstrate your ability at work and complete a list of job knowledge questions regarding the units in your qualification. It is the candidate’s responsibility to engage with the Assessor and gather the evidence that will match the assessment criteria in your NVQ.   How can the candidate gather the onsite/work evidence and job knowledge questions? Risk Assessment Method Statement Drawings Materials Measuring, Cutting, Positioning, and securing in place what you are installing.   Methods of ways of gathering evidence - Videos – this will be the candidate setting up their video and then demonstrating their skills and ability on site and then upload to the candidate’s portfolio. On site assessment - where your assessor will come out to you and observe you demonstrating your skills. This will depend on the site location and assessors’ location. If the site location is too far for the assessment to take place, it will be solely video evidence. Your Assessor will instruct you on how to complete your videos. Witness testimony - your Assessor will hold a recorded discussion with your manager/supervisor to confirm where, when and how you have completed the work to the specifications. Photos – They can be used as part of an assessment. They will not be accepted if the candidate isn’t in the photo. Photos cannot be used to build up a portfolio but can be used as part of the videos showing the full completed job and also in the Assessors on site assessment observation report.   Job Knowledge Questions account for 65% of the NVQ qualification. These can be saved to your computer and typed as this will be the quickest and easiest route or you can print them out and hand write them. They are very important, and they are written to see if you have the knowledge behind what you are doing on site or at work. The questions are all relevant to the work that you do.   What is the process? Speak to sales - billy@citytraining.com or 0300 373 3337 Complete the City Training Group Registration Form A copy of your photographic ID (Passport or Driving Licence) Once enrolled on the NVQ, your Online portfolio (Quals Direct) and certificate of registration will be set up. You will receive an email from the online platform with your username (your email address) and password. Arrange with your Assessor to complete your Induction. Complete your knowledge questions. Arrange with your Assessor your site assessment. Assessor will contact your Manager/Supervisor for a testimony. Recorded Professional Discussion with you to confirm your ability and authenticate your portfolio. Cost – Level 2 - £750 + Vat. If you would like to add an additional pathway, they would be £300 each added pathway. Level 3 - £950 + Vat. If you would like to add an additional pathway, they would be £300 each added pathway. Time Scale of the NVQ? The NVQ is candidate led. This will depend on how committed the candidate is and how much work the candidate has lined up. Your Assessor cannot complete you without the evidence. For a level 2, we aim to have the candidate completed in 4 – 8 weeks, Level 3 from 4 – 12/16 weeks