Power Query and Power Pivot in Microsoft Excel: A Quickstart Guide Course Description Copyright Ross Maynard 2022 Course Description Power Query and Power Pivot are two tools available in Microsoft Excel. If you are serious about data analysis, then you need to know how to use these tools. This Quickstart guide will give you the skills you need to get started with these powerful features. The Power Query tool allows you to import external data and then modify it to meet your needs, before loading it into Excel. These editing tasks are all things you can do manually in Excel, but Power Query greatly speeds things up when you have a large volume of data. The Power Pivot tool allows you to connect multiple data tables in an extended pivot table. Power Pivot also introduces new analysis and query tools to further enhance data analysis. If data analysis is your thing, then this course will help you get up to speed with these feature-filled tools. Through screen-capture video, the course provides a step-by-step guide to the foundation skills needed to use both Power Query and Power Pivot effectively. The course is designed to make your first steps into Power Query easy and to build your confidence to use them on your own. Both Power Query and Power Pivot are also available in Microsoft Power BI – the data visualisation suite. Once you have learned how to use Power Query and Power Pivot in Excel with this course, you’ll have a head start in getting to grips with Power BI Get up to speed with Power Query and Power Pivot in Microsoft Excel with this Quickstart guide. Key Learning Points On completion of the course, delegates will be able to: Use Power Query to load data from an external source into Microsoft Excel Clean and manipulate external data before loading it into Excel Consolidate separate files with Power Query Update Excel tables with new data in the same format Use Power Query to “unpivot” report tables to prepare the data for analysis Explain the core functionality of Power Pivot Link data tables together in the Power Pivot data model Create pivot tables that draw data from several source data tables Create performance measures and new analysis in the Power Pivot data model Use the most popular DAX query language functions in Power Pivot Curriculum Lesson 1: Power Query Quickstart Lesson 2: Consolidating Files with Power Query Lesson 3: Unpivoting a Table Lesson 4: Power Pivot Quickstart Lesson 5: Power Pivot – Adding Data and Functionality Lesson 6: Key DAX Functions for Power Pivot Lesson 7: The DAX CALCULATE Function Lesson 8: Key Learning Points Pre-Course Requirements There are no pre-course requirements Additional Resources Starter spreadsheets for each lesson are provided so that learners can follow the steps presented. Course Tutor Your tutor is Ross Maynard. Ross is a Fellow of the Chartered Institute of Management Accountants in the UK and has 30 years’ experience as a process improvement consultant specialising in business processes and organisation development. Ross is also a professional author of online training courses. Ross lives in Scotland with his wife, daughter and Cocker Spaniel Questions What is the main feature of Power Query? The ability to link data tables together to create pivot tables that allow data to be drawn from any and all of the source tables The ability to clean and manipulate large volumes of external data efficiently and to load the result into Microsoft Excel The removal of Microsoft Excel’s restrictions on file sizes and the number of rows of data allowed The ability to visualise data in dashboards and management reports What is the main feature of Power Pivot? The ability to link data tables together to create pivot tables that allow data to be drawn from any and all of the source tables The ability to clean and manipulate large volumes of external data efficiently and to load the result into Microsoft Excel The removal of Microsoft Excel’s restrictions on file sizes and the number of rows of data allowed The ability to visualise data in dashboards and management reports Which of the following actions cannot be performed within Power Query? Split text into multiple columns Trimming text and removing spaces Creating calculated columns using DAX functions Make date based calculations Which of the following statements is true? You can use Power Query to combine files that have the same format and open them all in the same spreadsheet You can use Power Query to link data tables and create pivot tables that pull data items from all the linked tables You can use Power Query to create interactive dashboard reports You can use Power Query to export data files to Microsoft Access and other databases Which of the following provides a compelling case to use Power Pivot in Microsoft Excel? The data visualisation and presentation features of Power Pivot are much more powerful than those in Excel Power Pivot offers the ability to clean large files of data imported from other systems quickly Existing reports and tables can be “reverse engineered” (unpivoted) to create data tables for more advanced analysis Files sizes in Power Pivot are smaller than in Excel and there is no limit on the number of rows of data that can be stored. This makes it much faster and more efficient to use Power Pivot for large data sets Power Pivot uses analysis functions from the DAX formula language. What does “DAX” stand for? Digital Architecture Extraction Data Arbitrage Extrapolation Display Analytics Extension Data Analysis Expressions Deeply Annoying Exercise The DAX CALCULATE function is one of the most powerful and useful functions available in Power Pivot. Which statement best describes it? It performs row by row calculations defined by the user and adds the total of them all together for a specified table It performs row by row calculations defined by the user and displays the maximum result for a specified table It performs a defined calculation and then applies filters specified by the user It filters the data in a specified table according to criteria set by the user As well as in Power Pivot in Microsoft Excel, in what application are DAX functions also available? Microsoft PowerPoint Microsoft Forms Microsoft Teams Microsoft Power BI How do DAX functions differ from Microsoft Excel functions? DAX functions are designed specifically for use with SQL based data sources DAX functions are completely new and provide additional functionality within Microsoft Excel DAX functions never take a cell reference or a range as reference, but instead take a column or table as reference DAX date and time functions return a date as a serial number, whereas Excel date and time functions return a datetime data type
Branding is an important aspect of marketing to promote your product or services. It is best for you to be exposed to strategies, methods, and solutions on the marketing performance your business is currently having. This Professional Diploma in Business Administration and Branding can help you in learning marketing applications how to identify problems and create solutions for your marketing needs. You will learn new strategies and techniques appropriate for your brand to promote your products and services to your target market. Course Highlights The price is for the whole course including final exam - no hidden fees Accredited Certificate upon successful completion at an additional cost Efficient exam system with instant results Track progress within own personal learning portal 24/7 customer support via live chat Professional Diploma in Business Administration and Branding has been given CPD accreditation and is one of the best-selling courses available to students worldwide. This valuable course is suitable for anyone interested in working in this sector or who simply wants to learn more about the topic. If you're an individual looking to excel within this field then Professional Diploma in Business Administration and Branding is for you. We've taken this comprehensive course and broken it down into several manageable modules which we believe will assist you to easily grasp each concept - from the fundamental to the most advanced aspects of the course. It really is a sure pathway to success. All our courses offer 12 months access and are designed to be studied at your own pace so you can take as much or as little time as you need to complete and gain the full CPD accredited qualification. And, there are no hidden fees or exam charges. We pride ourselves on having friendly and experienced instructors who provide full weekday support and are ready to help with any of your queries. So, if you need help, just drop them an email and await a speedy response. Furthermore, you can check the validity of your qualification and verify your certification on our website at anytime. So, why not improve your chances of gaining professional skills and better earning potential. Assessment and Certification At the end of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful. After you have successfully passed the final exam, you will be able to order an Accredited Certificate of Achievement at an additional cost of £19 for a PDF copy and £29 for an original print copy sent to you by post or for both £39. Career Path Not only does our CPD and CiQ accredited course look good on your CV, setting you apart from the competition, it can be used as a stepping stone to greater things. Further advance your learning, launch a new career or reinvigorate an existing one. On successful completion of this course, you have the potential to achieve an estimated salary of £17,100. The sky really is the limit. Course Curriculum Business Administration What is Business Administration? 00:30:00 Business and Organisations 00:15:00 Management of Business 00:40:00 Business Organization Perspectives 00:30:00 Decision Making 00:30:00 Approaches to Leadership 00:30:00 Business Communication Communication Basics 00:30:00 Know Thyself and The Message 00:30:00 Learn To Use Terms of Business Communication That Invoke Emotions 00:30:00 Pay Attention To Body Language 00:30:00 Learn To Use Terms That Spark Interest 00:30:00 The Benefits Of Presenting Your Message In 1 Minute 00:30:00 Branding Basics Introduction 00:15:00 The Purple Cow 00:30:00 Try to be an Exceptionist 00:30:00 Make Yourself Well Recognised Before Your Customers 00:15:00 Wow Your Customers 00:30:00 Develop a Personal Style 00:30:00 Use Creative Imageries to Catch the Attention 00:30:00 Be a Traditionalist, Not a Fad Chaser 00:15:00 Bringing Out the Purple Cow in Your Business 00:30:00 Conclusion 00:15:00 Brand Management Defining Branding 00:15:00 What Are You All About? 00:30:00 Creating a Mission 00:15:00 Creating a Vision of the Future 00:15:00 Positioning Your Brand 00:15:00 Developing Your Style 00:15:00 Developing a Brand Name and Slogan 00:15:00 Creating a Visual Identity 00:30:00 Living Your Brand 00:15:00 Connecting with Customers 00:15:00 Launching Your Brand 00:15:00 Taking Your Brand's Pulse 00:15:00 Performing a SWOT Analysis 00:15:00 Measuring Brand Health with a Balanced Scorecard 00:15:00 Middleton's Brand Matrix 00:15:00 Interpreting Evaluation Results 00:15:00 Keeping the Brand Alive 00:15:00 Going Beyond the Brand 00:15:00 Business Branding What Is Branding 00:30:00 Research Your Topic Thoroughly 00:30:00 Let People Know Who You Are: Distinguish Yourself 01:00:00 Represent Yourself 00:30:00 Networking With Social Media 01:00:00 Use Videos 00:30:00 Offer Training Courses 00:30:00 Provide Quality Material And Customer Service 00:30:00 Live And Breathe Your Brand 00:30:00 How Not Branding Can Spell Disaster 00:15:00 Personal Branding Module One - Getting Started 00:30:00 Module Two - Defining Yourself (I) 00:30:00 Module Three - Defining Yourself (II) 00:30:00 Module Four - Controlling and Developing Your Image 00:30:00 Module Five - Personal and Professional Influences 00:30:00 Module Six - Sharpening Your Brand 00:30:00 Module Seven - Appearance Matters 00:30:00 Module Eight - Social Media (I) 00:30:00 Module Nine - Social Media (II) 02:00:00 Module Ten - Brand Management During a Crisis 01:00:00 Module Eleven - Branding Personality Traits 00:30:00 Module Twelve - Wrapping Up 00:30:00 Recommended Reading Recommended Reading : Professional Diploma in Business Administration and Branding 00:00:00 Mock Exam Mock Exam - Professional Diploma in Business Administration and Branding 00:20:00 Final Exam Final Exam - Professional Diploma in Business Administration and Branding 00:20:00
***3-in-1 Exclusive Bundle*** Our extensive WordPress course is developed thoroughly for you to indulge and learn all the topics with utmost clarity and thorough explanation. This course includes not only one course but THREE courses within the bundle. So you are getting two extra courses for the price of one, no extra money! Our course aims to provide detailed insight into the WordPress with full support from our teachers. So if you are looking for a convenient way to boost your knowledge further of the WordPress topic but are too busy to go to a class, then enrol in this course and you are sorted! Our in-depth course has no time limit and can be accessed from anywhere in the world. You'll pick up a ton of fresh information, whether you're a novice or an advanced. The mega course's sheer size and breadth speak for itself! So, do not delay any further; we are excited and looking forward to letting you in our CPD Accredited course as much as you are! The following courses will not only fast-track your career but also make it even more rewarding: Course 01: Wordpress for Beginner Course 02: How To Build Easy Drag & Drop Landing Pages With Wordpress Course 03: Make a Wordpress WooCommerce Amazon Affiliate Store Learning Outcome From this interactive course, you will be able to: Deep dive into the basics of WordPress. Learn how to improve your skills in general. Increase your ability to reason and solve problems. Utilise the WordPress to boost output. Gain confidence and clarity in your communication. Explore different career routes in this field. This comprehensive three-in-one WordPress course equips you with critical guidance, methods, and strategies for increasing both employee and professional development. The WordPress course from Next Generation's easy-to-digest and deliverable modules will provide you with the most essential and useful knowledge for growing your profession, from setting personal development goals to forming a cross-functional team. Course Curriculum: Hosting & Setup Walking You Through The Wordpress Backend Picking a Theme Publishing Content & Plugins Hiring a Freelancer & Learning To Use FTP Comparing Landing Page Plugins Examples Of Landing Pages I've Built Using Thrive Themes for Landing Pages and Sales Pages Recommended Site Setup & Tools Niche Selection Amazon Plugin Comparison Site Setup (Using Prosociate) Search Engine Optimization Social Media Promotion Paid Advertising, Blogging & Promotion Outsourcing Help & Hiring Virtual Assistants Email Marketing Beyond Being Just an Amazon Affiliate - Phasing Into eCommerce Becoming an Etsy Affiliate And Many more ... Show off your new skills with a certificate of completion Once you complete the WordPress course, you will be eligible to request a digital certificate for free. For Printed Transcript & Hardcopy Certificate- 4.99 GBP (Inside the UK Postal Fee) 8.99 GBP (International Delivery Fee) CPD 30 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This comprehensive three-in-one bundled WordPress course has no restrictions for people registering for it. Anyone between the age of above sixteen can apply for the course. So whether you are an eager learner to explore the deeper unknown facts of the subject or a skilled individual in this field who wishes to enhance their career prospects further can take this course. Requirements No previous knowledge of the WordPress is required to enrol in this training. Career path The aim of this exclusive bundle WordPress course is to help you toward your dream career. So, complete this course and enhance your skills to explore opportunities in relevant areas.
Duration 5 Days 30 CPD hours This course is intended for System administrators System integrators Overview By the end of the course, you should be able to meet the following objectives: Introduce troubleshooting principles and procedures Practice Linux commands that aid in the troubleshooting process Use command-line interfaces, log files, and the vSphere Client to diagnose and resolve problems in the vSphere environment Explain the purpose of key vSphere log files Identify networking problems based on reported symptoms, validate and troubleshoot the reported problem, identify the root cause and implement the appropriate resolution Analyze storage failure scenarios using a logical troubleshooting methodology, identify the root cause, and apply the appropriate resolution to resolve the problem Troubleshoot vSphere cluster failure scenarios and analyze possible causes Diagnose common VMware vSphere High Availability problems and provide solutions Identify and validate VMware ESXi⢠host and VMware vCenter Server problems, analyze failure scenarios, and select the correct resolution Troubleshoot virtual machine problems, including migration problems, snapshot problems, and connection problems Troubleshoot performance problems with vSphere components This five-day, hands-on training course provides you with the advanced knowledge, skills, and abilities to achieve competence in troubleshooting the VMware vSphere© 7.x environment. This workshop increases your skill and competence in using the command-line interface, VMware vSphere© Client?, log files, and other tools to analyze and solve problems Course Introduction Introductions and course logistics Course objectives Introduction to Troubleshooting Define the scope of troubleshooting Use a structured approach to solve configuration and operational problems Apply a troubleshooting methodology to logically diagnose faults and improve troubleshooting efficiency Troubleshooting Tools Use command-line tools (such as Linux commands, vSphere CLI, ESXCLI) to identify and troubleshoot vSphere problems Identify important vSphere log files and interpret the log file contents Troubleshooting Virtual Networking Analyze and resolve standard switch and distributed switch problems Analyze virtual machine connectivity problems and fix them Examine common management network connectivity problems and restore configurations Troubleshooting Storage Troubleshoot and resolve storage (iSCSI, NFS, and VMware vSphere© VMFS) connectivity and configuration problems Analyze and resolve common VM snapshot problems Identify multipathing-related problems, including common causes of permanent device loss (PDL) and all paths down (APD) events and resolve these problems Troubleshooting vSphere Clusters Identify and recover from problems related to vSphere HA Analyze and resolve VMware vSphere© vMotion© configuration and operational problems Analyze and resolve common VMware vSphere© Distributed Resource Scheduler? problems Troubleshooting Virtual Machines Identify possible causes and resolve virtual machine power-on problems Troubleshoot virtual machine connection state problems Resolve problems seen during VMware Tools? installations Troubleshooting vCenter Server and ESXi Analyze and fix problems with vCenter Server services Analyze and fix vCenter Server database problems Examine ESXi host and vCenter Server failure scenarios and resolve the problems
Are you looking to enhance your Electrician skills? If yes, then you have come to the right place. Our comprehensive course on Electrician will assist you in producing the best possible outcome by mastering the Electrician skills. The Electrician course is for those who want to be successful. In the Electrician course, you will learn the essential knowledge needed to become well versed in Electrician. Our Electrician course starts with the basics of Electrician and gradually progresses towards advanced topics. Therefore, each lesson of this Electrician course is intuitive and easy to understand. Why would you choose the Electrician course from Compliance Central: Lifetime access to Electrician course materials Full tutor support is available from Monday to Friday with the Electrician course Learn Electrician skills at your own pace from the comfort of your home Gain a complete understanding of Electrician course Accessible, informative Electrician learning modules designed by expert instructors Get 24/7 help or advice from our email and live chat teams with the Electrician bundle Study Electrician in your own time through your computer, tablet or mobile device. A 100% learning satisfaction guarantee with your Electrician Course Improve your chance of gaining in demand skills and better earning potential by completing the Electrician Electrician Curriculum Breakdown of the Electrician Course Section 01: Introduction & Getting Started Section 02: Electronic and Electrical maintenance Repair Section 03: Tools Needed Section 04: Electronic Components Section 05: Testing Section 06: Troubleshooting Section 07: Introduction to Electronic Components: A Step by Step Guide CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The Electrician course helps aspiring professionals who want to obtain the knowledge and familiarise themselves with the skillsets to pursue a career in Electrician. It is also great for professionals who are already working in Electrician and want to get promoted at work. Requirements To enrol in this Electrician course, all you need is a basic understanding of the English Language and an internet connection. Career path The Electrician course will enhance your knowledge and improve your confidence in exploring opportunities in various sectors related to Electrician. 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
Course Overview Learn all the essential skills to become an expert in Bridal and Occasional Makeup. From this comprehensive Bridal and Occasional Makeup Artist Masterclass course, you will be able to understand the principles of Bridal and Occasional Makeup. In the step-by-step training process, you will acquire practical skills along with theoretical knowledge. The Qualified professionals will assist you throughout this learning process This Bridal and Occasional Makeup Artist Masterclass is structured to ensure you have all the adequate skills to secure a position in this competitive industry. You will achieve the confidence and competency to bear all the responsibilities of this profession. The course will add all the right credentials to your resume and increase your employability in this growing industry. Who is this course for? Anyone who is now employed in this field or who aspires to be one should take this course. Your knowledge will grow through taking this course, which will also strengthen your resume. To demonstrate your newly gained knowledge, develop crucial abilities and receive a professional credential. 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 you have successfully completed the course, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hardcopy at the cost of £39 or in PDF format at the cost of £24. PDF certificate's turnaround time is 24 hours, and for the hardcopy certificate, it is 3-9 working days. 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; Efficient exam systems for the assessment and instant result; The UK & internationally recognized 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 The Bridal and Occasional Makeup Artist Masterclass course is intended to assist you in obtaining the dream job or maybe the promotion you've always desired. With the assistance and direction of our Bridal and Occasional Makeup Artist Masterclass course, learn the vital abilities and knowledge you require to succeed in your life. Bridal and Occasional Makeup Artist Masterclass Module 01: The Base 00:47:00 Module 02: Eye Makeup 00:50:00 Module 03: Lips, Cheeks and Brows 00:47:00 Module 04: Special Considerations for Weddings and Events 00:20:00 Module 05: Bridal & Special Occasion Makeup as a Business 00:39:00 Assignment Assignment - Bridal and Occasional Makeup Artist Masterclass 00:00:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00
Do you love organising and planning events? Or are you currently working on an Event Planning business? Are you aiming to become a professional planner? If so, then this course will surely help you in improving your event planning and organising skills. Description: If you are having a hard time trying to plan a party? Worry No More! This course will help party organizers create parties that will give individuals the chance to mingle, celebrate and have some fun without worrying about the preparation. This course will guide you on what food you should be getting for the party that will match the event theme at the same time. Also, you will be able to know what activities to conduct and additional planning tips for your event to be successful. Who is the course for? Professionals, business owner or entrepreneurs who have event planning business. People who are interested in party or event planning. 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. Assessment: At the end of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After you have successfully passed the test, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. PDF certificate's turnaround time is 24 hours and for the hard copy certificate, it is 3-9 working days. 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; Efficient exam systems for the assessment and instant result; The UK & internationally recognized 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: Party Planner Course is a useful qualification to possess, and would be beneficial for the following careers: Event Planner Event's Organiser Party Planner. Party Planner Course Food Habits 00:15:00 Get The Theme 00:30:00 Classify Activities 00:30:00 Final Tips 00:30:00 Recipes 00:30:00 Conclusion 00:30:00 Mock Exam Mock Exam- Party Planner Course 00:20:00 Final Exam Final Exam- Party Planner Course 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00
An Introduction to Payroll Accounting Course Description Copyright Ross Maynard 2021 Course Description Welcome to an Introduction to Payroll Accounting. This course provides an overview of payroll accounting. It is aimed at accountants and business managers and owners new to payroll accounting and looking for straightforward coverage of the key elements and features of payroll. In this course we will cover the core elements of payroll; how gross pay is calculated; and issues when dealing with tips and benefits in kind. We’ll also look at tax-exempt deductions and the statutory deductions from pay. We’ll review the main elements of payroll taxation and social security contributions including the terminology used in the United States, Canada and the United Kingdom. And we’ll cover the calculation of Net Pay – that is the amount that the employee actually receives in their bank account. Finally we’ll explore the main journal entries required in the accounts. The principles and structure of payroll accounting are common across many jurisdictions, and the learning in this course applies in many countries of the world. For this reason, the course does not go into the detail of any country-specific legislation or regulations, and does not cover the particular tax rates, tax bands or deduction rates that apply in different jurisdictions. This course provides a grounding in the principles and structure of payroll accounting whatever your country of operation. I hope you enjoy it. Key Learning Points On completion of the course, delegates will be able to: Describe the main components of payroll including allowances, taxes and deductions. Explain the terms Gross Pay, Taxable Pay and Net Pay Identify the statutory taxes and deductions applicable in the United States, Canada and the United Kingdom Complete the main Journal Entries required to process payroll Describe the elements recorded in a Payroll Register Curriculum Lesson 1: First Principles in Payroll Accounting Lesson 2: Getting to Gross Pay Lesson 3: Allowances and Deductions Lesson 4: Income Taxes and Social Security Contributions Lesson 5: The Calculation of Net Pay Lesson 6: Specific Payroll Terminology for the United States, Canada and the United Kingdom Lesson 7: Payroll Journal Entries Lesson 8: Final Thoughts on Payroll Accounting Appendix: The Payroll Register Pre-Course Requirements There are no pre-course requirements Additional Resources None Course Tutor Your tutor is Ross Maynard. Ross is a Fellow of the Chartered Institute of Management Accountants in the UK and has 30 years’ experience as a process improvement consultant specialising in business processes and organisation development. Ross is also a professional author of online training courses. Ross lives in Scotland with his wife, daughter and Cocker Spaniel