45102 Courses

Childcare and Nutrition Do you enjoy being around children, taking care of them, and working with them? Then this Childcare and Nutrition course is ideal for you. With our Childcare and Nutrition course, prepare for a rewarding career in the care sector, and build your professional skills online. It is a complete training course for individuals to learn skills and knowledge on becoming child care planners, childcare employees, and nannies. It is a profession that brings a smile to everyone's face, spreads happiness, and allows you to better understand the health and safety facts associated with working with babies. This Childcare and Nutrition course will provide a thorough understanding of children's behaviour and development and how you may play a role in assisting children to attain their full potential. Enrol in our Childcare and Nutrition course today and gain the experience, skills, and knowledge you need to advance your professional development. Learning Outcomes After completing the Childcare and Nutrition course, you will be able to: Describe Childcare and Nutrition. Describe the importance of child growth and development. Keep children healthy and safe. Describe the importance of personal hygiene for children. Describe Macronutrients and Micronutrients. Know nutritional requirements for children. Describe child nutritional problems and physical development. Describe the concept of special needs. Prevent child abuse and neglect. Describe nutrition education and activities. Why Choose Childcare and Nutrition Course from Us Self-paced course, access available from anywhere. Easy to understand, high-quality study materials. Childcare and Nutrition Course developed by industry experts. MCQ quiz after each module to assess your learning. Automated and instant assessment results. 24/7 support via live chat, phone call or email. Free PDF certificate as soon as completing the course. ***Courses are included in this Childcare and Nutrition Exclusive Bundle Course Course 01: Childcare and Nutrition Course 02: Level 1 Diet and Nutrition Course Course 03: Nutrition Course (Level 3 Certificate) Course 04: Diploma in Sports Nutrition Course 05: Level 3 Award in Childcare and Education Course ***Other Benefits of Childcare and Nutrition Exclusive Bundle Courses 5 PDF Certificates Free Lifetime Access Unlimited Retake Expert Tutor Support [ Note: Free PDF certificate as soon as completing the Childcare and Nutrition course ] ***Childcare and Nutrition*** Detailed course curriculum of the Childcare and Nutrition Course: Module 1: Childcare and Nutrition Module 2: Children Growth and Development Module 3: Health and Safety of Children Module 4: Hygiene for Child Caring Module 5: The Use of Macronutrients Module 6: The Use of Micronutrients Module 7: Nutritional Requirements of Child Module 8: Child Nutritional Problem and Physical Development Module 9: Caring for Special Needs Children Module 10: Child Abuse and Neglect Module 11: Nutrition Education and Activities Assessment Method After completing each module of the Childcare and Nutrition Course, you will find automated MCQ quizzes. To unlock the next module, you need to complete the quiz task and get at least 60% marks. Certification After completing the MCQ/Assignment assessment for this Childcare and Nutrition course, you will be entitled to a Certificate of Completion from Training Tale. The certificate is in PDF format, which is completely free to download. A printed version is also available upon request. It will also be sent to you through a courier for £13.99. Who is this course for? Childcare and Nutrition Students Recent graduates Job Seekers Anyone interested in this topic People already working in this field want to improve their knowledge and skill. Requirements Childcare and Nutrition There are no specific requirements for this Childcare and Nutrition course because it does not require any advanced knowledge or skills. Students who intend to enrol in this course must meet the following requirements: Childcare Nutrition: Good command of the English language Must be vivacious and self-driven Basic computer knowledge A minimum of 16 years of age is required Career path Childcare and Nutrition You will receive help from this childcare and nutrition course in securing your ideal position in the industry. Regardless of your current employment situation, the childcare and nutrition course will advance your career. Certificates Certificate of completion Digital certificate - Included

Register on the ICT: Information and Communication Technology today and build the experience, skills and knowledge you need to enhance your professional development and work towards your dream job. Study this course through online learning and take the first steps towards a long-term career. The course consists of a number of easy to digest, in-depth modules, designed to provide you with a detailed, expert level of knowledge. Learn through a mixture of instructional video lessons and online study materials. Receive online tutor support as you study the course, to ensure you are supported every step of the way. Get an e-certificate as proof of your course completion. The ICT: Information and Communication Technology is incredibly great value and allows you to study at your own pace. Access the course modules from any internet-enabled device, including computers, tablet, and smartphones. The course is designed to increase your employability and equip you with everything you need to be a success. Enrol on the now and start learning instantly! What You Get With The ICT: Information and Communication Technology Receive a e-certificate upon successful completion of the course Get taught by experienced, professional instructors Study at a time and pace that suits your learning style Get instant feedback on assessments 24/7 help and advice via email or live chat Get full tutor support on weekdays (Monday to Friday) Course Design The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace. You are taught through a combination of Video lessons Online study materials Certification Upon successful completion of the course, you will be able to obtain your course completion e-certificate free of cost. Print copy by post is also available at an additional cost of £9.99 and PDF Certificate at £4.99. Who Is This Course For: The course is ideal for those who already work in this sector or are an aspiring professional. This course is designed to enhance your expertise and boost your CV. Learn key skills and gain a professional qualification to prove your newly-acquired knowledge. Requirements: The online training is open to all students and has no formal entry requirements. To study the ICT: Information and Communication Technology, all your need is a passion for learning, a good understanding of English, numeracy, and IT skills. You must also be over the age of 16.  Course Content Section 01: Introduction Introduction 00:06:00 What is ICT? 00:05:00 Hardware and Software 00:08:00 Information Processing Cycle 00:05:00 Software Explained 00:06:00 Human-Computer -Interface 00:07:00 Section 02: Impact of Emerging Technologies Introduction-Impact of Emerging Technology 00:01:00 Artificial intelligence 00:03:00 Biometrics 00:03:00 Vision enhancement 00:02:00 Robotics 00:03:00 Quantum cryptography 00:03:00 Computer-assisted translation 00:02:00 3D and holographic imaging 00:03:00 Virtual reality 00:06:00 Section 03: Types of Input Devices Types of Input Devices - Introduction 00:02:00 Manual input 00:07:00 Pointing devices 00:12:00 Inputting Images Devices 00:08:00 Inputting Sound & Music Devices 00:05:00 Direct input systems 00:07:00 Direct Input systems Part-2 00:05:00 Direct Input Systems Part-3 00:06:00 Direct Input Systems devices. Part-4 00:04:00 Sensors 00:05:00 Section 04: Types of Output Devices Types of Input Devices - Introduction 00:02:00 Monitors 00:06:00 Printers 00:08:00 Plotters 00:03:00 3D Printers 00:04:00 Speakers 00:02:00 Control Devices 00:06:00 Section 05: Storage Devices and Media Types of Storage Devices and Media 00:06:00 Magnetic Media 00:06:00 Optical media 00:10:00 Solid-State media 00:04:00 Backups 00:02:00 Section 06: Networks WHAT IS COMPUTER COMMUNICATION? 00:02:00 What is a computer network? 00:07:00 Types of NETWORK- Local Area Network 00:07:00 Wide Area Network 00:07:00 Bluetooth and WI-FI in Networks 00:07:00 Network Hardware 00:03:00 Network Switch 00:05:00 Network Bridge 00:02:00 Networking Hardware Router 00:05:00 Modem 00:04:00 Network Cables 00:03:00 How to set up a small network? 00:07:00 Section 07: Database What is a Database? 00:03:00 Database File 00:04:00 Database Types 00:09:00 Using Database 00:06:00 Data validation and verification 00:10:00 Section 08: Expert Systems What is an expert system? 00:10:00 Section 09: ICT Applications Applications in Banking: ATM, Electronic Fund Transfer 00:04:00 Applications in Banking: Internet Banking Telephone Banking 00:04:00 Applications in Banking: Cheque Clearing 00:05:00 RETAIL INDUSTRY Applications: POS 00:05:00 Retail: Stock Control 00:04:00 Retail: Automatic Reordering of Stock 00:03:00 Frequently Asked Questions Are there any prerequisites for taking the course? There are no specific prerequisites for this course, nor are there any formal entry requirements. All you need is an internet connection, a good understanding of English and a passion for learning for this course. Can I access the course at any time, or is there a set schedule? You have the flexibility to access the course at any time that suits your schedule. Our courses are self-paced, allowing you to study at your own pace and convenience. How long will I have access to the course? For this course, you will have access to the course materials for 1 year only. This means you can review the content as often as you like within the year, even after you've completed the course. However, if you buy Lifetime Access for the course, you will be able to access the course for a lifetime. Is there a certificate of completion provided after completing the course? Yes, upon successfully completing the course, you will receive a certificate of completion. This certificate can be a valuable addition to your professional portfolio and can be shared on your various social networks. Can I switch courses or get a refund if I'm not satisfied with the course? We want you to have a positive learning experience. If you're not satisfied with the course, you can request a course transfer or refund within 14 days of the initial purchase. How do I track my progress in the course? Our platform provides tracking tools and progress indicators for each course. You can monitor your progress, completed lessons, and assessments through your learner dashboard for the course. What if I have technical issues or difficulties with the course? If you encounter technical issues or content-related difficulties with the course, our support team is available to assist you. You can reach out to them for prompt resolution.

Embark on a cooking adventure! Learn the art of crafting tantalizing recipe videos with our Cooking Video Making course. Unleash your creativity today!

Welcome to Tiny Toes Ballet Staffordshire. Offering award-winning pre-school children's ballet and dance classes from walking to 7 years old. With our kids ballet classes and kids dance classes, your child will discover the joy of dancing, while also developing important skills such as coordination, balance, and rhythm. Our classes are extremely popular so if we're fully booked on your chosen class please do join the waiting list and we will be in touch very soon.

For confident candidates with outgoing personalities and a relentless attention to detail, the field of Secretary & PA Diploma services is wide open. Professional personal assistants (PAs) are the ultimate multitaskers, hired to manage the personal affairs and activities of those they support. Some secretaries and PAs work for large corporations, while others are hired by a single executive, entrepreneur, or influential figure. Regardless of which path you take, becoming a trusted and respected PA or Secretary opens the door to a world of incredible career opportunities. Personal qualities and character, as well as hard skills, are important for success as a PA or secretary. It's simply a matter of learning the roles of PAs and secretaries in order to prepare for a rewarding career in the field. This PA - Personal Assistant could be the key to your dream job. Transform your ambition and enthusiasm into a rewarding career for life by studying from home at your own pace and time. Learn how to handle a wide range of essential office administration tasks, as well as how to write important business letters and handle complex mail and shipping requirements. Making travel arrangements on behalf of others, organising meetings and events, the importance of time management as a PA, and how to become a better communicator are also covered in the course. Our PA - Personal Assistant course has been designed to equip you with the essential knowledge and skills needed to become an expert executive secretary or personal assistant and will give you all the practical knowledge & credentials that you need to excel in your new role. Enrol on our PA - Personal Assistant course today and begin your journey to improve your career prospects with the latest skills and the power of self-belief! Learning Outcomes After completing this PA - Personal Assistant course, learner will be able to: Understand personal assistant fundamentals Understand business telephone approaches Understand information regarding shipping and mail services Understand travel arrangements Understand outline setting up conferences and meetings Understand management of time Understand systems for record keeping and filing Understand business writing techniques Understand communication skills Understand customer service Understand basics of microsoft office skills Why Choose PA - Personal Assistant Course from Us Self-paced course, access available from anywhere. Easy to understand, high-quality study materials. Executive Secretary & PA Course developed by industry experts. MCQ quiz after each module to assess your learning. Automated and instant assessment results. 24/7 support via live chat, phone call or email. Free PDF certificate as soon as completing the course. ***Courses are included in this PA - Personal Assistant Bundle Course Course 01: Executive Secretary & PA Training Course 02: Minute Taking Course 03: Workplace Stress Management Course 04: Self Esteem & Assertiveness Skill Course Others benefits of this PA - Personal Assistant bundle course 4 Free PDF Certificate Lifetime Access Free Retake Exam Tutor Support [ Note: Free PDF certificate as soon as completing the PA - Personal Assistant course] Course Curriculum Of Executive Secretary & PA Training Module 01: Personal Assistant Fundamentals Module 02: Business Telephone Approaches Module 03: Information regarding shipping and mail services Module 04: An Overview of Travel Arrangements Module 05: Outline setting up conferences and meetings Module 06: Management of time Module 07: Systems for Record Keeping and Filing Module 08: Business Writing Techniques Module 09: Communication Skills Module 10: Customer Service Module 11: Basics of Microsoft Office Skills >>----------------------<< Assessment Method After completing each module of the PA - Personal Assistant Course, you will find automated MCQ quizzes. To unlock the next module, you need to complete the quiz task and get at least 60% marks. Certification After completing the MCQ/Assignment assessment for this PA - Personal Assistant course, you will be entitled to a Certificate of Completion from Training Tale. The certificate is in PDF format, which is completely free to download. A printed version is also available upon request. It will also be sent to you through a courier for £13.99. Who is this course for? This PA - Personal Assistant course is designed for existing secretarial/administrative workers seeking advancement or newcomers seeking their first professional position. Requirements There are no specific requirements for this PA - Personal Assistant course because it does not require any advanced knowledge or skills. Career path After completing this PA - Personal Assistant course, you may able to pursue a formal position in professional Personal-Assistant services such as: Personal Executive Assistant Receptionist Office Assistant Support Secretary Office Manager Personal Concierge Executive Assistant

Elevate your brand with compelling copywriting and advertising strategies. Unlock the power of persuasive language and strategic messaging to captivate your audience and drive engagement. From crafting irresistible headlines to creating impactful ad campaigns, discover the art and science of effective communication for business success. Explore proven techniques and expert insights to master the dynamic world of copywriting and advertising. Transform your brand's narrative and leave a lasting impression with our comprehensive guide.

Are you ready to delve into the world of economics and understand the forces that shape our society? Our Economics Level 3 Studies course is designed to provide you with a comprehensive understanding of economic principles, theories, and real-world applications. Whether you're aiming for a career in finance, business, or public policy, this course will equip you with the knowledge and skills you need to succeed. Key Features: CPD Certified Free Certificate Developed by Specialist Lifetime Access In this Economics Level 3 course, learners will explore the basics of economics, understanding how markets work and how prices are set. They will learn about supply and demand, and how different factors can affect prices. The course covers production costs and the differences between various market structures, such as perfect competition and monopoly. Students will study key economic indicators like GDP, unemployment, and inflation, and how these measures affect the economy. Additionally, the course addresses income distribution, poverty, and market failures. Learners will delve into fiscal policies, the role of money and banking, and the workings of the financial system. Finally, the course explores international finance, helping students understand global economic interactions. Overall, the course aims to provide a comprehensive understanding of how economic principles and policies shape the world around us. Course Curriculum Module 01: An Introduction to Economics Module 02: The Market System and the Circular Flow Model Module 03: Supply, Demand and Prices Module 04: Elasticity Module 05: Production and Costs Module 06: Market Structure Perfect Competition vs Monopoly Module 07: Measuring GDP and Economic Growth Module 08: Unemployment Module 09: Inflation Module 10: Prices Module 11: Income Distribution and Poverty Module 12: Market Failures Module 13: Fiscal Policy Module 14: Money, Banking and the Financial System Module 15: International Finance Learning Outcomes: Understand basic principles and theories introduced in Economics Level 3 Studies. Analyse the market system using the Circular Flow Model. Evaluate the effects of supply, demand, and prices on markets. Assess elasticity's impact on consumer and producer behaviour. Compare costs in different production stages and market structures. Examine GDP, economic growth, unemployment, and inflation measures. Investigate fiscal policy and the role of money and banking. CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Students interested in economic theory and applications. Individuals aiming to understand market dynamics. Learners curious about economic growth and policy. People wanting insight into financial systems. Those exploring income distribution and poverty issues. Career path Economic Analyst Financial Advisor Market Researcher Policy Analyst Banking Consultant International Trade Specialist Certificates Digital certificate Digital certificate - Included Certificate of Completion Digital certificate - Included Will be downloadable when all lectures have been completed.

Are you ready to delve into the world of economics and understand the forces that shape our society? Our Economics Level 3 Studies course is designed to provide you with a comprehensive understanding of economic principles, theories, and real-world applications. Whether you're aiming for a career in finance, business, or public policy, this course will equip you with the knowledge and skills you need to succeed. Key Features: CPD Certified Developed by Specialist Lifetime Access In this Economics Level 3 course, learners will explore the basics of economics, understanding how markets work and how prices are set. They will learn about supply and demand, and how different factors can affect prices. The course covers production costs and the differences between various market structures, such as perfect competition and monopoly. Students will study key economic indicators like GDP, unemployment, and inflation, and how these measures affect the economy. Additionally, the course addresses income distribution, poverty, and market failures. Learners will delve into fiscal policies, the role of money and banking, and the workings of the financial system. Finally, the course explores international finance, helping students understand global economic interactions. Overall, the course aims to provide a comprehensive understanding of how economic principles and policies shape the world around us. Course Curriculum Module 01: An Introduction to Economics Module 02: The Market System and the Circular Flow Model Module 03: Supply, Demand and Prices Module 04: Elasticity Module 05: Production and Costs Module 06: Market Structure Perfect Competition vs Monopoly Module 07: Measuring GDP and Economic Growth Module 08: Unemployment Module 09: Inflation Module 10: Prices Module 11: Income Distribution and Poverty Module 12: Market Failures Module 13: Fiscal Policy Module 14: Money, Banking and the Financial System Module 15: International Finance Learning Outcomes: Understand basic principles and theories introduced in Economics Level 3 Studies. Analyse the market system using the Circular Flow Model. Evaluate the effects of supply, demand, and prices on markets. Assess elasticity's impact on consumer and producer behaviour. Compare costs in different production stages and market structures. Examine GDP, economic growth, unemployment, and inflation measures. Investigate fiscal policy and the role of money and banking. CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Students interested in economic theory and applications. Individuals aiming to understand market dynamics. Learners curious about economic growth and policy. People wanting insight into financial systems. Those exploring income distribution and poverty issues. Career path Economic Analyst Financial Advisor Market Researcher Policy Analyst Banking Consultant International Trade Specialist Certificates Digital certificate Digital certificate - Included Will be downloadable when all lectures have been completed.

The Manager Skills: Leading in Management course provides a comprehensive understanding of management and leadership principles. Participants will learn essential skills such as motivating employees, effective communication, conflict management, and risk assessment. Additionally, the course covers important topics like emotional intelligence, corporate responsibility, and the use of Microsoft Office tools for efficient management. Learning Outcomes: Gain a thorough understanding of management and leadership concepts. Familiarize with various leadership theories and their applications. Improve management and leadership performance through practical techniques. Develop high-performance teams and foster a collaborative work environment. Acquire skills to motivate employees and enhance their job satisfaction. Master organizational skills to streamline processes and boost productivity. Learn effective talent management and succession planning strategies. Develop proficiency in business process management and communication. Why buy this Manager Skills: Leading in Management? Unlimited access to the course for forever Digital Certificate, Transcript, student ID all included in the price Absolutely no hidden fees Directly receive CPD accredited qualifications after course completion Receive one to one assistance on every weekday from professionals Immediately receive the PDF certificate after passing Receive the original copies of your certificate and transcript on the next working day Easily learn the skills and knowledge from the comfort of your home Certification After studying the course materials of the Manager Skills: Leading in Management there will be a written assignment test which you can take either during or at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60. Who is this course for? Aspiring managers and team leaders looking to enhance their leadership skills. Experienced managers seeking to refine their management techniques. Professionals transitioning into managerial roles. Individuals in leadership positions who want to improve team dynamics and employee motivation. Prerequisites This Manager Skills: Leading in Management does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Manager Skills: Leading in Management was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Career path Team Leader/Supervisor: Oversee and manage a team's daily operations and performance. Department Manager: Lead and coordinate activities within a specific department. Project Manager: Plan, execute, and oversee projects to achieve specific objectives. Human Resources Manager: Manage HR functions, talent acquisition, and employee development. Operations Manager: Oversee day-to-day business operations and optimize efficiency. Course Curriculum Module 1: Understanding Management and Leadership Understanding Management and Leadership 00:42:00 Module 2: Leadership Theories Leadership Theories 00:27:00 Module 3: Improving Management and Leadership Performance Improving Management and Leadership Performance 00:17:00 Module 4: High Performance Teams High Performance Teams 00:34:00 Module 5: Motivating Employees Motivating Employees 00:28:00 Module 6: Organisational Skills Organisational Skills 00:28:00 Module 7: Talent Management Talent Management 00:39:00 Module 8: Succession Planning Succession Planning 00:26:00 Module 9: Business Process Management Business Process Management 00:30:00 Module 10: Communication Skills Communication Skills 00:29:00 Module 11: Negotiation Techniques Negotiation Techniques 00:17:00 Module 12: Managing Meetings and Giving Feedback Managing Meetings and Giving Feedback 00:24:00 Module 13: Managing Change Managing Change 00:24:00 Module 14: Time Management Time Management 00:39:00 Module 15: Stress Management Stress Management 00:17:00 Module 16: Emotional Intelligence in Leadership Emotional Intelligence in Leadership 00:34:00 Module 17: Managing Conflict Managing Conflict 00:24:00 Module 18: Dealing with Office Politics Dealing with Office Politics 00:36:00 Module 19: Risk Management Risk Management 00:37:00 Module 20: Corporate Responsibility and Ethics Corporate Responsibility and Ethics 00:16:00 Module 21:Microsoft Word, Excel, PowerPoint Microsoft Word 08:06:00 Microsoft Excel 03:59:00 Microsoft PowerPoint 08:24:00 Assignment Assignment - Manager Skills: Leading in Management 00:00:00

Highlights of the Course Course Type: Online Learning Duration: 4 hours 13 minutes Tutor Support: Tutor support is included Customer Support: 24/7 customer support is available Quality Training: The course is designed by an industry expert Recognised Credential: Recognised and Valuable Certification Completion Certificate: Free Course Completion Certificate Included Instalment: 3 Installment Plan on checkout What you will learn from this course? Gain comprehensive knowledge about microsoft excel Understand the core competencies and principles of microsoft excel Explore the various areas of microsoft excel Know how to apply the skills you acquired from this course in a real-life context Become a confident and expert office admin Microsoft Excel Online Training Course Master the skills you need to propel your career forward in Microsoft excel. This course will equip you with the essential knowledge and skillset that will make you a confident office admin and take your career to the next level. This comprehensive Microsoft Excel course is designed to help you surpass your professional goals. The skills and knowledge that you will gain through studying this Microsoft Excel course will help you get one step closer to your professional aspirations and develop your skills for a rewarding career. This comprehensive course will teach you the theory of effective Microsoft excel practice and equip you with the essential skills, confidence and competence to assist you in the Microsoft excel industry. You'll gain a solid understanding of the core competencies required to drive a successful career in Microsoft excel. This course is designed by industry experts, so you'll gain knowledge and skills based on the latest expertise and best practices. This extensive course is designed for office admin or for people who are aspiring to specialise in Microsoft excel. Enrol in this Microsoft Excel course today and take the next step towards your personal and professional goals. Earn industry-recognised credentials to demonstrate your new skills and add extra value to your CV that will help you outshine other candidates. Who is this Course for? This comprehensive Microsoft Excel course is ideal for anyone wishing to boost their career profile or advance their career in this field by gaining a thorough understanding of the subject. Anyone willing to gain extensive knowledge on this Microsoft Excel can also take this course. Whether you are a complete beginner or an aspiring professional, this course will provide you with the necessary skills and professional competence, and open your doors to a wide number of professions within your chosen sector. Entry Requirements This Microsoft Excel course has no academic prerequisites and is open to students from all academic disciplines. You will, however, need a laptop, desktop, tablet, or smartphone, as well as a reliable internet connection. Assessment This Microsoft Excel course assesses learners through multiple-choice questions (MCQs). Upon successful completion of the modules, learners must answer MCQs to complete the assessment procedure. Through the MCQs, it is measured how much a learner could grasp from each section. In the assessment pass mark is 60%. Advance Your Career This Microsoft Excel course will provide you with a fresh opportunity to enter the relevant job market and choose your desired career path. Additionally, you will be able to advance your career, increase your level of competition in your chosen field, and highlight these skills on your resume. Recognised Accreditation This course is accredited by continuing professional development (CPD). CPD UK is globally recognised by employers, professional organisations, and academic institutions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. What is CPD? Employers, professional organisations, and academic institutions all recognise CPD, therefore a credential from CPD Certification Service adds value to your professional goals and achievements. Benefits of CPD Improve your employment prospects Boost your job satisfaction Promotes career advancement Enhances your CV Provides you with a competitive edge in the job market Demonstrate your dedication Showcases your professional capabilities What is IPHM? The IPHM is an Accreditation Board that provides Training Providers with international and global accreditation. The Practitioners of Holistic Medicine (IPHM) accreditation is a guarantee of quality and skill. Benefits of IPHM It will help you establish a positive reputation in your chosen field You can join a network and community of successful therapists that are dedicated to providing excellent care to their client You can flaunt this accreditation in your CV It is a worldwide recognised accreditation What is Quality Licence Scheme? This course is endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. Benefits of Quality License Scheme Certificate is valuable Provides a competitive edge in your career It will make your CV stand out Course Curriculum Microsoft Excel: Basic Level Introduction to Microsoft Excel 0101 Touring the interface 00:03:00 0102 Enter data & saving workbook 00:04:00 0103 Applying Formulas 00:03:00 0104 Changing a worksheet's structure 00:04:00 0105 Find, Replace & Spell Check 00:03:00 0106 Applying fonts, background colors, and borders 00:05:00 0107 Formatting numbers and dates 00:04:00 0108 Making the pieces fit 00:04:00 0109 Inserting headers & footers and Repeating Rows 00:02:00 0110 Managing Large Workbooks 00:05:00 Microsoft Excel: Intermediate Level Excel Essentials 0201 Formula Writing (Don't Miss This) 00:08:00 Ex 0201 Formula Writing (Don't Miss This) 00:02:00 Sum Count Average Functionality - With Conditions 0301 SumIf & SumIfs 00:24:00 Ex 0301 SumIf & SumIfs 00:08:00 0302 Count Functions 00:08:00 Ex 0302 Count Functions 00:02:00 0303 AverageIf & AverageIfs 00:03:00 Ex 0303 AverageIf & AverageIfs 00:03:00 Text Functions - Manipulating Text 0401 Change Case (Upper, Lower, Proper) 00:04:00 Ex 0401 Change Case (Upper, Lower, Proper) 00:03:00 0402 Separating Text on Symmetrical Data 00:06:00 Ex 0402 Separating Text on Symmetrical Data 00:06:00 0403 Separating Text on Non-Symmetrical Data 00:08:00 Ex 0403 Separating Text on Non-Symmetrical Data 00:05:00 Logical Functions - Working With Conditions 0501 If Functionality 00:04:00 Ex 0501 IF Functionality 00:03:00 0502 If with AND 00:05:00 Ex 0502 If with AND 00:03:00 0503 If with OR 00:03:00 Ex 0503 If with OR 00:03:00 0504 If with “AND” & “OR” / IF with Countif 00:08:00 Ex 0504 If with “AND” & “OR” / IF with Countif 00:04:00 0505 Nested IF (A Genie with 3 wishes) 00:13:00 Ex 0505 Nested IF (A Genie with 3 wishes) 00:05:00 Lookup Functionality - Burn Simple Find Technique 0601 Vlookup (Exact Match) # 1 00:23:00 Ex 0601 Vlookup (Exact Match) # 1 00:04:00 0602 Type of References (Use of $ sign) 00:11:00 0603 Vlookup (Exact Match) # 2 00:04:00 Ex 0603 Vlookup (Exact Match) # 2 00:06:00 0604 Double Vlookup 00:11:00 Ex 0604 Double Vlookup 00:10:00 0605 Vlookup on Duplicate Values 00:10:00 Ex 0605 Vlookup on Duplicate Values 00:05:00 0606 Vlookup (Approximate Match) 00:08:00 Ex 0606 Vlookup (Approximate Match) 00:02:00 0607 Vlookup with If (Conditional Vlookup) 00:05:00 Ex 0607 Vlookup with If (Conditional Vlookup) 00:02:00 0608 Hlookup (Exact Match) 00:03:00 Ex 0608 Hlookup (Exact Match) 00:03:00 0609 Hlookup (Approximate Match) 00:02:00 Ex 0609 Hlookup (Approximate Match) 00:02:00 0610 Lookup (Don't use this !) 00:05:00 Ex 0610 Lookup (Don't use this !) 00:02:00 0611 Vlookup with Match (Create Magical Vlookup) 00:14:00 Ex 0611 Vlookup with Match (Create Magical Vlookup) 00:05:00 0612 Match (Gives us Column/Row Index #) 00:03:00 Ex 0612 Match (Gives us Column/Row Index #) 00:03:00 0613 Index & Match (Made for Each Other) 00:11:00 Ex 0613 (1) Index & Match (Made for Each Other) 00:05:00 Ex 0613 (2) Index & Match (Made for Each Other) 00:03:00 Date & Time Function - A Tricky Game 0701 How Excel Records Date & Time 00:02:00 0702 Now, Today & Autofill 00:02:00 0703 DateValue & TimeValue 00:02:00 0704 Calculate WorkingDays 00:03:00 0705 DatedIf 00:05:00 Financial Functions 0801 Loan Calculation (PMT, PPMT, IPMT etc.) 00:12:00 Ex 0801 Loan Calculation (PMT, PPMT, IPMT etc.) 00:07:00 0802 Creating a Loan Table 00:09:00 Ex 0802 Creating a Loan Table 00:06:00 0803 Calculate Depriciation 00:02:00 Ex 0803 Calculate Depriciation 00:02:00 Sort & Filter 0901 Basic Sorting & Shortcut keys 00:16:00 Ex 0901 Basic Sorting & Shortcut keys 00:06:00 0902 Sorting Using Custom List 00:08:00 Ex 0902 Sorting Using Custom List 00:02:00 0903 Horizontal Sorting 00:01:00 Ex 0903 Horizontal Sorting 00:01:00 0904 Basic Filter & Shortcut Keys 00:09:00 Ex 0904 Basic Filter & Shortcut Keys 00:05:00 0905 Filter Problem # 1 (Copy Filtered Data without hidden rows) 00:06:00 Ex 0905 Filter Problem # 1 (Copy Filtered Data without hidden rows) 00:03:00 0906 Filter Problem # 2 (Pasting Values on Filtered Data) 00:07:00 Ex 0906 Filter Problem # 2 (Pasting Values on Filtered Data) 00:02:00 0907 Filter Problem # 3 (Performing Calculation on Filtered Data) 00:07:00 Ex 0907 Filter Problem # 3 (Performing Calculation on Filtered Data) 00:01:00 0908 Advanced Filter (Applying Complex Criteria's) 00:13:00 Ex 0908 Advanced Filter (Applying Complex Criteria's) 00:05:00 Microsoft Excel: Advanced Level Excel Charts - Visual Presentation 1001 How to create a chart 00:06:00 1002 Format Axis 00:02:00 1003 Plot Values on Secondary Axis 00:04:00 1004 Life of Pie (Charts) 00:03:00 1005 How to Show Axis Title 00:03:00 1006 How to Show Data Label 00:02:00 1007 Show data with chart in Data Table 00:02:00 1008 Column Chart 00:02:00 1009 Bar Chart 00:02:00 1010 Line Chart 1 00:03:00 1011 Line Chart 2 00:03:00 1012 Area Chart 00:01:00 1013 Pie Chart 00:03:00 1014 Pie of Pie or Bar of Pie 00:03:00 1015 Line Chart with Log Scale 00:02:00 1016 Bubble Chart 00:01:00 1017 Selecting Chart Elements 00:05:00 1018 Use of Format Dialog box 00:03:00 1019 Modifying Chart & Plot Area 00:04:00 1020 Modifying Data Series 00:02:00 1021 How to handle Missing Data 00:04:00 1022 Modifying 3-D Charts 00:03:00 1023 Creating Combination of upto 5 Different Charts 00:03:00 1025 Creating Picture Charts 00:02:00 Data Consolidation - Multiple Workbooks Worksheets Consolidate Data using Excel Inbuilt Function 00:06:00 Ex Consolidate Data using Excel Inbuilt Function 00:03:00 Data Validation 1201 Applying Data Validation 00:13:00 Ex 1201 Applying Data Validation 00:05:00 1202 Dependent Dropdown List 00:07:00 Ex1202 Dependent Dropdown List 00:05:00 Using Data Validation with Vlookup & Match 00:05:00 Other Data Validation Examples 00:10:00 Protection of Worksheet Workbook 1301 Worksheet Level Protection 00:01:00 Ex 1301 Worksheet Level Protection 00:01:00 1302 Cell Level Protection 00:05:00 Ex 1302 Cell Level Protection 00:02:00 1303 Hiding Formulas from Formula Bar 00:03:00 Ex 1303 Hiding Formulas from Formula Bar 00:02:00 1304 Protecting Workbook Structure 00:01:00 Ex 1304 Protecting Workbook Structure 00:01:00 1305 Workbook Level Protection 00:02:00 Ex 1305 Workbook Level Protection 00:01:00 Pivot Table & Techniques 1401 Understanding pivot Table 00:12:00 1402 Using Pivot Table in Real Scenario 00:10:00 Ex 1402 Using Pivot Table in Real Scenario 00:09:00 1403 Grouping in Pivot Table 00:04:00 Ex 1403 Grouping in Pivot Table 00:01:00 1404 Using Slicers (A Visually attractive Filter) 00:03:00 Ex 1404 Using Slicers (A Visually attractive Filter) 00:01:00 What-If Analysis & Solver Add-In 1501 Goal Seek (A Reverse Approach) 00:04:00 Ex 1501 Goal Seek (A Reverse Approach) 00:02:00 1502 One Way Data Table 00:03:00 1503 Two Way Data Table 00:02:00 1504 Scenario Manager 00:04:00 1505 Solver Add-In 00:07:00 Automation in Excel - Macros 1601 Record your first Macro 00:15:00 1602 Record Another Macro 00:02:00 1603 Assigning macro to a Shape, Button, Picture etc 00:02:00 1604 Editing or Deleting a Macro 00:03:00 1605 Security Settings of a Macro 00:02:00 Supplementary Resources Supplementary Resources - Microsoft Excel Diploma 00:00:00 Assessment Assessment - Microsoft Excel Diploma 00:10:00 Obtain Your Certificate Order Your Certificate of Achievement 00:00:00 Get Your Insurance Now Get Your Insurance Now 00:00:00 Feedback Feedback 00:00:00