3784 Link courses

Overview This comprehensive course on MS Access Tables and Queries for Beginner will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This MS Access Tables and Queries for Beginner 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 MS Access Tables and Queries for Beginner. It is available to all students, of all academic backgrounds. Requirements Our MS Access Tables and Queries for Beginner 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 Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 2 sections • 20 lectures • 03:32:00 total length •Module 01: Tour of the screen: 00:11:00 •Module 02: Using Design view to create and edit tables: 00:45:00 •Module 03: Using the lookup wizard: 00:09:00 •Module 04: Importing data from Other Data Sources into Access: 00:18:00 •Module 05: Linking Tables from Other Data Sources into Access: 00:10:00 •Module 06: Exporting data from Access to other data types: 00:03:00 •Module 07: Creating and Managing Table Relationships: 00:10:00 •Module 08: Database Tools: 00:05:00 •Module 09: Sort and Filter a Table: 00:06:00 •Module 10: Basic Queries: 00:22:00 •Module 11: Prompting the user for the criteria: 00:05:00 •Module 12: Creating Calculated Fields in a Query: 00:10:00 •Module 13: Creating Totals Queries: 00:08:00 •Module 14: Multiple table Queries: 00:12:00 •Module 15: Viewing the SQL code for an Access Query: 00:06:00 •Module 16: Using the Query Wizards: 00:09:00 •Module 17: Creating Subqueries: 00:03:00 •Module 18: Creating Make Table, Append, Update and Delete Queries: 00:19:00 •Module 19: Displaying a certain number of records: 00:01:00 •Assignment - MS Access Tables and Queries for Beginner: 00:00:00

Overview This comprehensive course on Data Analysis and Forecasting in Excel will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Data Analysis and Forecasting in Excel 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 Data Analysis and Forecasting in Excel. It is available to all students, of all academic backgrounds. Requirements Our Data Analysis and Forecasting in Excel 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 Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 10 sections • 31 lectures • 04:43:00 total length •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 •Sort Data: 00:10:00 •Filter Data: 00:10:00 •Query Data with Database Functions: 00:09:00 •Outline and Subtotal Data: 00:09:00 •Apply Intermediate Conditional Formatting: 00:07:00 •Apply Advanced Conditional Formatting: 00:05:00 •Create Charts: 00:13:00 •Modify and Format Charts: 00:12:00 •Use Advanced Chart Features: 00:12:00 •Create a PivotTable: 00:13:00 •Analyze PivotTable Data: 00:12:00 •Present Data with PivotCharts: 00:07:00 •Filter Data by Using Timelines and Slicers: 00:11:00 •Use Links and External References: 00:12:00 •Use 3-D References: 00:06:00 •Consolidate Data: 00:05:00 •Use Lookup Functions: 00:12:00 •Trace Cells: 00:09:00 •Watch and Evaluate Formulas: 00:08:00 •Apply Data Validation: 00:13:00 •Search for Invalid Data and Formulas with Errors: 00:04:00 •Work with Macros: 00:18:00 •Create Sparklines: 00:07:00 •MapData: 00:07:00 •Determine Potential Outcomes Using Data Tables: 00:08:00 •Determine Potential Outcomes Using Scenarios: 00:09:00 •Use the Goal Seek Feature: 00:04:00 •Forecasting Data Trends: 00:05:00

Overview This comprehensive course on Intermediate Solidworks will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Intermediate Solidworks  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 Intermediate Solidworks. It is available to all students, of all academic backgrounds. Requirements Our Intermediate Solidworks 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 Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 6 sections • 37 lectures • 02:45:00 total length •1.1 Extruded Boss Advanced: 00:03:00 •1.2 Extruded Boss Additional: 00:04:00 •1.3 Extruded Cut Advanced: 00:03:00 •1.4 Swept Boss: 00:02:00 •1.5 Lofted Boss: 00:03:00 •1.6 Draft: 00:03:00 •1.7 Shell: 00:02:00 •1.8 Rib: 00:04:00 •1.9 Example #1: 00:08:00 •1.10 Example #2: 00:07:00 •2.1 Linked dimensions: 00:04:00 •2.2 Equations: 00:05:00 •2.3 Coordinate System: 00:03:00 •2.4 Hole wizard: 00:03:00 •2.5 Feature scope: 00:02:00 •2.6 Mirror: 00:03:00 •2.7 Example #1: 00:09:00 •2.8 Example #2: 00:09:00 •3.1 Creating a Design Table: 00:06:00 •3.2 Configurations: 00:05:00 •3.3 Example #1: 00:07:00 •3.4 Example #2: 00:04:00 •4.1 Distance and Angle: 00:04:00 •4.2 Profile Center: 00:04:00 •4.3 Symmetric and Width: 00:05:00 •4.4 Path Mate: 00:05:00 •4.5 Linear Coupler: 00:06:00 •4.6 Example #1: 00:08:00 •4.7 Example #2: 00:13:00 •5.1 Collision Detection: 00:02:00 •5.2 Interference Detection: 00:03:00 •5.3 Assembly Feature: 00:02:00 •5.4 Replacing Part: 00:01:00 •5.5 Sub-assembly: 00:03:00 •5.6 Example #1: 00:05:00 •5.7 Example #2: 00:05:00 •Assignment - Intermediate Solidworks Course: 00:00:00

The importance of social media marketing for businesses and organizations is no longer questioned. It has become a worldwide trend which helps businesses and organizations connect with their customers online. Now, every company needs a dynamic web presence. The Complete Online Course on Social Media for Business covers the concepts and application of social media marketing and will equip you with the skills to plan and implement a successful social media marketing strategy. You will understand the social media foundations, and how to plan goals and create a vision. You will learn how to meaningfully measure social media engagement using platforms such as Twitter, Facebook, blogs, LinkedIn, YouTube and their useful features. Who is this Course for? Complete Online Course on Social Media for Business is 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. Entry Requirement: This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of the English language, numeracy and ICT are required to attend this course. CPD Certificate from Course Gate  At the successful completion of the course, you can obtain your CPD certificate from us. You can order the PDF certificate for £9 and the hard copy for £15. Also, you can order both PDF and hardcopy certificates for £22. Career path This course opens a new door for you to enter the relevant job market and also gives you the opportunity to acquire extensive knowledge along with required skills to become successful. You will be able to add our qualification to your CV/resume which will help you to stand out in the competitive job industry. Course Curriculum Social Media Marketing Introduction 00:30:00 Understanding the Value of Social Media Buzz and What It Can Do For Your Business 01:00:00 Developing a Winning Social Media Marketing Plan 01:00:00 Setup and Manage a Facebook Page That Works 01:00:00 Tweet Your Way to Online Prominence 01:00:00 Build Your Network with LinkedIn 01:00:00 Captivate Your Audience with YouTube 01:00:00 Conclusion 00:15:00 Social Media Management for Business Module One - Getting Started 00:30:00 Module Two - What is Social Media? 00:30:00 Module Three - Defining Your Social Media Policy (I) 00:15:00 Module Four - Defining Your Social Media Policy (II) 00:30:00 Module Five - Creating a Living Document 00:30:00 Module Six - Keeping an Eye on Security 00:30:00 Module Seven - Rules to Follow When Posting (I) 00:30:00 Module Eight - Rules to Follow When Posting (II) 00:30:00 Module Nine - Benefits of Social Media 00:30:00 Module Ten - The Pitfalls of Social Media 00:30:00 Module Eleven - Listen to Your Customers 00:30:00 Module Twelve - Wrapping Up 00:30:00 Activities 00:00:00 Facebook Marketing Basics Introduction to Facebook 00:15:00 Why You Should Care 00:15:00 Setting up a Facebook Page 00:30:00 How to Get More Likes for Your Facebook Page 00:30:00 Facebook Advertising 00:30:00 How Much Does Facebook Advertising Cost? 00:30:00 Marketing on Facebook 01:00:00 Create a Content Calendar 00:15:00 Understanding Edge Rank & the Art of Engagement 00:15:00 Twitter Marketing TWITTER FOR BUSINESS 00:15:00 TOP TWITTER TIPS 00:15:00 TWITTER IS 00:15:00 BUSINESS TERMS 00:15:00 WHY USE TWITTER FOR MARKETING 00:15:00 TWITTER MARKETING BASICS 01:00:00 TWITTER METRICS 00:30:00 YOUR BIO 00:15:00 WHEN TO TWEET 00:15:00 BUILDING YOUR COMMUNITY 00:15:00 GENERATING LEADS 00:15:00 REAL-TIME TWITTER MARKETING 00:15:00 ENGAGEMENT 00:15:00 TWETIQUETTE (TWEETING ETIQUETTE) 00:15:00 Social Bookmarking Introduction To Social Bookmarking 00:30:00 The Essential Benefits Of Social Bookmarking 00:30:00 Way To Use Social Bookmarking Correctly 00:30:00 Make Money Social Bookmarking 01:00:00 Identify The Social Bookmarking Competitors 00:15:00 Tips To Avoid Wrapping Traps 00:15:00 Recommended Reading Recommended Reading : Complete Online Course on Social Media for Business 00:00:00 Mock Exam Mock Exam- Complete Online Course on Social Media for Business 00:30:00 Final Exam Final Exam- Complete Online Course on Social Media for Business 00:30:00 Certificate and Transcript Order Your Certificates or Transcripts 00:00:00

Overview This comprehensive course on Personal Development Masterclass will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Personal Development Masterclass comes with accredited certification, 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 Personal Development Masterclass. It is available to all students, of all academic backgrounds. Requirements Our Personal Development Masterclass 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 8 sections • 39 lectures • 02:28:00 total length •Introduction: 00:05:00 •What's Your Self Image and How It Affects Your Self Esteem: 00:03:00 •The Meaning of Self-Image: 00:04:00 •Accepting Yourself for Who You Are: 00:04:00 •Ways to Change Your Self Image: 00:06:00 •How Your Self Image Affects You Emotionally: 00:04:00 •How Your Identity and Self Esteem Are Linked: 00:04:00 •What Roadblocks Do You Put in Your Way?: 00:03:00 •Comparing Yourself to Others as a Roadblock: 00:04:00 •Using Self Talk as a Roadblock: 00:04:00 •Using Fear as a Roadblock: 00:03:00 •Using Procrastination as a Roadblock: 00:04:00 •Having Self Limiting Beliefs: 00:04:00 •Causes for Low Self Esteem: 00:03:00 •Sources for low self-esteem: 00:04:00 •How Bullying Can Affect Your Self Esteem: 00:03:00 •How Your Parents Can Affect Your Self Esteem: 00:04:00 •How Trauma Can Affect Your Self Esteem?: 00:05:00 •How Society and the Media Can Affect Your Self Esteem: 00:03:00 •Using Psychology/Self Help to Form Empowering Beliefs: 00:04:00 •Ways to remove negative thoughts from your subconscious mind: 00:03:00 •Transactional Analysis-The Masks we wear: 00:03:00 •Affirmations: 00:03:00 •Steps to Overcome limiting beliefs learn in childhood: 00:05:00 •Learn to understand your potential: 00:04:00 •Changing Your Mindset to Overcome Limiting Beliefs: 00:06:00 •Proven Mindset hacks to overcome limiting beliefs: 00:05:00 •Ways to cultivate a more positive mindset: 00:03:00 •Ways to change your mindset and attitude: 00:04:00 •Ways to change your mindset for success: 00:04:00 •Ways to Change your mindset: 00:04:00 •Believe in yourself: 00:04:00 •Think About Your Past Successes: 00:03:00 •Learn to Trust Yourself: 00:04:00 •Let yourself off the hook: 00:04:00 •Have a Positive Attitude: 00:03:00 •Let a Life Coach Help You: 00:03:00 •Review of Course: 00:05:00 •Assignment - Personal Development Masterclass: 00:00:00

Overview This comprehensive course on Affiliate Marketing will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Affiliate Marketing 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 Affiliate Marketing. It is available to all students, of all academic backgrounds. Requirements Our Affiliate Marketing 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 Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 11 sections • 31 lectures • 01:07:00 total length •Unit 1: Welcome to the Course: 00:03:00 •Unit 1: What is Affiliate Marketing: 00:06:00 •Unit 2: Why Affiliate Marketing is Beneficial to Companies: 00:02:00 •Unit 3: Benefits of Doing Affiliate Marketing: 00:03:00 •Unit 4: Why Affiliate Marketing is Awesome: 00:01:00 •Unit 1: 3 Things to Do Before Starting: 00:02:00 •Unit 2: Understand Different Types of Affiliate Sites: 00:02:00 •Unit 3: Always Provide Affiliate Disclosure: 00:02:00 •Unit 1: Steps to Start Affiliate Marketing: 00:02:00 •Unit 2: Choose a Profitable Niche: 00:03:00 •Unit 3: Setup Your Website: 00:03:00 •Unit 1: Different Types of Compensation Model: 00:03:00 •Unit 2: What Are Void Affiliate Transactions: 00:03:00 •Unit 1: How to Find Affiliate Programs: 00:02:00 •Unit 2: Steps to Choose an Affiliate Program: 00:02:00 •Unit 3: Working with Affiliate Networks: 00:02:00 •Unit 4: Download the List of 50 Affiliate Programs & Networks: 00:01:00 •Unit 1: Types of Articles You Can Write: 00:04:00 •Unit 2: What Are Keywords & How to Find Them: 00:05:00 •Unit 3: How to Write SEO Friendly Articles: 00:02:00 •Unit 4: Including Affiliate Links in Articles: 00:01:00 •Unit 1: Why Promoting Content is Important: 00:01:00 •Unit 2: Promoting with Social Media: 00:02:00 •Unit 3: Promoting through Pinterest: 00:02:00 •Unit 4: Using Q & A Forums: 00:01:00 •Unit 5: Running Paid Ads: 00:02:00 •Unit 6: Influencer Outreach Method: 00:02:00 •Unit 7: Using YouTube for Affiliate Marketing: 00:02:00 •Unit 1: Conclusion: 00:01:00 •Resources - Affiliate Marketing: 00:00:00 •Assignment - Affiliate Marketing: 00:00:00

Overview Apex Learning's Advanced Teaching Assistant Diploma is the key to obtaining the required accreditation for effective work in the teaching profession. Enrol at discounted prices, become certified immediately and advance your career as a teaching assistant. Like all Apex Learning courses, this diploma is professionally designed through thorough study. Each topic is divided into manageable chunks for easier study. Our experienced instructors are always accessible to answer your queries and boost your learning experience. Completing the Advanced Teaching Assistant Diploma results in an instant e-certificate, which increases your CV and improves your career prospects in the relevant field. Consider Apex Learning's Advanced Teaching Assistant Diploma if you want to be certified in this field. Learning Outcomes Upon completing the course, learners will: Identify the key characteristics and Skills of an Advanced Teaching Assistant Support Classroom Learning and Teaching Comprehend School Organization and the UK School System Demonstrate National Curriculum and Teaching Policy Knowledge Apply Assessment and Planning Strategies Manage First Aid and Child Safeguarding Plan Activities for Literacy, Numeracy, and ICT Development Provide SEN Support for Children with Autism Cultivate Positive Relationships with Pupils and Families Description Every course at Apex Learning, including the Advanced Teaching Assistant Diploma, is created with passion and competence. We prioritize student value by ensuring that each course provides extensive information and skills. After finishing this program, you will earn a certification that will boost your CV and set you apart in the job market. Our training will help you achieve your employment objectives and professional development. Apex Learning provides high-quality learning opportunities. Enrol now! Why People Love This Diploma from Apex Learning Instantly accessible CPD-accredited certificate upon successful completion. 24/7 course access for 12 months, allowing for self-paced study. No hidden fees or exam charges, with full tutor support and efficient assessment. Achieve instant results and gain a competitive edge in your career. Method of Assessment Assessment in the Advanced Teaching Assistant Diploma involves an automated multiple-choice exam. A minimum score of 60% is required to pass and qualify for CPD Accredited certificates. Successful completion leads to certification eligibility. 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? This Advanced Teaching Assistant Diploma is appropriate for: People who want to advance their skills and knowledge as a teaching assistant People looking for a job or a promotion in the teaching field Anyone interested in learning a new skill or expanding their knowledge. Requirements There are no specific requirements for taking or enrolling in this Advanced Teaching Assistant Diploma. This is an open course that anybody can take. Any smart device with an internet connection can access the Advanced Teaching Assistant Diploma in all its sections. So, you can learn while lying at your house! All you need is a passion for learning and reading and to be at least 16 years old. Career Path This Advanced Teaching Assistant Diploma allows you to grow your career and find employment in suitable sectors. After finishing this course, you will have plenty of work choices linked to teaching to consider. Additionally, this training improves your proficiency and makes you eligible for job promotions. Course Curriculum 1 sections • 9 lectures • 02:47:00 total length •Module 01: Teaching Assistant Overview: 00:20:00 •Module 02: Professional Developments for a TA: 00:26:00 •Module 03: Working with the School and Its Policies: 00:23:00 •Module 04: Discussion on Curriculum, Assessment and Monitoring: 00:21:00 •Module 05: Providing the Best Learning Environment: 00:17:00 •Module 06: Learn to Implement ICT, Literacy and Numeracy Development Processes as a TA: 00:14:00 •Module 07: Child Development and the SEN Support: 00:15:00 •Module 08: Understanding Behaviour & Relationships as a TA: 00:18:00 •Module 09: Experienced TAs Maintain Strong Communications with the Students: 00:13:00

Overview This comprehensive course on Mandatory Training For Domiciliary Workers will deepen your understanding on this topic. After successful completion of this course, you can acquire the required skills in this sector. This Mandatory Training For Domiciliary Workers 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 Mandatory Training For Domiciliary Workers. It is available to all students, of all academic backgrounds. Requirements Our Mandatory Training For Domiciliary Workers 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 Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 9 sections • 44 lectures • 20:12:00 total length •Understanding Fire: 00:23:00 •Fire Risk Assessment: 00:28:00 •Fire Safety Arrangements: 00:28:00 •Evacuation & Safety: 00:16:00 •Fire Extinguishers: 00:15:00 •Introduction, Legislation and Guidance: 00:34:00 •Manual Handling Hazards and Injuries: 00:33:00 •Risk Assessment: 00:24:00 •Controlling and Reducing the Risks: 00:34:00 •Safe Lifting Techniques: 00:20:00 •Food Safety - An Introduction: 00:26:00 •Food Safety Management System: 00:41:00 •Contamination Hazards: 00:26:00 •Controlling Contamination: 00:36:00 •Food Poisoning (Bacterial) and Food-Borne Illness: 00:29:00 •Personal Hygiene: 00:27:00 •Introduction to Safeguarding: 00:21:00 •Child Abuse: 00:46:00 •Sexual Abuse: 00:34:00 •Risks and Risk Assessment: 00:14:00 •Laws and Guidance: 00:41:00 •An Introduction to Safeguarding of Vulnerable Adults: 00:17:00 •Understanding Abuse and Neglect: 00:31:00 •Understanding the Importance of Communication in Care: 00:23:00 •Sharing Information and Responding To a Disclosure: 00:30:00 •Safeguarding Legislations: 00:25:00 •Introduction to Infection: 00:33:00 •Microorganisms and Microbiology: 00:15:00 •Bloodborne Pathogens: 00:19:00 •Controlling Infection: 00:29:00 •Decontamination and Disinfection: 00:25:00 •Hygiene to Prevent Infection: 00:25:00 •Integrating Equality and Diversity into Policy: 00:39:00 •Human Rights: 00:39:00 •Promoting Diversity and Social Inclusion: 00:34:00 •Links between Values, Attitudes and Beliefs: 00:38:00 •Stereotypes, Prejudice, Discrimination and Bias: 00:33:00 •Monitoring Equality and Diversity: 00:33:00 •Introduction to Health and Social Care: 00:16:00 •Important Principles and Policies in Health and Social Care Work: 00:20:00 •Risk Management in Health and Social Care: 00:30:00 •Managing for Health and Safety: 00:29:00 •Electrical, Fire and Gas Safety: 00:22:00 •Overview of Mental Health First Aid: 00:11:00

Overview We live in an era where data, data and data surround us. You need to share something one way or another to use most of the services around you; just name it. Whether it is about reading a blog post, visiting a website, surveying for a service, seeing any social media post, or looking for offers, you must share some data, if not anything, and your email, at least.But do you ever realise why, in all these situations, you need to share your data? Because your data is oxygen in this world. Companies want to know what you are thinking or what you are about to do before you even think or are about to do it. Sounds crazy, right? Don't be.It is a new branch of knowledge and profession. A data analyst gathers, cleans, and evaluates data sets to find an explanation or resolve an issue. The most common tool for doing these is Microsoft Excel. Our Data Analysis in Microsoft Excel Complete Training course will prepare you to use Microsft Excel in data analysis. What Can You Expect To Achieve By Completing This Course? Proficiency in modifying and organising data within Excel worksheets. Skills in working with lists and effectively analysing data. Ability to create visual representations of data using charts and graphs. Competence in using PivotTables and PivotCharts for data summarisation and analysis. Command in managing multiple worksheets, workbooks, and advanced Excel functions for data manipulation and forecasting. 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 Data Analysis in Microsoft Excel Complete Training. It is available to all students, of all academic backgrounds. Requirements Our Data Analysis in Microsoft Excel Complete Training is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible on tablets and smartphones so you can access your course on wifi, 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 11 sections • 31 lectures • 04:46:00 total length •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 •Sort Data: 00:10:00 •Filter Data: 00:10:00 •Query Data with Database Functions: 00:09:00 •Outline and Subtotal Data: 00:09:00 •Apply Intermediate Conditional Formatting: 00:07:00 •Apply Advanced Conditional Formatting: 00:05:00 •Create Charts: 00:13:00 •Modify and Format Charts: 00:12:00 •Use Advanced Chart Features: 00:12:00 •Create a PivotTable: 00:13:00 •Analyze PivotTable Data: 00:12:00 •Present Data with PivotCharts: 00:07:00 •Filter Data by Using Timelines and Slicers: 00:11:00 •Use Links and External References: 00:12:00 •Use 3-D References: 00:06:00 •Consolidate Data: 00:10:00 •Use Lookup Functions: 00:12:00 •Trace Cells: 00:05:00 •Watch and Evaluate Formulas: 00:10:00 •Apply Data Validation: 00:13:00 •Search for Invalid Data and Formulas with Errors: 00:04:00 •Work with Macros: 00:18:00 •Create Sparklines: 00:07:00 •MapData: 00:07:00 •Determine Potential Outcomes Using Data Tables: 00:08:00 •Determine Potential Outcomes Using Scenarios: 00:09:00 •Use the Goal Seek Feature: 00:04:00 •Forecasting Data Trends: 00:05:00

The Professional Presenter Training provides you with the knowledge and skill building in the planning, preparation and delivery of truly engaging presentations. Exploring all aspects of concept, design and delivery, you will gain a range of tools and techniques to help you plan and deliver engaging and effective presentations to a range of audiences. You'll learn how to use specific tools and techniques for presentation creation and delivery which will enable you to conduct powerful presentations that engage your audience every time. This course will give you the framework needed to develop and deliver an effective, memorable presentation. You will learn proven tips and examples that will guide you through the presentation process no matter how large the audience. Who is this course for? Excel 2019 Intermediate is suitable for anyone who wants to gain extensive knowledge, potential experience and professional skills in the related field. This course is CPD accredited so you don't have to worry about the quality. Requirements Our Excel 2019 Intermediate is open to all from all academic backgrounds and there are no specific requirements to attend this course. It is compatible and accessible from any device including Windows, Mac, Android, iOS, Tablets etc. CPD Certificate from Course Gate At the successful completion of the course, you can obtain your CPD certificate from us. You can order the PDF certificate for £9 and the hard copy for £15. Also, you can order both PDF and hardcopy certificates for £22. Career path This course opens a new door for you to enter the relevant job market and also gives you the opportunity to acquire extensive knowledge along with required skills to become successful. You will be able to add our qualification to your CV/resume which will help you to stand out in the competitive job industry. Course Curriculum Intro Introduction 00:01:00 Section 01 Linking Worksheets and Workbooks 00:07:00 Linking Worksheets with 3D References 00:05:00 Understanding the Consolidate Feature 00:06:00 Section 02 What are Range Names 00:06:00 Creating Range Names Using the Name Box and Define Name 00:06:00 Creating Range Names Using Create from Selection 00:03:00 Section 03 Understanding the Differences Between Sorting and Filtering 00:03:00 Sorting Lists 00:07:00 Filtering Lists 00:06:00 Creating Subtotals 00:05:00 Section 04 Creating Tables and Understanding the Benefits 00:06:00 Understanding the Elements of a Table 00:05:00 Formatting a Table 00:05:00 Sorting and Filtering Tables 00:04:00 Filtering with Slicers 00:07:00 Calculating with Tables 00:06:00 Removing Erroneous Table Data 00:05:00 Exporting, Refreshing, and Converting Tables 00:05:00 Section 05 What is Conditional Formatting 00:03:00 Conditional Formatting-HIghlight Cells and Top Bottom Rules 00:06:00 Conditional Formatting-Data Bars, Icon Sets, and Color Scales 00:06:00 Using Custom Fonts and Colors 00:03:00 Using Custom Conditional Formatting 00:05:00 Modyfing or Removing Conditional Formatting 00:04:00 Section 06 What are Charts 00:06:00 Forecasting with Trendlines 00:05:00 Creating a Chart Template 00:04:00 Displaying Trends with Sparklines 00:08:00 Creating Charts 00:05:00 Understanding Chart Elements 00:05:00 Modifying Chart Elements 00:05:00 Changing and Moving Charts 00:03:00 Filtering a Chart 00:04:00 Formatting Charts 00:13:00 Adjusting Numbering 00:06:00 Creating Dual Axis Charts 00:05:00 Section 07 What is a PivotTable 00:05:00 Creating a PivotTable 00:07:00 Working with the PivotTable Fields Pane 00:10:00 Basic Data Organization and Analysis with PivotTables 00:08:00 Formatting PivotTables 00:05:00 Creating a PivotChart 00:04:00 Modifying and Formatting a PivotChart 00:04:00 Using Slicers and Timeline Slicers 00:08:00 Section 08 Using the PivotTable and PivotChart Wizard 00:03:00 Adding a Calculated Field 00:04:00 Adding a Calculated Item 00:04:00 Applying Conditional Formatting to a PivotTable 00:06:00 Creating Filter Pages for a PivotTable 00:04:00 Enabling the PowerPivot Add-in 00:11:00 Recap Recap 00:02:00 Certificate and Transcript Order Your Certificates or Transcripts 00:00:00