3023 Dele courses

A sales manager's role has more to do with the ability to lead, mentor, and motivate a sales team to achieve or exceed an organisation's sales goals. This programme concentrates on these skills and behaviours enhancing their existing skills to new levels through the sales management process.

This virtual modular programme develops the coaching skills of managers and leaders. This programme is delivered virtually over zoom, 4 x 180 Minute Sessions over 4 Days.

Duration 3 Days 18 CPD hours This course is intended for This course is primarily designed for students who want to gain the skills necessary to use VBA to automate tasks in Excel such as collecting data from external sources, cleaning, and manipulating data. The target student may also want to learn how to create custom worksheet functions to streamline worksheet formulas and make complex worksheets easier to support, maintain, and understand. Overview In this course, you will develop and deploy VBA modules to solve business problems. You will: Identify general components of VBA and their appropriate use in solving business solutions. Record VBA macros to automate repetitive tasks. Use reference tools built into Excel to get help on VBA programming language and objects used in the Excel VBA environment. Write VBA code to create a custom worksheet function. Eliminate, avoid, or handle errors in VBA code, and optimize its performance. Control how and when macros run. Develop UserForm objects to create custom dialog boxes and windows. Use VBA to read and write data from local files and cloud services. Use VBA to clean and transform data. Run programs and commands outside of Excel and share VBA projects with other users VBA (Visual Basic for Applications) enables you to enhance and extend the capabilities of Microsoft© Excel© and other applications in the Microsoft© Office application suite. You can use VBA to perform tasks that would be difficult or impossible to do using only worksheet functions, and you can automate a wide range of tasks involving the collection, processing, analysis, and visualization of data. This course will give you a good foundation for understanding, creating, and using VBA in your own Excel workbooks, show you how to work with data across different applications, and how to package the macros and functions you create so you can back them up, move them to other computers, and share them with other users Prerequisites To ensure your success in this course, you should be an experienced Excel user who is comfortable creating and working with Excel workbooks, including tasks such as entering worksheet formulas, using absolute and relative addressing, formatting cells, and creating pivot tables and charts. This level of skill could be acquired by taking the Microsoft Excel for Office 365? (Desktop or Online) courses, Parts 1, 2, and 3 1 - Using VBA to Solve Business Problems Topic A: Use Macros to Automate Tasks in Excel Topic B: Identify Components of Macro-Enabled Workbooks Topic C: Configure the Excel VBA Environment 2 - Automating Repetitive Tasks Topic A: Use the Macro Recorder to Create a VBA Macro Topic B: Record a Macro with Relative Addressing Topic C: Delete Macros and Modules Topic D: Identify Strategies for Using the Macro Recorder 3 - Getting Help on VBA Topic A: Use VBA Help Topic B: Use the Object Browser to Discover Objects You Can Use in VBA Topic C: Use the Immediate Window to Explore Object Properties and Methods 4 - Creating Custom Worksheet Functions Topic A: Create a Custom Function Topic B: Make Decisions in Code Topic C: Work with Variables Topic D: Perform Repetitive Tasks 5 - Improving Your VBA Code Topic A: Debug VBA Errors Topic B: Deal with Errors Topic C: Improve Macro Performance 6 - Controlling How and When Macros Run Topic A: Prompt the User for Information Topic B: Configure Macros to Run Automatically 7 - Developing Custom Forms Topic A: Display a Custom Dialog Box Topic B: Program Form Events 8 - Using VBA to Work with Files Topic A: Use VBA to Get File and Directory Structure Topic B: Use VBA to Read Text Files Topic C: Use VBA to Write Text Files 9 - Using VBA to Clean and Transform Data Topic A: Automate Power Query Topic B: Transform Data Using VBA and Workbook Functions Topic C: Use Regular Expressions Topic D: Manage Errors in Data 10 - Extending the Programming Environment Beyond the Workbook Topic A: Run Other Programs and Commands Topic B: Share Your VBA Projects

Do you want to prepare for your dream job but strive hard to find the right courses? Then, stop worrying, for our strategically modified Office Management and Delegation Skills bundle will keep you up to date with the relevant knowledge and most recent matters of this emerging field. So, invest your money and effort in our 33 course mega bundle that will exceed your expectations within your budget. The Office Management and Delegation Skills related fields are thriving across the UK, and recruiters are hiring the most knowledgeable and proficient candidates. It's a demanding field with magnitudes of lucrative choices. If you need more guidance to specialise in this area and need help knowing where to start, then StudyHub proposes a preparatory bundle. This comprehensive Office Management and Delegation Skills bundle will help you build a solid foundation to become a proficient worker in the sector. This Office Management and Delegation Skills Bundle consists of the following 30 CPD Accredited Premium courses - Course 01:Office Management Course 02:Office Skills and Administration Level 3 Course 03:Office Admin and Reception Course 04:Stress Management Training Course 05:Positive Psychology Masterclass Course 06:Dialectical Behaviour Therapy Course 07:Motivation Skills Course 08:People Management Skills Level 3 Course 09:Team Management Course 10:Dealing With Difficult People Training Course Course 11:HR Management Level 3 Course 12:HR Management and Employment Law Diploma Course 13:HR Advisor and Recruitment Training Diploma Course 14:HR and Marketing Level 4 Course 15:HR Practice Essentials Level 4 Course 16:HR - Crisis Communication Course 17:HR Assistant Skills Certification Course 18:Motivational Interviewing Course 19:Emotional Intelligence and Human Behaviour Course 20:Contract Manager Diploma Course 21:Delegation Skills Course 22:Interpersonal Skills in Management Course 23:Effective Listening Skills for Leaders Course 24:Personal and Networking Skills Course 25:Performance Centered Asset Management Course 26:Advanced Excel Course (Formula, VLOOKUP & Power Query) Course 27:Virtual Interviewing for HR Course 28:Virtual Training Masterclass Course 29:Recruitment Officer Diploma Course 30:HR and Recruitment Consultant Training 3 Extraordinary Career Oriented courses that will assist you in reimagining your thriving techniques- Course 01: Career Development Plan Fundamentals Course 02: CV Writing and Job Searching Course 03: Interview Skills: Ace the Interview Learning Outcome This tailor-made Office Management and Delegation Skills bundle will allow you to- Uncover your skills and aptitudes to break new ground in the related fields Deep dive into the fundamental knowledge Acquire some hard and soft skills in this area Gain some transferable skills to elevate your performance Maintain good report with your clients and staff Gain necessary office skills and be tech savvy utilising relevant software Keep records of your work and make a report Know the regulations around this area Reinforce your career with specific knowledge of this field Know your legal and ethical responsibility as a professional in the related field This Office Management and Delegation Skills Bundle resources were created with the help of industry experts, and all subject-related information is kept updated on a regular basis to avoid learners from falling behind on the latest developments. Certification After studying the complete training you will be able to take the assessment. After successfully passing the assessment you will be able to claim all courses pdf certificates and 1 hardcopy certificate for the Title Course completely free. Other Hard Copy certificates need to be ordered at an additional cost of •8. CPD 330 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Ambitious learners who want to strengthen their CV for their desired job should take advantage of the Office Management and Delegation Skills bundle! This bundle is also ideal for professionals looking for career advancement. Requirements To participate in this course, all you need is - A smart device A secure internet connection And a keen interest in Office Management and Delegation Skills Career path Upon completing this essential Bundle, you will discover a new world of endless possibilities. These courses will help you to get a cut above the rest and allow you to be more efficient in the relevant fields.

P404 Air Sampling of Asbestos and MMMF and Requirements for a Certificate of Reoccupation Following Clearance of Asbestos is the industry standard qualification for those whose work involves air sampling and clearance testing, such as asbestos analysts. In addition to holding the qualification, they are required to undertake and provide evidence of annual refresher training. RP404 Refresher is a new course, specifically designed to meet this requirement. RP404 Refresher enables candidates to revise and update their knowledge on air sampling and clearance testing techniques, and to receive a certificate of course completion by passing a written examination, which covers both the theory and practice of air sampling and clearance testing.

This CITB HSA course highlights potential hazards when on a construction site.

This qualification is suitable for those aged 16 and above who work with, or care for, children.

This training enables users to administer oxygen safely and effectively, for casualties with breathing difficulties. Delegates will learn how and when to administer oxygen to a casualty and the safety concerns with carrying, storing and administering it. This course is suitable for qualified First Aiders, Emergency First Aiders, dental practitioners and dental care professionals, nurses, healthcare professionals and others working in an environment where oxygen is available for casualty welfare.

Learning Centre Support Specialist, Learning Support Assistant,

Level 2 & 5 Endorsed Diploma | QLS Hard Copy Certificate Included | Plus 5 CPD Courses | Lifetime Access