1598 Courses in Cardiff delivered Live Online

Introduction to Design Thinking: In-House Training Innovation is the cornerstone of highly successful companies, especially those that continue to be successful over the years and decades. Design thinking practices fuel this continual innovation, as they are the critical links from inspiration to delivery, concept to showroom floor, and start-up to global business. Design thinking is a structured approach to promoting innovation and creative problem-solving. It is not a new approach. It has been around for centuries, as the art, architecture, and inventions of mankind illustrate. By examining the steps to achieving great design and maximum utility of product, design thinking approaches provide a framework in which to develop new solutions to problems and new products to sell. This highly interactive course is designed to help participants think like designers to generate innovation, and to help teams to produce more innovation and creativity. Since design thinking is based on doing rather than thinking, we participants are challenged to apply the techniques, in the classroom, to create new ideas and solutions to a case study project. What you will Learn At the end of this program, you will be able to: Explain the underlying principles and value of using Design Thinking for innovation Describe the basic concepts of the Stanford Model for Design Thinking Evaluate a set of basic Design Thinking techniques for application to your projects Apply tools, techniques, and skills aligned with the 5 stages of the Stanford Model Drive innovation through Design Thinking at some level in your work environment Foundation Concepts Problems and solutions The Design Thinking difference Design Thinking skills and abilities Design Thinking mindset Design Thinking frameworks Stages of Design Thinking Problems and solutions The Design Thinking difference Design Thinking skills and abilities Design Thinking mindset Design Thinking frameworks General Practices Team formation Visualization Improvisation Personalization Empathize Practices Overview of Empathize techniques Observation Engagement Interviews Define Practices Overview of Define practices Unpacking techniques Defining the customer techniques Integrating the Define experience Ideate Practices Overview of Ideate practices Reusable techniques for the Ideate stage New Ideate techniques to explore Prototype & Test Practices Overview of Prototype practices Examples of prototypes Overview of Testing practices Forms of testing techniques Adopt and Adapt Design Thinking Overview of Design Thinking implementation Design Thinking implementation challenges Success in implementing Design Thinking Summary and Next Steps Workshop summary Next steps: Personal Action Plans

Gain robust techniques for obtaining feedback from end users throughout product design, and learn how to identify new opportunities for design improvement.

Agile is not what you do, Agile is what you become! An introduction to the essentials of Agile Scrum as a delivery method. The same learning objectives as used in central government & public sector digital delivery projects. Agile is not what you do, Agile is what you become! Since 2012, all government departments have been required to use the Agile approach to project management, to build and run new digital services. As you begin your Agile journey, one of your first challenges will be understanding the rules and roles that support Agile delivery, some of the most frequently asked questions are "Which Agile framework is applicable to our business operating model?" or, "Is the Project Manager role equivalent to that of theProduct Owner?" and, "What does a Scrum Master do?" A strong corporate culture not accustomed to the Agile mindset can also be a difficult environment in which to implement Agile methods. In some cases, the company’s culture and practices may reward non-Agile milestones while inadvertently discouraging Agile success. This intensive two-day training course combines PowerPoint presentations, informal discussions and practical exercises to introduce you to Agile Scrum as a Delivery Method, without the impending pressure of having to pass a formal certification examination. Previous experience of Agile delivery is not a pre-requisite to attending this course, although it is assumed delegates have previously attended the Primer course, or have some understanding of Agile Scrum terms and practices. This course, designed by Agile Scrum practitioners and coaches with specialist experience of working on GDS (Government Digital Service) Service Standards compliant government and public sector projects has been accredited by The CPD Certification Service and is now available outside its usual central government and public sector digital delivery setting. Who this course is for Service and Programme Managers If you are a Service Manager or Programm Manager who wants to explore the benefits of transitioning to Agile ways of working and want to understand how your existing business processes and resource landscape will fit into an Agile delivery model, then this course aims to provide you with enough information to enable you to make an informed decision. Career ambitions If you are new to Agile and your intention is to pursue a career either as an Agile Scrum Master or Agile Product Owner, you will hopefully be provided with enough knowledge to enable you to determine which role best suits your Agile career ambitions. Frequently Asked Questions How this course differs from other Agile courses Delegates will learn the 'How', not just the 'What'! This course has been designed by highly experienced Agile practitioners and coaches with specialist real-life experience of working on GDS (Government Digital Service) Service Design Standard projects. Delegates will find that the learning objectives are significantly more detailed than with other Agile courses which only focus on teaching the learning objectives of The Scrum Guide. Delegates must take the certification assessment. No! During enrolment, delegates can opt out of taking the C-ASDM certification assessment. The online Agile Scrum as a Delivery Method – Essentials course quiz is optional Absolutely! Delegates are provided access to the online Agile knowledge quiz which accompanies the Agile Scrum as a Delivery Method – Essentials course. The quiz helps delegates gauge their level of attainment but is entirely optional. Delegates can take the certification assessment without enrolling on the course. Yes! Delegates with existing Agile project delivery experience can choose to take the certification assessment without enrolling on the course. I will receive my certificate as soon as I have completed the course You will initially receive an Assessment Completion report after completing the assessment. The report details the certification status: 'Pass' or 'Fail', and includes information on which questions were answered incorrectly. Your certificate is issued by the CPD Certification Service approximately four-to six-weeks after successfully completing and passing the C-ASDM Certification Assessment. A CPD certification is recognised by employers Yes! CPD certification is recognised by private and public sector employers, and in central government departments as a valuable way to evaluate the skills of an individual, and the quality of the learning activities. Listing your CPD certification as well as the number of CPD Points you have achieved on your CV is essentially showcasing your achievements in continuing your professional development. One CPD Point is equivalent to an hour of training CPD points are units that quantify time, and the quality of learning and development activities. Delegates will earn 3 CPD Points upon successful completion of the C-ASDM Certification Assessment or 13 CPD Points after completing the two-day course. My CPD certificate will expire after three years Your certificate will not expire however, best practice suggests a renewal after three years. You can do this by enrolling on the C-ASDM course to ensure your knowledge of Agile as a Delivery Method is up to date. Service features Two-day Agile Scrum training course The course uses eCommerce and other Business Case examples for context Optional online CPD certification assessment Optional Agile knowledge quiz to help delegates gauge level of attainment Online Retrospective feedback to enable continuous course improvements. Service benefits Delegates will understand the concepts and benefits of Agile Scrum development Scrum team roles and role accountabilities INVEST-compliant User Stories and BDD formatted Acceptance Criteria Agile approach to incremental project delivery Agile artefacts and Agile reports (burn-down & burn-up charts) Agile Events & Scrum rules Comparison: Agile methodologies (Lean, XP, SAFe & Scrum) Use of Kanban for workflow management Government Digital Service (GDS) Service Standards and Service Assessment Be able to communicate the ideals of Agile to stakeholders Service Agenda General knowledge Agile Delivery 101 Scrum process and sprints Applicability of Scrum Agile Manifesto Scrum roles and accountabilities Overview of Scrum roles (Core & Ancillary) Scrum Master role and role responsibilities Scrum Product Owner role and role responsibilities Scrum team Scrum events Sprint Planning Daily Scrums Sprint Reviews Sprint Retrospectives Scrum artefacts Product Backlog Sprint Backlog Increments Scrum Reports Burn-down and Burn-up Charts Scaling Scrum Working with multiple Scrum teams Working with distributed Scrum teams GDS (Government Digital Service) Service Standards Service Assessments Risks and challenges Risks and challenges of transitioning to Agile delivery Frequently asked questions Discussion on frequently asked Agile questions Agile knowledge quiz Examples of the multiple-choice questions in the optional online quiz On-going support Email support No Telephone support No Webchat support No Online support No Community Support Yes! Delegates are offered access to our private online 'Community of Agile Scrum Practitioners'. Delegates who achieve the pass mark for CPD certification are additionally offered access to our private 'Certified Scrum Practitioners’ Guild', a private Slack community of like-minded Agile professionals.

Virtual Agile Teams: In-House Training Agile teams are a must in this world of intense competition, marketing demands, and changing expectations. Global virtual teaming has become a necessity as organizations become increasingly distributed, with suppliers and clients actively engaged in joint projects. Agile Teams now work across geographical, organizational, and cultural boundaries to deliver solutions and services to global users. Distance and differences may amplify the effect of issues and factors that are relatively straightforward for co-located Agile teams. This workshop delivers practical concepts and techniques that participants will start using immediately with their virtual Agile teams. The goal of the course is to enable you to successfully execute your preferred Agile or Scrum methods in a virtual project team environment. What you will Learn At the end of this program, you will be able to: Explain the characteristics of a virtual team and how they differ from a co-located team Build an effective virtual Agile team using a Team Charter approach Develop Release Plans, including prioritizing user stories, with a virtual Agile Team Construct a Sprint plan, including effective user story estimates, virtually Execute a Sprint, including essential Agile or Scrum ceremonies, virtually Conduct effective virtual meetings in an environment supportive of Agile and Scrum methods Foundation Concepts Agile Mindset and Values Agile Benefits and Methods Scrum Overview Co-located vs. Virtual Teams Forming Virtual Agile Teams Exploring Virtual Leadership Focusing on Virtual Agile Leaders Developing a Virtual Agile Team Charter Meeting Team Challenges in a Virtual Environment Planning Releases with a Virtual Agile Team Planning releases overview Estimating user stories Prioritizing user stories Setting release parameters Getting consensus on the release plan Planning a Sprint for a Virtual Project Sprint Planning Overview Confirming Sprint Scope with Virtual Agile Teams Developing a Sprint Delivery Plan for Virtual Agile Teams Running a Sprint in a Virtual Environment Self-organizing a Sprint for a Virtual Agile Team Using Scrum tools in a Virtual Environment Conducting End of Sprint Meetings in a Virtual Environment Iterating as a Virtual Agile Team Creating an Environment for Success Piloting a virtual Agile team Creating an Agile-friendly virtual environment

Course Information This course aims to empower you with the expertise to proficiently navigate process mapping and master the art of crafting Standard Operating Procedures (SOPs) within regulated environments. Whether you're engaged in activities that demand process improvement, continual enhancement, or SOP creation, this course offers invaluable insights tailored to your needs. It caters to individuals tasked with managing, documenting, and implementing processes and SOPs, irrespective of prior experience or skills. Our curriculum does not focus on specific software or approaches, focusing instead on fundamental principles and adaptable concepts applicable across diverse organisational landscapes. Benefits include: Hands-on experience in mapping processes An understanding of how process maps can be used to define, communicate and continually improve complex processes An understanding of best practice for SOPs using of process maps/process flow diagrams and process mind maps to complement text An insight into the preparation of concise and user friendly SOPs. This course is structured to encourage delegates to:  Discuss and develop ideas Develop a practical approach for creating process maps and writing SOPs Understand how to use process maps in SOPs effectively Discuss how process mapping for preparing SOPs can be applied to process improvement for SOPs. Is this course for you? The course is designed for all those with responsibility for managing, documenting and implementing processes and SOPs. It assumes no prior experience or skills. The course does not recommend any specific software or approach, but explores the principles and ideas that can be applied in any organisation. What will you learn? Hands-on experience in mapping processes An understanding of how process maps can be used to define, communicate and continually improve complex processes An understanding of best practice for SOPs using of process maps/process flow diagrams and process mind maps to complement text An insight into the preparation of concise and user friendly SOPs. By the end of the course you will be able to: Create process maps and write clearer more concise SOPs Understand how to use process maps in SOPs effectively Understand how process mapping can be applied to process improvement and better SOPs. Tutors Tutors will be comprised of (click the photos for biographies): Laura Brown Director, Laura Brown Training and Development David Butler VP of Quality, Resolian Programme Please note timings may be subject to alteration. Day 1 09:00 Welcome, Introductions and Course Objectives Why Companies manage by process. 10:00 Exercise 1 - First Steps Mechanisms for process mapping, levels at which it can be applied, and the roles and responsibilities of process owners. 10:30 Exercise 1 - Feedback 10:45 Break 11:00 Mapping Processes The stages involved in mapping processes including how to construct a SIPOC chart. 11:45 Exercise 2 - Mapping A Process A first opportunity to practice your new process mapping skills. 12:30 Exercise 2 - Feedback 13:00 Lunch 14:00 Exercise 3 - Discussion of Options for Format, Structure and Layout What Makes A Good SOP? Discussion of options for format, structure, level of detail of SOPs and the use of process maps for SOP writing. A case study example of a good SOP which uses a flow chart/process map. 14:45 Exercise 3 - Feedback 15:00 Break 15:15 A Case Study example of a good SOP that uses a flow chart / process map 15:30 Exercise 4 Discussion of the content of an SOP using a Process Map 15:35 Exercise 4 - Feedback 15:45 Key Writing Considerations 16:15 Exercise 5 16:45 Exercise 5 - Feedback 17:00 Close of Day Day 2 09:00 Review of Day 1 09:15 Using Metrics Selecting and using metrics to monitor and improve processes. 10:00 Exercise 6 - Practice in Process Mapping Creating Process Maps from multi-source information. 11:00 Break 11:15 Exercise 6 - Feedback 11:45 Common Pitfalls Common problems and tips for good Process Mapping. 12:15 Demonstration of Process Mapping on a PC 12:45 Lunch 13:30 Exercise 7 - Mind Mapping 14:30 Exercise 7 - Feedback 15:00 Break 15:15 Exercise 8 - Using Process Maps to Write an SOP Applying your process mapping skills as part of writing an SOP 15:30 Exercise 8 - Feedback 15:45 Course Review and Follow-up 16:00 Close of Course Extra Information Face-to-face course Course Material Course material will be available in PDF format for delegates attending this course. The advantages of this include: Ability for delegates to keep material on a mobile device Ability to review material at any time pre and post course Environmental benefits – less paper being used per course. The material will be emailed in advance of the course and RQA will not be providing any printed copies of the course notes during the training itself. Delegates wishing to have a hard copy of the notes should print these in advance to bring with them. Alternatively delegates are welcome to bring along their own portable devices to view the material during the training sessions. Remote course Course Material This course will be run completely online. You will receive an email with a link to our online system, which will house your licensed course materials and access to the remote event. Please note this course will run in UK timezone. The advantages of this include: Ability for delegates to keep material on a mobile device Ability to review material at any time pre and post course Environmental benefits – less paper being used per course Access to an online course group to enhance networking. You will need a stable internet connection, a microphone and a webcam. Development Level Learn

Duration 5 Days 30 CPD hours This course is intended for Network designers Network administrators Network engineers Systems engineers Data center engineers Consulting systems engineers Technical solutions architects Field engineers Cisco integrators and partners Server administrator Network manager Overview After taking this course, you should be able to: Implement routing and switching protocols in Data Center environment Implement overlay networks in data center Introduce high-level Cisco Application Centric Infrastructure (Cisco ACI™) concepts and Cisco Virtual Machine manager (VMM) domain integration Describe Cisco Cloud Service and deployment models Implement Fibre Channel fabric Implement Fibre Channel over Ethernet (FCoE) unified fabric Implement security features in data center Implement software management and infrastructure monitoring Implement Cisco UCS Fabric Interconnect and Server abstraction Implement SAN connectivity for Cisco Unified Computing System™ (Cisco UCS) Describe Cisco HyperFlex™ infrastructure concepts and benefits Implement Cisco automation and scripting tools in data center Evaluate automation and orchestration technologies The Implementing and Operating Cisco Data Center Core Technologies (DCCOR) v1.2 course helps you prepare for the Cisco CCNP Data Center and CCIE Data Center certifications for advanced-level data center roles. In this course, you will master the skills and technologies you need to implement data center compute, LAN and SAN infrastructure. You will also learn the essentials of automation and security in data centers. You will gain hands-on experience deploying, securing, operating, and maintaining Cisco data center infrastructure including: Cisco MDS Switches and Cisco Nexus Switches; Cisco Unified Computing System (Cisco UCS) B-Series Blade Servers, and Cisco UCS C-Series Rack Servers. This course also earns you 64 Continuing Education (CE) credits towards recertification. This course, including the self-paced material prepares you to take the exam: 350-601 Implementing Cisco Data Center Core Technologies (DCCOR) This course will help you: Gain experience implementing, securing and automating network, compute, and storage infrastructure Gain knowledge and skills through Cisco?s unique combination of lessons and hands-on practice using enterprise-grade Cisco learning technologies, data center equipment, and software Qualify for professional and expert-level job roles in the high-demand area of enterprise-class data center environments Earn 64 CE credits toward recertification This course will help you prepare to take the 350-601 DCCOR exam. This exam tests your knowledge of implementing core data center technologies including network, compute, storage network, automation, and security. After you pass 350-601 DCCOR: You earn the Cisco Certified Specialist - Data Center Core certification and you satisfy the core requirement for these certifications: CCNP Data Center CCIE Data Center Implementing Data Center Switching Protocols* Spanning Tree Protocol Port Channels Overview Implementing First-Hop Redundancy Protocols* Hot Standby Router Protocol (HSRP) Overview Virtual Router Redundancy Protocol (VRRP) Overview Implementing Routing in Data Center* Open Shortest Path First (OSPF) v2 and Open Settlement Protocol (OSP) v3 Border Gateway Protocol Implementing Multicast in Data Center* IP Multicast in Data Center Networks Internet Group Management Protocol (IGMP) and Multicast Listener Discovery (MLD) Implementing Data Center Overlay Protocols Cisco Overlay Transport Virtualization Virtual Extensible LAN Implementing Network Infrastructure Security* User Accounts and Role Based Access Control (RBAC) Authentication, Authorization, and Accounting (AAA) and SSH on Cisco NX-OS Describing Cisco Application-Centric Infrastructure Cisco ACI Overview, Initialization, and Discovery Cisco ACI Management Describing Cisco ACI Building Blocks and VMM Domain Integration Tenant-Based Components Cisco ACI Endpoints and Endpoint Groups (EPG) Describing Packet Flow in Data Center Network* Data Center Traffic Flows Packet Flow in Cisco Nexus Switches Describing Cisco Cloud Service and Deployment Models Cloud Architectures Cloud Deployment Models Describing Data Center Network Infrastructure Management, Maintenance, and Operations* Time Synchronization Network Configuration Management Explaining Cisco Network Assurance Concepts* Need for Network Assurance Cisco Streaming Telemetry Overview Implementing Fibre Channel Fabric Fibre Channel Basics Virtual Storage Area Network (VSAN) Overview Implementing Storage Infrastructure Services Distributed Device Aliases Zoning Implementing FCoE Unified Fabric Fibre Channel over Ethernet Describing FCoE Implementing Storage Infrastructure Security* User Accounts and RBAC Authentication, Authorization, and Accounting Describing Data Center Storage Infrastructure Maintenance and Operations* Time Synchronization Software Installation and Upgrade Describing Cisco UCS Server Form Factors* Cisco UCS B-Series Blade Servers Cisco UCS C-Series Rack Servers Implementing Cisco Unified Computing Network Connectivity Cisco UCS Fabric Interconnect Cisco UCS B-Series Connectivity Implementing Cisco Unified Computing Server Abstraction Identity Abstraction Service Profile Templates Implementing Cisco Unified Computing SAN Connectivity iSCSI Overview Fibre Channel Overview Implementing Unified Computing Security User Accounts and RBAC Options for Authentication Introducing Cisco HyperFlex Systems* Hyper converged and Integrated Systems Overview Cisco HyperFlex Solution Describing Data Center Unified Computing Management, Maintenance, and Operations* Compute Configuration Management Software Updates Implementing Cisco Data Center Automation and Scripting Tools* Cisco NX-OS

Duration 5 Days 30 CPD hours This course is intended for Network designers Network administrators Network engineers Systems engineers Data center engineers Consulting systems engineers Technical solutions architects Field engineers Cisco integrators and partners Server administrator Network manager Overview After taking this course, you should be able to: Implement routing and switching protocols in Data Center environment Implement overlay networks in data center Introduce high-level Cisco Application Centric Infrastructure (Cisco ACI™) concepts and Cisco Virtual Machine manager (VMM) domain integration Describe Cisco Cloud Service and deployment models Implement Fibre Channel fabric Implement Fibre Channel over Ethernet (FCoE) unified fabric Implement security features in data center Implement software management and infrastructure monitoring Implement Cisco UCS Fabric Interconnect and Server abstraction Implement SAN connectivity for Cisco Unified Computing System™ (Cisco UCS) Describe Cisco HyperFlex™ infrastructure concepts and benefits Implement Cisco automation and scripting tools in data center Evaluate automation and orchestration technologies This course helps you prepare for the CiscoÿCCNPÿData Center and CCIEÿData Center certifications. In this course, you will master the skills and technologies you need to implement data center compute, LAN and SAN infrastructure. You will also learn the essentials of automation and security in data centers. You will gain hands-on experience deploying, securing, operating, and maintaining Cisco data center. Implementing Data Center Switching Protocols* Spanning Tree Protocol Port Channels Overview Implementing First-Hop Redundancy Protocols* Hot Standby Router Protocol (HSRP) Overview Virtual Router Redundancy Protocol (VRRP) Overview Implementing Routing in Data Center* Open Shortest Path First (OSPF) v2 and Open Settlement Protocol (OSP) v3 Border Gateway Protocol Implementing Multicast in Data Center* IP Multicast in Data Center Networks Internet Group Management Protocol (IGMP) and Multicast Listener Discovery (MLD) Implementing Data Center Overlay Protocols Cisco Overlay Transport Virtualization Virtual Extensible LAN Implementing Network Infrastructure Security* User Accounts and Role Based Access Control (RBAC) Authentication, Authorization, and Accounting (AAA) and SSH on Cisco NX-OS Describing Cisco Application-Centric Infrastructure Cisco ACI Overview, Initialization, and Discovery Cisco ACI Management Describing Cisco ACI Building Blocks and VMM Domain Integration Tenant-Based Components Cisco ACI Endpoints and Endpoint Groups (EPG) Describing Packet Flow in Data Center Network* Data Center Traffic Flows Packet Flow in Cisco Nexus Switches Describing Cisco Cloud Service and Deployment Models Cloud Architectures Cloud Deployment Models Describing Data Center Network Infrastructure Management, Maintenance, and Operations* Time Synchronization Network Configuration Management Explaining Cisco Network Assurance Concepts* Need for Network Assurance Cisco Streaming Telemetry Overview Implementing Fibre Channel Fabric Fibre Channel Basics Virtual Storage Area Network (VSAN) Overview Implementing Storage Infrastructure Services Distributed Device Aliases Zoning Implementing FCoE Unified Fabric Fibre Channel over Ethernet Describing FCoE Implementing Storage Infrastructure Security* User Accounts and RBAC Authentication, Authorization, and Accounting Describing Data Center Storage Infrastructure Maintenance and Operations* Time Synchronization Software Installation and Upgrade Describing Cisco UCS Server Form Factors* Cisco UCS B-Series Blade Servers Cisco UCS C-Series Rack Servers Implementing Cisco Unified Computing Network Connectivity Cisco UCS Fabric Interconnect Cisco UCS B-Series Connectivity Implementing Cisco Unified Computing Server Abstraction Identity Abstraction Service Profile Templates Implementing Cisco Unified Computing SAN Connectivity iSCSI Overview Fibre Channel Overview Implementing Unified Computing Security User Accounts and RBAC Options for Authentication Introducing Cisco HyperFlex Systems* Hyper converged and Integrated Systems Overview Cisco HyperFlex Solution Describing Data Center Unified Computing Management, Maintenance, and Operations* Compute Configuration Management Software Updates Implementing Cisco Data Center Automation and Scripting Tools* Cisco NX-OS Additional course details: Nexus Humans Cisco Implementing and Operating Cisco Data Center Core Technologies (DCCOR) v1.2 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 Cisco Implementing and Operating Cisco Data Center Core Technologies (DCCOR) v1.2 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.

The main subject areas of the course are: Controlling the health risks of asbestos. Sample handling and waste disposal. Identification of asbestos by PLM. Gravimetric quantification of asbestos-containing materials. Discrimination and quantification of free fibres by dispersion and PCM. Analysis of soils - practical application.

Enhance your skills and learn how to use a range of advanced formulas and functions to manage and extract data more efficiently. There are some great ones here that will save a lot of time. Course overview Duration: 1 day (6.5 hours) Our Excel Module 4 – Advanced Formulas and Functions course looks at some of the more advanced functions of Excel that can be used to manipulate and extract data. This is an intensive one-day course and designed for experienced users of Excel. Participants should be confident in creating and using Excel and be able to build simple formula before attending. Objectives By the end of the course you will be able to: Use a range of Text functions to manage text data Create and use different types of date and time functions Work with rounding functions Use logical statements Build nested formula Use SUMIF, COUNTIF and AVERAGEIF Cross reference data from other worksheets using LOOKUP, INDEX and MATCH functions Use IS functions and IFERROR to test cell values Content Working with text Splitting text into multiple cells Merging data into one cell Extracting data using text functions Tidying data Working with dates and times Formatting dates and times Date and time functions Calculating date and time differences Using functions to round numbers up and down ROUND ROUNDUP ROUNDDOWN CEILING FLOOR Use lookup functions Lookup functions Creating a lookup table Range naming Using VLOOKUP Using HLOOKUP Using INDEX and MATCH Working with logical statements Creating an IF statement Using the AND plus OR functions Nesting functions Calculating values based on given criteria SUMIF(S) COUNTIF(S) AVERAGEIF(S) Using IS and IFERROR and test cell values ISBLANK ISNUMBER ISTEXT ISERROR IFERROR

Bunnyfoot were the pioneers and are now one of the leading providers of the Certified Professional for Usability and User Experience – Foundation Level (CPUX-F) in the United Kingdom. Created in association with the international UXQB, this professional 3-day UX certification programme covers user experience methods and theories – and is independently assessed/certified.