7460 Systems courses in Coventry delivered Online

Course Objectives At the end of this course you will be able to: Work with advanced lookup and reference functions Create macros to automate common tasks Use advanced techniques to analyse data Create PivotTables and PivotCharts Work with data validation tools Import and export data ' Customer Feedback Best Training Ever! Just finished a bespoke 1-1 training course in Excel Advanced, Macros & VBA. Pedro is an excellent trainer, imparting his skills and knowledge in the best way - appropriately to audience skills, knowledge and ability. Pedro is always approachable, encouraging and supportive, giving delegates the optimum learning environment. I would not hesitate to recommend Pedro as a trainer, whatever your level of ability. Amanda Morris - Treasury & Systems Accountant at Reall - Real Equity for All The course was very interesting and engaging and will definitely be put to use. The trainer was very helpful and charismatic. Marving Lopez - AM Best Europe Pedro was excellent. Very knowledgeable, clear and great rapport with class. Darren Barkey - Direct Wines Great content and learnt a lot. Really enjoyable :) Kristie-Lee Ryan - Stirling Ackroyd 1 year email support service Take a closer look at the consistent excellent feedback visiting our site ms-officetraining co uk With more than 20 years experience, we deliver courses on all levels of the Desktop version of Microsoft Office and Office 365; ranging from Beginner, Intermediate, Advanced to the VBA level. Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering classrom, one to one, tailored and bespoke courses. Tailored In Company training: You can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs. Please visit our site (ms-officetraining co uk) to get a feel of the excellent feedback our courses have had and look at other courses you might be interested in. Advanced Functions COUNT, COUNTA, COUNTIF, COUNTBLANK, SUMIF, SUBTOTAL IF, OR, AND, IFERROR VLOOKUP to lookup Exact Values and Approximate values MATCH, INDIRECT, ROW/COLUMN, INDEX, OFFSET Analysing Data PMT function to calculate a monthly payment of a loan What If Analysis using Goal Seek Use scenarios to consider many different variables Using Solver Add-in to optimize variables PivotTables Create a PivotTable to analyse worksheet data Add or remove fields in a PivotTable Change the data source for a PivotTable Working with external data sources Using different Statistical Functions Calculate a Running Total, % of Grant Total, Difference From… Using the Slicer and Timeline to filter the PivotTable Using Filters in a PivotTable Group by Date, Auto Group by ranges of values, Custom Group Create a PivotChart The GETPIVOTDATA function Formula auditing Precedents and dependents Error checking Watch a formula and its result by using the Watch Window Evaluate a nested formula one step at a time Data Validation Number Validation Data List Validation Message Prompts and Alerts Conditional Data Validation Data Validation Errors Consolidation Consolidate data by position Consolidate data by category Use a formula to consolidate data Outline (group) data in a worksheet Create an outline of rows Create an outline of columns Copy outlined data Hide or remove an outline Connect external data to your workbook Using the Power Query Editor to import data From Text and CSV, From Access, From Web, From another Workbook Using the Power Query Editor to; Transform your data by Selecting which fields to import, by Splitting Columns, Changing Data Type and more. Deleting Applied Steps Refreshing your data Working with Form Controls; Buttons, Option Buttons and Scroll Bars Introduction to Macros Change Macro Security settings How to Record a macro Some Macro Examples Delete a macro Edit the macro to view the VBA code Copy part of a macro to create another macro Assign a macro to a button Who is this course for? Who is this course for? This course is intended to end users who want to develop their skills so they can use advanced techniques to analyse extensive and complex datasets in Excel and to automate simple tasks with the use of Macros. Requirements Requirements Preferably, delegates should have attended the Excel Intermediate course. Career path Career path Excel know-how can instantly increase your job prospects as well as your salary. 80 percent of job openings require spreadsheet and word-processing software skills Certificates Certificates Certificate of completion Digital certificate - Included

Give a compliment to your career and take it to the next level. This Plumber - Plumbing, HVAC & Domestic Gas bundle will provide you with the essential knowledge to shine in your professional career. Whether you want to develop skills for your next job or elevate your skills for your next promotion, this Plumber - Plumbing, HVAC & Domestic Gas bundle will help you stay ahead of the pack. Throughout the Plumber - Plumbing, HVAC & Domestic Gas programme, it stresses how to improve your competency as a person in your chosen field while also outlining essential career insights in the relevant job sector. Along with this Plumber - Plumbing, HVAC & Domestic Gas course, you will get 13 premium courses, an original hardcopy, 11 PDF certificates (Main Course + Additional Courses) Student ID card as gifts. This Plumber - Plumbing, HVAC & Domestic Gas Bundle Consists of the following Premium courses: Course 01: UK Standard Domestic Plumbing and Heating Installer Training Course 02: Level 3 Heating, Ventilation & Air Conditioning (HVAC) Technician Course 03: Level 2 Domestic Gas Course Course 04: Pipe Fitting Course Course 05: Welding Course Course 06: Spill Management Training Course 07: Handyperson Course 08: Workplace Safety Course Course 09: First Aid at Work Course 10: Manual Handling Level 2 Course 11: PUWER Course 12: Working at Height Awareness Diploma Course 13: COSHH Awareness Level 3 Course 14: Lone Worker Safety Course Enrol now in Plumber - Plumbing, HVAC & Domestic Gas to advance your career, and use the premium study materials from Apex Learning. The bundle incorporates basic to advanced level skills to shed some light on your way and boost your career. Hence, you can strengthen your Plumber - Plumbing, HVAC & Domestic Gas expertise and essential knowledge, which will assist you in reaching your goal. Moreover, you can learn from any place in your own time without travelling for classes. Course Curriculum : Course 01: UK Standard Domestic Plumbing and Heating Installer Training Basic Components Principles of Effective Plumbing Systems The Tools The Process Central Heating Systems Domestic Cold Water System Domestic Hot Water System - Part 1 Domestic Hot Water System - Part 2 The Sanitation System and Repairs Domestic Rainwater System Installation Plumbing Projects: Case Study UK Standards for Plumbing Certificate: PDF Certificate: Free (Previously it was £6*11 = £66) Hard Copy Certificate: Free (For The Title Course: Previously it was £10) CPD 140 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone from any background can enrol in this Plumber - Plumbing, HVAC & Domestic Gas bundle. Persons with similar professions can also refresh or strengthen their skills by enrolling in this course. Students can take this course to gather professional knowledge besides their study or for the future. Requirements Our Plumber - Plumbing, HVAC & Domestic Gas is fully compatible with PC's, Mac's, laptops, tablets and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so that you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course; it can be studied in your own time at your own pace. Career path Having this various expertise will increase the value of your CV and open you up to multiple job sectors. Certificates Certificate of completion Digital certificate - Included You will get the PDF Certificate for the title course (UK Standard Domestic Plumbing and Heating Installer Training) absolutely Free! Certificate of completion Hard copy certificate - Included You will get the Hard Copy certificate for the title course (UK Standard Domestic Plumbing and Heating Installer Training) absolutely Free! Other Hard Copy certificates are available for £10 each. Please Note: The delivery charge inside the UK is £3.99, and the international students must pay a £9.99 shipping cost.

Information Technology (IT) is a vast and growing field that offers many opportunities for career growth. Whether you're a student or a professional, there's an IT career path that's right for you. The skills required to succeed in IT are continuously changing because the industry is continually evolving. Therefore, being open to learning new things and adjusting to the most recent technologies is necessary if you want to stay ahead of the curve. If you're thinking about working in IT, here is an easy way to get started. You can take these online information technologies (IT) training courses. In this package, you will receive 11 premium courses, an original hard copy, and 11 PDF certificates (Main Course + Additional Courses) in addition to this IT bundle. Learning Outcomes Master functional skills in IT to be able to troubleshoot problems Learn about the hardware, software, computer network, operating systems etc Familiarise with ethical hacking, become well versed in cyber security Master CompTIA networking and learn how to build up a secure network Learn the basics of Linux and complete Windows 10 troubleshooting for the IT helpdesk tasks Understand information management, GDPR data protection and much more throughout this bundle IT is a fast-growing field, and the demand for skilled professionals is increasing every day. So sign up for our IT training bundle today, get ahead, and start your career. This IT Courses Bundle Consists of the following Premium courses: Course 1: Functional Skills IT Course 2: Ethical Hacking Course 3: Level 3 Cyber Security Course 4: CompTIA Networking - Level 4 Course 5: Network Security Level 2 Course 6: Secure Programming of Web Applications Course 7: Linux for Absolute Beginners! Course 8: Complete Windows 10 Troubleshooting for IT HelpDesk Course 9: Information Management Course 10: GDPR Data Protection Level 5 Course 11: Decision-Making and Critical Thinking Enrol now in IT Courses To advance your career and use the premium study materials from Apex Learning. The IT bundle incorporates basic to advanced level skills to shed some light on your way and boost your career. Hence, you can strengthen your IT Courses Expertise and essential knowledge, which will assist you in reaching your goal. Certificate: PDF Certificate: Free (Previously it was £6*11 = £66) Hard Copy Certificate: Free (For The Title Course: Previously it was £10) CPD 125 CPD hours / points Accredited by CPD Quality Standards Who is this course for? It is recommended for anyone interested in learning more about this topic. Requirements This IT Training course has been designed to be fully compatible with tablets and smartphones. Career path Your resume will be more valuable if you have this knowledge, and you'll be more employable in various IT-related fields. Like as: Learning and Development Trainer Systems Administrator IT Security Service Desk Analyst Information Technology Specialist In the UK, an information technology specialist makes an average salary of £36,290 per year.

This course aims to give the learner the knowledge regarding conditions, causes, signs, symptoms, treatments and risks associated with respiratory diseases.

This Electricity & Circuit Analysis Course is designed for those with a strong interest in electrical systems, power flow, and circuit behaviour. Covering a wide range of topics—from DC and AC circuit analysis to high-voltage generation and electrical machines—it offers a structured approach to understanding the core principles and theories behind modern electrical engineering. Whether you're brushing up your knowledge or looking to build a foundation for advanced study, this course supports your goals with detailed modules tailored to electrical applications. Each unit builds logically on the last, moving through core concepts like power electronics, MATLAB Simulink applications, and short-circuit analysis in high-voltage systems. The content is suitable for learners aiming to improve their confidence in tackling circuit-based problems, system behaviour, and electrical safety. With a strong focus on theory, calculation methods, and system analysis, the course offers a rigorous pathway into the essentials of electricity and circuit analysis—delivered entirely online, at your convenience. Key Features of Electrician: Electricity & Circuit Analysis Bundle CPD Accredited Electrician: Electricity & Circuit Analysis Course Instant PDF certificate Fully online, interactive Electrician: Electricity & Circuit Analysis course Self-paced learning and laptop, tablet, smartphone-friendly 24/7 Learning Assistance Discounts on bulk purchases Enrol now in this Electrician: Electricity & Circuit Analysis Bundle course to excel! To become successful in your profession, you must have a specific set of Electrician: Electricity & Circuit Analysis skills to succeed in today's competitive world. In this in-depth Electrician: Electricity & Circuit Analysis training course, you will develop the most in-demand Electrician: Electricity & Circuit Analysis skills to kickstart your career, as well as upgrade your existing knowledge & skills. Electrician: Electricity & Circuit Analysis Curriculum Course 01: Electrician Course Level 3 Course 02: Electricity and DC Circuit Analysis Course 03: Electric Circuits for Electrical Engineering Course 04: Power Analysis in AC Circuits Course 05: Short Circuit Analysis for HV Three Phase Systems Course 06: Light Current Systems for Electrical Engineering Course 07: High Voltage Generation for Electrical Engineering Course 08: Electrical Machines for Electrical Engineering Course 09: Power Electronics for Electrical Engineering Course 10: MATLAB Simulink for Electrical Power Engineering Course 11: Advanced Electrical Safety Accreditation This Electrician: Electricity & Circuit Analysis bundle courses are CPD accredited, providing you with up-to-date skills and knowledge and helping you to become more competent and effective in your chosen field. Certification Once you've successfully completed your Electrician: Electricity & Circuit Analysis course, you will immediately be sent a digital certificate. Also, you can have your printed certificate delivered by post (shipping cost £3.99). CPD 110 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This course is ideal for all employees or anyone who genuinely wishes to learn more about Electrician: Electricity & Circuit Analysis basics. Requirements No prior degree or experience is required to enrol in this course. Career path This Electrician: Electricity & Circuit Analysis Course will help you to explore avariety of career paths in the related industry. Certificates Digital certificate Digital certificate - Included Hardcopy Certificate Hard copy certificate - Included Hardcopy Certificate (UK Delivery): For those who wish to have a physical token of their achievement, we offer a high-quality, printed certificate. This hardcopy certificate is also provided free of charge. However, please note that delivery fees apply. If your shipping address is within the United Kingdom, the delivery fee will be only £3.99. Hardcopy Certificate (International Delivery): For all international addresses outside of the United Kingdom, the delivery fee for a hardcopy certificate will be only £10.

Who is this course for? Mastering 3ds Max: Complete Basic to Advanced Training. Looking to learn 3D modelling and animation? Look no further than our comprehensive 3ds Max beginner course! Gain a strong foundation in 3ds Max and learn essential skills for creating stunning 3D models and visualizations. Check our Website Training Duration: 40 hours Method: 1-on1 Sessions and Customized Content. Schedule: Choose your preferred time slot between 9 am and 7 pm, Mon to Sat, tailored to fit your schedule. Course Title: 3ds Max and V-Ray Comprehensive Training Program (40 Hours) Course Overview: Dive deep into the world of 3D visualization and rendering with our intensive 3ds Max and V-Ray training program. Over the course of 40 hours, you'll master the fundamental concepts, advanced techniques, and practical applications of both 3ds Max and V-Ray, empowering you to create stunning, photorealistic visualizations for various industries. Course Outline: Module 1: Introduction to 3ds Max (8 hours) Understanding the 3ds Max interface and tools Basic 3D modeling techniques and workflows Material creation and texture mapping Lights and cameras setup for scenes Module 2: Advanced 3ds Max Techniques (8 hours) Character modeling and animation Particle systems and dynamics Advanced lighting and shading techniques Scene composition and camera animation Module 3: V-Ray Fundamentals (8 hours) Introduction to V-Ray rendering engine V-Ray materials and texture mapping Lighting with V-Ray lights and HDRI maps V-Ray camera settings and depth of field Module 4: Advanced V-Ray Rendering (8 hours) Global illumination and image-based lighting V-Ray proxies and instancing Advanced V-Ray shaders and displacement maps Render elements and post-production techniques Module 5: Architectural Visualization with V-Ray (8 hours) Interior and exterior scene setup Realistic materials for architectural elements Lighting strategies for different times of the day Creating lifelike environments and atmospheric effects Course Features: Hands-On Learning: Engage in practical exercises and real-world projects to reinforce your skills and knowledge. Industry-Standard Tools: Work with the latest versions of 3ds Max and V-Ray, widely used in the professional 3D visualization industry. Expert Instruction: Learn from certified trainers and industry professionals with extensive experience in 3D modeling and rendering. Project-Based Assessments: Apply learned techniques to comprehensive projects, receiving feedback and guidance to refine your skills. Flexible Learning: Choose between in-person and online sessions, accommodating various schedules and learning preferences. Upon completing this 40-hour course, you will be equipped with the expertise to create visually stunning 3D renderings and animations, making you proficient in both 3ds Max and V-Ray for a successful career in architectural visualization, gaming, film production, and more. Upon completion, participants will: Master 3ds Max & V-Ray: Acquire advanced skills in 3ds Max and V-Ray for creating realistic 3D visualizations. Expert in Architectural Visualization: Specialize in architectural visualization techniques, ideal for interior designers and architects. Project-Based Proficiency: Apply learned skills to real projects, developing a professional portfolio. Recommended Jobs: Architectural Visualization Artist 3D Animator Product Visualization Specialist Interior Designer VR Developer Freelance 3D Artist Game Environment Artist Visualization Consultant This training opens doors to diverse roles in architecture, gaming, design, and more. Duration: 40 Hours Focus: Master 3ds Max and V-Ray for advanced 3D visualizations and architectural rendering. Learning Format: One-on-One Training for personalized attention. Availability: Book your sessions Monday to Saturday, 9 am to 7 pm, tailored to your schedule. Outcome: Expertise in 3ds Max, V-Ray, and specialized architectural visualization skills. Practical Focus: Hands-on projects and real-world applications for skill reinforcement. Certification: Upon completion, receive a certificate showcasing your advanced 3D modeling and rendering skills. This one-on-one course offers tailored training sessions from Monday to Saturday, 9 am to 7 pm, ensuring personalized attention and flexibility to suit your schedule. Download 3ds max Ongoing Email Support: We offer continuous email assistance, ensuring your queries are promptly addressed even after the course completion. Comprehensive Resources: Access extensive handouts and valuable documents designed to reinforce your learning experience. Flexible Financial Options: Explore adaptable financial support options, including installment plans and assistance through job center plus and DWP. Reach out to us for specific details. Satisfaction Guarantee: Although it's highly improbable given our exceptional quality and skilled tutors, if you find dissatisfaction after your initial session, we will promptly address your concerns. If necessary, a refund may be provided (Terms and conditions apply). Optimized Software Experience: Receive guidance on optimizing your computer for enhanced software performance in applications like Autocad, 3ds Max, and Photoshop, whether you're on MAC or PC platforms. Industry Connections: Leverage our industry ties as we actively showcase your portfolio to potential employers. Many of our students have secured jobs through our recommendations, offering valuable career opportunities.

FREE Level 5 QLS Endorsed Certificate | 12 CPD Courses + 12 PDF Certificates | 155 CPD Points | CPD Accredited

This Renewables Technical Surveying training short two day course is specifically designed for individuals and companies that want to train themselves and their staff on exactly how to carry out Renewables Technical Site Surveying prior to any renewables installation measures, this includes for heating systems, solar systems and EV Charge point installations. The course is primarily aimed at Energy Suppliers, Equipment Manufacturers, Renewable Installers, Domestic Energy Assessors, Retrofit Assessors, Retrofit Co-ordinators, Renewables sales staff and suitable individuals with a basic level of knowledge in varying building structures, heating systems and varying renewable technologies.

IASSC lean six sigma green belt course. Online, 24/7 access to content and exam. Fee includes learning content, live webinars, tutor support, and official IASSC exam.

Overview Uplift Your Career & Skill Up to Your Dream Job - Learning Simplified From Home! Kickstart your career & boost your employability by helping you discover your skills, talents, and interests with our special Supply Chain Management Course. You'll create a pathway to your ideal job as this course is designed to uplift your career in the relevant industry. It provides the professional training that employers are looking for in today's workplaces. The Supply Chain Management Course is one of the most prestigious training offered at Skillwise and is highly valued by employers for good reason. This Supply Chain Management Course has been designed by industry experts to provide our learners with the best learning experience possible to increase their understanding of their chosen field. This Supply Chain Management Course, like every one of Skillwise's courses, is meticulously developed and well-researched. Every one of the topics is divided into elementary modules, allowing our students to grasp each lesson quickly. At Skillwise, we don't just offer courses; we also provide a valuable teaching process. When you buy a course from Skillwise, you get unlimited Lifetime access with 24/7 dedicated tutor support. Why buy this Supply Chain Management? Unlimited access to the course forever Digital Certificate, Transcript, and student ID are all included in the price Absolutely no hidden fees Directly receive CPD Quality Standard-accredited qualifications after course completion Receive one-to-one assistance every weekday from professionals Immediately receive the PDF certificate after passing Receive the original copies of your certificate and transcript on the next working day Easily learn the skills and knowledge from the comfort of your home Certification After studying the course materials of the Supply Chain Management there will be a written assignment test which you can take either during or at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for free. Original Hard Copy certificates need to be ordered at an additional cost of £8. Who is this course for? This Supply Chain Management course is ideal for Students Recent graduates Job Seekers Anyone interested in this topic People already working in the relevant fields and want to polish their knowledge and skills. Prerequisites This Supply Chain Management does not require you to have any prior qualifications or experience. You can just enroll and start learning. This Supply Chain Management was made by professionals and it is compatible with all PCs, Macs, 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. Career path As this course comes with multiple courses included as a bonus, you will be able to pursue multiple occupations. This Supply Chain Management is a great way for you to gain multiple skills from the comfort of your home.   Module 01: An overview of Supply Chain Management An Overview of Supply Chain Management 00:17:00 Module 02: Role of logistics of Supply Chain Role of logistics of Supply Chain 00:19:00 Module 03: Customer Response Principles and Systems Customer Response Principles and Systems 00:15:00 Module 04: Supply Chain System and Principles Supply Chain System and Principles 00:15:00 Module 05: Global Supply Chain Operations Global Supply Chain Operations 00:17:00 Module 06:Inventory Strategies for Supply Chain Inventory Strategies for Supply Chain 00:15:00 Module 07: Warehouse Management and Operations Warehouse Management and Operations 00:13:00 Module 08: Supply Chain Design and Monitoring Supply Chain Design and Monitoring 00:15:00 Module 09: Supply Chain Network and Evaluating Supply Chain Network and Evaluating 00:18:00 Module 10: Supply Chain Planning and New Business Concepts Supply Chain Planning and New Business Concepts 00:17:00 Module 11: Aligning your supply chain process with your business Aligning Supply Chain Process with Your Business 00:18:00 Mock Exam Final Exam Assignment Assignment - Supply Chain Management 08:01:00 Feedback Learner Feedback