7085 Courses

Step into the world of data analysis and gain practical experience analyzing real-world datasets with the help of this course. This course will not only guide you in analyzing data efficiently in Python from scratch but also help you in conducting your own analysis with Python and extracting valuable insights that can transform your business!

Boost Your Career with Apex Learning and Get Noticed By Recruiters! Get Hard Copy + PDF Certificates + Transcript + Student ID Card worth £160 as a Gift - Enrol Now!

Course Objectives At the end of this course you will be able to: Record and edit a Macro Assign macros to keyboard shortcuts, Quick Access Toolbar, Buttons and Shape objects. Use the Visual Basic Editor; change the properties of an object; add a module to a project; write the code for a procedure and then run it; and use the Object Browser to search procedures Manipulate data by declaring variables of different data types; combine data by using expressions; use functions to accept input and display output; and declare variables and procedures with the appropriate scope Use decision structures to create procedures that make decisions; and use loop structures to perform repetitive tasks Create an error handling routine in case things go wrong with VBA code ' 1 year email support service Take a closer look at the consistent excellent feedback from our growing corporate clients visiting our site ms-officetraining co uk Customer Feedback Best Training Ever! Just finished a bespoke 1-1 training course in Excel Advanced, Macros & VBA. Pedro is an excellent trainer, imparting his skills and knowledge in the best way - appropriately to audience skills, knowledge and ability. Pedro is always approachable, encouraging and supportive, giving delegates the optimum learning environment. I would not hesitate to recommend Pedro as a trainer, whatever your level of ability. Amanda Morris - Treasury & Systems Accountant at Reall - Real Equity for All The trainer was very knowledgeable, kept everyone involved and was enthusiastic. A great experience.. Simon Harper - Lloyd's of London My learning experience was awesome. Perdinand Reagan - Subsea7 Very nice and relaxed approach to teaching. Was definitely a good learning experience. Jerome Pupe - S5 Agency World The Trainer – Very positive + patient + helpful + thorough Agnes Souza - Direct Wines ' With more than 20 years experience, we deliver courses on all levels of the Desktop version of Microsoft Office and Office 365; ranging from Beginner, Intermediate, Advanced to the VBA level. Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering public, one to one, tailored and bespoke courses. Our competitive rates start from £550.00 per day of training Tailored training courses: You can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs. Introduction to Macros and VBA Introducing Visual Basic for Applications Recording a Macro Naming conventions for Macro Procedures Running a Macro Absolute or Relative Cell Referencing Saving and Opening Files with Macros Making macros always available Adding Macros to Keyboard Shortcuts, Quick Access Toolbar, Buttons and Shapes Editing a Macro in the Visual Basic Editor Understanding the Development Environment Customising the Editor Tips for General Typing in VBA Using Visual Basic Help Working with Procedures Program Design Understanding Modules Naming Rules Creating a Module Understanding Procedures Programming Macro Concepts Creating a Subroutine Creating a Function Understanding Arguments Exiting Procedures Calling Procedures Objects, Properties, Methods and Events Understanding Objects Properties, Methods, and Events Navigating the Object Hierarchy Understanding Collections Accessing a Member of a Collection Understanding Hierarchy Using the Object Browser Using the With Statement Working with Properties Working with Methods Creating an Event Procedure Reserved Macro Names Using Expressions, Variables and Intrinsic Functions Understanding Expressions and Statements Declaring Variables Understanding Data Types Determining the Value of Variables Working with Variable Scope Using Built-in VBA Functions Understanding Constants Using Message Boxes Controlling the Answer to a Message Box Using Input Boxes Declaring and Using Object Variables Controlling Program Execution Understanding Control-of-Flow Structures Using the If...End If Decision Structures Nested If Statements Using the Select Case ... End Select Structure Using the Do ... Loop Structure Using the For ... Next Structure Using the For Each ... Next Structure Guidelines for Use of Control-of-Flow Structures Debugging and Handling Errors Understanding Errors Using Debugging Tools Setting Breakpoints and Using Break Mode Stepping Through Code Trapping Errors with the On Error Statement Understanding the Err Object Working with Inline Error Handling Writing an Error-Handling Routine Working with Forms and Controls Understanding UserForms Creating a Form Displaying and Removing a Form Aligning and Sizing Controls Using the Toolbox Working with a Form's Properties, Methods, and Events Working with Form and Control Properties, Methods and Event Setting the Tab Order Populating a Control Who is this course for? Who is this course for? This course is designed to give proficiency in the Visual Basic Editor (VBE), predominantly making use of Excel objects, understanding Object's Properties, Events and Methods, basic VBA Object oriented programming, event handling, control structures, and debugging tools. Requirements Requirements Preferably, delegates should have attended the Excel Advanced course. Certificates Certificates Certificate of completion Digital certificate - Included

Overview As a dedicated Caregiver, you will need the skills and confidence to assist those with special needs, which can be learnt right here. This valuable course is specifically designed to give people like you the absolute best advice when caring for individuals with learning disabilities. The Learning Disability Awareness course has been written with the assistance of industry experts, complete with tried and tested practices. You will be taught how to engage with patients and clients who possess mild to severe disabilities. The tuition includes overviews of Cerebral Palsy, Asperger's syndrome, Down's syndrome, and many more common conditions you may encounter. 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 Learning Disability Awareness. It is available to all students, of all academic backgrounds. Requirements Our Learning Disability Awareness is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible on tablets and smartphones so you can access your course on wifi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career path Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management , Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 2 sections • 11 lectures • 06:00:00 total length •Module 01: Learning Disability and Mental Health: 00:30:00 •Module 02: Learning Disability Nursing: 00:30:00 •Module 03: Psychosocial Interventions: 00:30:00 •Module 04: Psychodynamic Approaches: 00:30:00 •Module 05: Learning Disability Nursing Throughout the Lifespan: 01:00:00 •Module 06: Role of the Learning Disability Nurse in Promoting Health and Well-Being: 01:00:00 •Module 07: Care Planning in Mental Health Settings: 00:30:00 •Module 08: Nursing Models and Behavioural Interventions: 00:30:00 •Module 09: The Future of Learning Disability Nursing: 00:30:00 •Module 10: Future Spheres of Practice for Learning Disability Nursing: 00:30:00 •Assignment - Learning Disability Awareness: 00:00:00

Overview Learn to identify signs of extremism and discrimination and prevent acts of terrorism and intimidation from taking place. This comprehensive course will raise your awareness of radicalisation techniques in the UK and teach you how to react in the face of hate crime. The Safeguarding, Child Protection And Prevent course is designed to help you tackle all forms of extremist behaviour and ensure that all innocent individuals are safeguarded from harm. You will also be taught the importance of the 'Prevent Duty' and how it protects young people from exposure to this form of abuse, ensuring that British ethical beliefs are upheld and promoted. How will I get my certificate? At the end of the course there will be a written assignment test which you can take either during or after the course. After successfully completing the test you will be able to order your certificate, these are included in the price. Who is this course for? There is no experience or previous qualifications required for enrolment on this Safeguarding, Child Protection And Prevent. It is available to all students, of all academic backgrounds. Requirements Our Safeguarding, Child Protection And Prevent is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible on tablets and smartphones so you can access your course on wifi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career path Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management , Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 2 sections • 10 lectures • 04:48:00 total length •Module 01: Introduction to Family Support Work: 00:24:00 •Module 02: Legislation, Policy and Guidance: 00:51:00 •Module 03: Laws and Guidance: 00:43:00 •Module 04: Child Abuse: 00:49:00 •Module 05: Sexual Abuse: 00:38:00 •Module 06: Risks and Risk Assessment: 00:16:00 •Module 07: Responding to Disclosure and Reporting: 00:25:00 •Module 08: Things to Do after Referral: 00:24:00 •Module 09: Record Keeping: 00:18:00 •Assignment - Safeguarding, Child Protection And Prevent: 00:00:00

Overview Enrol in our Asbestos Surveyor Training Level 4 today and build the necessary skills, knowledge and experience to transform your career. The Asbestos Surveyor Training Level 4 could enhance your continuing professional development thus propelling you more towards your dream job. This Asbestos Surveyor Training Level 4 could be your key, if you are interested in a long term career in the field of Asbestos Surveyor Training Level 4. This Asbestos Surveyor Training Level 4 course consists of a number of easy to digest, in-depth modules which are designed to provide you with detailed knowledge on Asbestos Surveyor Training Level 4. This Asbestos Surveyor Training Level 4 aims to accompany you through your journey to help you become a master of Asbestos Surveyor Training Level 4. Learn through a mixture of interactive lessons and online study materials. 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 Asbestos Surveyor Training Level 4. It is available to all students, of all academic backgrounds. Requirements Our Asbestos Surveyor Training Level 4 is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible on tablets and smartphones so you can access your course on wifi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career path Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management , Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 1 sections • 9 lectures • 01:30:00 total length •Module 01: What is Asbestos?: 00:10:00 •Module 02: Health Effects of Asbestos: 00:10:00 •Module 03: Asbestos Containing Materials and Their Properties: 00:05:00 •Module 04: Management of Asbestos: 00:10:00 •Module 05: Risk Assessments and Legislative Requirements: 00:15:00 •Module 06: Asbestos Surveying: 00:10:00 •Module 07: Bulk Sampling Procedures and Strategies: 00:15:00 •Module 08: Survey Report, Quality Assurance and Quality Control: 00:10:00 •Module 09: Personal Decontamination: 00:05:00

Overview It is estimated that 1 in 6 people over the age of 60 have experienced some form of abuse in community settings. This 'Safeguarding Vulnerable Adults at Risk Complete Diploma', structured into eight comprehensive modules, is a critical tool to counteract this plight.This meticulously designed diploma course is divided into eight comprehensive modules, starting with an introduction to the fundamental principles of safeguarding. It progresses to an in-depth exploration of the various forms of abuse, delineates the categories of abuse, and offers robust strategies for responding effectively. The course further elaborates on the duties and responsibilities incumbent upon safeguarding roles, delves into specialised care for dementia patients, analyses the interplay between safeguarding and mental capacity, and concludes with a detailed examination of key legislation. How will I get my certificate? At the end of the course there will be a written assignment test which you can take either during or after the course. After successfully completing the test you will be able to order your certificate, these are included in the price. Who is this course for? There is no experience or previous qualifications required for enrolment on this Safeguarding Vulnerable Adults at Risk Complete Diploma. It is available to all students, of all academic backgrounds. Requirements Our Safeguarding Vulnerable Adults at Risk Complete Diploma is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible on tablets and smartphones so you can access your course on wifi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career path Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management , Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 1 sections • 8 lectures • 01:05:00 total length •Module 1: Introduction: 00:05:00 •Module 2: Abuse of Adults: 00:05:00 •Module 3: Categories of Abuse: 00:05:00 •Module 4: Responding to Abuse: 00:05:00 •Module 5: Safeguarding Duties and Responsibilities: 00:10:00 •Module 6: Dementia Care: 00:15:00 •Module 7: Safeguarding and Mental Capacity: 00:10:00 •Module 8: Other Key Legislations: 00:10:00

Overview Learn how to prepare, store, handle and serve food to the highest industry hygiene and safety standards. Aimed at hospitality and catering professionals, this course will give you an in-depth understanding of all aspects of food safety management. In this Hospitality and Catering - Food Safety Level 3, you will learn how to maintain the highest levels of safety and hygiene in the workplace in compliance with UK food safety regulations. On completion, you will gain a legally recognised qualification demonstrating your skills and competence to work in any profession within the hospitality and catering industry. 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 Hospitality and Catering - Food Safety Level 3. It is available to all students, of all academic backgrounds. Requirements Our Hospitality and Catering - Food Safety Level 3 is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible on tablets and smartphones so you can access your course on wifi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career path Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management , Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 1 sections • 12 lectures • 04:25:00 total length •Module 01: Introduction to Hospitality Management: 00:24:00 •Module 02: An Overview of Hotel Industry: 00:18:00 •The Process of Selection and Recruitment in Hospitality Industry: 00:21:00 •The Process of Development and Training in Hospitality Industry: 00:24:00 •Module 05: Management of Front Office Operations: 00:19:00 •Management of Housekeeping, Engineering and Security Operations: 00:27:00 •Management of Food and Beverage Operations: 00:20:00 •Management of Service Quality in Hospitality Industry: 00:20:00 •Marketing in Travel and Tourism Business: 00:24:00 •Module 10: Accounting in Hospitality Industry: 00:26:00 •Module 11: Customer Satisfaction: 00:20:00 •Module 12: E-Hospitality and Technology: 00:22:00

Overview Enrich your knowledge of the history of Criminal Law and improve your career prospects in legal and investigative works. This Criminology Law and Psychology course is a comprehensive collection of legal topics and the associated social sciences, enabling an acute understanding of Criminal behaviour as a whole. By combining aspects of Criminal case studies and the Justice System, you will achieve a full and complete education of the cause and effects of illegal behaviour. This can provide a considerable advantage for a career heading towards Law, Police, or Civil Service work. Along with legal classifications, you will develop ways to identify and predict Criminal acts. ** Completing this course does not imply that you are qualified to work as a Practitioner Psychologist. If you are seeking a course that fits the HCPC's standards, please contact the HCPC or the RCSLT. ** 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 Criminology Law and Psychology. It is available to all students, of all academic backgrounds. Requirements Our Criminology Law and Psychology is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible on tablets and smartphones so you can access your course on wifi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career path Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management , Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 2 sections • 9 lectures • 03:33:00 total length •Module 01: Understanding Criminal Psychology: 00:28:00 •Module 02: Influence of Mental Disorders: 00:23:00 •Module 03: Classification of Crime: 00:18:00 •Module 04: Violent Crimes: 00:29:00 •Module 05: The Crime Scene: 00:30:00 •Module 06: Dealing with Crime: 00:41:00 •Module 07: Victimology: 00:25:00 •Module 08: The Criminal Justice System in England and Wales: 00:19:00 •Assignment - Criminology Law and Psychology: 00:00:00

Overview Acquire great customer problems solving skills to develop long term relationships with your customers by enrolling in our Customer Service Management course. This course is a step-by-step training process to educate you in all the essential knowledge and skills to deliver contextual-based support to your customers and maintain high ethical business standards. The training has a huge impact on higher customer retention, acquisition of new customers, increased productivity and more. After your successful completion, you will be more than capable of identifying customer service elements and knowing the effects of poor service on a business; you will also be able to come up with some great techniques to deal with difficult customers. Enrol today to handle customer feedback and complaints efficiently. 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 Customer Service Management. It is available to all students, of all academic backgrounds. Requirements Our Customer Service Management is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible on tablets and smartphones so you can access your course on wifi, 3G or 4G.There is no time limit for completing this course, it can be studied in your own time at your own pace. Career path Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management , Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 1 sections • 9 lectures • 01:51:00 total length •Module One - Customer Service : Who We Are and What We Do: 00:16:00 •Module Two - Customer Service : Establishing Your Attitude: 00:12:00 •Module Three - Customer Service : Identifying and Addressing Customer Needs: 00:11:00 •Module Four - Customer Service : Generating Return Business: 00:14:00 •Module Five: In-Person Customer Service: 00:09:00 •Module Six - Customer Service : Giving Customer Service over the Phone: 00:11:00 •Module Seven - Customer Service : Providing Electronic Customer Service: 00:11:00 •Module Eight - Customer Service : Recovering Difficult Customers: 00:14:00 •Module Nine - Customer Service : Understanding When to Escalate: 00:13:00