4612 Employee courses in Cardiff delivered Online

Performance Management Course Overview This performance management course is accredited by the CPD 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. In any organisation, the traditional model of strict command and control wastes a significant amount of time and money. Mutual trust, employee motivation and readiness to perform can easily be undermined. Performance management, on the other hand, offers a different, much more effective approach. In formal terms, performance management involves the achievement of performance targets through the effective management of people and the environment in which they operate. It's about setting achievable goals for the organisation and targets for individuals and teams. Who should take this course? This comprehensive performance management course is suitable for anyone looking to improve their job prospects or aspiring to accelerate their career in this sector and want to gain in-depth knowledge of performance management. This performance management course is felicitous for those, who want to be the best in their jobs. Whether you are completely new to the field or are an aspiring professional, the performance management course will help open doors to a wide range of professions within your chosen field, helping you to stand out to employers with up-to-date skills that can be used to enhance your CV. Entry Requirement There are no academic entry requirements for this performance management course, and it is open to students of all academic backgrounds. Course Curriculum Module 1: The Course Structure Module 2: Definition and Benefits Module 3: Successful Performance Management Planning Module 4: Setting Goals, Objectives and Targets Module 5: Implementation Module 6: Motivation Module 7: Evaluation, Monitoring, Feedback and Coaching Recognised Accreditation CPD Certification Service This course is accredited by continuing professional development (CPD). CPD UK is globally recognised by employers, professional organisations, and academic institutions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. 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. Quality Licence Scheme Endorsed 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.     Certificate of Achievement 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

Mental Health First Aid is a course that teaches you how to recognise and respond to signs of mental distress in yourself and others. You will learn about the common types of mental health problems, their causes, symptoms, and treatments.

Did you realise that each business, by law, needs to keep books? Additionally, it is a legal prerequisite to issue sales invoices and keep accounts records for at least six years, so it is basic that organisations have an adequate and reasonable accounting framework set up. That is the reason there is an interest for qualified bookkeepers, and when you study with John's Academy, you will think that it's less demanding to land a position since you will have a perceived qualification on your CV. In this course, you will have a closer look at the role of a bookkeeper and the importance of that role in the business accounting process. You will then examine different types of business documents and reasons for record retention, filing and security. The terms Assets, Liabilities, Capital, Income and Expenditure will also be explained. In addition to this, we will also carry out some calculations using the Accounting Equation. Course Highlights Bookkeeping & Payroll Management Diploma is an award winning and the best selling course that has been given the CPD Certification & IAO accreditation. It is the most suitable course anyone looking to work in this or relevant sector. It is considered one of the perfect courses in the UK that can help students/learners to get familiar with the topic and gain necessary skills to perform well in this field. We have packed Bookkeeping & Payroll Management Diploma into 27 modules for teaching you everything you need to become successful in this profession. To provide you ease of access, this course is designed for both part-time and full-time students. You can become accredited in just 1 day and it is also possible to study at your own pace. We have experienced tutors who will help you throughout the comprehensive syllabus of this course and answer all your queries through email. For further clarification, you will be able to recognize your qualification by checking the validity from our dedicated website. Why You Should Choose Bookkeeping & Payroll Management Diploma Lifetime access to the course No hidden fees or exam charges CPD Accredited certification on successful completion Full Tutor support on weekdays (Monday - Friday) Efficient exam system, assessment and instant results Download Printable PDF certificate immediately after completion Obtain the original print copy of your certificate, dispatch the next working day for as little as £9. Improve your chance of gaining professional skills and better earning potential. Who is this Course for? Bookkeeping & Payroll Management Diploma is CPD certified and IAO accredited. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic backgrounds. Requirements Our Bookkeeping & Payroll Management Diploma is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path You will be ready to enter the relevant job market after completing this course. You will be able to gain necessary knowledge and skills required to succeed in this sector. All our Diplomas' are CPD and IAO accredited so you will be able to stand out in the crowd by adding our qualifications to your CV and Resume. Bookkeeping Module One - Introduction FREE 00:30:00 Module Two - Basic Terminology FREE 01:00:00 Module Three - Basic Terminology (II) 01:00:00 Module Four - Accounting Methods 01:00:00 Module Five - Keeping Track of Your Business 01:00:00 Module Six - Understanding the Balance Sheet 01:00:00 Module Seven - Other Financial Statements 01:00:00 Module Eight - Payroll Accounting Terminology 01:00:00 Module Nine - End of Period Procedures 01:00:00 Module Ten - Financial Planning, Budgeting and Control 01:00:00 Module Eleven - Auditing 01:00:00 Module Twelve - Wrapping Up 00:30:00 Managing Payroll What Is Payroll? FREE 01:00:00 Principles Of Payroll Systems FREE 01:00:00 Confidentiality And Security Of Information 00:30:00 Effective Payroll Processing 01:00:00 Increasing Payroll Efficiency 01:00:00 Risk Management in Payroll 00:30:00 Time Management 00:30:00 Personnel Filing 01:00:00 When Workers Leave Employment 01:00:00 Hiring Employees 01:00:00 Paye and Payroll for Employers 01:00:00 Tell HMRC about a New Employee 01:00:00 Net And Gross Pay 01:00:00 Statutory Sick Pay 00:30:00 Minimum Wage for Different types of Work 01:00:00 Mock Exam Mock Exam- Book Keeping & Payroll Management Diploma 00:20:00 Final Exam Final Exam- Book Keeping & Payroll Management Diploma 00:20:00

Register on the UK Employment Law Diploma 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 a digital certificate as a proof of your course completion. The UK Employment Law Diploma 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 UK Employment Law Diploma 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 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: 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 UK Employment Law Diploma, 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 UK Employment Law Diploma Module 01: Basic of Employment Law 00:24:00 Module 02: Legal Recruitment Process 00:43:00 Module 03: Employment Contracts 00:25:00 Module 04: Employee Handbook 00:23:00 Module 05: Disciplinary Procedure 00:15:00 Module 06: National Minimum Wage & National Living Wage 00:37:00 Module 07: Parental Right, Sick Pay & Pension Scheme 00:43:00 Module 08: Discrimination in the Workplace 00:39:00 Module 09: Health & Safety at Work 00:19:00 Module 10: Dismissal, Grievances and Employment Tribunals 00:36:00 Module 11: Workplace Monitoring & Data Protection 00:15:00 Mock Exam Mock Exam - UK Employment Law Diploma 00:20:00 Final Exam Final Exam - UK Employment Law Diploma 00:20: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.

Learn how to prevent and address sexual harassment in the workplace with our comprehensive online course. Gain valuable skills, understand legal responsibilities, and create a safe environment.

24 Hours Left! Don't Let the Winter Deals Slip Away - Enrol Now! From time management to employee care to customer service, you must have special skills to run your Restaurant job well. If you want a smooth-running Restaurant and create a dynamic team behind it, then put this Restaurant Management course in your basket and start your journey with us. This Advanced Diploma in Restaurant Management at QLS Level 7 course is endorsed by The Quality Licence Scheme and accredited by CPD to make your skill development & career progression more accessible than ever! This Restaurant Management course covers the basics of hotel demand management, managing the delivery of hospitality management, and the role of Restaurant Management in different areas. You'll learn how the process of development and training in the hospitality industry impacts the relevant sector, and you'll explore the tools & techniques that will help you effectively do the design & construction of the food premises and equipment services. Our Restaurant Management course has been designed according to your abilities and goals. You will also be introduced to hazard analysis, critical control points, proper food handling techniques, storage of food, correct temperatures to prevent food contamination and personal hygiene for food handlers. So, get started with this Restaurant Management course - take the time to develop and determine your Restaurant's ultimate plan for success! What You'll Learn From Course: Effectively deal with customer complaints to encourage return visits. Learn the ways that managers plan, organise and market Restaurants. The role of a supervisor in Personal Hygiene, Pest Management and Preventing Contamination. How to take advantage of current modes of advertising to gain the most exposure. Supervise revenue and expenses to ensure the Restaurant is operating perfectly. Determine ways to increase sales of Restaurants such as special promotions, catering services, menu changes, and entertainment. This course can help you to accomplish your ambitions and prepare you for a meaningful career. So, join us today - gear up with the essential skills to set yourself up for excellence! Skills You Will Gain Food handling and safety techniques Commercial business management Staff development and training Workplace risk assessment Front office operations Why choose Us? Opportunity to earn a certificate endorsed by the Quality Licence Scheme and another certificate accredited by CPD Get a free student ID card! (£10 postal charges will be applicable for international delivery) Innovative and engaging content. Free assessments 24/7 tutor support. Take a step toward a brighter future! **Course Curriculum** Here is the curriculum breakdown of this Course: Module 1: Introduction Module 2: An Overview of the Hotel Industry Module 3: Restaurant Industry Module 4: Restaurant Leadership and Management Module 5: The Process of Selection and Recruitment in the Hospitality Industry Module 6: The Process of Development and Training in the Hospitality Industry Module 7: Front Office Operations Module 8: Food and Beverage Operations Module 9: Food Safety - An Introduction Module 10: Supervision of Food Safety Module 11: Food Safety Legislation Module 12: Food Safety System Module 13: Food Safety Tools Module 14: Contamination Hazards Module 15: Controlling Contamination Module 16: Food Poisoning (Bacterial) and Food-Borne Illness Module 17: Food Poisoning (Non-Bacterial) Module 18: Personal Hygiene Module 19: Food Premises and Equipment: The Design and Construction Module 20: Pest Management Module 21: Food Safety Training for the Staff Assessment Process You have to complete the assignment questions given at the end of the course and score a minimum of 60% to pass each exam. Our expert trainers will assess your assignment and give you feedback after you submit the assignment. After passing the Advanced Diploma in Restaurant Management at QLS Level 7 exam, you will be able to request a certificate with additional cost that has been endorsed by the Quality Licence Scheme. CPD 180 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 course. This course is open to everybody. Requirements You will not need any prior background or expertise to enrol in this course. Career path Now that you know the ins and outs of Restaurant Management, are you ready to start looking for a job? There are pretty much several paths to take including: General Manager/Owner Assistant General Manager Bar or Service Manager Host/Server Catering Sales Manager QSR Team Manager Assistant Restaurant Manager Catering and Banquet Chef Food and Beverage Director Certificates CPD Accredited Certificate Digital certificate - £10 Advanced Diploma in Restaurant Management at QLS Level 7 Hard copy certificate - £139 After successfully completing the Advanced Diploma in Restaurant Management at QLS Level 7 course, you can order an original hardcopy certificate of achievement endorsed by the Quality Licence Scheme. The certificate will be home-delivered, with a pricing scheme of - 139 GBP inside the UK 149 GBP (including postal fees) for international delivery CPD Accredited Certificate 29 GBP for Printed Hardcopy Certificate inside the UK 39 GBP for Printed Hardcopy Certificate outside the UK (international delivery)

>>24 Hours Left! Don't Let the Winter Deals Slip Away - Enrol Now!<< Life is too short for boring nails! If nail art is one of your hobbies, it is high time to let your imagination fly. Join us in this nail technician course to learn the principles of nail art and work your way towards a lucrative nail technician profession. This comprehensively designed course will prepare you to work with a wide range of clients and be innovative in your work. This Diploma in Nail Technician at QLS Level 5 course is Endorsed by The Quality Licence Scheme Accredited by CPDQS (with 150 CPD points) This course will teach you how to care for and design your fingers and toenails. It will discuss the anatomy of the skin and nails, as well as the many nail problems. It will then walk you through the manicure and pedicure procedure and introduce you to crucial nail care items. You'll also learn how to work with artificial nails as well as numerous nail art techniques. Finally, it will provide fantastic advice on career prospects and relevant business opportunities. Nowadays, both men and women want their nails to be in ideal condition. As a result, the demand for nail salons is increasing. A career as a nail technician would be the best approach to taking advantage of the situation. This nail technician course can help you establish a nail tech profession while also earning money on the side. So, without further ado, enrol now! We are offering two more courses with this Nail Technician at QLS Level 5 course: Main Course: Diploma in Nail Technician at QLS Level 5 Bonus Course 1: Gel Manicure and Nail Artist Diploma Bonus Course 1: Personal Hygiene Course Learning Outcome of This Nail Technician Course: Discover how to clean, cut, and shape your nails. Learn the anatomy of nails. Investigate the ideas and methods of nail art. Be able to design various nail art styles. Learn about the different types of nail disorders. Learn how to provide customers with manicures, pedicures, and other nail treatments. Understand the instruments used in manicures and pedicures. Understand the UK legislation and pandemic implications. Be able to offer aftercare guidance to a customer. Discover how to open a nail salon. Why Prefer This Nail Technician Course? Opportunity to earn a certificate endorsed by the Quality Licence Scheme and another accredited by CPDQS after completing the Nail Technician course Get a free student ID card! Get instant access to this nail technician course. Learn to be a nail technician from anywhere in the world Nail Technician are affordable and simple to understand Nail Technician is entirely online, interactive lesson with voiceover audio Lifetime access to the Nail Technician course materials Nail Technician comes with 24/7 tutor support Take a step toward a brighter future! *** Course Curriculum *** Here is the curriculum breakdown of the Nail Technician course: Module 01: Nail Technician 101 Module 02: General Anatomy Module 03: Skin Structure, Growth, and Nutrition Module 04: Anatomy of Nail Module 05: Equipment for the Technician Module 06: Tools and Techniques Module 07: Basics of Chemistry and Chemicals Module 08: Nail Product Chemistry Module 09: Manicure Module 10: Pedicure Module 11: Nail Diseases and Skin Problems Module 12: Artificial Nails Module 13: Nail Art Module 14: Safety Practices Module 15: Career Prospect and Business Preparations Module 16: UK Legislations and Pandemic Implications Assessment Process of Nail Technician at QLS Level 5 Course: You have to complete the assignment questions given at the end of the course and score a minimum of 60% to pass each exam. After passing the Diploma in Nail Technician at QLS Level 5 course exam, you will be able to request a certificate at an additional cost that has been endorsed by the Quality Licence Scheme. CPD 150 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Beginners in nail care and design. Beauty industry professionals. Nail art enthusiasts. Freelance nail technician s. Salon owners and managers. Career changers interested in nail technology. Requirements You will not need any prior background or expertise to enrol in this Nail technician course. Career path This course delivers important abilities that would benefit you in pursuing the following professions: Nail Technician Manicurist\Pedicurist Beauty Salon Employee/Business Nail Art Influencer Nail Technician Instructor In the United Kingdom, the average salary for these occupations ranges from £24,450 to £51,503 per year. Certificates Certificate of completion Digital certificate - Included Diploma in Nail Technician at QLS Level 5 Hard copy certificate - £119 Show off Your New Skills with a Certificate of Completion After successfully completing the Diploma in Nail Technician at QLS Level 5, you can order an original hardcopy certificate of achievement endorsed by the Quality Licence Scheme. The certificate will be home-delivered, with a pricing scheme of - 119 GBP inside the UK 129 GBP (including postal fees) for International Delivery Certificate Accredited by CPDQS 29 GBP for Printed Hardcopy Certificate inside the UK 39 GBP for Printed Hardcopy Certificate outside the UK (International Delivery)

A Complete Guide for Effective LinkedIn Ads' is a comprehensive course that covers the fundamentals of setting up and managing successful LinkedIn Ads campaigns. Participants will learn to drive website traffic, utilize sponsored messages, generate leads, and effectively manage billing centers on the platform. Learning Outcomes: Understand the basics of LinkedIn Ads and their role in digital marketing. Learn how to set up LinkedIn Ads to drive targeted website traffic. Discover techniques for leveraging sponsored messages to engage with the audience. Acquire the skills to create and optimize LinkedIn Ads for lead generation. Gain proficiency in managing the billing center for efficient campaign budgeting and monitoring. Why buy this Excel VBA/Macros Foundations? Unlimited access to the course for forever Digital Certificate, Transcript, student ID all included in the price Absolutely no hidden fees Directly receive CPD accredited qualifications after course completion Receive one to one assistance on every weekday from professionals Immediately receive the PDF certificate after passing Receive the original copies of your certificate and transcript on the next working day Easily learn the skills and knowledge from the comfort of your home Certification After studying the course materials of the Excel VBA/Macros Foundations there will be a written assignment test which you can take either during or at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60. Who is this course for? This Excel VBA/Macros Foundations course is ideal for Students Recent graduates Job Seekers Anyone interested in this topic People already working in the relevant fields and want to polish their knowledge and skill. Prerequisites This Excel VBA/Macros Foundations does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Excel VBA/Macros Foundations was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Career path As this course comes with multiple courses included as bonus, you will be able to pursue multiple occupations. This Excel VBA/Macros Foundations is a great way for you to gain multiple skills from the comfort of your home. Course Curriculum Section 01: Introduction Recording Macros vs Writing VBA 00:04:00 Understanding Objects in Excel VBA 00:07:00 Understanding VBA Syntax and Parts of Speech 00:10:00 Activating the Developer tab 00:01:00 Recording a basic Macro 00:05:00 Absolute vs Relative Macro recording 00:04:00 Section 02: Exploring the Visual Basic Environment Introduction to the Visual Basic Environment 00:02:00 The Project Explorer 00:02:00 The Properties Window 00:02:00 The Code Window 00:04:00 Immediate, Locals and Watch Window 00:03:00 Dealing with Modules 00:03:00 Comments in Excel VBA 00:01:00 Section 03: The Range Object Introduction and Changing Cell Values 00:10:00 Adding a text to a cell 00:01:00 Dealing with Named Ranges 00:03:00 Value vs Text Property 00:04:00 Row and Column properties 00:02:00 The Select Method 00:02:00 The Count Property 00:04:00 The Address Property 00:09:00 The Formula Property 00:03:00 The Number Format Property 00:07:00 The Font Property 00:08:00 Section 04: Understanding the Cells Collection Object What is the cells object? 00:06:00 Using the Cells collection to affect cells positionally within a range 00:05:00 Affecting all cells within a sheet 00:02:00 Combining Range and cells objects 00:03:00 Section 05: Working with Sheets/Worksheets Selecting Sheets 00:06:00 Adding Sheets 00:11:00 Sheets vs Worksheets 00:04:00 Copying Sheets 00:05:00 Moving Sheets 00:01:00 Deleting Sheets 00:04:00 Section 06: Understanding Variables in Excel VBA Introduction to Variables 00:06:00 Variable Data Types 00:09:00 Declaring Variables 00:14:00 Object Variables 00:08:00 Calling a procedure from Another Procedure & Variable Scope 00:03:00 Public and Private Variables 00:07:00 Declaring Constants 00:04:00 Exercises-Variables 00:06:00 Section 07: Dealing with Workbooks Referring to Workbooks-Different ways 00:04:00 Closing Workbooks 00:03:00 Adding and Saving Workbooks Part 1 - Save method 00:04:00 Adding and Saving Workbooks Part 2 - Save as method 00:10:00 Opening Workbooks 00:06:00 Section 08: Must Know Excel VBA Logic Finding the Last row 00:09:00 Finding the Last Column 00:04:00 Finding the next row 00:04:00 The WITH Statement 00:04:00 Comparison operators in Excel VBA 00:01:00 IF Statements- Simple IF Statements 00:07:00 IF THEN ELSE Structure 00:03:00 IF THEN ELSEIF Structure 00:07:00 Nested IFs 00:04:00 OR - AND logical operators 00:07:00 NOT Logical operator 00:03:00 CASE Statements Part 1 - Single Case Statements 00:09:00 CASE Statements Part 2 - Nested Case Statements 00:06:00 Case Statements-Exercise 00:01:00 GOTO and Labels 00:03:00 Section 09: Looping in Excel VBA Loops-Introduction 00:01:00 FOR NEXT Loop 00:11:00 Exit For 00:09:00 Exercise - For Next loop 00:01:00 FOR EACH Loop - Intro 00:07:00 FOR EACH Loops - More examples 00:05:00 Do Loop - Introduction 00:04:00 Do Loop Example 00:01:00 Do Until 00:02:00 Do While 00:02:00 Do while vs Do until - Movies Example 00:04:00 Exit Do Statement 00:05:00 Exercise - Do Loop 00:01:00 Section 10: Interacting with Your Users The Messagebox - Introduction 00:03:00 Messagebox -Inputs 00:07:00 Messagebox - Capturing the User's input 00:05:00 Adding a new line to your VBA Strings 00:02:00 The Inputbox - introduction 00:04:00 Inputbox - Example1 - Capturing a user's name 00:05:00 Inputbox -Employee Database Example Part 1 00:05:00 Inputbox -Employee Database Example Part 2 00:04:00 Exercise - InputBox 00:02:00 Section 11: Error Handling in Excel VBA Error Handling - Introduction 00:09:00 Different Error types in action 00:04:00 On Error Goto statement 00:04:00 Resetting the error handling Status with On Error Goto 00:02:00 The Err Object 00:07:00 Setting a Breakpoint 00:02:00 Section 12: Triggering Code with Events! Worksheet Events -Selection change 00:08:00 Worksheet Events - Worksheet Activate event 00:03:00 Worksheet Events - Deactivate event 00:02:00 Worksheet Events - Before Delete Event 00:02:00 Worksheet Events - Before Double click event 00:08:00 Worksheet Events - Before Right Click event 00:03:00 Worksheet Events - Calculate event 00:03:00 Enabling and Disabling Events 00:03:00 Worksheet events - Worksheet change event 00:11:00 Workbook Events - Follow Hyperlink event 00:02:00 Worksheet events -Exercise 00:01:00 Workbook Events - Workbook open event 00:05:00 Workbook Events - Workbook Activate event 00:02:00 Workbook Events - Workbook Before save event 00:06:00 Workbook Events - Workbook Aftersave event 00:04:00 Workbook Events - Workbook Beforeclose event 00:09:00 Workbook Events - Workbook BeforePrint event 00:03:00 Workbook Events -Workbook De-activate events 00:02:00 Workbook Events - New Chart event 00:08:00 Workbook Events -New sheet event 00:03:00 Workbook Events - Sheet calculate event 00:03:00 Workbook Events - Sheet De-activate event 00:06:00 Workbook Events - Follow Hyperlink event 00:02:00 Workbook Events - Workbook Window Activate event 00:06:00 Workbook Events - Workbook Window De-Activate event 00:02:00 Workbook Events - Window Resize event 00:02:00 Exercise- Workbook Events 00:01:00 Resources Resources - Excel VBA/Macros Foundations 00:00:00 Assignment Assignment - Excel VBA/Macros Foundations 00:00:00

Enhance workplace safety with our Health and Safety Advanced Diploma. Gain comprehensive knowledge and skills to identify hazards, implement preventive measures, and ensure regulatory compliance. Enroll now to become a proficient health and safety professional and protect your organization's workforce.

HR Training Course Course is one of our best selling and most popular course. This course is suitable for anyone aspiring to or already working in the field of HR Management and looks at skills needed to improve workplace management. By taking this course you will gain the necessary skills to perform effectively in this field. The HR Training Course Course is organized into 26 modules and includes everything you need to become successful in this profession. To make this course more accessible for you, we have designed it for both part-time and full-time students. You can study at your own pace or become an expert in just 11 hours! If you require support, our experienced tutors are always available to help you throughout the comprehensive syllabus of this course and answer all your queries through email. 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? HR Training Course is suitable for anyone who wants 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 about this subject. Course Content HR Training Course Course Overview 00:15:00 Defining Human Resources 00:15:00 Performing a Skills Inventory 00:15:00 Forecasting Techniques 00:15:00 Job Analysis 00:00:00 Identifying Job Competencies 00:30:00 Position Profiles and Job Descriptions 00:30:00 Do You Really Need to Hire? 00:30:00 Finding Candidates 00:30:00 Advertising Guidelines 00:00:00 Screening Resumes 00:30:00 Preparing for the Interview 00:15:00 Conducting the Interview 01:00:00 After the Interview 00:15:00 Employee Orientation and Onboarding 00:30:00 Follow the Leader 00:15:00 Planning Training 00:15:00 Working With External Providers 00:15:00 Performance Reviews 01:00:00 Attendance Management 00:30:00 Managing a Diverse Workforce 00:30:00 Privacy Issues 00:15:00 Compensation and Benefits 01:00:00 Managing Disciplinary Issues 00:30:00 Terminating Employees 00:15:00 Exit Interviews 00:15:00 Mock Exam Mock Exam- HR Training Course 00:20:00 Final Exam Final Exam- HR Training Course 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.