7103 Systems courses in Cardiff delivered Online

Gear Up for Success: Your Roadmap to Car Mechanic Proficiency with complete Car Mechanic & Car Maintenance program. Are you ready to accelerate your career in the dynamic world of automotive engineering? Welcome to a transformative ride through our Car Mechanic & Car Maintenance program - not just a course but a roadmap to restore your career in the fast lane. This certification is your passport to a fulfilling career in a world where automotive expertise is critical. The automotive industry is booming, and opportunities abound for those with the right skills. Join us in exploring the intricacies of vehicle mechanics, hybrid technologies, Car Restoration, specialised areas like supercharger engineering and many more. Moreover, we're your dedicated partners in this exciting Car Mechanic & Car Maintenance program. Our goal isn't just to teach you; it's to support you 24/7 so you can get closer to your dream job. We're so confident with our program that we offer a 100% money-back guarantee, ensuring your complete satisfaction. Learning Outcomes Upon completion of the Car Mechanic & Car Maintenance program, you will have acquired: Electrician skills tailored for automotive applications Advanced proficiency in engine tuning techniques Expertise in chassis and suspension systems In-depth knowledge of fuel injection systems Competence in hybrid vehicle technology Understanding of supercharger and turbocharging principles Proficiency in digital circuit design for automobiles Effective inventory management skills for automotive workshops Expertise in LGV and motorbike maintenance Knowledge of fire safety measures and car restoration techniques. Time management strategies tailored explicitly for mechanics Comprehensive interview skills training to excel in job interviews Confidence in navigating the virtual job market, including video interviews Optimisation of your online presence through a professionally crafted LinkedIn profile. Courses Provided Upon Enrollment Enrol in our Car Mechanic & Car Maintenance program and gain access to 25 complete courses, including: => Course 01: Car Mechanic and Repair Training Diploma => Course 02: Large Goods Vehicle (LGV) => Course 03: Motorbike Repairing and Maintenance Diploma => Course 04: Hybrid Vehicle Expert Training => Course 05: Supercharger Automobile Engineering => Course 06: Engine Lubricant System Training - Level 4 => Course 07: Energy Saving in Electric Motors => Course 08: Car Restoration => Course 09: PUWER => Course 10: A complete course on Turbocharging => Course 11: Basic Automotive Engineering: Onboard Diagnostics => Course 12: Digital Electric Circuits & Intelligent Electrical Devices => Course 13: Mechanical Engineering => Course 14: Inventory Management Training => Course 15: Driving Instructor => Course 16: Bicycle Maintenance Course => Course 17: PAT Level 4 => Course 18: Manual Handling Training | Online Course => Course 19: Fire Safety Training => Course 20: Time Management | Online Course => Course 21: Career Development Plan Fundamentals => Course 22: CV Writing and Job Searching => Course 23: Interview Skills: Ace the Interview => Course 24: Video Job Interview for Job Seekers => Course 25: How to Create a Professional LinkedIn Profile Enrol in our highly regarded Car Mechanic & Car Maintenance program, featuring a job-relevant curriculum that ensures your skills align with employer expectations across various sectors. Don't miss this opportunity - your success story starts now! Please feel free to contact us for any query, and we will gladly assist you. Embark on a transformative journey into the complex car mechanics and maintenance sector with our comprehensive Car Mechanic & Car Maintenance program. From understanding the different aspects of engine mechanics to mastering hybrid technology, our courses cover it all, ensuring you're well-equipped for a successful career in the automotive industry. Why Choose Us? So, what sets us apart from other programs? Here are the benefits you'll experience when you join our Car Mechanic & Car Maintenance Program: Updated Materials: Stay at the forefront of the ever-evolving automotive landscape with our commitment to consistently updating course materials. In the Car Mechanic & Car Maintenance industry, staying current is vital. Our regularly updated content ensures you're ready with the latest knowledge, techniques, and industry trends. Flexible Timing: Our Car Mechanic & Car Maintenance program offers a flexible learning approach. Flexible timing allows you to tailor your learning experience to fit seamlessly into your schedule. Whether you're working a full-time job, managing family responsibilities, or pursuing other interests, our program adapts to you. No Hidden Costs: Transparency is our core principle regarding your investment in education. With our Car Mechanic & Car Maintenance program, your enrollment fee covers everything you need to succeed - from certification to comprehensive course materials. There are no hidden costs or additional expenses. Money-Back Guarantee: We stand behind the value our program brings to your educational journey. If, within the first 14 days of enrollment, you find that our Car Mechanic & Car Maintenance program doesn't align with your expectations, we offer a hassle-free money-back guarantee. Your satisfaction is our priority, and this guarantee reflects our confidence in the quality and relevance of our curriculum. Lifetime Access: Education is a lifelong journey, as is your access to our Car Mechanic & Car Maintenance program. Enjoy lifetime access to our complete course materials and updates, ensuring that you remain connected with the latest advancements in automotive technology. 24/7 Support: We understand that your learning journey is more than just a course. Our dedicated support team is available around the clock, 24/7, to assist you at every step of your learning experience. Whether you have questions about course content, need clarification on a concept, or require technical assistance, our support team is just a message away. CPD 250 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This Car Mechanic & Car Maintenance program is for individuals who are: Seeking a career in automotive engineering Interested in understanding car mechanics and maintenance Looking to enhance their knowledge of hybrid and electric vehicles Aspiring to work in LGV and motorbike maintenance Requirements No experience is required for the Car Mechanic & Car Maintenance program. Just enrol and start learning - we'll guide you every step of the way. Career path Upon completion of the Car Mechanic & Car Maintenance program, you will get edges in many professions, including: Automotive Technician: £25,000 - £35,000 Electric Vehicle Specialist: £30,000 - £40,000 Motorbike Mechanic: £20,000 - £30,000 Car Restoration Specialist: £25,000 - £35,000 Driving Instructor: £20,000 - £30,000 Bicycle Maintenance Technician: £18,000 - £25,000 Certificates CPD Accredited (e-Certificate) Digital certificate - Included CPD Accredited (Hard Copy Certificate) Hard copy certificate - Included e-Transcript Digital certificate - Included Hard Copy Transcript Hard copy certificate - Included Student ID Card Digital certificate - Included

This course explores why our energy system can become blocked and the impact those blocks have on our physical and mental health. We look at methods to clear those blocks and to be able to restore balance to the Aura and Chakra system. We explore in detail the intrinsic power of the Aura and Chakra systems and how they interact with the physical and emotional self.

The comprehensive Unix Operating System has been designed by industry experts to provide learners with everything they need to enhance their skills and knowledge in their chosen area of study. Enrol on the Unix Operating System today, and learn from the very best the industry has to offer! This best selling Unix Operating System has been developed by industry professionals and has already been completed by hundreds of satisfied students. This in-depth Unix Operating System is suitable for anyone who wants to build their professional skill set and improve their expert knowledge. The Unix Operating System is CPD-accredited, so you can be confident you're completing a quality training course will boost your CV and enhance your career potential. The Unix Operating System is made up of several information-packed modules which break down each topic into bite-sized chunks to ensure you understand and retain everything you learn. After successfully completing the Unix Operating System, you will be awarded a certificate of completion as proof of your new skills. If you are looking to pursue a new career and want to build your professional skills to excel in your chosen field, the certificate of completion from the Unix Operating System will help you stand out from the crowd. You can also validate your certification on our website. We know that you are busy and that time is precious, so we have designed the Unix Operating System to be completed at your own pace, whether that's part-time or full-time. Get full course access upon registration and access the course materials from anywhere in the world, at any time, from any internet-enabled device.  Our experienced tutors are here to support you through the entire learning process and answer any queries you may have via email.

The Heating, Ventilation & Air Conditioning (HVAC) Technician - CPD Accredited Course offers an in-depth exploration of HVAC systems, focusing on the essential concepts, techniques, and technologies required to master this crucial industry. Designed for those looking to develop expertise in maintaining and troubleshooting HVAC systems, this course provides a robust foundation that can be applied to residential, commercial, and industrial settings. The course delves into the science behind heating and cooling systems, helping you understand their functionality and the intricate balance required for optimum performance. Throughout the course, you will develop a thorough understanding of system components, installation processes, and energy-efficient solutions that are increasingly important in today’s eco-conscious world. The knowledge gained will equip you with the tools needed to excel in a competitive field, enhancing your professional credentials and boosting your career prospects. Whether you're new to the field or looking to formalise your existing knowledge, this course is a step forward in your professional journey as an HVAC technician. Still not convinced? Take a glimpse of the key benefits you'll get with - Lessons prepared in collaboration with Professionals User-friendly Learner Management System (LMS) Syllabus designed in line with the standards of the UK Education System Updated Study Materials focusing both on Knowledge and Skill based training Guidance to expand in 'a' territory and move forward with HVAC Technician profession Free Assessment to test learners' knowledge and skills Accredited learning and widely recognised certificate from reputed CPD Accreditation Bodies Course Curriculum: Module 01: Introduction to Heating, Ventilation & Air Conditioning (HVAC) Module 02: Heating Fundamentals and Psychrometrics Module 03: HVAC Systems Module 04: Heating and Ventilation Module 05: Air Conditioning Systems for HVAC Technicians Module 06: Compressors, Water Chillers, and Fans Module 07: Piping for HVAC Technician Module 08: Duct System in HVAC Module 09: Refrigeration and Refrigerants Module 10: Special Applications Module 11: HVAC System Selection Module 12: Safety in the HVAC Industry Course Assessment You will immediately be given access to a specifically crafted MCQ test upon completing the Heating , Ventilation & Air Conditioning (HVAC) Technician - CPD Accredited course. For each test, the pass mark will be set to 60%. Accredited Certificate After successfully completing this Heating , Ventilation & Air Conditioning (HVAC) Technician - CPD Accredited course, you will qualify for the CPD Quality Standards (CPD QS) certificate from Training Express. CPD 10 CPD hours / points Accredited by The CPD Quality Standards (CPD QS) Who is this course for? The Heating , Ventilation & Air Conditioning (HVAC) Technician - CPD Accredited training is ideal for highly motivated individuals or teams who want to enhance their skills and efficiently skilled employees. Requirements There are no formal entry requirements for the course, with enrollment open to anyone! Career path Learn the essential skills and knowledge you need to excel in your professional life with the help & guidance from our Heating , Ventilation & Air Conditioning (HVAC) Technician - CPD Accredited training.

***24 Hour Limited Time Flash Sale*** Computer Maintenance Admission Gifts FREE PDF & Hard Copy Certificate| PDF Transcripts| FREE Student ID| Assessment| Lifetime Access| Enrolment Letter Do you ever feel frustrated by your computer running slow, crashing unexpectedly or showing error messages? According to a recent study by YouGov, nearly 70% of UK adults have experienced a computer problem they couldn't fix themselves. This comprehensive Computer Maintenance Bundle equips you with the skills to not only troubleshoot these everyday issues but potentially pursue a career in IT support. Are you ready to take control of your technology and maybe even help others with theirs? This extensive bundle offers a one-stop shop for everything computer maintenance related. Whether you're a complete beginner or an experienced IT professional, you'll find a course to suit your needs. Learn how to build your own PC, troubleshoot Windows 10 issues, and become a certified computer maintenance specialist. Power up your knowledge of electrical systems and network security. The bundle even covers essential soft skills like communication and critical thinking, making you a well-rounded IT professional. Courses are Included in This Computer Maintenance Bundle: Course 01: Building Your Own Computer Course 02: Electronic & Electrical Devices Maintenance Course 03: PAT Level 4 Course 04: Complete Windows 10 Troubleshooting for IT Helpdesk Course 05: Computer Maintenance Specialist Training Course 06: Certificate in Computer Operating System and Troubleshooting Course 07: Display Screen Equipment (DSE) Course 08: Basic Electricity Course Course 09: Computer Hacking Forensic Investigator Course 10: IT Support Technician Course 11: Internet and Computing - Tools & Networking Guide Course 12: Information Technology and Networking Course 13: Cyber Security Awareness Training Course 14: Cyber Security Incident Handling and Incident Response Course 15: IT Administration and Networking Course 16: CompTIA Network+ Certification Course 17: CompTIA Security+ Certification Course 18: Cisco ASA Firewall Training Course 19: Digital Risk Protection Training Course 20: Data Protection Assistant Course 21: Data Center Training Essentials: Power & Electrical Course 22: Workplace Confidentiality Course 23: Information Management Course 24: Effective Communication Skills Course 25: Network Security Level 2 Course 26: Encryption Course 27: Decision Making and Critical Thinking Course 28: Internet of Things Course 29: Functional Skills IT Course 30: Web Application Penetration Testing Course Take control of your technology and open doors to exciting new career opportunities. This computer maintenance bundle equips you with the knowledge and skills to diagnose, solve, and prevent computer problems. Enrol today and take the first step towards a successful IT career! Learning Outcomes of Computer Maintenance Gain proficiency in building, maintaining, and troubleshooting computer systems. Master essential IT support skills for resolving common Windows 10 issues. Prepare for industry-recognized certifications like CompTIA Network+ and Security+. Develop a strong understanding of network security principles and data protection practices. Enhance your communication and decision-making skills for a successful IT career. Explore emerging technologies like the Internet of Things (IoT) and web application security. Why Choose Us? Get a Free CPD Accredited Certificate upon completion of Computer Maintenance Get a free student ID card with Computer Maintenance Training program (£10 postal charge will be applicable for international delivery) The Computer Maintenance is affordable and simple to understand This course is entirely online, interactive lesson with voiceover audio Get Lifetime access to the Computer Maintenance course materials The Computer Maintenance comes with 24/7 tutor support Start your learning journey straightaway! *** Course Curriculum *** Course 01: Building Your Own Computer Module 01: Introduction To Computer & Building PC Module 02: Overview Of Hardware And Parts Module 03: Building The Computer Module 04: Input And Output Devices Module 05: Software Installation Module 06: Computer Networking Module 07: Building A Gaming PC Module 08: Maintenance Of Computers Course 02: Electronic & Electrical Devices Maintenance Section 1: Introduction & Getting Started Section 2: Electronic And Electrical Maintenance Repair Section 3: Tools Needed Section 4: Electronic Components Section 5: Testing Section 6: Troubleshooting Section 7: Introduction To Electronic Components: A Step By Step Guide Course 03: PAT Level 4 Module 01: Introduction To PAT Module 02: Relevant Statutory Provisions For PAT Module 03: Safety Responsibilities & Maintenance Provisions Module 04: Risk Assessment Module 05: Reducing And Controlling Risks Module 06: Electrical Units And Appliance Classification Module 07: Equipment Coverage & Maintenance Needs Module 08: Initial Visual Examination Module 09: Instruments For Testing And Equipment Inspection Module 10: Electrical Installation Testing Module 11: Lead & RCD Testing Module 12: Safety Precautions In Electrical Testing Module 13: Reporting And Record-Keeping Module 14: Testing For New Or Used Equipment Module 15: British Standards And Latest Changes =========>>>>> And 27 More Courses <<<<<========= How will I get my Certificate? After successfully completing the course, you will be able to order your Certificates as proof of your achievement. PDF Certificate: Free (Previously it was £12.99*30 = £389) CPD Hard Copy Certificate: Free ( For The First Course: Previously it was £29.99) CPD 300 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone interested in learning more about the topic is advised to take this bundle. This bundle is ideal for: DIY Tech Enthusiasts IT Support Aspirants Cybersecurity Professionals Network Administrators Data Protection Specialists Career Changers Career Path Requirements You will not need any prior background or expertise to enrol in this bundle. Career path After completing this bundle, you are to start your career or begin the next phase of your career. IT Technician Helpdesk Analyst Network Engineer Security Analyst Data Center Specialist IT Consultant Certificates CPD Accredited Digital Certificate Digital certificate - Included Upon passing the Course, you need to order a Digital Certificate for each of the courses inside this bundle as proof of your new skills that are accredited by CPD QS for Free. CPD Accredited Hard Copy Certificate Hard copy certificate - Included Please note that International students have to pay an additional £10 as a shipment fee.

Join the Scrum.org accredited Live Virtual Class - Professional Scrum Product Owner Advanced™ training (PSPO Advanced) to master the role of a Product Owner. Learn how to advance your training of Product Ownership and apply it to deliver even more value. Course Description Agile techniques and the Scrum framework revolutionise project and product delivery, enabling teams to work faster and align closely with business needs. A product owner's role within this delivery is critical. Unlike traditional team managers, Product Owners focus on maximising product value rather than individual elements of project delivery. To excel in this role, product owners must combine business strategy with product vision and delivery roadmaps. The ability to operate within complex environments highlights the need for specific training and qualifications. Product Owner Advanced training is specifically designed to empower experienced Product Owners to deliver greater value. An exceptional Product Owner requires skillsets beyond core Agility and Scrum. These include clear decision-making, vision, communication, and influence. Practical experience is highly valued, and the PSPO 2 course emphasises interactive workshops, discussions, and exercises to provide a comprehensive understanding of the multifaceted Product Owner role. This course elevates existing Product Owners' capabilities, providing a clear path for your professional growth and delivering increased value to product stakeholders. Through collaborative and exploratory training, Product Owners' knowledge and experience will reach new heights, improving various aspects of your role. Key areas covered include: Deepening understanding of the Product Owner role, including product understanding, customer identification, and effective communication of product vision and strategy. Leveraging product vision and strategy to gain a competitive edge. Embracing diverse roles and stances essential for Product Owners. Enhancing stakeholder communication and management skills with a focus on different stakeholder groups. Navigating Agile governance, budgeting, and contracting within the Scrum framework. Scaling the Product Owner role for larger projects and products. By the end of this product owner advanced training, participants will be equipped to excel as Product Owners, driving success and value across their product journey. Why Train With Us? Develop advanced product owner skillsets that build on your existing knowledge of the Scrum framework and product owner accountabilities with our immersive two-day online PSPO Advanced course. Led by experienced industry professionals and support Professional Scrum Trainers & Product Owners, the course values team-based exercises and a hands-on learning experience. We help you grow within your Product Owner role through this advanced training, enabling you to better communicate product vision and strategy to teams, ultimately delivering higher value through projects and products with larger scopes. Who Should Attend This Course? The Professional Product Owner – Advanced course is designed for: Experienced Product Owners, ideally with at least one year of experience in the role Scrum Masters and stakeholders collaborating with Product Owners Your Professional Scrum Trainer Meet Jay, founder of Fractal Systems and a dedicated Professional Scrum Trainer. With over 20 years of experience in team and leadership roles, Jay is well-versed in delivering continuous value. His unique teaching approach involves zero PowerPoint and instead relies on engaging, experience-based sessions using techniques from Liberating Structures and Neuro Linguistic Programming. Jay's expertise lies in business transformations, offering training, mentoring, coaching, and consulting to foster success through collaborative efforts. Rapid learning and practical application are the hallmarks of his approach. Jay & the entire Fractal team are invested in your learning journey and are here to support you from start to end, including offering additional valuable support: Free practice assessments for certification success Free resource bundle to master Scrum Free exam revision sheets Free access to an exam simulator Free exam coaching sessions for first-time success Free 1:1 coaching to excel at work Our Clients Our Testimonials

Explore the intricate world of orthodontic biomechanics with our comprehensive course. Master the fundamental concepts, advanced techniques, and cutting-edge technologies shaping modern orthodontics. From archwires to aligner therapy, delve into the biomechanics of tooth movement, anchorage control, and space closure. Elevate your practice with expert insights, ensuring precision in class II and class III corrections. Join us for a transformative learning experience in the dynamic intersection of orthodontics and biomechanics.

A Medical Secretary, Where Care Meets Coordination, Bridging The Expertise Of Doctors With Patients' Health Journeys

This course on Information and Communication Technology (ICT) provides a comprehensive understanding of emerging technologies, input and output devices, storage media, networks, databases, and expert systems. It covers various ICT applications and their impact on society and businesses. Learning Outcomes: Understand the impact of emerging technologies on the field of ICT. Identify and describe different types of input and output devices used in computing. Familiarize with various storage devices and media and their applications. Gain knowledge about computer networks and their configurations. Explore the fundamentals of database systems and their importance in data management. Learn about expert systems and their role in decision-making processes. Discover practical ICT applications and their relevance in various domains. Why buy this ICT: Information and Communication Technology? Unlimited access to the course for forever Digital Certificate, Transcript, student ID all included in the price Absolutely no hidden fees Directly receive CPD accredited qualifications after course completion Receive one to one assistance on 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 ICT: Information and Communication Technology 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 £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60. Who is this course for? This ICT: Information and Communication Technology 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 skill. Prerequisites This ICT: Information and Communication Technology does not require you to have any prior qualifications or experience. You can just enrol and start learning.This ICT: Information and Communication Technology 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. Career path As this course comes with multiple courses included as bonus, you will be able to pursue multiple occupations. This ICT: Information and Communication Technology is a great way for you to gain multiple skills from the comfort of your home. Course Curriculum Section 01: Introduction Introduction 00:06:00 What is ICT? 00:05:00 Hardware and Software 00:08:00 Information Processing Cycle 00:05:00 Software Explained 00:06:00 Human-Computer -Interface 00:07:00 Section 02: Impact of Emerging Technologies Introduction-Impact of Emerging Technology 00:01:00 Artificial intelligence 00:03:00 Biometrics 00:03:00 Vision enhancement 00:02:00 Robotics 00:03:00 Quantum cryptography 00:03:00 Computer-assisted translation 00:02:00 3D and holographic imaging 00:03:00 Virtual reality 00:06:00 Section 03: Types of Input Devices Types of Input Devices - Introduction 00:02:00 Manual input 00:07:00 Pointing devices 00:02:00 Inputting Images Devices 00:08:00 Inputting Sound & Music Devices 00:05:00 Direct input systems 00:07:00 Direct Input systems Part-2 00:05:00 Direct Input Systems Part-3 00:06:00 Direct Input Systems devices. Part-4 00:04:00 Sensors 00:05:00 Section 04: Types of Output Devices Types of Input Devices - Introduction 00:02:00 Monitors 00:06:00 Printers 00:08:00 Plotters 00:03:00 3D Printers 00:04:00 Speakers 00:02:00 Control Devices 00:06:00 Section 05: Storage Devices and Media Types of Storage Devices and Media 00:06:00 Magnetic Media 00:06:00 Optical media 00:10:00 Solid-State media 00:04:00 Backups 00:02:00 Section 06: Networks WHAT IS COMPUTER COMMUNICATION? 00:02:00 What is a computer network? 00:07:00 Types of NETWORK- Local Area Network 00:07:00 Wide Area Network 00:07:00 Bluetooth and WI-FI in Networks 00:07:00 Network Hardware 00:03:00 Network Switch 00:05:00 Network Bridge 00:02:00 Networking Hardware Router 00:05:00 Modem 00:04:00 Network Cables 00:03:00 How to set up a small network? 00:07:00 Section 07: Database What is a Database? 00:03:00 Database File 00:04:00 Database Types 00:09:00 Using Database 00:06:00 Data validation and verification 00:10:00 Section 08: Expert Systems What is an expert system? 00:10:00 Section 09: ICT Applications Applications in Banking: ATM, Electronic Fund Transfer 00:04:00 Applications in Banking: Internet Banking Telephone Banking 00:04:00 Applications in Banking: Cheque Clearing 00:05:00 RETAIL INDUSTRY Applications: POS 00:05:00 Retail: Stock Control 00:04:00 Retail: Automatic Reordering of Stock 00:03:00 Assignment Assignment - ICT: Information and Communication Technology 00:00:00

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 from our growing corporate clients 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 public, one to one, tailored and bespoke courses. Our competitive rates start from £550.00 per day of training Tailored training courses: 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