7041 Courses

Microsoft Excel® in Depth The goal of this course is to provide a deeper understanding of Excel and its intricacies and a new ability to use it efficiently producing the best solutions for your projects. This practical course provides a solid background of the features of Excel and a deeper understanding of its features, benefits and uses. This is not a beginner's course in Excel. You will learn some advanced features such as Pivot Tables, Charting, Tables, Sorting, Filtering and Functions. The goal of this course is to provide a deeper understanding of Excel and its intricacies and a new ability to use it efficiently producing the best solutions for your projects. What you Will Learn You'll learn how to: Use functions like IF, AVERAGE, SUMIF, SUMIFS, SUMPRODUCT, INDEX, MATCH, CHOOSE, DATE, and many more Create meaningful charts Use pivot tables Use Conditional Formatting, Data Validation Take advantage of using Named ranges, do sorting, filtering, tables Getting Started The building blocks of Excel, built-in functions, will be examined The basics of formatting your data will be examined Shortcuts and data manipulation will be explored Built-in features like those mentioned in the 'What you will learn' section above will be explored in detail Excel Functions - VLOOKUP, IF, INDEX, MATCH, CHOOSE, SUMIF, SUMIFS, SUMPRODUCT, DATE, so many more Using Named ranges, Data Validation, Sorting, and Filtering Learn the Name manager; Learn the difference between local and global names; Ensure correct access to linked workbooks; Ensure data accuracy; Learn how to use cascading data validation (for example, once a user chooses 'cars', another cell allows only Ford, Toyota, etc.); Sorting by more than 3 fields; Filtering by font, pattern, or value; See your data based on things like dates in the 3rd quarter, or fields where quantity x price is greater than some fixed value Conditional formatting and data formatting Make relevant data stand out Isolate highs and lows Make error cells invisible Learn about Data bars, Icon sets, and Color scales Highlight differences between worksheets Learn all the codes in the Format/Number list Using cell Styles Learn all about alignment, protection, borders, colors and more Pivot Tables Learn how to summarize large amounts of data with a few clicks Learn various ways of presenting the data Learn the various pivot table tools Learn how to customize and format a pivot table to suit your needs Learn how to group data Learn how to use the various options to present your data Charts Learn how to create a chart with one keystroke! Learn the 11 types of built-in charts Learn how to create a chart with one keystroke! Learn how to customize the charts to make the information tell the right story Learn how to use the design, layout, and formatting available to charts in Excel 2007 Learn embedded charts versus chart sheets Learn how to use modify all the pieces of a chart Array formulas Learn how to use the most powerful formulas in Excel Learn how to combine many formulas into one compact array-formula Learn the real power of these formulas and why regular formulas can't do the job Learn how to use built-in array formulas, like TREND or TRANSPOSE

Project Leadership Skills: In-House Training To be effective within an organization, project managers need to have a wide variety of skills and abilities. Included among these are: creating and executing on a vision; motivating others; influencing without authority; networking; communicating up, down and laterally; negotiating; managing stakeholders; and managing conflict. This highly interactive workshop focuses on building the soft skills that are critical to leading a team and creating sustainable business change. Participants will gain insight into the social science as well as the brain science behind motivating and empowering others. They will learn and experiment with a variety of influencing strategies and tactics. Working in pairs as well as small groups, they will collaborate with others to brainstorm, share experiences, and apply concepts to everyday challenges. Participants will also discover their personal communication preferences, strengths, and blind spots and will gain insight into how best to communicate with others they find 'difficult.' They will gain insight into managing the people side of change, learning strategies for dealing with each step in the process. Hands-on negotiation and conflict management activities enhance the theoretical learning, grounding it in real life and making it actionable. Interweaving role play with experiential learning and group activities, this course will help participants refine a skill set that is invaluable to their organization, and one that transfers easily across their professional and personal lives. What You Will Learn At the end of this course, you will be able to: Explain the importance of vision in driving motivation and engagement Apply science-based research to better motivate those around you Strategically leverage both personal and positional power to achieve positive project results Determine influencing and networking strategies needed for personal growth Identify ways to problem solve communication challenges when others have different personality styles Connect stakeholder expectations to project success criteria Assess key stakeholders across various dimensions of complexity Apply the four rules of principled negotiation to a real-life conflict situation Recognize key aspects of a physiological response to conflict Utilize selected tools and techniques to 'defuse' an emotional situation Leverage various strategies and tactics to successfully deal with ambiguity at work Getting Started / Foundation Concepts Introductions Course structure, goals, and objectives Beginning a personal action plan Managing Vision and Purpose / Motivating Others Communicating and aligning around vision Tying the present to the future The importance of purpose The art and science of motivation Networking and Influencing Positive politics and project success Types of power within organizations Power and influence Networking best practices Communication The medium and the message Personality and communication styles Communication challenges Stakeholder Management and Negotiation Identifying stakeholders Analyzing stakeholders Negotiation basics Principled negotiation Conflict Management Dynamics of conflict The anatomy of conflict Conflict management approaches and tools Dealing with ambiguity Summary and Next Steps Key concepts review Creating your personal action plan

https://www.transmedia.co.uk/course/figma-introduction Figma is a web-based, graphics editing and user interface design app. You can use it to do all kinds of graphic design work, from wireframing websites, to designing mobile app interfaces, prototyping designs and crafting social media posts. Our two-day course starts with design basics such as typography, colour contrast, fonts, spacing, and more. Then we move on to show you the Figma toolset and how to use it to create text, add images, UI elements, and so on. During the course you will begin working with colours and styles and discover how to add other elements, such as slide-out menus. By the end, you'll be able to create professional mockups and turn your designs into interactive prototypes. All our Figma courses are taught by industry professionals who will share years of their industry experience with you, imparting best practice techniques as well mastery of the tools. Topics covered include Introduction to Figma, Exploring a Figma document, Designing and prototyping, Time-saving techniques and Exporting and sharing designs.

Boost your career and stay relevant with the world’s most recognized Digital Marketing diploma. Continuously updated content means you’ll get cutting-edge digital marketing and soft skills, always. Course Overview Boost your career and stay relevant with the world’s most recognized Digital Marketing diploma. Continuously updated content means you’ll get cutting-edge digital marketing and soft skills, always. Learn Google Ads, social media marketing, SEO and much more. Become a certified digital marketing professional with DMI. Program learning outcomes and content: What Will I Learn? You will be armed with the know-how, the experience and the insights to be able to work and speak with authority in this fast-paced industry. In short, you’ll be a skilled digital marketer, capable of building digital marketing strategies from scratch. Who is the DMI Pro for? • Traditional Marketers or Marketing Executives who want to play a bigger, sharper game • Marketing Managers and Senior Management • Graduates with no plans to wait around • Small Business Owners who want to grow • Career Changers • Entrepreneurs who want to be more entrepreneurial • Whoever needs to create and apply a digital marketing strategy for their organisation Course Content: Introduction to Digital Marketing: What’s it all about? How do you reach customers? How can traditional and digital media work together? What’s the difference between inbound and outbound marketing? This module takes you through the basics, keeping things clear and actionable: • Principles of Digital Marketing • Digital Research • Developing Objectives • Cultural Research • Connecting with the Customer Social Media Marketing: Bring your brand story to life on all the right platforms. Learn how to grow and engage a community around your offering. Define your audience and give them more to care about. There is so much to ‘like’. • Key Social Platforms for Digital Marketing • Growing and Engaging an Audience • Developing Data-Driven Audience and Campaign Insights • Setting up a Social Media Experience for a Business • Creating and Optimising Social Media Campaigns Paid Search (PPC) using Google Ads: Develop Pay-Per Click skills using Google Ads, bid auctions and build your targeting strategy. Optimise campaigns, track conversions, and measure your ROI. • Fundamentals of Paid Search • Search Campaign Management • Paid Search Campaign Measurement • Paid Search Campaign Creation with Google Ads Email Marketing: Your email list is one of your most powerful assets. Learn how to manage and segment your data, test headlines and maximise open rates and ROI. We also cover marketing automation and the importance of data management regulations. • Email Marketing Fundamentals • Email Design • Testing and Optimising an Email Campaign • Tools and Strategy • Creating an Effective Email Campaign • Marketing Automation Analytics with Google Analytics: This module helps you unleash the capability of your data. Discover what your customer wants, likes, needs and does. Understand how they use your website, set up goals and monitor conversions. • Web Analytics Fundamentals • Creating and Configuring a Google Analytics Account • Monitoring Campaigns with Google Analytics Reports • Setting Goals with Google Analytics • Analysing and Recording Google Analytics Data • Using Google Analytics 4 Content Marketing: This module teaches you how to create content that speaks to people, at the right time and via the right channels. Understand what works for you by tracking and measuring performance. • Content Marketing Concepts and Strategy • Developing a Content Marketing Plan • Publishing and Distributing Content • Using Content Research to Find Opportunities • Creating and Curating Content • Metrics and Performance • Establishing Content Intent Search Engine Optimisation (SEO): Search Engine Optimisation is all about getting on that first Google page, staying top of the list and top of mind. Develop keyword strategies, understand the kind of content that attracts users, optimise rankings and then convert visitors to customers. • SEO Fundamentals • Keywords and SEO Content Plan • Measuring SEO Performance • Aligning SEO and Business Objectives • Optimise Organic Search Ranking Display and Video Advertising: Learn how to set up, manage and optimise your YouTube channel. Target, test and develop your use of the Google Display Network and get creative with visual formats. • Fundamentals of Display and Video Advertising • Google Display Network and Video Ad Formats • Creating and Managing a YouTube Channel • Creating Display and Video Campaigns • Targeting Display and Video Campaigns • Measurement and Optimisation • Reporting on Display Campaign Website Optimisation: What makes a winning website? This module gives you the skills to create a simple, well-designed, optimised WordPress site that not only looks good but also delivers for your business. • Web Design and Website Optimisation • Design Principles and Website Copy • Publishing a Basic Website • User-Centered Design and Website Optimisation • Website Metrics and Developing Insight Digital Marketing Strategy: Underneath your digital activity, you need solid objectives. This module helps you to build a clear vision of your strategy, and makes it actionable with budget, channel and media plans, KPIs and more. • Digital Strategy Fundamentals • Setting Strategy Objectives and KPIs • Digital Strategy Research • Developing a Creative Strategy • Executing a Digital Marketing Strategy • Communicating a Digital Marketing Strategy • Forecasting performance DURATION 8-10 Weeks WHATS INCLUDED Course Material Case Study Experienced Lecturer Refreshments Certificate

Barista Skills teaches the essential practical skills needed behind the espresso bar, such as how to set your grinder, make espresso, foam and texture milk for cappuccinos, and create latte art, as well as an exploration of health and safety issues, customer service protocols, and basic business practices. The Barista Skills Intermediate course builds on the concepts and skills introduced in the Foundation course. It is ideal for someone who has barista skills experience and wants to explore how to improve coffee quality and prepare for more complex job functions found in the barista profession. Through this interactive course, learners will gain a deeper understanding of the coffee itself, specifically, the impact of a coffee’s variety, origins and processing methods on flavour; the parameters of coffee quantity, grind texture, water quality, and shot time and their interaction when dialling in a brew recipe; drink construction and taste differences; workflow management and efficiency, sensory aspects of the espresso extraction; milk handling and techniques as well as latte art. In addition to coffee preparation, this course also covers key concepts regarding health and safety, customer service, and basic business practices. A written exam tests Intermediate course knowledge, while a practical exam assesses the learner’s ability in terms of grinder calibration, espresso extraction analysis, latte art skills and drinks construction.

Course Description: The 18th edition course is a 3 day short course aimed at anyone involved in the design, construction and inspection and testing of electrical systems, also a nationally recognised ‘must have’ qualification for companies seeking to recruit electricians. It is intended to introduce the candidate to a working knowledge of the Wiring Regulations along with a brief overview of the Electricity at Work Regulations covering their statutory duties. Previous knowledge of the regulations is not assumed, however, a fundamental knowledge of electrical principles is assumed. Please be aware that the Wiring Regulations course is not designed to teach you every regulation in the book but it will teach you the best practices on how the reference the latest regulations as you would on the job. As such key topics currently covered on the 17th Edition will still be included. We have been delivering Wiring Regulations courses for many years and although it is mainly theory based you cannot beat real training in a real classroom. By training with other people in your class you will benefit from being able to ask relevant questions as well as finding the answers to many questions from your fellow students that you may not have even thought of. The examination is a 2 hour multiple choice, open book PC based examination with instant results. The course cost includes examination entry fees. Focus: You will study the latest standard of the IET wiring regulations, including essential subjects such as safety, selection and erection of electrical equipment. There are 8 key modules and current amendments: Section 1 – Scope, Object and FundamentalsSection 2 – DefinitionsSection 3 – Assessment of general characteristicsSection 4 – Protection for SafetySection 5 – Selection and Erection of equipmentSection 6 – Inspection & TestingSection 7 – Special Installations or locationsSection 8 – Functional Requirements This course does include the latest amendments such as: Electromagnetic Disturbance Surge Protection Medical locations Operating and Maintenance Gangways Arc Fault Detection Devices (AFDDs) Changes to fire safety requirements in chapter 422, covering the design of electrical installations in industrial, commercial and multiple-occupancy homes, as well as new information for ‘protected escape routes’ Protection against over voltages Changes across Part 7: Special Locations This classroom based course will show, teach and perfect you on how to reference and use the book for situations that you will encounter while working in the field.

Level 3 NVQ Diploma in Occupational Work Supervision

MASTERCLASS 8 CPD POINTS 1 DAY INTENSIVE COURSE  ONLINE or IN-CLINIC NOTE! After booking we will contact you for scheduling the exact course date! Courses dates are subject to change due to mentors availability. We will inform you via email if a date becomes available! CLINICAL PRP • Sports medicine • Traumatology • Ophthalmic • Burn trauma • Wound healing –diabetic foot • Skin grafting • Dentistry-sinus lift • Tooth implants.   PRP theory & equipment: Training Online Theory will enable you to understand: Anatomy Vascular Supply, Contraindications Patient consultation Complications Management Post treatment advice Dealing with equipment A certification of training will be provided upon completion of the course. Aesthetic PRP • Skin rejuvenation • Hair restoration • Fat grafting in combination PRP • Post laser •Acne & Rosacea •Acne scar •TissueVolumisation alternative of HA fillers •Aesthetic gynecology /urology.   Plathelet Rich Plasma We will cover pertinent information including mechanism of action, safety and efficacy issues, management and treatment of complications, dilution guidelines, and more. Hands on practical session – skin rejuvenation and hair loss Extraction, Preparation and Dosage Management Injection techniques – face, neck and head (hair loss); also the use of cannula Upon successful completion of the course, you will receive a certificate and title of PRP Certified Practitioner.   MASTER CLASS PRP & PRF During the course we are providing . Taking blood and how to use a Centrifuge . PRP injecting techniques in face neck and décolletage hands. PRP Microneedling using a DERMAPEN. Combination treatment PRP with Mesotherapy. MECHANISM OF ACTION Platelets + Leucocytes form 3D mesh release of GF Chemo attraction and migration of macrophages and stem cells Stem cells proliferates by mitosis Stem cells undergo differentiation process BENEFIT FROM PRP TREATMENT & THERAPYExperience the advantages of PRP treatment and therapy, utilizing autologous blood with natural growth factors for disease-free and hypoallergenic benefits. Boost wound healing by regulating mitosis, proliferation, and differentiation, enhancing tissue with collagen, elastin, and hyaluronic acid. Benefit from improved tissue oxygenation, nutrition flow, and support for procedures like hair transplants, fat transfers, and skin grafts.PRP works effectively in skin rejuvenation, facial resurfacing, microneedling, and combines well with HA, PDO threads, skin boosters, peeling, or CO2 lasers. It also proves beneficial for hair restoration, showing positive results in various protocols for Androgenic alopecia and age-related hair loss.PRP where works .Skin rejuvenation-facial resurfacing.application-injection alone. Microneedling Combination with HA,Combination with PDO threads,Skin boosters , peeling or CO2 lasers Hair restoration, Multiple protocols with positive results Evidence for improvement of: Androgenic alopecia-male and females, “spot hair lost” Improvement of age related hair loss. You need to be medically qualified as a doctor, dentist, nurse, pharmacist or paramedic with full governing body registration and have completed a Foundation Filler Course and to have administered a number of cases. Additional information ATTENDANCE ONLINE (Theory), IN CLINIC (Practice) COURSE LEVEL EXPERT | Masterclass Course

Create a festive copper ornament by forming and weaving wire. It can be embellished with sea glass or beads.

Join us for an exclusive Clinic Day, designed specifically for business owners who are ready to take their growth to the next level. This is your chance to access tailored, one-on-one sessions with top marketing professionals, offering you expert and practical advice and actionable strategies to propel your business forward.