3354 Courses

The Personal licence Course qualification aim is to provide individuals with essential knowledge of the legal framework surrounding the sale of alcohol in England and Wales.

Course Objectives The goal of this course is to provide you with the knowledge required to use more advanced functions and formulas and work with various tools to analyse and present data in spreadsheets, such as sorting, filtering, applying conditional formatting and charting the data. ' Customer Feedback Really useful and engaging course. Learnt a lot that will be very beneficial in my job. Trainer was great. Kelly Moreley - TACT Very happy with the course. Worked as a good refresher from what I knew already and enhanced my knowledge further in formulas + vlookup and shortcut keys. Jenny Price - Acer 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 classroom, 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. Recap on Excel formulas and calculations Overview of formulas in Excel Relative, Absolute and Mixed cell references Group editing worksheets Autofill and Flash Fill Changing Excel’s environment Options Changing the default number of sheets Creating an Autofill Custom List Adding tools to the Quick Access Toolbar Mastering Excel Tables Introducing Excel Tables Formatting a Table Creating Calculated Columns Using Slicers to filter your data Using Totals to get statistics out of your data Removing duplicates Converting Tables back to normal Ranges Using names Ranges In Excel formulas As a way of navigating through the workbook Advanced Formulas Simple IF examples Using IF to check if a cell is blank Nested IFs VLOOKUP HLOOKUP Text Functions Date Functions Conditional formatting Apply Conditional Formatting Customising Conditional Formatting Using Icons in Conditional Formatting Using Formulas to conditionally format cells Linking spreadsheets and workbooks Making a reference to another worksheet Making a reference to another workbook Editing links Troubleshooting links Analysing databases Quick analysis Sorting a database Apply filters to a database Advance filter Sorting and Filtering by Conditional Formats Charts Analyse trends in data using Sparklines Creating charts from start to finish Exploring the different Chart Types Apply Chart Styles Formatting Chart Elements Filtering Charts by Series or Categories Adding a Trendline to a Chart Create a Chart Template Attaching security to a spreadsheet and workbook Protect Cells Protect Structure of worksheets Protect a Workbook by adding passwords Introduction to Pivot Tables What are Pivot Tables? Using recommended pivot tables to analyse your data Who is this course for? Who is this course for? For those who want to explore in more detail formulas and functions, data analysis and data presentation. Requirements Requirements Preferably, delegates would have attended the Excel Introduction 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

The course price includes Refreshments, Car Parking Fees, Workbooks, Resources including access to our Trainer Resource Pack via the Approved Trainer HUB, Approved Trainer Membership, Approved Trainer T-Shirt, Ongoing Quality Assurance , support and Certification. We deliver this course to small groups a maximum of 4 people attend this course at our training premises ensuring all our learners receive Quality time with the Trainers/ Assessors delivering the course.

Landscape photography workshop and tour in the Lake District. Join Matt from Visuals of Scotland for a whirlwind tour of England's finest National Park

Training duration: 10 hrs. Click here for more info Method: 1-2-1, Personalized attention, Tailored content, Flexible pace, Individual support. Schedule: Personalized training experience with our flexible 1-2-1 sessions. Tailor your own schedule by pre-booking a convenient hour of your choice, available from Monday to Saturday between 9 am and 7 pm. Discover the world of 3D computer graphics and animation with our Autodesk Maya Basic to Fundamentals Training Course. Whether you're a beginner or aspiring artist, this comprehensive program equips you with essential skills in modeling, animation, and rendering. Benefit from interactive learning, experienced instructors, and the option to choose in-person or live online sessions. Enroll now to gain industry-standard knowledge and unleash your creativity in the field of animation and visual effects. Maya Basic to Intermediate Course Course Duration: 10 hours Course Outline: I. Introduction to Maya (1 hour) - Gain an insightful overview of Maya and its diverse applications - Familiarize yourself with the Maya interface and essential tools - Master navigation and viewport controls with ease - Learn the art of creating and managing projects proficiently II. Creating 3D Models (2 hours) - Lay a strong foundation in polygon modeling basics - Craft and shape basic objects and shapes adeptly - Refine and modify objects with precision and creativity - Unlock the art of constructing complex objects using extrusions and bevels III. Texturing and Materials (1 hour) - Venture into the realm of texturing and its significance - Create and skillfully apply materials to enhance visual appeal - Master the art of texture mapping and UV unwrapping techniques - Seamlessly import and incorporate textures and images into your projects IV. Lighting and Rendering (1.5 hours) - Illuminate your creations with fundamental lighting techniques - Set up cameras and compose visually captivating scenes - Master the art of rendering still images and dynamic animations - Explore diverse output options and file formats for professional results V. Animation (2.5 hours) - Embark on an enthralling journey into the world of animation - Effectively utilize keyframe animation and animation curves - Create and edit animation clips for seamless and captivating motion - Dive into the intricacies of rigging and animating a simple character VI. Special Effects (1 hour) - Unleash the potential of particle systems and dynamics - Create and manipulate mesmerizing fluid and fire effects - Craft and refine awe-inspiring special effects such as explosions and smoke VII. Intermediate Modeling Techniques (1 hour) - Elevate your skills with NURBS modeling essentials - Create and modify curves and surfaces with finesse - Dive into the world of crafting organic shapes using NURBS techniques - Employ sculpting tools to create high-resolution and detailed models VIII. Conclusion and Next Steps (0.5 hours) - Recap the wealth of knowledge from the course content - Discover valuable tips and resources for further learning and growth - Engage in a dynamic Q&A session and provide valuable feedback

HSE, First aid at work, EFAW, FAW,

QA Level 3 Award In Paediatric First Aid (Annual Refresher) (RQF) This page is here if you'd like us to run this course for you and your people, at our venue or yours (within 45 minute drive from Chesterfield, Derbyshire). If you'd like us to run this course for you and you're further away, please contact us direct for a quote.   If, instead, you're interested in an open/public course, please go here. Half day course Have you already got a valid Emergency Paediatric First Aid or Paediatric First Aid certificate? Can you still remember everything you were taught? Ofsted and HSE highly recommend Paediatric Annual Refreshers to keep your skills and knowledge up to date! Course Contents: Managing an Unresponsive Infant or Child Adult, Child and Infant Recovery Position Infant and Child CPR How to use an AED on an Infant and Child Choking Adult, Infant and Child Wounds and Bleeding Shock Benefits of this course: Have you already got a valid Emergency Paediatric First Aid or Paediatric First Aid certificate? Can you still remember everything you were taught? This course is fully accredited, thus ensuring you have done your due diligence It is taught in a fun, engaging, hands on way, so you get lots of practice in You will really enjoy yourself while re-learning these life-saving skills Accredited, Ofqual regulated qualification: Our Paediatric First Aid (Annual Refresher) course is a nationally recognised, Ofqual regulated qualification accredited by Qualsafe Awards.This means that you can be rest assured that your Paediatric First Aid certificate will fulfill the legal requirements. It is a very good way to make sure you and your employees are trained in First Aid for Children and Infants (babies).The Ofqual Register number for this course is 603/3153/7

👋 Say goodbye to outdated training, low confidence and unsolvable problems. 🎯 Hydronics Unlocked is our game-changing training programme designed for heating engineers. Whether you fit boilers or heat pumps, we're making it easier to master your craft and get ahead. Our programme is designed for you to upskill in your own time, at your own pace: Kick-Off Day in the classroom: a transformative introductory day of hydronics training for modern systems with your peers. Learn online: flexible, bite-sized modules designed to fit around your schedule and deliver practical outcomes. Qualification: includes Low Temperature Hot Water qualification on successful completion of the online modules. Ongoing learning available with Kimbot AI: all of Kimbo's knowledge in your pocket, Kimbot is ongoing support via our app for troubleshooting, peer connections and continuous development. 📣 Our Pilot offer We’re offering 16 spaces for this fifth pilot session, which is pivotal to shaping the future of Warmur Academy. Pilot attendees must also book the online modules, but as an early adopter, you’ll save £245 on the full program. You must be a practicing heating engineer (boilers or heat pumps). 👍 Look at what you get! Transformative day in person with Kimbo An updated version of the classic handout Lunch! Access to our online programme as we roll out from April 2025 Access to the Kimbot AI Beta trial Access to 2 months of free live online sessions with experts Level 3 RQF Low Temperature Hot Water (LTHW) Qualification (on successful completion of online modules) 👌 Early adopters discount price Kick off day in the classroom £195+VAT - FREE Discounted online modules with LTHW qualification: £495+ VAT £445+VAT - you must attend the pilot Kick off day to get access to the online modules Total £690+VAT £445+VAT 🗺 Where and when Pilot Kick Off Day: Tuesday 11th March Location: 2 Lumbertubs Lane, Boothville, Northampton, NN3 6AH Google Maps Link: https://maps.app.goo.gl/4z4Kv8HnMnWGZF5SA 🚀 Spots are limited! We're keeping numbers small so we can test the new in-person programme and gather feedback. This is a wonderful opportunity to get early access to what will be a transformative training programme for the heating industry.

Why Choose 3ds Max and Vray Training Course? Click here for more info 3ds Max a valuable tool for architectural modeling, product design, and manufacturing across numerous industries. While widely utilized, mastering the software requires effort. Engaging in 3ds Max tutorials proves particularly advantageous for game designers, aiding in their career advancement. Duration: 10 hrs Method: 1-on-1, Personalized attention Schedule: Tailor your own hours, available from Mon to Sat between 9 am and 7 pm Our 3ds Max course consists of two main sections, covering architectural visualizations for both interior and exterior scenes. By the end of the training, you'll have the expertise to create professional projects independently. We begin with fundamental and advanced 3D modeling, starting from simple objects and progressing to complex buildings, interiors, and products. 3ds Max and Vray Comprehensive Course Course Duration: 10 hours Course Overview: This course is designed to offer a comprehensive introduction to 3ds Max and Vray. Throughout this program, you will acquire the knowledge necessary to proficiently create 3D models, apply materials and textures, configure lighting and camera systems, and produce high-quality Vray renders. This course is suitable for individuals with various levels of experience, from beginners to those with some prior exposure to 3D modeling and rendering. Course Outline: Module 1: Introduction to 3ds Max and Vray Familiarization with the 3ds Max interface Configuring the workspace Navigating within 3ds Max Introduction to Vray and its user interface Module 2: 3D Modeling Creating fundamental shapes Employing modifiers Crafting intricate shapes through advanced 3D modeling techniques Grasping the fundamentals of polygonal modeling Crafting both organic and inorganic models Module 3: Materials and Textures Application and modification of textures Understanding UVW mapping Utilizing the material editor Developing custom materials Leveraging Vray materials Module 4: Lighting Introduction to various lighting techniques Exploring different types of lights Comprehending light properties Configuring lights for a scene Employing Vray lights Module 5: Cameras Familiarization with camera systems Understanding camera properties Setting up camera views Creating animations using cameras Utilizing Vray cameras Module 6: Rendering Introduction to rendering Exploring Vray Global Illumination Utilizing Vray Physical Cameras Harnessing Vray HDRI Lighting Implementing the Vray Rendering Workflow Module 7: Projects Integrating all acquired knowledge Crafting a simple interior scene Constructing a basic exterior scene Developing a complex scene featuring multiple objects and materials Course Requirements: To participate in this course, you will need: A computer with 3ds Max and Vray installed (trial versions can be obtained from Autodesk and Chaos Group websites) Basic computer operation skills An interest in 3D modeling and animation Course Goals: Upon completing this course, you will have gained a comprehensive understanding of 3ds Max and Vray. You will possess the skills required to create realistic and visually captivating 3D scenes using Vray. Furthermore, you will be well-equipped to continue honing your 3D modeling and rendering abilities. Resources: Vray Trial Download: https://www.chaosgroup.com/vray/sketchup/free-trial Materials:https://www.vray-materials.de/ Textures: https://textures.com/ By completing the 3ds Max and Vray Training Course, participants will acquire proficiency in 3D modeling and rendering using 3ds Max. They will establish a solid foundation and essential skills, enabling them to create captivating visualizations. This expertise opens doors to various job opportunities in fields such as architectural visualization, game design, film production, and product modeling.

Why AutoCAD Mac Basics-Advanced Training Course? Click here for more info Learn 2D drawing, Plans, Sections, Elevations and advanced features. Choose in-person or live online sessions. Certified tutors, practical exercises, and career advice. Access recorded lessons and lifetime email support.  Duration: 16 hrs. Method: 1-on-1, Personalized attention. Schedule: Tailor your own schedule by pre-booking a convenient hour of your choice, available from Mon to Sat between 9 am and 7 pm. AutoCAD for Mac Essentials to Advanced Training Course: Learn AutoCAD for Mac and master its popular functionalities, tailored for Mac users. Course Highlights: Thorough grounding for beginners in using AutoCAD for Mac. Develop the skills to create precise and high-quality 2D layouts and designs. Generic drawing techniques applicable to all industries. In-class or live online options available. Ideal for newcomers to AutoCAD for Mac, self-taught users, and those transitioning from other CAD tools. Autodesk Certified Tutors: Autocad Mac 1-2-1 training courses. Expert trainers with extensive experience in AutoCAD and various CAD applications. Hands-On Learning: Practical and hands-on training with demonstrations and step-by-step techniques. Support and Prerequisites: Lifetime post-course email support. Good working knowledge of the Mac OS required, no prior CAD experience needed. AutoCAD Mac Course Content: Fundamental Drawing:Creating Basic ObjectsWorking with LinesWorking with ArcsHandling Polylines Object Manipulation Techniques:Utilizing GripsMastering Object SnapsTracking Object Snap PointsEmploying Polar Tracking File Management:Saving Your WorkAuto-backupsUnderstanding Different File Formats (DXF, etc.)Disaster Recovery Accurate Object Creation:Working with UnitsUtilizing Dynamic InputUsing Inquiry Commands for Measurements Object Viewing and Navigation:Zooming TechniquesPanning Techniques Object Manipulation:Selecting Objects in the DrawingNoun/Verb SelectionQuick SelectMoving, Copying, Rotating, Mirroring, and Arraying ObjectsScaling, Trimming, and Extending Objects Organizing Drawings:Managing LayersChanging Object PropertiesExploring the Properties PaletteUsing Different Linetypes Layouts and Annotations:Working with Layouts and Page SetupsScaling Drawing ViewsAnnotating the Drawing with Text and DimensionsCreating MultileadersApplying Hatching to Objects Reusable Content:Creating and Inserting Blocks and SymbolsUsing Tool PalettesWorking with Groups Paper Space and Model Space: Understanding Model Space and Paper Space Creating Layouts and Managing Viewports Setting Viewport Scales Plotting and Output: Plotting Drawings Generating PDF Output Handling Multiple Sheet Drawings Using Plotstyles Drawing Templates and AutoCAD Tools: Creating Drawing Templates Exploring AutoCAD Toolsets Advance Plans, Sections, Elevations and Construction detailing. This course provides comprehensive instruction in AutoCAD, equipping participants with essential skills to create and manage drawings effectively for various design projects.