13018 GRE courses

This one-day workshop will give you a better understanding of the components and operations of an Access database. It is designed to build on a user's existing skills and includes useful action queries to allow greater manipulation of a database. This workshop will help participants: Ensure the integrity of their databases Manage field properties Use the query functions effectively Save time with the query expression builder Create different types of query more quickly Design better forms Link expressions in forms Create better and more useful reports Import and export tables more easily 1 Table relationship integrity Identifying relationships Identifying criteria for data integrity Applying referential integrity Managing relationship join types 2 Table field properties Field properties overview Using input mask field Using default value fields Using field validation rules 3 Query functions Running aggregate function calculations Running sum, average, count, max and min functions Grouping calculated data 4 Query calculations Using query operators and expressions Adding calculated fields to a query Using the query expression builder 5 Action queries Creating make table queries Creating append queries Creating update queries Creating delete queries 6 Designing forms Adding form controls Aligning and arranging form controls Adding pictures and labels to forms Adding new fields to a form Controlling tab order Adding command buttons Adding a combo box control Formatting data using conditional formatting 7 Form expressions (calculations) Using the form expression builder Working with a property sheet within a form Linking expressions within a form 8 Working with reports Creating reports with the report wizard Inserting report fields Formatting fields Inserting report headers and footers Working with a property sheet within a report 9 Grouped reports Creating groups with the report wizard Sorting grouped data Grouping alphabetically Grouping on date intervals Creating sub reports Adding calculations to groups 10 Importing and exporting tables Importing tables into Access Exporting tables from Access Importing and linking data in Access

The ability to influence others is a life skill but also one that has never been so critically useful at work. This one day workshop will set you on the road to discover what you need to be able to think and do that will help you take people with you. This involves learning some new tools and strategies that fit the situation you are in and making sure you use the right skills and behaviours to influence well, whether it is a single person or a room full of cynical expectant people! This workshop will enable you to: Learn about and understand influencing styles and strategies available and formulate plans and ideas on how to use them in influencing situations Understand which skills and behaviours to use to be the most effective influencer Have greater confidence in situations where they need to influence someone Use thinking, speaking and behavioural techniques that enable influencing to be effective and positive Review and evaluate learning and have an action plan to take back and implement in the workplace 1 Welcome, introductions & getting to know you and why you are here Course objectives 2 Personal objectives Introducing a learning diary 3 Gallery exercise - using images of exemplars brought by participants Plenary discussion The skills and behaviours of an exemplar influencer 4 Group task - what does your self-evaluation say? Discussion and conclusions 5 Influencing - what is it? - why do we need it? The current organisational landscape including values and behaviours the influencer operates in 6 Pit Stop - 'pull / push', 'the lost horse' and 'talking at' 7 Direct / support / delegate / coach: the different choices and approaches to choose from 8 Updating the learning diary 9 Power and types of power - its impact on influencing ability and approach and what is within your control Group task and discussion 10 The 5 influencing styles tool Series of tasks and exercises Drilling down to a personal action plan for maximising influence 11 'The person with the most flexibility has the most influence' Skills and behaviours for effective influencing Exercises and techniques that develop skills for influencing 12 Review and evaluation Action planning

Successful account management requires time and investment to achieve high levels of customer satisfaction and develop new business opportunities. Ensuring you are equipped with the right tools to approach every customer interaction in a structured way will help you have productive relationships with your clients. Whether you're new to account management or experienced in business development and looking to expand your skillset, understanding how you can maximise customer relationships will be key to your success. We have developed this programme to be practical, fun and interactive. Participants will have the opportunity to learn and practice a number of key skills that will see successful results, and are encouraged to bring real life examples to the course so that learning can be translated to real world scenarios. This course will help participants: Learn how to plan growth and increase revenue from existing accounts Develop skills to build and develop essential relationships to increase value and visibility Learn how best to create loyalty and customer satisfaction Identify how to set account targets and development plan for building contacts and cross-selling Develop persuasion and influencing skills to better define needs and develop opportunities Learn how to add value at all stages; plus gaining competitive advantage Develop an up-selling, cross-selling strategy 1 Performance metrics for account management Introduction to the PROFIT account management model Using practical tools to measure account performance and success Planning your account strategy - red flags and green lights 2 Relationships for account management How to build and manage key relationships Producing a 'relationship matrix' Developing a coach or advocate 3 Setting objectives for your account Developing an upselling cross-selling strategy Setting jointly agreed goals, objectives and business plans Planning session 4 Feedback and Retention - building loyal and satisfied customers How to monitor and track your customer's satisfaction Building a personalised satisfaction matrix Customer service review meetings 5 Influence Getting your message and strategy across to C-level contacts Being able to better develop a business partnership within an accountes 6 Teamwork and time management Working with others to achieve your account goals Managing and working with a virtual team Managing your time and accounts effectively 7 Gaining commitment and closing the sale Knowing when to close for commitment How to ask for commitment professionally and effectively Key negotiation skills around the closing process - getting to 'yes' Checklist of closing and negotiation skills Practice session

Maximising the team's sales capability is the key aim for any sales manager. When sales people struggle to hit their targets, it falls to the sales manager to provide support and help colleagues to find their way again. One of the most effective techniques for sales managers to improve and maintain sales performance is by providing live sales coaching. Sales coaching encourages sales people to find their own solutions and take responsibility for their own development. This course will help participants: Develop people to fulfil their sales potential Provide motivational feedback Identify strengths and weaknesses of their team members Understand personal learning styles Identify and adapt for different personality styles Prepare and conduct on-the-job observations Motivate sales people to greater performance 1 How is sales coaching different from sales training? What is coaching? Discover how coaching empowers sales people Learn the best time to use sales coaching Decide which people should be coached first Creating a development plan 2 Understanding learning, behavioural and communication styles Use practical tools to help you assess individual styles Tap into the essence and energy of the person you are developing Understand your own learning, behavioural and communication preferences Develop a strategy to adopt for each member of your team Discover what motivates you and your salespeople to perform Appreciate how this knowledge will improve your sales conversion 3 Using the GROW coaching model Learn the secrets of a successful coaching session Discover the importance of SMART objectives and instructions Understand and capture what coachees are currently doing right Develop their problem-solving and decision-making skills Help your colleagues crystalise their plans and actions Provide follow-up opportunities to embed the learning 4 Giving motivational feedback Understand why effective feedback is so powerful in sales Learn key models for motivational feedback Discover how to manage and structure more difficult conversations Understand the power of positive reinforcement Encourage sales people to coach and support colleagues 5 Putting it into practice Use realistic scenarios to provide opportunities for practice Discover what it feels like to be coached Receive immediate feedback on your coaching style Share common performance issues with fellow sales managers Create a personal development plan 6 Preparing on-the-job observations and joint visits Build a strategy for coaching and team development Prepare an observation template for effective coaching Learn the key elements of preparation for your next coaching session Agree common areas to focus on with coachees 7 Action planning Personal action plans

This workshop will provide participants with the insight and skills to be more effective business networkers, face-to-face and online. The approach taken is to build on the strengths people already have and their successes. It is easier to develop what you already have than to try and develop skills that do not come easily. Being yourself is the most effective tool for business networking and building relationships. This course will help those attending: Appreciate the importance of networking, and different forms of networking Understand the dynamics of communication that are specific to networking Become more confident and assured when 'working' a room Improve their influencing skills, especially with people who are experts and in positions of authority 'Sell' themselves and promote their company Identify and manage their profiles using online social networking sites Use effective follow-up to maintain active contacts and connections Select the correct networking groups, clubs and events Create their own personal network 1 The importance, and different types, of networking Personal objectives and introductions Test networking session Examples of the importance, purpose and format of various types of networking, and benefits you can expect 2 How to work a room - preparation and strategy Three things to know before you attend any event Non-verbal communication and art of rapport Breaking the ice - worked examples with practical demonstration 3 Communication dynamics in networking - the power of the listening networker Why it is better to listen than talk Effective questioning and active listening Creating a natural and engaging conversation, 1-2-1 and in a larger group 4 Assumptions when networking How to use the 'instant judgement' of others to your advantage What assumptions are you making? How to keep an open mind 5 Business networking etiquette Meeting and greeting at a business networking event - approaching complete strangers and introducing yourself Socialising: joining and leaving groups easily Making a good first impression in 30 seconds The use of status when networking 6 Making connections Asking for cards, contact details and referrals Gaining a follow-up commitment Some tips and tricks 7 Business networking rehearsals Practice sessions 8 Personal business networking online Overview of different types of networking sites - there is a lot more out there than just Facebook! Examples of creating an effective profile Using social networking effectively - case studies and application 'Advanced' applications - blogs, articles, twitter, feeds, etc. Online demonstration and examples 9 Building relationships - follow-up and follow-through Maintaining a good database Developing a contact strategy with different types and levels of contact How to analyse your contact base

Take your sales people from average to high performance. Motivate and develop experienced sales professionals with some new insights and learning. Applying NLP principles, techniques and models, this workshop will introduce the core attitudes and behaviours that differentiate the excellent sales person from the average one. The programme will help participants: Understand and adopt the mindset and beliefs needed for sales excellence Build rapport and connect with buyers at a deeper and more personal level Recognise some of the thinking and language patterns that make each individual unique Ask powerful questions to further understand the unique world of the individual and how they make decisions Apply tools and techniques to empathise with clients - seeing things from their perspectives Tailor their sales approach to the individual buyer's style, and talk in their language Influence with integrity and sell to organisations and individuals successfully 1 Introduction Aims and objectives of the programme Personal introductions and objectives Workshop overview 2 An introduction to NLP and sales excellence with NLP An overview of NLP and applying it to selling The pillars of NLP The NLP model of communication The difference that makes the difference 3 Building enhanced rapport Defining rapport and why it is important when selling Going beyond the initial small talk Building relationships with individual decision-makers Matching and mirroring Levels of rapport 4 Understanding the buyer's personal buying map How we take in, filter and process information How we judge others based on our own experiences of the world The different ways in which we communicate when selling Recognising and understanding the language and thinking patterns of others Adapting your sales communication style to different buyers 5 Making sense of the buying process How we filter information through our senses Understanding how we see, hear and experience the world Visual, auditory and kinaesthetic buyers Listening for key insights What different buyers want from you to help them to buy Applying sensory awareness to the sales process 6 Successful sales mindset The connection between thoughts and actions The sales beliefs of excellence Identifying negative thoughts and beliefs that are holding you back How to change your mindset Adopting the sales beliefs of excellence 7 Powerful questions Reviewing and honing your questioning skills Understanding the questions that great sales people ask Avoiding assumptions Clean language questions Getting to the bottom of it - precision questions Turbo-charging how you qualify 8 Influencing with integrity Understanding empathy Stepping into the buyer's shoes Speaking the buyer's language Tailoring your sales approach to the individual Match, pace, lead - how to take your buyer with you 9 Putting it all together Personal learning summary and action plans

This practical, enjoyable day will give you the tools to go and do your job effectively and the opportunity to practise using them in a safe and supportive environment before putting them into practice for real back in the workplace. To inspire, you need to be inspired!Having the right set of skills, tools and techniques helps us to manage in a productive and beneficial way. Above all, the workshop will inspire you with the determination to engage with the people you manage to produce greater levels of achievement. This workshop will enable you to: Understand what the role of the manager is Engage and inspire a team to perform Recognise the range of styles appropriate for different situations and how your communication style impacts Provide clear direction on your team's purpose, role and responsibilities Understand how to create a motivating environment for those who report to you Hold them accountable for delivery Hold performance conversations Review and evaluate your learning and have a plan to take back and implement at work 1 Bringing the role to life Starting the day with sharing your current ideals and approaches using the pre workshop task Understanding what you bring to your role and your objectives for the day 2 The role and responsibilities of a manager: an overview Responsibility and accountability Producing results Managing teams Developing individuals 3 Communication excellence The model of a team communicator What type of communicator are you and what about your team? Practical interactive group exercise 4 Your role as a team leader - shaping how we work using the organisation's values Your role Your team's role Enabling your team to deliver in a changing mindset 5 Engaging and motivating your team Exercise: using a leadership model to explore how you are enabling your team to engage with current change, what's getting in the way and how you will manage this in your organisational context Peer and group task and discussion 6 Addressing motivation at team and individual level in times of change Exercises:Identifying approaches to motivating people at work based on a work based model of motivation: team taskExploring a behavioural model of motivation: team discussion Review in plenary 7 Holding people accountable The work cycle model of team performance: Agree purposeSet objectivesMonitor performanceProvide feedbackCompliance vs. commitment Professional discussion in small groups Exercise: Practising short conversations using peer coaching support 8 Review of learning and action planning Personal review and action planning Group review of learning Evaluation

No-one in business will succeed if they are not financially literate - and no business will succeed without financially-literate people. This is the ideal programme for managers and others who don't have a financial qualification or background but who nonetheless need a greater understanding of the financial management disciplines essential to your organisation. This course will give the participants a sound understanding of financial reports, measures and techniques to make them even more effective in their roles. It will enable participants to: Overcome the barrier of the accountants' strange language Deal confidently with financial colleagues Improve their understanding of your organisation's finance function Radically improve their planning and budgeting skills Be much more aware of the impact of their decisions on the profitability of your organisation Enhance their role in the organisation Boost their confidence and career development 1 Review of the principal financial statements What each statement containsOutlineDetail Not just what the statements contain but what they mean Balance sheets and P&L accounts (income statements) Cash flow statements Detailed terminology and interpretation Types of fixed asset - tangible, etc. Working capital, equity, gearing 2 The 'rules' - Accounting Standards, concepts and conventions Fundamental or 'bedrock' accounting concepts Detailed accounting concepts and conventions What depreciation means The importance of stock, inventory and work in progress values Accounting policies that most affect reporting and results The importance of accounting standards and IFRS 3 Where the figures come from Accounting records Assets / liabilities, Income / expenditure General / nominal ledgers Need for internal controls 'Sarbox' and related issues 4 Managing the budget process Have clear objectives, remit, responsibilities and time schedule The business plan Links with corporate strategy The budget cycle Links with company culture Budgeting methods'New' budgetingZero-based budgets Reviewing budgets Responding to the figures The need for appropriate accounting and reporting systems 5 What are costs? How to account for them Cost definitions Full / absorption costing Overheads - overhead allocation or absorption Activity based costing Marginal costing / break-even - use in planning 6 Who does what? A review of what different types of accountant do Financial accounting Management accounting Treasury function Activities and terms 7 How the statements can be interpreted What published accounts contain Analytical review (ratio analysis) Return on capital employed, margins and profitability Making assets work - asset turnover Fixed assets, debtor, stock turnover Responding to figures EBIT, EBITEDIA, eps and other analysts' measure 8 Other key issues Creative accounting Accounting for groups Intangible assets - brand names Company valuations Fixed assets / leased assets / off-balance sheet finance

The often-used phrase, 'just the receptionist', completely misrepresents the role. An excellent receptionist is a most valuable resource for any organisation. This programme has been designed specifically to deal with the essential skills necessary to represent the organisation to the best possible effect. It will also help you get the most out of your working day. There are six key reasons to take part in this workshop. It will help you: See your role in a new light Develop your communication skills Deal with different types of customer and situation Boost your confidence Cope in a pressurised environment Get more satisfaction from your working day 1 Introduction Workshop objectives and personal objectives The challenges of 21st century communication What makes an excellent point of Reception? And why is it so important? Who and where are our customers? As a customer, how do you like to be treated? What makes people feel valued? Objective and subjective aspects of customer service 'Micro moments' that shape the relationship 2 Communication on reception Definition of communication Barriers to good communication The 'recipe' of verbal, vocal and visual aspects of communication Differences between communicating face-to-face and on the telephone Communication 'leaks' The primitive human response The impact of visual communication - body language, gesture and facial expression Voice - tone, speed, volume, pitch, clarity, inflection, pacing Words - positive words and phrases compared with negative terminology Professional greetings face-to-face Steering the conversation with effective questioning 3 Telephone excellence How we use the telephone Qualities of the telephone Non-verbal communication on the telephone - what aspects can be 'seen' by the other person? Professional telephone etiquette Taking and leaving messages - key points that can help customers, colleagues and the organisation Clarifying information 4 Listening skills for accuracy and relationship building How accurate are your listening skills? What are the challenges for accurate listening? Active / empathetic listening 5 Creating a rapport by 'style flexing' Understanding how different people communicate Shaping our message to the other person so that they feel understood How changing situations can alter communication needs 6 Confidence and assertiveness Recognising different styles of behaviour - aggressive, passive and assertive Qualities of assertive communication - verbal, vocal and visual Assertive techniques - basic, persistence, negotiation / empathetic Demonstrating confidence 7 Coping in a pressurised environment Words - the most useful ones to use with stressed people and identifying the 'red rag' words Challenging situations - what do you find difficult and how do you respond? Dealing with outbursts of anger Bringing non-stop talkers back from their tangent Constructive ways to say 'no' 8 Pulling it all together Action plans Summary of key learning points

The market for professional services is becoming increasingly competitive, with some firms and individuals becoming very effective at winning new work, leaving others lagging way behind. Given the choice between spending time on client work and business development work, we all tend to choose that which we feel to be easier, more attractive and more aligned with our image of ourselves. We stay within our comfort zones, we focus on client work, and we only resort to business development work when we have to, which can also lead to 'feast or famine' syndrome. The programme will help participants: Understand the professional business development approach and the style that is appropriate for their business and their clients Follow a process to guide their conversations and business development meetings Prepare thoroughly for a business development meeting/contact with a client to ensure they use their time efficiently and maximise results Create a great first impression and professional opening to a conversation Ask open questions and listen effectively in order to spot opportunities, understand needs and progress the opportunity Identify and understand buying and decision-making processes and criteria Skilfully and confidently handle questions and objections Sell the benefits of their services and approach over those of their competitors Progress the sale by agreeing next steps and gaining commitment appropriately 1 Introduction Aims and objectives of the programme Personal introductions and objectives Workshop overview 2 An introduction to business development and selling for professionals What is selling? Who are you selling to? The buying experience What clients want The four-step business development process The business development cycle and pipeline management Upselling and cross-selling as well as winning new clients 3 Networking and generating leads What is networking? Networking objectives It's not what you know but who you know Asking for referrals and introductions Making appointments from networking activity 4 Opening the sales relationship/sales meeting What potential customers are thinking Judging first impressions Creating positive first impressions Building rapport and creating interest and impact Earning the right 5 Core communication skills for professional selling Overcoming barriers to listening The art of listening Questioning refresher Types of questions Questioning funnel 6 Understanding and identifying needs and opportunities Identifying the questions to ask to identify needs and opportunities Questions to move us through the buying and selling process Understanding their buying processes Asking questions that position you as a 'trusted adviser' The questions that give you a competitive advantage Knowing when you have asked enough questions 7 Introducing solutions Tailoring your 'pitch' to the client Speaking the client's language Using features and benefits Applying the benefit cycle 8 Handling objections and concerns Identifying the typical objections and concerns Understanding why clients raise objections and concerns Following a structure for handling objections Handling the price objection 9 Gaining commitment Knowing when to close The art of checking Recognising buying signals Small c and big C 10 Putting it all together Personal learning summary and action plans