17238 Other courses in Cardiff delivered Online

Boost Your Career with Apex Learning and Get Noticed By Recruiters in this Hiring Season! Get Hard Copy + PDF Certificates + Transcript + Student ID Card worth £160 as a Gift - Enrol Now Give a compliment to your career and take it to the next level. This GIS: QGIS Cartography will provide you with the essential knowledge and skills required to shine in your professional career. Whether you want to develop skills for your next job or want to elevate skills for your next promotion, this GIS: QGIS Cartography will help you keep ahead of the pack. The GIS: QGIS Cartography incorporates basic to advanced level skills to shed some light on your way and boost your career. Hence, you can reinforce your professional skills and essential knowledge, reaching out to the level of expertise required for your position. Further, this GIS: QGIS Cartography will add extra value to your resume to stand out to potential employers. Throughout the programme, it stresses how to improve your competency as a person in your profession while at the same time it outlines essential career insights in this job sector. Consequently, you'll strengthen your knowledge and skills; on the other hand, see a clearer picture of your career growth in future. By the end of the GIS: QGIS Cartography, you can equip yourself with the essentials to keep you afloat into the competition. Along with this GIS: QGIS Cartography course, you will get 10 other premium courses. Also, you will get an original Hardcopy and PDF certificate for the title course and a student ID card absolutely free. This GIS: QGIS Cartography Bundle Consists of the following Premium courses: Course 01: QGIS Cartography Course 02: Architectural Studies Course 03: Land Surveying Course 04: Drawing and Illustration Level 2 Course 05: Digital Art - Sketching In Photoshop Course 06: Course 07: Ultimate Geology Course Course 08: Egyptology Course 09: Archaeology Course 10: Military History Course 11: Learn to Use Python for Spatial Analysis in ArcGIS So, enrol now to advance your career! Benefits you'll get choosing Apex Learning: One payment, but lifetime access to 11 CPD courses Certificates, student ID for the title course included in a one-time fee Full tutor support available from Monday to Friday Free up your time - don't waste time and money travelling for classes Accessible, informative modules taught by expert instructors Learn at your ease - anytime, from anywhere Study the course from your computer, tablet or mobile device CPD accredited course - improve the chance of gaining professional skills Curriculum of Bundle Course 01: QGIS Cartography Section 01: Introduction Section 02: Labels Section 03: Symbology Section 04: Base Layers Section 05: Project Setup Section 06: Water Styling Section 07: Land Styling =========>>>>> And 10 More Courses <<<<<========= How will I get my Certificate? After successfully completing the course you will be able to order your CPD Accredited Certificates (PDF + Hard Copy) as proof of your achievement. PDF Certificate: Free (Previously it was £6*11 = £66) Hard Copy Certificate: Free (For The Title Course: Previously it was £10) If you want to get hardcopy certificates for other courses, generally you have to pay £20 for each. But this Fall, Apex Learning is offering a Flat 50% discount on hard copy certificates, and you can get each for just £10! P.S. The delivery charge inside the U.K. is £3.99 and the international students have to pay £9.99. CPD 110 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone from any background can enrol in this GIS: QGIS Cartography bundle. Requirements This GIS: QGIS Cartography 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 (QGIS Cartography) 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.

Fall into Savings. Enjoy the biggest price fall this Autumn! Life Just Got Better This Summer! Get Hard Copy + PDF Certificates + Transcript + Student ID Card + e-Learning App as a Gift - Enrol Now Tired of browsing and searching for the course you are looking for? Can't find the complete package that fulfils all your needs? Then don't worry as you have just found the solution. Take a minute and look through this 14-in-1 extensive bundle that has everything you need to succeed in Marine Biology and other relevant fields! After surveying thousands of learners just like you and considering their valuable feedback, this all-in-one Marine Biology bundle has been designed by industry experts. We prioritised what learners were looking for in a complete package and developed this in-demand Marine Biology course that will enhance your skills and prepare you for the competitive job market. Also, our Marine Biology experts are available for answering your queries and help you along your learning journey. Advanced audio-visual learning modules of these courses are broken down into little chunks so that you can learn at your own pace without being overwhelmed by too much material at once. Furthermore, to help you showcase your expertise in Marine Biology, we have prepared a special gift of 1 hardcopy certificate and 1 PDF certificate for the title course completely free of cost. These certificates will enhance your credibility and encourage possible employers to pick you over the rest. This Marine Biology Bundle Consists of the following Premium courses: Course 01: Marine Biology Course - Online Diploma Course 02: Diploma In Microbiology Course 03: Diploma in Water Chemistry Course 04: Diploma in Water Treatment Course 05: Environmental Law Course 06: Environmental Health Course 07: Basic Biology Course Course 08: Biochemistry Course 09: Biotechnology Course 10: Genetics Course 11: Lab Analyst Training Course 12: Carbon Literacy Knowledge | Course Course 13: Process Improvement: Reduce Waste Course 14: Infection Prevention Training Curriculum: Course 01: Marine Biology Course - Online Diploma Introduction The Ocean The Ocean as a Habitat Characteristics of the Marine Environment Marine Life Marine Microbes Marine Invertebrates Marine Vertebrates Marine Populations and Communities Marine Ecology Food Chains and Food Webs Damaging Impact of Human Activities on Marine Life Marine Conservation ---------- Other Courses Are ---------- Course 02: Diploma In Microbiology Course 03: Diploma in Water Chemistry Course 04: Diploma in Water Treatment Course 05: Environmental Law Course 06: Environmental Health Course 07: Basic Biology Course Course 08: Biochemistry Course 09: Biotechnology Course 10: Genetics Course 11: Lab Analyst Training Course 12: Carbon Literacy Knowledge | Course Course 13: Process Improvement: Reduce Waste Course 14: Infection Prevention Training How will I get my Certificate? After successfully completing the course you will be able to order your CPD Accredited Certificates (PDF + Hard Copy) as proof of your achievement. PDF Certificate: Free (For The Title Course) Hard Copy Certificate: Free (For The Title Course) CPD 145 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone from any background can enrol in this Marine Biology bundle. Requirements Our Marine Biology course is fully compatible with PCs, Macs, laptops, tablets and Smartphone devices. Career path Having this Marine Biology 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 (Marine Biology Course - Online Diploma) absolutely Free! Certificate of completion Hard copy certificate - Included You will get the Hard Copy certificate for the title course (Marine Biology Course - Online Diploma) 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.

Boost Your Career with Apex Learning and Get Noticed By Recruiters in this Hiring Season! Get Hard Copy + PDF Certificates + Transcript + Student ID Card worth £180 as a Gift - Enrol Now Give a compliment to your career and take it to the next level. This Catheterisation Training for Nurse/Carer will provide you with the essential knowledge and skills required to shine in your professional career. Whether you want to develop skills for your next job or want to elevate skills for your next promotion, this Catheterisation Training for Nurse/Carer will help you keep ahead of the pack. The Catheterisation Training for Nurse/Carer incorporates basic to advanced level skills to shed some light on your way and boost your career. Hence, you can reinforce your professional skills and knowledge, reaching out to the level of expertise required for your position. Further, this Catheterisation Training for Nurse/Carer will add extra value to your resume to stand out to potential employers. Throughout the programme, it stresses how to improve your competency as a person in your profession while at the same time it outlines essential career insights in this job sector. Consequently, you'll strengthen your knowledge and skills; on the other hand, see a clearer picture of your career growth in future. By the end of the Catheterisation Training for Nurse/Carer, you can equip yourself with the essentials to keep you afloat into the competition. Along with this Catheterisation Training for Nurse/Carer course, you will get 10 other premium courses. Also, you will get an original Hardcopy and PDF certificate for the title course and a student ID card absolutely free. What other courses are included with this Catheterisation Training for Nurse/Carer? => Course 01: Adult Nursing Diploma => Course 02: Diabetes Care Diploma => Course 03: Phlebotomy Diploma => Course 04: Medical Law => Course 05: Medication Administration Level 4 => Course 06: Medical Transcription => Course 07: Wound Care Level 2 => Course 08: Nutrition and Diet Awareness => Course 09: Infection Prevention Training => Course 10: Personal Hygiene As one of the top course providers in the UK, we're committed to providing you with the best educational experience possible. Our industry experts have designed the Catheterisation Training for Nurse/Carer to empower you to learn all at once with accuracy. You can take the course at your own pace - anytime, from anywhere. So, enrol now to advance your career! Benefits you'll get choosing Apex Learning for this Catheterisation Training for Nurse/Carer: One payment, but lifetime access to 11 CPD courses Certificate, student ID for the title course included in a one-time fee Full tutor support available from Monday to Friday Free up your time - don't waste time and money travelling for classes Accessible, informative modules taught by expert instructors Learn at your ease - anytime, from anywhere Study the course from your computer, tablet or mobile device CPD accredited course - improve the chance of gaining professional skills How will I get my Certificate? After successfully completing the course you will be able to order your CPD Accredited Certificates (PDF + Hard Copy) as proof of your achievement. PDF Certificate: Free (Previously it was £10 * 11 = £110) Hard Copy Certificate: Free (For The Title Course) If you want to get hardcopy certificates for other courses, generally you have to pay £20 for each. But this Fall, Apex Learning is offering a Flat 50% discount on hard copy certificates, and you can get each for just £10! P.S. The delivery charge inside the U.K. is £3.99 and the international students have to pay £9.99. The Course Curriculum of The Catheterisation Training for Nurse/Carer Bundle => Course 01: Clinical Training for Nurses and Carers - Catheterisation Module 1: Introduction Module 2: The Urinary System Module 3: Patients' Guide for Catheterisation Module 4: Guidance for Nursing and Care Staff Module 5: Protocol for Female Catheterisation Module 6: Protocol for Male Catheterisation Module 7: Protocol for Handling Catheter & Catheter Bags => Course 02: Adult Nursing Diploma Module1: Introduction to Nursing Module 2: Working in Different Healthcare Settings Module 3: Understanding legal, professional standards of practice and ethical aspects of health care- Part 1 Module 4: Understanding legal, professional standards of practice and ethical aspects of health care- Part 2 Module 5: Effective Communication in Nursing Module 6: Health and Safety in Nursing Module 7: Hygiene in Nursing Module 8: Infection Control Module 9: Asepsis in Nursing Module 10: Medication Administration in Nursing Module 11: Adult Care in Different Life Stages Module 12: Understanding Immune System in Nursing Module 13: Rest and Sleep Management in Nursing Module 14: Mobility and Immobility Issues of Patients in Nursing Module 15: Pain Management for Nurses Module 16: Nutrition in Nursing Module 17: Fluid and Electrolyte Balance Module 18: Assisting with Elimination Module 19: Oxygenation in Nursing => Course 03: Diabetes Care Diploma Module 01: What is Diabetes Module 02: The Diabetes Challenge Module 03: The Cost of Diabetes in Social Care Module 04: Type 1 Diabetes Module 05: Type 2 Diabetes Module 06: Type 2 Diabetes Treatments Module 07: Prediabetes Module 08: Gestational Diabetes Module 09: Other Types of Diabetes Module 10: Hypoglycaemia Module 11: Hyperglycaemia and Hyperosmolar Hyperglycaemic State Module 12: Glossary of Diabetes Terms => Course 04: Phlebotomy Diploma Module 01: Introduction to Phlebotomy Module 02: Blood Circulation, Function, and Composition Module 03: Phlebotomy Equipment Module 04: Routine Venipuncture Module 05: Venipuncture Complications and Pre-Examination Variables Module 06: Dermal Puncture Module 07: Quality Assessment and Management in Phlebotomy Module 08: Special Blood Collection Procedure Module 09: Infection Control and Risk Management => Course 05: Medical Law Module 01- An Introduction to Medical Law Module 02- Legislation on Access to Health, Medical Report, Treatment Module 03- Legislation on Adult Support Module 04- Legislation on Public Health and Health Service (Part 1) Module 05- Legislation on Public Health and Health Service (Part 2) Module 06- Legislation on Public Health and Health Service (Part 3) Module 07- Legislation on Public Health and Health Service (Part 4) Module 08- Legislation on Coronavirus Module 09- Legislation on Mental Health (Part 1) Module 10- Legislation on Mental Health (Part 2) Module 11- Legislation on Abortion Module 12- Other Legislation (Part 1) Module 13- Other Legislation (Part 2) => Course 06: Medication Administration Level 4 Module 01: Introduction to Safe Handling of Medicines Module 02: Legislation and guidance of medication management Module 03: Principles of Safe and Appropriate Handling of Medicines Module 04: Medication Risk Assessment Guidance Module 05: Handling Medicines in Social Care Settings Module 06: Consent to Treatment Module 07: Requirements for Specific Services Module 08: Levels of Care and Support Module 09: Procedure for Handling Medication Module 10: The Six Rights of Medication Administration Module 11: Covert Administration of Medication Module 12: Recording Procedures Module 13: Storage of Medication Module 14: Transfer and Disposal of Medication Module 15: Drug Formulation and Ways of Taking It => Course 07: Medical Transcription Module 01: Introduction to Medical Transcription Module 02: The What, How, Who and Why of Medical Transcription Module 03: Understanding Medical Reports Module 04: Medical Language Boot Camp Module 05: Formatting: The Basics Module 06: Data Protection => Course 08: Wound Care Level 2 Module 01: The Wound Healing Process & Factors Delaying Wound Healing Module 02: Types of Wounds and Their Treatment Module 03: Dressing Module 04: Wound Assessment Module 05: Glossary => Course 09: Nutrition and Diet Awareness Overview Nutritional Details What to Avoid & Problem Areas Beyond Food Putting It All Together => Course 10: Infection Prevention Training Module 01: Infection Prevention and Control Policy in the UK Module 02: Principles of Prevention and Control of Infection Module 03: Immunization Module 04: Infections Spread by Food and Water Module 05: Infections Spread by Animals and Insects, and Less Common Infections Found in the UK Module 06: Infections & Diseases Spread by Person-to-Person Contact Module 07: Infections Spread by Sexual Contact Module 08: Infections Spread by Blood and Body Fluids => Course 11: Personal Hygiene Module 01: Introduction to Personal Hygiene and a Brief History Module 02: Looking Clean, Smelling Clean Module 03: Improving and Maintaining Oral Health Module 04: Care of the Eyes Module 05: Ear Care Secrets Module 06: Foot & Nail Care in Personal Hygiene Module 07: Hair Care Hygienic Ways Module 08: Hygienic Approach to Skin Care Module 09: Maintain Good Toilet Hygiene Module 10: Potential Hygiene Guidelines Module 11: Personal Hygiene During Coronavirus Pandemic Take control of your healthcare career by enrolling in the Catheterisation Training for Nurse/Carer Bundle today! CPD 110 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone from any background can enrol in this Catheterisation Training for Nurse/Carer 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. Please note: This course doesn't entitle you to practice as a professional in this specific field. Rather, this course will assist you in understanding the fundamentals so that you can improve your knowledge in the relevant field. Requirements Our Catheterisation Training for Nurse/Carer is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so 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 Catheterisation Training for Nurse/Carer bundle will increase the value of your CV and open you up to multiple job sectors: Practice Nurse: £30,000 - £45,000 Community Nurse: £25,000 - £35,000 Hospital Nurse: £27,000 - £37,000 Clinical Nurse Specialist: £35,000 - £45,000 Catheterisation Specialist Nurse: £40,000 - £50,000 Advanced Practice Nurse: £45,000 - £55,000 Certificates CPDQS Accredited e-Certificate Digital certificate - Included CPDQS Accredited Hard-Copy Certificate Hard copy certificate - Included You will get the Hard Copy certificate for the title course (Clinical Training for Nurses and Carers - Catheterisation) 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.

Why Choose 3ds Max Basic to Intermediate Training Course? Course info Looking to take your 3D modelling and animation skills to the next level then Our Intermediate 3DS Max course is designed to help you do just that! A bespoke course ideal for anyone who has a solid understanding of modelling in the 3D environment for films & games. Duration: 20 hrs Method: 1-on-1, Personalized attention. Schedule: Tailor your own schedule and hours of your choice, available from Mon to Sat between 9 am and 7 pm. Why Opt for Our 3ds Max Basic to Intermediate Course? Elevate your 3D modeling and animation skills with our tailored Intermediate 3DS Max course, perfect for those proficient in 3D modeling for films and games. 3ds Max Interface: Familiarize yourself with essential interface areas, tool names, and shortcuts. Master the Scene Explorer for comprehensive scene control. Learn initial software settings for an efficient workflow. Organize your project folder for streamlined work management. Enhance workflow through scene navigation shortcuts and visual styles setup. Understand scene unit configuration for precision. Foundations of 3D Modeling: Acquire industry-standard 3D modeling techniques. Implement compositing modeling with procedural geometry. Utilize non-destructive methods via Modifiers to enhance base geometries. Create 3D models using Splines and modifiers like Extrude, Sweep, and Lathe. Explore Boolean operations for complex shape creation. Delve into Mesh Modeling, enabling manual mesh editing for customized objects. Mesh Modeling: Navigate mesh modeling tools in 3ds Max. Model hard surface objects using mesh modeling and other techniques. Unleash creativity in modeling various objects. Material Creation and Application: Understand material basics and texture application. Create, apply, and resize materials on models. Utilize pictures as references for modeling. Apply multiple materials to one object. Incorporate transparency, reflection, and self-illuminating textures. Utilize images with transparency for intricate texture designs. Camera Control Techniques: Learn camera creation and viewpoint adjustment. Modify camera focal length and lock settings for stability. Adjust camera exposure for desired image brightness. Explore cameras with and without targets, understanding their differences. Lighting: Create realistic lighting using daylight systems. Fine-tune daylight settings based on geographical location. Optimize render settings for high-quality output. Utilize various light types for interior illumination. Master light distribution and apply color filters and textures. Implement HDRI environment images for realistic lighting effects. Animation Essentials: Gain a basic understanding of animation principles. Animate objects manually through keyframing. Create walkthrough animations using cameras and paths. Construct efficient camera rigs for path-based animations. Render animations as video output. Advanced Rendering Techniques: Explore rendering with V-Ray Simulate daylight systems and interior lighting in V-Ray Set up studio lighting configurations in both V-Ray advanced rendering. Course Requirements: A computer with 3ds Max and Vray installed (trial versions available on Autodesk and Chaos Group websites) Basic familiarity with 3D modeling concepts is beneficial but not mandatory Enthusiasm for learning 3ds Max and Vray to create impressive 3D models, visualizations, and animations

2 QLS Endorsed Course | CPD Certified | Free PDF + Hardcopy Certificates | 80 CPD Points | Lifetime Access

2 QLS Endorsed Course | CPD Certified | Free PDF + Hardcopy Certificates | 80 CPD Points | Lifetime Access

This course uses a non-traditional approach that improves all 4 Language Skills using materials from the students' own school courses. The training also focuses on examination techniques.

Description Precious Metals Investing Diploma   Precious metals are treasured metal varieties that are rarely found in nature. Their rarity makes them expensive and extraordinary compared to other kinds of metal. Even in the current market, they are valued and are used as art, jewellery, investments, and other forms of commodities. Unlike common metals, precious metals possess higher lustre, no reactivity, and higher flexibility. These qualities make precious metals unique compared to commonly found metals. Due to these reasons, precious metals gain higher prices than standard varieties. The Precious Metals Investing Diploma course introduces silver and gold as investment materials. Afterwards, the Precious Metals Investment Diploma course focuses on why these metals are considered precious and lucrative by investors. By the end of this Precious Metals Investing Diploma course, the student will understand the market for silver and gold and how they can be suitable investments. The Precious Metals Investing Diploma course states five significant silver and gold investment methods. It also presents ten drivers that determine the silver and gold prices. The Diploma course in Precious Metals Investment covers the fundamentals of the field. It can be helpful for amateur investors and enthusiasts of precious metals. Silver and gold are considered valuable worldwide and have been much sought-after since antiquity. Even today, they have a place in most knowledgeable investors' portfolios. However, a significant question is which precious metals can be the most profitable. And what is the reason behind its unpredictability? There are several methods to invest in precious metals, such as silver, platinum, and gold, and various reasons to get involved in this treasure hunt. So, if one is just a newbie to the precious metals market, one undertakes a thorough reading on the subject. What you will learn   1: Precious Metals 2: Gold and Silver  3: Platinum and Palladium  4: Uranium and Base Metals  5: Buying Metals  6: Mining Stocks  7: Mutual funds and ETFs  8: Futures and Options  9: Investment Strategies  10: Tips for Effective Investing  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.

Duration 1 Days 6 CPD hours This course is intended for This course is intended for people who use PowerPoint for their business communication needs. Overview To ensure your success in this course, you should have end-user skills with any current version of Windows, including being able to open and close applications, navigate basic file structures, and manage files and folders. This course is intended for those who wish to take advantage of the application for high quality business presentations and reports. Presentations Create Attractive Presentations from Existing PowerPoint Templates Creating Presentations Quickly using Outline to build a Structure Incorporating and reusing slides from other presentations into your own Templates and Customization Using Slide Layouts Using the Slide Master Creating Custom Slide Layout Working with Charts and Tables Create and Modify Tables Create Charts and Graphs Copying Charts into PowerPoint Link Vs Embed Add Visual Elements to a Presentation Create and Modify Shapes Add Images Create SmartArt to Make Easily Modifiable graphics Use SmartArt to Give Dull Text a More Visual Appeal Working with Media and Animation Add Audio to A Presentation Add Video to A Presentation Add and Customize Animations Add and Customize Transitions Preparing to Present Add Notes to A Presentation Presenter View And Slide Show Controls Create A Custom Slide Show Saving and Sharing the Presentation Printing Options and Handouts Additional course details: Nexus Humans Microsoft PowerPoint for the Business User training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the Microsoft PowerPoint for the Business User course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

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