• Professional Development
  • Medicine & Nursing
  • Arts & Crafts
  • Health & Wellbeing
  • Personal Development

14954 Other courses in Armthorpe delivered On Demand

Level 3 Award in Education and Training (RQF) - Train the Trainer (PTLLS)

4.9(27)

By Apex Learning

Fully Online No Obligation for Attending Classes Boost Your Career with Apex Learning and Get Noticed By Recruiters in this Hiring Season! Everyone who remembers his own education remembers teachers, not methods and techniques. The teacher is the heart of the educational system. Education is our passport to the future, for tomorrow belongs to the people who prepare for it today. A recent study showed there is widespread concern about the shortage of teachers in the UK. In some regions and some subject areas or phases, finding & retaining appropriately qualified teaching staff is a major challenge for school leaders. But you don't need to worry as our Level 3 Award in Education and Training (RQF) - Train the Trainer (PTLLS) is just the perfect opportunity for you to get into the teaching profession. If you're aiming to become a person who educates students for a better future, while securing a stable & successful career then this Level 3 Award in Education and Training (RQF) - Train the Trainer (PTLLS) online programme will help you achieve your goals. At the beginning of the Level 3 Award in Education and Training (RQF) - Train the Trainer (PTLLS) course, you'll be familiarised with the roles & responsibilities of a teacher also, Learn everything about classroom management and how to assess and provide effective feedback. Why is this Level 3 Award in Education and Training AET (Formerly PTTLS Course is Perfect for You? Choose Your Career: Join today and make a life-changing decision, get all the essential knowledge to transform your career. Advance Your Career: With our Regulated qualification, you can move up to the next level in your organisation with expertise. Upgrade Your Skills: Add value to your current educational profile and gain the skill sets to compete in your job role. Enhance Your Credibility: The AET (former PTLLS) course is Ofqual, UK Govt. Regulated and Awarded by Focus which adds value to your educational profile. 20 Additional Courses: With a single payment, you will get access to AET (former PTLLS) along with 5 Additional courses 100% Money-Back Guarantee: We are confident about our course quality and want to provide the best service to our invaluable learners. That's why we provide 14 days Unconditional Full Money-Back Guarantee with this course to ensure a hassle-free purchase. What other courses are included with this Level 3 Award in Education and Training (RQF) - Train the Trainer (PTLLS) Course?: With this Level 3 Award in Education and Training (RQF) - Train the Trainer (PTLLS) Course, learners will get the 20 Premium courses completely FREE. Course 01: Education Management Course 02: Educational Psychology and Development Course 03: Advanced Teaching Assistant Diploma Course 04: Special Education Needs (SEN) Training - Level 2 Course 05: EYFS Teaching - Level 3 Course 06: Phonics Teaching Diploma Level 3 Course 07: Leadership in Teaching Course 08: Lesson Planning for Teaching Course 09: Remote Teaching Online Course 10: Classroom Behaviour Management Course 11: Performance Management Course 12: People Management Skills Level 3 Course 13: Report Writing Course 14: Domestic Violence and Abuse Awareness - Level 2 Course 15: Child Neglect Awareness Certificate Course Course 16: Level 3 Mental Health and Adolescent Course Course 17: Safeguarding Children Level 3 Course 18: Functional Skills English Practice Level 2 Course 19: Train the Trainer Course 20: Leadership & Management Diploma Enrol in this Level 3 Award in Education and Training (RQF) - Train the Trainer (PTLLS) Course to become certified at a nationally acceptable level. Benefits you will gain from this Level 3 Award in Education and Training (RQF) - Train the Trainer (PTLLS) Course: Buy 1 Get 20 Personal Development Courses absolutely FREE Premium quality, intensive e-learning course materials Find a well-defined website for learning 24/7 teacher assistance Step-by-step guidelines Budget-friendly price Earned recognition from the UK's top awarding bodies Study in a user-friendly, advanced student portal Convenient and Flexible time limit Level 3 Award in Education and Training (RQF) - Train the Trainer (PTLLS) Level 3 Award in Education and Training (RQF) - Train the Trainer (PTLLS) course is comprised of three mandatory units. These are as follows: Understanding roles, responsibilities and relationships in education and training Understanding and using inclusive training and learning approaches in education and training Understanding assessment in education and training What skills will I gain from this Level 3 Award in Education and Training (RQF) - Train the Trainer (PTLLS) Course? Understand the underlying fundamentals of teaching and learning Make a practical approach to session planning Explore the various approaches to learning Determine the students' desires and long-term goals Implement strategies for assessing your students' potential You will become an expert in education and training You will gain knowledge in teacher expectations & attributions and much more... AET (former PTLLS) Qualification Purpose Achieving the Level 3 will award in education and training will enable the professionals to have the necessary knowledge and skills to prepare, plan, deliver and evaluate teaching and training sessions in a wide variety of teaching or training settings. AET (former PTLLS) Total Qualification Time It is an estimate of the total amount of time anticipated that a learner would spend to demonstrate mastery of all learning outcomes to achieve the award of the qualification. The whole qualification time is defined as GLH and an estimate of the time a learner will devote to preparation, study, and assessment. It does not underlie supervision by a lecturer, supervisor, or tutor. In the case of qualification, the credit value is defined by TQT, and one credit corresponds to ten hours of learning. Total Qualification Time for this qualification is 120 hours. The total credit value for this qualification is 12 AET (former PTLLS) Guided Learning Hours These hours comprise all real-time contact time, hours of lectures or tutorials or supervision of a learner, tutor, trainer or other education providers. GLH for this qualification is 48 AET (former PTLLS) Method of Assessment: Unit 1: In Unit 1, you need to complete a variety of writing assignments Unit 2: In Unit 2, there should be an assessment taken in the workplace, primarily evaluating learners' work, professional discussions with audio-video evidence Unit 3: In Unit 3, you will be demonstrated through your delivered work items and audio-video evidence after evaluating learners in a training context. AET (former PTLLS) Video Assessment You have to plan many things, such as observation, questioning/ professional discussion, and inspection of supporting work products evidence. Detailed assignment instructions will be made available to you in the 'Guidance for Achieving the Unit' section of your learning portal with a careful and clear explanation. You have to submit all your assignments via the online portal Certification Successful candidates will be awarded a Level 3 Award in Education and Training (RQF) - Train the Trainer (PTLLS) from Focus Awards Limited. Progression Level 4 Certificate in Education and Training Level 5 Diploma in Education and Training Level 3 Award in Understanding the Principles and Practices of Assessment Level 3 Award in Assessing Competence in the Work Environment Level 3 Award in Assessing Vocational Related Achievement Level 3 Certificate in Assessing Vocational Achievement Level 4 Award in Understanding the Internal Quality Assurance of Assessment Processes and Practice Level 4 Award in the Internal Quality Assurance of Assessment Processes and Practice Level 4 Certificate in Leading the Internal Quality Assurance of Assessment Processes and Practice Level 4 Award in Learning and Development Level 4 Diploma in Learning and Development Who is this course for? Level 3 Award in Education and Training (RQF) - Train the Trainer (PTLLS). Primary School Teacher Secondary School Teacher Private Tutor Freelance Teacher/ Trainer Consultant Job hunters & School leavers Educational Psychologist Office clerk & Administration Assistant College or University Student Requirements Level 3 Award in Education and Training (RQF) - Train the Trainer (PTLLS) This Level 3 Award in Education and Training (RQF) - Train the Trainer (PTLLS) course does not have any specific entry requirements for students. However, You must be at least 19 years old or above to register and undergo an initial assessment. Since it is a level 3 qualification, you must pass the minimum 1st level of the literacy assessment Career path Level 3 Award in Education and Training (RQF) - Train the Trainer (PTLLS) You will have the ability to accomplish a lot of things with this certificate. Here are just a few examples: School Teacher Private Tutor Freelance Teacher/ Trainer Consultant Job hunters & School leavers Educational Psychologist Office clerk & Administration Assistant College or University Student

Level 3 Award in Education and Training (RQF) - Train the Trainer (PTLLS)
Delivered Online On Demand
£339

Level 3 Award in Education and Training - AET (Formerly PTTLS)

4.9(27)

By Apex Learning

***Limited Time Deal*** Fully Online No Obligation for Attending Classes Boost Your Career with Apex Learning and Get Noticed By Recruiters in this Hiring Season! Everyone who remembers his own education remembers teachers, not methods and techniques. The teacher is the heart of the educational system. Education is our passport to the future, for tomorrow belongs to the people who prepare for it today. A recent study showed there is widespread concern about the shortage of teachers in the UK. In some regions and some subject areas or phases, finding & retaining appropriately qualified teaching staff is a major challenge for school leaders. But you don't need to worry as our AET: Level 3 Award in Education and Training AET (Formerly PTTLS) is just the perfect opportunity for you to get into the teaching profession. If you're aiming to become a person who educates students for a better future, while securing a stable & successful career then this AET: Level 3 Award in Education and Training AET (Formerly PTTLS) online programme will help you achieve your goals. At the beginning of the AET: Level 3 Award in Education and Training AET (Formerly PTTLS) course, you'll be familiarised with the roles & responsibilities of a teacher also, Learn everything about classroom management and how to assess and provide effective feedback. Why is this Level 3 Award in Education and Training AET (Formerly PTTLS Course is Perfect for You? Choose Your Career: Join today and make a life-changing decision, get all the essential knowledge to transform your career. Advance Your Career: With our Regulated qualification, you can move up to the next level in your organisation with expertise. Upgrade Your Skills: Add value to your current educational profile and gain the skill sets to compete in your job role. Enhance Your Credibility: The AET (former PTLLS) course is Ofqual, UK Govt. Regulated and Awarded by Focus which adds value to your educational profile. 5 Additional Courses: With a single payment, you will get access to AET (former PTLLS) along with 5 Additional courses 100% Money-Back Guarantee: We are confident about our course quality and want to provide the best service to our invaluable learners. That's why we provide 14 days Unconditional Full Money-Back Guarantee with this course to ensure a hassle-free purchase. What other courses are included with this Level 3 Award in Education & Training AET (former PTLLS) Course?: With this Level 3 Award in Education & Training AET (former PTLLS) Course, learners will get the 20 Premium courses completely FREE. Course 01: Education Management Course 02: Educational Psychology and Development Course 03: Advanced Teaching Assistant Diploma Course 04: Special Education Needs (SEN) Training - Level 2 Course 05: EYFS Teaching - Level 3 Course 06: Phonics Teaching Diploma Level 3 Course 07: Leadership in Teaching Course 08: Lesson Planning for Teaching Course 09: Remote Teaching Online Course 10: Classroom Behaviour Management Course 11: Performance Management Course 12: Maximise Your Personal Productivity: Negotiation Skills Course Course 13: Report Writing Course 14: Domestic Violence and Abuse Awareness - Level 2 Course 15: Child Neglect Awareness Certificate Course Course 16: Level 3 Mental Health and Adolescent Course Course 17: Safeguarding Children Level 3 Course 18: Functional Skills English Practice Level 2 Course 19: Train the Trainer Course 20: Leadership & Management Diploma Enrol in this Level 3 Award in Education & Training AET (former PTLLS) Course to become certified at a nationally acceptable level. Benefits you will gain from this Level 3 Award in Education & Training AET (former PTLLS) Course: Buy 1 Get 20 Personal Development Courses absolutely FREE Premium quality, intensive e-learning course materials Find a well-defined website for learning 24/7 teacher assistance Step-by-step guidelines Budget-friendly price Earned recognition from the UK's top awarding bodies Study in a user-friendly, advanced student portal Convenient and Flexible time limit AET: Level 3 Award in Education and Training - AET (Formerly PTTLS) The Level 3 Award in Education and Training - AET (Formerly PTTLS) course is comprised of three mandatory units. These are as follows: Understanding roles, responsibilities and relationships in education and training Understanding and using inclusive training and learning approaches in education and training Understanding assessment in education and training What skills will I gain from this Level 3 Award in Education and Training - AET (Formerly PTTLS) Course? Understand the underlying fundamentals of teaching and learning Make a practical approach to session planning Explore the various approaches to learning Determine the students' desires and long-term goals Implement strategies for assessing your students' potential You will become an expert in education and training You will gain knowledge in teacher expectations & attributions and much more... AET (former PTLLS) Qualification Purpose Achieving the Level 3 will award in education and training will enable the professionals to have the necessary knowledge and skills to prepare, plan, deliver and evaluate teaching and training sessions in a wide variety of teaching or training settings. AET (former PTLLS) Total Qualification Time It is an estimate of the total amount of time anticipated that a learner would spend to demonstrate mastery of all learning outcomes to achieve the award of the qualification. The whole qualification time is defined as GLH and an estimate of the time a learner will devote to preparation, study, and assessment. It does not underlie supervision by a lecturer, supervisor, or tutor. In the case of qualification, the credit value is defined by TQT, and one credit corresponds to ten hours of learning. Total Qualification Time for this qualification is 120 hours. The total credit value for this qualification is 12 AET (former PTLLS) Guided Learning Hours These hours comprise all real-time contact time, hours of lectures or tutorials or supervision of a learner, tutor, trainer or other education providers. GLH for this qualification is 48 AET (former PTLLS) Method of Assessment: Unit 1: In Unit 1, you need to complete a variety of writing assignments Unit 2: In Unit 2, there should be an assessment taken in the workplace, primarily evaluating learners' work, professional discussions with audio-video evidence Unit 5: In Unit 5, you will be demonstrated through your delivered work items and audio-video evidence after evaluating learners in a training context. AET (former PTLLS) Video Assessment You have to plan many things, such as observation, questioning/ professional discussion, and inspection of supporting work products evidence. Detailed assignment instructions will be made available to you in the 'Guidance for Achieving the Unit' section of your learning portal with a careful and clear explanation. You have to submit all your assignments via the online portal Certification Successful candidates will be awarded a Level 3 Award in Education and Training (RQF) from Focus Awards Limited. Progression Level 4 Certificate in Education and Training Level 5 Diploma in Education and Training Level 3 Award in Understanding the Principles and Practices of Assessment Level 3 Award in Assessing Competence in the Work Environment Level 3 Award in Assessing Vocational Related Achievement Level 3 Certificate in Assessing Vocational Achievement Level 4 Award in Understanding the Internal Quality Assurance of Assessment Processes and Practice Level 4 Award in the Internal Quality Assurance of Assessment Processes and Practice Level 4 Certificate in Leading the Internal Quality Assurance of Assessment Processes and Practice Level 4 Award in Learning and Development Level 4 Diploma in Learning and Development Who is this course for? AET: Level 3 Award in Education and Training AET (Formerly PTTLS) Primary School Teacher Secondary School Teacher Private Tutor Freelance Teacher/ Trainer Consultant Job hunters & School leavers Educational Psychologist Office clerk & Administration Assistant College or University Student Requirements AET: Level 3 Award in Education and Training AET (Formerly PTTLS) This AET: Level 3 Award in Education and Training AET (Formerly PTTLS)course does not have any specific entry requirements for students. However, You must be at least 19 years old or above to register and undergo an initial assessment. Since it is a level 3 qualification, you must pass the minimum 1st level of the literacy assessment. Career path AET: Level 3 Award in Education and Training AET (Formerly PTTLS) You will have the ability to accomplish a lot of things with this certificate. Here are just a few examples: Primary School Teacher Secondary School Teacher Private Tutor Freelance Teacher/ Trainer Consultant Job hunters & School leavers Educational Psychologist Office clerk & Administration Assistant College or University Student

Level 3 Award in Education and Training - AET (Formerly PTTLS)
Delivered Online On Demand
£339

AWS Associate to Practitioner and Professional Bundle with 5 Certifications and Exams

By Hudson

Amazon Web Services (AWS) is the world’s most comprehensive and broadly adopted cloud platform, offering over 175 fully featured services from data centers globally. Millions of customers—including the fastest-growing startups, largest enterprises, and leading government agencies, are using AWS to lower costs, become more agile, and innovate faster.

AWS Associate to Practitioner and Professional Bundle with 5 Certifications and Exams
Delivered Online On Demand
£1,395

iOS13 Online Shop Application: Build an e-Market

By Packt

Use Xcode 11, Swift 5, and iOS 13 to build an e-shop application with Firestore, Algolia, and Stripe Payment

iOS13 Online Shop Application: Build an e-Market
Delivered Online On Demand14 hours 27 minutes
£70.99

CT03g - Clinical trial monitor’s GCP responsibilities

By Zenosis

A clinical trial monitor acts on behalf of the sponsor to support investigational site personnel, verify the accuracy of data recorded, and ensure that the trial is conducted in compliance with the protocol, GCP and other study specific requirements. He or she acts as the ‘eyes and ears’ of the sponsor at the investigational site and provides the main channel of communication between sponsor and investigator. This short course explores the responsibilities of the monitor and provides insight into key challenges. We discuss assessment of investigators and investigational sites, education and trial initiation, monitoring of clinical conduct, including CRF review and source document verification, and trial close-out. We discuss noncompliance and how to deal with it.

CT03g - Clinical trial monitor’s GCP responsibilities
Delivered Online On Demand30 minutes
£25

Regulated Education & Training (RQF) with Phonics Teaching & Special Educational Needs

4.9(27)

By Apex Learning

The Level 3 Award in Education and Training (RQF) qualification is a level 3 Award in Education & Training AET(former PTLLS) which has been regulated by the UK's Govt. and awarded by Focus, the UK's fastest-growing awarding organisation. Focus is a well-established awarding organisation governed by OFQUAL, ensuring professionalism and appreciation of the qualifications.

Regulated Education & Training (RQF) with Phonics Teaching & Special Educational Needs
Delivered Online On Demand
£599

Purchasing & Procurement Courses

5.0(2)

By Apex Learning

***Premium Version*** **Be prepared for the upcoming Hiring Season by enhancing your professional skillsets with Apex Learning! Get Hard Copy + PDF Certificate + Transcript + Student ID Card 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 Purchasing and Procurement and other relevant fields! After surveying thousands of learners just like you and considering their valuable feedback, this all in one Purchasing and Procurement bundle has been designed by industry experts. We prioritised what learners were looking for in a complete package and developed this in-demand Purchasing and Procurement course that will enhance your skills and prepare you for the competitive job market. Also, our Purchasing and Procurement experts are available for answering your queries and help you along your learning journey. Advanced audiovisual 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 Purchasing and Procurement, 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 Purchasing and Procurement Bundle Consists of the following Premium courses: Course 01: Purchasing & Procurement Course - Level 3 Course 02: Logistic Management Course 03: Retail Operations Training Level 3 Course 04: Merchandising Course 05: Commercial Law 2021 Course 06: Level 3 Tax Accounting Course 07: Diploma in Lean Process and Six Sigma Course 08: Import/Export Processing Course 09: Quality Management Course 10: Warehouse Course 11: SAP Controlling (CO) - Product Costing S4HANA Course 12: Budgeting and Forecasting Course 13: Business Analysis Level 3 Course 14: Effective Communication Skills Diploma Benefits you'll get choosing Apex Learning: One payment, but lifetime access to 14 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 The bundle incorporates basic to advanced level skills to shed some light on your way and boost your career. Hence, you can strengthen your Purchasing & Procurement expertise and essential knowledge, which will assist you in reaching your goal. Moreover, you can learn from any place in your own time without travelling for classes. Course Curriculum : Course 01: Purchasing & Procurement Course - Level 3 Supply Chain Basics Role of Procurement in an Organisation The Purchasing Cycle Purchasing Toolkits Managing Competitive Bids Quality Management Supplier Relationship Management Improving Efficiency and Accuracy Category Management 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) 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. Learners inside the UK will enjoy free delivery of the hardcopy certificate, and learners outside the UK will need to pay a £9.99 postal delivery charge. CPD 140 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone from any background can enrol in this Purchasing and Procurement bundle. Requirements Our Purchasing and Procurement course is fully compatible with PCs, Macs, laptops, tablets and Smartphone devices. Career path Having this Purchasing and Procurement expertise will increase the value of your CV and open you up to multiple job sectors. Certificates Certificate of completion Digital certificate - Included

Purchasing & Procurement Courses
Delivered Online On Demand
£100

Food Safety & Food Processing Training

4.9(27)

By Apex Learning

Give a compliment to your career and take it to the next level. This Food Safety & Food Processing Training 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 course will help you keep ahead of the pack. Along with this course, you will get 10 other premium courses. Also, you will get an original Hardcopy and PDF certificate for the title course and a free student ID card. What other courses are included with this Food Safety & Food Processing Training? Course 1: Food Processing Diploma Course 2: TACCP Training Course Course 3: Food Allergen Awareness Course 4: Nutrition and Diet Awareness Course 5: Ketogenic Diet Course 6: Immunity Boosting Food Course 7: Food and Mood: Improving Mental Health Through Diet and Nutrition Course 8: Create a Short Recipe Video Course 9: Personal Hygiene Course 10: Kitchen Gardening So, enrol now to advance your career! Benefits you'll get choosing Apex Learning: One payment, but lifetime access to 11 CPD courses Certificate, 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 Gain valuable knowledge without leaving your home 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 £10 * 11 = £110) Hard Copy Certificate: Free (For The Title Course) 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. Curriculum: Course 1: Food Hygiene Level 2 Diploma Level 1- Food Hygiene and HACCP Module 01: Introduction to Food Hygiene Module 02: Food Safety Hazards Module 03: Food Safety Controls Module 04: Personal Hygiene Module 05: Cleaning Activities Level 2 - Food Hygiene and HACCP Introduction Bacteria and Microbiological Hazards Physical, Chemical and Allergenic Hazards Food Poisoning and Control Measures Food Spoilage and Food Storage Personal Hygiene HACCP and Food Premises Part 01 HACCP and Food Premises Part-02 Cleaning Reopening and Adapting Your Food Business during COVID-19 Course 2: Food Processing Diploma Course 3: TACCP Training Course Course 4: Food Allergen Awareness Course 5: Nutrition and Diet Awareness Course 6: Ketogenic Diet Course 7: Immunity Boosting Food Course 8: Food and Mood: Improving Mental Health Through Diet and Nutrition Course 9: Create a Short Recipe Video Course 10: Personal Hygiene Course 11: Kitchen Gardening CPD 110 CPD hours / points Accredited by CPD Quality Standards Requirements There is no time limit for completing this course, it can be studied in your own time at your own pace. Career path Having these various certifications will increase the value in your CV and open you up to multiple job sectors. Certificates Certificate of completion Digital certificate - Included

Food Safety & Food Processing Training
Delivered Online On Demand
£53

Stop Smoking: Kick a Habit©️: With Confidence

By WithCaroline

Stop Smoking With Confidence Training Program, you'll learn the skills you need to finally stop smoking and stay smoke-free. A swift, no-nonsense primarily audio course of action to become a Non-Smoker within the next seven days, includes hypnosis. Your trainer is Caroline Anderson MSc Psych, BSc Clinical Hypnosis,Mstr NLP, EFT3, Dip Personnel Mgmt.

Stop Smoking: Kick a Habit©️: With Confidence
Delivered Online On Demand1 hour
£149

Microsoft Excel Advanced Certificate

By OnlineCoursesLearning.com

Microsoft Excel Advanced Course Please Note: This course uses the Windows version of Microsoft Office 2016. Any other versions will have some differences in the functions. The Microsoft (MS) Excel Certification Level 3 Course is the most comprehensive of the three Excel courses presented here. If a team member has successfully completed the Level 1 and Level 2 courses, they will be fully prepared to start the Level 3 course. Formulae or functions are what advanced users of Excel want from this tool. When you use formulae, not only can you see the data that you require for your work, you can also analyse it and get answers to complex questions. Although anyone with some Excel knowledge can use formulae, such as SUM, a user who has the advanced Excel skills presented in this course will use other formulae, both alone and combined, such as MATCH, INDEX, DSUM and VLOOKUP. In addition to knowing and using these formulae, an advanced user of Excel knows how to debug these formulae, how to audit them and how to choose the perfect formula for the particular task to be carried out.   What's Covered in the Course? Any staff member choosing to study this course can expect to gain the following skills: How to set A Password to an Excel document; VLOOKUP Advanced formula options and manipulations; Other advanced functions: OR, AND, CHOOSE, INDIRECT, REPLACE, LEN, LEFT, FIND; Functions of CEILING, CORREL, DATEDIF, DATEVALUE, DAVERAGE and EDATE; Colouring a column and row with a formula; Highlighting a cell with a formula; Functions of ISODD, ISNUMBER, ISTEXT, ISLOGICAL, ISNONTEXT, ISERR and ISBLANK; Functions of DGET, DMAX, DPRODUCT, DCOUNTA, DCOUNT and DSUM; How to calculate depreciation in Excel, including SLN depreciation and SYD depreciation; Calculating loan IPMT and EMI; Functions of DATEDIF, DATEVALUE, EDATE, EOMONTH, MATCH and INDEX; Full explanation of the INDEX and MATCH functions; Looking up data; Selecting only cells containing comments; Hiding formulae; Automatically inserting serial numbers;   The employee will also learn about calculating depreciation, calculating interest and calculating IPMT and EMI for loans, all by using Excel functions. The course features information on INDEX and MATCH functions, which is important in certain industries and roles. It also shows learners how to use the CHOOSE formula and how to create special charts. What are the Benefits of the Course? Upon completion of the Level 3 course, the employee will have access to the full functionality of Excel and will know how to use all of its formulae, functions and capabilities; The Level 3 Excel course is designed for 'power' users, but not only for programmers and those interested in financial modelling; Competent Excel users add huge value to an organisation, through advanced data analysis.

Microsoft Excel Advanced Certificate
Delivered Online On Demand
£50