5081 Courses

This course is designed to meet the requirements of ILS courses laid down by UK Resus Council guidelines and is certified by ProTrainings. This CPD course meets the criteria for the General Dental Council’s development outcomes C and includes medical emergencies as set out by the GDC in the dental practice. The course is interactive, so please wear comfortable clothing. Free parking available near location On local bus route and within easy reach of Bathgate train station.

Life and Personal Performance Coaching with Spiritual Teacher and Peak Performance Coach Robert Greenwood.

The Temporary Works Supervisor course will provide you with knowledge of the role. You will also gain a good understanding of risk management on a temporary works site. Course Objectives: By the end of the course, the delegate will gain knowledge of: Have gained an understanding of the importance of cooperation and teamwork on a temporary works site Understand the legal duties of the role Have a stronger awareness of risk management on-site as well as the roles of a supervisor and their fellow employees on site Leave the course with an understanding of the “4C’s”, Communication, Cooperation, Coordination and Competency Course Content: Different groups and types of Temporary Works BS5975:2019 CDM Regulations Legislation and Codes of Practice Temporary Works Register, Design Brief and Design Case studies, policy and procedures, Standard solutions and permitted drawings Risk assessments, method statements Safe systems of work The roles and duties of a Temporary Works Supervisor Assessment: To successfully complete the course, you will need to get 72% or above in the final exam. The trainer encourages the delegates to be interactive and involved throughout the training. Certificate: The certificate for this course is valid for 5 years. Instructions Please note all Temporary Works Supervisor courses with the venue “Remote Learning” will be delivered by a tutor over a video call. This training will be delivered and assessed in English language; therefore, a good standard is required to complete the course. Further attendee information will be sent in a separate email, please check your inbox.

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

You can handle the tough stuff with the help of this comprehensive, interactive and thought-provoking course. Our trainers are experienced managers who will guide and support you through the intricacies of people and personal management. The key responsibilities of the manager A manager’s impact on the business and its staff Being a role model Communicating with confidence Questioning skills Managing hybrid teams Assertiveness techniques Managing team performance with ease Giving great feedback Prioritising like a winner Time management techniques Delegating effectively

Business Process Modeling This course is part of IIL's Business Analysis Certificate Program (BACP), a program designed to help prepare individuals pass the IIBA® Certification exam to become a Certified Business Analysis Professional (CBAP®). Learn more at www.iil.com/bacp A process model is a description of a process in terms of its steps or actions, the data flowing between them and participants in the process, machines, systems, and organizations involved. Modeling is a critical business analysis skill. It applies graphical and text communication techniques to describe the actions, objects, and relationships acted upon in the process and the steps that act upon them. This course teaches the technique of process modeling and ties together the core methods of process, behavior, and data modeling to enable business analysts to fully describe business processes in levels of detail from multiple perspectives. What you will Learn Upon completion, participants will be able to: Identify business processes and their components Work with UML diagrams Use process modeling in business diagramming Diagram and model business processes Foundation Concepts The role of the business analyst The IIBA® BABOK® Knowledge Areas Business Process Modeling (BPM) and the business analyst A practical approach to business process modeling The Context for Modeling Business Processes Overview of context for business process modeling Analyzing stakeholder information Modeling best practices Critical inputs for BPM: Business Rules Critical inputs for BPM: Context Diagrams Data Models Overview of data modeling Entity relationship diagrams Object-oriented approach Class diagrams Other data models Process Models - Part I (Non-UML) Overview of process modeling Data flow diagrams Workflow diagrams Flowcharts Process Models - Part II (UML) Overview of UML Process Models UML Activity Diagrams UML Sequence Diagrams Usage Models - Part I (Non-UML) Overview of usage modeling Prototyping options Static prototyping and storyboards Dynamic prototyping User Interface Design and user stories Usage Models - Part II (UML Use Cases) Overview of Use Cases Use Case diagrams Use Case descriptions Use Cases and the product life cycle Integrating the Models Overview of integrating the models General analysis best practices Specific analysis techniques summary Best practices for transition to design Summary and Next Steps What did we learn and how can we implement this in our work environments?

Course Objectives At the end of this course you will be able to: Work with advanced lookup and reference functions Create macros to automate common tasks Use advanced techniques to analyse data Create PivotTables and PivotCharts Work with data validation tools Import and export data ' 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 course was very interesting and engaging and will definitely be put to use. The trainer was very helpful and charismatic. Marving Lopez - AM Best Europe Pedro was excellent. Very knowledgeable, clear and great rapport with class. Darren Barkey - Direct Wines Great content and learnt a lot. Really enjoyable :) Kristie-Lee Ryan - Stirling Ackroyd 1 year email support service Take a closer look at the consistent excellent feedback visiting our site ms-officetraining co uk 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 classrom, one to one, tailored and bespoke courses. Tailored In Company training: 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. Please visit our site (ms-officetraining co uk) to get a feel of the excellent feedback our courses have had and look at other courses you might be interested in. Advanced Functions COUNT, COUNTA, COUNTIF, COUNTBLANK, SUMIF, SUBTOTAL IF, OR, AND, IFERROR VLOOKUP to lookup Exact Values and Approximate values MATCH, INDIRECT, ROW/COLUMN, INDEX, OFFSET Analysing Data PMT function to calculate a monthly payment of a loan What If Analysis using Goal Seek Use scenarios to consider many different variables Using Solver Add-in to optimize variables PivotTables Create a PivotTable to analyse worksheet data Add or remove fields in a PivotTable Change the data source for a PivotTable Working with external data sources Using different Statistical Functions Calculate a Running Total, % of Grant Total, Difference From… Using the Slicer and Timeline to filter the PivotTable Using Filters in a PivotTable Group by Date, Auto Group by ranges of values, Custom Group Create a PivotChart The GETPIVOTDATA function Formula auditing Precedents and dependents Error checking Watch a formula and its result by using the Watch Window Evaluate a nested formula one step at a time Data Validation Number Validation Data List Validation Message Prompts and Alerts Conditional Data Validation Data Validation Errors Consolidation Consolidate data by position Consolidate data by category Use a formula to consolidate data Outline (group) data in a worksheet Create an outline of rows Create an outline of columns Copy outlined data Hide or remove an outline Connect external data to your workbook Using the Power Query Editor to import data From Text and CSV, From Access, From Web, From another Workbook Using the Power Query Editor to; Transform your data by Selecting which fields to import, by Splitting Columns, Changing Data Type and more. Deleting Applied Steps Refreshing your data Working with Form Controls; Buttons, Option Buttons and Scroll Bars Introduction to Macros Change Macro Security settings How to Record a macro Some Macro Examples Delete a macro Edit the macro to view the VBA code Copy part of a macro to create another macro Assign a macro to a button Who is this course for? Who is this course for? This course is intended to end users who want to develop their skills so they can use advanced techniques to analyse extensive and complex datasets in Excel and to automate simple tasks with the use of Macros. Requirements Requirements Preferably, delegates should have attended the Excel Intermediate course. Career path Career path Excel know-how can instantly increase your job prospects as well as your salary. 80 percent of job openings require spreadsheet and word-processing software skills

Why Choose Fundamentals of Revit Training? Revit, the pinnacle of Building Information Modelling (BIM) software, is integral for architects, engineers, designers, and contractors. Mastering it is essential for various construction, design, and planning phases. Click here for more info: Website How to Enrol? Our training sessions are tailored exclusively for you, offering personalized 1-on-1 instruction. Choose a convenient hour between 9 a.m. and 7 p.m., Monday to Saturday. For booking, call 02077202581 or pre-book online. I. Introduction to Revit: Understanding Revit and its applications Exploring Revit interface and basic tools Navigating through viewport controls Creating and saving projects II. Project Setup: Creating a new project and utilizing templates Configuring project settings and scales Adding levels, grids, and columns III. Building Elements: Creating and modifying walls, doors, and windows Designing floors, ceilings, roofs, stairs, and railings IV. Views and Documentation: Managing views and sheets Adding schedules, tags, and annotations Generating construction documents V. Advanced Modeling and Components: Working with complex walls, curtain walls, and grids Using visibility and graphics controls and cutaway views VI. Rooms and Details: Adding and numbering rooms Incorporating annotations, dimensions, symbols, and legend views Creating detail callouts and using detail components VII. Families and Customization: Understanding families and their components Using reference planes, parameters, and constraints Building custom families with solid and void geometry VIII. Sheets, Plotting, and Exporting: Organizing sheets and exporting to AutoCAD and JPG formats Note: This course outline is flexible and can be tailored to meet learners' needs and proficiency levels. After completing the Revit Basic to Fundamentals Course, participants will: Understand the foundational concepts and principles of Autodesk Revit. Navigate and utilize the essential tools and features of Revit effectively. Create and modify basic building elements, such as walls, doors, windows, and roofs. Develop 3D building models and understand the concept of BIM (Building Information Modeling). Produce basic construction documentation, including floor plans, elevations, and sections. Implement annotation and dimensioning techniques to enhance documentation clarity. Gain proficiency in organizing and managing views for efficient project visualization. Collaborate on simple design changes and modifications using Revit's collaboration features. Acquire practical skills for applying Revit in real-world architectural and construction projects. Revit Essentials Training: Learn Revit fundamentals for architecture and structural design, supporting efficient building construction with BIM workflows. Delivery Options: In-class at our center Live online sessions Who Should Attend? Ideal for architects, building designers, structural engineers, and general users. Course Highlights: Hands-on and practical training with expert instructors. Detailed training guide for reference and post-course review. E-certificate upon successful completion. Practical skills for real-world application, no exams. Prerequisites: No prior Revit knowledge required. Basic construction principles recommended. CAD experience beneficial but not essential. Version and Support: Based on Latest Revit. Lifetime email support provided. Guarantees: Best value for money and assurance of learning essential concepts and skills. Individualized One-on-One Training: Experience personalized attention and tailored guidance. Flexible Timing: Schedule sessions at your convenience, choosing your preferred time and day. Post-Course Assistance: Access complimentary online support after course completion. Comprehensive Learning Materials: Receive effective learning resources, including PDF notes and handouts. Certification of Completion: Earn a recognition certificate upon successfully finishing the course. Affordable Rates: Enjoy budget-friendly training fees for valuable learning experiences. Software Setup Support: Receive assistance in configuring the software on your device. Referral Benefits: Recommend a friend and receive discounts on upcoming courses. Group Training Discounts: Avail special discounts for group training sessions. Convenient Availability: Attend sessions from Monday to Sunday, with extended operational hours. Customized Training: Get tailored and personalized courses designed to meet your specific requirements. Download Revit

Business Process Modeling: In-House Training This course is part of IIL's Business Analysis Certificate Program (BACP), a program designed to help prepare individuals pass the IIBA® Certification exam to become a Certified Business Analysis Professional (CBAP®). Learn more at www.iil.com/bacp A process model is a description of a process in terms of its steps or actions, the data flowing between them and participants in the process, machines, systems, and organizations involved. Modeling is a critical business analysis skill. It applies graphical and text communication techniques to describe the actions, objects, and relationships acted upon in the process and the steps that act upon them. This course teaches the technique of process modeling and ties together the core methods of process, behavior, and data modeling to enable business analysts to fully describe business processes in levels of detail from multiple perspectives. What you will Learn Upon completion, participants will be able to: Identify business processes and their components Work with UML diagrams Use process modeling in business diagramming Diagram and model business processes Foundation Concepts The role of the business analyst The IIBA® BABOK® Knowledge Areas Business Process Modeling (BPM) and the business analyst A practical approach to business process modeling The Context for Modeling Business Processes Overview of context for business process modeling Analyzing stakeholder information Modeling best practices Critical inputs for BPM: Business Rules Critical inputs for BPM: Context Diagrams Data Models Overview of data modeling Entity relationship diagrams Object-oriented approach Class diagrams Other data models Process Models - Part I (Non-UML) Overview of process modeling Data flow diagrams Workflow diagrams Flowcharts Process Models - Part II (UML) Overview of UML Process Models UML Activity Diagrams UML Sequence Diagrams Usage Models - Part I (Non-UML) Overview of usage modeling Prototyping options Static prototyping and storyboards Dynamic prototyping User Interface Design and user stories Usage Models - Part II (UML Use Cases) Overview of Use Cases Use Case diagrams Use Case descriptions Use Cases and the product life cycle Integrating the Models Overview of integrating the models General analysis best practices Specific analysis techniques summary Best practices for transition to design Summary and Next Steps What did we learn and how can we implement this in our work environments?

The Institution of Occupational Health and Safety (IOSH) is a globally respected chartered body that champions the highest workplace standards of health and safety.  Safehouse are proud to offer training of the IOSH Managing Safely course. This training programme is designed for any individual who has organisational responsibilities for managing health and safety risks, resources and workplace practices. Once complete, it provides an excellent foundation for further study for those looking to pursue a career in health and safety and gain qualifications accredited by the National Examination Board in Occupational Safety and Health (NEBOSH) or NVQ Course Programme and Duration The IOSH Managing Safely course takes three full days to complete and covers, in detail, the core responsibilities of anyone tasked with managing workplace health and safety. Those responsibilities are covered in seven distinct units of study: Unit 1: Introducing managing safely Unit 2: Assessing risks Unit 3: Controlling risks Unit 4: Understanding responsibilities Unit 5: Understanding hazards Unit 6: Investigating incidents Unit 7: Measuring Performance To help prepare candidates for end-of-course examinations, daily interactive homework assignments and quizzes will also be set by the tutor. Certification In order to successfully complete the course and gain IOSH certification, delegates must complete a 45-minute examination to assess their learning and carry out a practical assessment to demonstrate the application of knowledge gained. Location At our Barnsley based training centre, with free parking on site bistro, free wifi and a great learning environment. Easily accessible from Junction 36 and 37 of the M1. Course Costs Course fees include expert tuition, course materials, examinations and certification. Costs are £395.00 plus VAT with discounts available for multiple booking / delegates.