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

4074 Engineer courses

Cost and Management Accounting

By NextGen Learning

Ignite your dynamic career and strengthen your deep insight knowledge by signing up for Cost and Management Accounting. This Cost and Management Accounting is the ideal approach for you to obtain a thorough understanding and knowledge of the subject. We are concerned about the progression of your career. Therefore, after conducting extensive studies and consulting with experienced personnel, we formulated this outstanding course to improve your pertinent skills. In this easy-to-digest Cost and Management Accounting course, you will get exclusive training, which will enable you to stand out in this competitive market. However, the Cost and Management Accounting course covers all of the recent materials in order to keep you up to date with the job market and make you a good fit for your career. This top-notch course curriculum comprises basic to advanced levels of modules that will increase your skillsets. After completing this Programme, you will attain the productivity to succeed in your organisation. So, if you are eager to see yourself in a gratifying career, then enrol in our course today! What will make you stand out? On completion of this online course, you will gain: CPD QS Accredited After successfully completing the Course, you will receive a FREE PDF Certificate as evidence of your newly acquired abilities. Lifetime access to the whole collection of learning materials. The online test with immediate results You can study and complete the course at your own pace. Study for the course using any internet-connected device, such as a computer, tablet, or mobile device. The substantial Cost and Management Accounting is designed to help you demonstrate the preliminary to in-depth level of learning regarding this topic. Moreover, you will be provided with the most knowledgeable and informative modules for your lifetime by enrolling in this course just once. Furthermore, as you proceed through the modules of this course, you will discover the fundamentals of Cost and Management Accounting and explore the key topics such as: Cost and Management Accounting Introduction & Fundamentals Introduction and Fundamental Terms Fundamental terms - Perishable / Non Perishable cost, Inventory Terms Qualities of Good Cost Controller Cost Control process Cost Control Process and Controls related to Purchasing How to estimate Kitchen food Order Process Simplified How to Setup Store PAR for to identify re-order levels Basic Receiving Process Controls Basic Store Process controls Production Control and Tests Production Controls Recipe Card & Controls Buffet Costing and Menu Pricing Test and Checks in Cost Control Butcher test Bar Spot Checks and Recipe Testing Production Control Via Menu Engineering Slow and Non Moving Inventory Monitoring via reports and Checklist Daily & Monthly Food Cost Reports Menu Engineering Reports Cost Control Checklist Therefore, reinforce your knowledge and furnish your skills by enrolling in our course. Take one step closer to achieving your goal. Show off your new skills with a certificate of completion Once you complete the Cost and Management Accounting 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 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Is This Cost and Management Accounting Course the Right Option for You? This course is recommended for anyone who is interested in learning more about this topic. You'll learn the fundamental ideas and gain a comprehensive understanding of the topic by taking this Cost and Management Accounting course. Requirements Without any formal requirements, you can delightfully enrol in this course. Career path The aim of this exclusive Cost and Management Accounting course is to help you toward your dream career. So, complete this course and enhance your skills to explore opportunities in relevant areas.

Cost and Management Accounting
Delivered Online On Demand2 hours
£12

Wood Burning Process for Heating System

By iStudy UK

Do you want to learn how to use the wood burning instruments accurately? Do you want to develop the technique that will help you burn wood without creating much pollution? If yes, then this course is for you. If you warm with wood now or you are thinking about the utilizing of wood fuel for home warming, this course is for you. Heating with wood can be challenging as the result of the physical requests included. Unique information and skills are required to utilize this hands-on home warming choice effectively. In this course you will explore the practical ways of heating with wood ensuring your wood-heat system is safe. You will likewise discover helpful tips on step by step instructions to operate and maintain it properly. Course Highlights Wood Burning Process for Heating System 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 Wood Burning Process for Heating System into 25 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 1 day, 3 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 Wood Burning Process for Heating System 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? Wood Burning Process for Heating System 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 Wood Burning Process for Heating System 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. The Woodburner's Guide: Practical Ways of Heating with Wood 02:00:00 Wood Burning Stoves and Portable Fireplaces 02:00:00 How to find fireplaces and wood burning stoves 01:00:00 Wood Burning Stoves and Fireplaces Safety 01:00:00 Wood Burning Stoves and EPA Approved Fireplaces 00:30:00 Fireplaces and Wood Burning Stoves 02:00:00 How to Maintenance First in Wood Burning Stoves and Fireplaces 01:00:00 Direct Fireplaces and Wood Burning Stoves 01:00:00 Wood Burning Stoves and Fireplaces Tested and Approved 02:00:00 Wood Burning Stoves and Western Fireplaces 01:00:00 Wood Burning Stoves and Georgian Fireplaces 01:00:00 Warming up to Wood Burning Stoves and Fireplaces 02:00:00 Wood Burning Stoves and Fireplaces Safety Upheld Safety in Wood Burners 01:00:00 Victorian Wood Burning Stoves and Fireplaces 01:00:00 Wood EPA Burning Stoves and Fireplaces 00:30:00 WOOD BURNING STOVES AND FIRE PLACES 02:00:00 How many types of fireplaces are there? 01:00:00 Harman Cast Iron Woodstove and Fireplace 01:00:00 Enhancements in WOOD BURNING STOVES AND FIRE PLACES 00:15:00 Safer WOOD BURNING STOVES AND FIRE PLACES 02:00:00 Concepts in Wood Burning Stoves and Fireplaces 00:15:00 Choosing what wood burning stoves and fireplaces to purchase 00:30:00 Preparing Your Home for Your New Wood-Burning Fireplace or Stove 00:30:00 Remodeling your wood-burning fireplace or stove 00:30:00 Conclusion 00:15:00 Mock Exam Mock Exam- Wood Burning Process for Heating System 00:20:00 Final Exam Final Exam- Wood Burning Process for Heating System 00:20:00

Wood Burning Process for Heating System
Delivered Online On Demand27 hours
£25

Renewable Energy: Solar

By IOMH - Institute of Mental Health

Join our Renewable Energy: Solar course and discover your hidden skills, setting you on a path to success in this area. Get ready to improve your skills and achieve your biggest goals. The Renewable Energy: Solar course has everything you need to get a great start in this sector. Improving and moving forward is key to getting ahead personally. The Renewable Energy: Solar course is designed to teach you the important stuff quickly and well, helping you to get off to a great start in the field. So, what are you looking for? Enrol now! You will Learn The Following Things: Learn strategies to boost your workplace efficiency. Hone your skills to help you advance your career. Acquire a comprehensive understanding of various topics and tips. Learn in-demand skills that are in high demand among UK employers This course covers the topic you must know to stand against the tough competition. The future is truly yours to seize with this Renewable Energy: Solar. Enrol today and complete the course to achieve a certificate that can change your career forever. Details Perks of Learning with IOMH One-to-one support from a dedicated tutor throughout your course. Study online - whenever and wherever you want. Instant Digital/ PDF certificate 100% money back guarantee 12 months access Process of Evaluation After studying the course, an MCQ exam or assignment will test your skills and knowledge. You have to get a score of 60% to pass the test and get your certificate. Certificate of Achievement After completing the Renewable Energy: Solar course, you will receive your CPD-accredited Digital/PDF Certificate for £5.99. To get the hardcopy certificate for £12.99, you must also pay the shipping charge of just £3.99 (UK) and £10.99 (International). Who Is This Course for? This Renewable Energy: Solar is suitable for anyone aspiring to start a career in relevant field; even if you are new to this and have no prior knowledge, this course is going to be very easy for you to understand.  On the other hand, if you are already working in this sector, this course will be a great source of knowledge for you to improve your existing skills and take them to the next level.  This course has been developed with maximum flexibility and accessibility, making it ideal for people who don't have the time to devote to traditional education. Requirements There is no prerequisite to enrol in this course. You don't need any educational qualification or experience to enrol in the Renewable Energy: Solar course. Do note: you must be at least 16 years old to enrol. Any internet-connected device, such as a computer, tablet, or smartphone, can access this online course. Career Path The certification and skills you get from this Renewable Energy: Solar Course can help you advance your career and gain expertise in several fields, allowing you to apply for high-paying jobs in related sectors. Course Curriculum Unit 1- Basics of Solar Energy System Module 1- Introduction To PV System Construction 00:24:00 Module 2- Solar Heating, Solar Irradiation And Panels 00:38:00 Module 3- Effect of Insolation and Temperature on V-I Curve 00:05:00 Module 4- PV Installation, Short Circuit And Open Circuit Tests Using Avometer 00:15:00 Module 5- Solar Wires And Cables Installation Process 00:22:00 Module 6- Mounting Of PV System 00:04:00 Module 7- Shading and Tilt angle In Solar Energy 00:15:00 Module 8- Half Cut Cell Technology In PV System For Solar Engineering 00:25:00 Module 9- Importance Of Charge Controller In Solar Energy System 00:03:00 Module 10- PWM And MPPT Charge Controllers 00:14:00 Module 11- Understanding More about MPPT Solar Charge Controller For Solar Energy Course 00:24:00 Module 12- Junction Box In Solar Energy System 00:04:00 Module 13- Wiring of Junction Box In Solar Energy System 00:05:00 Module 14- Function, Types And Data Sheet Of Inverter 00:55:00 Module 15- Determining PV Array Maximum System Voltage 00:09:00 Unit 2- Batteries in PV System Module 1- Construction And Types Of Batteries In Solar Energy System 00:09:00 Module 2- Charging Of Lead Acid Batteries And Hydrometer In Solar Energy System 00:07:00 Module 3- Maintenance Of Batteries And Methods Of Charging In Solar Energy System 00:03:00 Module 4- Cycle of Batteries 00:04:00 Unit 3- Components and Design of Off Grid Solar Energy System Module 1- Off-Grid Solar System 00:02:00 Module 2- Advantages of Off-Grid Solar System 00:02:00 Module 3- Equipment of Off-Grid Solar System 00:04:00 Module 4- Selection and Datasheet of the Panel 00:04:00 Module 5- Inverter Selection 00:02:00 Module 6- Example 1 On Designing Off Grid System 00:01:00 Module 7- Determine Power Consumption Demands 00:04:00 Module 8- Size the PV modules 00:05:00 Module 9- Inverter sizing 00:04:00 Module 10- Battery Sizing 00:08:00 Module 11- Solar Charge Controller Sizing 00:05:00 Module 12- MPPT Charge Controller Sizing 00:10:00 Module 13- Example 2 Design of an OFF Grid System 00:20:00 Unit 4- Designing of ON Grid Solar Energy System Module 1- Grid-Tied Solar System 00:03:00 Module 2- Advantages of Grid-Tied Solar System 00:04:00 Module 3- Equipment of Grid-Tied Solar System 00:03:00 Module 4- Example Design of an On Grid System 00:10:00 Module 5- PV Energy According to Area 00:02:00 Unit 5- Design of PV System Using PVSyst Programme Module 1- Design of an Off Grid Solar Energy System Using PVSYST Program 00:28:00 Module 2- Design Of An On Grid Solar Energy System Using PVSyst Program 00:12:00 Module 3- Mega PV System Design Using PVSyst Program For Solar Energy 00:29:00 Unit 6- Solar Water Pumping System Module 1- Introduction To Water Pumping System And Steps Of Design 00:24:00 Module 2- Solved Example On Solar Pumping System Design 00:23:00 Unit 7- Protection of PV System Module 1- Introduction to Protection Of PV System 00:07:00 Module 2- Selection of Fuses and Protection of String 00:13:00 Module 3- Protection of Arrays 00:07:00 Module 4- Protection of Inverter 00:07:00 Module 5- Protection of Transformer 00:07:00 Module 6- Surge Protection Device 00:02:00 Module 7- Grounding of PV System 00:07:00 Module 8- Types of BusBars in PV System and Selection of BusBars 00:12:00 Unit 8- Design Using Excel Sheet Module 1-Design Of Off Grid PV System Using Excel Sheet 00:26:00 Unit 9- Single Line Diagram of PV System Module 1- Single Line Diagram Of PV System And Selection Of Fuses And Breakers 00:45:00 Unit 10- MATLAB and ETAP PV Simulation Module 1- Simulation Of PV Cell In MATLAB And Obtaining V-I Characteristics 00:28:00 Module 2- Get a Complete Grid Connected PV Solar Energy System In MATLAB Simulink 00:25:00 Module 3- PV System Simulation Using ETAP Lesson 00:24:00

Renewable Energy: Solar
Delivered Online On Demand11 hours 44 minutes
£11.99

Overview This Biotechnology course will unlock your full potential and will show you how to excel in a career in Biotechnology. So upskill now and reach your full potential. Everything you need to get started in Biotechnology is available in this course. Learning and progressing are the hallmarks of personal development. This Biotechnology will quickly teach you the must-have skills needed to start in the relevant industry. In This Mental Health Course, You Will: Learn strategies to boost your workplace efficiency. Hone your Mental Health skills to help you advance your career. Acquire a comprehensive understanding of various Mental Health topics and tips from industry experts. Learn in-demand Mental Health skills that are in high demand among UK employers, which will help you to kickstart your career. This Biotechnology course covers everything you must know to stand against the tough competition in the Biotechnology field.  The future is truly yours to seize with this Biotechnology. Enrol today and complete the course to achieve a Biotechnology certificate that can change your professional career forever. Additional Perks of Buying a Course From Institute of Mental Health Study online - whenever and wherever you want. One-to-one support from a dedicated tutor throughout your course. Certificate immediately upon course completion 100% Money back guarantee Exclusive discounts on your next course purchase from Institute of Mental Health Enrolling in the Biotechnology course can assist you in getting into your desired career quicker than you ever imagined. So without further ado, start now. Process of Evaluation After studying the Biotechnology course, your skills and knowledge will be tested with a MCQ exam or assignment. You must get a score of 60% to pass the test and get your certificate.  Certificate of Achievement Upon successfully completing the Biotechnology course, you will get your CPD accredited digital certificate immediately. And you can also claim the hardcopy certificate completely free of charge. All you have to do is pay a shipping charge of just £3.99. Who Is This Course for? This Biotechnology is suitable for anyone aspiring to start a career in Biotechnology; even if you are new to this and have no prior knowledge on Biotechnology, this course is going to be very easy for you to understand.  And if you are already working in the Biotechnology field, this course will be a great source of knowledge for you to improve your existing skills and take them to the next level.  Taking this Biotechnology course is a win-win for you in all aspects.  This course has been developed with maximum flexibility and accessibility, making it ideal for people who don't have the time to devote to traditional education. Requirements This Biotechnology course has no prerequisite.  You don't need any educational qualification or experience to enrol in the Biotechnology course. Do note: you must be at least 16 years old to enrol. Any internet-connected device, such as a computer, tablet, or smartphone, can access this online Biotechnology course. Moreover, this course allows you to learn at your own pace while developing transferable and marketable skills. Course Curriculum Module 1 - Introduction to Biotechnology Introduction to Biotechnology 00:19:00 Module 2- Biotechnology in the Realm of History Biotechnology in the Realm of History 00:27:00 Module 3- Molecular and Cellular Biology Molecular and Cellular Biology 00:27:00 Module 4 - Biotechnology Versus Molecular Biology Biotechnology Versus Molecular Biology 00:11:00 Module 5- Genetic Engineering Genetic Engineering 00:16:00 Module 6- Biotechnology in Health Sector Biotechnology in Health Sector 00:11:00 Module 7- Industrial Biotechnology Industrial Biotechnology 00:14:00 Module 8- Biotechnology in a Business Perspective Biotechnology in a Business Perspective 00:13:00 Assignment Assignment - Biotechnology and Molecular Biology 00:00:00

Biotechnology
Delivered Online On Demand2 hours 18 minutes
£11

Heating, Ventilation & Air Conditioning (HVAC) Technician Part - 2

By iStudy UK

Course Description Get instant knowledge from this bite-sized Heating, Ventilation & Air Conditioning (HVAC) Technician Part - 2 course. This course is very short and you can complete it within a very short time. In this Heating, Ventilation & Air Conditioning (HVAC) Technician Part - 2 course you will get fundamental ideas of heating, ventilation and air conditioning, the key understanding of compressors, water chillers and so on. Enrol in this course today and start your instant first step towards learning about air conditioning systems. Learn faster for instant implementation. Learning Outcome Familiarise with air conditioning systems Understand compressors, water chillers, and fans Gain in-depth knowledge of the piping Understand the duct system in HVAC How Much Do HVAC Technicians Earn? Senior - £60,000 (Apprx.) Average - £39,000 (Apprx.) Starting - £25,000 (Apprx.) Requirement Our Heating, Ventilation & Air Conditioning (HVAC) Technician Part - 2 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. Heating, Ventilation & Air Conditioning (HVAC) Technician Part - 2 Module 01: Air Conditioning Systems for HVAC Technicians 00:22:00 Module 02: Compressors, Water Chillers, and Fans 00:25:00 Module 03: Piping for HVAC Technician 00:20:00 Module 04: Duct System in HVAC 00:28:00 Assignment Assignment - Heating, Ventilation & Air Conditioning (HVAC) Technician Part - 2 00:00:00

Heating, Ventilation & Air Conditioning (HVAC) Technician Part - 2
Delivered Online On Demand1 hour 35 minutes
£25

Advanced Construction Management Diploma

By Compliance Central

Discover the key skills and resources required to remain current and innovative in the field of construction management. This Advanced Construction Management Diploma course will make it easier for you to prepare for success in the construction industry by arming you with the knowledge you need. You will get important insights into the topic of construction management through this Advanced Construction Management Diploma course, including information on project success and life cycles, cost control, site research, site organisation, and site administration. Additionally, you will gain knowledge in managing equipment, managing supplies, and conducting vendor assessments. You will gain knowledge about managing value, risk, and people. You will also discover the significance of preserving health and safety in construction management, among other topics. If you have a strong general interest in architecture and design, as well as the ability to take the lead on large projects from start to finish, construction management is the perfect career for you. This Advanced Construction Management Diploma course is for you if you're a seasoned construction industry professional wishing to transfer professions or a brand-new construction manager attempting to get your bearings. Learning outcome After completing this Advanced Construction Management Diploma course, you will: Find out about construction management. Gain an understanding of the success of projects and their life cycles. Become aware of cost management. Familiarise yourself with preliminary site investigation, site organisation, and site management. Learn about planning and managing construction materials, managing equipment, and doing vendor analyses. Get knowledge about the procurement process for construction. Discover how to manage supply chains and inventory. Identify who the main participants are. Recognise quality control and customer service. Know about the legal elements of contracts Understanding risk, value, and human resource management Gain knowledge about construction communications, information, and documentation Comprehend the significance of health and safety in construction management. Are you prepared to advance your career in the construction management field? Then enrol right away in our Advanced Construction Management Diploma course! Along with this course, 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. 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. ***Advanced Construction Management Diploma*** Module 01: Introduction Module 02: Project Life Cycle and Success Module 03: Cost Management Module 04: Preliminary Site Investigation and Site Organisation Module 05: Site Management Module 06: Planning and Management of Equipment Module 07: Materials Management Module 08: Vendor Analysis Module 09: Procurement Module 10: Stock Control Module 11: Supply Chain Management Module 12: The Main Participators Module 13: Quality Assurance and Customer Care Module 14: Legal Aspects of Contracting Module 15: Human Resources Management Module 16: Risk and Value Management Module 17: Communications, Information and Documentation Module 18: Health and Safety CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone with a passion for the industry Employees in the industry Engineers Owners/clients of projects Contractors Requirements To enrol in this Advanced Construction Management Diploma course, all you need is a basic understanding of the English Language and an internet connection. Career path Construction Manager - Salary: £27,000 to £65,000Plant hire adviser - Salary: £19,000 to £30,000Contracts manager - Salary: £25,000 to £60,000Plant operator - Salary: £19,000 to £36,000Site supervisor - Salary: £25,000 to £45,000Engineering technician - Salary: £19,000 to £36,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

Advanced Construction Management Diploma
Delivered Online On Demand7 days
£12

Power Query and Power Pivot in Microsoft Excel: A Quickstart Guide

By Ideas Into Action

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  

Power Query and Power Pivot in Microsoft Excel: 
A Quickstart Guide
Delivered Online On Demand
£9.99

CompTIA Security+ Certification Training Advanced Diploma

3.0(2)

By Alpha Academy

The CompTIA Security+ (SY0-401) certification course provides information about the corporate security which is recognised as one of the fastest-growing fields in IT. Every institution even small business invests in IT security to secure their confidential data. The course covers the security fundamentals including the information security cycle, information security controls, authentication methods, cryptography fundamentals, and security policy fundamentals. Throughout the course, you will learn the Security Threats and vulnerabilities, Managing data, Application and Host Security, and the system of implementing Networking Security, implementing access control, authentication and Account Management, and implementing Compliance and Operating Security. Finally, the course will teach you how to manage certificates, how to manage risk, how to troubleshoot and manage security incidents, and the proper Business Continuity and Disaster Recovery Planning. In short, the course helps you to acquire competency in network infrastructure, system security, organizational security and access control. Course Highlights The price is for the whole course including final exam - no hidden fees Accredited Certificate upon successful completion Efficient exam system with instant results Track progress within own personal learning portal 24/7 customer support via live chat 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 CompTIA Security+ Certification Training Advanced Diploma 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 accredited qualification. 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 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 £30,000. The sky really is the limit. Course Curriculum Security Fundamentals The Information Security Cycle 00:37:00 Information Security Controls 00:35:00 Authentication Methods 00:09:00 Cryptography Fundamentals 00:56:00 Security Policy Fundamentals 00:11:00 Identifying Security Threats and Vulnerabilities Social Engineering 00:31:00 Malware 00:25:00 Software-Based Threats 00:21:00 Based Threats 00:38:00 Wireless Threats and Vulnerabilities 00:43:00 Physical Threats and Vulnerabilities 00:09:00 Managing Data, Application, and Host Security Manage Data Security 00:47:00 Manage Application Security 00:56:00 Manage Device and Host Security 01:07:00 Manage Mobile Security 00:10:00 Implementing Network Security Configure Security Parameters on Network Devices and Technologies 00:49:00 Network Design Elements and Components 00:26:00 Implement Networking Protocols and Services 01:09:00 Apply Secure Network Administration Principles 00:12:00 Secure Wireless Traffic 00:31:00 Implementing Access Control, Authentication, and Account Management Access Control and Authentication Services 00:42:00 Implement Account Management Security Controls 00:33:00 Managing Certificates Install a CA Hierarchy 00:25:00 Enroll Certificates 00:13:00 Secure Network Traffic by Using Certificates 00:03:00 Renew Certificates 00:01:00 Back Up and Restore Certificates and Private Keys 00:05:00 Revoke Certificates 00:07:00 Implementing Compliance and Operational Security Physical Security 00:20:00 Legal Compliance 00:10:00 Security Awareness and Training 00:11:00 Integrate Systems and Data with Third Parties 00:08:00 Risk Management A Risk Analysis 00:17:00 Implement Vulnerability Assessment Tools and Techniques 00:04:00 Scan for Vulnerabilities 00:27:00 Mitigation and Deterrent Techniques 00:19:00 Troubleshooting and Managing Security Incidents Respond to Security Incidents 00:23:00 Recover from a Security Incident 00:09:00 Business Continuity and Disaster Recovery Planning Business Continuity 00:17:00 Plan for Disaster Recovery 00:17:00 Execute DRPs and Procedures 00:13:00 Mock Exam Mock Exam- CompTIA Security+ Certification - Complete Video Course 00:20:00 Final Exam Final Exam- CompTIA Security+ Certification - Complete Video Course 00:20:00

CompTIA Security+ Certification Training Advanced Diploma
Delivered Online On Demand
£10.99

Heating, Ventilation & Air Conditioning (HVAC) Technician Part - 1

By iStudy UK

Course Description Get instant knowledge from this bite-sized Heating, Ventilation & Air Conditioning (HVAC) Technician Part - 1 course. This course is very short and you can complete it within a very short time. In this Heating, Ventilation & Air Conditioning (HVAC) Technician Part - 1 course you will get fundamental ideas of heating, ventilation and air conditioning, the key understanding of heating fundamentals, psychrometrics and so on. Enrol in this course today and start your instant first step towards learning about heating, ventilation and air conditioning (HVAC). Learn faster for instant implementation. Learning Outcome Familiarise with heating, ventilation and air conditioning (HVAC) Understand heating fundamentals and psychrometrics Gain in-depth knowledge of the HVAC Systems Deepen your understanding of heating and ventilation How Much Do HVAC Technicians Earn? Senior - £60,000 (Apprx.) Average - £39,000 (Apprx.) Starting - £25,000 (Apprx.) Requirement Our Heating, Ventilation & Air Conditioning (HVAC) Technician Part - 1 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. Heating, Ventilation & Air Conditioning (HVAC) Technician Part - 1 Module 01: Introduction to Heating, Ventilation & Air Conditioning (HVAC) 00:13:00 Module 02: Heating Fundamentals and Psychrometrics 00:33:00 Module 03: HVAC Systems 00:15:00 Module 04: Heating and Ventilation 00:22:00 Assignment Assignment - Heating, Ventilation & Air Conditioning (HVAC) Technician Part - 1 00:00:00

Heating, Ventilation & Air Conditioning (HVAC) Technician Part - 1
Delivered Online On Demand1 hour 23 minutes
£25

Project Management Professional

4.7(160)

By Janets

From planning to managing risks, project management is not an easy task. However, you do not have to worry as our exclusive Project Management Professional course is designed to show you the way. The course is created to give you a thorough understanding of project management ideas, practices, and techniques as well as the abilities needed to manage projects successfully. After finishing the course, you will have a firm understanding of stakeholder management, project performance, change management and much more. The course will also provide a certificate of achievement with the help of this certificate, you can show prospective employers that you have the knowledge and experience necessary to successfully manage complicated projects. In conclusion, enrolling in the Project Management Professional course can be a great career investment because it will equip you with the skills and information you need to succeed in the dynamic and fast-paced world of project management. Learning Outcomes By completing the Project Management Professional (PMP) course, learners can expect to achieve the following learning outcomes: Recognise the basic tenets of project management, including starting, planning, carrying out, overseeing, and closing projects Get a thorough understanding of the methodology, tools, and best practices for project management Get the skills necessary to effectively lead and manage teams, including effective communication, conflict resolution, and stakeholder management Gain knowledge of technology in minute taking. Learn how to design and manage project schedules, budgets, and resources Hone your ability to identify, manage, and create backup strategies for project risks Certificate of Achievement Endorsed Certificate of Achievement from the Quality Licence Scheme Upon successful completion of the final assessment, you will be eligible to apply for the Quality Licence Scheme Endorsed Certificate of achievement. This certificate will be delivered to your doorstep through the post for £119. An extra £10 postage charge will be required for students leaving overseas.  CPD Accredited Certificate 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.  Method of Assessment To successfully finish the course, students must take an online automated multiple-choice exam and achieve a minimum score of 60%. Upon passing the exam, students can apply for a certificate of achievement endorsed by the Quality Licence Scheme. Career path Taking the Project Management Professional (PMP) course can open up a variety of career paths in the UK, as the skills and knowledge gained through the course are highly sought after in a range of industries. Entry-level project management roles, such as Project Coordinator or Assistant Project Manager, with an average annual salary range of £25,000 to £35,000. Mid-level project management roles, such as Project Manager or Senior Project Manager, with an average annual salary range of £40,000 to £70,000. Senior-level project management roles, such as Director of Project Management or Program Director, with an average annual salary range of £80,000 to £120,000. A project management professional certification could result in higher pay and more challenging career possibilities. Construction, engineering, information technology, and finance are just a few of the industries that could benefit from using the skills and knowledge acquired via the PMP course

Project Management Professional
Delivered Online On Demand4 weeks
£9.99