Microsoft Excel is the world's most popular spreadsheet program, learning how to use the software with Osborne Training shows that you've taken one of the best Excel training courses available. A comprehensive training course with up to date material to practice at home and during your class. You will also be provided a step by step manual of all the tricks you can do using Excel spreadsheets to gain better management reporting and budgeting skills. It is a fundamental programme for professional Accountants. Excel spread sheets are the most powerful tool, extensively used for reporting and analysis. Having advanced skills on excel can excel your career and help you to stand ahead of the competitive job market. Advanced skills on excel is a must for any potential professional accountants. You will receive an attendance certificate once you complete the course successfully. Excel Course Content Creating worksheets, formatting text Simple and complex formulas Handling rows and columns Autocomplete, using styles, headers and footers, Average, max and min functions and using charts. Use of IF Formula Summing Techniques Cell References Formula Linking Sumifs Tables and Bordering Look up References (Vlookup, Hlookup,etc) Data Validation Conditional Formatting Date & Time Formulas Charts & Graphs Protection & Security Creating Pivot Table Pivot Table Analysis
This intensive one-day IACCM-approved programme helps participants develop the skills, knowledge and competencies required to plan for and carry out effective negotiations in a range of different environments. By the end of the programme participants will be able to: Understand the basic concepts of negotiation and how it adds value to the organisation Recognise the stages of negotiation and the skills required at each stage Make use of tried-and-tested negotiation planning tools Apply a range of negotiation tools and techniques to support the organisation in obtaining value for money, quality and fit-for-purpose outcomes Set negotiation objectives Appreciate the importance of interpersonal skills in maximising the opportunities for reaching win/win agreements 1 Welcome Introductions Aims and objectives Plan for the day 2 Why negotiate? Understanding the negotiation context Negotiating with suppliers Negotiating with stakeholders 3 Understanding the process The phases of negotiation and what to do in each phase Before During After 4 Planning Appreciating the importance of planning Different approaches Identifying the key variables Setting objectives for each of them Practical negotiation planning exercise 5 Doing The key skills required, Communication Numeracy empathy Applying these skills in a role play: practical exercise 6 Close Review of key learning points Personal action planning
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
This Tableau Desktop Training intermediate course is designed for the professional who has a solid foundation with Tableau and is looking to take it to the next level. For Private options, online or in-person, please send us details of your requirements: This Tableau Desktop training intermediate course is designed for the professional who has a solid foundation with Tableau and is looking to take it to the next level. Attendees should have a good understanding of the fundamental concepts of building Tableau worksheets and dashboards typically achieved from having attended our Tableau Desktop Foundation Course. At the end of this course you will be able to communicate insights more effectively, enabling your organisation to make better decisions, quickly. The Tableau Desktop Analyst training course is aimed at people who are used to working with MS Excel or other Business Intelligence tools and who have preferably been using Tableau already for basic reporting. The course is split into 3 phases and 9 modules: Phase 1: AMPLIFY MODULE 1: CHECK ABILITIES Revision – What I Should Know What is possibleHow does Tableau deal with dataKnow your way aroundHow do we format chartsHow Tableau deals with datesCharts that compare multiple measuresCreating Tables MODULE 2: COMBINE DATA Relationships Joining Tables – Join Types, Joining tables within the same database, cross database joins, join calculations Blending – How to create a blend with common fields, Custom defined Field relationships and mismatched element names, Calculated fields in blended data sources Unions – Manual Unions and mismatched columns, Wildcard unions Data Extracts – Creating & Editing Data extracts MODULE 3: ADVANCED CALCULATIONS Row Level v Aggregations Aggregating dimensions in calculations Changing the Level of Detail (LOD) of calculations – What, Why, How Adding Table Calculations Phase 2: ANALYSE MODULE 4: EXPAND APPLICATION Making things dynamic with parameters Sets Trend Lines How do we format charts Forecasting MODULE 5: ADVANCED MAPPING Using your own images for spatial analysis Mapping with Spatial files MODULE 6: DATA COMPARISONS Advanced Charts Bar in Bar charts Bullet graphs Creating Bins and Histograms Creating a Box & Whisker plot Phase 3: ACT MODULE 7: ADVANCED DASHBOARDS Using the dashboard interface and Device layout Dashboard Actions and Viz In tooltips Horizontal & Vertical containers Navigate between dashboards MODULE 8: PRESENT STORIES Telling data driven stories MODULE 9: ENABLE DECISIONS What is Tableau Server Publishing & Permissions How can your users engage with content This training course includes over 25 hands-on exercises and quizzes to help participants “learn by doing” and to assist group discussions around real-life use cases. Each attendee receives a login to our extensive training portal which covers the theory, practical applications and use cases, exercises, solutions and quizzes in both written and video format. Students must bring their own laptop with an active version of Tableau Desktop 2018.2 (or later) pre-installed. What People Are Saying About This Course “Course was fantastic, and completely relevant to the work I am doing with Tableau. I particularly liked Steve’s method of teaching and how he applied the course material to ‘real-life’ use-cases.”Richard W., Dashboard Consulting Ltd “This course was extremely useful and excellent value. It helped me formalise my learning and I have taken a lot of useful tips away which will help me in everyday work.” Lauren M., Baillie Gifford “I would definitely recommend taking this course if you have a working knowledge of Tableau. Even the little tips Steve explains will make using Tableau a lot easier. Looking forward to putting what I’ve learned into practice.”Aron F., Grove & Dean “Steve is an excellent teacher and has a vast knowledge of Tableau. I learned a huge amount over the two days that I can immediately apply at work.”John B., Mporium “Steve not only provided a comprehensive explanation of the content of the course, but also allowed time for discussing particular business issues that participants may be facing. That was really useful as part of my learning process.”Juan C., Financial Conduct Authority “Course was fantastic, and completely relevant to the work I am doing with Tableau. I particularly liked Steve’s method of teaching and how he applied the course material to ‘real-life’ use-cases.”Richard W., Dashboard Consulting Ltd “This course was extremely useful and excellent value. It helped me formalise my learning and I have taken a lot of useful tips away which will help me in everyday work.” Lauren M., Baillie Gifford “I would definitely recommend taking this course if you have a working knowledge of Tableau. Even the little tips Steve explains will make using Tableau a lot easier. Looking forward to putting what I’ve learned into practice.”Aron F., Grove & Dean “Steve is an excellent teacher and has a vast knowledge of Tableau. I learned a huge amount over the two days that I can immediately apply at work.”John B., Mporium
This workshop-based bite-size will provide space to explore some practical tools and ideas on how to be more resilient when faced with challenging and tough situations. There is an opportunity to do a self assessment and bring it to the day as a means to identify areas to work on and begin to master skills that will enhance resilient thinking. There will be time to explore what resilience is and understand the range of practical tools and techniques available that can be used beyond the workshop itself. By the end of the workshop participants will be able to: Discuss and evaluate their personal strengths and areas for development in being more resilient at work Understand what resilience involves and how to identify and challenge their own beliefs that undermine resilience Understand the four aspects of resilience - confidence, adaptability, building support and maintaining a clear perspective Understand how to use resiliency tools to help to cope better with the challenge of change Review and evaluate their learning and have an action plan to take back and implement in the workplace 1 Welcome, introductions and objectives Breaking the ice 2 Identifying current challenges in relation to work How we handle these challenges 3 Defining resilience and how and why it helps our personal effectiveness and thinking 4 Resilience skills and how to develop them 5 Learning a resilience tool that promotes new ways of thinking / working 6 Review and evaluation of learning Action planning
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
If you want to be better at making to-do lists or managing time better this is NOT for you! The time challenges we all face at work need to be addressed with a different approach. This 'bite-size' session takes a fresh approach to how we deal with time personally and challenges the belief that we don't always have enough time. The workshop will be participative, interactive, and will cover the personal relationship we have with time and how this impacts on dealing with challenges and ever-changing priorities on a daily basis at work. The workshop will give you some practical tools and ideas on dealing with your thieves of time from a different perspective, including interruptions and emails. To enable participants to organise and use their time effectively, using strategies to help with both 'thinking' and 'doing' that are fit for purpose. This workshop will enable you to: Recognise the barriers to effective time management and set goals to overcome them and get things done Understand how their mindset affects how they use time and use better ways to deal with the inbuilt patterns of behaviour this produces when at work Plan for tasks and projects in a productive way Use some new tools and techniques to tackle time thieves, including email and interruptions Review and evaluate their learning and have an action plan to take back to work 1 Welcome, introductions and objectives Exploring your relationship with time and how you focus your mind on daily work pressures in relation to time Past, present and future - where do you focus your energy at work? Time thieves - exploring the results of the pre-workshop questionnaire and learning strategies to deal with the roots of your time thieves 2 Personal strategies and tools: having a new mindset Emails, interruptions and curve balls Review and evaluation of learning Action-planning
The 2-day Coaching and Mentoring for Managers course is designed for organisations that want their managers and team leaders to apply practical coaching and mentoring skills in everyday work situations in order to develop the performance of those they are responsible for, as well as improving communication within the business. Previous attendees have included chief executives, general managers, and HR managers, right through to production line supervisors and office staff. In fact, anybody that has to work as part of a team and relies on other people's efforts will benefit from this programme. Course Syllabus The syllabus of the Coaching and Mentoring for Managers course is comprised of four modules, covering the following: Module One Introduction to Coaching and Mentoring Exploding the myths surrounding coaching Benefits of coaching and mentoring The role of a coach and mentor How to avoid everyday interference that takes your time away from coaching people to achieve results How motivation works The difference between mentoring, coaching, directing, supporting & delegating, and learning when it is necessary to apply them Why coaching is an action orientated partnership purely focused on measurable results Coaching and mentoring outcomes Module Two Managing a Coaching Session The most important skills of a business coach The key characteristics of a good coach How to ask powerful coaching questions Opportunity to role-play using the STAR/GROW model Module Three Mentoring in Action Mentoring suggestions The first meeting Between first and second meetings The second meeting The Experiential learning cycle Model discussions Frequent questions asked by Mentors Duration of mentoring End of relationships Module Four Putting Learning into Practice Building a bank of great coaching questions Demonstration of what has been taught in a live coaching/mentoring meeting Individual feedback from a professional coach Creating SMART action plans Getting started as a work coach/mentor Group review and feedback on new learning Action steps for new coaches Scheduled Courses Unfortunately this course is not one that is currently scheduled as an open course, and is only available on an in-house basis. Please contact us for more information.
SAP Training Online | Sap Training in London, UK What is SAP? SAP is one of the largest ERP(Enterprise Resource Planning) software in the world. It provides end to end solution for Financials, Manufacturing, Logistics, Distributions etc. SAP applications, built around their latest R/3 system, provide the capability to manage financial, asset, and cost accounting, production operations and materials, personnel, plants, and archived documents. The R/3 system runs on a number of platforms including Windows and MAC and uses the client/server model. SAP Career Potential You can become a SAP consultant. SAP consultants analyze, design, and configure new computer software and systems in accordance with their employers' or clients' specifications, as well as write programs such as forms, specifications, and interfaces. They also test new interfaces to ensure that system workflows are optimized and interact with end-users to make changes as requested and obtain feedback. As a SAP consultant, you could expect to earn £80,000-£150,000 per year. Which SAP Module Osborne Training offers training on various sap modules such as Financial and Controlling Sales and Distribution Material Management CRM SRM HANA And many more... Study Options Instructor-Led Live SAP Online Training Students attending training through Online LIVE Training have a real-time, Live Instructor-Led student experience through the world-class Virtual Learning Campus. Online LIVE Training provides an engaging live classroom environment that allows students to easily interact with instructors and fellow students virtually. Classroom-Based Live SAP Training in London Osborne Training offers evening sessions for classroom-based training, where an experienced Tutor/Consultant goes through the whole SAP Training course from the London campus. Only selected modules are offered from the London campus. Free Certification from Osborne Training on completion. You may attempt for SAP certification exams online to get certificate directly from SAP. Syllabus varies depending on the module take. Please send a query to receive full syllabus information.
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