Overview Internal auditing is an independent and objective activity to evaluate an organisation's internal operations. You'll learn how to initiate an audit, prepare and conduct audit activities, compile and distribute audit reports and complete follow-up activities. It is very important for the organisation to have a smooth flow of accounting as it plays a very important role in the development of the organisation. Financial Managers or any person who deals with Accounts need to see that the company accounts are very updated and are free from any risks that can become a problem during the time of Auditing. Objectives By the end of the course, participants will be able to: Efficiently dealing with senior leaders with confidence Effective Contribution and Strategically Analysing and Auditing towards business success Analysing and Evaluating as an effective internal audit leader How to manage key relationships with the audit committee Practical methods for managing the audit committee and senior management Describing the significance to help maximize the contribution to their organization
A question of trust. Leadership implies followership. And that means trust. Because who's going to follow a leader they don't trust? This programme takes a values-driven approach to leadership. It gets current and aspiring leaders to hold up the mirror to themselves and to see their reflections as leaders of people. It asks them whether what they see justifies their view of themselves as leaders. It helps them understand just what it takes to be an effective leader. And it does so in a highly practical, constructive manner. It helps the course participants to truly understand the core skills of effective leadership. It focuses on the difference between leadership and management, defining what high performing teams do and how they do it. It helps people to see their teams from different perspectives, allowing them to adapt their styles to maximise team outputs. And it explores concepts such as emotional intelligence, authentic leadership and the RAIV approach (relationships-achievement-independence-vocation) to help explore underlying values and use them to drive effective leadership. Because what worth do our values have unless we put them into practice? The course will help you:• Appreciate the key skills a leader needs to be effective• Understand what the organisation expects of you as a leader• Recognise your leadership style and the impact it has on others• Consider your role models - who inspires you?• See leadership from the 'followers' perspective - how do you like to be led?• Discover what holds you back - limiting beliefs• Examine your core values -do they support your ambition?• Explore the concept of Emotional Intelligence - how do we manage ourselves?• Discover how to lead through change• Explore the concept of 'Authentic Leadership' - consider how it can work for you• Practice some of the skills essential to motivating and influencing for success• Use the RAIV approach to generating enthusiasm and commitment• Plan how best to 'walk the leadership talk' - in your role, in your organisation Above all, this course will help you put theory into practice, values into actions, in a mature, considered, effective way. Day 1 1 Welcome and introduction Participants are welcomed to the programme and invited to share their personal objectives and people challenges Participants given an action plan template to complete throughout the workshop Participants required to bring an inspirational quote to share with the group 2 What is leadership? The concept of 'leadership' The role of a leader Skills assessment for all participants# Leadership v Management Assess your team effectiveness 3 Your leadership style Leadership questionnaire You and your role models Push v Pull styles of leadership Empowerment v Control Team goals and role profiling Day 2 1 You, the leader Your core values Your communication style Situational leadership The Emotional Bank Account Buy Me Today 2 Are you Emotionally Intelligent? (EI) What is emotional intelligence? Self-assessment exercise Manage your emotions Nine strategies for promoting EI 3 Leading through change Identify the major changes affecting you / your team Types of change The roles of resistance How safe are you to talk to? Forcefield Analysis Day 3 1 Authentic Leadership (AL) What is AL? Managing perceptions is managing their truth A leadership challenge 2 Motivating and influencing for success What motivates you? Motivational theory Leading by example Influencing skills required Influencing styles The influence challenge! 3 Creating enthusiasm and commitment The RAIV approach (relationships-achievement-independence-vocation) Building self-worth What drives your team? Your leadership legacy Your commitment to leadership
Why cultural differences exist, what you can do to understand and respect these differences and then implement strategies to build effective intercultural relationships.Learn the skills, knowledge and have the confidence to tackle difficult conversations in a productive way. Course overview Duration: 1 day (6.5 hours) This workshop is designed for those who deal on a regular basis with fellow employees, suppliers or customers from different cultural backgrounds. The workshop will focus on understanding why cultural differences exist, what you can do to understand and respect these differences and then implement strategies to build effective intercultural relationships. The one day session will use professional actors in the afternoon so that you can practice real-life situations involving intercultural challenges. Objectives By the end of the course you will be able to: Understand what makes us different from people from other cultures Appreciate why we form impressions of other cultures Use strategies to communicate effectively with those from different cultural backgrounds Build trust with those we work with from a different cultural background Content Intercultural Challenges What challenges do you face with dealing with people from different cultures? Why do these challenges exist? Understanding Culture What is culture? Trompenaars’ Model of Culture – what determines our understanding of different cultures Cultural theories Hall and Hall:Three Systems of TimeThe Importance of Context – Data vs Dialogue Hofstede – 6 Cultural Dimensions Trompenaars – 7 Cultural Dimensions Chart your intercultural business relationships against these dimensions Strategies and Intercultural Management Trompenaar’s 3 step approach – Recognise, Respect, Reconcile How to foster and maintain trust Effective intercultural communication strategies Practical Activities Professional actors will work with you in small groups in the afternoon to practice real-life challenging conversations.
There is a lot to learn in Power BI, this course takes a comprehensive look at the fundamentals of analysing data and includes a balanced look at the four main components that make up Power BI Desktop: Report view, Data view, Model view, and the Power Query Editor. It also demonstrates how to utilise the online Power BI service. It looks at authoring tools that enable you to connect to and transform data from a variety of sources, allowing you to produce detailed reports through a range of visualisations, in an interactive and dynamic way. It also includes a detailed look at formulas by writing both M functions in Power Query, and DAX functions in Desktop view. This knowledge will allow you to take your reports to the next level. The aim of this course is to provide a complete introduction to understanding the Power BI analysis process, by working hands-on with examples that will equip you with the necessary skills to start applying your learning straight away. 1 Getting Started The Power BI ecosystem Opening Power BI Desktop Power BI's four views Introduction to Dashboards 2 Importing Files Importing data sources Importing an Excel file Importing a CSV file Importing a database Connect to an SQL Server Database Import vs. Direct Query Importing from the web Importing a folder of files Managing file connections 3 Shape Data in the Query Editor The process of shaping data Managing data types Keeping and removing rows Add a custom column Appending tables together Hiding queries in reports Fixing error issues Basic maths operations 4 The Data Model Table relationships Relationship properties 5 Merge Queries Table join kinds Merging tables 6 Inserting Dashboard Visuals Things to keep in mind Inserting maps Formatting Maps Inserting charts Formatting Charts Inserting a tree map Inserting a table, matrix, and card Controlling number formats About report themes Highlighting key points Filter reports with slicers Sync slicers across dashboards Custom web visuals 7 Publish and share Reports Publishing to Power BI service Editing online reports Pinning visuals to a dashboard What is Q&A? Sharing dashboards Exporting reports to PowerPoint Exporting reports as PDF files 8 The Power Query Editor Fill data up and down Split column by delimiter Add a conditional column More custom columns Merging columns 9 The M Functions Inserting text functions Insert an IF function Create a query group 10 Pivoting Tables Pivot a table Pivot and append tables Pivot but don't aggregate Unpivot tables Append mismatched headers 11 Data Modelling Expanded Understanding relationships Mark a date table 12 DAX New Columns New columns and measures New column calculations Insert a SWITCH function 13 Introduction to DAX Measures Common measure functions Insert a SUM function Insert a COUNTROWS function Insert a DISTINCTCOUNT function Insert a DIVIDE function DAX rules 14 The CALCULATE Measure The syntax of CALCULATE Insert a CALCULATE function Control field summarisation Things of note 15 The SUMX measure X iterator functions Anatomy of SUMX Insert a SUMX function When to use X functions 16 Time Intelligence Measures Importance of a calendar table Insert a TOTALYTD function Change financial year end date Comparing historical data Insert a DATEADD function 17 Hierarchies and Groups Mine data using hierarchies Compare data in groups
This two-day programme gives the key insights and understanding of contracting principles and the impact they have on business and operations. The course is designed for individuals involved in or supporting contracting who want to improve their commercial management skills; individuals in functions such as project management, business development, finance, operations who need practical training in commercial management; general audiences wanting to gain a basic understanding of commercial management. This is an assessed programme, leading to the International Association for Contracts & Commercial Management (IACCM)'s coveted Contract and Commercial Management Associate (CCMA) qualification. The programme addresses 31 different subject areas, across the five stages of the contracting process. By the end of the course the participants will be able, among other things, to: Develop robust contract plans, including scope of work and award strategies Conduct effective contracting activities, including ITT, RFP, negotiated outcomes Negotiate effectively with key stakeholders, making use of the key skills of persuading and influencing and to work with stakeholders to improve outcomes Set up and maintain contract management systems Take a proactive approach to managing contracts Make effective use of lessons learned to promote improvements from less than optimal outcomes, using appropriate templates Develop and monitor appropriate and robust Key Performance Indicators to manage the contractor and facilitate improved performance Understand the approvals process and how to develop and present robust propositions Make appropriate use of best practice contract management tools, techniques and templates DAY ONE 1 Introductions Aims Objectives Plan for the day 2 Commercial context Explaining the contracting context Define the key objective The importance of contact management Impact upon the business 3 Stakeholders How to undertake stakeholder mapping and analysis Shared vision concept, How to engage with HSE, Finance, Operations 4 Roles and responsibilities Exploring the key roles and responsibilities of contract administrators, HSE, Finance, Divisional managers, etc 5 Initiating the contract cycle Overview of the contracting cycle Requirement to tender Methods Rationale and exceptions 6 Specifications Developing robust scope of works Use of performance specifications Output based SOW 7 Strategy and award criteria Developing a robust contract strategy Award submissions/criteria 8 Managing the tender process Review the pre-qualification process Vendor registration rules and processes Creation of bidder lists Evaluation, short listing, and how to use of the 10Cs© model template and app 9 Types of contract Classify the different types of contracts Call-offs Framework agreement Price agreements Supply agreements 10 The contract I: price Understanding contract terms Methods of compensation Lump sum, unit price, cost plus, time and materials, alternative methods Cost plus a fee, target cost, gain share contracts Advanced payments Price escalation clauses DAY TWO 11 Risk How to manage risks Risk classification Mitigation of contractual risks 12 Contractor relationship management session Effectively managing relationships with contractors, Types of relationships Driving forces? Link between type of contract and style of relationship 13 Disputes Dealing with disputes Conflict resolution Negotiation Mediation Arbitration 14 Contract management Measuring and improving contract performance Using KPIs and SLAs Benchmarking Cost controls 15 The contract II: terms and conditions Contract terms and conditions Legal aspects Drafting special terms 16 Managing claims and variations How to manage contract and works variations orders Identifying the causes of variations Contractor claims process 17 Completion Contract close-out process Acceptance/completion Capture the learning/HSE Final payments, evaluation of performance 18 Close Review Final assessment
Understand how to effectively manage conflict and learn that conflict can be healthy and need not damage relationships. Course overview Duration: 1 day (6.5 hours) Conflict and differences of opinion are inevitable in the today’s fast moving, complex business world, some would argue they are even necessary. This highly interactive and practical course addresses the many aspects of effectively managing conflict and will help you ensure that conflict can be healthy and need not damage the relationship. This workshop has been specifically designed to give you an opportunity to learn and test a range of influencing and conflict handling models and techniques. The course is aimed at anyone who interacts with others on a regular basis. Objectives By the end of the course you will be able to: Utilise influencing skills to pre-empt and defuse conflict Resolve conflict by choosing the right approach Recognise the impact of non-verbal communication in managing conflict Use language skills necessary to get you message across in the ‘right’ way Present your case in a reasonable and responsible manner Identify behaviours that can help or hinder interactions with others Apply different techniques for managing conflict positively and for dealing with aggression Content Developing Influence Networking Sources of influence Influencing techniques Effective Behaviour Choosing the right approach Techniques to pre-empt or defuse conflict Behavioural styles and their impact on working relationships Triggers to aggressive behaviour Managing conflict flash points Dealing with different behaviour types Developing Skills Communication skills in conflict situations Using the right language Verbal and non verbal communications Managing our body language Your conflict management style analysis Thomas Killman Conflict Handling Instrument Working in groups Practical exercises and case studies The language of mediation Transactional Analysis Practical Practical exercises Case studies Personal action planning
Are you looking for something that will help you understand yourself and how to interact with others more effectively? Would you like something that uses a simple four colour model to quickly allow you to understand your personality type and how you can use this knowledge to enhance your relationships and reach your goals, whatever they are? We think that Insights Discovery might be just the thing for you! What's even better is that our Discovery bundle includes both a copy of your unique profile and a 90 minute personal session with our executive coach, Cami Rose, to chat it all through and set you up for success using your new knowledge for the future. Just request a session and we'll be in touch with the link that will allow you to complete the Insights evaluator and arrange your personal coaching session at a time to suit you. Want Discovery for your team? We can do that too. Leave us your name and details and we'll be in touch to chat through your needs and objectives.
Managing for Growth is designed for anyone who has management and leadership responsibilities within an organisation. Suitable for newly promoted managers, team leaders and supervisors through to senior managers; the objective of the programme is to develop a culture that will translate strategy into measurable outcomes by engaging these leaders to facilitate change and innovation. The programme is extremely effective at giving managers the tools and skills to deliver sustainable change and business growth. It's also been proven to reduce costs and increase profit – even before the programme has ended. Managing for Growth is built upon three aspects common to every job: Managing Resources. Ensuring that the resources available are appropriate for the tasks for which they are required and are being used effectively. Learning how to control and coordinate a mix of available resources for maximum efficiency. Managing Relationships. Positively influencing people’s behaviour in order to motivate them and promote effective working. Focusing on listening skills, we share ways to improve communication and teamwork to get the best from both internal and external relationships. Controlling Routines. Investigating the processes/systems/routines/series of actions that are linked together to achieve a desired outcome. Recognising the importance of controlling, developing, simplifying and following routines. Managing for Growth shows your team leaders, supervisors and managers how to cultivate a culture of teamwork and continuous improvement within your organisation. Focus for Action Throughout the programme the participants take part in work-based activities that will cause them to evaluate every aspect of their job and identify areas for improvement. By the end of the programme, the participants act on these action lists and implement improvement projects that will deliver measurable results. Continuous Improvement Managing for Growth sets the framework for continuous improvement by transferring skills and knowledge enabling your team leaders to translate organisational strategies into real, measurable outcomes. Format Designed for groups of up to 6 people, the programme is spread over 4 months with the first 7 sessions being held every 2 weeks and the final session a month later. Each session lasts approximately 2 hours.
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
REFERENCE CODE 610/0134/X COURSE LEVEL NVQ Level 3 THIS COURSE IS AVAILABLE IN Course Overview Who is this qualification for? This qualification is aimed at those who are involved in either site carpentry including first and second fixing, those who are involved in shopfitting site work or those who carry out shopfitting bench work. The qualification is at level 3 although there may be some units at different levels. Level 3 qualifications are primarily aimed at those who are fully trained and experienced in a wide range of work activities, It is not expected that candidates working in this industry all do the same activities or use the same equipment and machinery so the qualification has been developed to make it as widely available as possible. All work completed must be carried out in accordance with Building Regulations and Industry recognised safe working practices, including the disposal of waste. The qualification is structured to ensure that there is a high degree of flexibility within the pathways and units available and will allow employees from companies of all sizes and specialisms equal opportunity to complete. The qualification consists of 3 pathways. What is required from candidates? Qualifications are also required to indicate the number of hours of teaching someone would normally need to receive in order to achieve the qualification. These are referred to as Guided Learning Hours (GLH). The GLH for this qualification is 404. Pathway 1 Site Joinery, Pathway mandatory units Level Credits Installing bespoke first fixing components in the workplace Installing bespoke second fixing components in the workplace Setting up and using transportable cutting and shaping machines in the workplace Erecting roof structure carcassing components in the workplace Confirming work activities and resources for an occupational work area in the workplace Developing and maintaining good occupational working relationships in the workplace Confirming the occupational method of work in the workplace Conforming to general health, safety and welfare in the workplace Pathway 1 Site joinery – Optional units minimum of 1 unit must be achieved Erecting structural carcassing components in the workplace Maintaining non-structural and structural components in the workplace Pathway 2-Shopfitting site work-Pathway mandatory units Marking out from setting out details for routine shopfitting products in the Summary of the: GQA LEVEL 3 NVQ DIPLOMA IN WOOD OCCUPATIONS (CONSTRUCTION) Installing shopfitting frames and finishings in the workplace Installing shopfitting fitments in the workplace Installing shopfronts and finishings in the workplace Setting up and using transportable cutting and shaping machines in the workplace Confirming work activities and resources for an occupational work area in the workplace Developing and maintaining good occupational working relationships in the workplace Confirming the occupational method of work in the workplace Conforming to general health, safety and welfare in the workplace Pathway 3 – Shopfitting-Bench Work – Pathway mandatory units Producing setting out details for routine shopfitting products in the workplace Marking out from setting out details for routine shopfitting products in the workplace Manufacturing routine shopfitting products in the workplace Confirming work activities and resources for an occupational work area in the workplace Developing and maintaining good occupational working relationships in the workplace Confirming the occupational method of work in the workplace Manufacturing bespoke shopfitting products in the workplace Setting up and using fixed machinery in the workplace Conforming to general health, safety and welfare in the workplace Pathway 3 – Shopfitting – Bench work – Pathway optional units a minimum of 1 unit must be achieved Producing CAD setting out details in the workplace Producing wood and wood-based products using computer numerically controlled/numerically controlled (CNC/NC) machinery in the workplace Producing setting out details for bespoke shopfitting products in the workplace Assessment Guidance: Evidence should show that you can complete all of the learning outcomes for each unit being taken. Types of evidence: Evidence of performance and knowledge is required. Evidence of performance should be demonstrated by activities and outcomes, and should be generated in the workplace only, unless indicated under potential sources of evidence (see below). Evidence of knowledge can be demonstrated though performance or by responding to questions. Quantity of evidence: Evidence should show that you can meet the requirements of the units in a way that demonstrates that the standards can be achieved consistently over an appropriate period of time. Potential sources of evidence: The main source of evidence for each unit will be observation of the candidate’s performance and knowledge demonstrated during the completion of the unit. This can be supplemented by the following types of physical or documentary evidence: Accident book/reporting systems Photo/video evidence Safety records Work diaries Training records Timesheets Audio records Telephone Logs Job specifications and documentation Meeting records Delivery Records Records of toolbox talks Witness testimonies Equipment Correspondence with customers Prepared materials and sites Notes and memos Completed work Please Note that photocopied or downloaded documents such as manufacturers or industry guidance, H&S policies, Risk Assessments etc, are not normally acceptable evidence for GQA qualifications unless accompanied by a record of a professional discussion or Assessor statement confirming candidate knowledge of the subject. If you are in any doubt about the validity of evidence, contact Oscar Onsite Academy