1718 Office courses in Cardiff delivered Live Online

Refresh your skills from when you last did your mental health first aid course! How much do you still remember? How comfortable are you approaching someone? Is there more to learn?

Essential self-care for helping professionals New research gives us practical ways to prevent overwhelm or burnout in ourselves and others, manage workplace stress, avoid ‘compassion fatigue’ and much more… Accredited CPD Certificate: 6 hours Length: 1 day (9.15am - 4.00pm GMT) Really interesting and engaging online course with lots of tips to support ourselves and our clientsCOMPLEMENTARY THERAPIST Live Online Training – Join Emily Gajewski on Thursday 11th April 2024 to take some important time out for yourself, or to help those you support. Once you’ve booked your place we will email you confirmation and you will receive details of how to join the Zoom workshop the day before the event. Bonus Recording – the training is recorded, in case anyone experiences technical difficulties on the day, so you will also get a recording for a limited time afterwards to maximise your learning. Can’t make this date? Then please register your interest below – and we’ll email you when a new date is available. To help others effectively, we need to have enough ‘spare capacity’, which means looking after our own wellbeing too – new research shows us how… Why you should take this course When our day-to-day jobs involve continually listening to other people’s emotional difficulties, how do we avoid being overwhelmed by them ourselves or succumbing to compassion fatigue? We are the ‘tool’ of our trade. It could be argued that we have a duty to those we work with to prioritise our own mental health and wellbeing so that we can give them the best possible service. This live online training events shows you how. ‘Burnout’ is commonly defined as a physical and emotional state caused by excessive or overwhelming workplace stress. This is often specifically related to work but of course feelings of burnout can be impacted or compounded by other life events and caring roles too. Even if we know good stress management techniques, this often isn’t enough. Burnout is a very common phenomena in the ‘helping professions’, A 2018 research review paper published in the Journal of Clinical Psychology analysed 30 years of research on this topic, involving 9,000 psychotherapists. Over half of the therapists they sampled reported “moderate-high levels of stress and burnout”. The good news is that burnout, overwhelm and empathy fatigue are not a given of working in roles where we are consistently exposed to others’ emotional pain. New research and insights into ‘buffering’ the impact of this work mean that we can consciously choose to put in safeguards to our own mental wellbeing, whilst also remaining connected and present with our clients. Emily Gajewski’s online course draws on her extensive experience of working as a therapist and clinical supervisor, in the NHS and privately, for over 20 years. Throughout the day she examines the many ways working in the caring professions can impact us personally and gives you a wealth of practical steps you can take to mitigate them. She also covers the most up-to-date guidance on keeping ourselves well and thriving in caring roles and will help you develop a realistic plan for your own continuing wellbeing. Excellent online training…. very insightful and thought provokingHILARY KEARNS, ACUPUNCTURIST What you will learn The latest research on how to prevent burnout in your working life How to identify burnout in ourselves and others – the warning signs you need to look out for Easy, practical steps to protect yourself in stressful work situations How to avoid ‘compassion fatigue’ Evidence based ‘top tips’ for optimal working practices to maintain your own wellbeing The Cycle of Stress – how to ‘work with it’ for optimal health An understanding of vicarious trauma – and how to avoid it Techniques to calm yourself in client sessions when you are ‘triggered’ by something they bring up Understanding the difference between compassion fatigue and empathy fatigue Reducing your own risk of depression when you’re worried about your clients The joy of creating ‘flow’ in our working life Constructive ways to manage difficult feelings that arise as a result of your work Practical techniques for grounding and ‘letting go’ of clients How to safely explore our own areas of vulnerability Useful tips for ongoing stress management What you need to maintain your own mental health How to re-ground yourself if you’re feeling overwhelmed or derailed by a client An opportunity for you to reflect on your own practice and wellbeing, take some time to step back, learn what works for you and how you can create more spare capacity Time to relax, try out techniques and refresh your tools to support your wellbeing and build resilience How to utilise what you’ve learnt to create your own realistic wellbeing plan. Very useful and practical. The term ‘burnout’ is become as over-used as ‘wellbeing’ and ‘stress’. This online course provides clarity on what the term ‘burnout’ means in reality ... with strategies to counter the effectsHEADTEACHER SUPPORT SERVICE COUNSELLOR Course Programme The ‘How to avoid burnout’ live online course starts at 9.15am and runs until 4.00pm. (GMT). 9.15am Join the Zoom meeting 9.30am Understanding Burnout and how to halt the journey towards it 11.00am Comfort break and discussion 11.30am Exploring practical self-care steps that can work for YOU! 1.00pm Lunch break 1.45pm How to manage difficult feelings that arise as a result of our work 2.45pm Comfort break and discussion 3.00pm Creating a plan for your own wellbeing 4.00pm Day ends Who this workshop is suitable for Anyone who works within a role that involves caring for others – including: medical professionals – including GPs and nurses health and social care professionals therapists and mental health workers counsellors educators, teachers professional carers (foster carers and non-paid carers) social workers occupational therapists outreach workers volunteers holistic practitioners etc. This course has been independently accredited by the internationally recognised CPD Standards Office for 6 hours of CPD training. On completion of this training you’ll receive CPD certificates from the College and the CPD Standards Office.

C++ Bootcamp is for coding beginners: You want all the basic stuff, all the advanced stuff and practical experience and get a fantastic job in C++

Exam Technique Training for OISC Level 1 The aim of the Exam Technique Training is to provide participants with a strong body of knowledge of the OISC Level 1 exam. Topics on the course include: Navigating the OISC Exam Resource Book Overview of the Syllabus for the Level 1 OISC Exam OISC competency levels What is an ‘open book’ exam? Practice mock exam questions Exam tips Q&A The course also includes the opportunity to practise a typical question under exam conditions. Following this, there will be time for collective discussion and group feedback. There is a limited capacity of 10 participants on this course so book early to avoid disappointment. The size of the course means that all individuals will have time to ask questions and learn as much as possible about how to prepare for the OISC Level 1 exam. Please note that this is an exam preparation course – not the OISC exam. We provide some of the most comprehensive immigration law training courses across the UK. This course is ideal for anyone who is preparing to take the OISC Level 1 exam. Join over 92% of satisfied customers who found their training with IAS useful and beneficial. You will also be provided with training materials to keep after completing the course.   Course joining links, materials and instructions are sent out 24hours before the course starts. How can I prepare for the OISC Level 1 exam? You can prepare independently to take the OISC Level 1 exam. If you wish to maximise your chances of a successful result, we recommend taking a training course from experienced immigration lawyers. IAS offers OISC training at Level 1, Level 2, and Level 3 and has a strong track record in assisting candidates to successfully take the exam. The OISC Level 1 exam is divided into two parts. The first part consists of multiple-choice questions, while the second part consists of a number of scenario-based questions. This Exam Technique Training course will help you to prepare to take the exam and give you the knowledge and skills you need to be successful. What is included in the OISC Level 1 Syllabus? This half-day course does not cover the full training involved in the OISC Level 1 syllabus. However, some of the topics covered in the course will be relevant. Based on the latest syllabus, published by the Office of the Immigration Services Commissioner in 2013, the OISC Level 1 Training Course covers the following: Analysis of the structures, terminology, ethical practices and frameworks of immigration law Asylum and protection law European Economic Area (EEA) free movement law British naturalisation and British citizenship registration Immigration law for businesses Immigration appeals process and structures of the Asylum and Immigration Tribunal

Revit face to face training customised and bespoke. Online or Face to Face

Microsoft Excel® in Depth: Virtual In-House Training 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

Duration 3 Days 18 CPD hours This course is intended for The audience for this course are data professionals and business intelligence professionals who want to learn how to accurately perform data analysis using Power BI. This course is also targeted toward those individuals who develop reports that visualize data from the data platform technologies that exist on both in the cloud and on-premises. This course covers the various methods and best practices that are in line with business and technical requirements for modeling, visualizing, and analyzing data with Power BI. The course will show how to access and process data from a range of data sources including both relational and non-relational sources. Finally, this course will also discuss how to manage and deploy reports and dashboards for sharing and content distribution. Prerequisites Understanding core data concepts. Knowledge of working with relational data in the cloud. Knowledge of working with non-relational data in the cloud. Knowledge of data analysis and visualization concepts. DP-900T00 Microsoft Azure Data Fundamentals is recommended 1 - Discover data analysis Overview of data analysis Roles in data Tasks of a data analyst 2 - Get started building with Power BI Use Power BI Building blocks of Power BI Tour and use the Power BI service 3 - Get data in Power BI Get data from files Get data from relational data sources Create dynamic reports with parameters Get data from a NoSQL database Get data from online services Select a storage mode Get data from Azure Analysis Services Fix performance issues Resolve data import errors 4 - Clean, transform, and load data in Power BI Shape the initial data Simplify the data structure Evaluate and change column data types Combine multiple tables into a single table Profile data in Power BI Use Advanced Editor to modify M code 5 - Design a semantic model in Power BI Work with tables Create a date table Work with dimensions Define data granularity Work with relationships and cardinality Resolve modeling challenges 6 - Add measures to Power BI Desktop models Create simple measures Create compound measures Create quick measures Compare calculated columns with measures 7 - Add calculated tables and columns to Power BI Desktop models Create calculated columns Learn about row context Choose a technique to add a column 8 - Use DAX time intelligence functions in Power BI Desktop models Use DAX time intelligence functions Additional time intelligence calculations 9 - Optimize a model for performance in Power BI Review performance of measures, relationships, and visuals Use variables to improve performance and troubleshooting Reduce cardinality Optimize DirectQuery models with table level storage Create and manage aggregations 10 - Design Power BI reports Design the analytical report layout Design visually appealing reports Report objects Select report visuals Select report visuals to suit the report layout Format and configure visualizations Work with key performance indicators 11 - Configure Power BI report filters Apply filters to the report structure Apply filters with slicers Design reports with advanced filtering techniques Consumption-time filtering Select report filter techniques Case study - Configure report filters based on feedback 12 - Enhance Power BI report designs for the user experience Design reports to show details Design reports to highlight values Design reports that behave like apps Work with bookmarks Design reports for navigation Work with visual headers Design reports with built-in assistance Tune report performance Optimize reports for mobile use 13 - Perform analytics in Power BI Explore statistical summary Identify outliers with Power BI visuals Group and bin data for analysis Apply clustering techniques Conduct time series analysis Use the Analyze feature Create what-if parameters Use specialized visuals 14 - Create and manage workspaces in Power BI Distribute a report or dashboard Monitor usage and performance Recommend a development life cycle strategy Troubleshoot data by viewing its lineage Configure data protection 15 - Manage semantic models in Power BI Use a Power BI gateway to connect to on-premises data sources Configure a semantic model scheduled refresh Configure incremental refresh settings Manage and promote semantic models Troubleshoot service connectivity Boost performance with query caching (Premium) 16 - Create dashboards in Power BI Configure data alerts Explore data by asking questions Review Quick insights Add a dashboard theme Pin a live report page to a dashboard Configure a real-time dashboard Set mobile view 17 - Implement row-level security Configure row-level security with the static method Configure row-level security with the dynamic method Additional course details: Nexus Humans PL-300T00: Microsoft Power BI Data Analyst 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 PL-300T00: Microsoft Power BI Data Analyst 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.

Microsoft Excel® in Depth: In-House Training 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

Duration 2 Days 12 CPD hours This course is intended for A Dynamics 365 for Finance and Operations Functional Consultant is responsible for performing discovery, capturing requirements, engaging subject matter experts and stakeholders, translating requirements, and configuring the solution and applications. The Functional Consultant implements a solution using out of the box capabilities, codeless extensibility, application and service integrations. Overview This course provides the practical knowledge to Navigate and efficiently use search, filtering and queries Use operational workspaces Work with Business Document Management Work with record templates Integrate Power BI with Dynamics 365 Finance and Operations apps Personalize workspaces Run and analyze security reports Create and use workflow for approval Work with Organization Hierarchy and its purposes. How to use personalization feature Use Data Management workspace Create and use and entity templates Import and export data and manage data by using Office Integration Dynamics 365 Finance and Operations apps include, but are not limited to, Dynamics 365 Finance, Dynamics 365 Supply Chain Management, and Dynamics 365 Supply Chain Management, Manufacturing. This foundational course provides students with the important first steps in automating and modernizing both global financial and supply chain operations. USE COMMON FUNCTIONALITY AND IMPLEMENTATION TOOLS Introduction Identify and use common Dynamics 365 Finance and Operations apps features and functionality Describe use cases for Power Platform apps and services Module Summary CONFIGURE SECURITY, PROCESSES, AND OPTIONS Introduction Implement security Design and create workflows Configure Organization administration features Configure System administration features Module Summary MANAGE DYNAMICS 365 FINANCE AND OPERATION DATA Introduction Manage data in Dynamics 365 Finance and Operations apps Plan a migration strategy Prepare data for migration and migrate data Module Summary VALIDATE AND SUPPORT THE SOLUTION Introduction Test solutions in Dynamics 365 Finance and Operations apps Implement Lifecycle Services tools Module Summary Additional course details: Nexus Humans MB-300T00 Microsoft Dynamics 365: Core Finance and Operations 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 MB-300T00 Microsoft Dynamics 365: Core Finance and Operations 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 insights gained from data analysis are only truly valuable when you can be clearly expressed to other people – bosses, colleagues, clients, customers, or other stakeholders. In this workshop you’ll learn how to turn raw qualitative or quantitative data into a clear visual story through infographics and data visualization. We'll discuss the key principles for planning an effective visual, look at examples of best (and worst) practice, and learn repeatable and practical design techniques for enhancing the story. We'll also give you an overview of useful tools that will help you turn your idea into a finished infographic or data visualization. You could be conjuring up eye-catching slide decks, building effective reports and dashboards, pitching to investors, or presenting persuasive data to your most important customers.  This is a fully interactive online workshop, so be prepared to join discussions and get hands on with building your own visualisations.  Takeaways Be able to evaluate the elements that make an infographic or visualization effective. Learn quick and repeatable visual tricks for ensuring infographics convey a clear message. Understand how to tailor your approach to different audiences and context. Discover a bunch of free tools and resources to help you build your own visualizations. Understand how online, interactive visualizations work and how to create them. Delivery  We deliver our courses over Zoom, to maximise flexibility. The training can be delivered in a single day, or across multiple sessions. All of our courses are live and interactive – every session includes a mix of formal tuition and hands-on exercises. To ensure this is possible, the number of attendees is capped at 16 people.  Tutor Alan Rutter is the founder of Fire Plus Algebra. He is a specialist in communicating complex subjects through data visualisation, writing and design. He teaches for General Assembly and runs in-house training for public sector clients including the Home Office, the Department of Transport, the Biotechnology and Biological Sciences Research Council, the Health Foundation, and numerous local government and emergency services teams. He previously worked with Guardian Masterclasses on curating and delivering new course strands, including developing and teaching their B2B data visualisation courses. He oversaw the iPad edition launches of Wired, GQ, Vanity Fair and Vogue in the UK, and has worked with Condé Nast International as product owner on a bespoke digital asset management system for their 11 global markets.
 Testimonials "Just to say what a great course this was. I have made my first report employing some of the ideas and tools you showed us – to rapturous responses! The next actions are clear for all and they all understood it! Thank you for helping me to organise my data and thoughts, showing how to present the key message up front, and how to keep it simple and focused. Gearing up for another report now!" Kay Anderson | Head of Finance | Mima "We have been using Tableau to display data for some time but knew we could do more to engage our end users. Alan’s training gave us a framework to start thinking about what we wanted to achieve with our visualisations and analysis, and some great tips on how to display information for maximum impact. Alan was an engaging trainer and we found the workshops very energising." Ellen Austin | Senior Data Analyst | London School of Economics