• Professional Development
  • Medicine & Nursing
  • Arts & Crafts
  • Health & Wellbeing
  • Personal Development

5831 Model courses

VBA in Excel - Part 2

By Underscore Group

Expand your VBA knowledge further and learn some of the more advanced coding features. Course overview Duration: 2 days (13 hours) This course is aimed at experienced VBA users or those who have attended our Part 1 course and have started to use the language. Part 2 expands on the huge array of commands and elements of the data model that can be used and looks at building more complex VBA models Objectives  By the end of the course you will be able to: Use comparison operators and system functions Use Arrays Work with ranges Work with the worksheets and workbooks collections and objects Use application objects Use the FileSystemObject Create function procedures Import and save text files Connect to other applications Content Comparison operators Using Comparison operators and functions The LIKE function Wildcards Using SELECT Case System functions The VAL function Case functions Trim functions Text functions Date functions Excel worksheet functions Using Excel functions in VBA Arrays Creating arrays Using arrays Ubound and Lbound Single and multi dimensional arrays Static vs dynamic arrays Working with ranges Creating range objects Passing data between range objects and arrays Using Transpose The Excel object model The object browser Working with collections Collections Creating object variables Setting object variables The For Each . . . Next Loo Sheet collections The worksheets collection The worksheet object The sheets collection Using object Grouping worksheets Using Typename The Workbook collection The workbooks collection Setting workbook variables Application objects Excel default information Display/alerts Screen updating Status bar On Time Using Wait Systems dialog boxes Showing dialog boxes Using dialog boxes Working with files Searching for files and folders The DIR function The FileSystemObject Function procedures Creating functions Adding arguments Calling functions Working with text files Searching for files and folders The DIR function The FileSystemObject Using the FILE and FOLDER collections Sharing data with other applications Early vs Late Binding Setting references to other applications Creating application variables Setting application variables

VBA in Excel - Part 2
Delivered in Horsham or OnlineFlexible Dates
Price on Enquiry

Effective technical writing (In-House)

By The In House Training Company

The aim of this programme is to help attendees create better quality technical documents in an organised and efficient manner. It will give those new to the topic an appreciation of how to approach the task professionally whilst those with more experience will be able to refresh and refine their skills. The programme comprises three complementary one-day modules: The programme presents a structured methodology for creating technical documents and provides a range of practical techniques that help delegates put principles into practice. Although not essential, it is strongly advised that delegates for modules 2 and 3 have already attended module 1, or another equivalent course. Note: the content of each module as shown here is purely indicative and can be adapted to suit your particular requirements. This course will: Explain the qualities and benefits of well written technical documents Present a structured approach for producing technical documents Review the essential skills of effective technical writing Demonstrate practical methods to help create better documents Provide tools and techniques for specification and report writing Review how technical documents should be issued and controlled Note: the content of each module as shown here is purely indicative and can be adapted to suit your particular requirements. Module 1: Essential skills for technical writers 1 Introduction to the programme Aims and objectives of the module Introductions and interests of participants 2 Creating effective technical documents What is technical writing? how does it differ from other writing? Key qualities of an effective technical document Communication essentials and the challenges faced by technical writers The lessons of experience: how the best writers write The five key steps : prepare - organise - write - edit - release (POWER) 3 Preparing to write Defining the document aims and objectives; choosing the title Understanding technical readers and their needs Getting organised; planning and managing the process Integrating technical and commercial elements The role of intellectual property rights (IPR), eg, copyright 4 Organising the content The vital role of structure in technical documents Deciding what to include and how to organise the information Categorising information: introductory, key and supporting Tools and techniques for scoping and structuring the document Creating and using document templates - pro's and con's 5 Writing the document Avoiding 'blinding them with science': the qualities of clear writing Problem words and words that confuse; building and using a glossary Using sentence structure and punctuation to best effect Understanding the impact of style, format and appearance Avoiding common causes of ambiguity; being concise and ensuring clarity Using diagrams and other graphics; avoiding potential pitfalls 6 Editing and releasing the document Why editing is difficult; developing a personal editing strategy Some useful editing tools and techniques Key requirements for document issue and control Module 2: Creating better specifications 1 Introduction Aims and objectives of the day Introductions and interests of participants The 'POWER' writing process for specifications 2 Creating better specifications The role and characteristics of an effective specification Specifications and contracts; the legal role of specifications Deciding how to specify; understanding functional and design requirements Developing the specification design; applying the principles of BS 7373 Getting organised: the key stages in compiling an effective specification 3 Preparing to write a specification Defining the scope of the specification; deciding what to include and what not Scoping techniques: scope maps, check lists, structured brainstorming The why/what/how pyramid; establishing and understanding requirements Clarifying priorities; separating needs and desires: the MoSCoW method Useful quantitative techniques: cost benefit analysis, QFD, Pareto analysis Dealing with requirements that are difficult to quantify 4 Organising the content The role of structure in specifications Typical contents and layout for a specification What goes where: introductory, key and supporting sections Creating and using model forms: the sections and sub sections Detailed contents of each sub-section Exercise: applying the tools and techniques 5 Writing the specification Identifying and understanding the specification reader Key words: will, shall, must; building and using a glossary Writing performance targets that are clear and unambiguous Choosing and using graphics Exercise: writing a specification 6 Editing and releasing the document Key editing issues for specifications Issue and control of specifications Module 3: Writing better reports 1 Introduction Aims and objectives of the day Introductions and interests of participants The 'POWER' technical writing process for technical reports 2 Creating better reports What is a technical report? types and formats of report The role and characteristics of an effective technical report Understanding technical report readers and their needs The commercial role and impact of technical reports Getting organised: the key stages in compiling a technical report 3 Preparing to write reports Agreeing the terms of reference; defining aims and objectives Being clear about constraints; defining what is not to be included Legal aspects and intellectual property rights (IPR) for reports Preparing the ground; gathering information and reference documents Keeping track of information: note making, cataloguing and cross referencing Tools and techniques for developing a valid and convincing argument 4 Organising the content The role of structure reviewed; some typical report structures Who needs what: identifying the varied needs of the readership What goes where: introductory, key and supporting sections Creating and using model forms: the sections and sub sections Detailed contents of each sub-section Exercise: applying the tools and techniques 5 Writing the report Planning the storyline: the report as a journey in understanding Recognising assumptions about the reader; what they do and don't know Converting complex concepts into understandable statements Presenting technical data and its analysis; the role of graphics Presenting the case simply whilst maintaining technical integrity Exercise: writing a technical report 6 Editing and releasing the report Key editing issues for technical reports Issue and control of technical reports

Effective technical writing (In-House)
Delivered in Harpenden or UK Wide or OnlineFlexible Dates
Price on Enquiry

Accredited Dog Nutrition Course

4.3(43)

By John Academy

Course Overview Amp up your project management skills to meet your project requirements and shape your organisation's success. Project managers are responsible for the successful planning and execution of projects. This Accredited Dog Nutrition Course  is designed to help you learn the proven project management skills and techniques to manage projects from beginning to end. The course will give you clear ideas on project management basics, different project types, and the techniques applied to project activities for successful project completion. During the course, you'll gain insights into project management steps, such as project initiation, execution, monitoring, and closing. On top of that, you'll explore the steps involved in project team building and acquire knowledge of earned value management to measure project performance. Learning Outcomes Discover the crucial steps to project success Familiarise yourself with different types of projects Identify the steps involved in project initiation, execution, monitoring and closing Understand what makes a successful project management team Learn about Earned Value Management (EVM) for project performance measurement Determine what is a change control process in project management Who is the Accredited Dog Nutrition Course for? This Accredited Dog Nutrition Course is perfect for aspiring professionals in the relevant industry, such as people with careers in: Project Manager Project Executive Project Administrator Project Co-ordinator Project Lead It will deepen their knowledge and help them establish the fundamental skills for project management. Why Choose this Diploma in Accredited Dog Nutrition Course Affordable, well-structured and high-quality e-learning study materials Engaging tutorial videos, materials from the industry-leading experts Opportunity to study in a user-friendly, advanced online learning platform Efficient exam systems for the assessment and instant result The UK & internationally recognised accredited qualification Access the course content on mobile, tablet, or desktop from anywhere, anytime Excellent career advancement opportunities 24/7 student support via email. Entry Requirement This course is available to all learners of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. A good understanding of the English language, numeracy, and ICT are required to attend this course. Assessment At the end of the course, you will be required to sit for an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful. Before sitting for your final exam, you will have the opportunity to test your proficiency with a mock exam. Certification After you have successfully passed the test, you will be able to obtain an Accredited Certificate of Achievement. However, you can also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hard copy at the cost of £39 or in PDF format at £24. PDF certificate's turnaround time is 24 hours, and for the hardcopy certificate, it is 3-9 working days. Meet Me And 'The Boys!' This Is Where It All Started. These 2 Dogs Changed My Life And Career! 00:03:00 What You'll Get From This Course What You'll Get From This Course 00:03:00 BARF (Bones And Raw Food) Feeding For Dogs What BARF Is And The Principles Of Feeding This Way 00:11:00 What Type Of Bones Should You Feed Your Dog? Here's The Answer 00:03:00 These Foods Are Also Important To Include. 00:07:00 How Much Should You Feed Your Dog? You'll Find Out Here 00:02:00 This Is What You'll Need To Get Started 00:03:00 Important - Please Read This Please Read This First Before Watching The Next Sections 00:02:00 Raw Meaty Bones (RMB) Or Prey Model Feeding For Dogs Shattering The Myths About Raw Feeding 00:04:00 More Raw Feeding Myths Shattered1 00:05:00 More Raw Feeding Myths Shattered 2 00:04:00 More Raw Feeding Myths Shattered 3 00:07:00 Raw Meaty Bones Feeding What The Raw Meaty Bones Feeding Method Is And How It Differs To BARF 00:07:00 How To Start Feeding Your Dog Raw Meaty Bones 00:10:00 How To Switch To A Raw Diet 00:03:00 Raw Food Supplier List 00:04:00 Additional Supplier List 00:03:00 3rd Suggestion - Ready Made BARF Ready Made BARF 00:09:00 Resources This Is Your Resource List 00:05:00 Bonus Section **Bonus** 15 Natural Recipe Treats Your Dog Will Love 00:35:00 **Bonus** BLOAT - How To Prevent The Second Biggest Killer In Dogs Today 00:05:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Accredited Dog Nutrition Course
Delivered Online On Demand2 hours 15 minutes
£18

Dog Training - BARF

4.3(43)

By John Academy

Course Overview Learn all the essential skills to become an expert in Dog Training. From this comprehensive Dog Training - BARF course, you will be able to understand the principles of Dog Training. In the step-by-step training process, you will acquire practical skills along with theoretical knowledge. The Qualified professionals will assist you throughout this learning process. This Dog Training - BARF is structured to ensure you have all the adequate skills to secure a position in this competitive industry. You will achieve the confidence and competency to bear all the responsibilities of this profession. The course will add all the right credentials to your resume and increase your employability in this growing industry. Learning Outcomes Learn about some of the best raw food for dogs and their benefits Discover the raw dog food recipes and meal suggestions Find out about the right types of raw food to feed your dog and where to get it from Understand how much to feed your dog daily to promote optimum health, body weight and longevity Discover step-by-step instructions on transitioning your dog from dry food to raw Understand how to avoid the mistakes people often make when feeding dogs a raw food diet Explore how to feed your dog the way nature intended and reap the rewards of a strong, happy and healthy dog Who is this course for? Anyone who is now employed in this field or who aspires to be one should take this course. Your knowledge will grow through taking this course, which will also strengthen your resume. To demonstrate your newly gained knowledge, develop crucial abilities and receive a professional credential. Entry Requirement This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. Certification After you have successfully completed the course, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hardcopy at the cost of £39 or in PDF format at the cost of £24. PDF certificate's turnaround time is 24 hours, and for the hardcopy certificate, it is 3-9 working days. Why choose us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos/materials from the industry-leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally recognized accredited qualification; Access to course content on mobile, tablet or desktop from anywhere anytime; The benefit of career advancement opportunities; 24/7 student support via email. Career Path The Dog Training - BARF course is intended to assist you in obtaining the dream job or maybe the promotion you've always desired. With the assistance and direction of our Dog Training - BARF course, learn the vital abilities and knowledge you require to succeed in your life. Meet Me And 'The Boys!' This Is Where It All Started. These 2 Dogs Changed My Life And Career! 00:03:00 What You'll Get From This Course What You'll Get From This Course 00:03:00 BARF (Bones And Raw Food) Feeding For Dogs What BARF Is And The Principles Of Feeding This Way 00:11:00 What Type Of Bones Should You Feed Your Dog? Here's The Answer 00:03:00 These Foods Are Also Important To Include 00:07:00 How Much Should You Feed Your Dog? You'll Find Out Here 00:02:00 This Is What You'll Need To Get Started99 00:03:00 Important - Please Read This Please Read This First Before Watching The Next Sections 00:02:00 Raw Meaty Bones (RMB) Or Prey Model Feeding For Dogs Shattering The Myths About Raw Feeding 00:04:00 More Raw Feeding Myths Shattered1 00:05:00 More Raw Feeding Myths Shattered 2 00:04:00 More Raw Feeding Myths Shattered 3 00:07:00 Raw Meaty Bones Feeding What The Raw Meaty Bones Feeding Method Is And How It Differs To BARF 00:07:00 How To Start Feeding Your Dog Raw Meaty Bones 00:10:00 How To Switch To A Raw Diet 00:03:00 Raw Food Supplier List 00:04:00 Additional Supplier List 00:03:00 3rd Suggestion - Ready Made BARF Ready Made BARF 00:09:00 Resources This Is Your Resource List 00:04:00 Bonus Section **Bonus** 15 Natural Recipe Treats Your Dog Will Love 00:42:00 **Bonus** BLOAT - How To Prevent The Second Biggest Killer In Dogs Today 00:05:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Dog Training - BARF
Delivered Online On Demand2 hours 21 minutes
£18

Learn Azure Serverless Functions in a Weekend

By Packt

Learn Azure Serverless Computing in a weekend with Azure Functions. This course covers core concepts such as serverless functions, event-driven applications, Azure Service Bus, database interaction, email sending, monitoring, transaction management, integrations, and more! Gain valuable and in-demand skills in Microsoft Azure's Serverless Computing.

Learn Azure Serverless Functions in a Weekend
Delivered Online On Demand3 hours 52 minutes
£82.99

Online MTS Glow aka BB Glow

By KBH Training Academy

MTS Glow Course- you must be qualified in micro-needling already. If not, we combine our MTS Glow course with micro-needling as well Please note: BB Glow wording has been trademarked and it's illegal to use unless permission has been granted from the owner. This means all accreditors have revoked the courses being accredited under this name. Therefore, we have trademarked our course to MTS Glow and our students are free to use this for advertising purposes. What is MTS Glow? MTS Glow is a unique Korean produced serum with the addition of a foundation. Using Micro Needle Therapy System the goal of the treatment is to lighten and smooth the face skin tone. Course Content -Anatomy of the face and skin - Skin physiology - The choice of colour for the type of skin - Use of ampoules - Purpose of the treatment and the obtained effect - Contraindications for MTS Glow treatments - Possible complications after treatments - Types of pigments - Consultation/consent form - Step by step on how to offer MTS glow treatment Course Content for microneedling: https://www.kbhtrainingacademy.com/product-page/microneedling-course Training Kit for MTS Glow only(you must supply your microneedling pen and nano needles) 5x BB ampules Cleanser Neutralising foam Face Mask Repair Cream Training Kit for MTS Glow & Microneedling 5x BB ampules 5x Microneedling serums Cleanser Neutralising foam Face Mask Repair Cream DR Pen 5x nano needle 5x 12pin needle Certificate You will receive an end of course certificate which is accredited by the cpd group and allows you to work on public How do Online Courses work? http://www.kbhtrainingacademy.com/online-courses Duration of Course? You will have 3 months to complete the course before it expires Will I require a model? Yes, you will be required to send a case of studies Are there video tutorials? Yes, you will have links to YouTube and training videos to watch the treatment being performed Do I Need Experience Before Booking a Course? You must be qualified in micro-needling already. If not, we combine our MTS Glow course with micro-needling as well

Online MTS Glow aka BB Glow
Delivered Online On Demand12 weeks
£49 to £438

Advanced Financial Modeler Certificate Course - Oil & Gas

4.3(6)

By dbrownconsulting

Learn the fundamentals of Oil and Gas modeling following best practices. This course will break down the important concepts of modeling allowing you to implement them in the Oil and Gas industry.

Advanced Financial Modeler Certificate Course - Oil & Gas
Delivered OnlineJoin Waitlist
£900

Introduction to SAP Business Technology Platform (BTP) Administration

By Nexus Human

Duration 3 Days 18 CPD hours This course is intended for Database Administrator Enterprise Architect System Administrator System Architect Technology Consultant Overview This course will prepare you to: Understand the concepts of SAP BTP Understand the tasks of an SAP BTP administrator Administrate accounts, services, and users in SAP BTP Manage connections, databases, and monitoring in SAP BTP This course will prepare you to:Understand the concepts of SAP BTPUnderstand the tasks of an SAP BTP administratorAdministrate accounts, services, and users in SAP BTPManage connections, databases, and monitoring in SAP BTP SAP Strategy RISE with SAP and Intelligent, Sustainable Enterprise SAP BTP Use Cases Architectures Account Model and Services ABAP, Cloud Foundry, and Kyma Runtime Environments Cloud Development Concept Configuration Discovery Center and Boosters Command Line Interface Connectivity Destinations Cloud Connector User Management Account User Management SAP Cloud Identity Services Database Offerings SAP HANA Cloud Application Lifecycle Management Product Portfolio Monitoring SAP Application Logging Service SAP Cloud ALM Interface Channel SAP Cloud Transport Management Service SAP Cloud Transport Management Service Additional course details: Nexus Humans Introduction to SAP Business Technology Platform (BTP) Administration training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the Introduction to SAP Business Technology Platform (BTP) Administration course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

Introduction to SAP Business Technology Platform (BTP) Administration
Delivered OnlineFlexible Dates
Price on Enquiry

Cisco Troubleshooting Cisco Contact Center Enterprise v1.0 (CCET)

By Nexus Human

Duration 2 Days 12 CPD hours This course is intended for Account manager Deployment engineer Deployment project manager Sales engineer Overview After taking this course, you should be able to: Describe CCE flows and processes required to support and troubleshoot the PCCE deployment Introduce the many diagnostic tools available to the engineer responsible for troubleshooting a PCCE environment Apply troubleshooting tools and techniques to address issues with CCE Certificates, Cisco Finesse, and PCCE Deployment The Troubleshooting Cisco Contact Center Enterprise (CCET) v1.0 course is focused on Day 2 support of a Packaged Contact Center Enterprise (PCCE) deployment by Tier 3 support personnel. Cisco© PCCE provides an enterprise-class contact center in a prepackaged deployment model that offers simplified deployment, operation, and maintenance. You will learn to identify the processes and tools used to diagnose common deployment issues so that support personnel can select optimal methods to resolve those issues CCE Flows and Process Review Troubleshooting and Support Methodology PCCE Component Review PCCE Call Flow Review CCE Diagnostic Tools Diagnostic Framework Suite Run Analysis Manager Run Unified System Command-Line Interface (CLI) Troubleshooting CCE Troubleshoot Certificates Troubleshoot Cisco Finesse Troubleshoot a PCCE Deployment Additional course details: Nexus Humans Cisco Troubleshooting Cisco Contact Center Enterprise v1.0 (CCET) training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the Cisco Troubleshooting Cisco Contact Center Enterprise v1.0 (CCET) course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

Cisco Troubleshooting Cisco Contact Center Enterprise v1.0 (CCET)
Delivered OnlineFlexible Dates
Price on Enquiry

Unlock the power of steam turbine technology with EnergyEdge's comprehensive classroom training. Gain expertise and optimize operations. Enroll now!

Steam Turbine Technology
Delivered In-Person
£2,799 to £2,899