32818 Courses

Learn how to work with and connect multiple data sets to effectively analyse and report on data. Course overview Duration: 1 day (6.5 hours) Within Excel you have some powerful features to enable you to connect and analyse multiple data sources. Power Query enables you to import and manipulate your data, Power Pivot enables you to connect multiple data sources and create pivot tables and pivot charts from them. This course is an introduction to Power Query and Power Pivot in Excel to get you started on creating a powerful reporting capability. Knowledge of working with Excel workbooks and relational databases would be an advantage. Objectives By the end of the course you will be able to: Import data from multiple data sources Edit and transform data before importing Add extra columns of data Append data Merge data from other tables Create data models Build data relationships Build Pivot Tables Build Pivot Charts Use Slicers and Timeline Filters Content Importing data Data sources Importing data Transforming data Editing your data Setting data types Removing columns/rows Choosing columns to keep Setting header rows Splitting columns Appending queries Appending data from other tables Adding text Columns from example Custom columns Conditional columns 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 Analysing information using pivot tables Creating and modifying a Pivot Table Recalculating the Pivot Table Filtering the Pivot Table Searching the Pivot Table Drilling down to underlying data Customising field names Changing field formatting Pivot charts, slices and timelines Creating Pivot Charts Adding and using Slicers

At times, everyone involved with a business will find themselves in a position where they are faced with difficult decisions. Being able to deal with these situations effectively and confidently is an important interpersonal skill. This is especially true for managers who will be forced to make tough decisions on a regular basis, but need to ensure that the business continues to perform both during and after the difficult decisions have been made. The manner in which they approach and implement these decisions can sometimes be the difference between success and failure. Course SyllabusThe syllabus of the Dealing with Difficult Situations with Confidence course is comprised of four modules, covering the following: Module OneSelf Awareness Attitude towards challenges - self-resilience Going into a challenging scenario - how to prepare Recognising the signs of contention Giving feedback constructively Module TwoHaving Difficult Conversations with Confidence Behaviour labelling - preparing the approach Assertiveness techniques Dealing with a difficult issue focussing on behaviour & consequences Keeping objective and professional throughout Module ThreeExamining Your Preferred Communication Style Recognising the different communication styles Analysing your preferred style - Paradigm FitIn Profiler review Identifying the most appropriate situations for each style Module FourHelpful Interpersonal Skills Effective questioning techniques Active listening Body language Recognising and dealing with behaviours Displaying and creating positive attitudes Remaining Assertive and in control

Gain confidence, expand your vocal power and develop your unique rock voice that will turn heads and turn your world upside down under the guidance of excellent rock singing instructors who specialise in teaching adults. Study the greatest hits while improving your vocal skills.

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

Learn how create and structure enterprise projects and programmes. Course overview Duration: 2 days (13 hours) Our P6 Project Planning and Controls Fundamentals course is an intensive two day course aimed at experienced planners and project controllers who need to use Primavera to create and manage detailed plans. It includes creating EPS levels, projects, WBS levels and detailed activity and resource planning. Experience of project planning and scheduling techniques is essential. Objectives  By the end of the course you will be able to: Create a programme structure Create projects and set project properties Create programme milestones Create a Work Breakdown Structure (WBS) Create detailed plans including activities, links and resources Progress the schedule Manage actuals Customise layouts Use the reporting tools in Primavera Content Programme Management Creating EPS elements Defining the programme structure Navigating the EPS structure Finding programmes Project Management and WBS Creating projects Setting project properties Validating projects Assigning project codes Building a work breakdown structure Creating a WBS structure Creating WBS elements Work package management Top Down budgets Allocating top down budgets Budget change Programming milestones and activity planning Creating programme milestones Setting constraints Linking milestones Scheduling Using the schedule function Detailed activity planning Creating activities Relationship types Creating relationships Adding milestones Assigning activity codes Resourcing, workloads and baselining Resource types Creating resources Resource attributes Assigning resources Switching resources Split load resource assignment Reduced hours resource assignment Checking workload Reviewing workload Dealing with resource conflicts Assignments view Baselining Creating baselines Assigning baselines Working with layouts Creating layouts Customising columns Setting filters Sorting and grouping Changing the timescale Customising the Gantt Creating activity code breakdown structures Progressing the schedules Updating task status and remaining duration Setting the data date Monitoring and reporting Exporting and importing information Primavera standard reports Creating custom reports Creating portfolios Printing Printing your schedule Printing to other packages

Learn how to create fully relational databases and how to input, extract and report on data. Course overview Duration: 2 days (13 hours) Our Access Database Design and reporting course looks at the key elements to building fully relational databases and entering and extracting information from them. This course is designed for new users who need to build relational database systems. Objectives  By the end of the course you will be able to: Create a new database Create data tables Set field validation and properties Enter data and manage data Create forms Use queries to extract data Create parameter queries Create calculations in queries Build relational databases Use sub datasheets Build multi table queries Use advanced form and report design techniques Content Creating a database Creating a new database Database elements Creating a data table Setting field properties Using input masks Using input masks Validation rules Default values Setting a primary key Creating lookup fields Data entry Adding data Deleting data Quick keys for data entry Working with data Sorting data Filtering data Finding information Navigation Creating data form Creating quick forms The form wizard Amending forms Formatting Setting the tab order Entering data using forms Creating queries Creating a query Setting criteria Using the expression builder Creating parameter queries Using wildcards Using more than one parameter Using calculations in queries Adding a totals row Formatting results Adding calculations Printing and reporting Printing tables and queries Creating reports Building and amending reports Adding headers and footers Working with relational databases Relational database principles Importing data from other sources Linking information between tables One-to-one and one-to-many links Defining referential integrity Amending links Deleting links Sub datasheets Viewing a subdatasheet Removing a subdatasheet Connecting a subdatasheet Multiple table queries Deciding which tables to use Adding tables to the query Creating links between tables Setting join properties Advanced form design Field properties Creating lookup fields Adding calculated fields Applying conditional formatting Advanced report design Field properties Report properties Alternate colour bandings Concatenating fields Adding calculated fields Sorting and grouping Grouping settings Adding headers and footers Adding dates, times, page numbers

Supporting Women in Leadership Throughout The UK Our women in leadership course is specifically designed to target challenges and support women in developing their leadership and management careers. AWARD WINNING LEADERSHIP DEVELOPMENT PROGRAMME Discover Our Women in Construction Management Course The Power Within is dedicated to helping women in construction across England and Scotland achieve business success through our Motivational Intelligence framework. Motivational Intelligence is the third level of intelligence, and the science behind it has won a Nobel Prize. Our women leadership in construction course supports women by improving their motivation, self-belief, decision-making, and leadership skills. This programme is designed to help female business leaders adapt more quickly to their environment, handle adversity more effectively, take productive action, and thrive during times of change. Each is a vital skill needed in today’s ever-changing business environment. When completed, you’ll have the skills needed to make decisions more effectively that help your business grow, become more resilient, and take opportunities when others are stuck. "This course has completely changed my outlook on my responsibilities as a manager/leader. In 26 years with Pfizer, I have never participated in a programme that has as profoundly changed my perspective on my role, my responsibilities and my ability to positively impact my team." FEMALE DIRECTOR OF BUSINESS SERVICES, PFIZER LEADING WITH MOTIVATIONAL INTELLIGENCE What is our Women in Construction Course? In the past five years, we’ve supported thousands of business leaders and managers in nurturing the skills and mindset needed to achieve and exceed their business goals. The Power Within knows women are incredibly effective and consistent at applying our Motivational Intelligence techniques to their lives and business. Our women in construction management course is designed to give you the skills you need to take charge of your business and ensure constant growth while future-proofing your business. The training is perfect for women in construction who are managers or leaders looking to: Quickly Adapt Their Team to Change Effectively Mentor Every Team Member Improve Communication and Collaboration Gain More Buy-In to New Goals or Strategies Transform Their Team Culture Increase Initiative and Self-Motivation Across Their Team How We Help Women in the Construction Industry Our course focuses on imparting fundamental skills, tactical best practices, and powerful insights into the human side of the business. You’ll be provided with valuable knowledge needed to be successful leaders and managers of all levels. We’ll focus on addressing the challenges new businesses around the world face, like leading teams and developing businesses in turbulent and transitional times as well as overcoming the challenges of being women in the construction industry. Throughout the course, particular emphasis is given to helping leaders raise motivational intelligence and foster a growth mindset within their team. LEADING WITH MOTIVATIONAL INTELLIGENCE Our Leading with Motivational Intelligence (MQ) Executive Diploma Programme is specifically designed to help participants create the “complete game” of leadership and management. Leveraged by more than 40% of the largest Fortune 500 companies and implemented around the world, the Leading with Motivational Intelligence (MQ) consistently receives a participant buy-in rate in excess of 97%. However, the most important statistic is: 12 months after completing the course more than 93% of participants continue to use the skills and techniques taught on a daily basis. SQA APPROVED EXECUTIVE DIPLOMA What Skills Do We Help Women in Construction Develop? The skills we teach through our women in construction management courses are delivered through seven modularised sessions, each between three and three-and-a-half hours per session, with all sessions starting at 9:30 am via Zoom. An additional two hours per week is spent working on the online training assignments and leadership development plan. Each session will provide the education and information needed to establish yourself in your business. Here is more information regarding each session and the skills taught: SESSION 1: SELF-LEADERSHIP & THE SECRET TO PERSONAL SUCCESS Our first module is focused on setting course expectations and creating the right environment for learning. We’ll introduce the format and logistics, then discuss leading through turbulent times and how we can take control of ourselves, our thoughts, and our actions to lead growth. There is also a discussion on adult learning techniques and how leaders can leverage them to improve the effectiveness of their teams. We’ll also explore how turbulence and transition have changed how we manage and lead our teams. SESSION 2: THE ROLE OF INTELLIGENCE WHEN LEADING In this session, we’ll discuss the three levels of human intelligence and show how they each play in an individual’s performance and behaviors. Through two distinct mindsets, you’ll be shown how an individual’s motivational intelligence ultimately influences their emotional intelligence and intelligence quotient (IQ). Depending on which mindset a person operates under ultimately dictates their view of themselves, opportunities, and the work at which they will allow themselves to succeed. Finally, we’ll discuss switching your team to a growth mindset. SESSION 3: THE PILLARS OF HUMAN PERFORMANCE Completing this session will allow you to deconstruct the components that create a motivational intelligence growth mindset. Through discussion, you’ll see how most organizational challenges can be directly tied back to lapses in these components. We’ll review the leaders who’ve had the most significant influence on the meeting participants and shows the commonalities that make these leaders stand out. Lastly, we’ll introduce terminology, tools, and techniques that leaders can leverage to better coach and mentor their team. SESSION 4: MANAGEMENT VERSUS LEADERSHIP: THE TWO CRITICAL AND CO-DEPENDENT SKILLSETS FOR CREATING TEAM SUCCESS We’ll discuss the difference between a manager’s and a leader’s focus. The discussion focuses on the two most common management mistakes and how they undermine team culture and individual performance. The final debate focuses on the five critical best practices of excellent management, including clearly defining and communicating goals, creating alignment and buy-in, setting proper expectations, monitoring performance, and recognizing and rewarding performance. Our final portion will work to define what management is. Session 5: Exploring and Defining Leadership: Dispelling the Myths that Surround It Session 5 strives to define leadership. Building on this definition is a follow-up discussion regarding how people develop their leadership abilities. We’ll explore the underpinnings of what creates a successful leader. It also includes the importance of asking questions and active listening. We’ll review the five behavioral characteristics associated with motivational intelligence and how leaders can assess the relative strengths or weaknesses of the characteristics within their team. Lastly, we’ll explore great leaders’ five critical best practices, including communicating a compelling vision, modeling the correct behaviors, establishing a team culture anchored in responsibility, consistently building team confidence and self-esteem, and proactively coaching and mentoring. SESSION 6: BUILDING A LEADERSHIP TOOLBOX FOSTERING ADAPTABILITY, RESILIENCE, AND COURAGE We’ll provide information regarding tools and techniques that leaders can utilize to foster greater accountability and ownership win their teams. The Power Within will explore self-esteem’s critical role in the relative strength or weakness of a person’s motivational intelligence and adaptability in life. We’ll discuss how self-esteem has formed and how it will influence how a person interprets feedback in life. Lastly, we’ll explore levels of self-esteem and the associated behaviors of each. SESSION 7: HELPING EMPLOYEES DEVELOP A HEALTHY PERSPECTIVE AND RESILIENT ATTITUDE During the final session, we’ll explore self-esteem’s critical role in the relative strength or weakness of a person’s motivational intelligence and adaptability in life. We’ll talk about how self-esteem is formed and how it influences how a person interprets feedback. Finally, we’ll explore levels of self-esteem and the behaviors of each and the influence of comfort zones, and the tools that leaders can use to help people escape the fear of change. Our Course Leaders The Power Within was founded by husband and wife team James and Enas Fleming, to inspire people worldwide to think bigger, be better, and achieve more. They both work on a personal level with individuals, businesses, and organisations to help them create leaders and build environments where they can thrive. James and Enas challenge the limits with the Motivational Intelligence formula to help you broaden your perspective and create a future on your terms. Here is more about your course instructors: James Fleming James Fleming – James Fleming, the co-creator of The Power Within. He wanted to inspire people around the world to think better, be better, and achieve more. James believes everyone can do whatever they set their minds to. Founding The Power Within allowed James to turn that deep knowledge into a business that helps others think bigger, better, and achieve more daily. He strives to give leaders the tools and knowledge to achieve their full potential while increasing their self-confidence and self-belief through the Motivational Intelligence Revolution. James wants to support today’s businesses to become tomorrow’s leaders. Mari Steyn Mari is the go-to person for building self-esteem, offering new perspectives and stepping up in Life. With an endless abundance of excitement and love for all people, combined with degrees in Psychology, Knowledge and Information Management and is a Master NLP and Transformation Coach and International NLP and Coaching Trainer and Executive Coach, Mari offers an attractive, fresh, expert approach to Emotional Freedom, Motivational Intelligence, Leadership Development and ReWriting your Story. We undoubtedly have the power within to alchemize ourselves and any situation! Seeing the light go on in someone’s eyes is my ultimate joy. Take Charge with Our Women in Construction Course The Power Within is a Motivational Intelligence company dedicated to helping businesses and leaders become more accountable, resilient, adaptable, and capable of handling all challenges, regardless of the complexity. Our women in construction management course build upon best practices, strategic insights, and lessons learned over three decades of building leadership universities for Fortune 500 companies. Throughout the course, emphasis is given to helping leaders raise their motivational intelligence and foster a growth mindset within their team. You’ll gain the skills you need to successfully lead your team and overcome adversity while ensuring your company is profitable. To learn more about our course or to register, reach out today.

Virtual course for parents of adult children at risk/pre manifest. We are pleased to invite you to our virtual course for parents of adult children at risk/pre manifest. This is an opportunity to improve your knowledge of the issues surrounding your adult child at risk, share your experiences and gain ideas of support available for yourself and your adult child. This is a 5 week course running from Thursday 22 February 2024 10am -11.30am until Thursday 21 March, with the final session being an extended session narrative therapy session facilitated by Riverbank Psychology. There will be the opportunity to join a follow up support group. Week 1 – Thursday 22 February 2024 10am Welcome and overview of support available from the Huntington Disease Association. Speaker: James O’Connor – Team Leader HDYES – Huntington’s Disease Association Week 2 – Thursday 29 February 2024 10am Genetics: How to access testing, the process and family planning options Speaker: Chris Platt – SHDA – Huntington’s Disease Association Week 3 – Thursday 7 March 2024 10am Research update and what next Speaker: Nataile Saad - Research Sister - Welcome Trust Southampton University Hospital Week 4 – Thursday 14 March 2024 10am Finances planning ahead Speaker: Lisa Pearson - Financial Advisor - Asset management Week 5 – Thursday 21 March 2024 9.30 -12.30pm (note longer session)* Narrative Therapy: Coping with Feelings, supporting a loved one and self-care. Mariangels Ferrer – Clinical Psychologist – Riverbank Psychology * We will invite previous course participants to this part of the course but can only accommodate a maximum of 12/14 people on the day. The focus of Narrative Therapy in this group is to participate in a creative activity that explores identity through values, beliefs, and support systems, enabling us to make connections to our external lives which will be sustainable in our everyday lives. Mariangels Ferrer Duch is a Clinical Psychologist trained in Narrative Therapy who will be facilitating a three-hour Narrative Therapy session. The focus of the session will be upon the many small things that are important to us in life which can often be overlooked in times of stress. We hope the conversation will help to mutually inspire us all! We take your privacy seriously and promise to never sell your data. You can find out more about your rights, how we use your personal information and how we keep your details safe and secure by reading our privacy policy here. For more information email info@hda.org.uk or call 0151 331 5444.

If your focus is to learn how to communicate effectively and efficiently, to the point where you can speak like a native, then to book yourself into our conversation classes Timetable: daily 12:30 – 13:30

AgileBA® Foundation and Practitioner: Virtual In-House Training The AgileBA® Foundation and Practitioner course takes you through a business understanding of the external and internal forces that underline the project from a business perspective, looks at modeling techniques, (As Is - To Be), and also provides an overview to project management (AgilePM) from an 'Agile' perspective. The course explains the role's relevance and involvement throughout the project. What You Will Learn At the end of this program, you will be able to: Understand business analysis in a project environment and the techniques used, as well as knowing more about the role of the business analyst in a project Business Analysis - Business Environment and Organizational Strategy Overview of AgilePM The Business Case Stakeholder Engagement/Analysis Techniques: Requirements and Estimating Prioritization Timeboxing Iterative Development Planning Facilitated Workshops Modeling - 'As Is - To Be' Making the transition to AgileBA