6744 Courses

Ideal for those already using Excel but who really want to get to grips with formulas and functions. Course overview Duration: 1 day (6.5 hours) Our Excel Mastering Formulas and Functions course looks at how to confidently use formulas and functions within Excel. It looks at how to correctly construct formulas and explains how to build common formulas such as working with percentages. It investigates a range of built in Excel functions and shows you how to use the formula auditing tools to help when things go wrong.  This course is aimed at existing users of Excel who want to further their skills. Participants should be able to confidently create and amend worksheets. Objectives By the end of the course you will be able to: Construct Formulas Use a range of common Functions Work with absolute and relative references in formulas Create percentage calculations Use named ranges in formulas Use the XLOOKUP command Create formulas with date and use date functions Use formulas in conditional formatting Use a range of Count functions Use the formula auditing tools Content Formulas vs Functions Constructing formulas Using functions Common Excel functions Using the function wizard vs the formula bar Formulas in tables Absolute vs relative references in formulas Using absolute references in formulas Using partial absolute referencing Range Naming Naming ranges Using range names in formulas Single and multi-cell ranges Working with percentages Creating formulas with percentages Percentage breakdowns Percentage increases Formatting as a percentage Using Lookups Using XLOOKUP to insert information from other spreadsheets Calculating with dates Calculating with dates Using date functions Using formulas in conditional formatting Using conditional formulas Using functions in conditional formatting Count functions COUNT COUNTA COUNTBLANK Formula auditing Using the auditing facility Tracing how formulas are made up Tracing precedents and dependants Evaluating formulas Error checking Showing formulas on a sheet

This course is a beginners programmers course, to intermediate level, starting from basics through to creating methods, classes and objects. At the end of this course, one would be conversant with all the necessary basics of Java. This is a one day course in classroom, in Manchester.

Mid-Century Modern home design and shopping event at The Arienas Collective in Edinburgh

The Expand a Business to Other Countries course gives you the knowledge to grow your business beyond borders. You will learn how to research new markets, understand customers, plan strategies, and use marketing tools the right way. This course breaks down business expansion into easy steps, helping you think clearly and act smartly in global markets. It covers marketing, customer behaviour, branding, pricing, communications, and strategic planning. Course Curriculum ✓ Module 01: Basics of Marketing ✓ Module 02: The Marketing Process ✓ Module 03: Strategic Marketing ✓ Module 04: Marketing Environment ✓ Module 05: Market Segmentations ✓ Module 06: Consumer Buying Behaviour ✓ Module 07: Business Markets and Buying Behaviour ✓ Module 08: Marketing Research ✓ Module 09: Product Strategy ✓ Module 10: Branding Strategy ✓ Module 11: Product Life Cycle ✓ Module 12: Pricing Strategy ✓ Module 13: Marketing Channels ✓ Module 14: Integrated Marketing Communications ✓ Module 15: Advertising and Sales Promotion ✓ Module 16: Personal Selling and Public Relations ✓ Module 17: Direct and Digital Marketing ✓ Module 18: What is Marketing? ✓ Module 19: Common Marketing Types (I) ✓ Module 20: Common Marketing Types (II) ✓ Module 21: The Marketing Mix ✓ Module 22: Communicating the Right Way ✓ Module 23: Customer Communications ✓ Module 24: Marketing Goals ✓ Module 25: The Marketing Funnel ✓ Module 26: Marketing Mistakes (I) ✓ Module 27: Marketing Mistakes (II) ✓ Module 28: An Introduction to Strategic Planning ✓ Module 29: Development of a Strategic Plan ✓ Module 30: Strategic Planning for Marketing ✓ Module 31: Strategic and Marketing Analysis ✓ Module 32: Internal Analysis ✓ Module 33: External Analysis ✓ Module 34: Market Segmentation, Targeting and Positioning ✓ Module 35: Approaches to Customer Analysis ✓ Module 36: Approaches to Competitor Analysis Learning Outcomes Understand the key ideas behind marketing. Learn how the marketing process works. Study customer behaviour in different markets. Discover how to segment and target new markets. Explore product, pricing, and branding strategies. Create effective advertising and promotion plans. Understand how to use digital and direct marketing. Develop a strategic marketing plan for growth. Analyse competitors and customers clearly. Gain skills to enter international markets with confidence. Who is this course for? This course is ideal for business owners, entrepreneurs, and managers who want to grow their company in new countries. It also suits marketing professionals and students eager to learn how global markets work. If you plan to take your product or service to an international level, this course is for you. Eligibility Requirements You don’t need any formal experience to join. A basic interest in business or marketing is enough. This course is simple and clear, and anyone with a desire to grow a business can join. Career Path Once you finish this course, you can pursue roles such as marketing manager, global strategist, brand manager, or business development officer. You can also use these skills to grow your own business or help other companies enter new markets. This course opens doors in international business, trade, and marketing fields. (Learn more about this online course)

Every Wednesday at 18:30 – 19:45 Embark on a journey with the RAD Grade 4 program at M&L School of Performing Arts, where students deepen their ballet and character dance exploration within a curriculum that champions artistic expression and technical refinement. Aligned with a higher educational standard, this level mirrors the progression and complexity expected of students ready to embrace more challenging aspects of ballet. Set to an eclectic mix of music that enriches the ballet experience, our Grade 4 classes are designed to advance students’ technical skills, musicality, and performance artistry. As part of this curriculum, students engage in a sophisticated exploration of ballet that encourages them to express themselves with greater confidence and complexity. Through a blend of traditional and character dance, learners are motivated to refine their understanding of ballet, finding a profound sense of achievement and joy in their evolving capabilities. At this pivotal grade, character work becomes more intricate, introducing students to new cultural dances that enhance their technical repertoire and broaden their appreciation for the diversity of dance traditions. This expansion of knowledge and skill not only equips students with a richer set of technical abilities but also fosters a deep appreciation for the art of dance, guiding them toward a path of lifelong engagement and accomplishment in ballet. Why RAD Grade 4 Ballet Lessons Are Key for Your Child’s Development: Physical Fitness: Focused on improving flexibility, strength, and coordination, ballet at this level offers a rigorous approach to physical health and technical agility. Elevated Self-Expression and Confidence: As students master more complex dance sequences, they experience enhanced self-expression and a significant boost in self-confidence. Increased Discipline and Focus: The complexity of Grade 4 routines demands a higher level of discipline, concentration, and attention to detail, preparing students for success in all areas of life. Deepened Musical Appreciation: With a diverse musical selection, students deepen their understanding of rhythm and musicality, enriching their overall dance experience. Fulfillment in Movement Mastery: Emphasizing the precision and elegance of ballet, our curriculum ensures that students find fulfillment in the mastery of each movement. Enhanced Social and Leadership Skills: Group ballet classes encourage not only social interaction but also leadership and teamwork skills, as students often work together to perfect routines. Cultural Exploration and Appreciation: Incorporating a wider array of character dances, Grade 4 enriches students’ cultural knowledge and appreciation for the global dance community. Superior Coordination and Posture: This grade focuses on refining coordination and posture, essential for the development of a poised and graceful dancer. Life Skills for Future Success: Ballet at this level teaches resilience, time management, and goal-setting, equipping students with skills vital for future academic and personal success. Preparation for Ballet Studies: Setting a strong foundation for higher levels of dance education, Grade 4 prepares students for continued growth and achievement in ballet and beyond. Why M&L School of Performing Arts Is Your Choice for Grade 4 Ballet: Choosing M&L School of Performing Arts for Grade 4 ballet means joining a community that is deeply committed to fostering artistic excellence and personal growth. Inspired by our foundational love for dance and music, we provide a supportive environment where students are encouraged to push their boundaries, explore their artistic potential, and celebrate their progress. Here, learners find not just technical training but a nurturing space that honors their journey towards becoming accomplished dancers. Enroll your child in our RAD Grade 4 ballet program, and witness their transformation into confident, expressive, and technically skilled artists. Become part of our story at M&L School of Performing Arts, where every dancer’s dream is nurtured with passion, dedication, and a deep commitment to the art of ballet. Book first lesson here: https://mandlschoolofperformingarts.com/book-first-lesson/

Join us for a round table discussion with Ginger Gregory, CHRO. Think Broadly: How do we create time and space for White Space thinking? As part of the UKI Wellbeing day we’re inviting everyone to participate in one of a series of roundtable focus groups hosted by HR and Ginger Gregory, our CHRO. These sessions are current organisational challenges designed to foster open dialogue, enhance collaboration, and gather your valuable insights. This is an opportunity to connect, share experiences, and contribute meaningfully to our organisation.

Every Wednesday at 16:05 – 16:40 (Newmarket Academy) or Every Saturday at 8:45 – 9:20 or 10:00 – 10:35 (Exning Community Church Hall) The piano is one of the most popular instruments among all western instruments. At M&L Music School we equip our piano players with all the necessary skills to play different styles of music using good technique. From beginners to grade 8 level (grade 5 is a level that would be enough to gain an A in a GCSE solo instrumental assessment). Piano Group Lessons are an encouraging and challenging environment that can be highly motivational. Learning and playing the piano in a group allows students to practice and perform in front of other people while building confidence. Our piano classes consist of learning pieces using notated music and by ear; scales; sight-reading; aural and technique exercises. We can prepare students to take Trinity guildhall grades, ABRSM, and Rock School piano or keyboard exams as well as performances. Book first lesson here: https://mandlschoolofperformingarts.com/book-first-lesson/

Welcome to Refashion My Town’s upcycled Denim Design competition! Refashion My Town is a social enterprise based in Chippenham. Our mission is to help and encourage young people to make a positive social and environmental impact through fashion. Our goal is to highlight the impact that fast fashion has on the environment and while doing so, we aim to help young people reduce, reuse, refashion and mend more. And what better way to start is by participating and joining our Upcycled Denim Design Competition!  Why Denim? Denim has become an integral part of everyday life, but it wasn’t always like that. Denim was long known to be worn by working class individuals such as miners, railroad workers and even labourers, before booming into a fashion trend that had not ceased to stop. Now you see denim worn by nearly everyone across the globe due to its easy and comfortable wear. However, denim has done more than become a global fashion trend, it has also contributed to the slow destruction of the environment. Most demin products are made with an overwhelmingly large number of dyes that are highly toxic and damaging. Denim also relies on cotton that needs lots of water and pesticides to grow. Pesticides are harmful to human health and can become an environmental risk but that is just one part of the problem. The production of one pair of jeans could require up to 80 gallons of water which is around 360 litres. This is a lot! This is why here at Refashion my Town, we want young people to reduce, reuse, refashion and mend more to combat the issues the fashion industry has on society and environment. Our upcycled Denim design competition is open to 14-18 year olds on Friday 22nd April 2022 and submissions will close on Monday 5th September 2022. This competition requires you to EITHER:  A. A 3-minute video explaining the concept, inspiration, and idea of your upcycled denim design. We would like to see a mock-up of your design within your presentation, as well as before and after of the material used. You can also include a completed final product or garment but this is optional.  Or B. 1 x A3 sheet with design concept 1 x A3 sheet with design development 1 x A3 sheet with final design including before and after Mock-up of final design ( Final product - optional ).  Please note: this is a design ( NOT sewing ) competition, so entries will mainly be judged based on creative flair and out of the box thinking, rather than technical sewing skills. So play and have fun developing your ideas. There will be FIVE judges of the competition:  • Liz Alstrom - Mayor of Chippenham • Rachel Sheila Kan - Founder, Circular earth  • Yvonne Skelton - Head of textiles, Bath College • Melissa Barnett - Curator, Chippenham Museum  • Tricia Morris - Mending and Upcycling Expert, Morrissews. All entrants have access to materials and trimmings from Refashion My Town. Refashion My Town will also have FREE drop-in sessions every Friday at 3.30 - 5 pm, starting 29th April, to help entrants develop their ideas and if necessary, learn new skills to complete their entries. 

Every Wednesday at 17:30 – 18:30 (The Stable) or Every Saturday at 11:55 – 12:55 (Exning Community Church Hall) Step into our Grade 1 ballet class at M & L School of Performing Arts, where budding ballet enthusiasts aged 7 and older are invited to deepen their dance journey. This class is a vibrant exploration of the Royal Academy of Dance (RAD) Ballet curriculum, meticulously designed to enhance technical skill, musicality, and the pure joy of performance across a spectrum of dance styles. Here, students are welcomed into a world where each plié and pirouette is more than a movement—it’s a step towards mastering the art of ballet. Our expert instructors are committed to cultivating each student’s physical fitness, timing, rhythm, and ability to interpret music through dance. With a focus on technique and performance, we prepare our dancers for the exciting opportunity of optional examinations and class awards, fostering a sense of achievement and growth. Joining our Grade 1 ballet class means your child will not only find a fulfilling physical outlet in ballet but will also engage in artistic expression, building bonds with a community of young dance lovers. Enroll today and watch your child’s passion for ballet blossom in a nurturing, inspiring setting. Why Ballet Lessons Are a Leap Forward for Kids Aged 7+ Years: Refined Motor Skills and Coordination: Ballet’s detailed movements refine motor skills, improving balance and coordination. Discipline and Focus: Learning choreography requires discipline, enhancing focus and attention to detail. Physical Fitness: Ballet is a holistic exercise, promoting flexibility, strength, and a healthy lifestyle. Self-Expression and Confidence: Ballet serves as a creative outlet for emotions, with performance opportunities boosting self-esteem. Artistic Appreciation: Children grow a profound appreciation for the arts, enriching their emotional and cultural understanding. Social Interaction: Classes provide a space for friendship and teamwork, vital for social development. Cultural Awareness: Ballet introduces children to diverse cultures and histories, broadening their worldview. Enhanced Posture and Grace: Essential ballet principles teach poise and elegance in movement. Mental Agility: Memorizing routines and understanding dance terms sharpen cognitive abilities. Goal Setting and Achievement: Working towards exams and performances teaches the value of setting and achieving goals. Life Skills: Ballet encourages perseverance, time management, and a strong work ethic, skills valuable beyond the dance studio. Long-Lasting Passion: Ballet often ignites a lifelong love for the arts, with potential pathways to future careers in dance. Why M&L School of Performing Arts Stands Out: M & L School of Performing Arts isn’t just about learning ballet; it’s about embracing a dream sparked by the pure joy and innate dance passion of a child. Founded by Martin and Lwena, our school’s journey from musical performances to ballet teaching reflects a profound commitment to sharing the magic of ballet with young minds. Lwena, inspired by their daughter and certified by the Royal Academy of Dance, alongside Martin, aims to create a legacy of artistic expression and joy in dance. At our school, your child will dive into a world where ballet lessons are a gateway to self-confidence, discipline, and artistic fulfillment. It’s a place where passion meets dedication, and every dancer’s journey is celebrated. Join us and be part of a story where music and dance continue to inspire generation after generation. Book first lesson here: https://mandlschoolofperformingarts.com/book-first-lesson/

Slinger Signaller Training The aim of the NPORS Slinger Signaller Training or Slinger Signaller Course is to provide both theoretical and practical training in the safe and efficient operation of slinging and moving loads using hand signals or radios Guided by the Lift Supervisor. On successful completion of the slinger and signaller course you will be issued with the NPORS Slinger Signaller trained identity card with or without the CSCS Logo or testing can be carried out on your site nationwide or at our training centre in Gloucestershire NPORS Slinger Signaller Test Book with Confidence at Vally Plant Training At Vally Plant Training, we guarantee unbeatable value with our Slinger And Signaller Test Price Match Promise. When you choose us, you can book with confidence, knowing that we will not be beaten on price. If you find a lower price for the same NPORS Slinger and Signaller Worker Test, we’ll match it—ensuring you receive top-quality training at the best possible rate. Click for our terms and conditions Your skills, our commitment—always at the best price. NPORS Slinger Signaller Experienced Worker Test .This test is for operators who have received some form of training in the past or alternatively has been operating as a Slinger Signaller for a period of time. If you are unsure if you qualify to go down the test route please contact us to discuss this in more detail. This test is held at our test centre in Gloucestershire or at your site nationwide. Discounts are available for multiple bookings Turn your Slinger Signaller red card to blue with our hassle free NVQ, for more information CLICK HERE Slinger Signaller Course Duration Novice: 2 days, maximum of 3 candidates Experienced Worker Test: 1 day test only, maximum of 6 candidates. Location: Tewkesbury Training Centre At Our Customers Site*: Our instructors travel throughout the UK to deliver the slinger signaller training *Mileage and accommodation charges may apply Certification NPORS Traditional card – lasts for 5 years and is mainly accepted with housebuilders, utilities, port and marine as proof of competence OR NPORS card with CSCS logo – accepted by all major building contractor’s. The initial card is the RED trained operator card which lasts for 2 years and can be upgraded to BLUE competent operator card further to completion of relevant NVQ. CSCS Health & Safety Test If you require the NPORS Slingers Red operator card with the CSCS logo on then you must have completed the operatives health and safety test within the last two years. In house certificates: suitable as proof of operator competence accepted for insurance and HSE compliance. Slinger Signaller Course Contents: A Slinger Signaller course typically covers a range of topics related to the safe operation of lifting equipment and the signalling procedures involved in crane and lifting operations. While specific course contents may vary depending on the training provider and the regulations of the region, here’s a general outline of what will be included: 1. Introduction to Lifting Operations: Overview of lifting equipment and machinery. Importance of safe lifting operations. Legal and regulatory requirements for lifting operations, LOLLER, PUWER and BS 7121. 2. Roles and Responsibilities of Slinger and Signaller: Duties of the slinger signaller. Understanding the roles of other personnel involved in lifting operations (crane operator, banksman, etc.). Importance of effective communication and coordination. 3. Health and Safety: Risk assessment and hazard identification. Personal protective equipment (PPE) requirements. Safe working practices around lifting equipment and machinery. 4. Lifting Equipment and Accessories: Types of lifting equipment (cranes, hoists, slings, etc.). Inspection and maintenance requirements for lifting gear. Proper selection and use of lifting accessories. 5. Signals and Communication: Standard hand signals for crane operations. Radio communication procedures between Crane Driver & The Slinger and Signaller. Clear and effective communication techniques. 6. Load Identification and Weight Estimation: Methods for identifying loads and determining their weights. Estimating centre of gravity and load stability. 7. Slinging Techniques: Types of slings and their applications. Correct methods for attaching and securing loads. Precautions for different types of loads (e.g., fragile, hazardous). 8. Lifting Operations Planning: Pre-lift checks and planning considerations. Site-specific factors affecting lifting operations (e.g., terrain, weather). Emergency procedures and contingency planning. 9. Practical Exercises and Demonstrations: Hands-on training with lifting equipment and machinery. Practice sessions for signalling and communication. Simulation of real-world lifting scenarios. 10. Assessment and Certification: Written tests to assess theoretical knowledge. Practical assessments of signalling and slinging skills. Certification upon successful completion of the course. It’s essential for the Slinger Signaller Course to provide a balance of theoretical knowledge and practical skills to ensure that participants can effectively carry out their duties as slinger signallers in various lifting operations. Additionally, the course should emphasise the importance of safety and adherence to regulations throughout all aspects of lifting operations. Slinger Signaller Training Available 7 days a week to suit your business requirements. VPT have a team of friendly and approachable instructors, who have a wealth of knowledge of the Slinger Signaller and the construction industry We have our own training centre conveniently located close to the M5 junction 9, In Tewkesbury. With its own purpose-built practical training area to simulate an actual working environment as a slinger signaller Our slinger and signaller training and test packages are priced to be competitive. Discounts are available for multiple bookings We can send a fully qualified NPORS slinger Tester to your site nationwide, to reduce the amount of time away from work Other courses: Master the operation of essential machinery with our Lift Supervision Training, Telehandler Training, Cat & Genny Training, Ride-On Road Roller, Scissor Lift, Abrasive Wheel Training, Lorry Loader Training and Telehandler Training. Elevate your skills for safer and more efficient operations in construction and maintenance projects. Enrol today to advance your career prospects in these industries. Location Advantage: NPORS Slinger Signaller Training Near Me For those looking for a “NPORS Slinger Signaller Training near me,” our widespread operations make it convenient for you to access Vally Plant Trainings top-quality training no matter where you are in the UK