504 Marketing courses in Cardiff delivered Live Online

Course Overview This comprehensive course on "Data Analysis and Forecasting in Excel" provides learners with essential skills to manage, analyse, and visualise data effectively using Excel. Whether you are analysing historical data or forecasting future trends, this course covers key tools such as PivotTables, charts, and lookup functions to make your data work for you. Learners will also gain proficiency in automating tasks and creating dynamic reports, which are invaluable for decision-making processes in various professional settings. By the end of the course, you will have the capability to work with complex data sets, produce insightful reports, and apply forecasting techniques to guide future strategies. Course Description In this course, learners will delve into the full spectrum of data analysis capabilities offered by Excel. Topics include modifying worksheets, working with lists, and using advanced tools such as PivotTables, PivotCharts, and lookup functions. Learners will explore the process of visualising data through charts and sparklines, allowing them to convey complex information in an accessible manner. The course also covers automating workbook functionality and creating mapping data for better analysis. Additionally, learners will gain expertise in forecasting data trends to support strategic planning. By the end of the course, participants will have developed a comprehensive understanding of Excel’s analytical tools, enabling them to manage data with efficiency and precision in various business contexts. Course Modules Module 01: Modifying a Worksheet Module 02: Working with Lists Module 03: Analyzing Data Module 04: Visualizing Data with Charts Module 05: Using PivotTables and PivotCharts Module 06: Working with Multiple Worksheets and Workbooks Module 07: Using Lookup Functions and Formula Auditing Module 08: Automating Workbook Functionality Module 09: Creating Sparklines and Mapping Data Module 10: Forecasting Data (See full curriculum) Who is this course for? Individuals seeking to enhance their Excel data analysis skills. Professionals aiming to improve their forecasting and reporting capabilities. Beginners with an interest in data management and analysis. Those seeking to enhance their proficiency in Excel for career advancement. Career Path Data Analyst Business Analyst Financial Analyst Marketing Analyst Operations Manager Project Manager Excel Specialist in various industries such as finance, marketing, and logistics

Course Overview This course, "Logo Animation Fundamentals," provides a comprehensive introduction to the essential concepts of logo animation. It covers the tools, techniques, and principles needed to create impactful animated logos. Learners will explore animation software, with a focus on the use of effects to bring logos to life, making them engaging and visually striking. By the end of the course, learners will be able to produce high-quality logo animations that can enhance branding efforts across digital platforms. The course also offers valuable insights into industry practices, enabling learners to develop a solid foundation in this creative field. Course Description In this course, learners will delve into the basics of logo animation, starting with an understanding of the key principles of animation. They will explore the process of animating logos using advanced tools such as Adobe After Effects and the Saber plugin. The course also covers the history and evolution of animation, providing context to its current use in modern branding. With each module, learners will enhance their skills in design and animation, enabling them to create dynamic and professional logo animations. This course is ideal for those who wish to incorporate animation into branding or add this valuable skill to their creative toolkit. Learners will gain a thorough understanding of logo animation techniques and develop a portfolio-ready project. Course Modules: Module 01: Introduction Overview of logo animation Importance of logo animation in branding Module 02: Logo Animation Basic principles of animation Tools for animating logos Exploring different animation styles Module 03: Logo Animation Using Saber Introduction to the Saber plugin Step-by-step guide to creating glowing logo effects Integrating advanced effects into logo animation Module 04: Background of Animation The history and evolution of animation The role of animation in modern media Module 05: Outro Key takeaways and next steps for further learning Final thoughts and project wrap-up (See full curriculum) Who is this course for? Individuals seeking to enhance their branding skills with animation. Professionals aiming to expand their expertise in motion graphics and design. Beginners with an interest in animation and digital design. Marketing and branding specialists looking to integrate animated logos into campaigns. Career Path Motion Graphic Designer Animation Specialist Branding Consultant Visual Designer Digital Marketing Professional

Duration 2 Days 12 CPD hours This course is intended for This is an intermediate and beyond level SQL course geared for experienced end users, data scientists, business analysts, application developers and database administrators. Students should have recently attended a basic SQL class or have equivalent experience. Overview This course is approximately 50% hands-on, combining expert lecture, real-world demonstrations and group discussions with machine-based practical labs and exercises. Our engaging instructors and mentors are highly experienced practitioners who bring years of current 'on-the-job' experience into every classroom. Working in a hands-on learning environment led by our expert practitioner, attendees will learn advanced skills needed to: Advanced Query Techniques Manipulating Table Data Using SQL's Data Manipulation Language (DML) User-Defined Functions Stored Procedures Triggers A company?s success hinges on responsible, accurate database management. Organizations rely on highly available data to complete all sorts of tasks, from creating marketing reports and invoicing customers to setting financial goals. Data professionals like analysts, developers and architects are tasked with creating, optimizing, managing and analyzing data from databases ? with little room for error. When databases aren?t built or maintained correctly, it?s easy to mishandle or lose valuable data. Our SQL Programming and Database Training Series provides students with the skills they require to develop, analyze and maintain data and in correctly structured, modern and secure databases. Next Level SQL explores how to identify and use advanced querying techniques to manipulate and index tables. All hands-on work in this course is ANSI SQL compliant and should work with most SQL databases such as Oracle, SQL Server, MySQL, MS Access, Informix, Sybase, or any other ANSI SQL compliant database. Advanced Query Techniques Join inner outer (Left, Right, Full) Subqueries Simple Correlated Using the Exists Operator Tips for Developing Complex Queries Performing Set Operations Aggregating Results Using Group by Creating Temporary Tables Manipulating Table Data Using SQL's Data Manipulation Language (DML) Inserting Data into Tables Updating Existing Data Deleting Records Truncating Tables Implementing Data Integrity with Transactions Beginning Explicit Transactions Committing Transactions Rolling Back Transactions User-Defined Functions Definition and Benefits of Use CREATE FUNCTION Syntax RETURN Clause and the RETURNS Statement Scalar vs. Table Functions Comparison with Stored Procedures Returning Scalar Values and Tables ALTER and DROP FUNCTION Stored Procedures Definition and Benefits of Use CREATE PROCEDURE Syntax Variables and Parameters Control of Program Flow ALTER and DROP PROCEDURE Implementation Differences Triggers Definition and Benefits of Use Alternatives (e.g., Constraints) CREATE TRIGGER Syntax Trigger Types 'Inserted' (or 'NEW') and 'Deleted' (or 'OLD') Tables Event Handling and Trigger Execution ALTER and DROP TRIGGER Additional course details: Nexus Humans Advanced SQL Programming (TTSQL005) training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the Advanced SQL Programming (TTSQL005) course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

Sharing & Networking - Regular giving fundraising programmes. Session aimed at those working in supporter care, individual giving and leadership roles. THIS SESSION WILL NOT BE RECORDED

Graphic Design Using Canva Course Overview: This course introduces learners to the world of graphic design using Canva, a powerful yet accessible design tool. It covers the essentials of graphic design, starting from the basics of working with colour and progressing through intermediate and advanced design techniques. Learners will explore photo-editing tools, graphic layout principles, and how to create professional-quality designs for a variety of purposes. By the end of the course, learners will have developed the skills to create engaging and visually appealing graphics, preparing them for roles in the creative industry. Course Description: The course covers a range of topics that build a solid foundation in graphic design using Canva. Starting with working with Adobe colours online, learners will move on to mastering basic design principles within Canva, before advancing to more complex techniques such as photo editing and designing at a professional level. The course provides learners with the knowledge to create impactful designs for social media, marketing, and branding. Learners will gain valuable skills that are widely used in the design industry, allowing them to apply these techniques in real-world contexts. The course structure is designed to build upon each module, ensuring learners progress at a comfortable pace while enhancing their graphic design abilities. Graphic Design Using Canva Curriculum: Module 01: Working with Adobe Colours Online Module 02: Basic Graphics Design using Canva Module 03: Photo-Editing Basics Module 04: Intermediate to Pro Lessons on Canva Graphic Designs Module 05: Bonus (See full curriculum) Who is this course for? Individuals seeking to enter the graphic design field. Professionals aiming to enhance their creative design skills. Beginners with an interest in digital design and visual communication. Entrepreneurs looking to improve their brand visuals. Career Path Graphic Designer Digital Marketing Specialist Social Media Content Creator Branding Consultant Freelance Designer

Listening Course - The Power of Listening Course Overview The "Listening Course - The Power of Listening" equips learners with essential listening skills, enabling them to effectively engage in conversations and enhance communication. By exploring various listening techniques and understanding the difference between active and passive listening, this course helps individuals sharpen their ability to listen attentively. It will empower learners to build stronger relationships, improve professional communication, and foster a more understanding environment. Upon completion, participants will have developed advanced listening abilities that will enhance both personal and professional interactions. Course Description In this comprehensive course, learners will delve into the different types of listening and explore the distinct approaches of active versus passive listening. Through examining key listening techniques, they will discover ways to improve their skills and recognise the difference between simply hearing and truly listening. Learners will also gain an understanding of the benefits of strong listening skills, such as enhanced decision-making and improved relationships. This course will provide learners with valuable insights into refining their communication, both in everyday conversations and in professional settings, making them more effective listeners. Listening Course - The Power of Listening Curriculum Module 01: Introduction Module 02: Lead Generation with Attraction Marketing for Business Module 03: Types of Listening Module 04: Difference Between Active and Passive Listening Module 05: Difference Between Listening and Hearing Module 06: Ways to Improve Your Listening Skills Module 07: What are Good Listening Skills Module 08: Benefits of Good Listening Skills Module 09: Conclusion (See full curriculum) Who is this course for? Individuals seeking to improve their communication skills. Professionals aiming to enhance their leadership and interpersonal abilities. Beginners with an interest in developing effective listening techniques. Anyone wanting to build stronger relationships through better communication. Career Path Customer Service Representative HR Professional Communications Specialist Sales and Marketing Expert Leadership and Management Roles Mediation and Conflict Resolution Specialist

Freelancer Masterclass Course Overview The "Freelancer Masterclass" offers a comprehensive introduction to building a successful freelance career, focusing on key skills needed for freelancing in the copywriting field. This course equips learners with the tools to confidently start their freelance journey, from understanding the foundational principles of freelance work to mastering the skills required for copywriting. Learners will gain valuable knowledge in handling clients, improving conversion rates, and navigating the nuances of closing deals. By the end of this course, participants will be well-prepared to enter the freelancing world with the essential skills to thrive in a competitive industry. Course Description This course delves deeper into the specific skills and strategies required to succeed as a freelance copywriter. From learning how to get started, understanding the skills required, to effectively communicating with prospects, the course covers a broad spectrum of essential topics. Learners will explore various niches that use copywriters, learn how to make and close deals, and understand how to build a freelance career that stands out. Throughout the course, students will be guided on how to refine their approach to increasing conversion rates and establishing a solid client base, ensuring they are well-equipped to succeed in a dynamic freelance market. Freelancer Masterclass Curriculum Module 01: Getting Started as a Copywriter Module 02: Skills Needed by a Copywriter Module 03: Communicating With Your Prospect to Improve Conversion Rate Module 04: Making and Closing a Deal Module 05: Niches That Use Copywriters Module 06: Becoming a Freelance Copywriter Module 07: Conclusion (See full curriculum) Who is this course for? Individuals seeking to start a freelance career. Professionals aiming to enhance their copywriting skills. Beginners with an interest in copywriting or freelancing. Aspiring freelance copywriters or content creators. Career Path Freelance Copywriter Content Marketing Specialist Digital Marketing Copywriter Brand Strategist Freelance Content Writer

Overcome camera shyness and boost your presentation skills! 🎥 Join our FREE webinar designed to build your confidence and teach practical tips for creating engaging videos. Don’t miss out—register now and step into the spotlight with confidence!

AI Short Video Creation | Turn Long Videos into Engaging Shorts

Course Overview The Adobe Premiere Pro CC course is designed to provide learners with a comprehensive understanding of the software's advanced features, enabling them to create and edit professional-quality videos. Through this course, students will gain the essential skills to work efficiently with various multimedia elements, enhance their video editing techniques, and explore key tools such as colour correction, sound editing, and effects application. This course offers practical insights into working with Adobe Premiere Pro, equipping learners to create high-impact, visually appealing content. Upon completion, students will be proficient in all key aspects of video editing, ready to apply their skills in various industries such as film production, marketing, and online media. Course Description This Adobe Premiere Pro CC course takes an in-depth approach to mastering the video editing software. Learners will explore a range of topics, from setting up the workspace and understanding the interface to advanced techniques such as multi-camera editing, transitions, and colour grading. The course also covers sound editing, the use of effects, and tips for efficient workflows. Students will develop proficiency in editing both short and long-form content, ensuring that they are capable of handling a variety of editing tasks. With a focus on developing professional skills, learners will gain the confidence to use Adobe Premiere Pro CC for a wide array of video production needs. By the end of the course, learners will be well-equipped to produce polished video content for different platforms, making them highly marketable in the creative and media industries. Course Modules Module 01: Introduction to Adobe Premiere Pro CC Module 02: Setting up the Workspace and Interface Module 03: Importing and Organising Media Module 04: Basic Editing Tools and Techniques Module 05: Working with Audio Module 06: Transitions and Effects Module 07: Colour Correction and Grading Module 08: Advanced Video Editing Techniques Module 09: Multi-Camera Editing Module 10: Exporting and Rendering Video Projects Module 11: Working with Titles and Graphics Module 12: Final Project and Portfolio Development (See full curriculum) Who is this course for? Individuals seeking to enhance their video editing skills. Professionals aiming to develop expertise in video production. Beginners with an interest in video editing and media production. Creative individuals interested in improving their technical video editing abilities. Career Path Video Editor Content Creator Multimedia Specialist Film Production Assistant Digital Media Producer Marketing Video Editor Post-production Specialist