1529 Courses in Cardiff delivered Live Online

Following on from the Macros course look at how you can write your own Visual Basic code within Excel to fully automate tasks and save time. Course overview Duration: 2 days (13 hours) Our VBA in Excel course is an introduction to using the Visual Basic for Applications language for programming in Excel. It looks at structures, syntax and coding standards. This course is designed for existing experienced users of Excel who can record and run macros and those who have dabbled in VBA but would like some formal training and help to put some structure to their code. Objectives  By the end of the course you will be able to: Write visual basic procedures Create event and general procedures Use commands from the Excel data model Use statements and functions Use a selection of debugging tools Create and use variables and constants Use different types of loops Create an Excel user form Content The VBA environment Project explorer Excel objects Modules Properties window Code window Code structure Code structure Navigating within your code Adding comments Using WITH Steps to creating a VBA procedure Procedures Sub procedures Event procedures Calling procedures The Excel data model Workbook commands Worksheet commands Excel selection methods Data manipulation commands Debugging Using breakpoints Stepping through code The immediate window The watch window The locals window points Variables and Constants Declaring variables Declaring multiple variables Variable data types Concatenation Scope of variables Constants Declaring constants Using constants Scope of constants Looping Do while loops Do until loops For next loops Conditional Statements IF statement SELECT CASE statement Comparison statements Logical operators Creating a User Form Form layout The control toolbox Naming conventions Adding objects Naming objects Captions Displaying the form Object properties Object properties Setting properties at design time Setting properties at run time Interconnectivity between the user form and Excel Comparing values Transferring information Running code

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 The "Microsoft Excel Complete Course" is designed to equip learners with the essential skills to master Microsoft Excel, one of the most widely used tools in data analysis and business operations. This course covers a comprehensive range of topics, including Excel's new features, formula creation, data visualisation, and workbook management. It offers practical knowledge that will help learners work more efficiently, whether they are managing large datasets, analysing trends, or presenting information. By the end of this course, learners will be confident in using Excel for various business tasks, gaining a strong foundation for further professional development. Course Description This course covers all key aspects of Microsoft Excel, from the basics to advanced techniques. Learners will explore Excel’s new features in the 2019 version, as well as how to perform calculations, modify worksheets, and apply formatting. The course delves into functions, lists, and data analysis tools, including PivotTables and charts. Learners will also learn how to work with multiple worksheets and workbooks, use lookup functions, and automate workbook functionality. With a focus on essential Excel tools and techniques, learners will gain the ability to efficiently manage and analyse data for business or personal use. Course Modules Module 01: Microsoft Excel 2019 New Features Module 02: Getting Started with Microsoft Office Excel Module 03: Performing Calculations Module 04: Modifying a Worksheet Module 05: Formatting a Worksheet Module 06: Printing Workbooks Module 07: Managing Workbooks Module 08: Working with Functions Module 09: Working with Lists Module 10: Analyzing Data Module 11: Visualizing Data with Charts Module 12: Using PivotTables and PivotCharts Module 13: Working with Multiple Worksheets and Workbooks Module 14: Using Lookup Functions and Formula Auditing Module 15: Sharing and Protecting Workbooks Module 16: Automating Workbook Functionality Module 17: Creating Sparklines and Mapping Data Module 18: Forecasting Data (See full curriculum) Who is this course for? Individuals seeking to improve their data management and analysis skills. Professionals aiming to enhance their productivity in Excel for business applications. Beginners with an interest in data analysis or office administration. Anyone looking to build a strong foundation in Excel for career advancement. Career Path Data Analyst Financial Analyst Office Administrator Project Manager Business Analyst Operations Manager Administrative Assistant HR Specialist

Course Overview: This course on Decision Making and Critical Thinking offers a comprehensive exploration of how to develop and apply critical thinking skills in both personal and professional contexts. Learners will gain the ability to analyse complex situations, make well-informed decisions, and approach problems with a logical mindset. By the end of this course, participants will have a clear understanding of critical thinking principles, decision-making processes, and how to apply these techniques effectively in various scenarios. The course is designed to enhance problem-solving capabilities and promote more thoughtful, reasoned approaches to decision-making. Course Description: The Decision Making and Critical Thinking course covers a wide range of essential topics, including understanding the key components of critical thinking, identifying and overcoming common barriers, and exploring decision-making strategies. Learners will delve into how to evaluate claims, the benefits of critical thinking, and the practical applications of these skills in real-world situations. With engaging lessons and interactive content, participants will develop the cognitive tools needed to think critically, solve problems, and make decisions that are both informed and objective. Key areas of focus include problem-solving techniques, critical thinking strategies, and the structured decision-making process. Upon completion, learners will be equipped to make more effective decisions and analyse situations with a critical mindset. Course Modules: Module 01: Introduction to Critical Thinking Module 02: Critical Thinking and the Judgment of Claims Module 03: Benefits and Barriers of Critical Thinking Module 04: Importance of Critical Thinking Module 05: Recognising a Critical Thinker Module 06: What Are the Critical Thinking Steps? Module 07: Critical Thinking Strategies Module 08: Problem-Solving Through Critical Thinking Module 09: Decision Making with Critical Thinking (See full curriculum) Who is this course for? Individuals seeking to improve their decision-making skills. Professionals aiming to enhance their critical thinking abilities. Beginners with an interest in logic, problem-solving, and decision-making. Anyone looking to develop a more analytical and structured approach to challenges. Career Path: Analyst roles in business, marketing, and consulting. Leadership positions requiring strategic decision-making. Project management and operations management positions. Careers in education, research, or policy analysis. Roles in human resources, where critical thinking is key to recruitment and development.

Duration 5 Days 30 CPD hours This course is intended for This course is suitable for anyone responsible for configuring, managing or supporting a Veeam Availability Suite v11 environment. This includes Senior Engineers and Architects responsible for creating architectures for Veeam environments. Overview After completing this course, attendees should be able to: Describe Veeam Availability Suite components usage scenarios and relevance to your environment. Effectively manage data availability in on-site, off-site, cloud and hybrid environments. Ensure both Recovery Time Objectives (RTOs) and Recovery Point Objectives (RPOs) are met. Configure Veeam Availability Suite to ensure data is protected effectively. Adapt with an organization's evolving technical and business data protection needs. Ensure recovery is possible, effective, efficient, secure and compliant with business requirements. Provide visibility of the business data assets, reports and dashboards to monitor performance and risks. Design and architect a Veeam solution in a real-world environment Describe best practices, review an existing infrastructure and assess business/project requirements Identify relevant infrastructure metrics and perform component (storage, CPU, memory) quantity sizing Provide implementation and testing guidelines in line with designs Innovatively address design challenges and pain points, matching appropriate Veeam Backup & Replication features with requirements Veeam Certified Architect is the highest level of Veeam technical certifications. Engineers who complete both Veeam Availability Suite v11: Configuration and Management and Veeam Backup & Replication V11: Architecture and Design programs (courses + exams) will be granted with the 'Veeam Certified Architect' (VMCA) title by Veeam. Introduction Veeam Availability Suite v11: Configuration and Management Describe RTOs and RPOs, what they mean for your business, how to manage and monitor performance against them The 3-2-1 Rule and its importance in formulating a successful backup strategy Identify key Veeam Availability Suite components and describe their usage scenarios and deployment types Building backup capabilities Backup methods, the appropriate use cases and impact on underlying file systems Create, modify, optimize and delete backup jobs, including Agents and NAS Backup jobs. Explore different tools and methods to maximize environment performance Ensure efficiency by being able to select appropriate transport modes while being aware of the impact of various backup functions on the infrastructure Building replication capabilities Identify and describe the options available for replication and impacts of using them Create and modify replication jobs, outline considerations to ensure success Introduce the new Continuous Data Protection (CDP) policy Secondary backups Simple vs. advanced backup copy jobs, how to create and modify them using best practices to ensure efficient recovery Discuss using tapes for backups Advanced repository capabilities Ensure repository scalability using a capability such as SOBR on-premises and off-site including integration with cloud storage Ensure compatibility with existing deduplication appliances Introduce the new hardened repository Protecting data in the cloud Review how Veeam can protect the data of a cloud native application Review how Veeam Cloud Connect enables you to take advantage of cloud services built on Veeam Review how Veeam can be used to protect your Office 365 data Restoring from backup Ensure you have the confidence to use the correct restore tool at the right time for restoring VMs, bare metal and individual content such as files and folders Utilize Secure Restore to prevent the restoration of malware Describe how to use Staged Restore to comply with things like General Data Protection Regulation (GDPR) before releasing restores to production Identify, describe and utilize the different explores and instant recovery tools and features Recovery from replica Identify and describe in detail, failover features and the appropriate usage Develop, prepare and test failover plans to ensure recovery Disaster recovery from replica to meet a variety of real-world recovery needs Testing backup and replication Testing backups and replicas to ensure you can recover, what you need, when you need to Configure and setup virtual sandbox environments based on backup, replicas and storage snapshots Veeam Backup Enterprise Manager and Veeam ONE Introduce the concept of monitoring your virtual, physical and cloud environments with Veeam Backup Enterprise Manager and Veeam ONE? Configuration backup Locate, migrate or restore backup configuration Introduction Veeam Backup & Replication v11: Architecture and Design Review the architecture principles Explore what a successful architecture looks like Review Veeam?s architecture methodology Discovery Analyze the existing environment Uncover relevant infrastructure metrics Uncover assumptions and risks Identify complexity in the environment Conceptual design Review scenario and data from discovery phase Identify logical groups of objects that will share resources based on requirements Create a set of detailed tables of business and technical requirements, constraints, assumptions and risks Review infrastructure data with each product component in mind Create high level design and data flow Logical design Match critical components and features of VBR with requirements Create logical groupings Determine location of components and relationship to logical grouping Aggregate totals of component resources needed per logical grouping Calculate component (storage, CPU, memory) quantity sizing Physical/tangible design Convert the logical design into a physical design Physical hardware sizing Create a list of physical Veeam backup components Implementation and Governance Review physical design and implantation plan Review Veeam deployment hardening Describe the architect?s obligations to the implementation team Provide guidance on implementation specifics that relate to the design Validation and Iteration Provide framework for how to test the design Further develop the design according to a modification scenario

Digital Product Management Course Overview: The Digital Product Management course is designed to provide learners with a comprehensive understanding of managing digital products throughout their lifecycle. Covering key areas such as market analysis, strategy development, and product marketing, this course equips learners with essential skills to succeed in the fast-paced digital landscape. It explores core concepts of product management, offering a thorough introduction to the tools and processes involved in delivering successful digital products. Learners will gain the knowledge necessary to effectively manage a digital product from conception to launch, ultimately enhancing their career prospects in digital product management. Course Description: This course dives deep into the intricacies of digital product management, beginning with the basics and progressing through advanced concepts. Learners will explore market research, customer analysis, and strategy formulation to ensure product success. Modules also cover the creation of product roadmaps, understanding different development methodologies, and the use of analytics to measure product performance. Legal considerations and marketing strategies are also key components, offering a well-rounded understanding of the product management process. By the end of the course, learners will have the expertise needed to manage a digital product from ideation to its eventual market entry and beyond. Digital Product Management Curriculum: Module 01: Basics of Digital Product Management Module 02: Understanding Market and Customers Module 03: Strategy Development Module 04: Roadmap Module 05: Development Methodologies Module 06: Analytics and Metrics Module 07: Marketing Module 08: Legal Aspects (See full curriculum) Who is this course for? Individuals seeking to build a career in digital product management. Professionals aiming to enhance their product management skills. Beginners with an interest in managing digital products or services. Those looking to transition into a digital-focused career. Career Path: Digital Product Manager Product Development Manager Digital Marketing Specialist Project Manager in Tech Companies Product Strategist E-commerce Manager

Minute Taking Course Overview: This Minute Taking Course is designed to equip learners with the essential skills needed to effectively capture, organise, and communicate meeting details. The course covers the key elements of minute-taking, from preparation to the final report, and helps learners build confidence in their ability to record decisions and actions. Upon completion, learners will have developed a comprehensive understanding of minute-taking processes, ensuring they can produce accurate, concise, and professional meeting minutes for any organisation or professional setting. Course Description: This course delves into the fundamentals of minute writing, covering everything from preparing for minute-taking to the essential roles and responsibilities of a minute taker. Learners will explore topics such as understanding meeting structures, recording decisions, and action points, and the role of technology in improving minute-taking efficiency. In addition, the course offers tips for improving minute-taking skills, along with building the confidence needed for effective participation in meetings. By the end of the course, learners will have the tools to efficiently document meetings, ensuring clarity and accuracy in every record they create. Minute Taking Course Curriculum: Module 01: Introduction to Minute Writing Module 02: Preparation for Minute Taking Module 03: The Meeting Structure Module 04: Minute Meeting, Decision and Action Module 05: Roles and Responsibility of Minute Taker Module 06: Tips for Minute Taking Module 07: Technology in Minute Taking Module 08: Building Confidence (See full curriculum) Who is this course for? Individuals seeking to enhance their minute-taking skills. Professionals aiming to improve their meeting documentation. Beginners with an interest in administrative support roles. Anyone involved in business meetings or organizational documentation. Career Path: Administrative Assistant Executive Assistant Meeting Coordinator Office Manager Personal Assistant Project Manager Event Coordinator

Day-to-Day Leadership Course Overview: This course on Day-to-Day Leadership equips learners with the essential tools and strategies to effectively lead on a daily basis. Covering key leadership principles and real-world applications, it focuses on enhancing decision-making, communication, and team management. Learners will explore situational leadership, practical models, and adaptable leadership styles that can be applied to diverse organisational settings. The course provides learners with the confidence to implement leadership strategies that foster collaboration, productivity, and team morale in their daily work. Course Description: The Day-to-Day Leadership course delves deeper into various leadership theories, including Situational Leadership, and offers a structured framework for leading teams effectively. Throughout the course, learners will engage with key concepts, including how to adapt leadership styles to different situations, develop key skills for motivating teams, and apply leadership strategies to ensure productivity and engagement. With an emphasis on real-world applications, learners will be guided through practical models and gain valuable insights into team dynamics, communication, and problem-solving. This course is ideal for individuals looking to enhance their leadership capabilities and progress in their professional development. Day-to-Day Leadership Curriculum: Module 01: Introduction to this Course Module 02: Introduction to Situational Leadership Module 03: A Practical Model for Day-to-Day Leadership Module 04: The Skills for Day-to-Day Leadership Styles Module 05: Bonus Content Module 06: Closing Section (See full curriculum) Who is this course for? Individuals seeking to develop leadership capabilities. Professionals aiming to enhance their team management skills. Beginners with an interest in leadership and management. Those interested in improving day-to-day workplace leadership. Career Path: Team Leader Operations Manager Project Manager Department Head Leadership Coach Organisational Development Specialist

Team Building Masterclass Course Overview This Team Building Masterclass provides learners with the knowledge and skills necessary to create high-performing teams in various professional environments. Covering core topics such as communication, team dynamics, and leadership strategies, this course offers valuable insights into the qualities that contribute to a successful team. Learners will gain practical tools for managing both in-person and remote teams, along with strategies for overcoming common challenges. By the end of the course, learners will have a clear understanding of how to build cohesive, motivated, and effective teams, enhancing their leadership potential and organisational impact. Course Description The Team Building Masterclass delves into the critical aspects of team success, starting with the key qualities that define high-performing teams. Participants will explore various communication techniques, effective team-building models, and the stages of the team-building process. Special focus is placed on the challenges faced when managing virtual teams, as well as interactive exercises designed to strengthen team bonds. Throughout the course, learners will develop a comprehensive understanding of the essential elements of team collaboration and gain strategies for navigating obstacles. This course is ideal for those seeking to improve team cohesion and productivity in their professional roles. Team Building Masterclass Curriculum Module 01: Qualities of a Successful Team Module 02: Communicating Effectively as a Team Module 03: Team Building Models Module 04: Team Building Process Module 05: Challenges of Managing a Virtual Team Module 06: Team Building Exercises (See full curriculum) Who is this course for? Individuals seeking to enhance their leadership skills Professionals aiming to improve team performance Beginners with an interest in team management Managers looking to develop team-building strategies HR professionals and organisational developers Career Path Team Manager Project Manager HR Specialist Organisational Development Consultant Leadership Coach Remote Team Manager

Ace Your Presentations: Public Speaking Masterclass Course Overview In the "Ace Your Presentations: Public Speaking Masterclass," learners will acquire essential skills to enhance their public speaking and presentation abilities. The course covers techniques for confident delivery, structuring engaging presentations, handling stage fright, and communicating effectively with diverse audiences. By the end, learners will have the tools to captivate any audience, whether in a business meeting, conference, or seminar. This course offers practical value for anyone seeking to improve their speaking abilities, with tangible benefits in personal confidence and professional success. Course Description This comprehensive course dives into various aspects of public speaking, including speech structure, voice modulation, body language, and audience engagement. It explores techniques for managing nerves, maintaining focus, and delivering persuasive presentations. Learners will also gain valuable insights into creating compelling visual aids and handling questions with ease. With a focus on clear, effective communication, this course equips participants with the skills needed to influence, inspire, and inform any audience, setting the stage for career advancement and personal growth. Ace Your Presentations: Public Speaking Masterclass Curriculum Module 01: Introduction to Public Speaking Module 02: Building Confidence and Overcoming Nervousness Module 03: Structuring Your Presentation Module 04: Mastering Body Language and Voice Modulation Module 05: Engaging Your Audience and Handling Questions Module 06: Creating Effective Visual Aids and Supporting Materials Module 07: Final Project: Delivering Your Own Presentation (See full curriculum) Who is this course for? Individuals seeking to boost their public speaking confidence Professionals aiming to enhance their communication skills Beginners with an interest in becoming effective presenters Anyone looking to refine their speaking abilities for career advancement Career Path Public Speaker Corporate Trainer Marketing and Sales Professional Event Speaker Communication Consultant