7040 Courses

Learn to push boundaries and perfect paintwork like never before.Our One-day sanding course for automotive paintwork is for experienced, high-end detailers looking to add to their portfolio with the ultimate refinement, along with the option to pre-purchase a machine pack - including Flex ORE 3-150 sander, Interface pad and sanding film kit, at a fantastic low price in advance, for collection on the day. Our one-day sanding and flatting course for automotive paintwork is for experienced detailers looking to add to their portfolio with the ultimate refinement and correction technique to improve results, and productivity, and add a valuable and marketable service to their business. Sanding is a skill which can be used to perfect and rectify the harshest repairable damage and imperfect paintwork. Using a range of tools from electric and pneumatic sanders to specialist tools and compounds, you will work through the day to perfect a series of ever more challenging panels under the watchful eye of our instructors who are there to guide and demonstrate every step. wet sanding is a critically difficult skill which can bring high-yield finishes to a detailing portfolio and turn around the most challenging and rewarding of projects. Course fees cover all materials and lunch, with the day starting at 9.30 and running to around 4.30 pm. You also have the option to pre-purchase the Machine add-on pack - a Flex ORE 3-150 - at a fantastic low price in advance, for collection on the day. Because of the high demand and complexity of the skill, all attendees will need a working knowledge of machine polishers - both rotary and DA - and confidence in heavy correction to benefit from this course as it assumes a high level of competency prior to taking on the most challenging work in a detailers arsenal. Course Length 1 Day (0930-1600) Location UK Detailing Academy, 2 Purlieus Barn, Ewen, Cirencester, GL7 6BY Group Size One-to-One Experience / Qualification Competent with a machine polisher Refreshments or Lunch Refreshments included

A day packed with enthusiast detailer training and advice. The perfect course for detailing enthusiasts who have a passion for keeping their cherished vehicles in peak cosmetic condition, and who want to further their knowledge of detailing. The perfect course for car care enthusiasts who have a passion for keeping their cherished vehicles in peak cosmetic condition, and who want to further their knowledge of detailing. The course will guide the attendee through best practice processes of safe pressure & hand washing, decontamination, inspection, paint protection, mild paint correction and discuss/apply the various protection options on offer. Course Details: • Assessment of vehicle exterior & interior inspection. • Cleaning, decontamination & preparatory work of the vehicle body: Washing processes, Pre-wash & snow foam, multi bucket methods, acids and alkalis, fallout removers and in-depth cleaning practices. • Cleaning, decontamination & preparatory work of alloy wheels. • Paintwork inspection using lighting techniques, depth gauges, and visual cues. Identifying areas of concern and how to address them. • Practical overview of machine polisher ranges and their usage. • Practical overview of various polishing compounds and pad combinations. • Paintwork and alloy wheel sealant protection options and application technique. • Glass cleansing and protection practical overview. • Detailing tips and tricks to give you the best results. You will have hands-on experience starting from the very beginning and working your way through all steps of a full enhancement detail, it will then be up to you to build on the knowledge you have gained by practising on your own vehicle, with ongoing support. The course is run from our fully equipped studio in the heart of Gloucestershire, with easy access to the M4/M5, and under an hour and a half to the M25. Course Length 1 Day (0930-1600) Group Size One-to-One Location UK Detailing Academy, 2 Purlieus Barn, Ewen, Cirencester, GL7 6BY Experience / Qualification Open to all Refreshments or Lunch Refreshments included

This Level 1 qualification introduces the role of a bookkeeper and the underpinning knowledge to identify and carry out simple different bookkeeping activities, such as income and expenditure, profit and loss, and assets and liabilities. Course Overview This Level 1 qualification introduces the role of a bookkeeper and the underpinning knowledge to identify and carry out simple different bookkeeping activities, such as income and expenditure, profit and loss, and assets and liabilities. It also offers an introduction into the role, and the benefits and risks associated with bookkeeping software. The jobs it can lead to: • Cashier • Clerical assistant • Trainee bookkeeping assistant Entry requirements: If you have no prior accounting knowledge or bookkeeping knowledge, this entry-level bookkeeping qualification will give you an understanding of manual, single-entry bookkeeping basics. For the best chance of success we recommend that students begin their studies with a good standard of English and maths. It provides a solid grounding for students before moving on to the Level 2. Course Content: Bookkeeping fundamentals: This unit introduces students to the role of a bookkeeper and simple bookkeeping techniques, while providing an understanding on why it’s important to keep accurate and up to date financial information in business. Students will learn how to identify a range of bookkeeping transactions including income, expenses, and profit and loss, as well as gaining an understanding of the benefits and risks associated with bookkeeping software and the importance of ethical behaviour. Learning outcomes: • Understand the role of the bookkeeper. • Understand financial transactions. • Process customer and supplier transactions. • Process receipts and payments. • Understand the benefits and risks of using accounting software to complete bookkeeping tasks. DURATION 110 Hours WHATS INCLUDED Course Material Case Study Experienced Lecturer Refreshments Certificate

Course Objectives At the end of this course you will be able to: Modify the PowerPoint environment Using Master View in order to customise a design template Add and customize SmartArt graphics Add animations and change its effect options Add action buttons to control the flow of the presentation Use various options to customise slide shows Use different PowerPoint file types to distribute presentations ' 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 Very clearly explained Good pace. Lucy Tailor - ACER ' 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. Customising the PowerPoint Environment Customise the User Interface Set PowerPoint Options Customising Design Templates Modify Slide Masters and Slide Layouts Add Headers and Footers Modify the Notes Master and the Handout Master Adding SmartArt to a Presentation Create SmartArt Modify SmartArt Working with Media Add Audio to a Presentation Add Video to a Presentation Working with Animations Entrance, Emphasis and Exit Animations Animate Charts by Category and Series Customise Animations and Transitions Collaborating on a Presentation Review a Presentation Store and Share Presentations on the Web Customising a Slide Show Annotate a Presentation Set Up a Slide Show Create a Custom Slide Show Add Hyperlinks Add Action Buttons Record a Presentation Securing and Distributing a Presentation Secure a Presentation Create a Video or a CD Distribute the Presentation in different File Formats Who is this course for? Who is this course for? This course is designed for delegates who want to gain the skills necessary to work with design templates, various types of diagrams, special effects, custom slide shows, collaboration functionality, and advanced presentation delivery. Requirements Requirements Preferably, delegates should have attended the Powerpoint Introduction course. Career path Career path Microsoft Office 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 Certificates Certificates Certificate of completion Digital certificate - Included

Target Audience Mid- to senior-level managers, team leaders, and executives who are responsible for performance management and seek to enhance their coaching skills to drive both individual and team success. Duration 1 Day Course Overview This course equips leaders with the skills and mindset to effectively manage and coach performance in their teams, using an appreciative and strengths-based approach rooted in Positive Organizational Scholarship. Leaders will learn how to foster high performance, address underperformance constructively, and promote continuous improvement. By leveraging the Leadership Tension Lens, participants will navigate the challenges of balancing individual and team performance with organizational goals, while maintaining a culture of positivity, resilience, and growth. This course is designed by highly qualified learning design experts, assisted and guided by a Doctoral & Masters level leadership team. Working closely with subject matter leaders with extensive domain experience, this course is built on sound academic rigour and applied real world experience. Run in a cohort-based, activity-led format, it goes beyond theory to provide practical methods and frameworks that you can immediately apply in your workplace. Key Outcomes Define Role of Performance Coaching in Leadership: Shifting from Supervision to Empowerment Apply Positive Organizational Scholarship: An Appreciative Framework for Performance Coaching Aligning Individual and Team Performance with Organizational Vision Apply Tailored Coaching to Individual Strengths and Development Needs Define a Culture of High Performance: Leading by Example and Setting the Tone Embed a culture of feedback and Continuous Improvement

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 from our growing corporate clients 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 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. 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 Certificates Certificates Certificate of completion Digital certificate - Included

If you need to conduct effective internal audits against your own Quality Management Systems against the ISO 9001 series of standards, customer-specific, or regulatory requirements – then this is the workshop for you! Course Overview: This ISO 9001:2015 Internal Auditor training is a highly interactive two-day practical workshop, perfect for those requiring a solid understanding of quality auditing techniques and principles. It emphasises the role of the internal ISO auditor in developing and improving effective Quality Management Systems (QMS) and is designed to ensure that participants will have the knowledge and skills to plan, prepare, perform and report the results of internal audits based on ISO 9001 requirements. This ISO 9001 Internal Auditor workshop is aimed at candidates who already have a basic knowledge & understanding of the ISO 9001 requirements. For individuals who do not yet have this knowledge, then we recommend that they become familiar with/develop their understanding of the standard prior to attending the auditor course. What Will Your Learn: You will learn about: What is an effective Quality management system The purpose of an audit How to approach an audit You’ll have the knowledge to: Explain the guidelines of auditing management systems according to ISO 19011:2018 Guidelines for Auditing Management Systems Describe the application of these guidelines to auditing ISO 9001:2015 You’ll have the skills to: Initiate the audit. Prepare and audit activities; complete the audit. Prepare and distribute the audit report. Identify trends and use them to develop action plans. Audit follow-up. Who Should Attend: This Internal Auditor workshop is designed to build upon delegates’ prior knowledge of ISO 9001 and teach them the skills to undertake internal audits of part of a QMS based on ISO 9001. It is delivered as a mix of practical activities, group discussions, and classroom learning. It is suitable for: Staff who will be involved in performing internal audits within their organisation. Managers responsible for the effectiveness and efficiency of an operating unit. Auditees who wish to understand the audit process. Operational and Support functions involved in maintaining or supervising of an ISO 9001:2015 QMS. Managers and decision-makers wanting to understand the auditing process to improve their organisation’s quality management practices. Cost: £800 + VAT per person. What is included Refreshments and lunch provided each day of training Free car park If your organization is a CforC member, please contact us for discounted rates.

Course Objectives At the end of this course you will be able to: Identify the common objects of an Access database Design and build the structure of a database Input and maintain data Design user-friendly data entry forms Search the database using queries Generate reports from your data 1 year email support service Take a look at the consistent excellent feedback from our corporate clients 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 public, one to one, tailored and bespoke courses. Tailored in company 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. Introducing Microsoft Access The Access interface Database terminology Access database objects Fields and records Properties Designing a database Planning and designing a table Creating fields Setting common field properties Defining key fields Working with table data Entering and editing data Sorting and filtering table records Deleting records Relationships Why use table relationships? Relationship types Referential Integrity Working with table subdatasheets Querying a database Creating simple Select Queries Specifying query criteria Sorting query results Adding calculated fields Designing Forms Creating simple forms for data entry Designing custom forms Working with form sections Creating sub forms Designing Reports Creating basic list reports Working with grouping and sorting in a report Adding totals to a report Who is this course for? Who is this course for? This course is intended for the user that wants to explore the creation of a relational database. It will focus on the structuring of the database itself and the creation of the basic functional elements of a database in order to manage data. Career path Career path Microsoft Office 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

Learn how to make your own hallmark quality silver clay jewellery in this private class at The Arienas Collective creative workshop hub in Edinburgh City Centre

Just had an argument with your girlfriend or boyfriend want to sort it out? Need assistance? An M.D.D date coach will call both of you once a day for 30minutes for one week and mediate on your behalf and do a session together at the end of the week to help you both see the other person’s point of view. (This package is only for couples who have a problem and both parties want to resolve the issue) https://relationshipsmdd.com/product/m-d-d-couples-drama-package/