17367 Other courses in Shepshed delivered Online

Sharing a radical change in thinking from Service to Person centred

Course Objectives At the end of this course you will be able to: Work with advanced lookup and reference functions Create macros to automate common tasks Use advanced techniques to analyse data Create PivotTables and PivotCharts Work with data validation tools Import and export data ' Customer Feedback Best Training Ever! Just finished a bespoke 1-1 training course in Excel Advanced, Macros & VBA. Pedro is an excellent trainer, imparting his skills and knowledge in the best way - appropriately to audience skills, knowledge and ability. Pedro is always approachable, encouraging and supportive, giving delegates the optimum learning environment. I would not hesitate to recommend Pedro as a trainer, whatever your level of ability. Amanda Morris - Treasury & Systems Accountant at Reall - Real Equity for All The course was very interesting and engaging and will definitely be put to use. The trainer was very helpful and charismatic. Marving Lopez - AM Best Europe Pedro was excellent. Very knowledgeable, clear and great rapport with class. Darren Barkey - Direct Wines Great content and learnt a lot. Really enjoyable :) Kristie-Lee Ryan - Stirling Ackroyd 1 year email support service Take a closer look at the consistent excellent feedback visiting our site ms-officetraining co uk With more than 20 years experience, we deliver courses on all levels of the Desktop version of Microsoft Office and Office 365; ranging from Beginner, Intermediate, Advanced to the VBA level. Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering classrom, one to one, tailored and bespoke courses. Tailored In Company training: You can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs. Please visit our site (ms-officetraining co uk) to get a feel of the excellent feedback our courses have had and look at other courses you might be interested in. Advanced Functions COUNT, COUNTA, COUNTIF, COUNTBLANK, SUMIF, SUBTOTAL IF, OR, AND, IFERROR VLOOKUP to lookup Exact Values and Approximate values MATCH, INDIRECT, ROW/COLUMN, INDEX, OFFSET Analysing Data PMT function to calculate a monthly payment of a loan What If Analysis using Goal Seek Use scenarios to consider many different variables Using Solver Add-in to optimize variables PivotTables Create a PivotTable to analyse worksheet data Add or remove fields in a PivotTable Change the data source for a PivotTable Working with external data sources Using different Statistical Functions Calculate a Running Total, % of Grant Total, Difference From… Using the Slicer and Timeline to filter the PivotTable Using Filters in a PivotTable Group by Date, Auto Group by ranges of values, Custom Group Create a PivotChart The GETPIVOTDATA function Formula auditing Precedents and dependents Error checking Watch a formula and its result by using the Watch Window Evaluate a nested formula one step at a time Data Validation Number Validation Data List Validation Message Prompts and Alerts Conditional Data Validation Data Validation Errors Consolidation Consolidate data by position Consolidate data by category Use a formula to consolidate data Outline (group) data in a worksheet Create an outline of rows Create an outline of columns Copy outlined data Hide or remove an outline Connect external data to your workbook Using the Power Query Editor to import data From Text and CSV, From Access, From Web, From another Workbook Using the Power Query Editor to; Transform your data by Selecting which fields to import, by Splitting Columns, Changing Data Type and more. Deleting Applied Steps Refreshing your data Working with Form Controls; Buttons, Option Buttons and Scroll Bars Introduction to Macros Change Macro Security settings How to Record a macro Some Macro Examples Delete a macro Edit the macro to view the VBA code Copy part of a macro to create another macro Assign a macro to a button Who is this course for? Who is this course for? This course is intended to end users who want to develop their skills so they can use advanced techniques to analyse extensive and complex datasets in Excel and to automate simple tasks with the use of Macros. Requirements Requirements Preferably, delegates should have attended the Excel Intermediate course. Career path Career path Excel know-how can instantly increase your job prospects as well as your salary. 80 percent of job openings require spreadsheet and word-processing software skills Certificates Certificates Certificate of completion Digital certificate - Included

People often equate the words mental health with mental illness and there are many definitions of what mental health actually is. Mental health issues can happen to anyone despite social background, intelligence, gender or other factors. This course explains the difference between mental health and mental illness. It covers the symptoms of a number of the most common mental illnesses so you will know what to look out for or what to expect if you are working with someone with one of these conditions. As well as providing some practical advice on how you can work effectively with those affected by these conditions.

Description This course offers a brief overview of MiFID II. It addresses the changes to the market structure under MiFID and MiFID II, and provides a sound grounding to the MiFID II provisions. Training Duration This course may take up to 2 hours to be completed. However, actual study time differs as each learner uses their own training pace. Participants This course is ideal for anyone wishing to be introduced to the MiFID II and the respective regulatory provisions. It is also suitable to professionals pursuing regulatory CPD in Financial Regulation. Training Method The course is offered fully online using a self-paced approach. The learning units consist of video presentations and reading material. Learners may start, stop and resume their training at any time. At the end of the training, participants take a Quiz to complete their learning and earn a Certificate of Completion. Accreditation and CPD Recognition This programme has been developed by the London Governance and Compliance Academy (LGCA), a UK-recognised training institution in collaboration with the European Institute of Management and Finance (EIMF). The syllabus is verified by external subject matter experts and can be accredited by regulators and other bodies for 2 CPD Units that approve education in financial regulation, such as the FCA. The course may be also approved for CPD Units by institutions which approve general financial training, such as the CISI. Eligibility criteria and CPD Units are verified directly by your association, regulator or other bodies which you hold membership. Registration and Access To register to this course, click on the Get this course button to pay online and receive your access instantly. If you are purchasing this course on behalf of others, please be advised that you will need to create or use their personal profile before finalising your payment. If you wish to receive an invoice instead of paying online, please contact us at info@lgca.uk. Access to the course is valid for 365 days.

Description Approved Persons Regime awareness course for all members of firms NOT subject to the Senior Managers & Certification Regime (SM&CR) which came into effect on 7 March 2016, applying to banks, building societies, credit unions and investment firms that are subject to dual regulation by the Prudential Regulation Authority (PRA) and Financial Conduct Authority (FCA). Please note that, if your firm is currently regulated solely by the FCA under the Approved Persons Regime, this will be replaced by SM&CR in 2019 (or December 2018 for insurers). Training Duration This course may take up to 1 hour to be completed. However, actual study time differs as each learner uses their own training pace. Training Method The course is offered fully online using a self-paced approach. The learning units consist of reading material. Learners may start, stop and resume their training at any time. At the end of each session, participants take a Quiz to complete their learning unit and earn a Certificate of Completion upon completion of all units. Accreditation and CPD Recognition This programme has been developed by the London Governance and Compliance Academy (LGCA), a UK-recognised training institution. The syllabus is verified by external subject matter experts and can be accredited by regulators and other bodies for 1 CPD Unit that approve education in financial regulation, such as the FCA. The course may be also approved for CPD Units by institutions which approve general financial training, such as the CISI. Eligibility criteria and CPD Units are verified directly by your association, regulator or other bodies which you hold membership. Registration and Access To register to this course, click on the Get this course button to pay online and receive your access instantly. If you are purchasing this course on behalf of others, please be advised that you will need to create or use their personal profile before finalising your payment. If you wish to receive an invoice instead of paying online, please contact us at info@lgca.uk. Access to the course is valid for 365 days.

This course uses a non-traditional approach that improves all 4 Language Skills using materials from the students' own school courses. The training also focuses on examination techniques.

Have you ever dreamed of coaching a football team? Of leading players to victory? Of helping them achieve their full potential? If so, then our Football Coaching Training program is for you. We offer a comprehensive training program that will teach you everything you need to know to be a successful coach. From the fundamentals of the game to the latest coaching techniques, we will cover it all. But we don't just teach you the skills. We also provide you with the support you need to succeed. Our team of experienced coaches will be there to guide you every step of the way. We will help you develop your coaching philosophy, build your resume, and network with other coaches. And when you're ready to start your career, we'll help you find a job. We have a strong network of contacts in the football industry, and we'll use it to get you your foot in the door. So what are you waiting for? Start your journey to becoming a football coach today. If you are serious about a career in football coaching, then our program is the perfect choice for you. Contact us today to learn more. Our mission is simple: to be your trusted partner and assist you every step of the way until you land the job of your dreams. Why Choose Us Here's what makes our Football Coaching Training Program stand out from the crowd: Personalised Job Search Assistance: We're in this together! Our dedicated team will work tirelessly to support your entire job searching process. From crafting a standout resume to submitting it to top companies, we'll ensure you have a compelling application that gets noticed. Unleash Your Coaching Potential: At our core, we believe that great coaches are made, not born. With our comprehensive training program, we will equip you with the essential tools and techniques to become a successful football coach. Whether you're just starting out or looking to enhance your existing coaching skills, we've got you covered. Expertly Crafted CV: Your resume is your ticket to the interview room. Our professional resume writers will create a customised CV highlighting your unique skills and experiences. This will maximise your chances of standing out among the competition. Strategic Placement: We understand the power of casting a wide net. We'll strategically submit your CV to various platforms and networks, expanding your reach and connecting you with valuable opportunities that align with your career goals. One-On-One Consultation Sessions with Industry Experts: Gain invaluable insights and guidance from seasoned professionals who have thrived in the Football Coaching field. Our consultation sessions provide you with insider tips, tricks, and advice, empowering you to navigate the industry with confidence and expertise. Comprehensive Skill Development: Our program is designed to equip you with the most sought-after skills in the Football Coaching sector. From mastering cutting-edge tools to honing your coaching prowess, we'll ensure you have the knowledge and expertise to excel in any football-driven environment. Ongoing Support: We understand that the journey to landing your dream job doesn't end with placement. That's why our commitment to your success extends well beyond your initial training. Our support team will be available to answer your questions, provide guidance, and assist you as you progress in your career. Here are the X courses we will provide once you enrol in the program: Course 01: Football Coaching Course 02: Sports Psychology Course 03: Sports Therapy Course 04: Nutrition: Food Nutrients Sources, Functions and Deficiency Course 05: Sports Injuries Course 06: Pain Management These courses will help you to develop your knowledge and skills to become a successful Football Coach. The Program is completed in 5 easy steps: Step 1 - Enrol in the program and start learning from the courses we provide After you enrol in this Football Coaching Training Program, you will get lifetime access to 6 premium courses related to Football Coaching. These courses will teach you the knowledge and skills required to become a successful Football Coach. Our customer service team will help you and keep in contact with you every step of the way. Step 2 - Complete your courses and get certifications After learning from the courses, you must obtain certificates for each course. There will be exams for every course, and you have to pass them to get your certificate. To pass successfully, you must get 90% marks for the first course and 80% for the rest relevant courses. Once you pass the exams, you will receive hardcopy certificates. These certificates will prove that you're an expert in the subject. Step 3 - Get a consultation session from a professional Football Coach Take your Football Coaching skills to new heights with a one-on-one consultation session led by a seasoned professional. Gain invaluable insights, expert tips, and tailored advice that will propel your career forward. Step 4 - Complete the CV and attend the interview Once you've successfully obtained the certifications, our team of professionals will build you a compelling CV and LinkedIn profile. With these powerful tools in hand, you'll be fully prepared to tackle job interviews confidently. Kickstart your Football Coaching career with a starting salary ranging from •15,000 to •30,000 annually. Step into the football industry with the assurance of a promising future. Step 5 - We will not leave you until you get a job Our commitment to your success goes above and beyond. We won't stop until you land that dream job. With personalised support, expert guidance, and unwavering dedication, we'll be by your side until you secure the perfect opportunity. Your job search becomes our mission, ensuring you have the best chance at a successful career in Football Coaching. Don't let your dreams of becoming a football coach remain just that-dreams. Take action today and join our Football Coaching Training program. Together, we will unlock your coaching potential, build your professional profile, and pave the way to a fulfilling and rewarding career in football coaching. You just have to learn and gain knowledge and skills. Finding a job is our task! We will remove most of your worries and help you focus on only developing your skills. So join our Football Coaching Training Program today, and let us be your trusted partner on your journey to success. CPD 100 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This Football Coaching Training program is ideal for: Aspiring football coaches seeking comprehensive training and guidance. Individuals looking to enhance their existing coaching skills and knowledge. Those in pursuit of a rewarding career in the football coaching industry. Passionate football enthusiasts ready to turn their love for the game into a profession. Requirements No experience required. Just enrol & start learning. Career path In the UK, a career in football coaching offers tremendous opportunities. With our program, you'll receive top-notch training, personalised mentoring, and job assistance, giving you a solid foundation to embark on a successful coaching journey. From grassroots to professional levels, the UK's thriving football industry awaits you. Unlock your potential and shape your path to success. Certificates CPD Accredited e-Certificate Digital certificate - Included CPD Accredited Framed (Hardcopy) Certificate Hard copy certificate - Included Enrolment Letter Digital certificate - Included Student ID Card Digital certificate - Included

Duration 1 Days 6 CPD hours This course is intended for This course is intended for people who use PowerPoint for their business communication needs. Overview To ensure your success in this course, you should have end-user skills with any current version of Windows, including being able to open and close applications, navigate basic file structures, and manage files and folders. This course is intended for those who wish to take advantage of the application for high quality business presentations and reports. Presentations Create Attractive Presentations from Existing PowerPoint Templates Creating Presentations Quickly using Outline to build a Structure Incorporating and reusing slides from other presentations into your own Templates and Customization Using Slide Layouts Using the Slide Master Creating Custom Slide Layout Working with Charts and Tables Create and Modify Tables Create Charts and Graphs Copying Charts into PowerPoint Link Vs Embed Add Visual Elements to a Presentation Create and Modify Shapes Add Images Create SmartArt to Make Easily Modifiable graphics Use SmartArt to Give Dull Text a More Visual Appeal Working with Media and Animation Add Audio to A Presentation Add Video to A Presentation Add and Customize Animations Add and Customize Transitions Preparing to Present Add Notes to A Presentation Presenter View And Slide Show Controls Create A Custom Slide Show Saving and Sharing the Presentation Printing Options and Handouts Additional course details: Nexus Humans Microsoft PowerPoint for the Business User training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the Microsoft PowerPoint for the Business User course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

Fall into Savings. Enjoy the biggest price fall this Autumn! Life Just Got Better This Summer! Get Hard Copy + PDF Certificates + Transcript + Student ID Card + e-Learning App as a Gift - Enrol Now Tired of browsing and searching for the course you are looking for? Can't find the complete package that fulfils all your needs? Then don't worry as you have just found the solution. Take a minute and look through this 14-in-1 extensive bundle that has everything you need to succeed in Marine Biology and other relevant fields! After surveying thousands of learners just like you and considering their valuable feedback, this all-in-one Marine Biology bundle has been designed by industry experts. We prioritised what learners were looking for in a complete package and developed this in-demand Marine Biology course that will enhance your skills and prepare you for the competitive job market. Also, our Marine Biology experts are available for answering your queries and help you along your learning journey. Advanced audio-visual learning modules of these courses are broken down into little chunks so that you can learn at your own pace without being overwhelmed by too much material at once. Furthermore, to help you showcase your expertise in Marine Biology, we have prepared a special gift of 1 hardcopy certificate and 1 PDF certificate for the title course completely free of cost. These certificates will enhance your credibility and encourage possible employers to pick you over the rest. This Marine Biology Bundle Consists of the following Premium courses: Course 01: Marine Biology Course - Online Diploma Course 02: Diploma In Microbiology Course 03: Diploma in Water Chemistry Course 04: Diploma in Water Treatment Course 05: Environmental Law Course 06: Environmental Health Course 07: Basic Biology Course Course 08: Biochemistry Course 09: Biotechnology Course 10: Genetics Course 11: Lab Analyst Training Course 12: Carbon Literacy Knowledge | Course Course 13: Process Improvement: Reduce Waste Course 14: Infection Prevention Training Curriculum: Course 01: Marine Biology Course - Online Diploma Introduction The Ocean The Ocean as a Habitat Characteristics of the Marine Environment Marine Life Marine Microbes Marine Invertebrates Marine Vertebrates Marine Populations and Communities Marine Ecology Food Chains and Food Webs Damaging Impact of Human Activities on Marine Life Marine Conservation ---------- Other Courses Are ---------- Course 02: Diploma In Microbiology Course 03: Diploma in Water Chemistry Course 04: Diploma in Water Treatment Course 05: Environmental Law Course 06: Environmental Health Course 07: Basic Biology Course Course 08: Biochemistry Course 09: Biotechnology Course 10: Genetics Course 11: Lab Analyst Training Course 12: Carbon Literacy Knowledge | Course Course 13: Process Improvement: Reduce Waste Course 14: Infection Prevention Training How will I get my Certificate? After successfully completing the course you will be able to order your CPD Accredited Certificates (PDF + Hard Copy) as proof of your achievement. PDF Certificate: Free (For The Title Course) Hard Copy Certificate: Free (For The Title Course) CPD 145 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone from any background can enrol in this Marine Biology bundle. Requirements Our Marine Biology course is fully compatible with PCs, Macs, laptops, tablets and Smartphone devices. Career path Having this Marine Biology expertise will increase the value of your CV and open you up to multiple job sectors. Certificates Certificate of completion Digital certificate - Included You will get the PDF Certificate for the title course (Marine Biology Course - Online Diploma) absolutely Free! Certificate of completion Hard copy certificate - Included You will get the Hard Copy certificate for the title course (Marine Biology Course - Online Diploma) absolutely Free! Other Hard Copy certificates are available for £10 each. Please Note: The delivery charge inside the UK is £3.99, and the international students must pay a £9.99 shipping cost.

Boost Your Career with Apex Learning and Get Noticed By Recruiters in this Hiring Season! Get Hard Copy + PDF Certificates + Transcript + Student ID Card worth £160 as a Gift - Enrol Now Give a compliment to your career and take it to the next level. This GIS: QGIS Cartography will provide you with the essential knowledge and skills required to shine in your professional career. Whether you want to develop skills for your next job or want to elevate skills for your next promotion, this GIS: QGIS Cartography will help you keep ahead of the pack. The GIS: QGIS Cartography incorporates basic to advanced level skills to shed some light on your way and boost your career. Hence, you can reinforce your professional skills and essential knowledge, reaching out to the level of expertise required for your position. Further, this GIS: QGIS Cartography will add extra value to your resume to stand out to potential employers. Throughout the programme, it stresses how to improve your competency as a person in your profession while at the same time it outlines essential career insights in this job sector. Consequently, you'll strengthen your knowledge and skills; on the other hand, see a clearer picture of your career growth in future. By the end of the GIS: QGIS Cartography, you can equip yourself with the essentials to keep you afloat into the competition. Along with this GIS: QGIS Cartography course, you will get 10 other premium courses. Also, you will get an original Hardcopy and PDF certificate for the title course and a student ID card absolutely free. This GIS: QGIS Cartography Bundle Consists of the following Premium courses: Course 01: QGIS Cartography Course 02: Architectural Studies Course 03: Land Surveying Course 04: Drawing and Illustration Level 2 Course 05: Digital Art - Sketching In Photoshop Course 06: Course 07: Ultimate Geology Course Course 08: Egyptology Course 09: Archaeology Course 10: Military History Course 11: Learn to Use Python for Spatial Analysis in ArcGIS So, enrol now to advance your career! Benefits you'll get choosing Apex Learning: One payment, but lifetime access to 11 CPD courses Certificates, student ID for the title course included in a one-time fee Full tutor support available from Monday to Friday Free up your time - don't waste time and money travelling for classes Accessible, informative modules taught by expert instructors Learn at your ease - anytime, from anywhere Study the course from your computer, tablet or mobile device CPD accredited course - improve the chance of gaining professional skills Curriculum of Bundle Course 01: QGIS Cartography Section 01: Introduction Section 02: Labels Section 03: Symbology Section 04: Base Layers Section 05: Project Setup Section 06: Water Styling Section 07: Land Styling =========>>>>> And 10 More Courses <<<<<========= How will I get my Certificate? After successfully completing the course you will be able to order your CPD Accredited Certificates (PDF + Hard Copy) as proof of your achievement. PDF Certificate: Free (Previously it was £6*11 = £66) Hard Copy Certificate: Free (For The Title Course: Previously it was £10) If you want to get hardcopy certificates for other courses, generally you have to pay £20 for each. But this Fall, Apex Learning is offering a Flat 50% discount on hard copy certificates, and you can get each for just £10! P.S. The delivery charge inside the U.K. is £3.99 and the international students have to pay £9.99. CPD 110 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone from any background can enrol in this GIS: QGIS Cartography bundle. Requirements This GIS: QGIS Cartography course has been designed to be fully compatible with tablets and smartphones. Career path Having this expertise will increase the value of your CV and open you up to multiple job sectors. Certificates Certificate of completion Digital certificate - Included Certificate of completion Hard copy certificate - Included You will get the Hard Copy certificate for the title course (QGIS Cartography) absolutely Free! Other Hard Copy certificates are available for £10 each. Please Note: The delivery charge inside the UK is £3.99, and the international students must pay a £9.99 shipping cost.