17144 Other courses in Tonbridge delivered Online

An in depth look at Pivot Tables and their powerful features to summarise and visualize your data. Course overview Duration: 1 day (6.5 hours) Our Excel – Pivot Table Specialist course is a comprehensive guide to working with Pivot Tables for those who need to learn more about the use of Pivot Tables to summarise and analyse information. This course is designed for existing experienced users of Excel. You should be a confident Excel user and be able to create and edit worksheets and write basic formulas. Objectives By the end of the course you will be able to: Build and customise Pivot Tables Group and sort information Filter information Use slicers and the timeline filter Add different summary calculations Create Pivot Charts Add calculated fields and items Content The anatomy of a Pivot Table Using a Pivot Cache Building a Pivot Table The Pivot Table interface Refreshing the Pivot Table Adding column, row, page and data fields Changing data orientation Showing data fields in columns or rows Drilling down to underlying data Setting Pivot Table options Format options Totals and filters options Display and printing options Data options Customising Pivot Tables Modifying field names Data formatting Changing field layout options Changing summary calculations Working with subtotals Filtering and sorting Filtering items Sorting data Value and label filters Creating top 10 reports Using the Search filter Using the Slicer tool Use the Timeline filter Grouping Grouping date fields Grouping numeric fields Adding your own groups Summary calculations Running totals Differences year on year, month on month % Differences year on year, month on month % of Row, Column, Total and other fields Pivot charts Pivot Chart rules Creating a Pivot Chart Working with your Pivot Chart Creating calculations Adding calculated fields Adding calculated items

Our OISC Level 2 preparation course is a two-day training course which offers a closer look at immigration advice and follows on from the training at Level 1. Throughout this course, we cover the syllabus at Level 2, as according to OISC standards. View our course dates below, delivered via Microsoft Teams Course Overview:   Take your expertise to the next level with our OISC Level 2 Accreditation Course. Designed as a two-day training program, this course builds upon the foundation established in Level 1 training. Delving deeper into immigration advice, we cover the Level 2 syllabus as prescribed by the OISC. Throughout this course, you’ll explore intermediate structures, frameworks, and concepts of UK immigration law. Gain insights into Humanitarian Protection and Asylum law, as well as the complexities of European Economic Area (EEA) free movement law. Additionally, our curriculum covers Business immigration law and Points-Based System (PBS) visas, along with the intricacies of detention and bail. We’ll also address major immigration offences to ensure a well-rounded understanding. Don’t forget to check out our Exam Technique Training (Level 2) which is designed to help prepare learners for their accreditation exam.   Course joining links, materials and instructions are sent out 24hours before the course starts. What is included in the OISC Level 2 Syllabus? The OISC Level 2 Training introduces new learning objectives for immigration adviser applicants. The course includes: Intermediate structures, frameworks and concepts of UK immigration law Humanitarian Protection and Asylum law European Economic Area (EEA) free movement law Business immigration law and PBS visas Detention and bail Major immigration offences   Join over 92% of satisfied customers who found their training with IAS useful and beneficial. You will also be provided with training materials to keep after completing the course. Who can attend the OISC Training Level 2 classes? The immigration procedures and structures introduced by the OISC Level 2 Course follow directly on from the objectives covered in the Level 1 Training. For this reason, participants should attend an OISC Level 2 class only after completing the Level 1 assessment. This course is also useful for participants who aim to become acquainted with UK immigration law. On the other hand, those who hold an OISC accreditation and wish to learn more about the latest development in this field can also benefit from this training class.

CRRUK equips professionals with the concepts, skills and tools to build conscious, intentional relationships, and to coach relationship systems of any size.

Free Level 5 QLS Endorsed Certificate | CPD Accredited | 150 CPD Points | Advanced Learning Materials | Lifetime Access

Do you want to prepare for your dream job but strive hard to find the right courses? Then, stop worrying, for our strategically modified Corporate and Business Finance Optimisation bundle will keep you up to date with the relevant knowledge and most recent matters of this emerging field. So, invest your money and effort in our 40 course mega bundle that will exceed your expectations within your budget. The Corporate and Business Finance Optimisation related fields are thriving across the UK, and recruiters are hiring the most knowledgeable and proficient candidates. It's a demanding field with magnitudes of lucrative choices. If you need more guidance to specialise in this area and need help knowing where to start, then StudyHub proposes a preparatory bundle. This comprehensive Corporate and Business Finance Optimisation bundle will help you build a solid foundation to become a proficient worker in the sector. This Corporate and Business Finance Optimisation Bundle consists of the following 30 CPD Accredited Premium courses - Course 01 :Financial Consultant Training Course 02 :Making Budget & Forecast Course 03 :Business Model Canvas for Business Plan Course 04 :Dealing With Uncertainity: Make Budgets and Forecasts Course 05 :Financial Modeling Using Excel Course 06 :Debt Management - Online Course Course 07 :Financial Management Course 08 :Financial Statements Fraud Detection Training Course 09 :Anti-Money Laundering (AML) Training Course 10 :Document Control Course 11 :Corporate & Strategic Communication Skills for Managers Course 12 :Excel Vlookup, Xlookup, Match and Index Course 13 :Basic Data Analysis Course 14 :Pension UK Course 15 :GDPR Course 16 :Bookkeeper Training Course Course 17 :Xero Accounting and Bookkeeping Online Course 18 :Quickbooks Online Course 19 :Sage 50 Accounts Course 20 :Commercial Law Course 21 :UK Tax Accounting Course 22 :Cost Control & Project Scheduling Course 23 :Dynamic Excel Gantt Chart and Timelines Course 24 :Understanding Financial Statements and Analysis Course 25: Financial Reporting Course 26: Learn to Read, Analyse and Understand Annual Reports Course 27: Accounting Basics Course 28: Excel Pivot Tables for Data Reporting Course 29: Personal Productivity Course Course 30: Time Management Training - Online Course 10 Extraordinary Career Oriented courses that will assist you in reimagining your thriving techniques- Course 01 :Career Development Plan Fundamentals Course 02 :CV Writing and Job Searching Course 03 :Interview Skills: Ace the Interview Course 04 :Video Job Interview for Job Seekers Course 05 :Create a Professional LinkedIn Profile Course 06 :Business English Perfection Course Course 07 :Networking Skills for Personal Success Course 08 :Boost Your Confidence and Self-Esteem Course 09 :Public Speaking Training Course 10 :Learn to Fight Procrastination Learning Outcome This tailor-made Corporate and Business Finance Optimisation bundle will allow you to- Uncover your skills and aptitudes to break new ground in the related fields Deep dive into the fundamental knowledge Acquire some hard and soft skills in this area Gain some transferable skills to elevate your performance Maintain good report with your clients and staff Gain necessary office skills and be tech savvy utilising relevant software Keep records of your work and make a report Know the regulations around this area Reinforce your career with specific knowledge of this field Know your legal and ethical responsibility as a professional in the related field This Corporate and Business Finance Optimisation Bundle resources were created with the help of industry experts, and all subject-related information is kept updated on a regular basis to avoid learners from falling behind on the latest developments. Certification After studying the complete training you will be able to take the assessment. After successfully passing the assessment you will be able to claim all courses pdf certificates and 1 hardcopy certificate for the Title Course completely free. Other Hard Copy certificates need to be ordered at an additional cost of •8. CPD 400 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Ambitious learners who want to strengthen their CV for their desired job should take advantage of the Corporate and Business Finance Optimisation bundle! This bundle is also ideal for professionals looking for career advancement. Please Note: Studyhub is a Compliance Central approved resale partner for Quality Licence Scheme Endorsed courses. Requirements To participate in this course, all you need is - A smart device A secure internet connection And a keen interest in Corporate and Business Finance Optimisation Career path Upon completing this essential Bundle, you will discover a new world of endless possibilities. These courses will help you to get a cut above the rest and allow you to be more efficient in the relevant fields.

Level 2, 4 & 5 QLS Endorsed Diploma | QLS Hard Copy Certificate Included | Plus 10 CPD Courses | Lifetime Access

English for Academic Purposes: English for Academic Purposes Would you like to enhance your critical thinking and research skills to gather, evaluate, and synthesise information from various sources? Then join our level 2 certificate in English for Academic Purposes course now! This level 2 certificate in English for Academic Purposes course explains how to create engaging discussion and writing skills. Additionally, this level 2 certificate in English for Academic Purposes course aims to create the value of reacting and actively listening. Through this level 2 certificate in English for Academic Purposes course, you will study the system for reading information, the goal of reading, and the correct meaning. Moreover, this level 2 certificate in English for Academic Purposes course covers correct speech and communication. If you want to learn advanced grammar and a broad range of vocabulary accurately in both written and spoken English, participate in our comprehensive level 2 certificate in English for Academic Purposes course quickly! Learning outcome of level 2 certificate in english for academic purposes course This level 2 certificate in english for academic purposes course helps to understand: How to make an interactive discussion. Also, this level 2 certificate in english for academic purposes course explains the importance of active listening and responding. Through this level 2 certificate in english for academic purposes course, you will learn the system for reading information, purpose of reading, and proper meaning. How to speak and communicate properly is included in this level 2 certificate in english for academic purposes lesson. You will learn to write fluently and accurately with this level 2 certificate in english for academic purposes course. Special Offers of this english for academic purposes Course This English for Academic Purposes Course includes a FREE PDF Certificate. Lifetime access to this English for Academic Purposes Course Instant access to this English for Academic Purposes Course Get FREE Tutor Support to this English for Academic Purposes Course English for Academic Purposes: English for Academic Purposes Elevate your academic journey with our Level 2 Certificate in English: English for Academic Purposes course! This comprehensive English: English course hones your discussion and writing skills, making your academic interactions engaging and impactful. Learn the value of active listening and effective reactions through our English: English curriculum. Master the system for reading information, understanding the goal of reading, and grasping the correct meanings with our English: English guidance. Additionally, refine your speech and communication skills with our English: English training. Enroll in our Level 2 Certificate in English: English for Academic Purposes course today and excel in your academic pursuits! Who is this course for? English for Academic Purposes: English for Academic Purposes Anyone, including students, beginners, or professionals, can take our level 2 certificate in english for academic purposes course. Requirements English for Academic Purposes: English for Academic Purposes To enrol in this English for Academic Purposes Course, students must fulfil the following requirements. To join in our English for Academic Purposes Course, you must have a strong command of the English language. To successfully complete our English for Academic Purposes Course, you must be vivacious and self driven. To complete our English for Academic Purposes Course, you must have a basic understanding of computers. A minimum age limit of 15 is required to enrol in this English for Academic Purposes Course. Career path English for Academic Purposes: English for Academic Purposes Your career is going to flourish with the support of this level 2 certificate in english for academic purposes course.

English for Academic Purposes: English for Academic Purposes Would you like to enhance your critical thinking and research skills to gather, evaluate, and synthesise information from various sources? Then join our level 2 certificate in English for Academic Purposes course now! This level 2 certificate in English for Academic Purposes course explains how to create engaging discussion and writing skills. Additionally, this level 2 certificate in English for Academic Purposes course aims to create the value of reacting and actively listening. Through this level 2 certificate in English for Academic Purposes course, you will study the system for reading information, the goal of reading, and the correct meaning. Moreover, this level 2 certificate in English for Academic Purposes course covers correct speech and communication. If you want to learn advanced grammar and a broad range of vocabulary accurately in both written and spoken English, participate in our comprehensive level 2 certificate in English for Academic Purposes course quickly! Learning outcome of level 2 certificate in english for academic purposes course This level 2 certificate in english for academic purposes course helps to understand: How to make an interactive discussion. Also, this level 2 certificate in english for academic purposes course explains the importance of active listening and responding. Through this level 2 certificate in english for academic purposes course, you will learn the system for reading information, purpose of reading, and proper meaning. How to speak and communicate properly is included in this level 2 certificate in english for academic purposes lesson. You will learn to write fluently and accurately with this level 2 certificate in english for academic purposes course. Special Offers of this english for academic purposes Course This English for Academic Purposes Course includes a FREE PDF Certificate. Lifetime access to this English for Academic Purposes Course Instant access to this English for Academic Purposes Course Get FREE Tutor Support to this English for Academic Purposes Course English for Academic Purposes: English for Academic Purposes Elevate your academic journey with our Level 2 Certificate in English: English for Academic Purposes course! This comprehensive English: English course hones your discussion and writing skills, making your academic interactions engaging and impactful. Learn the value of active listening and effective reactions through our English: English curriculum. Master the system for reading information, understanding the goal of reading, and grasping the correct meanings with our English: English guidance. Additionally, refine your speech and communication skills with our English: English training. Enroll in our Level 2 Certificate in English: English for Academic Purposes course today and excel in your academic pursuits! Who is this course for? English for Academic Purposes: English for Academic Purposes Anyone, including students, beginners, or professionals, can take our level 2 certificate in english for academic purposes course. Requirements English for Academic Purposes: English for Academic Purposes To enrol in this English for Academic Purposes Course, students must fulfil the following requirements. To join in our English for Academic Purposes Course, you must have a strong command of the English language. To successfully complete our English for Academic Purposes Course, you must be vivacious and self driven. To complete our English for Academic Purposes Course, you must have a basic understanding of computers. A minimum age limit of 15 is required to enrol in this English for Academic Purposes Course. Career path English for Academic Purposes: English for Academic Purposes Your career is going to flourish with the support of this level 2 certificate in english for academic purposes course.

Course Outcomes As an MHFAider® you will be able to:  Recognise those that may be experiencing poor mental health and provide them with first-level support and early intervention Encourage a person to identify and access sources of professional help and other supports Practise active listening and empathy Have a conversation with improved mental health literacy around language and stigma Discuss the MHFAider® role in depth, including boundaries and confidentiality Practise self-care Know how to use the MHFAider Support App® Know how to access a dedicated text service provided by Shout and ongoing learning opportunities with MHFA England Format Learners will be trained over four live sessions with an MHFA England Instructor Member, covering 14 hours of content in total. Learning takes place through a mix of instructor led training, group discussions, individual and group activities. Each session builds on the previous, enabling the learner to gain confidence in supporting others with a Mental Health First Aid action plan. We limit numbers to 16 people per course so that instructors can keep people safe and supported while they learn. We strive for all of our learning content to be as accessible and inclusive as possible. Takeaways Everyone who completes this course gets:  A hard copy workbook to support their learning throughout the course A digital manual to refer to whenever they need it after completing the course A wallet-sized reference card with the Mental Health First Aid action plan A digital MHFAider® certificate Access to the MHFAider Support App® for three years Access to ongoing learning opportunities, resources and exclusive events The opportunity to be part of the largest MHFAider® community in England Becoming a qualified MHFAider® Once you complete the Mental Health First Aid course, you can test your knowledge and build your confidence in your role as an MHFAider® with the internationally recognised MHFAider® qualification, RSPH Level 3 Award in Mental Health First Aid. Course Structure Session 1: Mental Health First Aid and the action plan The MHFAider® role and self-care Helpful and unhelpful language Useful models to support the role Session 2: What influences mental health? What is anxiety? Crisis first aid Active listening and empathy What are eating disorders? What is self-harm? What is substance misuse? Session 3: Applying the Mental Health First Aid action plan What is depression? What is suicide? Crisis first aid continued What is psychosis? Session 4: Recovery and lived experience Boundaries in the MHFAider® role Moving forward in the MHFAider® role My MHFA action plan

Level 5 QLS Endorsed Course | Endorsed Certificate Included | Plus 5 Career Guided Courses | CPD Accredited