1495 PE courses in Bristol

This programme provides an intensive, one-day overview of the key concepts and techniques of project management. The project management methods presented can be applied to a wide range of projects and the course emphasises both the task and the team-related aspects of project management. The aims of the programme are to: Present the key concepts of project management Provide a structured approach for managing projects Demonstrate tools and techniques for planning and controlling project work Enable participants to apply the techniques to their own projects At the end of the programme, participants will: Recognise the benefits of a structured approach to project work Be able to apply a range of practical tools and techniques to improve their personal effectiveness in project work Have a means of determining the status of current projects and know what actions are needed to ensure success 1 Introduction Why this programme has been developed Review of participants' needs and objectives 2 Key concepts The characteristics of projects and project work The four key phases of a project Essential lessons from past projects Key success factors Achieving success through the 'Team-Action Model' Challenges of the multi-project situation 3 Setting project goals Understanding 'customer' requirements Managing project stakeholders and gaining commitment Using questioning skills to define goals and success criteria Defining and documenting the scope of the project 4 Project planning Defining what has to be done Creating a work breakdown Agreeing roles and responsibilities for the work Developing a programme using networks and bar charts Estimating timescales, costs and resource requirements Planning exercise: participants develop a project plan Identifying and managing project risks Using project planning software Managing and updating the plan 5 Project implementation and control Creating a pro-active monitoring and control process Techniques for monitoring progress Using latest estimates Managing project meetings Resolving problems effectively Managing multiple projects Personal time management 6 Course review and action planning Identify actions Sponsor-led review and discussion of proposals Conclusion

This course starts with data transformation strategies, exploring capabilities in the Power Query Editor, and data-cleansing practices. It looks at the Advanced Query Editor to view the M language code. This course focuses on advanced DAX measures that include filtering conditions, with a deep dive into time intelligence measures. Like the M query language, DAX is a rich functional language that supports variables and expression references. This course also looks at the creation of dynamic dashboards and incorporates a range of visualisations available in Power BI Desktop and online in the AppSource. The course finishes with a look at setting up end user level security in tables. 1 The query editor Split by row delimiter AddDays to determine deadlines Advanced query editor 2 Fuzzy matching joins Matching inconsistencies by percentage Matching with transformation table 3 Logical column functions Logical functions IF, AND, OR Using multiple conditions Including FIND in functions 4 Editing DAX measures Make DAX easier to read Add comments to a measure Using quick measures 5 The anatomy of CALCULATE Understanding CALCULATE context filters Adding context to CALCULATE with FILTER Using CALCULATE with a threshold 6 The ALL measure Anatomy of ALL Create an ALL measure Using ALL as a filter Use ALL for percentage 7 DAX iterators Anatomy of iterators A closer look at SUMX Using RELATED in SUMX Create a RANKX RANKX with ALL 8 Date and time functions Overview of functions Create a DATEDIFF function 9 Time intelligent measures Compare historical monthly data Create a DATEADD measure Creating cumulative totals Creating cumulative measures Visualising cumulative totals 10 Visualisations in-depth Utilising report themes Create a heatmap Comparing proportions View trends with sparklines Group numbers using bins Setting up a histogram 11 Comparing variables Visualising trendlines as KPI Forecasting with trendlines Creating a scatter plot Creating dynamic labels Customised visualisation tooltips Export reports to SharePoint 12 User level security Setting up row level security Testing user security

This one-day introduction workshop is intended for users who need to get to grips with the essentials of Microsoft Outlook. It will provide you with the basic skills you need to effectively start using Outlook to manage your emails, calendar, contacts, tasks and notes. This course will help participants: Send messages with added email options applied Quickly file messages away for safe keeping Manage messages and attachments Organise calendar meetings and check other people's schedules Respond to a meeting request Create a contacts list Manage daily tasks Use reading and folder panes Create and manage folders Use auto reply Use notes Utilise Outlook's printing functionality 1 Getting started Using the reading pane Using the folder pane Changing inbox views Managing the to-do bar 2 Emailing messages Replying to and forwarding messages Adding message options Attaching files to an email message Opening and saving attachments 3 Outlook folders Creating and managing folders Moving messages into folders Adding folders to favourites Using search folder Always moving messages in conversation Automatically move messages with rules 4 Managing messages Using instant search Finding messages by criteria Grouping and sorting messages Categorising messages Adding message follow up flags Filtering messages with the people pane 5 Using auto reply Replying to messages whilst you are away Managing auto reply settings Applying rules to auto reply 6 Outlook calendars Adding and editing appointments Adding calendar reminders Moving and copying appointments Creating all day events Recurring appointments Sharing your calendar Opening another user's calendar 7 Planning a meeting Arranging meetings Inviting attendees to meetings Responding to meeting invites 8 Outlook contacts Creating and editing a contact Saving emails as contacts Finding contacts Sending messages to contacts Creating contact groups 9 Adding tasks Creating and editing tasks Completing tasks Assigning a task to another user Responding to a task request 10 Notes Creating and editing tasks Emailing notes Sticking notes on your desktop 11 Printing Printing messages Printing calendars Printing contacts

This course is designed for those already using Power BI Desktop and are ready to work with more comprehensive elements of analysing and reporting in Power BI. The course maintains a balanced look at data analysis including the Power Query Editor, with a deep dive into writing DAX formulas, and enhanced dashboard visualisations. The aim of this course is to provide a more complete understanding of the whole Power BI analytics process, by working with business examples that will equip you with the necessary skills to output comprehensive reports and explore Power BI's analytical capabilities in more depth. 1 The Query Editor Grouping rows in a table Split row by delimiter Add days to determine deadlines The query editor 2 Fuzzy Matching Joins Matching inconsistencies by percentage Matching with transformation table 3 The Query Editor M Functions Adding custom columns Creating an IF function Nested AND logics in an IF function 4 DAX New Columns Functions Including TRUE with SWITCH Using multiple conditions The FIND DAX function The IF DAX function Logical functions IF, AND, OR 5 Editing DAX Measures Making DAX easier to read Add comments to a measure Using quick measures 6 The Anatomy of CALCULATE Understanding CALCULATE filters Add context to CALCULATE with FILTER Using CALCULATE with a threshold 7 The ALL Measure Anatomy of ALL Create an ALL measure Using ALL as a filter Use ALL for percentages 8 DAX Iterators Anatomy of iterators A closer look at SUMX Using RELATED with SUMX Create a RANKX RANKX with ALL 9 Date and Time Functions Overview of functions Create a DATEDIFF function 10 Time Intelligent Measures Compare historical monthly data Create a DATEADD measure Creating cumulative totals Creating cumulative measures Visualising cumulative totals 11 Visualisations In-Depth Utilising report themes Applying static filters Group data using lists Group numbers using bins Creating heatmaps Comparing proportions View trends with sparklines 12 Comparing Variables Visualising trendlines as KPI Forecasting with trendlines Creating a scatter plot Creating dynamic labels Customised visualisation tooltips Export reports to SharePoint

It is important for Officers to understand the roles and responsibilities, processes and procedures involved when working with Elected Members. They also need to appreciate the significance of Elected Members as the decision-makers in local government. Officers have a responsibility to work and communicate with Elected Members effectively. This very successful course is designed to help Officers with this. Note: this is very much an indicative outline. The programme is tailored to the needs of each particular organisation. To provide managers with the knowledge and understanding they need to have productive working relationships with Elected Members and provide appropriate support. By the end of the course participants will: Understand the roles, responsibilities, processes and procedures in place for working with Elected Members Be able to identify the best way to approach potentially sensitive issues Understand the skills and behaviours required for working effectively with Members Be able to deploy their influencing skills more successfully Review their learning and have an action plan to take back and implement at work Note: this is very much an indicative outline. The programme is tailored to the needs of each particular organisation. 1 Introduction Welcome and introductions Objectives and programme overview 2 Working in a political environment What is political awareness? Contact and experience with Members Importance of the role of Members 3 Why be an Elected Member? Perceptions of what Elected Members are and do Values of Members and their motivations for doing what they do 4 Political decision-making in local government Current challenges and drivers affecting the organisation / the council Roles and responsibilities of Officers and Members Centrality of Members' strategic role 5 (Option) A day in the life of an Elected Member An Elected Member gives a talk about what they do 6 Having a beneficial relationship between Officers and Members 7 Member / Officer communication Discussion of the formal processes, service procedures, etc (whether enshrined in a protocol, Memorandum of Understanding, etc) Response times and requirements Procedures required by Heads of Service [if appropriate] 8 Influencing styles and strategies Different forms of power and how they impact Developing an appropriate 'influencing style' Exploring strategies for improving communication and influencing at work 9 Review and evaluation Review and evaluation of learning Personal action plans

Project management can seem scary and rather intimidating. The whole aim of this programme is to give people a simple and straightforward way of dealing with projects without having to use complex and confusing systems. This two-day course is designed to introduce the apparently complex world of project management in a simple and practical manner. The programme is for anybody who has to run a project of any nature. It has been attended by people from as diverse fields as events management, fashion, charities, oil companies and so on. The programme is run without using any IT project management systems although an introduction can be given if required. At the end of the programme participants will leave understanding: What a project is and why projects are so important today The roles of a project manager Some key language and concepts A simple 5-step model for organising projects How to make sure you understand what your 'client' really wants A set of three simple tools to plan the project How to make decisions What to monitor when the project is running How to close the project 1 Introduction What is the aim of this programme? 2 Background thinking What is a project? The project manager's eternal triangle (cost-quality-time) What are the characteristics of successful projects? Who are the key characters in a project? What are the roles of a project manager? 3 The project process Why have one? 4 Project initiation What is the aim? Identifying key information Key skill: mission analysis Initial risk analysis Document and sign-off 5 Decision-making - 'Stop, Think, Act!' The 'Stop, Think, Act!' technique Recognise the opportunity to make a decision The 3 Cs - making sure we understand the decisions we have to make Identifying options Making your decision Taking it to action 6 Creativity 7 The planning stage Identify all discrete tasks Sequence and dependencies Time line - critical path Resources Project base-line 8 Execution stage - delivering the result Monitor Evaluate Adapt Control Review 9 The project close Review Documentation Have we delivered? What have we learned?

In the fast-changing world of business, and especially IT, everyone in the organisation should be involved in sales. One of the best ways is to give the customer an outstanding experience. The customer experience is the competitive battlefield of today. Sales may be won or lost here. You can either close a sale for a quick buck, or open a long-term relationship to create a high lifetime value customer. By developing excellent communication skills, rapport and, most of all, a desire to serve and listen to the needs of the customer to the best of their ability, both sales teams and other IT professionals will create trust, nurture relationships and develop awareness of other opportunities with the customer. By the end of this course, participants will be able to: Understand the power of a positive customer experience in developing sales opportunities Recognise and develop a sales opportunity when it arises Engage with customers and develop rapport and trust Use verbal and non-verbal communication skills and pick up on signals Ask powerful questions - and listen to the answers Create 'magic moments' for the customer Turn a complaint into an opportunity Know when to ask for referrals and testimonials Pass on leads to the relevant people 1 Introduction Aims and objectives Beliefs about sales 2 Building rapport First impressions Short cuts to rapport Finding common interests 3 Selling or serving? Managing emotions and behaviour - Transactional Analysis Moments of truth - creating 'magic moments' Speed sells - the follow-up 4 Meetings Planning a successful meeting Pre-meeting connection and assistance Sales meeting failure reasons Right v wrong mindset 5 Communication - verbal and non-verbal The 3 Vs - Visual, Verbal, Vocal Picking up on signals 7 power questions Questioning techniques LISTEN - 3 types of listening skills 6 Influencing 6 levels of influence Framing to change perspectives Turning complaints into opportunities 7 Referrals The power of referrals How and when to ask for a referral 5 steps from rapport to referral 8 Presentation and pitching (optional session) Basic presentation structure and delivery Creating powerful impressions Creating a 60-second pitch The elevator 10-second pitch - answering 'What do you do?' Sales presentations Emotion v Intellect - how to engage Using visuals

This very practical one-day programme provides participants with the skills and knowledge required to be an effective member of the procurement team and to enable them to procure a wide range of resources for the organisation, in a compliant and cost-effective manner. It also empowers them to be able to collaborate with all key stakeholders. By the end of the programme participants will be able to: Understand the basic concepts of good procurement practice Apply a range of tools and techniques for developing scopes of work and specifications Apply various methods to select and evaluate suppliers Develop robust contract award strategies Appreciate the commercial importance of effective procurement and opportunities to reduce cost and add value Develop appropriate procurement strategies depending on risk and value Appreciate the legal aspects of procurement 1 Welcome Introductions Aims and objectives Plan for the day 2 The basics of procurement The concept of total cost of ownership v price The procurement cycle The roles of the customer and the contractor Impact upon profit 3 Specification process Importance of effective specifications Specification development process Types of specification Team approach Use of performance specifications Early supplier involvement (ESI) / early contractor involvement (ECI) 4 Quality Concepts and practices Defining 'fit for purpose' Conformance to requirements Compliance to standards Role of the supplier Quality assurance tools and techniques 5 Procurement methods RFP RFQ ITT Negotiated procurement Strategic partnerships Outsourcing 6 Tendering How to undertake a formal tendering process Business case to award Critical stages in the process Risks and benefits 7 Tender evaluation How to undertake a quotation analysis Tools of analysis Use of VFM models Role of the customer Comparisons around cost, quality, and delivery 8 Supplier selection and evaluation Developing critical selection criteria Using the 10Cs model Importance of effective selection process Weighting systems Importance of validity and evidence 9 Capital equipment procurement Life cycle cost issues Payback calculations Compatibility issues Maintenance and training issues After-sales support 10 Supplier relationships Corporate social responsibility issues Communication 360 feed-back Open and ethical Initial understanding Clear and fair terms and conditions 11 Close Review of key learning points Personal action planning

We've all sat through far more bad presentations than good ones, but knowing what 'good' looks like is easier than successfully replicating it. Sales presentations are a performance and, as salespeople, fluffing our lines can cost us a lot more than hurt pride. Having discovered and understood the specific needs and burning issues our prospect has, then this course will help any salesperson avoid dropping the ball and instead wowing their prospects with a high-impact, tailored and compelling case for purchase. This course will help participants: Prepare mentally and physically for stand-up presentations Use voice modulation and bullet-pointing to demand attention Avoid boring their prospects Master the do's and don'ts of PowerPoint Deal more effectively with technical hitches and prospect's interruptions Use eye contact and engagement to avoid prospects 'tuning out' Deploy best practice essentials for presenting with colleagues Steer through the toughest Q&A 1 Preparing your presentation Mindset Knowing your objective(s) Vocal warm-up techniques Assembling pre-agreed benefits Time management Room set-up Technical preparation 2 How to open your presentation Vocal energy Summary and agreement of prospect's needs How to have posture and confidence Use of humour What to do with those dreaded hands Confident v non-confident body language 3 How to get and keep people's attention Bullet pointing Linking benefits to specific, stated needs Practical exercise - formulating and delivering tailored benefits Being selective with features Third party reinforcement and case studies 'Watering the garden' eye contact technique Practical exercise - participants practise 'sharing out' eye contact to audience How to handle a prospect's negative body language Handling interruptions 4 Presenting in groups Credentialing all participants Role delineation for group presentations Edifying other participants' messages - do's and don'ts How to maintain energy when not speaking Practical exercise - good and bad practice when not speaking Teamwork in Q&A sessions How to hand over professionally 5 PowerPoint do's and don'ts Use of visual aids Good and bad PowerPoint slides How to make PowerPoint work for you Classic PowerPoint errors Avoiding and handling technical problems Good and bad flipchart practice 6 Closing and / or achieving next action steps Power of summary Good Q&A practice Handling objections Practical exercise - handling objections on one's feet Creating consensus among prospect panel What to do when prospects disagree with each other When to trial close How to close on next action steps 7 Wrap-up Key learning points from each participant Action steps to be implemented on next presentations

Today's administrative professional needs flexibility and a broad portfolio of skills including self-motivation, assertiveness, and the ability to deal with difficult people. You will benefit from this course if you are an administrator, medical/legal secretary or PA, who wants to enhance your administrative support skills, as well as evaluating your existing techniques. This course will help you identify: your areas of strength and your areas for improvement in the work environment ways to accept new challenges and responsibilities with confidence what motivates you at work techniques to improve your planning and time management ways of improving your influencing and assertiveness skills your preferred working style (and relate it to your interaction with others) ways of using your initiative how to deal with challenging people, using recognised communication methods The course will help you develop a flexible set of skills that will allow you to succeed at work, no matter what the day throws at you. It will help you communicate effectively with a diverse range of colleagues and others with tact and diplomacy. And, finally, it will help you provide the administrative support that is essential for the smooth running of your area and of the organisation as a whole. 1 Introduction Overview Introductions Individual objectives 2 What exactly is your role? Before looking at new skills and techniques, where are you now? Do you have the skills, knowledge and attitude required to be an exceptional administrator? Understand your job criteria Identifying your strengths and areas for development Activity - skills analysis Activity - action plan 3 Building trust How can you build trust? Understanding the links between reliability, consistency and trust What is required to deliver efficient service? Activity: efficient service requirements of the professional administrator 4 Working styles Identifying your working style preference Understanding the importance of a flexible approach Identifying areas of improvement to become a more effective team member Activity: Questionnaire (completing, scoring and charting) Activity: drawbacks of my style Developing your working style 5 Assertiveness Understand the differences between behaviours Activity: Definition and characteristics of assertive / aggressive / passive behaviour Activity: Identifying different behaviours Understanding how to be more assertive How to use assertiveness techniques How to ask for feedback Activity: Making requests assertively Activity: Refusing requests assertively 6 Time management The importance of planning for success The importance of managing interruptions The importance of having clear purpose Time management best practices Activity: How do you plan your time? What prevents you improving your time management? How will you recognise success? 7 Prioritisation How to prioritise work to meet deadlines The prioritisation matrix Activity: Post it! 8 Dealing with interruptions The impact interruptions have on productivity How to manage interruptions Activity: What interruptions do you experience? What tactics can be employed to reduce these interruptions? 9 Close Open forum Summary Action planning