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

928 Data Analysis courses in Coventry delivered On Demand

CRM: Customer Relationship Management - CPD Certified

By Wise Campus

CRM: Customer Relationship Management Would you want to learn about various methods for choosing tools and the best ways to keep customers? Our in-depth CRM (Customer Relationship Management) will assist you in expanding your knowledge about the CRM sector. Our CRM (Customer Relationship Management) provides an introduction to Customer Relationship Management (CRM) along with its all functions. Also, the CRM (Customer Relationship Management) explains CRM strategies, and data analysis in CRM and CRM Databases. Moreover, this CRM (Customer Relationship Management) includes difficulties handling processes. Additionally, the CRM (Customer Relationship Management) explain how to deepen the customer relationship and the future of CRM. Enhance your organisational efficiency and maximise business growth through our effective CRM (Customer Relationship Management) practices! Learning Outcome of CRM (Customer Relationship Management) This CRM (Customer Relationship Management) will teach you about: Introduction to CRM (Customer Relationship Management). The CRM (Customer Relationship Management) explains CRM fundamentals. CRM (Customer Relationship Management) also includes CRM strategies. Data analysis in CRM and collecting CRM databases are parts of this CRM (Customer Relationship Management). Through the CRM (Customer Relationship Management), you will learn about deepening customer relationships. Handling customer complaints and the future of CRM is elaborately explained in this CRM (Customer Relationship Management). Special Offers of this CRM: Customer Relationship Management Course This CRM: Customer Relationship Management Course includes a FREE PDF Certificate. Lifetime access to this CRM: Customer Relationship Management Course Instant access to this CRM: Customer Relationship Management Course Get FREE Tutor Support to this CRM: Customer Relationship Management Course CRM: Customer Relationship Management Unlock the full potential of your customer interactions with our CRM: Customer Relationship Management course, offering a comprehensive introduction to CRM strategies and functionalities. This CRM: Customer Relationship Management course guides you through the essentials of CRM, from data analysis to managing CRM databases. Learn how to navigate challenges and streamline processes through the CRM: Customer Relationship Management framework. Moreover, the CRM: Customer Relationship Management course teaches you to deepen customer relationships and explore the future of CRM. Elevate your business and master the art of customer loyalty with our expert-led CRM: Customer Relationship Management program. Who is this course for? CRM: Customer Relationship Management This CRM (Customer Relationship Management) is intended for individuals who wish to enhance their company chances and cultivate solid client connections. Requirements CRM: Customer Relationship Management To enrol in this CRM: Customer Relationship Management Course, students must fulfil the following requirements: Good Command over English language is mandatory to enrol in our CRM: Customer Relationship Management Course. Be energetic and self-motivated to complete our CRM: Customer Relationship Management Course. Basic computer Skill is required to complete our CRM: Customer Relationship Management Course. If you want to enrol in our CRM: Customer Relationship Management Course, you must be at least 15 years old. Career path CRM: Customer Relationship Management You may work as a manager, customer service manager, CRM analyst, and many other roles after finishing this CRM (Customer Relationship Management)!

CRM: Customer Relationship Management - CPD Certified
Delivered Online On Demand1 hour 24 minutes
£12

CRM: Customer Relationship Management - CPD Accredited

By Wise Campus

CRM: Customer Relationship Management Would you want to learn about various methods for choosing tools and the best ways to keep customers? Our in-depth CRM Course (Customer Relationship Management) will assist you in expanding your knowledge about the CRM sector. Our CRM Course (Customer Relationship Management) provides an introduction to Customer Relationship Management (CRM) along with its all functions. Also, the CRM Course (Customer Relationship Management) explains CRM strategies, and data analysis in CRM and CRM Databases. Moreover, this CRM Course (Customer Relationship Management) includes difficulties handling processes. Additionally, the CRM Course (Customer Relationship Management) explain how to deepen the customer relationship and the future of CRM. Enhance your organisational efficiency and maximise business growth through our effective CRM Course (Customer Relationship Management) practices! Learning Outcome of CRM Course (Customer Relationship Management) This CRM Course (Customer Relationship Management) will teach you about: Introduction to CRM Course (Customer Relationship Management). The CRM Course (Customer Relationship Management) explains CRM fundamentals. CRM Course (Customer Relationship Management) also includes CRM strategies. Data analysis in CRM and collecting CRM databases are parts of this CRM Course (Customer Relationship Management). Through the CRM Course (Customer Relationship Management), you will learn about deepening customer relationships. Handling customer complaints and the future of CRM is elaborately explained in this CRM Course (Customer Relationship Management). Special Offers of this CRM: Customer Relationship Management Course This CRM: Customer Relationship Management Course includes a FREE PDF Certificate. Lifetime access to this CRM: Customer Relationship Management Course Instant access to this CRM: Customer Relationship Management Course Get FREE Tutor Support to this CRM: Customer Relationship Management Course CRM: Customer Relationship Management Unlock the potential of your business with our CRM: Customer Relationship Management course. This CRM: Customer Relationship Management course provides a comprehensive introduction to all CRM functions, ensuring you grasp the fundamentals of managing customer relationships. You’ll explore effective CRM: Customer Relationship Management strategies, master data analysis in CRM, and gain expertise in navigating CRM databases. Additionally, our CRM: Customer Relationship Management course covers the intricacies of handling process challenges, helping you deepen customer relationships. Plus, you'll get insights into the future of CRM: Customer Relationship Management, making this course your gateway to mastering customer engagement. Who is this course for? CRM: Customer Relationship Management This CRM: Customer Relationship Management is intended for individuals who wish to enhance their company chances and cultivate solid client connections. Requirements CRM: Customer Relationship Management To enrol in this CRM: Customer Relationship Management Course, students must fulfil the following requirements. To join in our CRM: Customer Relationship ManagementCourse, you must have a strong command of the English language. To successfully complete our CRM: Customer Relationship Management Course, you must be vivacious and self driven. To complete our CRM: Customer Relationship Management Course, you must have a basic understanding of computers. A minimum age limit of 15 is required to enrol in this CRM: Customer Relationship Management Course. Career path CRM: Customer Relationship Management You may work as a manager, customer service manager, CRM analyst, and many other roles after finishing this CRM: Customer Relationship Management!

CRM: Customer Relationship Management - CPD Accredited
Delivered Online On Demand1 hour 18 minutes
£12

Python Bootcamp in a Day - Python Programming for Beginners.

By Packt

This course offers you the exact skills and principles you need to deliver a project using Python along with the tools you can use to create solid Python code. Master the language constructs, tools, and terminology with this carefully designed course for beginners.

Python Bootcamp in a Day - Python Programming for Beginners.
Delivered Online On Demand3 hours 40 minutes
£82.99

Accounting : Accountancy Training for Accountant

4.7(47)

By Academy for Health and Fitness

Buy Big. Save Big! Save: £403! Offer Ends Soon; Hurry Up!! Want to learn Accountancy? This course will guide you in the right direction in the field of Accounting. Enrol in this comprehensive course and make yourself one step closer to achieving your career goal. This course includes: Introduction to Accounting The Role of an Accountant Accounting Concepts and Standards Double-Entry Bookkeeping Balance Sheet Expand your expertise with high-quality training - study the and get an expertly designed, great value training experience. Learn from industry professionals and quickly equip yourself with the specific knowledge and skills you need to excel in your chosen career through this online training course. This course is endorsed by The Quality Licence Scheme and accredited by CPD (with 150 CPD points) to make your skill development and career progression related to Accountancy substantial and easier than ever! This course is broken down into several in-depth modules to provide you with the most convenient and rich learning experience possible. Upon successful completion of this course, you will receive an instant e-certificate as proof of the comprehensive skill development and competency. Add these amazing new skills to your resume and boost your employability by simply enrolling on this course. You will fulfil your dreams and prepare for your ideal career by taking this intensive this course. This course offers students an in-depth learning experience that they can work through at their own pace to advance their careers. This same course will teach you everything you need to know to advance in your chosen field. You'll get a free Student ID card by enrolling in this course. This ID card entitles you to discounts on bus tickets, movie tickets, and library cards. Enrolling in this course will help you find your dream career sooner than you ever imagined. With this program, you will stand out from the crowd and prepare for the career you want. Experts created this course to provide a rich and in-depth training experience for all students who enrol in it. Enrol in this course right now, and you'll have immediate access to all of the course materials. Then, from any internet-enabled device, access this course materials and learn when it's convenient for you. Start your learning journey straight away with this course and take a step toward a brighter future! Why Prefer this Course? Opportunity to earn a certificate endorsed by the Quality Licence Scheme and another certificate accredited by CPD after completing this course. Student ID card with amazing discounts - completely for FREE! (£10 postal charges will be applicable for international delivery) Standard-aligned lesson planning Innovative and engaging content and activities Assessments that measure higher-level thinking and skills Complete the program in your own time, at your own pace Each of our students gets full tutor support on weekdays (Monday to Friday) Diploma in Accountancy at QLS Level 5 Module 01: Introduction to Accounting What Is Accounting? Accounting and Bookkeeping Who Uses Accounting Information? Accountability in Accounting Financial Statements How Different Business Entities Present Accounting Information Module 02: The Role of an Accountant What Is an Accountant? Roles and Responsibilities Important Skills Accounting Automation Transparency and Security Data Analysis Module 03: Accounting Concepts and Standards Introduction to Accounting Concepts Introduction to Accounting Standards Accounting Standards in the UK International Standards International Financial Reporting Standards Module 04: Double-Entry Bookkeeping Introduction of Double-Entry Bookkeeping What Does the Account Show? Account NameDebits and CreditsAccount Details Rules for Double-Entry Transactions Inventory Double-Entry Transactions for Inventory Returns of Inventory Drawings Income and Expenses How Many Different Expense Accounts Should Be Opened? Balancing Accounts General Rules for Balancing Accounts Module 05: Balance Sheet Introduction of Balance Sheet The Components of a Balance Sheet AssetsLiabilitiesNet Worth or Equity The Equation Understanding the Balance Sheet What Does the Date on the Balance Sheet Mean? Module 06: Income statement Understanding the Income Statement The Accrual Concept Revenue Expenses Net Income Interest and Income Taxes Bad Debt Expense Module 07: Financial Statements Introduction of Financial Statements Trial Balance Statement of Comprehensive Income Calculation of Profit Difference between Gross and Net Profits Trading Account Profit and Loss Account Statement of Financial Position Non-Current AssetsCurrent AssetsCurrent LiabilitiesNon-Current LiabilitiesCapital Module 08: Cash Flow Statements What Is a Statement of Cash Flows? What Is the Purpose of the Cash Flow Statement? Cash and Cash Equivalents Operating Activities Investing Activities Financing Activities Module 09: Understanding Profit and Loss Statement Introduction of Profit and Loss Account Measurement of Income Relation Between Profit and Loss Account and Balance Sheet Preparation of Profit and Loss Account Module 10: Financial Budgeting and Planning What Is a Budget? Planning and Control Advantages of Budgeting Developing the Profit Strategy and Budgeted Profit and Loss Statement Budgeting Cash Flow from Profit for the Coming Year Capital Budgeting Module 11: Auditing What Is an Audit? Types of Audits External AuditsInternal AuditsInternal Revenue Service (IRS) Audits Why Audits? Who's Who in the World of Audits What's in an Auditor's Report Assessment Process We offer an integrated assessment framework to make the process of evaluation and accreditation for learners easier. You have to complete the assignment questions given at the end of the course and score a minimum of 60% to pass each exam. Our expert trainers will assess your assignment and give you feedback after you submit the assignment. You will be entitled to claim a certificate endorsed by the Quality Licence Scheme after you have completed all of the exams. CPD 150 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Is This Course Right for You? Anyone interested in learning more about this subject should take this course. This course will help you grasp the basic concepts as well as develop a thorough understanding of the subject. All are welcome to take this course. There are no prerequisites for enrollment, and you can access the course materials from any location in the world. This course is preferable for people who want to pursue a career in Aspiring Accountant Recent Graduates Individuals interested in building a career in this sector Individuals working in the relevant field Professionals who have rooms to improve skills and knowledge Requirements This course does not require any prior knowledge; everyone may participate! This course is open to anyone who is interested in learning from anywhere in the world. Every student must be over the age of 16 and have a passion for learning and literacy. This 100% online course can be accessed from any internet-connected device, such as a computer, tablet, or smartphone. This course allows you to study at your own speed while earning an industry-recognized certification. Career path This course will allow you to kickstart or take your career in the related sector to the next stage. Our whole course will assist you in achieving a position of respect and dignity, as well as allowing you to gain an advantage over your competitors. The certificate will strengthen your CV and assist you in finding work in the related industry. Certificates CPD Accredited Certificate Digital certificate - £10 Diploma in Accountancy at QLS Level 5 Hard copy certificate - £119 After successfully completing the Diploma in Accountancy at QLS Level 5 course, you can order an original hardcopy certificate of achievement endorsed by the Quality Licence Scheme. The certificate will be home-delivered, with a pricing scheme of - 119 GBP inside the UK 129 GBP (including postal fees) for international delivery CPD Accredited Certificate 29 GBP for Printed Hardcopy Certificate inside the UK 39 GBP for Printed Hardcopy Certificate outside the UK (international delivery)

Accounting : Accountancy Training for Accountant
Delivered Online On Demand3 weeks
£12

Anti Money Laundering

4.7(47)

By Academy for Health and Fitness

Deal Price is Active Now; Save £401! Offer Ends Soon, Hurry Up!! Have you ever wondered how illegally embezzled money finances significant projects? Did you ever think about how luxury properties are purchased by using illegal money? And how organisations can prevent money laundering systematically? Then, this course is your ultimate guide to Anti Money Laundering (AML). So enrol today, accomplish the knowledge that will drive your career forward and get ahead of the curve! This Anti-Money Laundering course encompasses discrete topics from terrorist financing framework to customer due diligence checks and processes, demonstrating your understanding of the characteristics of a money laundering reporting officer. Through this course, you will explore how illegal activities affect the economic and social aspects and the different methods of money laundering. In addition, after completing this course, you will be able to plan and execute a risk-based approach to minimise financial crimes in organisations. Again, this course prepares you to apply the policy and procedures for reporting suspicious activity. Furthermore, the course will equip you with the ability to inspect the structures of a non-bank financial institution, insurance companies, financial statements, record keeping, and many more. That's not all though, after completing this course, you will illustrate perception on problem-solving, data analysis, and decision making, which will help you to master the related job responsibilities. With 24/7 student support offered to you on the course , you can be sure of quick and comprehensive assistance whenever you need it. You'll get a Free Student ID card by enrolling in thiscourse. This ID card entitles you to discounts on bus tickets, movie tickets, and library cards. What will I learn from this Anti Money Laundering course? An overview of the money laundering framework Acknowledge the proceeds of crime act 2002 Understand the principles of anti-money laundering regulations Demonstrate knowledge on the role of a money-laundering report officer How to assess and conduct an assessment of client's financial information The elements of customer due to diligence programme AML record-keeping standards in the UK Techniques to identify the risk associated with the financial transaction On top of everything, you will get a certificate which will help make a mark for yourself in the competitive job market. This certificate will also help you create an impression of self-reliance and dedication that will surely attract prospective employers to prioritise your job application. Enrol in this course today and open doors to enchanting career opportunities ahead. Why should you choose Anti-Money Laundering Course with Academy for Health & Fitness? Opportunity to earn a certificate accredited by CPD after completing this course Student ID card with amazing discounts - completely for FREE! (£10 postal charges will be applicable for international delivery) Globally accepted standard structured lesson planning Innovative and engaging content and activities Assessments that measure higher-level thinking and skills Complete the program in your own time, at your own pace Each of our students gets full 24/7 tutor support Experts created the Anti-Money Laundering? course to provide a rich and in-depth training experience for all students who enrol in it. Enrol in the course right now and you'll have immediate access to all of the Anti-Money Laundering? course materials. Then, from any internet-enabled device, access the Anti-Money Laundering? course materials and learn when it's convenient for you. Start your learning journey straight away with this Anti-Money Laundering? course and take a step toward a brighter future! *** Course Curriculum *** Here are the topics you will cover on the Course: >> Anti Money Laundering (AML) Course << Module 01: Introduction to Money Laundering Module 02: Proceeds of Crime Act 2002 Module 03: Development of Anti-Money Laundering Regulation Module 04: Responsibility of the Money Laundering Reporting Officer Module 05: Risk-based Approach Module 06: Customer Due Diligence Module 07: Record Keeping Module 08: Suspicious Conduct and Transactions Module 09: Awareness and Training Here is the module breakdown of Anti Money Laundering (AML) Course ----------- Module 01: Introduction to Money Laundering What Is Money Laundering? Turning 'Bad' Money into 'Legitimate' Money How Is Money Laundered? Why Are AML Efforts Important? The Three Stages of Money Laundering Module 02: Proceeds of Crime Act 2002 Introduction The Principal Offences Contained in Part 7 of POCA 2002 The Notion of Criminal Property Elements of Criminal Property The Concept of Knowledge The Notion of Suspicion Module 03: Development of Anti-Money Laundering Regulation Introduction The First Money Laundering Directive Terrorism legislation The Proceeds of Crime Act 2002 and Serious Organised Crime and money laundering offences under the Police Act 2005 The Second Money Laundering Directive The Third Money Laundering Directive The Fourth Money Laundering Directive The Fifth Money Laundering Directive Module 04: Responsibility of the Money Laundering Reporting Officer What Is a Money Laundering Reporting Officer? Who Can be Appointed as an MLRO? The Role of The Money Laundering Reporting Officer Module 05: Risk-based Approach Introduction What Is a Risk-Based Approach (RBA)? A Risk-Based Approach to Customer Due Diligence (CDD) How to Assess the Risk Profile of The Entity How to Assess Client Risk Conducting the Client Risk Assessment Module 06: Customer Due Diligence What is Customer Due Diligence? Main Elements of a Customer Due Diligence Program Enhanced Due Diligence Enhanced Due Diligence for Higher-Risk Customers Account Opening, Customer Identification and Verification Consolidated Customer Due Diligence Module 07: Record Keeping The Purpose of Record-Keeping What Records Have to be Kept? Customer Identification In What Form Should Records be Kept? Failure to Keep Records Module 08: Suspicious Conduct and Transactions What Is Suspicious Activity? What Is a Suspicious Transaction? Avoiding a National Reporting or Record-Keeping Requirement Wire or Fund Transfers Insufficient or Suspicious Information by a Customer Other Suspicious Customer Activity The Identification of Unusual Transactions The Types of Events That Might Cause Suspicion Module 09: Awareness and Training The Importance of Staff Awareness and Training The Core Obligations of Training Legal and Regulatory Obligations Staff Responsibilities Internal Training Procedures Assessment Process Once you have completed all the modules in the Anti Money Laundering course, you can assess your skills and knowledge with an optional assignment. Our expert trainers will assess your assignment and give you feedback afterwards. Showcase Your Accomplishment of New Skills: Get a Certification of Completion The learners have to successfully complete the assessment of this Anti Money Laundering course to achieve the CPD accredited certificate. Digital certificates can be ordered for only £10. The learner can purchase printed hard copies inside the UK for £29, and international students can purchase printed hard copies for £39. CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Is This Anti Money Laundering (AML) Course Right for You? This Anti Money Laundering course has a practical focus and is open to anyone interested in the subject. However, the course is preferable by: Individuals with specific anti-money laundering duties Individuals working in financial services who want a thorough understanding of anti-money laundering Anyone who aspires to a career in anti-money laundering or fraud prevention Requirements Enrol on the Anti Money Laundering with no formal entry requirements! If you have a passion for knowledge and want to learn something new, register on the Anti Money Laundering without any delay. We only ask that all students have a passion for learning and literacy, and be over the age of 16. Complete the Anti Money Laundering online from your computer, tablet, or smartphone, and learn in a way that suits you. Career path Enrolling on this Anti Money Laundering Course can lead you to the following career paths: Ethics & Compliance Officer Lawyer Entrepreneur AML Analyst Accountant Bookkeeper Chartered Accountant Money Laundering Reporting Officer AML Officer Business Analyst Compliance Manager And many more!

Anti Money Laundering
Delivered Online On Demand3 hours
£12

Psychology - Advance Training Course Online

By Study Plex

Highlights of the Course Course Type: Online Learning Duration: 8 Hours 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 psychology Understand the core competencies and principles of psychology Explore the various areas of psychology Know how to apply the skills you acquired from this course in a real-life context Become a confident and expert psychologist Psychology - Advance Training Course Online Course Master the skills you need to propel your career forward in child psychology. This course will equip you with the essential knowledge and skillset that will make you a confident psychologist and take your career to the next level. This comprehensive psychology course is designed to help you surpass your professional goals. The skills and knowledge that you will gain through studying this psychology 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 child psychology practice and equip you with the essential skills, confidence and competence to assist you in the child psychology industry. You'll gain a solid understanding of the core competencies required to drive a successful career in child psychology. 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 psychologist or for people who are aspiring to specialise in child psychology. Enrol in this psychology 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 psychology 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 child psychology 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 psychology 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 psychology 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 psychology 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. Course Curriculum Perspectives in Psychology What Is Psychology 00:07:00 The Biological Approach 00:10:00 Behaviourist And Cognitive Approaches 00:09:00 Person-Centred Approaches 00:08:00 Debates In Psychology 00:12:00 Social Psychology Social Influence: Compliance, Obedience and Conformity 00:10:00 Social Cognition 00:08:00 Applied Social Psychology 00:09:00 Cognitive Psychology and Its Applications Perception 00:09:00 Attention 00:07:00 Remembering (Memory) 00:09:00 Research Methods In Psychology 00:12:00 Forgetting (Memory) 00:07:00 Language 00:10:00 Thinking (Cognition) 00:07:00 Attitudes 00:09:00 Problem-Solving And Artificial Intelligence 00:09:00 Child Development Issues In Child Development 00:05:00 Cognitive Development 00:06:00 The Development Of Language And Communication 00:06:00 Social Perception (Interpersonal Perception) 00:05:00 Moral Development 00:09:00 The Psychology of Atypical (Abnormal) Behaviour The Definition And Diagnosis Of Atypical (Abnormal) Behaviour 00:06:00 Treatments Of Atypical (Abnormal) Behaviour 00:07:00 Emotional Disorders 00:05:00 Research Methods Research Methods 00:06:00 Research Issues 00:06:00 Data Analysis 00:06:00 Thank You and Good Bye! 00:02:00 Child Psychology Introduction About your tutor 00:01:00 About the course 00:02:00 Child Psychology - Applied What is 'Child Psychology'? 00:08:00 The Role of Child Psychologist 00:06:00 Where do Child Psychologists Work 00:06:00 Child Psychology - Theoretical Approach Why do we need to learn theories? 00:08:00 Developmental Theories: What we are born with 00:09:00 Developmental Theories: How environment impacts us 00:09:00 Environmental & Socio-Cultural Factors in Development 'Attachment' factor in newborns 00:08:00 Socio-Cultural Factors in Child's Development 00:07:00 Family & Schooling Factors in Development The Role of Parenting in Child's Development 00:10:00 Relationship Breakdown in the Family 00:07:00 Schooling Environment 00:08:00 Counselling Young Children 00:08:00 Cognitive and Emotional Development Language & Cognitive Development 00:07:00 Emotions & Feelings 00:06:00 Socialising with others 00:04:00 Thank You and Good Bye!44 00:01:00 Addiction Psychology Introduction: About instructor & the course 00:02:00 Theories of Addiction The Moral Model 00:05:00 The Psychological Model 00:06:00 The Medical / Disease Model 00:09:00 The Socio-Cultural Model 00:05:00 Addiction Treatments Pharmacotherapy 00:03:00 The Minnesota Model 00:04:00 Counselling and Therapy 00:07:00 Harm Reduction Model 00:04:00 Treatments in Practice 00:05:00 Addiction in Society Drug policies, Legislation and Decriminalisation 00:08:00 Community change, Outreach, Harm Reduction or Abstinence 00:06:00 Alcohol and Drug education 00:05:00 Alcohol- and drug related issues in the workplace 00:06:00 Addiction in Families Codependency, Children of alcoholic families, parenting styles, family factors 00:08:00 Relapse for families, 'letting go', dependent attitudes and dependent behaviours 00:04:00 Al-Anon 00:04:00 The Intervention Approach3 00:04:00 Working with Addiction Why be a 'helper' 00:03:00 'Helper' qualities and attitudes 00:03:00 Counselling / 'helping' skills 00:04: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

Psychology - Advance Training Course Online
Delivered Online On Demand
£19

SQL NoSQL Big Data and Hadoop

4.9(27)

By Apex Learning

Overview This comprehensive course on SQL NoSQL Big Data and Hadoop will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This SQL NoSQL Big Data and Hadoop 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? At the end of the course there will be an online written test, which you can take either during or after the course. After successfully completing the test you will be able to order your certificate, these are included in the price. Who is This course for? There is no experience or previous qualifications required for enrolment on this SQL NoSQL Big Data and Hadoop. It is available to all students, of all academic backgrounds. Requirements Our SQL NoSQL Big Data and Hadoop 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 14 sections • 130 lectures • 22:34:00 total length •Introduction: 00:07:00 •Building a Data-driven Organization - Introduction: 00:04:00 •Data Engineering: 00:06:00 •Learning Environment & Course Material: 00:04:00 •Movielens Dataset: 00:03:00 •Introduction to Relational Databases: 00:09:00 •SQL: 00:05:00 •Movielens Relational Model: 00:15:00 •Movielens Relational Model: Normalization vs Denormalization: 00:16:00 •MySQL: 00:05:00 •Movielens in MySQL: Database import: 00:06:00 •OLTP in RDBMS: CRUD Applications: 00:17:00 •Indexes: 00:16:00 •Data Warehousing: 00:15:00 •Analytical Processing: 00:17:00 •Transaction Logs: 00:06:00 •Relational Databases - Wrap Up: 00:03:00 •Distributed Databases: 00:07:00 •CAP Theorem: 00:10:00 •BASE: 00:07:00 •Other Classifications: 00:07:00 •Introduction to KV Stores: 00:02:00 •Redis: 00:04:00 •Install Redis: 00:07:00 •Time Complexity of Algorithm: 00:05:00 •Data Structures in Redis : Key & String: 00:20:00 •Data Structures in Redis II : Hash & List: 00:18:00 •Data structures in Redis III : Set & Sorted Set: 00:21:00 •Data structures in Redis IV : Geo & HyperLogLog: 00:11:00 •Data structures in Redis V : Pubsub & Transaction: 00:08:00 •Modelling Movielens in Redis: 00:11:00 •Redis Example in Application: 00:29:00 •KV Stores: Wrap Up: 00:02:00 •Introduction to Document-Oriented Databases: 00:05:00 •MongoDB: 00:04:00 •MongoDB Installation: 00:02:00 •Movielens in MongoDB: 00:13:00 •Movielens in MongoDB: Normalization vs Denormalization: 00:11:00 •Movielens in MongoDB: Implementation: 00:10:00 •CRUD Operations in MongoDB: 00:13:00 •Indexes: 00:16:00 •MongoDB Aggregation Query - MapReduce function: 00:09:00 •MongoDB Aggregation Query - Aggregation Framework: 00:16:00 •Demo: MySQL vs MongoDB. Modeling with Spark: 00:02:00 •Document Stores: Wrap Up: 00:03:00 •Introduction to Search Engine Stores: 00:05:00 •Elasticsearch: 00:09:00 •Basic Terms Concepts and Description: 00:13:00 •Movielens in Elastisearch: 00:12:00 •CRUD in Elasticsearch: 00:15:00 •Search Queries in Elasticsearch: 00:23:00 •Aggregation Queries in Elasticsearch: 00:23:00 •The Elastic Stack (ELK): 00:12:00 •Use case: UFO Sighting in ElasticSearch: 00:29:00 •Search Engines: Wrap Up: 00:04:00 •Introduction to Columnar databases: 00:06:00 •HBase: 00:07:00 •HBase Architecture: 00:09:00 •HBase Installation: 00:09:00 •Apache Zookeeper: 00:06:00 •Movielens Data in HBase: 00:17:00 •Performing CRUD in HBase: 00:24:00 •SQL on HBase - Apache Phoenix: 00:14:00 •SQL on HBase - Apache Phoenix - Movielens: 00:10:00 •Demo : GeoLife GPS Trajectories: 00:02:00 •Wide Column Store: Wrap Up: 00:05:00 •Introduction to Time Series: 00:09:00 •InfluxDB: 00:03:00 •InfluxDB Installation: 00:07:00 •InfluxDB Data Model: 00:07:00 •Data manipulation in InfluxDB: 00:17:00 •TICK Stack I: 00:12:00 •TICK Stack II: 00:23:00 •Time Series Databases: Wrap Up: 00:04:00 •Introduction to Graph Databases: 00:05:00 •Modelling in Graph: 00:14:00 •Modelling Movielens as a Graph: 00:10:00 •Neo4J: 00:04:00 •Neo4J installation: 00:08:00 •Cypher: 00:12:00 •Cypher II: 00:19:00 •Movielens in Neo4J: Data Import: 00:17:00 •Movielens in Neo4J: Spring Application: 00:12:00 •Data Analysis in Graph Databases: 00:05:00 •Examples of Graph Algorithms in Neo4J: 00:18:00 •Graph Databases: Wrap Up: 00:07:00 •Introduction to Big Data With Apache Hadoop: 00:06:00 •Big Data Storage in Hadoop (HDFS): 00:16:00 •Big Data Processing : YARN: 00:11:00 •Installation: 00:13:00 •Data Processing in Hadoop (MapReduce): 00:14:00 •Examples in MapReduce: 00:25:00 •Data Processing in Hadoop (Pig): 00:12:00 •Examples in Pig: 00:21:00 •Data Processing in Hadoop (Spark): 00:23:00 •Examples in Spark: 00:23:00 •Data Analytics with Apache Spark: 00:09:00 •Data Compression: 00:06:00 •Data serialization and storage formats: 00:20:00 •Hadoop: Wrap Up: 00:07:00 •Introduction Big Data SQL Engines: 00:03:00 •Apache Hive: 00:10:00 •Apache Hive : Demonstration: 00:20:00 •MPP SQL-on-Hadoop: Introduction: 00:03:00 •Impala: 00:06:00 •Impala : Demonstration: 00:18:00 •PrestoDB: 00:13:00 •PrestoDB : Demonstration: 00:14:00 •SQL-on-Hadoop: Wrap Up: 00:02:00 •Data Architectures: 00:05:00 •Introduction to Distributed Commit Logs: 00:07:00 •Apache Kafka: 00:03:00 •Confluent Platform Installation: 00:10:00 •Data Modeling in Kafka I: 00:13:00 •Data Modeling in Kafka II: 00:15:00 •Data Generation for Testing: 00:09:00 •Use case: Toll fee Collection: 00:04:00 •Stream processing: 00:11:00 •Stream Processing II with Stream + Connect APIs: 00:19:00 •Example: Kafka Streams: 00:15:00 •KSQL : Streaming Processing in SQL: 00:04:00 •KSQL: Example: 00:14:00 •Demonstration: NYC Taxi and Fares: 00:01:00 •Streaming: Wrap Up: 00:02:00 •Database Polyglot: 00:04:00 •Extending your knowledge: 00:08:00 •Data Visualization: 00:11:00 •Building a Data-driven Organization - Conclusion: 00:07:00 •Conclusion: 00:03:00 •Assignment -SQL NoSQL Big Data and Hadoop: 00:00:00

SQL NoSQL Big Data and Hadoop
Delivered Online On Demand22 hours 34 minutes
£12

Counselling and Psychology

4.7(160)

By Janets

Course Overview Learn the Latest Skills | Acknowledged by CPD & QLS | MCQ Based Exam & Tutor Support | Interactive Video Training  The popular Counselling and Psychology Course will guide you through psychology’s core concepts, critical viewpoints, and applications. In addition, it offers comprehensive details on child cognitive development, how to handle abnormal behaviour, psychology research methodologies, and psychological approaches. You will have a variety of skills necessary to work in the health and social care sector, such as in hospitals, health centres, and child mental health services, by completing the Counselling and Psychology Course. Please note that this course does not entitle you to join the HCPC register or be acknowledged as a psychologist. However, through this course, you will come across all the basic guidelines of psychology to boost and shine your knowledge in this particular field of Psychology, which will add to your CPD points. What Will You Learn? Demonstrate knowledge of the major perspectives in psychology Recognize the major theories used in contemporary psychology Apply social psychological theories, principles and research findings to gain a better understanding of social issues Understand the cognitive development of children Recognize prevalent mental illnesses in both children and adults. Treatment for abnormal behaviour and knowledge of abnormal behaviour's diagnosis Apply data analysis in psychology and expert research techniques. What classes are included in this package? Earn a digital certificate upon successful completion acknowledged by UK and internationally acknowledged lesson There are no set schedules, so you can work at your own pace. Our email and live chat specialists are available to assist you 24 hours a day, 7 days a week. On weekdays, you’ll have access to a full-time tutor. Learn in a user-friendly, cutting-edge online learning environment. High-quality e-learning study materials Benefit from instant feedback through mock exams and multiple-choice assessments Who Should Take This Course? This course is an essential learning exercise for anybody considering a career in counselling, and the welfare or healthcare sectors, where communication and empathy are valued commodities. No formal lesson is required before enrolling on the course. Career Path Training offered by Counselling and Psychology could potentially benefit a range of roles, but would particularly enhance careers in: SEN Teacher Counselling Psychologist Life Coach Social Care Worker Psychotherapist Clinical Psychologist Child Psychologist School Counsellor 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 Mock exams Multiple-choice assessments Assignment Certificate of Achievement After the successful completion of the final assessment, you will receive a CPD-accredited certificate of achievement. The PDF certificate is for £9.99, and it will be sent to you immediately after through e-mail. You can get the hard copy for £15.99, which will reach your doorsteps by post. Endorsed Certificate of Achievement from the Quality Licence Scheme Once the course has been completed and the assessment has been passed, all students are entitled to receive an endorsed certificate. This will provide proof that you have completed your training objectives, and each endorsed certificate can be ordered and delivered to your address for only £99. Please note that overseas students may be charged an additional £10 for postage. Endorsement This course and/or training programme has been endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. This course and/or training programme is not regulated by Ofqual and is not an accredited qualification. Your training provider will be able to advise you on any further recognition, for example progression routes into further and/or higher education. For further information please visit the Learner FAQs on the Quality Licence Scheme website. Method of Assessment On successful completion of the Counselling and Psychology, you will be required to sit an online multiple-choice assessment. You will need to score 60% or above to pass the course. After successfully passing the exam, you will be able to apply for a Quality Licence Scheme endorsed certificate of achievement. The assessment will be evaluated automatically and the results will be given to you immediately. Retake fee If you do not pass the exam first time, you can purchase the Retake Exam for £1.99 and try again. Course Contents Perspectives in Psychology Social Psychology Cognitive Psychology and Its Applications Child Development The Psychology of Atypical (Abnormal) Behaviour Research Methods

Counselling and Psychology
Delivered Online On Demand3 weeks
£9.99

Counselling, Psychology and Cognitive Development

4.7(160)

By Janets

Follow your dreams by enrolling on the Counselling, Psychology and Cognitive Development course today and develop the experience, skills and knowledge you need to enhance your professional development. Counselling, Psychology and Cognitive Development will help you arm yourself with the qualities you need to work towards your dream job. Study the Counselling, Psychology and Cognitive Development training course online with Janets through our online learning platform and take the first steps towards a successful long-term career. The Counselling, Psychology and Cognitive Development course will allow you to enhance your CV, impress potential employers, and stand out from the crowd.  This Counselling, Psychology and Cognitive Development course consists of a number of easy to digest, in-depth modules, designed to provide you with a detailed, expert level of knowledge. Study the Counselling, Psychology and Cognitive Development course through a mixture of instructional video lessons and online study materials. Receive online tutor support as you study the Counselling, Psychology and Cognitive Development course, to ensure you are supported every step of the way. Get a digital certificate as proof of your Counselling, Psychology and Cognitive Development course completion. Janets is one of the top online training course providers in the UK, and we want to make education accessible to everyone! Learn the essential skills you need to succeed and build a better future for yourself with the Counselling, Psychology and Cognitive Development course. The Counselling, Psychology and Cognitive Development course is designed by industry experts and is tailored to help you learn new skills with ease.  The Counselling, Psychology and Cognitive Development is incredibly great value and allows you to study at your own pace. With full course access for one year, you can complete the Counselling, Psychology and Cognitive Development when it suits you. Access the Counselling, Psychology and Cognitive Development course modules from any internet-enabled device, including computers, tablets, and smartphones. The Counselling, Psychology and Cognitive Development course is designed to increase your employability and equip you with everything you need to be a success. Enrol on the Counselling, Psychology and Cognitive Development now and start learning instantly! Please note that this course does not entitle you to join the HCPC register or recognised as psychologist. Through this course you will come across all the basic guidelines of psychology to boost and shine your knowledge in this particular field of Psychology and it will add your CPD points. What You Get Out Of Studying Counselling, Psychology and Cognitive Development With Janets: Receive a digital Certificate upon successful completion of the Counselling, Psychology and Cognitive Development 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) Description The Counselling, Psychology and Cognitive Development training course is delivered through Janets' online learning platform. Access the Counselling, Psychology and Cognitive Development content from any internet-enabled device whenever or wherever you want to. The Counselling, Psychology and Cognitive Development course has no formal teaching deadlines, meaning you are free to complete the course at your own pace. Method of Assessment  To successfully complete the Counselling, Psychology and Cognitive Development course, students will have to take an automated multiple-choice exam. This exam will be online and you will need to score 60% or above to pass the Counselling, Psychology and Cognitive Development course. After successfully passing the Counselling, Psychology and Cognitive Development course exam, you will be able to apply for a CPD-accredited certificate as proof of your Counselling, Psychology and Cognitive Development qualification. Certification All students who successfully complete the Counselling, Psychology and Cognitive Development course can instantly download their digital certificate. You can also purchase a hard copy of the Counselling, Psychology and Cognitive Development course certificate, which will be delivered by post for £9.99. Who Is This Course For: The Counselling, Psychology and Cognitive Development is ideal for those who already work in this sector or are an aspiring professional. This Counselling, Psychology and Cognitive Development 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 Counselling, Psychology and Cognitive Development is open to all students and has no formal entry requirements. To study the Counselling, Psychology and Cognitive Development course, 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. Career Path: The Counselling, Psychology and Cognitive Development is ideal for anyone who wants to pursue their dream career in a relevant industry. Learn the skills you need to boost your CV and go after the job you want. Complete the Counselling, Psychology and Cognitive Development and gain an industry-recognised qualification that will help you excel in finding your ideal job. Course Content Perspectives in Psychology What is Psychology 00:08:00 The Biological Approach 00:10:00 Behaviourist and Cognitive Approaches 00:10:00 Person-Centred Approaches 00:09:00 Research Methods in Psychology 00:12:00 Debates in Psychology 00:13:00 Social Psychology Social Influence: Compliance, Obedience and Conformity 00:10:00 Social Cognition 00:09:00 Applied Social Psychology 00:10:00 Cognitive Psychology and Its Applications Perception 00:10:00 Attention 00:07:00 Remembering (Memory) 00:10:00 Forgetting (Memory) 00:07:00 Language 00:10:00 Thinking (Cognition) 00:07:00 Attitudes 00:10:00 Problem-Solving and Artificial Intelligence 00:09:00 Child Development Issues in Child Development 00:05:00 Cognitive Development 00:07:00 The Development of Language and Communication 00:06:00 Social Perception (Interpersonal Perception) 00:06:00 Moral Development 00:09:00 The Psychology of Atypical (Abnormal) Behaviour The definition and Diagnosis of Atypical (Abnormal) Behaviour 00:07:00 Treatments of atypical (abnormal) behaviour 00:07:00 Emotional disorders 00:05:00 Research Methods Research Methods 00:06:00 Research Issues 00:06:00 Data Analysis 00:07:00 Thank You and Good Bye! 00:02:00 Resources Resources - Psychology Diploma 00:00:00 Mock Exam Mock Exam- Counselling, Psychology and Cognitive Development 00:20:00 Final Exam Final Exam- Counselling, Psychology and Cognitive Development 00:20: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.

Counselling, Psychology and Cognitive Development
Delivered Online On Demand4 hours 34 minutes
£25

Microsoft Excel Complete Course - Beginner Intermediate & Advanced

By iStudy UK

Microsoft Excel Complete Course - Beginner Intermediate & Advanced To make learning Microsoft Excel easier for you, we have thoughtfully bundled our three greatest courses: Microsoft Excel Beginners, Intermediate, and Advanced. At this price, you won't find a better deal anywhere else. One of the most popular applications for visualizing and analyzing data that has been created to date is Microsoft Excel. These days, practically every industry and household use this helpful program for personal purposes. Excel is used by business owners for a plethora of tasks, including data analysis, visualizing data, tracking hours worked, money, and statements. This Microsoft Excel Complete Course can be very helpful to you whether you are a newbie, have some training and experience with the program, or haven't used Excel in a long time and need a thorough refresher to develop your skills. After completing this course, you will be a proficient Excel user. In a short period of time, our simple lessons will impart the knowledge in a very easy way. There won't be a rush because you can study whenever you want and at your own speed. After completing the course, your confidence in using Excel will increase. Course Highlights Microsoft Excel Complete Course - Beginner Intermediate & Advanced is an award winning and the best selling course that has been given the CPD Certification & IAO accreditation. It is the most suitable course anyone looking to work in this or relevant sector. It is considered one of the perfect courses in the UK that can help students/learners to get familiar with the topic and gain necessary skills to perform well in this field. We have packed Microsoft Excel Complete Course - Beginner Intermediate & Advanced into 73 modules for teaching you everything you need to become successful in this profession. To provide you ease of access, this course is designed for both part-time and full-time students. You can become accredited in just 11 hours, 6 minutes hours and it is also possible to study at your own pace. We have experienced tutors who will help you throughout the comprehensive syllabus of this course and answer all your queries through email. For further clarification, you will be able to recognize your qualification by checking the validity from our dedicated website. Why You Should Choose Microsoft Excel Complete Course - Beginner Intermediate & Advanced Lifetime access to the course No hidden fees or exam charges CPD Accredited certification on successful completion Full Tutor support on weekdays (Monday - Friday) Efficient exam system, assessment and instant results Download Printable PDF certificate immediately after completion Obtain the original print copy of your certificate, dispatch the next working day for as little as £9. Improve your chance of gaining professional skills and better earning potential. Who is this Course for? Microsoft Excel Complete Course - Beginner Intermediate & Advanced is CPD certified and IAO accredited. 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 backgrounds. Requirements Our Microsoft Excel Complete Course - Beginner Intermediate & Advanced 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 You will be ready to enter the relevant job market after completing this course. You will be able to gain necessary knowledge and skills required to succeed in this sector. All our Diplomas' are CPD and IAO accredited so you will be able to stand out in the crowd by adding our qualifications to your CV and Resume. Microsoft Excel Complete Course - Beginner Intermediate & Advanced Microsoft Excel 2019 New Features Introduction to Microsoft Excel 2019 New Features 00:07:00 CONCAT 00:02:00 IFS 00:01:00 MAXIFS 00:01:00 MINIFS 00:01:00 SWITCH 00:02:00 TEXTJOIN 00:01:00 Map Chart 00:02:00 Funnel Chart 00:01:00 Better Visuals 00:06:00 Pivot Table Enhancements 00:02:00 Power Pivot Updates 00:01:00 Getting Started With Microsoft Office Excel Navigate the Excel User Interface 00:28:00 Use Excel Commands 00:28: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 Working With Functions Work with Ranges 00:18:00 Use Specialized Functions 00:11:00 Work with Logical Functions 00:24:00 Work with Date & Time Functions 00:08:00 Work with Text Functions 00:11:00 Working With Lists 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 Analyzing Data Apply Intermediate Conditional Formatting 00:07:00 Apply Advanced Conditional Formatting 00:06:00 Visualizing Data With Charts Create Charts 00:13:00 Modify and Format Charts 00:12:00 Use Advanced Chart Features 00:13:00 Using PivotTables And Pivot Charts Create a PivotTable 00:13:00 Analyze PivotTable Data 00:12:00 Present Data with Pivot Charts 00:08:00 Filter Data by Using Timelines and Slicers 00:11:00 Working With Multiple Worksheets And Workbooks Use Links and External References 00:12:00 Use 3-D References 00:06:00 Consolidate Data 00:06:00 Using Lookup Functions And Formula Auditing Use Lookup Functions 00:13:00 Trace Cells 00:09:00 Watch and Evaluate Formulas 00:09:00 Sharing And Protecting Workbooks Collaborate on a Workbook 00:20:00 Protect Worksheets and Workbooks 00:08:00 Automating Workbook Functionality Apply Data Validation 00:13:00 Search for Invalid Data and Formulas with Errors 00:04:00 Work with Macros 00:18:00 Creating Sparklines And Mapping Data Create Sparklines 00:07:00 MapData 00:07:00 Forecasting Data Determine Potential Outcomes Using Data Tables 00:09:00 Determine Potential Outcomes Using Scenarios 00:09:00 Use the Goal Seek Feature 00:04:00 Forecasting Data Trends 00:05:00 Excel Templates Excel Templates 00:00:00 Resources Microsoft Excel 2019 00:00:00 Assignment Assignment - Microsoft Excel Complete Course - Beginner Intermediate & Advanced 00:00:00

Microsoft Excel Complete Course - Beginner Intermediate & Advanced
Delivered Online On Demand11 hours 6 minutes
£25