50881 Courses in Cardiff delivered Online

Explore the dynamic world of Organisational Planning & Ethics through our comprehensive course. It is designed for those aiming to make a big impact in the modern business world.

If you dream of becoming a sales superstar or want to sell more, dive in. Our sales prospecting and lead generation course is your next step!

If you think you may be interested in a career in Child Care, this Certificate in Skills for Working in Child Care Industries : Level 1 will provide you an introduction to the expectations of the sector. This Certificate in Skills for Working in Child Care Industries : Level 1 course will help learners to develop their skills and knowledge in order to start or advance their careers in a range of child care industries. This Certificate in Skills for Working in Child Care Industries : Level 1 course covers various aspects of child care, such as child development, childcare, working in childcare principles, and supporting a child's learning. Learners will also be able to develop the essential communication skills required to succeed in the industry. Learning Outcomes After completing this Certificate in Skills for Working in Child Care Industries : Level 1 course, learner will be able to: Understand caring for a baby Understand caring for a child Gain a thorough understanding of child development (0-3 Years) Know how to develop language and communication skills in children Know how to build & manage workplace relationship Understand bullying & harassment in the workplace Why Choose Level 1 Certificate in Skills for Working in Child Care Industries Course from Us Self-paced course, access available from anywhere. Easy to understand, high-quality study materials. Course developed by industry experts. MCQ quiz after each module to assess your learning. Automated and instant assessment results. 24/7 support via live chat, phone call or email. Free PDF certificate as soon as completing the course. ***Others Benefits of this Certificate in Skills for Working in Child Care Industries : Level 1 Course Free One PDF Certificate Lifetime Access Unlimited Retake Exam Tutor Support [ Note: Free PDF certificate as soon as completing the course ] Detailed Course Curriculum Module 1: Caring for a Baby Module 2: Caring for a Child Module 3: Child Development (0-3 Years) Module 4: Developing Language and Communication Skills in Children Module 5: Building & Managing Workplace Relationship Module 6: Bullying & Harassment In The Workplace Assessment Method After completing each module of the Certificate in Skills for Working in Child Care Industries : Level 1, you will find automated MCQ quizzes. To unlock the next module, you need to complete the quiz task and get at least 60% marks. Once you complete all the modules in this manner, you will be qualified to request your certification. Certification After completing the MCQ/Assignment assessment for this course, you will be entitled to a Certificate of Completion from Training Tale. It will act as proof of your extensive professional development. The certificate is in PDF format, which is completely free to download. A printed version is also available upon request. It will also be sent to you through a courier for £13.99. Who is this course for? This course is suitable for anyone who wants to learn the Certificate in Skills for Working in Child Care Industries : Level 1 industries or help young children develop in a nursery, childcare, or primary school setting. Requirements There are no specific requirements for this Certificate in Skills for Working in Child Care Industries : Level 1 course because it does not require any advanced knowledge or skills. Students who intend to enrol in this course must meet the following requirements: Good command of the English language Must be vivacious and self-driven Basic computer knowledge A minimum of 16 years of age is required Career path Upon successful completion of this Certificate in Skills for Working in Child Care Industries : Level 1 course, you may be able to pursue a number of career opportunities in the childcare industry. Such as- Nursery Childcare and Education Early Years Education And much more. Certificates Certificate of completion Digital certificate - Included

With the thriving real estate market, law firms and property companies require skilled professionals to assist with property transactions. According to recent data, there has been a 15% rise in job postings for Conveyancing Secretaries in the past year. These professionals handle administrative tasks, draft legal documents, and liaise with clients. Earning opportunities in this sector are promising, with salaries ranging from £20,000 to £30,000 per annum, depending on experience and location. The Conveyancing Secretary role offers a stable and rewarding career path in the UK. Our Conveyancing Secretary course starts with the basics of Conveyancing Secretary and gradually progresses towards advanced topics.. In the Conveyancing Secretary course, you will learn the essential knowledge needed to become well versed in Conveyancing Secretary. Learning Outcomes: Understand the fundamental principles of conveyancing. Apply property law and conveyancing practices effectively. Comprehend the law of contracts in relation to conveyancing. Execute standard conveyancing transactions proficiently. Demonstrate knowledge of accounting procedures in conveyancing transactions. Identify and address taxation issues in conveyancing. Conveyancing Secretary Curriculum Breakdown of the Conveyancing Secretary Course Module 01: Introduction to Conveyancing Module 02: Key Conveyancing Fundamentals Module 03: Property Law & Conveyancing Practice Module 04: Land Registry Updates and Law Module 05: Law of Contract Module 06: Landlord and Tenant Module 07: Standard Conveyancing Transactions Module 08: Understanding Accounting Procedures for Conveyancing Transactions Module 09: Preparing Legal Documents Module 10: Taxation Issues for Conveyancers CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Individuals seeking a career in conveyancing. Professionals in the legal field seeking specialisation. Real estate agents or brokers looking to expand their knowledge. Law students interested in property law and conveyancing. Paralegals or legal assistants seeking career advancement. Individuals interested in the legal aspects of property transactions. Requirements To enrol in this Conveyancing Secretary course, all you need is a basic understanding of the English Language and an internet connection. Career path The Conveyancing Secretary course will enhance your knowledge and improve your confidence in exploring opportunities in various sectors related to Conveyancing Secretary. Conveyancing Secretary (£18,000 - £30,000) Conveyancing Assistant (£18,000 - £25,000) Conveyancing Paralegal (£20,000 - £30,000) Conveyancing Executive (£25,000 - £35,000) Conveyancing Solicitor (£40,000 - £70,000) Certificates CPD Accredited PDF Certificate Digital certificate - Included CPD Accredited PDF Certificate CPD Accredited Hard Copy Certificate Hard copy certificate - £10.79 CPD Accredited Hard Copy Certificate Delivery Charge: Inside the UK: Free Outside of the UK: £9.99 each

Take on a fulfilling journey into the world of Nursery Nurse Training, where you'll delve into the essential aspects of nurturing and educating young children. This comprehensive course equips you with the foundational knowledge and practical skills needed to excel in early years education. Discover the intricacies of child growth and development, understanding how to foster a supportive environment that promotes their well-being and learning. Learn about nutrition tailored to children's needs, ensuring they receive healthy, balanced meals crucial for their development. Safety and health are paramount, as you grasp protocols ensuring children's welfare in early years settings. Gain expertise in observing and assessing children's progress, honing your ability to provide tailored support and learning experiences. Key Features: CPD Certified Free Certificate Developed by Specialist Lifetime Access Additionally, learn to collaborate effectively with parents and carers, fostering strong partnerships that enhance children's learning experiences. Embrace diversity and inclusivity, promoting environments where every child feels valued and supported. This course empowers you to design and implement early learning curricula, ensuring each child receives a nurturing education tailored to their unique needs and abilities. Join us and embark on a rewarding career dedicated to shaping young minds with confidence and expertise. Course Curriculum Module: 01 Introduction to Nursery Nurse Module: 02 Curriculum and Developing Early Learning Module: 03 Understanding the Growth and Development of Children Module: 04 Nutrition and Healthy Food for Children Module: 05 Health and Safety of Children in the Early Years Module: 06 Observations and Assessment of Children in the Early Years Setting Module: 07 Play and Learning in Children's Education Module: 08 Safeguarding, Protection and Welfare of Young Children Module: 09 Working in Partnership with Parents and Carers Module: 10 Promoting Equality, Diversity and Inclusive Practice in Early Years Learning Module: 11 Curriculum and Developing Early Learning Learning Outcomes: Demonstrate understanding of nursery nurse roles and responsibilities. Analyse stages of child development for effective care planning. Apply knowledge of nutrition to promote children's health and growth. Implement health and safety practices in early years settings. Utilise observation techniques for assessing children's developmental progress. Facilitate inclusive learning environments through play-based educational activities. CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Individuals aspiring to work with young children in nursery settings. Those interested in promoting child health and well-being. People aiming to support early childhood education initiatives. Individuals seeking to enhance skills in child development practices. Those looking to contribute to diverse and inclusive educational environments. Career path Nursery Nurse Early Years Practitioner Childcare Assistant Preschool Teacher Family Support Worker Playgroup Leader Certificates Digital certificate Digital certificate - Included Will be downloadable when all lectures have been completed.

Are you looking to enhance your Business Management skills? If yes, then you have come to the right place. Our comprehensive course on Business Management will assist you in producing the best possible outcome by mastering the Business Management skills. The Business Management course is for those who want to be successful. In the Business Management course, you will learn the essential knowledge needed to become well versed in Business Management. Our course starts with the basics of Business Management and gradually progresses towards advanced topics. Therefore, each lesson of this Business Management course is intuitive and easy to understand. Why would you choose the Business Management course from Compliance Central: Lifetime access to Business Management course materials Full tutor support is available from Monday to Friday with the Business Management course Learn Business Management skills at your own pace from the comfort of your home Accessible, informative Business Management learning modules designed by expert instructors Get 24/7 help or advice from our email and live chat teams with the bundle Study in your own time through your computer, tablet or mobile device A 100% learning satisfaction guarantee with your Business Management Course Curriculum Breakdown of the Business Management Course Module 01: Introduction to Business Management Module 02: Operations Management Module 03: Introduction to Business Analysis Module 04: Strategic Analysis and Product Scope Module 05: Project Management Module 06: Business Development and Succession Planning Module 07: Business Process Management Module 08: Planning & Forecasting Operations Module 09: Performance Management Module 10: Management of Cash and Credit Module 11: Managing Risk and Recovery Module 12: Quality Management Module 13: Communication Skills Module 14: Business Environment Module 15: Organisational Skills Module 16: Negotiation Techniques Module 17: Human Resource Management Module 18: Motivation and Counselling Module 19: Customer Service Module 20: Time Management Module 21: Conflict Management CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The Business Management course helps aspiring professionals who want to obtain the knowledge and familiarise themselves with the skillsets to pursue a career. Requirements To enrol in this Business Management course, all you need is a basic understanding of the English Language and an internet connection. Career path The Business Management course will enhance your knowledge and improve your confidence in exploring opportunities in various sectors. Certificates CPD Accredited PDF Certificate Digital certificate - Included CPD Accredited PDF Certificate CPD Accredited Hard Copy Certificate Hard copy certificate - £10.79 CPD Accredited Hard Copy Certificate Delivery Charge: Inside the UK: Free Outside of the UK: £9.99 each

Designated Safeguarding Lead Training Online If you want to learn about Designated Safeguarding Lead Training and become an expert in the field, you have arrived at the right place. Industry experts designed this Designated Safeguarding Lead training course to enable you to learn quickly and efficiently and at your own pace and convenience. This exclusive Designated Safeguarding Lead Training will teach you more about the role and will assist you in better understanding the safeguarding process. The Designated Safeguarding Lead Training Uk Online course uses a combination of written text and interactive exercises to help you review and develop your organization's child protection procedures and ensure that all staff members understand their roles in safeguarding children. As the Designated Safeguarding Lead Training, you are the first point of contact for staff members, families, and anyone who has access to your organization; therefore, you must have a thorough understanding of child protection procedures. Enrol Designated Safeguarding Lead training today and take the next step towards your personal and professional goals. Designated Safeguarding Lead Training Learning Outcomes After completing this Designated Safeguarding Lead Training Course, the learner will be able to: Understand the fundamentals of safeguarding. Understand safeguarding structure and guidance. Know how to recognise abuse and how to respond to disclosures. Know the responses under the safeguarding structure. know how to resolve disagreements. Understand the principles of confidentiality. Understand the importance of Record-Keeping. Certificate of Completion You will receive a Designated Safeguarding Lead Training course completion certificate for free as soon as you complete the Designated Safeguarding Lead Training course. Module: 01 Introduction 12:00 1: Introduction 08:00 PDF 2: Quiz: Introduction 04:00 Module 02: Safeguarding Structure and Guidance 14:00 3: Safeguarding Structure and Guidance 10:00 PDF 4: Quiz: Safeguarding Structure and Guidance 04:00 Module 03: Recognising and Responding to Abuse 18:00 5: Recognising and Responding to Abuse 15:00 PDF 6: Quiz: Recognising and Responding to Abuse 03:00 Module 04: Responses Under the Safeguarding Structure 15:00 7: Responses Under the Safeguarding Structure 11:00 PDF 8: Quiz: Responses Under the Safeguarding Structure 04:00 Module 5: Working Together and Sharing Information 14:00 9: Working Together and Sharing Information 12:00 PDF 10: Quiz: Working Together and Sharing Information 02:00 Module 6: Recording Information 16:00 11: Recording Information 12:00 PDF 12: Quiz: Recording Information 04:00 Who is this course for? Designated Safeguarding Lead Training This Designated Safeguarding Lead Training Course is ideal for anyone. Requirements Designated Safeguarding Lead Training There are no specific requirements for Designated Safeguarding Lead Training course. Career path Designated Safeguarding Lead Training Certificates Reed Courses Certificate of Completion Digital certificate - Included Will be downloadable when all lectures have been completed.

Are you looking to enhance your Diploma in AML Compliance Manager Training skills? If yes, then you have come to the right place. Our comprehensive course on Diploma in AML Compliance Manager Training will assist you in producing the best possible outcome by mastering the Diploma in AML Compliance Manager Training skills. The Diploma in AML Compliance Manager Training course is for those who want to be successful. In the Diploma in AML Compliance Manager Training course, you will learn the essential knowledge needed to become well versed in Diploma in AML Compliance Manager Training. Our course starts with the basics of Diploma in AML Compliance Manager Training and gradually progresses towards advanced topics. Therefore, each lesson of this course is intuitive and easy to understand Along with the Diploma in AML Compliance Manager Training courses, you also get: Lifetime Access. Unlimited Retake Exam & Tutor Support. Easy Accessibility to the Course Materials- Anytime, Anywhere - From Any Smart Device (Laptop, Tablet, Smartphone Etc.) 100% Learning Satisfaction Guarantee. Description: Learn at your own pace from the comfort of your home, as the rich learning materials of this course are accessible from any place at any time. The curriculums are divided into tiny bite-sized modules by industry specialists. And you will get answers to all your queries from our experts. So, enrol and excel in your career with Compliance Central. Diploma in AML Compliance Manager Training Course Curriculum 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 CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone from any background can enrol in this Diploma in AML Compliance Manager Training course. Requirements To enrol in this Diploma in AML Compliance Manager Training course, all you need is a basic understanding of the English Language and an internet connection. Career path After completing this course, you can explore trendy and in-demand jobs related to Diploma in AML Compliance Manager Training. AML Compliance Analyst: £25,000 to £40,000 per year AML Compliance Officer: £30,000 to £50,000 per year AML Compliance Manager: £40,000 to £65,000 per year Financial Crime Analyst: £28,000 to £45,000 per year Risk and Compliance Specialist: £35,000 to £55,000 per year Certificates CPD Accredited PDF Certificate Digital certificate - Included CPD Accredited PDF Certificate Certificate of completion Hard copy certificate - £10.79 CPD Accredited Hard Copy Certificate Delivery Charge: Inside the UK: Free Outside of the UK: £9.99 each

Description: Would you like to know how to become a nanny? With the help of this course, take a stepping stone rewarding work in the home based childcare industry. If you were always passionate about supporting the emotional and psychological development of children of the same age, this course is just perfect for you! Employment in this very large occupation rose strongly in the past five years and is forecast to grow strongly in the long-term. Nannies care for children as employees or contractors in private households. Employment can be sought in almost any location nationwide. International work opportunities for professional nannies exist in many countries. Join the course now! Who is the course for? Health Professionals and Workers who are into babies' growth and development Anyone who wants to know how baby care works 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 English language, numeracy and ICT are required to attend this course. Certification: After completing the course, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Why choose us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos/materials from the industry leading experts; Study in a user-friendly, advanced online learning platform; The UK & internationally recognised accredited qualification; Access to course content on mobile, tablet or desktop from anywhere anytime; The benefit of career advancement opportunities; 24/7 student support via email. Career Path: Baby Care and Nannying Diploma is a useful qualification to possess and would be beneficial for the following careers: Child Care Specialist Nanny Infant Massage Therapist Labour and Delivery Nurse Paediatric Nurse Pediatric Physical Therapist Lactation Consultant Midwife. First Baby Care Bonding Time With My First Baby 00:30:00 Communicating With My First Baby 00:30:00 Fashion Tips For My First Baby 00:30:00 How To Change My First Baby's Diaper 00:30:00 My First Baby Essentials 00:30:00 My First Baby Feeding Guide 00:30:00 My First Baby Learning The Basics 00:30:00 My First Baby: Understanding The Crying Game 00:30:00 Nutritious Bites For My First Baby 00:30:00 The Joys And Angst Of Holding My First Baby 00:30:00 Baby Care Basics Baby Products For Bath 00:30:00 Tips To Manage Your Baby Sleeping Schedules 00:30:00 Baby Weaning Difficulties And Tips To Cope With It 00:30:00 Choosing The Right Baby Care 00:30:00 Choosing The Right Baby Formula 00:30:00 Coping With Colic 00:30:00 Diaper Rash Help 00:30:00 Feeding Schedules Tips to Get it Right 00:30:00 How To Get Rid Of A Pacifier 00:30:00 Premature Baby Help 00:30:00 Reading To Baby 00:30:00 Reducing Baby's Risk Of Choking 00:30:00 Safety Measures For Food Borne Illnesses 01:00:00 The Benefits of Breastfeeding 00:30:00 Why Do Babies Cry 00:30:00 Baby Car Seat Buying Tips 00:30:00 When You Spot Something Wrong 00:30:00 Baby Care and Breastfeeding 00:30:00 Baby Care And Television 00:15:00 Baby Hazards: Be Careful Or You May Not Know 00:30:00 Baby Pacifiers: Yes Or No 00:30:00 What's In The Nursery 00:30:00 Baby Bathing Is This Hard To Do 00:30:00 5 Things To Keep In Mind With Baby Care 00:30:00 Babies At Work Good Or Bad 00:15:00 Baby Sleeping Everything You Need To Know About Baby Sleeping 00:15:00 3 Best Organic Baby Sleeping Bags 00:30:00 All About Baby Sleeping Bags 00:30:00 Baby Sleeping and Intimacy 00:30:00 5 Steps To Get Your Baby To Sleep 00:30:00 Organic Baby Sleeping Linens 00:15:00 5 More Tips To Get Your Baby To Sleep 00:30:00 Baby Sleeping and Family 00:15:00 Allergies and Baby Sleeping 00:30:00 Baby Sleeping For You 00:15:00 Baby Sleeping For New Dads 00:30:00 Enough is Enough Baby Sleeping 00:30:00 Refusing to Sleep 01:00:00 3 Great Companies for Baby Sleeping Sacks 00:30:00 Teething and Baby Sleeping 00:30:00 5 Great Habits for Baby Sleeping 01:00:00 Organic Baby Sleeping 00:30:00 Baby Sleeping Techniques 00:30:00 The 5 S's To Baby Sleeping 00:30:00 The Controlled Crying Technique 00:30:00 Home Remedies For Baby Sleeping 00:30:00 How To Put Your Child To Bed Easily 01:00:00 Is Baby's Sleeping Affecting Other Children? 00:15:00 Multiple Bedtimes 00:30:00 SIDS 01:00:00 Nannying What is a Nanny? 00:30:00 Time Management for Nannies 00:15:00 A Day in the Life of Martha, the Nanny 00:30:00 Caregiver and Team Player 00:15:00 It Takes a Village to Raise a Child 00:15:00 The Nanny's Job Profile 00:15:00 Meet the Needs of the Child 01:00:00 Childcare Child Care Guidelines 00:30:00 Outdoor Safety 00:15:00 Plants That Poison 00:15:00 Guidelines for Food Preparation and Handling 00:30:00 Changing Diapers 00:30:00 Symptoms of Illness 00:30:00 Order your certificate Order Your Certificate 00:00:00

Dive into the intricate world of numbers and data with our comprehensive 'Microsoft Excel & Accounting Training' course. Begin your journey by mastering the foundational elements of Microsoft Office Excel 2016, from the basics of worksheet modifications to the art of data visualisation using charts. As you progress, pivot your attention towards the meticulous realm of accounting. Here, you'll unravel the secrets of the accounting equation, immerse yourself in transaction analyses, and culminate your learning by understanding the complete accounting cycle. Whether you're looking to enhance your data management skills or embark on a career in accounting, this course is your stepping stone to success. Learning Outcomes: Acquire proficiency in utilising Microsoft Excel 2016 for data analysis, visualisation, and workbook management. Understand the core principles of accounting, including the accounting equation and transaction analysis. Demonstrate the ability to prepare financial statements and complete the accounting cycle. Implement advanced Excel features such as PivotTables, PivotCharts, and Lookup Functions. Apply knowledge in real-world scenarios, including fiscal year evaluations and spreadsheet exercises. Why buy this Microsoft Excel & Accounting Training? Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments are designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the Microsoft Excel & Accounting Training Course at your own pace, on your own schedule. Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience Who is this Microsoft Excel & Accounting Training course for? Individuals aiming to bolster their data analysis and management capabilities. Aspiring accountants keen on understanding the fundamentals of the profession. Business owners desiring a deeper grasp of financial statements and accounting cycles. Students pursuing a career in finance or data management. Professionals looking to integrate Excel functionalities into their daily tasks. Career path Data Analyst: Average salary range: £25,000 - £40,000 Annually Accountant: Average salary range: £28,000 - £52,000 Annually Financial Controller: Average salary range: £40,000 - £70,000 Annually Management Accountant: Average salary range: £30,000 - £55,000 Annually Excel Specialist: Average salary range: £22,000 - £35,000 Annually Bookkeeper: Average salary range: £18,000 - £30,000 Annually Prerequisites This Microsoft Excel & Accounting Training does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Microsoft Excel & Accounting Training was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Certification After studying the course materials, there will be a written assignment test which you can take at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £4.99 Original Hard Copy certificates need to be ordered at an additional cost of £8. Course Curriculum **Microsoft Excel** Getting Started with Microsoft Office Excel 2016 Navigate the Excel User Interfact 00:28:00 Use Excel Commands 00:10:00 Create and Save a Basic Workbook 00:19:00 Enter Cell Data 00:12:00 Use Excel Help 00:05:00 Performing Calculations Create Worksheet Formulas 00:15:00 Insert Functions 00:17:00 Reuse Formulas and Functions 00:17:00 Modifying a Worksheet Insert, Delete, and Adjust Cells, Columns, and Rows 00:10:00 Search for and Replace Data 00:09:00 Use Proofing and Research Tools 00:07:00 Formatting a Worksheet Apply Text Formats 00:16:00 Apply Number Format 00:07: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:23: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 Create and Modify Tables 00:16:00 Apply Intermediate Conditional Formatting 00:07:00 Apply Advanced Conditional Formatting 00:05:00 Visualizing Data with Charts Create Charts 00:13:00 Modify and Format Charts 00:12:00 Use Advanced Chart Features 00:12:00 Using PivotTables and PivotCharts 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 Working with Multiple Worksheets and Workbooks Use Links and External References 00:12:00 Use 3-D References 00:06:00 Consolidate Data 00:05:00 Using Lookup Functions and Formula Auditing Use Lookup Functions 00:12:00 Trace Cells 00:09:00 Watch and Evaluate Formulas 00:08:00 Sharing and Protecting Workbooks Collaborate on a Workbook 00:19: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:08:00 Determine Potential Outcomes Using Scenarios 00:09:00 Use the Goal Seek Feature 00:04:00 Forecasting Data Trends 00:05:00 **Accounting Training** Professional Bookkeeper Introduction Professional Bookkeeper 00:09:00 Introduction to Accounting and Business Defining a Business 00:07:00 Ethics in Accounting 00:05:00 Generally Accepted Accounting Principles (GAAP) 00:10:00 The Accounting Equation The Accounting Equation 00:07:00 Transactions 00:11:00 Financial Statements 00:13:00 Analyzing Transactions The Accounting Equation and Transactions 00:16:00 Double-Entry System 00:11:00 Transactions - Journalizing 00:17:00 Journal Entries 00:38:00 Entering Information - Posting Entries Posting Entries 00:10:00 The Trial Balance 00:10:00 Finding Errors Using Horizontal Analysis 00:09:00 Horizontal Trend : Balance Sheet 00:21:00 Horizontal Trend: Income Statement 00:36:00 Adjusting Process The Purpose of the Adjusting Process 00:15:00 Adjusting Entries Adjusting Entries - Prepaid Expenses 00:13:00 Adjusting Entries - Accrued Revenues 00:10:00 Adjusting Entries - Depreciation Expense 00:09:00 Adjustment Summary Adjustment Summary - Review 00:13:00 Vertical Analysis 00:33:00 Preparing a Worksheet Preparing a Worksheet 00:06:00 Financial Statements The Income Statement 00:11:00 Financial Statements - Definitions 00:12:00 Completing the Accounting Cycle Temporary vs. Permanent Account 00:19:00 The Accounting Cycle Illustrated Accounting Cycle Illustrated - Steps 1-5 00:11:00 Accounting Cycle Illustrated - Steps 6-10 00:12:00 Fiscal Year Fiscal Year 00:09:00 Spreadsheet Exercise Spreadsheet Exercise - Steps 1-4 00:11:00 Spreadsheet Exercise - Steps 5-7 00:37:00