140 Courses

Learn woodturning in the peaceful setting of our workshop located in the cottage garden of our home on the Cambs/Norfolk border.

Overview Do you face struggle when you open a Power Query seeing the number of things to do then and cannot make good use of your time? Then this Microsoft Excel: Master Power Query in 120 Minutes! Course is just what you need.to break free of your worries. Power Query is a business intelligence tool available in Excel that allows you to import data from many sources and then clean, transform and reshape your data as needed. The course is designed for learners opting to learn Power Query, a feature available in Excel. Power query is a data connection technology that enables you to connect combine refine and discover data from various sources to meet analysis needs.  The course will introduce you to the basic features of Power query and then show how to trim and transform Data in Excel Power Query, Format Dates and Values in Excel Power Query. You will also learn how to extract data from folders and doing auto clean up on Excel Power Query. You will also learn to merge and shape data according to analysis requirements and prepare models by tools such as power pivot. Learning Outcomes: Acquire proficiency in using Excel Power Query for efficient data management. Master the art of transforming raw data into actionable insights. Learn advanced techniques for data manipulation and analysis. Develop the ability to streamline complex data processes. Enhance your analytical thinking and problem-solving skills. How is the course assessed? To successfully complete the course you must pass an automated, multiple-choice assessment. The assessment is delivered through our online learning platform. You will receive the results of your assessment immediately upon completion. Will I receive a certificate of completion? Upon successful completion, you will qualify for the UK and internationally-recognised certification and you can choose to make your achievement formal by obtaining your PDF Certificate at a cost of £9 and Hardcopy Certificate for £15. Why study this course Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards and CIQ after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the Course at your own pace, on your own schedule. Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience. Unlock career resources for CV improvement, interview readiness, and job success. Requirements Our Microsoft Excel: Master Power Query in 120 Minutes! Course is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career paths Data Analyst: £25,000 - £40,000 Per Annum Business Analyst: £30,000 - £50,000 Per Annum Financial Analyst: £28,000 - £45,000 Per Annum Marketing Analyst: £24,000 - £40,000 Per Annum Operations Analyst: £26,000 - £42,000 Per Annum Management Consultant: £35,000 - £55,000 Per Annum Course Curriculum Microsoft Excel: Master Power Query in 120 Minutes! Power Query Intro and Excel version 00:03:00 Excel Power Query - Introduction 00:03:00 Excel Power Query - Query Editor Ribbon 00:09:00 Transform Data - Trim in Excel Power Query 00:05:00 Transform Data - Format Dates and Values in Excel Power Query 00:02:00 Transform Data - Parsing URLs in Excel Power Query 00:05:00 Transform Data - Split Text Fields in Excel Power Query 00:10:00 Transform Data - Group By in Excel Power Query 00:03:00 Transform Data - Unpivoting Columns in Excel Power Query 00:05:00 Transform Data - Pivoting Columns in Excel Power Query 00:02:00 Transform Data - Split Columns into Other Columns in Excel Power Query 00:04:00 Transform Data - Filtering Rows in Excel Power Query 00:05:00 Transform Data - Sorting Columns in Excel Power Query 00:02:00 Transform Data - Transform and Add Columns in Excel Power Query 00:07:00 From Folder - Import From Folder in Excel Power Query 00:07:00 From Folder - Doing Auto Cleanup in Excel Power Query 00:13:00 From Folder - Extract Data from Forms in Excel Power Query 00:13:00 From Workbook - Extract Multiple Criteria in Excel Power Query 00:05:00 From Workbook - Extract Multiple Worksheets in Excel Power Query 00:04:00 Joins - Intro to Joins 00:04:00 Joins - Merging 00:08:00 Joins - Full Outer Join 00:06:00 Joins - Right Anti Join 00:09:00 Power Query - Convert Reports into Pivot Tables 00:05:00 Modulo 00:06:00

Interior valeting is often overlooked as 'simple' but it is a vital skill for any detailer to master - the difference between an acceptable job and a fantastic job can be vast. With the range of materials and surfaces in modern vehicles, navigating the most efficient way to care for interiors is sometimes difficult. Learning the chemistry behind stain removal, the correct tools for the job and how best to employ them, and how to deal with unusual and stubborn tasks is the aim of this course. We push your knowledge further and advance your skillset through technique and demonstration, enabling you to reduce time spent cleaning and re-cleaning interiors, increasing efficiency, and advancing your interior valeting skills to a new level.   Availability  If no dates are showing as available in the calendar, you can sign up for updates to find out when new dates are released and new course developments. Interior valeting is often overlooked as 'simple' but it is a vital skill for any detailer to master - the difference between an acceptable job and a fantastic job can be vast. With the range of materials and surfaces in modern vehicles, navigating the most efficient way to care for interiors is sometimes difficult. Learning the chemistry behind stain removal, the correct tools for the job and how best to employ them, and how to deal with unusual and stubborn tasks is the aim of this course. We push your knowledge further and advance your skillset through technique and demonstration, enabling you to reduce time spent cleaning and re-cleaning interiors, increasing efficiency, and advancing your interior valeting skills to a new level. You will cover: Interior materials - identifying, cleaning and their issues. Removal of components for deep cleaning, including seats, trim and steering wheels. Cleaner Chemistry and how it applies to different stains. Vacuum, steam and wet extraction technique and efficiency. Specific stain removal; such as Biro ink, oils, sand, tannins, paints, and hard-to-shift materials, such as sand, and chewing gum. Pet hair removal and allergen information. Glass cleaning and access. Odour removal and biocidal sanitising treatments. Surface protection - hard surface, leather and fabric protection and application. Screens and delicate surfaces - including HUDs, touch controls and binnacles. Finally, we teach a proven and methodical checklist to run down with each vehicle to ensure complete thoroughness, whilst sticking to an agreed schedule with a client and upselling additional services.   Course Length 1 Day (0930-1600) Location UK Detailing Academy, 2 Purlieus Barn, Ewen, Cirencester, GL7 6BY Group Size Up to 5 people

Learn woodturning in the peaceful setting of our workshop located in the cottage garden of our home on the Cambs/Norfolk border.

Learn AutoCAD Evening Training Course. Clickhere for info This Autodesk AutoCAD 2D Introduction Evening Course is ideal for students who are completely new to the software and for those looking to produce advanced 2D plans, elevations and sections, as well as understanding all key tools in AutoCAD 2D. Call 02077202581 or WhatsApp 07970325184. Duration: 10 hrs. Method: 1-on-1, Personalized attention Schedule: Tailor your own slots, available from Mon to Sat between 9 am and 7 pm. Flexible Evening Sessions: Learn at your pace with evening classes. Comprehensive Skill Development: Master 2D Plans, Sections and Elevations. Industry-Standard Knowledge: Gain proficiency sought by employers. Practical Application: Apply skills to real-world design scenarios. Recorded Lessons for Review: Revisit course material anytime. Lifetime Email Support: Get ongoing assistance even after course completion. Course Duration: 10 hours Course Overview: AutoCAD 2D Training Course Designed for beginners, this course teaches the fundamentals of AutoCAD 2D software. Participants will learn essential tools and features to create, edit, and annotate 2D drawings. By course completion, students will confidently produce their own 2D drawings using AutoCAD. Introduction to AutoCAD 2D Overview of AutoCAD 2D software Understanding the user interface Navigating the drawing area Setting up drawing units and limits Creating basic shapes and lines Drawing Tools Utilizing Line, Circle, and Arc tools Implementing Polyline and Spline tools Adding dimensions and annotations Understanding layers and object properties Creating and inserting blocks into drawings Editing Tools Using Erase, Move, and Copy tools Implementing Rotate and Scale tools Understanding grips and grip editing Utilizing Trim and Extend tools Exploring fillets and chamfers Advanced Drawing Tools Utilizing Offset and Mirror tools Implementing Array and Divide tools Understanding hatching and gradient fills Adding text and multiline text Incorporating tables and fields into drawings Final Project Completing a final project using all learned tools and features Instructor-guided process to create a personal 2D drawing with AutoCAD Q&A and review of course material Assessment: Submission of the final project Active participation in class exercises and discussions Requirements: AutoCAD 2D software installed on the student's computer Basic computer skills and familiarity with the Windows operating system A laptop or desktop computer with a minimum of 4GB RAM and a 64-bit operating system.

Discover how to utilize VBA to automate procedures and effortlessly generate reports with a single button press. Streamline your tasks and achieve seamless productivity by performing various actions at the click of a button. No prior knowledge of VBA is required but familiarity with Excel will be an advantage.

Wanna Be The Trusted Waxer That Everyone Raves About? Who is this course for? ​ This Level 6 Depilation course is designed for anyone looking to have a career in the waxing industry and allows for progression on to Intimate Waxing and Advanced Waxing Skills. SQA Level 6 Award in Depilation provides knowledge and practical competence in health & safety within the salon and waxing and is regulated by SQA. The strategy for delivery of this unit is based upon a combination of online theory, and autonomous learning, workshops and practical sessions. This is delivered over 6 sessions. The final stage is an assessment which is submitted to SQA and finally your certificate will be issued. In this unit you will develop the skills required to remove hair from various areas on the face and body. You will gain knowledge of skin and hair structure, hair growth, causes of excess hair growth, hair types, contra-indications, special care conditions and contra-actions. Your practical skills will be developed by consulting with clients to develop treatment plans then preparing for and performing depilation treatments You will give clients homecare and aftercare advice and evaluate the effectiveness of the treatment in relation to technique and product selection. You will demonstrate knowledge of and adherence to relevant health and safety procedures; appearance which reflects organisational and industry standards and effective communication and consultation techniques. You will be assessed by answering structured questions in closed-book conditions to demonstrate your understanding of essential knowledge relating to depilation and will be observed carrying out depilation treatments on a minimum of six areas of the face and body on four different clients. Two of the performances must demonstrate multiple treatment areas. Treatment areas must include Face: upper lip and eyebrow; Body: underarms and bikini; Limbs: half leg and full leg. An assessor observation checklist must be used to provide evidence of performance supported by an accurately completed client consultation record completed by the learner. Practical performance must be carried out in a commercially acceptable time. Key areas of knowledge will be: Structures of the skin Hair structure Hair growth cycle Hair types Causes of excess hair growth Ingrown hairs Contra-indications Contra-actions Personal preparation Consultation techniques Reasons for consultation Client confidentiality Treatment planning Treatment environment preparation Equipment preparation Current waxing techniques — warm and hot wax Correct application and removal methods Product selection Skin sensitivity testing When and how to trim over-long hair Treatment areas: face, body, limbs Client preparation and positioning Client comfort and safety Waste disposal Commercial timing Time management Relevant current Health and safety legislation After care and homecare advice Methods used to evaluate the effectiveness of the depilation technique Self-evaluation ​​ Aspects of the Core Skill of Problem Solving, that is, Planning and Organising, Critical Thinking, and Reviewing and Evaluating, will be naturally developed as the depilation treatment is planned and safely undertaken. In planning the treatment you will identify and analyse a range of factors including suitable products, equipment and techniques to ensure the treatment meets the needs of each individual client. The treatment application must ensure client comfort and safety. Compliance with health and safety legislation is integral to achievement. Communication skills are not formally assessed however you will be expected to present oral and written communication to an acceptable professional standard. Oral communication skills will be developed in practical work with clients when interaction must be professional, sensitive and empathic. Communicating appropriate information to clients, explaining and reassuring during treatment sessions and giving aftercare advice and homecare advice will be an essential aspect of competence. You should be fully aware of a range of active listening techniques in order to relate and respond to others in the most appropriate and effective way, adapting language, register and style to suit their purpose and clientele. In addition to the specific vocational skills developed and assessed you will have the opportunity to develop generic skills which will enhance their employability skills profile, eg customer care skills, communication skills, time management. The SQA Level 6 Depliation is a practical and knowledge based qualification. It is aimed at equipping therapists with skills required for work in salons, destination/day spas and cruise ships. The units have been identified by employers as the most appropriate for working as a beauty therapist however, there are many CPD courses that can enhance the skills learnt and provide new techniques to ensure that the qualified therapist remains current and at the forefront of the industry

Level 3 QLS Endorsed Course with FREE Certificate | CPD & CiQ Accredited | 120 CPD Points | Lifetime Access

AutoCAD Training for 15 hours - Live and Online The AutoCAD Training is for 15 hours that will cover from Introduction to Intermediate in small classes with only 1 people per class. AutoCAD course is for Windows or AutoCAD for MAC platforms. If you have AutoCAD for MAC, please let us know to book the specific course.  The training is tailored to your needs and we will focus the AutoCAD course on the area you want to learn.   During the training, you will receive many AutoCAD tips on how to work fast and efficient.  This live AutoCAD course will be now online at a reduced price.  You will receive a certificate of attendance at the end of the course. After the training, you can book 1 to 1 AutoCAD support to answer your questions and support your journey to learn AutoCAD. This is an extra service that you can book a minimum of 2.5 hours. Spread the cost with interest-free instalments. Buy now, pay later courses! AutoCAD Training: https://www.bimrevittraining.com/autocad-training AutoCAD Course Description AutoCAD Settings and Customization • Workspaces (AutoCAD Classic/2D Drafting & Annotation) • Background Color • Cross Air Size • New / Open and Save • User Preferences • Toolbars • Drawing Units • Drawing Limits • Snap Mode • Grid Display • Ortho Mode • Polar Tracking • Object Snap • Object Snap Tracking   AutoCAD Drawing Tools • Line • Multiple Line • Construction Line • Polyline • Polygon • Rectangle • Arc • Circle • Revision Cloud • Spline • Ellipse / Ellipse Arc • Insert Block • Make Block • Point • Hatch/Gradient • Region • Table • Multiline Text   Modify Tools • Erase • Copy • Mirror • Offset • Array • Move • Rotate • Scale • Stretch • Trim • Extend • Break at Point • Break • Join • Chamfer • Fillet • Explode   Working Methods •Object Properties •Match Properties •Layer Properties Manager •Adding Layers •Working with Layouts •External References •Insert/Edit Images •Insert PDF   AutoCAD Plotting / Publishing •Page Setup Manager •Plot Style Manager •Plotting •Publish •eTransmit

Overview This comprehensive course on Brow Lift & Lamination Training will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Brow Lift & Lamination Training comes with accredited certification, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this Brow Lift & Lamination Training. It is available to all students, of all academic backgrounds. Requirements Our Brow Lift & Lamination Training is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management, Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 5 sections • 12 lectures • 00:47:00 total length •Introduction: 00:01:00 •1. Clean the eyebrows: 00:03:00 •2. Apply The product nr1: 00:02:00 •3. Removing The product nr1: 00:02:00 •4. Apply The product nr2: 00:03:00 •5. Removing The product nr2: 00:02:00 •6. Tint the eyebrows: 00:10:00 •7. Tweeze, wax, trim them: 00:14:00 •8. Strengthening lotion and concealing: 00:08:00 •Tint preparation: 00:02:00 •Resources - Brow Lift & Lamination Training: 00:00:00 •Assignment - Brow Lift & Lamination Training: 00:00:00