257 Courses in London

Facilitated by Registered Clinicians with extensive experience

Most people only use a fraction of Excel's capabilities. This workshop shows what you've been missing! This course will help participants: Nest formulas Get the most from pivot tables Use conditional formatting Write array formulas Explore the lookup functions Calculate by criteria Use 'goal seek' and 'scenario manager' for what-if analysis Record macros 1 Nesting formulas Principles of nesting formulas together Using IF with AND or OR to answer questions Nesting an AND function in an IF Nesting an OR function in an IF 2 Advanced pivot table reports Grouping dates, numerical and text items Running percentage analyse Running analyses to compare data Inserting Field calculations Finishing off with a user-friendly dashboard 3 Advanced conditional formatting Colour table rows based on criteria in it Applying colour to approaching dates Exploring the different rule types 4 Lookup functions Going beyond the VLOOKUP function Lookups that retrieve data from left or right The versatile INDEX and MATCH functions Retrieving data from columns with duplicates 5 Calculate by criteria Using SUMIFS to sum by criteria Finding an average by criteria with AVERAGEIFS Use SUMPRODUCT to multiply then add different values 6 What-if analysis Use Goal Seek to meet targets Forecast reports with the Scenario Manager 7 Recording Macros Macro security Understanding a Relative References macro Recording, running and editing macros Saving files as Macro Enabled Workbooks Introduction to VBA code Making macros available across workbooks Add a macro button to the Quick Access toolbar

Code the Hangman Game in a few hours, in our Taster Java Hangman Code course Basics made simple! Learn plenty in one day and apply techniques to a game by coding The Hangman Game. Get to know what is Java coding. Will you enjoy a coding career? Or for coders, simply fast-track crossing over to Java.

Maximize the value of data assets in the oil and gas sector with EnergyEdge's assessment-based training course on Python programming and analytics.

Develop a deep understanding of electricity pricing and marginal cost analysis with EnergyEdge's virtual instructor-led training course. Enroll now for a rewarding learning journey!

This course presents an approach for dealing with security and privacy throughout the entire software development lifecycle. You will learn about vulnerabilities that undermine security, and how to identify and remediate them in your own projects.

Who is this course for? AutoCAD 2D Basics to Advanced Course. Click here for more info: Website This course enables you to learn the skills in the CAD. Upon completion, you'll proficiently edit and create 2D drawings, utilizing advanced features like Paperspace and Block Attributes for increased efficiency.   1-on-1 sessions. Our booking are available Mon to Sat, 9 am to 7 pm Duration: 16 hours, which you can flexibly distribute across as many days you want. Approach: In-person or live online training. AutoCAD Basics to Advanced Level Training Course Outline. Fundamental Concepts: Introduction to AutoCAD interface, commands, and tools. Managing drawings and creating basic shapes. Basic modification techniques like erase, move, rotate, and scale. Intermediate Techniques: Working with layers and adjusting properties. Creating and modifying text and dimensions. Introduction to blocks and attributes. Advanced Topics: Advanced object modification techniques such as fillet, chamfer, trim, and extend. Utilizing grips for object manipulation. Creating and editing polylines and splines. Course Highlights: Engaging exercises and projects for skill reinforcement. Access to Q&A and troubleshooting support. Proficiency in AutoCAD 2D for basic to intermediate drawings. Topics Covered: Drawing techniques encompassing various shapes. Inquiry tools for measurement and selection. Modification commands for object manipulation. Layer management and attributes. Annotation and dimensioning. Hatching objects and working with reusable content. Layouts and viewports for better organization. Annotating drawings effectively. Polylines, splines, ellipses, and tables. Plotting drawings and creating templates. Multi-lines, revision clouds, and wipeout objects. Working with point objects and calculations. Creating and managing templates. Annotation scaling and text manipulation. Dimensioning and geometric annotations. Dynamic blocks and attributes. Layer management best practices. Introduction to sheet sets and their properties. Utilizing fields and attributes in sheet sets. Working with tables, table styles, and advanced tables. Exporting and importing tables. Creating tables linked to external data. Download AutoCAD Software https://www.autodesk.co.uk What Will I Gain from this Course? Throughout this course, you will develop expertise in the following areas: CAD layering techniques Text and dimension style manipulation Proficiency in creating and editing 2D drawings Mastery of attributed block creation and editing Efficient utilization of Paperspace Dynamic input and grips utilization This comprehensive training program not only provides you with an advanced comprehension of 2D drawing in AutoCAD but also offers a fundamental introduction to 3D drawing concepts. Upon completion of this course, you will possess the skills to: Swiftly generate schematics, parts, and assemblies Enhance efficiency by reusing content and customizing tool palettes Save time through the use of dynamic blocks, which can be edited in place Gain full control over your viewports and layouts Is This Course Right for Me? This advanced AutoCAD 2D training assumes that you are already a proficient AutoCAD user. We recommend prior attendance of our Introduction and/or Intermediate AutoCAD 2D training courses or practical experience in the topics covered in those courses. If you have any doubts about the suitability of this course for your skill level, please feel free to contact us, and we will be happy to assist you. In this course, you will gain proficiency in utilizing essential features of AutoCAD (Computer Aided Design) to enhance the efficiency of producing and editing 2D CAD drawings. You will acquire expertise in layering, text and dimension styles, the creation and modification of attributed blocks, and effective use of Paperspace. Additionally, you will master dynamic inputs, grips, and the art of renaming and purging. This flexible course grants you 16 hours to complete, typically spanning 4 to 5 days. It serves as a valuable continuation of skills acquired from the CAD: AutoCAD 2D Essentials course or as an opportunity to expand your existing AutoCAD knowledge. Upon course completion, you will possess the ability to efficiently create and modify 2D drawings, leveraging advanced features like Paperspace and Block Attributes. Your instruction will be provided by an Autodesk-certified instructor with industry experience." 1. All-encompassing course designed to accommodate both novices and advanced users. 2. Addresses essential functions and advanced methodologies in AutoCAD. 3. Enhances proficiency in creating precise and professional 2D drawings. Interactive instruction guided by seasoned educators. Benefit from on-demand access to lesson recordings for convenient revision. Receive ongoing support through lifetime email and phone assistance. Post-course Assistance: Enjoy continuous support via lifetime email and phone assistance. Should you encounter any challenges or queries after the course, we are readily available to address your concerns via email or phone calls."

This one-day workshop will give you a better understanding of the components and operations of an Access database. It is designed to build on a user's existing skills and includes useful action queries to allow greater manipulation of a database. This workshop will help participants: Ensure the integrity of their databases Manage field properties Use the query functions effectively Save time with the query expression builder Create different types of query more quickly Design better forms Link expressions in forms Create better and more useful reports Import and export tables more easily 1 Table relationship integrity Identifying relationships Identifying criteria for data integrity Applying referential integrity Managing relationship join types 2 Table field properties Field properties overview Using input mask field Using default value fields Using field validation rules 3 Query functions Running aggregate function calculations Running sum, average, count, max and min functions Grouping calculated data 4 Query calculations Using query operators and expressions Adding calculated fields to a query Using the query expression builder 5 Action queries Creating make table queries Creating append queries Creating update queries Creating delete queries 6 Designing forms Adding form controls Aligning and arranging form controls Adding pictures and labels to forms Adding new fields to a form Controlling tab order Adding command buttons Adding a combo box control Formatting data using conditional formatting 7 Form expressions (calculations) Using the form expression builder Working with a property sheet within a form Linking expressions within a form 8 Working with reports Creating reports with the report wizard Inserting report fields Formatting fields Inserting report headers and footers Working with a property sheet within a report 9 Grouped reports Creating groups with the report wizard Sorting grouped data Grouping alphabetically Grouping on date intervals Creating sub reports Adding calculations to groups 10 Importing and exporting tables Importing tables into Access Exporting tables from Access Importing and linking data in Access

Why AutoCAD Night Training Course? This Autodesk AutoCAD 2D Evening Course, 10 hours, is perfect for beginners aiming to create 2D plans, elevations, sections. It covers all tools in AutoCAD 2D, making it valuable for both newcomers and those aspiring to enhance their skills. Click here for more info: Website When: Personalized 1-on-1 sessions. Available from Mon to Sat 9 am to 7 pm. Book over the phone, call 02077202581 Duration: 10 hours (Split 10 hrs over as many as days you want) Method: In-person or live online training Course Content: Foundational Shape Construction Manipulating Lines, Arcs, and Polylines Optimizing Object Alignment with Grip Tools Data Management and Backup Protocols File Format Exploration and Understanding Disaster Recovery Strategies Advanced Object Creation Techniques Precision Measurement Unit Handling Dynamic Input Methods Utilizing Inquiry Commands and Measurement Tools Effective Object Visualization and Navigation Zoom, Pan, and Object Manipulation Swift Object Management Strategies Object Transformation and Alteration Techniques Functions for Trimming, Extending, and Offsetting Objects Creating Various Geometric Shapes Object Editing, Joining, and Filleting Stretching and Organizing Objects Layer Management and Customization Configuring Object Properties and Linetypes Designing Layouts and Efficient Page Configurations Scaling Drawing Views and Adding Annotations Text Creation, Styling, and Editing Dimensioning Principles and Customization Implementing Multileaders for Annotations Object Hatching and Editing Techniques Managing Reusable Content: Blocks and Symbols Utilizing Tool Palettes and Working with Groups Understanding Model Space and Paper Space Creating Layouts and Viewports Scaling Viewports and Plotting/PDF Output Managing Multiple Sheet Drawings Optimizing Plotstyles for Printing Creating Custom Drawing Templates To download AutoCAD, visit Autodesk's official website. Advantages: AutoCAD stands as the industry-leading computer-aided design (CAD) software, widely adopted for creating architectural, engineering, and construction drawings. Acquire essential skills applicable across a diverse spectrum of industries. Assessment: Evaluation will occur informally during classes, which comprehensively cover specific topics, complemented by practical drawing exercises to reinforce skills and knowledge. Additionally, we offer longer, independent drawing tasks that encompass multiple acquired skills, evaluated against professional benchmarks. Requirements: Prospective participants should possess basic computer literacy and engagement in professions where CAD is utilized. English Proficiency: Applicants are expected to demonstrate proficiency in both written and spoken English. Why Opt for This Course? Our AutoCAD course is your gateway to mastering the essential skills for creating top-notch technical drawings. Designed with beginners in mind, this course is perfect for individuals who have little to no prior experience with AutoCAD. If your work or studies involve CAD drawings, gaining a solid grasp of the program is crucial for confidence and proficiency. Upon enrollment, students gain access to a free 30 days trial. While classes are conducted using AutoCAD on PC, it's worth noting that the course is compatible with AutoCAD on Mac, albeit with slight interface variations. Who Should Attend? This course caters to those eager to acquire the skills necessary for creating and interpreting drawings produced in AutoCAD. Our diverse system hails from various industries, including engineering, architecture, landscape architecture, construction, electronics, and product design. Why Opt for CAD Training? Practical Learning Experience: Immerse yourself in hands-on training. Personalized One-to-One AutoCAD Classes: Benefit from individualized attention. Expert and Knowledgeable Instructors: Learn from skilled and experienced teachers. Online Training Recordings: Access recorded AutoCAD training sessions online. Best Price Guarantee: Enjoy competitive pricing with a satisfaction guarantee. Pre and Post-Training Support: Receive lifetime free support before and after completing your training. Flexible Schedule: Choose your class timings and dates-weekdays, weekends, or evenings. Tailored Course Content: Customize the AutoCAD course to align with your specific needs. Access Anywhere: Access AutoCAD training and support from any location.

An emergency can happen anywhere, so it's better to be prepared at all instances, specially at the workplace. Come to Knight Training and ensure your employees are safe with our Emergency First Aid At Work Course now!