6474 Courses in Strabane delivered Live Online

Learn how to use this powerful tool to import and clean data and create some amazing visuals. Course overview Duration: 2 days (13 hours) Power BI Desktop is a powerful tool for working with your data. It enables you to import multiple data sources and create effective visualisations and reports. This course is an introduction to Power BI to get you started on creating a powerful reporting capability. You should have a good working knowledge of Excel and managing data before attending. Objectives  By the end of the course you will be able to: Import data from multiple data sources Edit and transform data before importing Create reports Create different visualisations Create data models Build data relationships Use the drill down features Create measures Use the Power BI Service Build dashboards Use the mobile app Content Essentials Importing Data Power BI Overview Data sources Importing data Transforming Your Data Editing your data Setting data types Removing columns/rows Choosing columns to keep Setting header rows Splitting columns Creating Reports Creating and saving reports Adding pages Renaming pages Interactivity Refreshing your data Adding Columns Columns from example Custom columns Conditional columns Append Queries Importing folders Setting up and using append queries Creating Chart Visualisations Adding chart elements Choosing chart types Setting properties Setting values, axis and legends Using tooltips Visual filters Setting page and report filters Creating Tables, Cards, Gauges and Maps Adding table elements Adding maps Working with cards Working with matrices KPIs and Gauges Conditional Formatting Setting rules Removing conditional formatting   Working with Data Models Merge Queries Setting up and using merge queries Merging in columns of data Creating a Data Model The data model Multiple data tables Connecting tables Building relationships Relationship types Building visuals from multiple tables Unpivoting Data Working with summary data Unpivoting data Using Hierarchies Using built in hierarchies Drill down Drill up See next level Expand a hierarchy Create a new hierarchy Grouping Grouping text fields Grouping date and number fields Creating Measures DAX functions DAX syntax Creating a new measure Using quick measures Using the PowerBI Service Shared workspaces My workspace Dashboards Reports Datasets Drill down in dashboards Focus mode Using Q&A Refreshing data Using Quick Insights Power BI Mobile App Using the Power BI Mobile App

Discover the powerful schedule and cost risk analysis features of PRA. Course overview Duration: 2 days (13 hours) Our Primavera Risk Analysis course gives a detailed introduction to the schedule and risk analysis features of Primavera Risk Analysis. It shows the powerful features of the tool and give hands on practice throughout the course to ensure you can confidentially put your new skills into practice back in the workplace. This course is designed for new users of Primavera Risk Analysis, and no previous experience is required. You should however be familiar with risk management processes and terminology. Objectives  By the end of the course you will be able to: Import schedules into PRA Add three point estimates onto plans Perform schedule and cost analysis Use templated quick risk Run risk analysis Interpret results from the Risk Histogram and Tornado graph Add task percentiles to a Gantt chart Set up a risk register Add qualitative and quantitative risks Link risk to activities in the plan Create reports Use the Distribution Analyser Content Importing schedules Importing MSP and Primavera Schedules Running import checks Checking schedule integrity Schedule risk analysis 3 point estimating Entering uncertainly Different distributions Using quick risk Updating plan Importing plans with 3 point estimates Cost/Resource uncertainty Resource loadings Creating 3 point cost estimates Resource distributions and escalations Simple cost estimates Templated quick risk Setting up and applying templated quick risk Assessing risk at WBS level Running risk analysis Running risk analysis Interpreting results on the Risk Histogram Setting analysis options Task percentiles Setting task percentile options Including task percentiles on the Gantt chart Tornado graph Creating a Tornado graph Viewing sensitivity Analysing sensitivity against activities Setting up the risk register Setting Schema levels Defining criteria and tolerances Setting up a Risk Breakdown Structure (RBS) Working with manageability and proximity Saving scoring matrices Adding custom fields Exporting data Exporting to Excel, Word and PowerPoint Qualitive risks Setting risk IDs Adding risk cause, description and effect Setting up risk details Entering mitigation actions Quantitative risks Linking risks to activities Adding schedule and cost impacts Defining how multiple risks impact Correlation Migrating your plan Adding mitigation actions to your plan as tasks Linking tasks to mitigation actions Actioning your risk register Progressing risks Importing progressed plans Linking register to progressed plans Risk history The Waterfall chart Saving and reporting Exporting the risk register Running reports Creating new reports Building and comparing risk plans Using the distribution analyser Comparing dates and cost

Expand your VBA knowledge further and learn some of the more advanced coding features. Course overview Duration: 2 days (13 hours) This course is aimed at experienced VBA users or those who have attended our Part 1 course and have started to use the language. Part 2 expands on the huge array of commands and elements of the data model that can be used and looks at building more complex VBA models Objectives  By the end of the course you will be able to: Use comparison operators and system functions Use Arrays Work with ranges Work with the worksheets and workbooks collections and objects Use application objects Use the FileSystemObject Create function procedures Import and save text files Connect to other applications Content Comparison operators Using Comparison operators and functions The LIKE function Wildcards Using SELECT Case System functions The VAL function Case functions Trim functions Text functions Date functions Excel worksheet functions Using Excel functions in VBA Arrays Creating arrays Using arrays Ubound and Lbound Single and multi dimensional arrays Static vs dynamic arrays Working with ranges Creating range objects Passing data between range objects and arrays Using Transpose The Excel object model The object browser Working with collections Collections Creating object variables Setting object variables The For Each . . . Next Loo Sheet collections The worksheets collection The worksheet object The sheets collection Using object Grouping worksheets Using Typename The Workbook collection The workbooks collection Setting workbook variables Application objects Excel default information Display/alerts Screen updating Status bar On Time Using Wait Systems dialog boxes Showing dialog boxes Using dialog boxes Working with files Searching for files and folders The DIR function The FileSystemObject Function procedures Creating functions Adding arguments Calling functions Working with text files Searching for files and folders The DIR function The FileSystemObject Using the FILE and FOLDER collections Sharing data with other applications Early vs Late Binding Setting references to other applications Creating application variables Setting application variables

This course is for learners gain an awareness of the causes and effects and identify signs and symptoms of Epilepsy, lifestyle issues associated with Epilepsy and plan effective levels of care for people.

Learn the skills and mindset to become a business partner, align your expertise with the organisational goals, drive growth, and shape the future of your company. Course overview Duration: 1 day (6.5 hours) This is a highly interactive and practical course which will help you to understand the role of Business Partnering and the key skills needed to be successful in the role. The course is designed specifically to give you an opportunity to explore the role and test a range of techniques to improve your strategic working as well as your influencing and relationship building skills. This course is aimed at individuals who work cross-functionally and with other people to achieve business results and is particularly helpful for those who engage frequently with senior managers and executives. Objectives  By the end of the course you will be able to: Describe the role of Business Partner and the benefit to the business Develop stronger engagement with all internal and external stakeholders Influence without authority Build positive relationships Handle robust conversations Be forward thinking, not reactive Act as a change agent Communicate with confidence and credibility Content Understanding the role of the Business Partner What is Business Partnering from an individual, departmental and business view Using a psychometric test to look at where your strengths are and how you can use them effectively in the role Developing Relationships Creating a powerful first impression. Communication skills Understanding different communication styles Being more proactive in developing key relationships Stakeholder engagement Presenting ideas in a confident and articulate way Understanding and developing trust Connecting with people Networking Influencing and Negotiating Influencing and persuading others Dealing with conflict and difficult conversations Becoming a trusted advisor/Business Partner Advanced questioning skills and techniques to get to the root of a problem Strategic Thinking Develop the mind-set and strategic capability to play a more proactive leading role in the business

Learn effective strategies and leadership skills to thrive in today's remote work landscape. Elevate your team's performance, no matter where they are located. Course overview Duration: 1 day (6.5 hours) Remote teams present a specific set of challenges to their managers. Such challenges include communication, task allocation and performance management. This workshop is designed for managers who run teams that spread over more than one location, nationally or internationally, and who wish to find ways to enhance teamworking in these conditions. Objectives  By the end of the course you will be able to: Identify key actions to take to manage team performance remotely Implement a communications plan for use within the team Allocate tasks to team members to build a culture of teamworking across the different locations Involve your team members in planning team activities Use visits to each location to maximum effect Content Communication to ensure inclusivity How do team members find out the latest news? Identifying what needs to be known by all A team communication plan Effective virtual meetings Manage performance from a distance Principles of Smart Working Involving the team in planning activities Allocating tasks and objectives across the team Identifying areas of expertise Deciding key areas of responsibility per location Identifying, and dealing with, the different levels of performance Maximising time in each location Setting the tone of a visit – from ‘inspection’ to ‘social call’ Considering what team members expect and need from your presence Identifying what needs to be prepared by the team for your visit Making contact with your team members while you are there Action planning Identifying and planning next steps

Gain the insights, tools, and frameworks to make impactful decisions that steer your organisation towards success. Elevate your strategic thinking and drive results Course overview Duration: 1 day (6.5 hours) Strategic decision making is messy, complex and full of uncertainty. These are factors which work against the human mind when it comes to making effective decisions. This course provides delegates with insights into the factors influencing strategic decision making. Using psychometric profiles delegates will learn about their own preferences when making decisions, how to influence others and how to create the ideal conditions for successful strategic decision making. Objectives By the end of the course you will be able to: Explain the challenges of VUCA – Volatility, Uncertainty, Complexity & Ambiguous Use models of Strategic Thinking Understand the impact of perception, bias and judgement in decision making Understand personal preferences and approaches to decision making Speed read other people’s approach to decision making Use decision making models for strategic thinking Apply Mindsets, Skillsets and Toolsets for decision making Content The decision lifestyle - personal preferences Understand the human facts that influence decision making Understanding personal preferences and approaches to decision making Understand the impact of Perception, Bias and judgement in decision making Speed reading others’ approach to decision making Frameworks to provide context for decision making Understand the business factors that influence decision making – VUCA The Cynefin Framework – decision making in complex situations Understanding which business context you operate in – simple, complicated, complex or chaotic Models to improve strategic thinking How to understand yourself better How to improve your decision making How to understand others better How to improve other’s decision making Human centred decision making How to put humans at the centre of your decision making The art of Creative Problem Solving Using Design Thinking to reduce human complexity in decision making

Understand the Mental Toughness model and look at how to improve your mental toughness with the 4c’s. Course overview Duration: 1 day (6.5 hours) Mental toughness is the ability to resist, manage and overcome doubts, worries, concerns and circumstances that prevent you from succeeding, or excelling at a task or towards an objective or a performance outcome that you set out to achieve. Our one day programme can help you to achieve this by using tools and techniques to help you perform under pressure and ensure your wellbeing. Objectives  By the end of the course you will to: Identify the causes of stress and how to prevent them Assess your mental toughness using the MTQ48 measure Use tools and techniques to develop your mental toughness Content Understanding Stress, Pressure and Challenge The causes of stress How stress can manifest itself Threat response The Stress performance curve Stress, challenge and pressure Positive stress Mental Toughness, Stress Management and Resilience Defining stress management, resilience and mental toughness How they differ and how they affect each other Mental Toughness Understanding mental toughness The importance of mental toughness The benefits of developing your mental toughness The 4 Cs of Mental Toughness How we approach Challenge Control our emotions Develop Confidence Create Commitment MTQ48 Profile Understanding your MTQ48 profile Looking at your mental toughness Areas for development Developing Mental Toughness Managing physical energy to deal with stress Developing healthy habits for managing stress Multitasking and the ability to focus Identifying unhelpful thought patterns Positive and pragmatic thinking approaches Managing your approach to change and challenge Ways of developing mental toughness

Learn the skills, knowledge and have the confidence to tackle difficult conversations in a productive way. Course overview Duration: 1 day (6.5 hours) Do you worry about how to give negative feedback or deal with performance issues? Are you concerned about giving bad news? This workshop is designed to give you the skills, knowledge and confidence to tackle these scenarios in a productive way. If you are a people manager, team leader or supervisor looking to make those challenging conversations less stressful and more effective, this workshop is for you. Lots of practical sessions will ensure you have the opportunity to relate your learning to your real life work situations. The one day session will use professional actors in the afternoon so that you can practice handling real-life challenging conversations. Objectives By the end of the course you will be able to: Deal with a wide range of challenging conversations Describe the preferred behavioural style for giving feedback State the most appropriate influencing technique to use in your situations Explain how to give successful constructive feedback Content What are challenging conversations What type of challenging conversations occur? Why do we find them challenging? Communication Practical exercise to demonstrate and act as a refresher of the fundamentals of communication Barriers to communication especially in a difficult discussion Choosing the right behavioural style Refresher of assertiveness and why it is important in this context Practical exercise demonstrating how behaviour breeds behaviour, and the impact of choosing an inappropriate style Steps to using assertive behaviour Influencing Cialdini’s model for influence How to use influencing techniques in handling challenging conversations Practical application Feedback Understanding feedback – positive vs. negative Using the ABCBC model for feedback Using the basics of emotional intelligence to give effective feedback Practical application Practical Activities Professional actors will work with you in small groups in the afternoon to practice real-life challenging conversations.

Unlock the Power of Teams: Elevate your leadership with our Building and Leading Effective Teams course. Learn the art of collaboration, communication, and synergy to create high-performing teams that drive success Course overview Duration: 1 day (6 hours) Everyone works in teams today in one way or another. Whatever we do in the workplace we need to interact with another person or a number of people at various times. It is important that we know how to communicate, how to listen, how to work together and how to overcome conflict when it arises in our workplace. Challenges are often created by a lack of trust, poor conflict handling skills, a lack of shared vision and confusion over roles and responsibilities. This course will help delegates understand how to encourage more productive team working in the workplace. By the end of the course delegates will be able to describe what makes a High Performing Team and realistically assess their current strengths and weaknesses. Delegates will also be able to identify and plan behavioural changes that will improve the team’s performance. The course is experiential based with lots of learning by doing activities, reflecting and discussion. This will allow team members to get to know/improve their knowledge of team colleagues and energise or re-energise teams. Objectives  Know more about their colleagues Be able to describe what makes a high performing team Understand the importance of playing to different strengths and skills Recognise the need for clear and effective communication Content The Importance of Team Work The importance of teamwork The ‘third dimension’ – how working together has the potential to achieve more The dangers of an overly competitive workplace culture Psychological Safety Team Development Models Stages of Team Development Behaviours at each stage Dysfunctional Teams – what does good and bad look like Characteristics of high performing and elite teams Teaming and Leadership Skills Teaming competencies Active Listening Proactive Language Values and Beliefs Building Mental Fitness of Teams Becoming an inspirational leader Establishing a climate of psychological safety Team Challenges The importance of Accountability The Team Charter Smart Teams:Building TrustBuilding CollaborationOvercoming ConflictGaining CommitmentDeveloping Shared Goals The importance of shared goals Effective Team communication