1108 Courses in London

Learn everything that you need to know to become a casino croupier then decide whether you want to work on cruise ships or casinos all over the world

Work with award winning filmmaker and leading London acting coach Fay Beck.

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

Why Choose Revit Basic to Advanced Training Course? Course info. Revit Basic to Advanced Master complex 3D modeling, BIM workflows, and project phasing. In-person or live online options available. Enroll now to elevate your architectural, engineering, and construction projects with advanced Revit techniques. Duration: 16 hours Methof: Personalized 1-on-1. Customized Schedule: Choose a convenient hour from Mon to Sat between 9 am and 7 pm to create your own schedule.   Revit Basic to Advanced Training Course: Learn the fundamentals of Revit for architecture and structural design, supporting BIM workflows for efficient building construction. Delivery Options: In-class at our center Live online sessions Who Should Attend? Ideal for architects, building designers, structural engineers, and general users. Course Outline: I. Introduction to Revit  Explore Revit's purpose and applications Familiarize yourself with the user-friendly interface and essential tools Navigate efficiently and control viewports Initiate and save projects for future reference II. Setting up a Project  Create new projects and use templates for efficiency Establish project levels, grids, and crucial building information Configure project units for precision and consistency III. Basic Modeling  Master the creation and customization of walls, doors, and windows Develop floors, ceilings, and roofs for complete building structures Craft functional and aesthetically pleasing stairs and railings IV. Advanced Modeling  Learn to design custom parametric families to enhance productivity Explore conceptual modeling tools for creative freedom Integrate lighting and materials for realistic 3D rendering V. Views and Sheets  Efficiently manage views and organize them effectively Generate informative and well-structured sheets for documentation Integrate schedules and tags to enhance information clarity VI. Annotation and Detailing  Add clear and concise text and dimensions to your designs Customize detail components for precise annotations Employ symbols and keynote legends for standardized documentation VII. Phasing and Worksharing Grasp the concepts of phasing and design options Manage and modify phases effectively Collaborate seamlessly with worksharing features VIII. Project Collaboration and Management Establish a productive worksharing environment Monitor and track worksets and user activities Synchronize worksets for a coordinated team effort IX. Advanced Documentation  Create specialized and advanced schedules for comprehensive project insights Develop legends and keynotes to enhance documentation clarity Finalize construction documents with professional-looking sheets and title blocks X. Conclusion and Next Steps  Recapitulate the course content and achievements Receive valuable tips for continuous learning and further resources Engage in a Q&A session to address any remaining queries or concerns For more information and to start your learning journey, visit our website or download the free trial of Autodesk Revit from the provided link: https://www.autodesk.co.uk/autodesk/revit

Being safe at the workplace should be a priority for any business. Come to Knight Training to train with us and start working safe with our IOSH Managing and Working Safely Course!

MASTERCLASS: LEARN PROFESSIONAL LEATHER CRAFT, SEWING AND LEATHERGOODS CONSTRUCTION SKILLS One teacher, five students KEY FEATURES OF THIS COURSE:– Understanding and working with leather– Learning leather hand sewing– Learning leather machine sewing– Realising samples of bag features– Realising two finished leather items Experience a comprehensive two-week Leather Craft and Sewing Masterclass, merging theory with hands-on learning Explore essential techniques for working with leather, vegan alternatives, and fabric. Proficiently handle hand tools, master hand-sewing, and operate industrial machines. Cover material selection, finishing and construction methods.Gain insights into the technical aspects of leatherworking, including preparation, marking, cutting, gluing, reinforcing, skiving, debossing, and more.Participants receive thorough instruction in professional sewing techniques on diverse industrial machines, along with specialised saddle stitching training. Create personalised samples to enhance practical skills.Conclude the masterclass with the ability to craft entirely handmade simple leather items, showcasing acquired skills in both machine-stitched and saddle-stitched styles.Facilitated by a prototype maker and manufacturer, the course offers a professional journey into common leatherworking practices.Participants also receive valuable handouts and curated lists of leather and tool suppliers for ongoing reference.   Here is a concise summary of the topics covered during the classes: LEATHER, VEGAN LEATHER, AND HAND TOOLS:Understanding leather types, tanning, finishings and best useExploring different types of vegan leathers and their featuresComparing leather and vegan leather: pros and cons from a manufacturer’s perspectiveImportance of choosing the right materials and tools for projectsLeather preparation, pattern placement and markingCutting complex shapes with various toolsUsing leather punches, skiving, beveling and creasingFinishing leather edges: painting vs. burnishingUtilising leather glues, tapes and reinforcementsExploration of prototyping and manufacturing leather goods, encompassing varied working methods, machines, and tools.   MACHINE AND HAND SEWING:Understanding industrial sewing machines and their differencesSelecting the right sewing machine for specific materials and constructionsOperating a lock stitch walking foot machineThreading industrial sewing machinesAchieving correct tension in sewingUnderstanding thread types and needle sizesLearning to sew leather, distinguishing it from other materialsCorrectly sewing various leather types, ranging from thin to very thickSewing straight lines, curves and creating parallel seamsProducing various seams and seam finishesBasics of saddle stitching leather and understanding related tools and materials   CONSTRUCTION TECHNIQUES:Sewing and finishing a simple zip on leatherCutting, assembling and sewing simple straps/handlesIncorporating basic lining types in projectsConstructing and sewing common gussetsComprehending the use of reinforcements and stabilisers and their application in the craft of accessory making   LEATHER GOODS MAKING:Creating two finalised leather items from chosen designs such as card holders, purses, clutches, glass covers and similar accessories.# By the end of the tuition, you will have:– Developed confidence in utilising specific tools for leather preparation, marking, finishing, cutting and fastening fittings.– Acquired an understanding of working with diverse leather types and thicknesses, with the ability to source and select appropriate tools and materials for your projects.– Mastered essential leather sewing techniques, troubleshooting common sewing issues and handling challenges such as curves, multiple layers of leather and various surface textures.– Learned to sew fundamental bag components like simple zips, straps, and gussets, along with reinforcing specific areas of a bag.– Built confidence in sewing with both industrial machines and by hand, gaining the skills to independently create simple leather items. Included in the course:You will be provided with useful paper handouts which contain:– A list of tools and materials used during the lesson(s), including a description of what they are and how they are used– A list of recommended suppliers for both leather and fittings (physically in London and online)– A glossary containing essential key words related to the topic of the lesson– A glossary containing information about leather types and characteristics– A glossary containing information about needle and thread types   What are the entry requirements? This course is suitable for total beginners, beginners with some experience and intermediate.You should be able to use measurements and understand verbal and written English instructions.   Are there any other costs? Materials are included.   Is there anything I need to bring? Feel free to bring a notepad, if you would like to take some notes, we will provide the rest.   How long is this tuition? This tuition will require two consecutive weeks / 50 hours to be completed.We aim to provide customised and high quality tuition services and by only allowing up to 5 students at a time, we are able to focus on each person needs and interests.   IMPORTANT TO KNOW: We aim to cover as much of the syllabus as possible. Depending on your ability and prior experience, we may not complete the entire program or we might delve into additional techniques related to the listed topics, including:Advanced finishing techniques (piping, binding, folding)More complex styles of zipsUtilising different machine feet, tools, and equipment in your sewingExploring various fittings, closure types, fastening techniques, and tools (sam browns, magnets, pop buttons, eyelets, etc.)Understanding the importance and application of construction sequences and reference notes during item construction

Join me at the Big Penny Social for a special evening of hand stitching. I will take you through the very cool technique of chickenscratch embroidery, which is done on gingham fabric with normnal embroidery threads. Simple techniques can be combined in endless ways and colours to adorn clothes, homewares, notebook covers, all kinds.

Learn mosaic crochet in Surrey - this is an immersive 4 x 2 hour course running on Tuesday evenings in Walton-on-Thames.

4and20Million run Sustainable Excellence, a course designed to help people unlock their productivity, without resorting to longer hours and unnecessary stress. For full details, further information and learning more about how to boost your career prospects, please contact: dan@4and20million.com alex@4and20million.com

About this Training Course In our pursuit to discover oil & gas in deeper horizons, wells are often drilled in a HPHT environment. To be considered a HPHT well, the downhole conditions will have pressures in excess of 10,000 psi (69 MPa) and 300° F (150° C). To drill these usually expensive wells successfully, the planning and execution phase has to be of an exceptionally high standard. Therefore, both operator and drilling/service contractor staff must be seamlessly aligned and work as a coherent team to reach and then harness the well objectives. This is particularly important when speciality services such as Managed Pressure Drilling (MPD) are being applied with crews and/or supervisors who are not intricately familiar with complicated well control incidents. As we seek to prevent costly non-productive time, attention will also be paid to enabling technologies like expandable solid tubulars, mud coolers and specialty mud. The 3 full-day course will explain the key characteristics and challenges of HPHT Planning and Well Control. This includes: Differences between HPHT and standard (conventional) wells and what this entails for well design. The challenges unique to HPHT and the impact of Pore Pressure Prediction (PPP). Static and Dynamic Equivalent Mud Density and the factors that influence the ultimate Bottom Hole Pressure (BHP). Control practices such as 'fingerprinting' to identify what's happening downhole. HPHT shut-in procedures and practices. Specific HPHT equipment and drilling tool requirements and advantages of Managed Pressure Drilling (MPD). Well control on/off bottom, bull-heading and dealing with kick-loss situations. Mud management, tolerance on mud properties and challenges in cementing. Case history on emergency control. Drills, team effort, checklists, human factor and 'getting everybody on board'. Training Objectives By the end of this course, participants will be able to: Recognize the main differences in planning/design between HPHT and standard (conventional) wells as well as the challenges that will have to be faced. Explain drilling and tripping operational challenges and practices as well as how to manage these effectively. Identify wellbore breathing (a.k.a. ballooning) and how to safely deal with this within the narrow window for mud density selection. Apply practices of consistent fingerprinting and how to develop procedures for this to benefit the rig team. Measure and understand bottom hole pressure and the effect of influencing factors such as temperature, rotation and flow rate. Understand the critical mud properties to alleviate barite sag, general mud density control techniques and specify the essentials in cementing. Manage losses and low fracture gradients with well bore strengthening methods. Execute sound HPHT shut-in procedures. Understand how MPD can assist in the safe and efficient drilling and hole cleaning of HPHT wells. Understand the use of MPD Influx Management Envelopes. Identify critical Early Kick Detection Systems (EKDS) and HPHT well control equipment. Execute safe secondary well control practices in a H2S environment, bull-heading, on and off bottom and handling of gas at surface, using MGS and hydrate mitigation measures. Target Audience The course is intended for: Office-based staff engaged in HPHT well planning and day-to-day operations Field-based rig staff working as front-line supervisors - from Assistant Drillers to Senior Toolpushers Field-based rig staff working for service companies supporting the execution of HPHT wells (MPD, mud and mudlogging services etc.) Trainer Your expert course leader has over 45 years of experience in the Oil & Gas industry. During that time, he has worked exclusively in the well engineering domain. After being employed in 1974 by Shell, one of the major oil & gas producing operators, he worked as an apprentice on drilling rigs in the Netherlands. After a year, he was sent for his first international assignment to the Sultanate of Oman where he climbed up the career ladder from Assistant Driller, to Driller, to wellsite Petroleum Engineer and eventually on-site Drilling Supervisor, actively engaged in the drilling of development and exploration wells in almost every corner of this vast desert area. At that time, drilling techniques were fairly basic and safety was just a buzz word, but such a situation propels learning and the fruits of 'doing-the-basics' are still reaped today when standing in front of a class. After some seven years in the Middle East, a series of other international assignments followed in places like the United Kingdom, Indonesia, Turkey, Denmark, China, Malaysia, and Russia. Apart from on-site drilling supervisory jobs on various types of drilling rigs (such as helicopter rigs) and working environments (such as jungle and artic), he was also assigned to research, to projects and to the company's learning centre. In research, he was responsible for promoting directional drilling and surveying and advised on the first horizontal wells being drilled, in projects, he was responsible for a high pressure drilling campaign in Nigeria while in the learning centre, he looked after the development of new engineers joining the company after graduating from university. He was also involved in international well control certification and served as chairman for a period of three years. In the last years of his active career, he worked again in China as a staff development manager, a position he nurtured because he was able to pass on his knowledge to a vast number of new employees once again. After retiring in 2015, he has delivered well engineering related courses in Australia, Indonesia, Brunei, Malaysia, China, South Korea, Thailand, India, Dubai, Qatar, Kuwait, The Netherlands, and the United States. The training he provides includes well control to obtain certification in drilling and well intervention, extended reach drilling, high pressure-high temperature drilling, stuck pipe prevention and a number of other ad-hoc courses. He thoroughly enjoys training and is keen to continue taking classes as an instructor for some time to come. POST TRAINING COACHING SUPPORT (OPTIONAL) To further optimise your learning experience from our courses, we also offer individualized 'One to One' coaching support for 2 hours post training. We can help improve your competence in your chosen area of interest, based on your learning needs and available hours. This is a great opportunity to improve your capability and confidence in a particular area of expertise. It will be delivered over a secure video conference call by one of our senior trainers. They will work with you to create a tailor-made coaching program that will help you achieve your goals faster. Request for further information post training support and fees applicable Accreditions And Affliations