1554 A2 courses delivered Online

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  

This course is intended to give you an overview of how the National Food Hygiene Rating Scheme works, what the scoring criteria are and how these are assessed by the inspectors, the appeals process, the Safer Food Better Business management system, E-Coli and concludes with some practical advice for ensuring your premises gets the best score possible.

A short online course led by NICKY SIMPSON, learning how to be creative using Bondaweb.

Are you ready for a total wipe-out of your organization to make way for the growth that comes along with a digital transition? Were you aware that was what a digital transition is? This type of pivot is a huge step for a company and has a lot more to consider than some people think. Do you know what the first step is? You might be surprised. A digital transformation is a catalyst for an organization's growth and future sustainability. Because of its impact on the identity of your organization, it is important to understand that steps to get there. This microlearning video serves as a great starting point. This video is great for anyone involved in strategic planning at your organization. Length: 5:06 Learning Objectives Construct a compelling vision for digital transformation within your organization, illuminating the reasons behind the transition and its role in shaping the future of the company.;Develop a comprehensive digital transformation strategy that assesses current performance, outlines future goals, and identifies how digital technology will facilitate goal achievement, using a well-structured roadmap as a guiding framework.;Cultivate effective change management and communication skills to ensure that all stakeholders, including employees and customers, are engaged, informed, and prepared for the organizational shifts that accompany a digital transformation.

A personal shopping experience with a professional dog trainer and behaviourist plus a deep dive interview with a qualified nutritionist! Take the hassle out of shopping for food, toys, chews and toys and learn to shop for dog products like a pro Course curriculum 1 Dog Food & Nutrition A Brief History of Dog Food, The Power of Advertising The History of Nutrition Dog Food: A Nutritionists perspective with Alison Daniel 2 Chewing Behaviour Choose Chews Rawhide Chews Natural Chews Alternative Chews Chewing Behaviour 3 Toys & Training Products! Dog Toys Training Products

COMPUTER AIDED DESIGN + NICKY SIMPSON ONLINE ON-DEMAND FEES: FULL COURSE £35 WHAT THE COURSE IS ABOUT: A great short course, led by textile artist NICKY SIMPSON. This course introduces you to repeat patterning using PowerPoint, with video tutorials and comprehensive step-by-step guides. Whether you are using this in school, wanting to print for fashion or furnishing, or simply printing a T-shirt, this is a great way to get your own artwork or photographs into a repeat pattern for printing. It can also be used to print on paper for cards or letters and much more. This course shows how you can easily do repeat pattern designs, layering designs, inserting your designs into shapes and fashion illustration, with lots of exemplars and some inspirational designers. WHO IS THIS COURSE FOR: This course is suitable for anyone. You may be a teacher wanting to up-skill, a student who wants to further your current knowledge, or anyone who would like to be more creative with very limited equipment! All these tutorials can be used directly with students in schools. WHAT TO EXPECT: This comprehensive course offers a series of 6 short video tutorials, where you can practice alongside Nicky, working in your own time, at your own pace. Each video can be paused and rewound, using step-by-step guides.  Introduction: Welcome to the training room Video Tutorial 1: How to use the Picture Format Tool Bar Video Tutorial 2: Creating Repeat Patterns Video Tutorial 3: CAD from your own primary images Video Tutorial 4: Layering images Video Tutorial 5: Inserting Your Repeat Patterns Into Shapes Video Tutorial 6: Fashion Illustration PDF: Designers & Exemplars LEARNING OUTCOMES: Learn and practice a new and exciting skill. Develop confidence and enhance your IT skills with free tools! Create exciting repeat patterns that can be used for fashion, interiors or stationary. A creative activity to get your own photographs into a repeat pattern ready for printing.

Babysitting: Babysitting Course Online This Babysitting: Babysitting Course is perfect for students who want to enhance their understanding of babysitting and aspire to achieve a career in a daycare centre, nursery or pre-school setting. This qualification provides a thorough understanding of the skills required for Babysitting: Babysitting Course. It includes the babysitter's responsibilities to the children they care for and their responsibilities to the parents, accident prevention, and fire safety. This Babysitting: Babysitting Course is the perfect way to kickstart your career in the childcare industry. Enrol today and take the next step towards your personal and professional goals. Special Offers of this Babysitting: Babysitting Course This Babysitting: Babysitting Course includes a FREE PDF Certificate. Lifetime access to this Babysitting: Babysitting Course Instant access to this Babysitting: Babysitting Course Get FREE Tutor Support from Monday to Friday in this Babysitting: Babysitting Course Main Course: Level 2 Award in Babysitting Course Courses with Babysitting: Babysitting Course Course 01: Advanced Diploma in Childcare Course 02: Negotiation Skills Course 03: Communication Skills Course 04: Child and Adolescent Mental Health Course [ Note: Free PDF certificate as soon as completing the Babysitting: Babysitting Course ] Babysitting: Babysitting Course Online Industry Experts Designed this Safeguarding and Prevent: Safeguarding and Prevent Course into 04 detailed modules. Course Curriculum of Level 2 Award in Babysitting Course Module 01: Accident Prevention and Fire Safety When Babysitting Module 02: Caring for Young Children in a Babysitting Environment Module 03: Craft Activities with Young Children Module 04: Respecting and Valuing Children Assessment Method of Babysitting: Babysitting Course After completing each module of the Babysitting: Babysitting Course, you will find automated MCQ quizzes. To unlock the next module, you need to complete the quiz task and get at least 60% marks. Once you complete all the modules in this manner, you will be qualified to request your certification. Certification of Babysitting: Babysitting Course After completing the MCQ/Assignment assessment for Babysitting: Babysitting 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? Babysitting: Babysitting Course Online This Babysitting: Babysitting Course is perfect for anyone who interested in learning about babysitting. Furthermore, if you work in any of the following fields, you must complete this Babysitting: Babysitting Course. Special Note: Our Babysitting: Babysitting Course is knowledge Based course. If You want to get qualified, you can consider following options: Level 2 Award in Babysitting (RQF) Requirements Babysitting: Babysitting Course Online Students who intend to enrol in this Babysitting: Babysitting Course must meet the following requirements: Babysitting: Good command of the English language Babysitting: Must be vivacious and self-driven Babysitting: Basic computer knowledge Babysitting: A minimum of 16 years of age is required Career path Babysitting: Babysitting Course Online This Babysitting: Babysitting Course will help you get the job you want in the relevant field. Regardless of your current job status and also the course will advance your career. Certificates Certificate of completion Digital certificate - Included

Each year, people are killed, injured, or suffer work-related illnesses while carrying out their jobs in the United Kingdom. As a result, health and safety is a major concern. The government, employers, and workers all have an important role in minimizing workplace fatalities and accidents and preventing health-related illnesses at work. The Health and Safety : Health and Safety in a Construction Environment - Level 1qualification covers an introduction to the legal aspects of health and safety before moving on to the fundamentals of risk assessment and safe working practices. It then goes into detail to cover the most common hazards encountered in construction sites, such as working at heights and respiratory hazards, as well as electrical and chemical hazards. Learning Outcomes After completing Health and Safety: Health and Safety in a Construction Environment - Level 1 course, the learner will be able to: Understand the legal aspects of health and safety in construction. Assess the safety of a workplace and conduct a health & safety risk assessment. Understand the importance of safe manual handling in the workplace. Gain a solid understanding of risks to health within a construction environment. Understand the importance of working around plants and equipment safely. Why Choose Health and Safety: Health and Safety in a Construction Environment - Level 1 Course from Us Self-paced course, access available from anywhere. Easy to understand, high-quality study materials. Health & Safety in a Construction Environment 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 this course. ***Others benefits of this Health and Safety in a Construction Environment course*** Free One PDF Certificate Lifetime Access Free Retake Exam Tutor Support [ Note: Free PDF certificate as soon as completing the Health and Safety: Health and Safety in a Construction Environment - Level 1 course] Detailed Course Curriculum of *** Health and Safety in a Construction Environment *** Module 01: Health and Safety in a Construction Environment Know the principles of risk assessment for maintaining and improving health and safety at work Know the importance of safe manual handling in the workplace Know the importance of working safely at height in the workplace Know risks to health within a construction environment Know the importance of working around plant and equipment safely Assessment Method After completing each module of the Health and Safety: Health and Safety in a Construction Environment - Level 1 Course, you will find automated MCQ quizzes. To unlock the next module, you need to complete the quiz task and get at least 60% marks. Certification After completing the MCQ/Assignment assessment for this Health and Safety: Health and Safety in a Construction Environment - Level 1 course, you will be entitled to a Certificate of Completion from Training Tale. 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 Health and Safety: Health and Safety in a Construction Environment - Level 1 course is designed for those who work on construction sites. Requirements There are no specific requirements for Health & Safety in a Construction Environment course because it does not require any advanced knowledge or skills. Career path Working in Construction Sites Certificates Certificate of completion Digital certificate - Included

Unleash your entrepreneurial spirit with our comprehensive course 'From Idea to Enterprise: A Guide to Entrepreneurship and Start-Up Success'. This course is designed to guide you on your journey from concept to business, providing the tools, techniques, and insights you need to transform your innovative ideas into a successful enterprise. You will learn how to generate business ideas, recognise opportunities, develop strategic business plans, and perform insightful market analyses. The course covers financial planning, legalities of business structure, sales, marketing, branding, operational management, and leadership. Finally, it addresses the challenges of entrepreneurship, the importance of sustainability, and the power of networking and mentoring. Learning Outcomes Understand the fundamentals of entrepreneurship and identify business opportunities. Develop strategic business plans and perform market analyses. Manage financial planning and understand the legalities of business structure. Apply effective techniques in sales, marketing, and branding. Understand the importance of sustainability, networking, and mentoring in entrepreneurship. Why choose this From Idea to Enterprise: A Guide to Entrepreneurship and Start-Up Success course? Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards and CIQ after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the 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. Unlock career resources for CV improvement, interview readiness, and job success. Who is this From Idea to Enterprise: A Guide to Entrepreneurship and Start-Up Success course for? Aspiring entrepreneurs looking to launch their own business. Business owners seeking to refine their entrepreneurial skills. Students studying business, management, or related disciplines. Professionals considering a career change into entrepreneurship. Individuals interested in understanding the mechanics of starting a business.. Career path Entrepreneur: £30,000 - £100,000+ Business Consultant: £30,000 - £60,000 Business Development Manager: £30,000 - £55,000 Start-up Founder: £20,000 - £90,000+ Marketing Manager: £25,000 - £50,000 Operational Manager: £30,000 - £55,000 Prerequisites This From Idea to Enterprise: A Guide to Entrepreneurship and Start-Up Success does not require you to have any prior qualifications or experience. You can just enrol and start learning.This From Idea to Enterprise: A Guide to Entrepreneurship and Start-Up Success 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 Module 01: Introduction to Entrepreneurship Introduction to Entrepreneurship 00:26:00 Module 02: Idea Generation and Opportunity Recognition Idea Generation and Opportunity Recognition 00:20:00 Module 03: Business Planning and Strategy Development Business Planning and Strategy Development 00:22:00 Module 04: Market Analysis and Customer Insights Market Analysis and Customer Insights 00:23:00 Module 05: Financial Planning and Management Financial Planning and Management 00:22:00 Module 06: Legalities and Business Structure Legalities and Business Structure 00:25:00 Module 07: Sales, Marketing, and Branding Sales, Marketing, and Branding 00:23:00 Module 08: Operational Management and Logistics Operational Management and Logistics 00:25:00 Module 09: Team Building and Leadership Team Building and Leadership 00:24:00 Module 10: Challenges, Risks, and Crisis Management Challenges, Risks, and Crisis Management 00:24:00 Module 11: Digital Tools and Resources for Entrepreneurs Digital Tools and Resources for Entrepreneurs 00:25:00 Module 12: Sustainability and Social Entrepreneurship Sustainability and Social Entrepreneurship 00:25:00 Module 13: Networking, Mentoring, and Growth Networking, Mentoring, and Growth 00:22:00

Dive into the world of construction safety with our course, 'Health and Safety in a Construction Environment - Route to CSCS Green Card.' This course is your straightforward guide to understanding the essentials of safety on a construction site. It kicks off with an easy-to-grasp introduction to health and safety protocols, providing you with the basics you need to start. You'll learn not just the theory but also how these rules apply in real-life construction settings. Moving through the course, you'll cover everything from recognizing hazards and managing risks to handling materials and machinery safely. Each module, like dealing with Slips, Trips, and Falls, or understanding the risks associated with Plant and Machinery, is packed with practical tips and important knowledge. The course doesn't just cover the heavy stuff; it also includes vital topics like Respiratory Risks and Worksite Hygiene, ensuring you know how to keep yourself and others safe in various situations. By the end, topics like Fire, Electricity, and Gas Safety, and the right way to use Personal Protective Equipment (PPE) will become part of your everyday safety toolkit. Learning Outcomes Gain a solid foundation in construction site health and safety protocols. Identify and manage potential hazards and risks on site. Understand and implement safety measures for working at height and manual handling. Learn to operate machinery and equipment safely. Get to grips with essential emergency procedures and personal safety practices. Why choose this Health and Safety in a Construction Environment - Route to CSCS Green Card course? Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards and CIQ after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the 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. Unlock career resources for CV improvement, interview readiness, and job success. Who is this Health and Safety in a Construction Environment - Route to CSCS Green Card course for? Construction workers looking to get their CSCS Green Card. New entrants in the construction industry needing essential safety training. Site supervisors who want to update their safety knowledge. Professionals in charge of overseeing construction site safety. Anyone in the construction field wanting to ensure a safe working environment. Career path Construction Site Supervisor: £30,000 - £50,000 Health and Safety Officer: £25,000 - £40,000 Site Manager: £35,000 - £55,000 Safety Consultant: £30,000 - £50,000 Project Manager (Construction): £40,000 - £70,000 Facilities Manager: £28,000 - £45,000 Prerequisites This Health and Safety in a Construction Environment - Route to CSCS Green Card does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Health and Safety in a Construction Environment - Route to CSCS Green Card 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 Introduction to the Course Introduction to the Course 00:02:00 Module 01: Introduction to the Health and Safety Protocols at a Construction Site Introduction to the Health and Safety Protocols at a Construction Site 00:20:00 Module 02: Hazards, Risks, Assessment and Controls Hazards, Risks, Assessment and Controls 00:14:00 Module 03: Slips, Trips, Falls and Working at Height Slips, Trips, Falls and Working at Height 00:24:00 Module 04: Manual Handling Manual Handling 00:14:00 Module 05: Plant and Machinery Plant and Machinery 00:20:00 Module 06: Respiratory Risks Respiratory Risks 00:12:00 Module 07: Fire, Electricity and Gas Safety Fire, Electricity and Gas Safety 00:16:00 Module 08: Chemical Hazard and Worksite Hygiene Chemical Hazard and Worksite Hygiene 00:14:00 Module 09: Vehicles, PPE and General Safety Vehicles, PPE and General Safety 00:22:00