7360 Systems courses

Description: The Archives and Record Management Diploma will provide you with the basic principles and practices to work in records and information management and archives. You'll gain the knowledge you need to pursue an archives and records career in research, business, government, academia - indeed anywhere that qualified professionals are needed. You will learn to work in a way that provides the accountability and transparency demanded for effective public administration or which meets the needs of archive users in the wider cultural and heritage environments. Assessment: At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? Archives and Record Management Diploma is certified by CPD Qualifications Standards and CiQ. 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 background. Requirements Our Archives and Record Management Diploma 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 After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Modules Getting Started 00:05:00 Understanding Records 00:10:00 Management of Records 00:20:00 Context I 00:20:00 Context II 00:15:00 Classification 00:15:00 Paper-Based Systems 00:20:00 Electronic Records 00:15:00 Hybrid Systems 00:15:00 Appraisals & Systems 00:20:00 Record Maintenance 00:20:00 Wrapping Up 00:05:00 Mock Exam Mock Exam- Archives and Record Management Diploma 00:20:00 Final Exam Final Exam- Archives and Record Management Diploma 00:20:00 Order Your Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

In the dynamic realm of Electrical Engineering, a myriad of opportunities beckons. This ever-evolving field is pivotal to our modern world and the driving force behind groundbreaking innovations, offering unparalleled career prospects for aspiring engineers. With the rise of intelligent technologies and sustainable energy solutions, expertise in Electrical Engineering has become more vital than ever. For those eager to ride this wave and harness the potential within, our curated MATLAB Simulink for Electrical Engineering bundle is your gateway. It equips learners with the essential skills and knowledge, ensuring they're well-prepared to navigate and contribute to the bright future of Electrical Engineering. Dive in and embrace the exciting challenges and rewards that await. Learners can get theoretical knowledge and skills from these eight courses to succeed in this field. Embark on your Electrical Engineering journey today. Equip yourself with industry-leading knowledge and skills. Don't miss out - enrol now and power up your future The CPD Accredited Eight Courses Are: Course 1: MATLAB Simulink for Electrical Power Engineering. Course 2: Trigonometry for Electrical Engineering. Course 3: ETAP Power System Analysis For Electrical Engineers. Course 4: PLC Programming Using Logixpro Simulator. Course 5: Digital Electric Circuits & Intelligent Electrical Devices. Course 6: Power Electronics for Electrical Engineering Course 7: Electric Circuits for Electrical Engineering. Course 8: Electrical Machines for Electrical Engineering. Learning outcomes: By Completing this MATLAB Simulink for Electrical Engineering bundle, you will be able to: Gain expertise in Electrical Power Engineering simulations. Understand core maths essential for electrical systems with our Electrical Engineering bundle. Harness ETAP for efficient system analysis with our Electrical Engineering bundle. Master automation using Logixpro Simulator. Grasp digital circuits and intelligent device applications. Delve into the design and operations of core electrical machinery. MATLAB Simulink for Electrical Power Engineering: Delve into the heart of Electrical Power Engineering simulations. This course offers theoretical knowledge with MATLAB Simulink, enabling learners to model, analyse, and design electrical systems, making it an indispensable tool for every Electrical Engineer. Trigonometry for Electrical Engineering: This specialised module demystifies the crucial mathematical principles behind electrical systems. Gain an in-depth understanding of trigonometric concepts tailored to solve real-world Electrical Engineering challenges. ETAP Power System Analysis For Electrical Engineers: Equip yourself with the mastery of ETAP, the leading power system modelling and analysis software. Dive into detailed load flow studies, fault calculations, and stability analysis, ensuring efficient system design and operations. PLC Programming Using Logixpro Simulator: Step into the world of automation with a keen focus on PLC programming. Harness the Logixpro Simulator to design, test, and optimise automated systems, which is pivotal for modern Electrical Engineering projects. Digital Electric Circuits & Intelligent Electrical Devices: Navigate the digital transformation in Electrical Engineering. Understand the principles behind digital circuitry, and explore the frontier of intelligent devices shaping the future of Electrical Engineering. Power Electronics for Electrical Engineering: Delve into the dynamic realm of power electronics. Grasp the design, analysis, and application of electronic circuits used to control and convert electric power, solidifying your expertise in this vital Electrical Engineering domain. Electric Circuits for Electrical Engineering: Build a robust foundation with this comprehensive guide to electric circuits. From basic principles to advanced circuit analysis, this course ensures you're well-prepared to design and troubleshoot in any Electrical Engineering scenario. Electrical Machines for Electrical Engineering: Embark on a journey through the core of Electrical Engineering machinery. Dive deep into the design, operation, and application of transformers, motors, and generators, ensuring a well-rounded understanding of the machines that power our world. Show off your new skills with a certificate of completion. After successfully completing the course, you can order your CPD Accredited Certificates as proof of your achievement. Please Note: The delivery charge inside the U.K. is £4.99, and international students have to pay £8.99. CPD 90 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The target audience for the MATLAB Simulink for Electrical Engineering course is: Aspiring Engineers: Beginners eager to dive into Electrical Engineering. Professionals: Experts aiming to update or broaden their skills. Students: Pursuing Electrical Engineering academically. Researchers: Seeking in-depth tools and methodologies. Innovators: Exploring Electrical Engineering for product development. Hobbyists: Passionate about electronics and electrical systems. After Completing this course, you can later enrol in these courses: Level 3 Award in the Initial Verification and Certification of Electrical Installations Level 3 Electrotechnical Qualification Requirements Without any formal requirements, you can delightfully enrol in this MATLAB Simulink for Electrical Power Engineering course. Just get a device with internet connectivity, and you are ready to start your learning journey. Thus, complete this Electrical Engineering course at your own pace. Career path Our MATLAB Simulink for Electrical Engineering course will prepare you for a range of careers, including: Electricians Junior Electrical Engineer Control Systems Engineer Power Systems Analyst Digital Circuit Designer Power Electronics Engineer

Get yourself onto the promising road of becoming a master refrigeration and air conditioning technician, learning the ins

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

Ever feel stuck in a rut? Like you're constantly saying, "one day," but never quite get there? We've all been there! That's why we created different online courses. Forget dry lectures and overwhelming textbooks. Our courses are like having a personal mentor in your pocket, guiding you with clear, bite-sized lessons that fit perfectly into your busy schedule. Imagine crushing your work goals, finally starting that dream side hustle, or unlocking a hidden talent while learning at your own pace. That's the power you get with our courses! They're packed with actionable steps and real-world examples, so you see progress fast. No more wondering, "What if?" – it's time to say, "Let's do this!" Here's the best part: You can learn from anywhere, on your commute, during your lunch break, or while chilling in your PJs. We make learning convenient and fun because who says education can't be fabulous? This 20-in-1 Ultimate Mechanical Engineer - HVAC bundle consists of the following Courses: Course 01: Level 3 Heating, Ventilation & Air Conditioning (HVAC) Technician Course 02: Heat Exchanger Course 03: PAT Level 4 Course 04: Smart Meter Installer Training Course 05: Domestic Appliance Repairing Course Course 06: Electronic & Electrical Devices Maintenance Course 07: Electrician Course 08: Digital Electric Circuits & Intelligent Electrical Devices Course 09: Electric Power Metering for Single and Three Phase Systems Course 10: Light Current Systems for Electrical Engineering Course 11: Basic AC Circuit Analysis Course 12: Electrical 3 Phase Power Transformers Fundamentals Course 13: Electrical Power System and High Voltage Engineering Course 14: Electrical Engineering for Electrical Substations Course 15: Essential Hydro Electric Power Plant Training Course 16: Energy Saving in Electric Motors Course 17: MATLAB Simulink for Electrical Power Engineering Course 18: MATLAB/Simulink for Power Electronics Simulations Course 19: Solar Energy Course 20: Protection and Control of High Voltage Power Circuits Additionally, you will get 5 other career-guided courses in this Mechanical Engineer - HVAC bundle: Course 01: Career Development Plan Fundamentals Course 02: CV Writing and Job Searching Course 03: Interview Skills: Ace the Interview Course 04: Video Job Interview for Job Seekers Course 05: Create a Professional LinkedIn Profile So, stop scrolling down and procure the skills and aptitude with Apex Learning to outshine all your peers by enrolling in this Mechanical Engineer - HVAC bundle. Learning Outcomes of Mechanical Engineer - HVAC bundle This career-oriented bundle will help you to Gain the ability to excel in the role of Mechanical Engineer - HVAC Know your responsibilities as Mechanical Engineer - HVAC and convey your experience to others Gain excellent interpersonal and communication skills Know the pros and cons of working as Mechanical Engineer - HVAC Adhere to the regulations around this area Gain time and risk management skills to ensure efficiency Manipulate technological advancement to become more effective Maintain moral standards and set an example for your peers CPD 250 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone from any background can enrol in this Mechanical Engineer - HVAC bundle. Requirements This Mechanical Engineer - HVAC course has been designed to be fully compatible with tablets and smartphones. Career path Having this expertise will increase the value of your CV and open you up to multiple job sectors. Certificates Certificate of completion Digital certificate - Included Certificate of completion Hard copy certificate - Included You will get the Hard Copy certificate for the title course (Level 3 Heating, Ventilation & Air Conditioning (HVAC) Technician) 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.

24 Hours Left! Don't Let Year-End Deals Slip Away - Enrol Now! This Diploma in Piping & Instrumentation Diagram (P&ID) Training at QLS Level 5 course is endorsed by The Quality Licence Scheme and accredited by CPDQS (with 150 CPD points) to make your skill development & career progression more accessible than ever! Are you looking to improve your current abilities or make a career move? If yes, our unique Piping & Instrumentation Diagram (P&ID) at QLS Level 5 course might help you get there! It is an expertly designed course which ensures you learn everything about the topic thoroughly. Expand your expertise with high-quality training from the Piping & Instrumentation Diagram (P&ID) at QLS Level 5 course. Due to Piping & Instrumentation Diagram (P&ID) at QLS Level 5's massive demand in the competitive market, you can use our comprehensive course as a weapon to strengthen your knowledge and boost your career development. Learn Piping & Instrumentation Diagram (P&ID) at QLS Level 5 from industry professionals and quickly equip yourself with the specific knowledge and skills you need to excel in your chosen career. The Piping & Instrumentation Diagram (P&ID) at QLS Level 5 course is broken down into several in-depth modules to provide you with the most convenient and rich learning experience possible. Upon successful completion of the Piping & Instrumentation Diagram (P&ID) at QLS Level 5 course, an instant e-certificate will be exhibited in your profile that you can order as proof of your skills and knowledge. Add these amazing new skills to your resume and boost your employability by simply enrolling in this Piping & Instrumentation Diagram (P&ID) at QLS Level 5 course. This Piping & Instrumentation Diagram (P&ID) at QLS Level 5 training can help you to accomplish your ambitions and prepare you for a meaningful career. So, join us today and gear up for excellence! Why Prefer This Piping & Instrumentation Diagram (P&ID) at QLS Level 5 Course? Opportunity to earn a certificate endorsed by the Quality Licence Scheme & another accredited by CPDQS which is completely free. Get a free student ID card! (£10 postal charge will be applicable for international delivery) Innovative and engaging content. Free assessments 24/7 tutor support. Take a step toward a brighter future! *** Course Curriculum *** Here is the curriculum breakdown of the Piping & Instrumentation Diagram (P&ID) at QLS Level 5 course: INTRODUCTION ABOUT P&ID's INTRODUCTION TO P&ID READING BASIC P&ID SYMBOLS LET'S GET SOME PRACTICE : BASIC P&ID SYMBOLS P&ID DESIGNATION CODES THE IMPORTANCE OF PROCESS CONTROL CONTROL THEORY BASICS BASIC PROCESS CONTROL SYSTEMS (BPCS) ADVANCED PROCESS CONTROL SAFETY INSTRUMENTED SYSTEMS (SIS), INTERLOCKS AND ALARMS P&ID EXAMPLES : LET'S GET SOME PRACTICE Workbook Assessment Process You have to complete the assignment questions given at the end of the course and score a minimum of 60% to pass each exam. Our expert trainers will assess your assignment and give you feedback after you submit the assignment. You will be entitled to claim a certificate endorsed by the Quality Licence Scheme after you have completed all of the Diploma in Piping & Instrumentation Diagram (P&ID) Training at QLS Level 5 exams. CPD 150 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This Piping & Instrumentation Diagram (P&ID) at QLS Level 5 course is perfect for highly motivated people who want to improve their technical skills and prepare for the career they want! Requirements No prior background or expertise is required. Career path The Piping & Instrumentation Diagram (P&ID) at QLS Level 5 course will boost your CV and aims to help you get the job or even the long-awaited promotion of your dreams. Certificates CPDQS Accredited Certificate Digital certificate - Included Diploma in Piping & Instrumentation Diagram (P&ID) Training at QLS Level 5 Hard copy certificate - Included Show off Your New Skills with a Certificate of Completion After successfully completing the Diploma in Piping & Instrumentation Diagram (P&ID) Training at QLS Level 5, you can order an original hardcopy certificate of achievement endorsed by the Quality Licence Scheme andalso you can order CPDQSAccredited Certificate that is recognised all over the UK and also internationally. The certificates will be home-delivered, completely free of cost.

24-Hour Knowledge Knockdown! Prices Reduced Like Never Before Ever wondered why your body reacts so quickly when you come into contact with a heated surface? This is because your nervous system delivers neural signals to your brain, which then communicates with your muscles. Do you want to explore more logical explanations like this of how human biology works and the biological reasons behind it? Then, enrol and start learning with our Anatomy and Physiology course. This comprehensive bundle delves into the fascinating world of anatomy and physiology. You will learn about the intricate details of the human body, from the cellular level to the complex organ systems. Additionally, you'll gain insights into medical terminology, medical transcription, and neurology, equipping you with the knowledge and skills to communicate effectively in healthcare settings and understand the intricacies of the nervous system. Courses Included in this Anatomy and Physiology Package: Course 01: Anatomy and Physiology-Level 7 Advanced Diploma Course 02: Medical Terminology and Medical Transcription: Audio Typist Course 03: Basic Biology Online Course Course 04: Neurology at QLS Level 4 Invest in your professional growth and embark on a rewarding career path that combines scientific curiosity with a passion for understanding the human body. After successfully completing this Anatomy and Physiology Diploma course, you will be able to: Describe the structure and functionality of the heart, digestive system, muscular system, nervous system, and blood and blood vessels Learn everything there is to know about the skeleton of a human Explain how brain impulses are transmitted Explain how the male and female reproductive systems function Explain the bones, sensory organs, and breathing system's structure and functioning Why Choose Us? Get a Free CPD Accredited Certificate upon completion of anatomy and physiology Get a free student ID card with anatomy and physiology Training program (£10 postal charge will be applicable for international delivery) The anatomy and physiology is affordable and simple to understand This course is entirely online, interactive lesson with voiceover audio Get Lifetime access to the anatomy and physiology course materials The anatomy and physiology comes with 24/7 tutor support Start your learning journey straightaway! This Anatomy and Physiology Diploma course covers human anatomy as well as the physiology of the neurological, skeletal, reproductive, circulatory, and other systems. We dive into the fascinating internal workings of the body, which is a vast network of interconnected systems that perform the crucial tasks that enable you to move, think, feel, and live. *** Course Curriculum *** Course 01: Anatomy and Physiology-Level 7 Advanced Diploma Module 1: The Chemistry of Cells Module 2: Cells Module 3: Cell Division Module 4: Replication and Metabolism Module 5: Human Tissues Module 6: Skin Module 7:Human Skeletal System Module 8: The Muscular System Module 9: Skeletal Muscle Fibre Module 10: Nervous System Module 11: The Brain Module 12: Nervous System-Spinal Cord and Spinal Nerves Module 13: Nervous System: Autonomic Nervous System and Cranial Nerves Module 14: Nervous System-The Eyes Module 15: Nervous System-The Ears, Hearing, and Equilibrium Module 16: Nervous System-Memory Module 17: Sensory Systems Module 18: Cardiovascular System Module 19: Blood Module 20: Lymphatics Module 21: Immune System Module 22: Digestive System Module 23: Respiratory System Module 24: Urinary System Module 25: Male Reproductive System Module 26: Female Reproductive System Course 02: Medical Terminology and Medical Transcription: Audio Typist Module 01: Human Body Vocabulary With Pictures Module 02: Equipment, Instruments And Lab Tests Module 03: Acronyms And Abbreviation Module 04: Digestive System Module 05: Cardiovascular System Module 06: Blood And Immunity System Module 07: Respiratory System Module 08: Musculoskeletal System Module 09: Central Nervous System Course 03: Basic Biology Online Course Module 01: Introduction to Biology Module 02: Characteristics, Classification and Organisation of Living Organisms Module 03: The Biosphere and Humans Module 04: The Evolution of Life Module 05: The Ecology Module 06: Cells to Organs and Function of Organs Module 07: Human Body Module 08: The Plants Course 04: Neurology at QLS Level 4 Module 01: Introduction To Neurology Module 02: Neurological Disorders Module 03: Visual Disorders Module 04: Disorders Of Hearing Module 05: Spinal Cord Disorders Module 06: Peripheral Nervous System Disorders Module 07: Child Neurology Module 08: Neurological Assessments Module 09: Medications 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*4 = £51) CPD Hard Copy Certificate: £29.99 CPD 200 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: Students seeking mastery in this field Professionals seeking to enhance their skills Anyone who is passionate about this topic 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. Nursing Medicine Therapy Research Education 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. Advanced Diploma in Anatomy and Physiology of Human Body at QLS Level 7 Hard copy certificate - £139 Please note that International students have to pay an additional £10 as a shipment fee.

Description World History Diploma The World History Diploma is an insightful online course that examines the defining moments and significant eras of human history. This comprehensive program spans from the dawn of civilization to the present day, offering a well-rounded perspective on the world's most transformative events. The World History Diploma starts by exploring the origins of human civilization, tracing the development of early societies and their impact on the course of history. Learners will discover the fascinating stories of ancient civilizations that paved the way for modern societies. This journey through the past provides a deeper understanding of how complex cultures emerged and evolved over time. As the course progresses, students will learn about the spread of Islam and its profound influence on politics, economics, and social structures. This module delves into the pivotal role of the Islamic Golden Age in shaping the world's intellectual and scientific landscape. The subsequent period of the Age of Exploration is a key focus of the course, detailing the adventures and discoveries that forever changed the map of the world. The Age of Enlightenment, a time of revolutionary ideas and unprecedented progress, is another highlight of the World History Diploma. This era saw the emergence of thinkers who questioned traditional norms and laid the foundations for modern democracy, human rights, and scientific inquiry. Learners will study the powerful movements that led to the establishment of new political systems and the shaping of the world as we know it today. The course further covers the Industrial Revolution, a transformative period that witnessed the rise of urbanization, industrialization, and economic growth. Participants will learn how technological innovations spurred societal changes and altered the trajectory of global development. The World History Diploma also delves into the two World Wars that had far-reaching consequences for nations and people alike. These events were instrumental in shaping the geopolitical landscape and redefining global power dynamics. The aftermath of the wars gave rise to the Cold War, a time of intense political rivalry and ideological conflict. This section explores the impact of the Cold War on international relations and global stability. The course concludes with an examination of globalization, a phenomenon that has connected the world in unprecedented ways. Learners will discover how globalization has affected economic, political, and social systems worldwide. The final module takes a look at the future of the world, exploring the challenges and opportunities that lie ahead. The World History Diploma is a rich and engaging online course that provides learners with a well-rounded understanding of the world's past, present, and future. This immersive program is designed for individuals with a passion for history, offering them the opportunity to learn from the comfort of their own homes. With the World History Diploma, students can explore the significant events that have shaped humanity and gain valuable insights into the world around them. The World History Diploma offers a comprehensive journey through time, taking learners on a captivating exploration of human history. Whether you're a history enthusiast or seeking to broaden your knowledge, the World History Diploma is a valuable resource that provides a deeper understanding of the world we live in today. What you will learn 1:The Origins of Human Civilization 2:Ancient Civilisations 3:The Spread of Islam 4:The Age of Exploration 5:The Age of Enlightenment 6:The Industrial Revolution 7:The World Wars 8:The Cold War 9:Globalization 10:The Future of the World Course Outcomes After completing the course, you will receive a diploma certificate and an academic transcript from Elearn college. Assessment Each unit concludes with a multiple-choice examination. This exercise will help you recall the major aspects covered in the unit and help you ensure that you have not missed anything important in the unit. The results are readily available, which will help you see your mistakes and look at the topic once again. If the result is satisfactory, it is a green light for you to proceed to the next chapter. Accreditation Elearn College is a registered Ed-tech company under the UK Register of Learning( Ref No:10062668). After completing a course, you will be able to download the certificate and the transcript of the course from the website. For the learners who require a hard copy of the certificate and transcript, we will post it for them for an additional charge.

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.

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