18145 Courses delivered Online

Are you a medical student, or would you like to become a Registered Nurse? This exclusive Control and Administration of Medicine Course Online course will teach you about the standards and legislation guiding the safe handling of medicines, as well as increase your knowledge of the classifications of medicine. The Control and Administration of Medicine Course Online course will teach you best practices for prescribing, checking, obtaining, and dispensing medicines, making it ideal for anyone starting a medical career. You will also learn about the various routes by which medicine is administered, as well as topics like contraindications and record-keeping. Learning Outcomes After completing this course, the learner will be able to: Gain a thorough understanding of the procedures for handling medication safely. Understand the principles and importance of patient confidentiality. Know the routes by which medicine can be administered. Understand the legislation and guidance regarding the safe handling of medicines. Comply with record-keeping requirements. Know the effects that can occur as a result of an adverse reaction. Be fully familiar with the different classifications of medicine. Why Choose This Course from Us Self-paced course, access available from anywhere. Easy to understand, high-quality study materials. Control and Administration of Medicine Course Online developed by industry experts. MCQ quiz after each module to assess your learning. Automated and instant assessment results. 24/7 support via live chat, phone call or email. Free PDF certificate as soon as completing the Control and Administration of Medicine Course Online. ***Other Benefits of this this Course Online *** Free One PDF Certificate Lifetime Access Unlimited Retake Exam Tutor Support [ Note: Free PDF certificate as soon as completing the Control and Administration of Medicine Course Online course] *** Control and Administration of Medicine Course Online *** Detailed Course Curriculum of this Course Online: Module 1: Overview of Medicine Management Medicines Nomenclature- an Overview Numeracy in Medicine Management A Synopsis on Clinical Pharmacokinetics Different Administration Routes Untoward Drug Reactions The way Drug Interactions Happen Module 2: Significance of Medicine Management Medicines Management- an Overview Why Medication Management Is Important Medication Management Plan Effect of Poor Medicines Management Important Tools for Managing Medications Module 3: The Best Way Medicine Can be Prescribed Essentials of Good Prescribing Recording Medication History Issuing a Drug Prescription Module 4: Common Issues in Pharmacological Management What is Dyspepsia? Acute Diarrhea and Constipation Inflammatory Bowel Disease Nausea and Vomiting Hypertension Diuretics Respiratory Conditions Diabetes Smoking Cessation Module 5: Administering Common Medicines Antibiotics Contraceptives Anticoagulants Antiplatelet Drugs Topical Agents and Emollients Topical Steroids Module 6: Defining Palliative Care Palliative Care- a brief introduction Drug Interactions in Palliative Care When to offer palliative care? Diseases that require palliative care Module 7: Medicine Optimization and its Four Principles Usefulness of Medicine Optimization Four Guiding Principles that Underpin Medicines Optimization Reflecting on Practice: Making Best Use of the Principles Module 8: Handling Medication in Residential Aged Care Facilities (RACFs) Roles and Responsibilities of People Concerned Roles of Medication Advisory Committee Sorting out of Medicines Complementary and Alternative Medicines (CAMs) and Non-Prescription Medicines- a General Overview What Medication Charts Looks Like Medication Evaluation How to Store Medicines Module 9: Law and Legislation Concerning Medicines Key Legislation focused on Health and Social Care Act 2008 Control of Substances Hazardous to Health 2002 Misuse of Drugs Act 1971 Medicines Act 1968 Misuse of Drugs (Safe Custody) Regulations 1973 -------------------- Assessment Method After completing each module of the Control and Administration of Medicine Course, you will find automated MCQ quizzes. To unlock the next module, you need to complete the quiz task and get at least 60% marks. Certification After completing the MCQ/Assignment assessment for this Control and Administration of Medicine course, you will be entitled to a Certificate of Completion from Training Tale. The certificate is in PDF format, which is completely free to download. A printed version is also available upon request. It will also be sent to you through a courier for £13.99. Who is this course for? *** Control and Administration of Medicine Course Online *** This Control and Administration of Medicines Course is suitable for medical students, and anyone interested in a career in health care. It is ideal for those new to the industry and learning key best practises. Requirements *** Control and Administration of Medicine Course Online *** There are no specific requirements for this Control and Administration of Medicine Course Online because it does not require any advanced knowledge or skills. Certificates Certificate of completion Digital certificate - Included

This Tableau Desktop Training intermediate course is designed for the professional who has a solid foundation with Tableau and is looking to take it to the next level. For Private options, online or in-person, please send us details of your requirements: This Tableau Desktop training intermediate course is designed for the professional who has a solid foundation with Tableau and is looking to take it to the next level. Attendees should have a good understanding of the fundamental concepts of building Tableau worksheets and dashboards typically achieved from having attended our Tableau Desktop Foundation Course. At the end of this course you will be able to communicate insights more effectively, enabling your organisation to make better decisions, quickly. The Tableau Desktop Analyst training course is aimed at people who are used to working with MS Excel or other Business Intelligence tools and who have preferably been using Tableau already for basic reporting. The course is split into 3 phases and 9 modules: Phase 1: AMPLIFY MODULE 1: CHECK ABILITIES Revision – What I Should Know What is possibleHow does Tableau deal with dataKnow your way aroundHow do we format chartsHow Tableau deals with datesCharts that compare multiple measuresCreating Tables MODULE 2: COMBINE DATA Relationships Joining Tables – Join Types, Joining tables within the same database, cross database joins, join calculations Blending – How to create a blend with common fields, Custom defined Field relationships and mismatched element names, Calculated fields in blended data sources Unions – Manual Unions and mismatched columns, Wildcard unions Data Extracts – Creating & Editing Data extracts MODULE 3: ADVANCED CALCULATIONS Row Level v Aggregations Aggregating dimensions in calculations Changing the Level of Detail (LOD) of calculations – What, Why, How Adding Table Calculations Phase 2: ANALYSE MODULE 4: EXPAND APPLICATION Making things dynamic with parameters Sets Trend Lines How do we format charts Forecasting MODULE 5: ADVANCED MAPPING Using your own images for spatial analysis Mapping with Spatial files MODULE 6: DATA COMPARISONS Advanced Charts Bar in Bar charts Bullet graphs Creating Bins and Histograms Creating a Box & Whisker plot Phase 3: ACT MODULE 7: ADVANCED DASHBOARDS Using the dashboard interface and Device layout Dashboard Actions and Viz In tooltips Horizontal & Vertical containers Navigate between dashboards MODULE 8: PRESENT STORIES Telling data driven stories MODULE 9: ENABLE DECISIONS What is Tableau Server Publishing & Permissions How can your users engage with content This training course includes over 25 hands-on exercises and quizzes to help participants “learn by doing” and to assist group discussions around real-life use cases. Each attendee receives a login to our extensive training portal which covers the theory, practical applications and use cases, exercises, solutions and quizzes in both written and video format. Students must bring their own laptop with an active version of Tableau Desktop 2018.2 (or later) pre-installed. What People Are Saying About This Course “Course was fantastic, and completely relevant to the work I am doing with Tableau. I particularly liked Steve’s method of teaching and how he applied the course material to ‘real-life’ use-cases.”Richard W., Dashboard Consulting Ltd “This course was extremely useful and excellent value. It helped me formalise my learning and I have taken a lot of useful tips away which will help me in everyday work.” Lauren M., Baillie Gifford “I would definitely recommend taking this course if you have a working knowledge of Tableau. Even the little tips Steve explains will make using Tableau a lot easier. Looking forward to putting what I’ve learned into practice.”Aron F., Grove & Dean “Steve is an excellent teacher and has a vast knowledge of Tableau. I learned a huge amount over the two days that I can immediately apply at work.”John B., Mporium “Steve not only provided a comprehensive explanation of the content of the course, but also allowed time for discussing particular business issues that participants may be facing. That was really useful as part of my learning process.”Juan C., Financial Conduct Authority “Course was fantastic, and completely relevant to the work I am doing with Tableau. I particularly liked Steve’s method of teaching and how he applied the course material to ‘real-life’ use-cases.”Richard W., Dashboard Consulting Ltd “This course was extremely useful and excellent value. It helped me formalise my learning and I have taken a lot of useful tips away which will help me in everyday work.” Lauren M., Baillie Gifford “I would definitely recommend taking this course if you have a working knowledge of Tableau. Even the little tips Steve explains will make using Tableau a lot easier. Looking forward to putting what I’ve learned into practice.”Aron F., Grove & Dean “Steve is an excellent teacher and has a vast knowledge of Tableau. I learned a huge amount over the two days that I can immediately apply at work.”John B., Mporium

Unlock the power of data with our 'Sales Analysis in Excel' course. Dive into e-commerce sales analysis and craft insightful sales analysis reports. Discover how to manipulate sales data, forecast trends, and automate workbook functionality. Elevate your career with advanced Excel skills! Learning Outcomes of Sales Analysis in Excel: Master data manipulation techniques for e-commerce sales analysis. Create comprehensive sales reports with Excel's advanced functions. Visualize data effectively using charts, PivotTables, and PivotCharts. Forecast future trends and make data-driven decisions. Automate repetitive tasks to boost efficiency and productivity. Why buy this Sales Analysis in Excel? 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 Sales Analysis in Excel 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? Business analysts seeking to enhance their data analysis skills. Sales professionals aiming to leverage Excel for deeper insights. Aspiring data scientists interested in e-commerce sales data. Students and graduates looking to gain a competitive edge. Entrepreneurs striving to optimize their sales strategies. Prerequisites This Sales Analysis in Excel does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Sales Analysis in Excel 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 Data Analyst: £25,000 - £40,000 Per Annum Business Analyst: £30,000 - £50,000 Per Annum Sales Analyst: £25,000 - £45,000 Per Annum Financial Analyst: £30,000 - £55,000 Per Annum Market Research Analyst: £25,000 - £40,000 Per Annum Excel Specialist: £22,000 - £35,000 Per Annum Course Curriculum Modifying a Worksheet Insert, Delete, and Adjust Cells, Columns, and Rows 00:10:00 Search for and Replace Data 00:09:00 Use Proofing and Research Tools 00:07:00 Managing Workbooks Manage Worksheets 00:05:00 Manage Workbook and Worksheet Views 00:07:00 Manage Workbook Properties 00:06:00 Working with Functions Work with Ranges 00:18:00 Use Specialized Functions 00:11:00 Work with Logical Functions 00:23:00 Work with Date & Time Functions 00:08:00 Work with Text Functions 00:11:00 Working with Lists Sort Data 00:10:00 Filter Data 00:10:00 Query Data with Database Functions 00:09:00 Outline and Subtotal Data 00:09:00 Analyzing Data Welcome to the Course 00:03:00 Apply Intermediate Conditional Formatting 00:07:00 Apply Advanced Conditional Formatting 00:05:00 Visualizing Data with Charts Create Charts 00:13:00 Modify and Format Charts 00:12:00 Use Advanced Chart Features 00:12:00 Using PivotTables and PivotCharts Create a PivotTable 00:13:00 Analyze PivotTable Data 00:12:00 Present Data with PivotCharts 00:07:00 Filter Data by Using Timelines and Slicers 00:11:00 Working with Multiple Worksheets and Workbooks Use Links and External References 00:12:00 Use 3-D References 00:06:00 Consolidate Data 00:05:00 Creating Sparklines and Mapping Data Create Sparklines 00:07:00 MapData 00:07:00 Forecasting Data Determine Potential Outcomes Using Data Tables 00:08:00 Determine Potential Outcomes Using Scenarios 00:09:00 Use the Goal Seek Feature 00:04:00 Forecasting Data Trends 00:05:00 Using Lookup Functions and Formula Auditing Use Lookup Functions 00:13:00 Trace Cells 00:09:00 Watch and Evaluate Formulas 00:08:00 Automating Workbook Functionality Apply Data Validation 00:13:00 Search for Invalid Data and Formulas with Errors 00:04:00 Work with Macros 00:18:00

*** A Better Pathway for Rapid Growth! Limited Time Opportunity; Hurry Up! *** Ignite your dynamic career and strengthen your deep insight knowledge by signing up for Strategic Account Management. This course is the ideal approach for you to obtain a thorough understanding and knowledge of the subject. We are concerned about the progression of your career. Therefore, after conducting extensive studies and consulting with experienced personnel, we formulated this outstanding course to improve your pertinent skills. In this easy-to-digest Strategic Account Management course, you will get exclusive training, which will enable you to stand out in this competitive market. However, the Strategic Account Management course covers all of the recent materials in order to keep you up to date with the job market and make you a good fit for your career. This top-notch course curriculum comprises basic to advanced levels of modules that will increase your skillsets. After completing this Programme, you will attain the productivity to succeed in your organisation. So, if you are eager to see yourself in a gratifying Strategic Account Management career, then enrol in our course today! What will make you stand out? On completion of this Strategic Account Management online course, you will gain: CPD Certified Course After successfully completing the Course, you will receive a FREE PDF Certificate as evidence of your newly acquired abilities. Lifetime access to the whole collection of Strategic Account Management learning materials. The course online test with immediate results Enroling in the Course has no additional costs. You can study and complete the course at your own pace. Study for the course using any internet-connected device, such as a computer, tablet, or mobile device. The substantial Strategic Account Management is designed to help you demonstrate the preliminary to in-depth level of learning regarding this topic. Moreover, you will be provided with the most knowledgeable and informative modules for your lifetime by enroling in this course just once. Furthermore, as you proceed through the modules of this course, you will discover the fundamentals of Strategic Account Management and explore the key topics such as: Strategic Account Management Module 01: Introduction to Key Account Management Module 02: Purpose of Key Account Management Module 03: Understanding Key Accounts Module 04: Elements of Key Account Management Module 05: What Makes a Good Key Account Manager Module 06: Building and Delivering Value to Key Accounts Module 07: Key Account Planning Module 08: Business Customer Marketing and Development Module 09: Developing Key Relationships Module 10: The Importance of Record Keeping for Key Account Management Module 11: Internal KAM Aspects Module 12: The Value Proposition Therefore, reinforce your knowledge and furnish your skills by enroling in our Strategic Account Management course. Take one step closer to achieving your goal. Show off your new skills with a certificate of completion When you have finished all of the Strategic Account Management course lectures, a digital certificate will be available for download. CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Is This Strategic Account Management Course the Right Option for You? This Strategic Account Management course is recommended for anyone who is interested in learning more about this topic. You'll learn the fundamental ideas and gain a comprehensive understanding of the topic by taking this course. This Strategic Account Management course is open to everybody. You can access the course materials from any location in the world and there are no requirements for enrolment. You should enrol in this Strategic Account Management course if you: Aspire to understand Strategic Account Management better. Already working on it and eager to learn more. Is a student pursuing a relevant field of study? Trying to get a job in Strategic Account Management-related fields. Requirements Without any formal requirements, you can delightfully enrol in this Strategic Account Management course. Just get a device with internet connectivity and you are ready to start your learning journey. Thus, complete this Strategic Account Management course at your own pace. Career path The aim of this exclusive Strategic Account Management course is to help you toward your dream career. So, complete this Strategic Account Management course and enhance your skills to explore opportunities in relevant areas.

If you aim to enhance your Penetration Tester - CPD Certified skills, our comprehensive Penetration Tester - CPD Certified course is perfect for you. Designed for success, this Penetration Tester - CPD Certified course covers everything from basics to advanced topics in Penetration Tester - CPD Certified. Each lesson in this Penetration Tester - CPD Certified course is crafted for easy understanding, enabling you to become proficient in Penetration Tester - CPD Certified. Whether you are a beginner or looking to sharpen your existing skills, this Penetration Tester - CPD Certified is the ideal choice. With our Penetration Tester - CPD Certified exclusive bundle, you will get a PDF Certificate, PDF Transcript and Digital Student ID Card (worth £50) Absolutely FREE. Courses are Included in This Penetration Tester - CPD Certified Bundle: Course 01: Web Application Penetration Testing Course 02: Penetration Testing with OWASP ZAP Course 03: CompTIA PenTest+ (Ethical Hacking) Course 04: Secure Programming of Web Applications - Developers and TPMs Course 05: Network Security Level 2 Course 06: IT: Ethical Hacking & IT Security Why Choose Our Penetration Tester - CPD Certified Course? FREE Penetration Tester - CPD Certified certificate accredited Get a free student ID card with Penetration Tester - CPD Certified Training Get instant access to this Penetration Tester - CPD Certified course. Learn Penetration Tester - CPD Certified from anywhere in the world The Penetration Tester - CPD Certified is affordable and simple to understand The Penetration Tester - CPD Certified is an entirely online, interactive lesson with voiceover audio Lifetime access to the Penetration Tester - CPD Certified course materials The Penetration Tester - CPD Certified comes with 24/7 tutor support So enrol now in this Penetration Tester - CPD Certified Today to advance your career! Start your learning journey straightaway! This Penetration Tester - CPD Certified's curriculum has been designed by Penetration Tester - CPD Certified experts with years of Penetration Tester - CPD Certified experience behind them. The Penetration Tester - CPD Certified course is extremely dynamic and well-paced to help you understand Penetration Tester - CPD Certified with ease. You'll discover how to master the Penetration Tester - CPD Certified skill while exploring relevant and essential topics. Assessment Process Once you have completed all the courses in the Penetration Tester - CPD Certified bundle, you can assess your skills and knowledge with an optional assignment. Our expert trainers will assess your assignment and give you feedback afterwards. CPD 60 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This Penetration Tester - CPD Certified bundle is suitable for everyone. Requirements You will not need any prior background or expertise. Career path This Penetration Tester - CPD Certified bundle will allow you to kickstart or take your career in the related sector to the next stage. Certificates CPD Accredited Digital certificate Digital certificate - Included CPD Accredited Hard copy certificate Hard copy certificate - £29 If you are an international student, you will be required to pay an additional fee of 10 GBP for international delivery, and 4.99 GBP for delivery within the UK, for each certificate

Overview This comprehensive course on Excel PowerQuery and PowerPivot will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Excel PowerQuery and PowerPivot 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 Excel PowerQuery and PowerPivot. It is available to all students, of all academic backgrounds. Requirements Our Excel PowerQuery and PowerPivot 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 3 sections • 28 lectures • 01:50:00 total length •pivot table power query power pivot - 1: 00:09:00 •pivot table power query power pivot - 2: 00:01:00 •pivot table power query power pivot - 3: 00:02:00 •pivot table power query power pivot - 4: 00:03:00 •pivot table power query power pivot - 5: 00:01:00 •pivot table power query power pivot - 6: 00:04:00 •pivot table power query power pivot - 7: 00:08:00 •pivot table power query power pivot - 8: 00:05:00 •pivot table power query power pivot - 9: 00:03:00 •pivot table power query power pivot - 10: 00:04:00 •pivot table power query power pivot - 11: 00:04:00 •pivot table power query power pivot - 12: 00:02:00 •pivot table power query power pivot - 13: 00:03:00 •pivot table power query power pivot - 14: 00:05:00 •pivot table power query power pivot - 15: 00:02:00 •pivot table power query power pivot - 16: 00:03:00 •pivot table power query power pivot - 17: 00:03:00 •pivot table power query power pivot - 18: 00:08:00 •pivot table power query power pivot - 19: 00:02:00 •pivot table power query power pivot - 20: 00:04:00 •pivot table power query power pivot - 21: 00:05:00 •pivot table power query power pivot - 22: 00:09:00 •pivot table power query power pivot - 23: 00:04:00 •pivot table power query power pivot - 24: 00:03:00 •pivot table power query power pivot - 25: 00:04:00 •pivot table power query power pivot - 26: 00:09:00 •Resources - Excel PowerQuery and PowerPivot: 00:00:00 •Assignment - Excel PowerQuery and PowerPivot: 00:00:00

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

Overview Our comprehensive course is designed to provide you with the necessary skills and knowledge to excel in your field. Developed by professionals with years of experience, this course is perfect for anyone looking to kick start their career or advance their skills. It features an audio-visual presentation and easy-to-learn modules, allowing for a self-paced learning experience. Our expert online support team is available during weekdays to assist you throughout the course. Learning Outcomes Upon completion of the course, you will be able to: Understand the fundamentals and its applications. Develop the necessary skills to succeed in the field . Apply your newly acquired knowledge to real-world scenarios. Create effective and efficient solutions for relevant topics. Enhance your employability and career prospects. It is designed to provide you with the knowledge needed to stand out in the competitive job market. With lifetime access to course materials and the ability to learn at your own pace, this course is the perfect opportunity to improve your skills and advance your career. You can learn at your own pace, from the comfort of your home, as all course materials are accessible online at any time. Why Choose Us? Lifetime access to course materials Full tutor support is available Monday through Friday for all courses Learn essentials skills at your own pace from the comfort of your home Gain a thorough understanding of the course Access informative video modules taught by expert instructors 24/7 assistance and advice available through email and live chat Study the course on your computer, tablet, or mobile device Improve your chances of gaining professional skills and earning potential by completing the course. Why should you study this course? The course offers a comprehensive introduction to the subject matter and provides a solid foundation for further study. It will also help students to gain knowledge and skills that can be applied in their professional or personal life. Assessment The course includes a series of quizzes that will test your understanding and retention of the material covered in the course. The quizzes will help you to identify areas where you may need further practice, and you will have the opportunity to review the course materials as needed. Upon successfully passing the final quiz, you will be able to order your certificate of achievement. Career Path The course is designed to equip you with the skills and knowledge you need to succeed in the field. After completing the course, you will be able to pursue a variety of career opportunities in different industries. Course Content END OF LIFE CARE TRAINING Module 1: Understanding End-of-Life Care Module 2: Legal and Ethical Aspects of End-of-Life Care Module 3: Identification of the Stage of Illness Module 4: Breaking Bad News & Communication in End-of-Life Care Module 5: Pain and Symptom Management Module 6: Psychosocial, Emotional, and Spiritual Care Module 7: Care in the Last Days of Life Module 8: Child and Young Adult End-of-Life Care Module 9: Hospice and Palliative Care Module 10 Nutrition and Hydration at the End of Life

Overview Creating standout logos for games is both exciting and rewarding. Our "Video Game Design Training" course helps you master this art by teaching you how to design logos that perfectly capture the essence of different game genres. From thrilling racing games to spooky horror adventures, you’ll learn how to create logos that make a lasting impression. The course takes you through each step of the design process. You’ll begin with fundamental techniques and gradually advance to more complex logo designs. Whether it’s cute cartoon characters or gritty grunge styles, you’ll gain the skills needed to tackle various design challenges. By the end of this training, you’ll be equipped with practical skills for a range of creative careers. Whether you're looking to enter game design or graphic design, our course provides the tools and knowledge you need to shine in the industry. Start crafting logos that stand out and represent your unique vision! Become proficient in Video Game Design Training by grasping all the essential knowledge from our top-quality course step by step. Enrol now to ensure that your Video Game Design Training mastery is not limited to only conceptual frameworks! This Video Game Design Training will assist you in standing out from the crowd and being more efficient in your chosen area of expertise. Furthermore, if you require assistance with the Video Game Design Training, we will provide experts who will support and guide you. So, add this Video Game Design Training to your cart and boost your personal and career development. In this Video Game Design Training, you will: Sharpen your skills to help you advance your career. Acquire a comprehensive understanding of various related topics and tips from industry experts. Learn in-demand knowledge and skills in high demand among UK employers, which will help to kickstart your Video Game Design Training career. Enrolling in the Video Game Design Training can assist you in getting into your desired career faster than you ever imagined. So, without further ado, start now! Additional Perks of Buying a Course From Institute of Mental Health Study online - whenever and wherever you want. One-to-one support from a dedicated tutor throughout your course. Certificate immediately upon course completion 100% Money back guarantee Exclusive discounts on your next course purchase from Institute of Mental Health Enrolling in the Video Game Design Course course can assist you in getting into your desired career quicker than you ever imagined. So without further ado, start now. Process of Evaluation After studying the Video Game Design Course, your skills and knowledge will be tested with a MCQ exam or assignment. You must get a score of 60% to pass the test and get your certificate.  Certificate of Achievement Upon successfully completing the Video Game Design Course, you will get your CPD accredited digital certificate immediately. And you can also claim the hardcopy certificate completely free of charge. All you have to do is pay a shipping charge of just £3.99. Who Is This Course for? This Video Game Design Course is suitable for anyone aspiring to start a career in Video Game Design Course; even if you are new to this and have no prior knowledge on Video Game Design Course, this course is going to be very easy for you to understand.  And if you are already working in the Video Game Design Course field, this course will be a great source of knowledge for you to improve your existing skills and take them to the next level.  Taking this Video Game Design course is a win-win for you in all aspects.  This course has been developed with maximum flexibility and accessibility, making it ideal for people who don't have the time to devote to traditional education. Requirements This Video Game Design Course has no prerequisite.  You don't need any educational qualification or experience to enrol in the Video Game Design Course. Do note: you must be at least 16 years old to enrol. Any internet-connected device, such as a computer, tablet, or smartphone, can access this online Video Game Design course. Moreover, this course allows you to learn at your own pace while developing transferable and marketable skills. Course Curriculum Introduction to game logo design The first question to ask 00:02:00 My game logo design process 00:03:00 The importance of sketching 00:03:00 Basic logos Simple racing game logo design 00:12:00 Simple horror game logo design 00:17:00 Simple logo for a puzzle game 00:18:00 Complex logo designs Cute cartoon game logo design - Part 1 00:13:00 Cute cartoon game logo design - Part 2 00:18:00 Design a sci-fi logo using negative space - Part 1 00:08:00 Design a sci-fi logo using negative space - Part 2 00:16:00 Cartoon fantasy RPG game logo design -Part 1 00:15:00 Cartoon fantasy RPG game logo design -Part 2 00:14:00 Grunge zombie shooter game logo design - Part 1 00:11:00 Grunge zombie shooter game logo design - Part 2 00:19:00

9 in 1 Premium Courses Bundle! CPDQS Accredited | Audio Visual Training | 90 CPD Points | Free ID Card & Assessment