Discover Excel 2019 and become confident in using spreadsheets
Let's build sophisticated visualizations and dashboards using Sankey diagrams and geospatial, sunburst, and circular charts and animate your visualizations. We will also cover advanced Tableau topics, such as Tableau parameters and use cases and Level of Detail (LOD) expressions, spatial functions, advanced filters, and table calculations.
Your guide to practice and learn to excel in Word 2019.
An accredited qualification for current and prospective managers. This programme gives Team Leaders & Managers the skills, disciplines and confidence to manage their team effectively and add a great deal more value to the organisation - where they have to apply their learning in order to achieve the highly coveted ILM qualification. One of the main responsibilities of a manager is to make sure that employees are satisfied with their job and reaching their full potential. A manager who can energise his or her employees will have a team which has a much greater potential and capability of achieving company goals and objectives. It is therefore vital that a manager has the essential skills to fully support and lead their team to success. This 3-day programme brings together the key leadership skills that you will need to be an effective manager so that you can return to the workplace and deliver tangible results. All of our ILM Programmes are provided in partnership with The BCF Group, which is the ILM Approved Centre we deliver under. Course Syllabus The syllabus of the ILM Level 3 Award in Leadership and Management course is split into three main modules, covering the following: Module OneSolving Problems and Making Decisions What is a problem? How to identify a problem, its nature, scope and impact Identifying the root cause Understanding how to interpret information to solve a problem What is involved in making an informed decision? Generate ideas/solutions- creative thinking techniques How to evaluate your options Finding the critical path Having confidence to commit to a decision Planning approach Communicating the decision Implementing the plan Module TwoUnderstanding Leadership What is leadership? Recognise the differences and similarities between leadership and management Qualities and skills of a leader Action Centered Leadership - Team, Task, Individual - John Adair Varying leadership styles Evaluating a range of leadership models and their significance for: Task, Performance, Culture, Relationships Reflect on your own leadership styles and behaviours Create an action plan to enhance your performance Module ThreeUnderstanding the Communication Process in the Workplace Identify what is effective communication Understand the importance of effective communication at work Recognise the different ways we communicate Recognise possible barriers to communication and how to overcome them Johari's window - communication flows How others will perceive and interpret the information you have provided Active listening Developing questioning skills Understanding the significance of non-verbal communication and body language Developing sensory acuity and how to use it effectively in the workplace In-House & Classroom Courses Available Online We have developed an alternative to traditional face-to-face training that continues to provide a full learning experience, and allows delegates to learn effectively whilst self-isolating from home. This is how it looks: Delegates booked on Classroom and In-House courses will continue to have access to their trainer online throughout the days that the course is booked to run. Prior to a delegate's course start date, they will be enrolled on our e-learning platform (in partnership with BCF Group) for the course they are booked on to. They will also be given contact information for their trainer, and details of how to access the online workshops. Delegates will not require any special IT equipment. A desktop computer, laptop, tablet, or a mobile phone with internet and audio capability is all that is required. Delegates taking ILM Qualifications will then proceed to the book review, video review and work based assignments with 12 months tutor support as appropriate, and in line with our previous arrangements. We hope you agree that this blended learning experience represents the safest way to continue supporting our clients and delegates during the Coronavirus disruption. In-House Courses As well as being one of the most popular open courses, we can also arrange this course as an in-house programme for companies and organisations who wish to develop a number of their managers at the same time, and would find an in-house course at their own premises much more suitable. Scheduled Courses On-Demand Course - Self-paced The online course option includes a comprehensive course manual, book reviews, useful guides and personalised tutor support. You will also be able to upload assessments online and receive online feedback. Our online training option gives you 24/7 access to our learning platform for the duration of your course. The programme elements and assignments can be completed as quickly as you like, with the only time limit being that the final assignment has to be submitted to ILM within 12 months of your registration on the programme. Cost: £695 + vat Dickson Training Ltd Founded in 1985 in Yorkshire, we have built an impressive and loyal client base. Our partnerships are built by consistently delivering outstanding development solutions and working in close collaboration with our clients, resulting in us becoming a leading UK and international training provider.
Based on our extensive work and experience with leaders, both in the private and public sectors, this ILM Level 5 Coaching and Mentoring programme has been designed to develop the capability of leaders to positively impact the performance of individuals and teams. We are experts at unlocking peak performance. Coaching and mentoring improves relationships, performance and engagement. This programme has been created to sharpen a leader's skills - enabling them to balance control, commitment and empowerment through productive conversations with individuals and teams. Scroll down to find out more about this ILM Level 5 qualification, or use the buttons below to jump straight to the scheduled course dates and prices. All of our ILM Programmes are provided in partnership with The BCF Group, which is the ILM Approved Centre we deliver under. Course Syllabus The syllabus of the ILM Level 5 Qualification in Business Coaching and Mentoring is comprised of six modules, covering the following: Module OneIntroduction 1.1) Explore the myths 1.2) What is coaching and mentoring? 1.3) What is business coaching? 1.4) Thoughts and perceptions 1.5) 7 competencies of a coach 1.6) Definitions - Mentoring / Consulting / Coaching / Therapy / Counseling Module TwoModels and Practice 2.1) The Wheel of Life 2.2) Johari's Window 2.3) KASH - Knowledge, Attitude, Skills, Habits of an effective coach 2.4) STAR / GROW model 2.5) Effective use of Paradigm cards 2.6) Practice and feedback Module ThreeBuilding the Relationship 3.1) Self-management 3.2) How motivation works 3.3) Personality & behavioural traits 3.4) Rapport and trust Module FourCommunication and Practice 4.1) Non-verbal communication 4.2) Effective communication 4.3) Questioning through 2nd/3rd/4th level questioning 4.4) Building a bank of coaching questions 4.5) Practice and feedback Module FiveStructure 5.1) Introduction 5.2) The coaching cycle 5.3) How to give feedback 5.4) The COMET model 5.5) Executive coaching 5.6) Psychometrics 5.7) Closing the coaching session Module SixWell-Formed Outcomes 6.1) Challenge and focus steps 6.2) Coaching goals 6.3) Establishing the gap analysis 6.4) Using diagnostic tools 6.5) SMART objectives 6.6) Designing & planning focus steps 6.7) Gaining commitment 6.8) Practice and feedback Who is it for? Business coaching is the skill to have in today's rapidly changing business climate. People and team development through business coaching is fast, efficient and cost effective, and will get you measurable results. The ILM Level 5 Qualifications in Business Coaching and Mentoring are highly accessible and have been designed for all tiers of director, management and supervisory level, or indeed anyone involved in people development. With a business-relevant, tried-and-tested approach, we encourage participants to bring live business issues and case histories with them on the course. Accreditation Upon completion of this programme all attendees will receive the 'ILM Endorsed Programme in Business Coaching & Mentoring' certificate. Participants will also be eligible to receive ILM letters after their name; either AMInstLM (Affiliate/Associate Member Institute Leadership & Management) or MInstLM (Member Institute Leadership & Management). As with all ILM Accredited Programmes, participants will need to complete the post-programme activity in order to achieve their full 'ILM Level 5 Certificate in Coaching and Mentoring in Management' certificate. These elements have been designed in order to show to the Institute of Leadership and Management (ILM) that you are able to put the skills and techniques learned on the programme into practice. Full support and guidance is provided for completing these final elements. Required Activities Pre-Course We ask you to come prepared with issues which you are currently experiencing that you would be happy to discuss and be coached on. We also send out a short document containing questions and exercises which will help our coaches understand you better and work with you in order to receive the best training. Post-Course To achieve this ILM qualification, participants will have to complete the following post-course activities: 3 x work-based assignments need to be completed within 1 year from attendance and registration. Embedded in the assignments, the Certificate will require delegates to complete 18 hours of coaching or mentoring activity with 2-3 people. The Diploma will require delegates to complete 54 hours of coaching or mentoring with 4-9 people. Tutor guided learning will take on the format of book and video reviews with ongoing tutor guidance and support via phone, Skype or face-to-face. Optional: Self-initiated 2 x 45 min executive coaching sessions per delegate to offer a coaching best practice view. Course Material Each participant will be issued with a workbook to assist them both during and after the course, which will contain information, guidance and forms to assist with the coaching sessions. Participants will also complete a Paradigm psychometric report and receive a year's membership with the Institute of Leadership & Management (ILM). In-House & Classroom Courses Available Online We have developed an alternative to traditional face-to-face training that continues to provide a full learning experience, and allows delegates to learn effectively whilst self-isolating from home. This is how it looks: Delegates booked on Classroom and In-House courses will continue to have access to their trainer online throughout the days that the course is booked to run. Prior to a delegate's course start date, they will be enrolled on our e-learning platform (in partnership with BCF Group) for the course they are booked on to. They will also be given contact information for their trainer, and details of how to access the online workshops. Delegates will not require any special IT equipment. A desktop computer, laptop, tablet, or a mobile phone with internet and audio capability is all that is required. Delegates taking ILM Qualifications will then proceed to the book review, video review and work based assignments with 12 months tutor support as appropriate, and in line with our previous arrangements. We hope you agree that this blended learning experience represents the safest way to continue supporting our clients and delegates during the Coronavirus disruption. Scheduled Courses On-Demand Course - Self-paced The online course option includes a comprehensive course manual, book reviews, useful guides and personalised tutor support. You will also be able to upload assessments online and receive online feedback. Our online training option gives you 24/7 access to our learning platform for the duration of your course. The programme elements and assignments can be completed as quickly as you like, with the only time limit being that the final assignment has to be submitted to ILM within 12 months of your registration on the programme. Diploma: £1,195 + vat | Certificate: £895 + vat Dickson Training Ltd Founded in 1985 in Yorkshire, we have built an impressive and loyal client base. Our partnerships are built by consistently delivering outstanding development solutions and working in close collaboration with our clients, resulting in us becoming a leading UK and international training provider.
This video course will help you learn all the basic and advanced concepts of Microsoft Excel 2019. You'll start with Excel basics and slowly move to the advanced concepts in Excel. Each section is accompanied by an exercise at the end to practice what you have learned.
Microsoft Project 2021 is a complete lifecycle project management tool that manages complex projects efficiently. This all-encompassing course molds you into an expert in project management with fundamentals to advanced techniques to handle projects of all sizes and gain confidence and proficiency in project planning, execution, and reporting.
In this course, we look at a number of advanced Excel techniques all aimed at helping you make sense of the numbers in your business. Each section in the course contains an exercise for practice and quiz. The course is created using Excel 2019/365 for Windows.
This course explains how huge chunks of data can be analyzed and visualized using the power of the data analyst toolbox. You will learn Python programming, advanced pivot tables' concepts, the magic of Power BI, perform analysis with Alteryx, master Qlik Sense, R Programming using R and R Studio, and create stunning visualizations in Tableau Desktop.
FREE Welcome class, introduction to the Foundation and Diploma in Clinical Hypnotherapy and to your journey into the study and practice of Clinical Hypnotherapy. This induction session will give you a Course Overview and show you where to find all you need to support your learning experience.