170 Courses in Cardiff

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

Excel but different. Harness this most powerful tool but on a course tailored to your business and needs. Using case studies relevant to your business and often actual files your firm uses on a daily basis we embark on a voyage of discovery. This isn't a boring "watch what I do and copy" course. This is exciting, engaging, funny and enjoyable. Delegates will learn relevant skills but also, because of the delivery methods they will gain an increased enjoyment of using Excel and will retain and implement all of the material covered. They also have access to the trainer for an unlimited amount of time after the course to continue to grow their knowledge

A Warm Welcome to Ludo Tutors Founded in 2017 by Martha, a Dyslexic and Dyspraxia graduate from Cambridge University (Education with English and Drama, BA MA Cantab), Ludo Tutors was created to provide students with a holistic, well-rounded education and excellent quality Tutors. We have over 150 Tutors on our books and tutor everything from Academic subjects (such as 11+ Exams, Key Stage Three Science, GCSEs and A Levels) through to LAMDA Drama, Shakespeare and Public Speaking Exams). What are 11+ / Entrance Exams? 11+ Exams, sometimes called 'Entrance Exams', are examinations that many UK private schools. The rare usually competitive and a bit daunting! Don't panic, though - we're here to help!  How do I take Entrance Exams? Different schools have different application procedures, timelines and expectations. Some will belong to a body of schools using the same examination papers, whereas others will set their own, independent exams. Many also charge an administration fee. We do not advise parents on the applications themselves, but we have garnered a depth of knowledge about 11+ Exams that enable our Tutors to workeffikiently and effectively, whilst still keeping their students engaged and in good spirits. Who are your Tutors? Over half of our Tutors studied at either Oxford or Cambridge University and many hold PGCEs or TEFL/CELTA qualifications. All Tutors are Enhanced DBS checked. We interview each Tutor personally, to get to know them and to find our students the best match. What 11+ experience do you have? Our Founder, Martha, has extensive experience preparing students for the UK's top independent school exams, with many of her students achieving their first choice school, if not also a scholarship - lovely! This work is now carried out by our experienced and friendly tutors, with input from Martha if, as and when they may need extra support.

A Coal Centrifuge is a vital piece of equipment used in the coal preparation process to remove excess water from the coal. This machine operates on the principle of centrifugal force, rapidly spinning coal slurry to separate the water from the coal particles. The use of a coal centrifuge is crucial in reducing the moisture content of coal, which not only enhances its quality but also improves its burning efficiency and reduces transportation costs. By effectively dewatering the coal, the centrifuge ensures that the final product is of higher quality, suitable for various industrial applications.

EFT Tapping Course NE38 7SA – Your Level 1 EFT Workshop – FREE 6 months email support – Fully Experiential Class

Small Class Sizes – EFT Tapping Course Online on Zoom – Every Therapist, Hypnotherapist, Counsellor, Parent, and Teacher needs to learn EFT Tapping – Or For Your Own Self-Development – Dip your toe in the water with just Level 1, or go for the whole thing, scroll down for details and amazing Early Bird Rate

Full Stack Development encompasses the complete creation of end-to-end development of both the front-end and back-end of an application. LSET Bridges The Gap Between Education And Employment

Safer recruitment is designed to help those who are responsible for employing anyone who works with vulnerable groups, to identify and deter or reject individuals who are deemed to be at risk of abusing. It is crucial that all employers have a recruitment policy in place that takes into account safer recruitment best practices and considerations. This course covers key topics including: advertising, application forms, selecting candidates for interview based on the information they have presented, and post-interview checks - including DBS checks - before making an offer of employment. Recruitment of staff is now a complex process and there are many issues that need to be considered to ensure safe and successful recruitment, to reduce in turn the risk of harm, abuse and neglect of adults and children.

Agility has become a prized business attribute. Although Agile methods were once most associated with software development, they are now applied in a host of different areas. Agile continues to find new applications because it is primarily an attitude. This programme delivers a solid grounding in both the Agile mindset and Agile methods. It covers three methods, illustrates the benefits of each and shows how they can be integrated. It includes practical techniques as well as background knowledge. By the end of the session, participants will be able to: Apply Agile concepts to self-manage their work Understand the roles people take on in Agile teams Use a variety of techniques to help deliver customer satisfaction Focus on delivering against priorities Employ a range of estimating techniques 1 Introduction Overview of the programme Review of participants' needs and objectives 2 The basics of Agile What makes Agile different Agile Manifesto and Principles Using feedback to deliver what is needed 3 Agile teams Multi-disciplinary teams Team size and empowerment Agile values 4 Agile at the team level - Scrum Scrum roles Scrum 'events' Scrum 'artifacts' 5 Agile for teams juggling multiple demands - Kanban Taking control of the work Improving throughput Dealing with bottlenecks 6 Agile in projects - AgilePM The phases of an Agile project Managing change requests Delivering on time 7 Estimating T-shirt / Pebble sizing Yesterday's weather Planning poker 8 Pick 'n' mix - some useful techniques The daily stand-up User stories Retrospectives Work-in-process limits Burndown charts Minimum viable product A / B testing 9 Review and action planning Identify actions to be implemented individually Conclusion

In the world of equestrian sports and care, unique challenges and risks are ever-present. That's why NR Medical Training presents our tailored Equestrian First Aid and Trauma course, designed especially for riders, horse trainers, stable staff, vets, and anyone involved in the equine field. Taught by experienced Paramedics and EMTs who have seen and managed everything on the course. Spanning a comprehensive 2-day workshop, this hands-on, face-to-face course provides real-world solutions to real-world problems. Whether it's handling a sudden injury during a riding session or managing a complex trauma situation, our course offers you the skills, insights, and confidence to act appropriately.