1264 Cells courses in Cardiff delivered On Demand

Level 2 Microsoft Office Essentials

Overview This Upgrade Your Excel Skills course will unlock your full potential and will show you how to excel in a career in Upgrade Your Excel Skills. So upskill now and reach your full potential. Everything you need to get started in Upgrade Your Excel Skills is available in this course. Learning and progressing are the hallmarks of personal development. This Upgrade Your Excel Skills will quickly teach you the must-have skills needed to start in the relevant industry. In This Upgrade Your Excel Skills Course, You Will: Learn strategies to boost your workplace efficiency. Hone your Upgrade Your Excel Skills to help you advance your career. Acquire a comprehensive understanding of various Upgrade Your Excel Skills topics and tips from industry experts. Learn in-demand Upgrade Your Excel Skills that are in high demand among UK employers, which will help you to kickstart your career. This Upgrade Your Excel Skills course covers everything you must know to stand against the tough competition in the Upgrade Your Excel Skills field.  The future is truly yours to seize with this Upgrade Your Excel Skills. Enrol today and complete the course to achieve a Upgrade Your Excel Skills certificate that can change your professional career forever. Additional Perks of Buying a Course From Institute of Mental Health Study online - whenever and wherever you want. One-to-one support from a dedicated tutor throughout your course. Certificate immediately upon course completion 100% Money back guarantee Exclusive discounts on your next course purchase from Institute of Mental Health Enrolling in the Upgrade Your Excel Skills course can assist you in getting into your desired career quicker than you ever imagined. So without further ado, start now. Process of Evaluation After studying the Upgrade Your Excel Skills course, your skills and knowledge will be tested with a MCQ exam or assignment. You must get a score of 60% to pass the test and get your certificate.  Certificate of Achievement Upon successfully completing the Upgrade Your Excel Skills course, you will get your CPD accredited digital certificate immediately. And you can also claim the hardcopy certificate completely free of charge. All you have to do is pay a shipping charge of just £3.99. Who Is This Course for? This Upgrade Your Excel Skills is suitable for anyone aspiring to start a career in Upgrade Your Excel Skills; even if you are new to this and have no prior knowledge on Upgrade Your Excel Skills, this course is going to be very easy for you to understand.  And if you are already working in the Upgrade Your Excel Skills field, this course will be a great source of knowledge for you to improve your existing skills and take them to the next level.  Taking this Upgrade Your Excel Skills course is a win-win for you in all aspects.  This course has been developed with maximum flexibility and accessibility, making it ideal for people who don't have the time to devote to traditional education. Requirements This Upgrade Your Excel Skills course has no prerequisite.  You don't need any educational qualification or experience to enrol in the Upgrade Your Excel Skills course. Do note: you must be at least 16 years old to enrol. Any internet-connected device, such as a computer, tablet, or smartphone, can access this online Upgrade Your Excel Skills course. Moreover, this course allows you to learn at your own pace while developing transferable and marketable skills. Course Curriculum Unit 01: Introduction Welcome 00:02:00 Unit 02: Excel Productivity Tips -Part 1 Camera Tool 00:05:00 Add Line Break in Formula Bar 00:03:00 Advanced Copy-Paste using Office Clipboard 00:03:00 Navigation between Worksheets using Shortcut Keys 00:01:00 Flash Fill 00:02:00 Add Multiple Rows and Columns Quickly 00:02:00 Delete Blank Rows 00:03:00 Multi Level Row and Column Sorting 00:04:00 Add Sparklines 00:03:00 Paste Special - Transpose 00:03:00 Unit 03: Excel Productivity Tips - Part 2 Snap to Grid 00:03:00 Create Custom Auto fill List 00:06:00 Absolute Cell Reference 00:03:00 Import Data from Web page 00:04:00 Move Cell Direction 00:03:00 Delete Data using Mouse 00:02:00 Status Bar Quick Calculations 00:03:00 Link Text Boxes to Cell 00:04:00 Phone Number and ZIP Code Format 00:04:00 Speaking Cell 00:05:00 Unit 04: Excel Productivity Tips - Part 3 Invisible Text 00:03:00 Worksheet Grouping 00:04:00 Advanced Transpose 00:04:00 XLStart Folder 00:03:00 Use Slicers 00:05:00 Convert Text to Numbers 00:03:00 Hiding Workbook Elements 00:02:00 Useful Shortcut Keys 00:03:00 Sort data from Left to Right 00:03:00 Advanced Filter (Complex) 00:11:00 Unit 05: Excel Productivity Tips - Part 4 Email as PDF 00:02:00 Synchronous Scrolling 00:03:00 Quick Analysis of data within Excel 00:02:00 Fill blank cells with Value 00:03:00 Hidden Chart Source Data 00:03:00 Two more Shortcuts 00:03:00 Add Blank Rows 00:03:00 Custom views in Excel 00:06:00 EMBED Feature 00:04:00 Adding Country code in Mobile Numbers 00:04:00 Unit 05: Excel Productivity Tips - Part 5 Plot an Average Line to a Chart 00:04:00 3D Referencing 00:04:00 Extract Unique Values 00:03:00 Excel Array Formula 00:04:00 Forecast Sheet 00:04:00 Add Spin Controls in Excel 00:05:00 Move Data using Mouse 00:01:00 Add new entry in Auto Correct to use across Office Applications 00:05:00 Find Differences between Two Lists 00:02:00 Find formulas Quickly 00:02:00 Unit: 06 Wrap Up Thank You 00:01:00

Microsoft Office 2016 Essentials is yet another 'Teacher's Choice' course from Teachers Training for a complete understanding of the fundamental topics. You are also entitled to exclusive tutor support and a professional CPD-accredited certificate in addition to the special discounted price for a limited time. Just like all our courses, this Microsoft Office 2016 Essentials and its curriculum have also been designed by expert teachers so that teachers of tomorrow can learn from the best and equip themselves with all the necessary skills. Consisting of several modules, the course teaches you everything you need to succeed in this profession. The course can be studied part-time. You can become accredited within 17 Hours studying at your own pace. Your qualification will be recognised and can be checked for validity on our dedicated website. Why Choose Teachers Training Some of our website features are: This is a dedicated website for teaching 24/7 tutor support Interactive Content Affordable price Courses accredited by the UK's top awarding bodies 100% online Flexible deadline Entry Requirements No formal entry requirements. You need to have: Passion for learning A good understanding of the English language Be motivated and hard-working Over the age of 16. Certification CPD Certification from The Teachers Training Successfully completing the MCQ exam of this course qualifies you for a CPD-accredited certificate from The Teachers Training. You will be eligible for both PDF copy and hard copy of the certificate to showcase your achievement however you wish. You can get your digital certificate (PDF) for £4.99 only Hard copy certificates are also available, and you can get one for only £10.99 You can get both PDF and Hard copy certificates for just £12.99! The certificate will add significant weight to your CV and will give you a competitive advantage when applying for jobs. Excel 2016 Getting Started With Microsoft Office Excel 2016 Navigate the Excel User Interface 00:28:00 Use Excel Commands 00:10:00 Create and Save a Basic Workbook 00:19:00 Enter Cell Data 00:12:00 Use Excel Help 00:05:00 Performing Calculations Create Worksheet Formulas 00:15:00 Insert Functions 00:17:00 Reuse Formulas and Functions 00:17:00 Modifying a Worksheet Insert, Delete, and Adjust Cells, Columns, and Rows 00:10:00 Search for and Replace Data 00:09:00 Use Proofing and Research Tools 00:07:00 Formatting a Worksheet Apply Text Formats 00:16:00 Apply Number Format 00:08:00 Align Cell Contents 00:09:00 Apply Styles and Themes 00:12:00 Apply Basic Conditional Formatting 00:11:00 Create and Use Templates 00:08:00 Printing Workbooks Preview and Print a Workbook 00:10:00 Set Up the Page Layout 00:09:00 Configure Headers and Footers 00:07:00 Managing Workbooks Manage Worksheets 00:05:00 Manage Workbook and Worksheet Views 00:07:00 Manage Workbook Properties 00:06:00 Word 2016 Getting Started with Word Navigate in Microsoft Word 00:12:00 Create and Save Word Documents 00:24:00 Manage Your Workspace 00:06:00 Edit Documents 00:16:00 Preview and Print Documents 00:04:00 Customize the Word Environment 00:08:00 Formatting Text and Paragraphs Apply Character Formatting 00:17:00 Control Paragraph Layout 00:19:00 Align Text Using Tabs 00:07:00 Display Text in Bulleted or Numbered Lists 00:03:00 Apply Borders and Shading 00:05:00 Working More Efficiently Make Repetitive Edits 00:06:00 Apply Repetitive Formatting 00:10:00 Use Styles to Streamline Repetitive Formatting Tasks 00:14:00 Managing Lists Sort a List 00:05:00 Format a List 00:06:00 Adding Tables Insert a Table 00:07:00 Modify a Table 00:06:00 Format a Table 00:03:00 Convert Text to a Table 00:04:00 Inserting Graphic Objects Insert Symbols and Special Characters 00:04:00 Add Images to a Document 00:11:00 Controlling Page Appearance Apply a Page Border and Color 00:03:00 Add Headers and Footers 00:06:00 Control Page Layout 00:05:00 Add a Watermark 00:04:00 Preparing to Publish a Document Check Spelling Grammar and Readability 00:07:00 Use Research Tools 00:06:00 Check Accessibility 00:03:00 Save a Document to Other Formats 00:04:00 Workbooks - Microsoft Word 2016 (Beginner) Workbooks - Microsoft Word 2019 00:00:00 PowerPoint 2016 PowerPoint Interface Navigate the PowerPoint Environment 00:28:00 View and Navigate a Presentation 00:15:00 Create and Save a PowerPoint Presentation 00:13:00 Use PowerPoint Help 00:10:00 Presentation Basics Select a Presentation Type 00:08:00 Edit Text 00:13:00 Build a Presentation 00:27:00 Formatting Format Characters 00:11:00 Format Paragraphs 00:16:00 Format Text Boxes 00:09:00 Inserting Options Insert Images 00:10:00 Insert Shapes 00:15:00 Working with Objects Edit Objects 00:16:00 Format Objects 00:06:00 Group Objects 00:04:00 Arrange Objects 00:07:00 Animate Objects 00:07:00 Table Create a Table 00:09:00 Format a Table 00:03:00 Insert a Table from Other Microsoft Office Applications 00:06:00 Charts Create a Chart 00:10:00 Format a Chart 00:10:00 Insert a Chart from Microsoft Excel 00:05:00 Review and Presentatin Review Your Presentation 00:11:00 Apply Transitions 00:05:00 Print Your Presentation 00:05:00 Deliver Your Presentation 00:08:00 Access 2016 Introduction to Access Orientation to Microsoft Access 00:39:00 Create a Simple Access Database 00:10:00 Get Help and Configure Options in Microsoft Access 00:06:00 Modify Data Modify Table Data 00:17:00 Sort and Filter Records 00:05:00 Working with Queries Create Basic Queries 00:15:00 Sort and Filter Data in a Query 00:14:00 Perform Calculations in a Query 00:08:00 Access Forms Create Basic Access Forms 00:07:00 Work with Data on Access Forms 00:23:00 Working with Reports Create a Report 00:23:00 Add Controls to a Report 00:12:00 Enhance the Appearance of a Report 00:05:00 Prepare a Report for Print 00:03:00 Organize Report Information 00:15:00 Format Reports 00:12:00

Description: Customer service is an essential part of any business. Companies always look for the people who have the strong command over handling customer issues. With the help of the Customer Service Training - Complete Video Course, you gain mastery over customer service skills. The bundle video course covers all the necessary parts that a person should know for managing the customer service. For understanding the skill properly, the course is divided into several sections and sub-sections. Firstly, in the Customer Service Skills part, you will be introduced to the fundamentals of customer service including the telephone etiquette. Then, you will learn about the communication procedures in the Communication Essential sections. You will learn about the different types of communication covering business communication, verbal and non-verbal communication, written and electrical communication, etc. Next section is Time Management- one of the best and most efficient parts of any business. Here, you will know the tips and techniques for managing time properly. After that, you will be introduced to the Microsoft Office Word and Microsoft Office Excel. These are two necessary skills that every employee should know for managing the customer service properly. You will learn to use these two applications. Finally, it can be said that the Customer Service Training - Complete Video Course course helps you to achieve the necessary skills for grabbing the attention of the customers with proper etiquette and create a long-term relationship with them. Assessment: At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? Customer Service Training - Complete Video Course is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our Customer Service Training - Complete Video Course is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Understanding Customer Service Understanding Customer Service FREE 00:17:00 Identifying Customer Expectations 00:06:00 Providing Excellent Customer Service 00:07:00 Focusing on the Customer Focusing on the Customer 00:08:00 Customer Service and the Telephone Customer Service and the Telephone 00:08:00 Handling Complaints Handling Complaints 00:12:00 Enduring Stress Enduring Stress 00:13:00 Business Communication Identifying Basic Communication Techniques FREE 00:09:00 Formal and Informal Communication 00:02:00 Verbal and Non-verbal Communication Describing Verbal and Non-verbal Communication 00:04:00 Understanding Body Language 00:05:00 Making Effective Presentations 00:10:00 Fundamentals of Productive Meetings 00:08:00 Written Communication Written Communication 00:13:00 Electronic Communication Electronic Communication 00:19:00 Communicating with Graphics Creating Graphics for Business Communication 00:04:00 Communicating Static Information 00:03:00 Communicating Dynamic Information 00:03:00 Effectively Working for Your Boss Representing Your Boss 00:06:00 Communicating Your Boss's Decisions 00:03:00 Supporting Your Boss and Colleagues 00:04:00 Building a Partnership with Your Boss 00:13:00 Identifying Goals Identifying Goals FREE 00:10:00 Effective Energy Distribution Energy Distribution 00:09:00 Time Logs 00:11:00 Working with Your Personal Style Personal World View 00:10:00 Strengths 00:09:00 Building Your Toolbox A Building Your Toolbox 00:10:00 Establishing Your Action Plan Establishing Your Action Plan 00:11:00 Getting Started with Word Navigate in Microsoft Word FREE 00:12:00 Create and Save Word Documents 00:24:00 Manage Your Workspace 00:06:00 Edit Documents 00:16:00 Preview and Print Documents 00:04:00 Customize the Word Environment 00:08:00 Formatting Text and Paragraphs Apply Character Formatting 00:17:00 Control Paragraph Layout 00:19:00 Align Text Using Tabs 00:07:00 Display Text in Bulleted or Numbered Lists 00:03:00 Apply Borders and Shading 00:04:00 Working More Efficiently Make Repetitive Edits 00:06:00 Apply Repetitive Formatting 00:10:00 Use Styles to Streamline Repetitive Formatting Tasks 00:14:00 Managing Lists Sort a List 00:05:00 Format a List 00:06:00 Adding Tables Insert a Table 00:07:00 Modify a Table 00:06:00 Format a Table 00:03:00 Convert Text to a Table 00:04:00 Inserting Graphic Objects Insert Symbols and Special Characters 00:04:00 Add Images to a Document 00:11:00 Controlling Page Appearance Apply a Page Border and Color 00:03:00 Add Headers and Footers 00:06:00 Control Page Layout 00:05:00 Add a Watermark 00:04:00 Preparing to Publish a Document Check Spelling Grammar and Readability 00:07:00 Use Research Tools 00:06:00 Check Accessibility 00:03:00 Save a Document to Other Formats 00:04:00 Getting Started with Microsoft Office Excel 2016 Navigate the Excel User Interface FREE 00:28:00 Use Excel Commands 00:10:00 Create and Save a Basic Workbook 00:19:00 Enter Cell Data 00:12:00 Use Excel Help 00:05:00 Performing Calculations Create Worksheet Formulas 00:15:00 Insert Functions 00:17:00 Reuse Formulas and Functions 00:17:00 Modifying a Worksheet Insert, Delete, and Adjust Cells, Columns, and Rows 00:10:00 Search for and Replace Data 00:09:00 Use Proofing and Research Tools 00:07:00 Formatting a Worksheet Apply Text Formats 00:17:00 Apply Number Format 00:08:00 Align Cell Contents 00:09:00 Apply Styles and Themes 00:12:00 Apply Basic Conditional Formatting 00:11:00 Create and Use Templates 00:07:00 Printing Workbooks Preview and Print a Workbook 00:10:00 Set Up the Page Layout 00:08:00 Configure Headers and Footers 00:07:00 Managing Workbooks Manage Worksheets 00:05:00 Manage Workbook and Worksheet Views 00:07:00 Manage Workbook Properties 00:05:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

The Anatomy and Physiology Advanced Diploma offers a profound exploration into the intricate systems of the human body. Through this course, you will gain a deep understanding of human anatomy, from the skeletal structure to the complex systems that keep us functioning daily. The curriculum is designed to provide clear insights into how the body works, covering everything from cells and tissues to organs and systems, ensuring a solid foundation in both the theory and applied science of human biology. In addition to the essential theoretical knowledge, this diploma will enhance your ability to connect anatomical structures with their physiological functions, helping you gain a balanced perspective of how these systems interact. Whether you are seeking to improve your professional qualifications or simply wish to enrich your knowledge, this course is perfect for those wanting to pursue a thorough and detailed understanding of human anatomy and physiology. With expert-led content and a structured approach, you’ll be equipped to confidently advance in your chosen field. Our Anatomy and Physiology Advanced Diploma course is endorsed by the Quality Licence Scheme - QLS, ensuring you acquire new skills and enhance your professional development. Anatomy and Physiology Advanced Diploma QLS Bundle Includes the following Courses Course 01: Advanced Diploma in Anatomy and Physiology at QLS Level 7 Course 02: Basic Biology Course 03: Neurology Course 04: Genetics Course 05: Microbiology Laboratory Technician Key Features of Anatomy and Physiology Advanced Diploma Eligibility for QLS endorsed certificate upon successful completion of the Anatomy and Physiology Advanced Diploma course Free CPD Accredited Course Fully online, interactive Anatomy and Physiology Advanced Diploma course with audio voiceover Self-paced learning and laptop, tablet, smartphone-friendly 24/7 Learning Assistance Discounts on bulk purchases To become successful in your profession, you must have a specific set of skills to succeed in today's competitive world. In this in-depth Anatomy and Physiology Advanced Diplomatraining course, you will develop the most in-demand skills to kickstart your career, as well as upgrade your existing knowledge & skills. Assessment At the end of the Anatomy and Physiology Advanced Diploma course, we will provide assignment and quizzes. For each test, the pass mark will be set to 60%. Accreditation This Anatomy and Physiology Advanced Diploma course is QLS - Quality Licence Scheme Endorsed and CPD Certified, providing you with up-to-date skills and knowledge and helping you to become more competent and effective in your chosen field. Certification CPD Certified: Once you've successfully completed your Anatomy and Physiology Advanced Diploma course, you will immediately be sent a digital certificate. Also, you can have your printed certificate delivered by post (shipping cost £3.99). QLS Endorsed:After successfully completing the Anatomy and Physiology Advanced Diploma course, learners will be able to order an endorsed certificate, titled: Advanced Diploma in Anatomy and Physiology at QLS Level 7, as proof of their achievement. This certificate of achievement endorsed by the Quality Licence Scheme. CPD 55 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This course is ideal for all employees or anyone who genuinely wishes to learn more about Anatomy and Physiology Advanced Diploma basics. Requirements No prior degree or experience is required to enrol in this Anatomy and Physiology Advanced Diploma course. Career path This Anatomy and Physiology Advanced Diploma Course will help you to explore avariety of career paths in the related industry. Certificates Digital certificate Digital certificate - Included Hardcopy Certificate Hard copy certificate - Included Hardcopy Certificate (UK Delivery): For those who wish to have a physical token of their achievement, we offer a high-quality, printed certificate. This hardcopy certificate is also provided free of charge. However, please note that delivery fees apply. If your shipping address is within the United Kingdom, the delivery fee will be only £3.99. Hardcopy Certificate (International Delivery): For all international addresses outside of the United Kingdom, the delivery fee for a hardcopy certificate will be only £10.

A personal trainer is someone who develops and delivers safe and effective exercise programmes for seemingly healthy individuals and groups, as well as those who have medical clearance to exercise. They motivate clients by working together to set goals, providing meaningful feedback, and being a trustworthy source of accountability. Do you have an interest in the fitness trainer profession? Are you looking for the best Personal Trainer + Personal Exercise + Nutrition and Health certification in the industry? If this is the case, you should not be concerned. We are here to meet your needs. Our professionals created this course to provide you with advanced skills, knowledge, and confidence to help you build a long-term career in this field. This Personal Trainer + Personal Exercise + Nutrition and Health course is ideal for those who are currently working or hoping to start a career in the trainer profession. This course is also appropriate for anyone with an interest in or desire to learn a variety of fundamental skills required to become a successful personal trainer. This course is a comprehensive, online course that will provide you with a complete understanding of the topic. Learning Outcomes After completing this Personal Trainer + Personal Exercise + Nutrition and Health Bundle course, the learner will be able to Gain a range of core skills needed to become a successful personal trainer. Gain in-depth knowledge of the science of losing weight and gaining muscle. Understand how to warm up safely before exercising and monitor heart rate. Understand how to perform a range of cardio, endurance and resistance exercises. Know how to build stamina and lean muscle. Understand how to perform a range of stretches safely to increase flexibility. Why Choose Personal Trainer + Personal Exercise + Nutrition and Health Bundle Course from Us Self-paced course, access available from anywhere. Easy to understand, high-quality study materials. This Masterclass 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 Personal Trainer + Personal Exercise + Nutrition and Health Bundle Course*** Course 01: Personal Trainer Course 02: Level 2 Award in Improving Personal Exercise, Health and Nutrition Course 03: Level 2 Award in Nutrition and Health ***Other Benefits of Personal Trainer + Personal Exercise + Nutrition and Health Bundle Course*** Free 3 PDF Certificate Access to Content - Lifetime Exam Fee - Totally Free Free Retake Exam [ Note: Free PDF certificate will provide as soon as completing the Personal Trainer + Personal Exercise + Nutrition and Health course ] Detailed course curriculum *** Personal Trainer + Personal Exercise + Nutrition and Health*** Module 1: Professionalism and Presentation Personal Training Examining the Sector of Personal Training The professionalism of Personal Trainers in Business Presentation and Qualifications in Personal Training Marketing and Sales Module 2: Planning a Personal Training Session Principles and Characteristics of Personal Training Planning Activities Module 3: Delivering a Personal Training Session Monitoring and Adjusting Exercise Maintaining Good Communication and Motivation Different Personal Training Environments Extending Frequent and Good Communication to Clients Module 4: Skeletal Articulations and Joint Movement Connective Tissue Joint Structure Lever Systems Effects of Resistance Training on Joints Module 5: Injury Prevention Osteoporosis Spinal Injury Prevention Shoulder Stabilisation Ligamentous Damage Module 6: Muscular System Contraction Types and Their Characteristics Acute Muscle Adaptations to Different Training Types Chronic Muscle Adaptation to Training Muscle Functions of the Hip and Thoracolumbar Fascia Module 7: Energy Systems Three Energy Systems Acute Variables and Energy Systems Effects of EPOC and Interval Training on Metabolism Fat Burning METs and Calories Methods for Monitoring Exercise Use of Energy From Nutrients Module 8: Cardiorespiratory System Cardiovascular System Respiratory System Module 9: Nervous System The organisation of the Nervous System The function of the Nervous System Nervous System and Exercise Module 10: Hormonal Responses to Exercise Structural Overview of the Endocrine System Classification of Hormones Hormone Interactions With Target Cells Hormonal Responses to Acute Exercise Hormonal Adaptations to Chronic Exercise Training Module 11: Health and Fitness Assessment Defining Health and Fitness Preliminary Health Assessment Fitness Assessments Module 12: Psychological Aspects of Personal Training Role of Psychology in Personal Training Goals and Goal Setting Beliefs and Expectations Emotions, Stress and Coping Module 13: Nutrition Energy Requirement Estimating Energy Expenditure Calculating Energy Needs Recommended Dietary Intakes Healthy Eating Patterns How Dietary Intake Influences Health Micronutrient Deficiency and Health Fads and Popular Diets Developing a Healthy, Balanced Way of Eating Tobacco, Alcohol and Caffeine Fat and Lipoprotein Safe and Effective Weight Loss and Gain Module 14: Training Adaptations Adaptations to Training Principles Adaptations to Resistance Training Adaptations to Aerobic Training Adaptations to Range of Motion Training Module 15: Exercise Planning and Programming Planning for Resistance Training Planning for Aerobic Endurance Training Applied Training Programming Examples of Exercise Programming -------------------- [ Bundle Course 02 ] *Level 2 Award in Improving Personal Exercise, Health and Nutrition Course Curriculum Module 01: Understand Health, Well-being and Exercise Module 02: Understand the Role of Nutrition in Exercise Module 03: Plan and Prepare for Personal Exercise and Nutrition -------------------- [ Bundle Course 03 ] *Level 2 Award in Nutrition and Health Course Curriculum Module 01: Explore Principles of Healthy Eating Module 02: Consider Nutritional Needs of a Variety of Individuals Module 03: Use Food and Nutrition Information to Plan a Healthy Diet Assessment Method After completing each module of the Personal Trainer + Personal Exercise + Nutrition and Health 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. Once you complete all the modules in this manner, you will be qualified to request your certification. Certification After completing the MCQ/Assignment assessment for this Personal Trainer + Personal Exercise + Nutrition and Health course, you will be entitled to a Certificate of Completion from Training Tale. It will act as proof of your extensive professional development. 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? Personal Trainer + Personal Exercise + Nutrition and Health course is designed for those who want to learn the skills needed to start a successful career in the fitness industry. Our course is also suitable for anyone interested in learning the science of weight loss and developing the ideal workout routine to achieve their long-term fitness goals. Requirements Students who intend to enrol in this Personal Trainer + Personal Exercise + Nutrition and Health course must meet the following requirements: 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 After completing Personal Trainer + Personal Exercise + Nutrition and Health course, you will have the necessary knowledge and skillset to start your training business. You can also make it a full-time job by working in gyms, clients' homes, fitness centres, and other professional settings. Such as: Fitness Instructor Fitness Coach Gym Instructor etc. Certificates Certificate of completion Digital certificate - Included

This course offers an immersive experience in data analysis, guiding you from initial setup with Python and Pandas, through series and DataFrame manipulation, to advanced data visualization techniques. Perfect for enhancing your data handling and analysis skills.

Start your data science journey with this carefully constructed comprehensive course and get hands-on experience with Python for data science. Gain in-depth knowledge about core Python and essential mathematical concepts in linear algebra, probability, and statistics. Complete data science training with 13+ hours of content.

Overview This comprehensive course on General Inorganic Chemistry will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This General Inorganic Chemistry comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this General Inorganic Chemistry. It is available to all students, of all academic backgrounds. Requirements Our General Inorganic Chemistry is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. 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 qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management, Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 22 sections • 151 lectures • 14:47:00 total length •Learning objectives: 00:10:00 •Example of a solved problem: 00:06:00 •System of measurement: 00:02:00 •International system of units: 00:05:00 •Temperature units and scales: 00:04:00 •Use and misuse of units: 00:03:00 •Dimensional analysis: 00:03:00 •Quantities and units: Solved problems: 00:10:00 •Atoms: 00:02:00 •Nuclei: 00:04:00 •Periodic table: 00:08:00 •Relative atomic masses: 00:04:00 •Moles: 00:05:00 •Symbols, formulas and molar masses: 00:04:00 •Atomic, molecular and molar masses - Problems with solutions: 00:16:00 •Empirical formula from composition: 00:04:00 •Composition from formula: 00:04:00 •Nuclidic molecular masses and chemical formulas: 00:05:00 •Formulas and compositions: Solved problems: 00:24:00 •Introduction to nomenclature: 00:03:00 •Naming binary compounds of nonmetals: 00:05:00 •Naming ionic compounds: 00:01:00 •Naming monoatomic cations: 00:06:00 •Naming polyatomic cations: 00:03:00 •Naming monoatomic anions: 00:02:00 •Naming oxyanions: 00:05:00 •Naming special anions: 00:01:00 •Putting the names of the ions together: 00:02:00 •Writing formulas for ionic compounds: 00:08:00 •Naming inorganic acids: 00:06:00 •Naming acid salts: 00:04:00 •Naming hydrates: 00:01:00 •Introduction to chemical equations: 00:02:00 •Molecular relations from equations: 00:05:00 •Mass relations from equations: 00:06:00 •Limiting reactant: 00:01:00 •Calculations from chemical equations: Solved problems: 00:24:00 •Types of chemical reactions: 00:04:00 •Pressure: 00:07:00 •Gas laws: 00:02:00 •Boyle's law: Constant temperature: 00:01:00 •Charles' law: Constant pressure: 00:01:00 •Gay-Lussac's law: Constant volume: 00:01:00 •Combined gas law: 00:01:00 •Density of an ideal gas: 00:03:00 •Dalton's law for partial pressures: 00:01:00 •Collecting a gas over a liquid: 00:02:00 •Deviation from ideal beahvior: 00:01:00 •Measurement of gases: Solved problems: 00:13:00 •Avogadro's hypothesis: 00:03:00 •Molar volume: 00:01:00 •Ideal gas law: 00:05:00 •Gas volume relations from equations: 00:04:00 •Gas stoichiometry involving mass: 00:05:00 •The ideal gas law: Solved problems: 00:13:00 •Heat: 00:04:00 •Energy and enthalpy: 00:05:00 •Enthalpy changes for various processes: 00:12:00 •Rules of thermochemistry: 00:09:00 •Thermochemistry - Problems with solutions: 00:21:00 •Characters of light: 00:05:00 •Interaction of light with matter: 00:08:00 •Particles and waves: 00:03:00 •Orbitals: 00:17:00 •The Pauli exclusion principle: 00:01:00 •Aufbau principle: 00:03:00 •Electron configuration: 00:11:00 •Atomic radii: 00:04:00 •Ionization energies: 00:03:00 •Electron affinity and magnetic properties: 00:05:00 •Atomic structure - Problems with solutions: 00:16:00 •Introduction to chemical bonding: 00:02:00 •Octet rule: 00:03:00 •Ionic bonding: 00:09:00 •Electron dot notation: 00:05:00 •Covalent bonding: 00:17:00 •Distinction between ionic and covalent bonding: 00:03:00 •Predicting the nature of bonding in compounds: 00:05:00 •Formal charges: 00:08:00 •Dipole moment and electronegativity: 00:04:00 •Hybrid orbitals: 00:10:00 •Crystals: 00:08:00 •Close packing: 00:04:00 •Crystal forces: 00:06:00 •Liquid forces: 00:03:00 •Solids and liquids: Solved problems: 00:22:00 •Introduction to redox reactions: 00:04:00 •Oxidation number: 00:09:00 •Oxidizing and reducing agents: 00:05:00 •Ionic notation for equations: 00:04:00 •Balancing oxidation-reduction equations: 00:11:00 •Oxidation-reduction: Solved problems: 00:14:00 •Composition of solutions: 00:01:00 •Concentrations: 00:02:00 •Molarity: 00:02:00 •Normality: 00:05:00 •Molality: 00:01:00 •Mole fraction: 00:01:00 •Comparison and summary of the concentration units: 00:04:00 •Dilution problems: 00:01:00 •Concentration of solutions: Solved problems: 00:14:00 •Reactions involving standard solutions: 00:04:00 •Reaction involving standard solutions: Solved problems: 00:13:00 •Introduction to chemical solutions: 00:02:00 •Vapor pressure lowering: 00:04:00 •Freezing point lowering: 00:05:00 •Boiling point lowering: 00:03:00 •Osmotic pressure: 00:03:00 •Solution of gases in liquids: 00:02:00 •Law of distribution: 00:01:00 •Properties of solutions: Solved problems: 00:13:00 •The first law: 00:02:00 •The second law: 00:06:00 •Entropy: 00:04:00 •The third law: 00:01:00 •Standard states: 00:06:00 •Chemical equilibrium: 00:03:00 •The equilibrium constant: 00:10:00 •Le Chatelier's principle: 00:14:00 •Thermodynamics - Problems with solutions: 00:18:00 •Arrhenius concept: 00:03:00 •Brönsted-Lowry concept: 00:08:00 •Lewis concept: 00:02:00 •Ionization of water: 00:07:00 •Hydrolysis: 00:06:00 •Buffer solutions: 00:06:00 •Indicators: 00:03:00 •Polytropic acids: 00:05:00 •Titration: 00:08:00 •Acids and bases - Problems with solutions: 00:21:00 •Coordination complexes: 00:08:00 •Solubility product: 00:02:00 •Precipitation: 00:05:00 •Complex ions and precipitates: Solved problems: 00:06:00 •Electrical units: 00:03:00 •Faraday's laws: 00:04:00 •Voltaic cells: 00:06:00 •Standard half-cell potential: 00:07:00 •Combining couples: 00:04:00 •Free energy and Nernst equation: 00:08:00 •Electrolysis: 00:06:00 •Electrochemistry: Solved problems: 00:16:00 •Introduction to rates of reactions: 00:01:00 •Rate constants and order of reactions: 00:11:00 •First order reactions: 00:02:00 •Other rate laws: 00:01:00 •Energy of activation: 00:01:00 •Mechanism of reaction: Molecularity: 00:05:00 •Mechanism of reaction: Energetics: 00:05:00 •Rates of reactions: Solved problems: 00:13:00 •Assignment -General Inorganic Chemistry: 00:00:00

Outline: This course is intended to provide an introduction to the methods of test (both laboratory-based and on-site) that are used to assess primary performance and installation requirements of different kinds of cladding and glazing system used on modern buildings, and to identify key British, European and CWCT standards and guides relevant to those tests. NOTE: The material for this course is based on previous MTCP and CWDC courses. Target audience: This course is aimed at those who require, specify or witness testing of modern façade systems, as well as those whose products or installations are likely to require testing. Learning objectives: Understand why testing may be carried and what tests are available, Understand how built-up walls and glazed systems are tested for weathertightness in the laboratory, Understand how built-up walls and glazed systems are tested for weathertightness in on site, Appreciate the importance of appropriate test samples, Appreciate the importance of whole building air leakage testing. Assessment: Assessment will be via a series of multiple-choice questions following the course, The assessment is timed and must be passed in order to receive a CPD certificate for the course, If the assessment is failed, one re-take will be permitted. Prerequisites: None, although C201 Introduction to contemporary cladding and façade systems is recommended. Course availability:  23 September - 20 October 2024 Lecture time: 1/2 day Price:  Member price Non-Member price £90 + VAT £180 + VAT