1575 Running courses in Cardiff delivered Online

Medical & Clinical Administration: Medical & Clinical Administration Course Online Most medical and clinical administrators' work is done behind the scenes. Nonetheless, their significance in the healthcare industry cannot be overstated. They are in charge of the strings that keep the system running smoothly. With this Medical & Clinical Administration: Medical & Clinical Administration Course, you can start a promising career in this in-demand industry. This Medical & Clinical Administration: Medical & Clinical Administration Course is designed by industry experts to provide you with a thorough understanding of the subject. The Medical & Clinical Administration: Medical & Clinical Administration Course covers the fundamentals of Medical and Clinical Administration, Organize Schedules, Effective Filing Systems in Medical Offices, Maintaining Medical Records, Confidentiality in a Medical Environment, Medical Jargon and Terminology, Medical (Clinical) Coding and Billing and much more. Whether you are an aspirant looking to begin your dream career, a professional looking to increase your knowledge, or someone in between, this Medical & Clinical Administration: Medical & Clinical Administration Course has you covered. This course's rudimentary knowledge will add tremendous value and allow you to establish the meaningful Medical & Clinical Administration career you have always wanted. Special Offers of this Medical & Clinical Administration: Medical & Clinical Administration Course This Medical & Clinical Administration: Medical & Clinical Administration Course includes a FREE PDF Certificate. Lifetime access to this Medical & Clinical Administration: Medical & Clinical Administration Course Instant access to this Medical & Clinical Administration: Medical & Clinical Administration Course Get FREE Tutor Support from Monday to Friday in this Medical & Clinical Administration: Medical & Clinical Administration Course Courses are included in this Medical & Clinical Administration: Medical & Clinical Administration Course Course 01: Medical & Clinical Administration Course 02: Level 3 Diploma in Healthcare Support Course 03: Level 2 Certificate in Understanding Safeguarding and Prevent Course 04: Level 2 Health & Care Course 05: Healthcare Management Training Course 06: Clinical Psychology Diploma Other Benefits of Medical & Clinical Administration: Medical & Clinical Administration Course Free 6 PDF Certificate Lifetime Access Free Retake Exam Tutor Support [ Note: Free PDF certificate as soon as completing the Medical & Clinical Administration: Medical & Clinical Administration Course] Medical & Clinical Administration: Medical & Clinical Administration Course Online Industry Experts Designed This Medical & Clinical Administration: Medical & Clinical Administration Course into 10 detailed modules. Course Curriculum of Medical & Clinical Administration Course Module 01: An Overview of Medical and Clinical Administration Module 02: Ways of Organising Schedules Module 03: How to Maintain Medical Records Module 04: Understanding the Filing Systems in Medical Offices Module 05: Maintaining Confidentiality in a Medical Environment Module 06: The Ways of Controlling Stocks and Supplies Module 07: Medical Jargon and Terminology Module 08: Ensuring Safety at Workplace Module 09: The Use of Information Technology in Health Care Module 10: Medical (Clinical) Coding and Billing Assessment Method of Medical & Clinical Administration Course After completing each module of the Medical & Clinical Administration: Medical & Clinical Administration Course, you will find automated MCQ quizzes. To unlock the next module, you need to complete the quiz task and get at least 60% marks. Certification of Medical & Clinical Administration Course After completing the MCQ/Assignment assessment for this Medical & Clinical Administration: Medical & Clinical Administration Course, you will be entitled to a Certificate of Completion from Training Tale. The certificate is in PDF format, which is completely free to download. A printed version is also available upon request. It will also be sent to you through a courier for £13.99. Who is this course for? Medical & Clinical Administration: Medical & Clinical Administration Course Online This Medical & Clinical Administration: Medical & Clinical Administration Course is designed for people who want to gain an accredited qualification that will allow them to start or advance their careers in Medical Reception and Medical Administration roles. Requirements Medical & Clinical Administration: Medical & Clinical Administration Course Online Students who intend to enroll in this Medical & Clinical Administration: Medical & Clinical Administration Course must meet the following requirements: Medical & Clinical Administration: Good command of the English language. Medical & Clinical Administration: Must be vivacious and self-driven Medical & Clinical Administration: Basic computer knowledge. Medical & Clinical Administration: A minimum of 16 years of age is required Career path Medical & Clinical Administration: Medical & Clinical Administration Course Online This qualification Medical & Clinical Administration: Medical & Clinical Administration Course will allow you to pursue a variety of careers, including: Healthcare Administrator GP Receptionist Patient Coordinator Medical Assistant Medical Receptionist Certificates Certificate of completion Digital certificate - Included

The British Cleaning Training Diploma is an essential course for anyone interested in building a successful career in the cleaning industry. This QLS Endorsed course offers a deep dive into the fundamental principles and techniques of cleaning, ensuring that participants gain a thorough understanding of industry standards. From health and safety regulations to effective cleaning methods, this course equips learners with the knowledge required to excel in a variety of cleaning roles. Whether you're looking to get started or enhance your expertise, this diploma provides a well-rounded foundation for success. With a focus on the UK cleaning sector, this course addresses key topics such as environmental concerns, sustainable practices, and the latest cleaning technologies. Learners will explore different types of cleaning environments, from domestic to commercial, and understand the varying needs of each. By completing the British Cleaning Training Diploma, you'll be prepared to navigate the ever-evolving landscape of the cleaning industry, offering your services with confidence. With no requirement for physical attendance, the course can be completed at your own pace, offering flexibility and convenience for those balancing other commitments. This QLS Bundle Includes the following Courses Course 01: Diploma in British Cleaning Training at QLS Level 5 Course 02: Spill Management Course 03: Working at Heights and Confined Space Course 04: Workplace First Aid Training Course 05: Personal Hygiene Course Key Features: Eligibility for QLS endorsed certificate upon successful completion of the British Cleaning Training Diploma course Free CPD Accredited Course Fully online, interactive course with audio voiceover Self-paced learning and laptop, tablet, smartphone-friendly 24/7 Learning Assistance Discounts on bulk purchases Course Curriculum: Diploma in British Cleaning Training at QLS Level 5 Module 1: An Introduction to the Cleaning Job Module 2: The Diversity of Cleaning Jobs Module 3: Cleaning Equipment, Products and Clothing Module 4: House Cleaning Module 5 Food Kitchen and Commercial Kitchen Cleaning Module 6 Bathrooms and Toilets Module 7 Office Cleaning Module 8 Cleaning External Surfaces and Areas Module 9 Dealing with Non-Routine Waste Module 10 Chemical Safety, Keyholding and Alarm Codes for Cleaners Module 11 Starting a Cleaning Business and Planning for it Module 12 Running the Business with Quality Service Module 13 Customer Satisfaction Module 14 Management of Staff Module 15 Marketing, Advertising and Sales Module 16 Expansion Management Module 17 Business Insurance, Tax and Additional Equipment Spill Management Module 01: Introduction to Spill Management Module 02: Hazardous Substances Module 03: Pollution Incident Response Planning Module 04: Managing a Spill Module 05: Spill Clean-Up Guideline Module 06: Spills on a Road or Highway Module 07: Diesel Spillages: An Overview Module 08: Site-Specific Pollution Control Options Module 09: Spill Prevention & Control Checklist Module 10: Ways to Encourage Best Practice Working at Heights and Confined Space Module 1: Introduction, Regulations and Duties Module 2: Assessment and Prevention of the Risks Module 3: Work at Height Equipment Module 4: Working in Confined Spaces and the Laws Module 5: Risk Assessment Module 6: Control Measures Module 7: Emergency Procedures Workplace First Aid Training Module 01: Introduction to Workplace First Aid Module 02: Legal Framework for Workplace First Aid Module 03: Incident Management at Work Module 04: Primary Survey Module 05: Secondary Survey Module 06: Basic First-Aid Techniques Module 07: Dealing with Minor Injuries at the Workplace Module 08: Secondary Illness Loss of Responsiveness and CPR Module 09: Secondary Illness Breathing Problems Module 10: Secondary Illnesses and Injuries Module 11: Dealing With Fractures and Dislocations Module 12: Call for an Emergency Personal Hygiene Course 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 Learning Outcomes: Gain comprehensive knowledge of diverse jobs and environments. Master the use of equipment, products, and safety attire. Develop expertise in specialized areas like kitchen, office, and external surface. Acquire spill management skills, including handling hazardous substances and pollution incidents. Demonstrate competence in working at heights and confined spaces, ensuring regulatory compliance. Attain proficiency in workplace first aid, from incident management to CPR and emergency procedures. To become successful in your profession, you must have a specific set of skills to succeed in today's competitive world. In this in-depth course, you will develop the most in-demand skills to kickstart your career, as well as upgrade your existing knowledge & skills. Assessment At the end of this course, we will provide assignment and quizzes. For each test, the pass mark will be set to 60%. Accreditation This course is QLS - Quality Licence Scheme Endorsed and CPD Certified, providing you with up-to-date skills and knowledge and helping you to become more competent and effective in your chosen field. Certification CPD Certified: Once you've successfully completed your course, you will immediately be sent a digital certificate. Also, you can have your printed certificate delivered by post (shipping cost £3.99). QLS Endorsed: After successfully completing this course, learners will be able to order an endorsed certificate, titled: Diploma in British Cleaning Training at QLS Level 5, as proof of their achievement. This certificate of achievement endorsed by the Quality Licence Scheme. CPD 50 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This course is ideal for all employees or anyone who genuinely wishes to learn more about this topic, including: Individuals aspiring to enter the industry. Entrepreneurs planning to start a business. Those interested in spill management and environmental safety. Individuals aiming to pursue careers in workplace first aid. Requirements No prior degree or experience is required to enrol in this course. Career path This Course will help you to explore a variety of career paths in the related industry. Cleaning Supervisor - £20K to 30K/year. Environmental Safety Officer - £25K to 35K/year. Workplace First Aid Trainer - £22K to 28K/year. Business Owner (Cleaning Services) - £25K to Certificates Digital certificate Digital certificate - Included Hardcopy Certificate Hard copy certificate - Included Hardcopy Certificate (UK Delivery): For those who wish to have a physical token of their achievement, we offer a high-quality, printed certificate. This hardcopy certificate is also provided free of charge. However, please note that delivery fees apply. If your shipping address is within the United Kingdom, the delivery fee will be only £3.99. Hardcopy Certificate (International Delivery): For all international addresses outside of the United Kingdom, the delivery fee for a hardcopy certificate will be only £10.

CPD Accredited | Career Oriented Learning Modules | 24x7 Tutor Support | Lifetime Access

Duration 3 Days 18 CPD hours This course is intended for IT professionals who support a Cisco ACI data center network, including: Data center engineers Field engineers Network engineers Systems engineers Overview After taking this course, you should be able to: Operationalize and troubleshoot the ACI fabric Understand Cisco Application Policy Infrastructure Controller (APIC) and its monitoring, management, and troubleshooting capabilities Avoid common mistakes and recognize common symptoms The Cisco Application Centric Infrastructure Operations and Troubleshooting (DCACIO) v1.0 course shows you how to operate and troubleshoot Cisco© data center network infrastructure running Cisco ACI. Through expert instruction and hands-on practice, you will learn about operational tools, and best practices and caveats for configuration management, performance tracking, and more. You will practice troubleshooting common issues on a live fabric. Based on lessons learned in over 100 production deployments, this course gives you the real-world knowledge and skills to boost operational efficiencies in your own deployment. Course Outline ACI Overview and Configuration Review ACI Configuration Management Installing, Upgrading, Backing Up, and Restoring ACI Fabric Monitoring ACI Always-On and On-Demand Monitoring Tools Exercises: Visore, CLI Commands, Audit Logs, Traffic Map Troubleshooting ACI Methodologies, Tools, and Specific Examples Exercises: iPing, End Point Tracker, Troubleshooting Tool, Contract Drops, Contracts, Traceroute, Atomic Counters Additional course details: Nexus Humans Cisco ACI Operations and Troubleshooting Boot Camp (DCACIO) 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 Cisco ACI Operations and Troubleshooting Boot Camp (DCACIO) 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.

Duration 2 Days 12 CPD hours This course is intended for This course is intended for anyone who is responsible for day-to-day management of many FortiGate devices via the FortiManager platform. Overview Describe capabilities of FortiManager Add FortiGate devices to Device Manager and import their running configuration Use provisioning templates and scripts for device-level changes across many devices Identify the synchronization states Manage the revision history of managed devices Offer a local FortiGuard Distribution Server to your Fortinet devices Deploy administrative domains (ADOMs) to support multiple customers on a single FortiManager Manage firewall policies across multiple FortiGate devices using policy packages with shared and dynamic objects Deploy policies and objects from the global ADOM to multiple ADOMs Explain high availability, backup, and recovery options for FortiManager Compare methods for centrally managing IPsec VPNs Explain the restricted ''admin'' profile and API high-level usage Use workspaces and workflow mode Identify steps to replace a managed FortiGate device Manage FortiGate devices' firmware centrally In this 2-day class, you will learn the fundamentals of using FortiManager for centralized network administration of many FortiGate devices. Example use cases include large enterprise and carrier networks. Course Outline Module1 - Introduction and Initial Configuration Module2 - Administration and Management Module3 - Device Registration Module4 - Device Level Configuration and Installation Module5 - Policy and Objects Module6 - Manager Panes Module7 - Diagnostics and Troubleshooting Module8 - Advanced Configuration Additional course details: Nexus Humans FortiManager 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 FortiManager 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.

Learn to fully utilize your Computer with the help of this Course If you are a little weak when it comes to understanding how computer works then don't worry. This course will feed you some of the most important information about a computer, its operating system. An operating system is the most important software that runs on a computer. It manages the computer's memory and processes, as well as all of its software and hardware. It also allows you to communicate with the computer without knowing how to speak the computer's language. Without an operating system, a computer is useless. Your computer's operating system (OS) manages all of the software and hardware on the computer. Most of the time, there are several different computer programs running at the same time, and they all need to access your computer's central processing unit (CPU), memory, and storage. The operating system coordinates all of this to make sure each program gets what it needs. You will not only learn the basics of computer OS, but you will also learn about the different operating systems in this course. So without further delay, get started now. Course Highlights Certified Computer Operating System Course is an award winning and the best selling course that has been given the CPD Certification & IAO accreditation. It is the most suitable course anyone looking to work in this or relevant sector. It is considered one of the perfect courses in the UK that can help students/learners to get familiar with the topic and gain necessary skills to perform well in this field. We have packed Certified Computer Operating System Course into 23 modules for teaching you everything you need to become successful in this profession. To provide you ease of access, this course is designed for both part-time and full-time students. You can become accredited in just 17 hours, 45 minutes and it is also possible to study at your own pace. We have experienced tutors who will help you throughout the comprehensive syllabus of this course and answer all your queries through email. For further clarification, you will be able to recognize your qualification by checking the validity from our dedicated website. Why You Should Choose Certified Computer Operating System Course Lifetime access to the course No hidden fees or exam charges CPD Accredited certification on successful completion Full Tutor support on weekdays (Monday - Friday) Efficient exam system, assessment and instant results Download Printable PDF certificate immediately after completion Obtain the original print copy of your certificate, dispatch the next working day for as little as £9. Improve your chance of gaining professional skills and better earning potential. Who is this Course for? Certified Computer Operating System Course is CPD certified and IAO accredited. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic backgrounds. Requirements Our Certified Computer Operating System Course is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path You will be ready to enter the relevant job market after completing this course. You will be able to gain necessary knowledge and skills required to succeed in this sector. All our Diplomas' are CPD and IAO accredited so you will be able to stand out in the crowd by adding our qualifications to your CV and Resume. Module 1: Introduction to Computer Operating System Introduction 00:15:00 What is an Operating System? 00:30:00 History of Operating System 00:30:00 What an Operating System Does 01:00:00 Microsoft Windows 01:00:00 MAC OS 01:00:00 UNIX 00:30:00 LINUX 00:30:00 GNU 00:30:00 Other Operating Systems 01:00:00 Installing an Operating System 01:00:00 Defining The Processes 01:00:00 Conclusion 00:15:00 Module 2: MAC Operating System Introduction to Mac 01:00:00 Features of Mac Desktops 01:00:00 Networking System of Mac 01:00:00 Types of Mac 01:00:00 Mac your way to cyberspace 00:30:00 Benefits of Using Mac 01:00:00 How to print & fax using Mac 01:00:00 Managing music with iTunes 01:00:00 Having fun with photos 01:00:00 Wrapping Up 00:15:00 Mock Exam Final Exam

This video course takes you through the concepts of Puppet 6 needed to configure your systems. You will learn how to write and run ad-hoc commands, create manifests, modules, templates, and use Puppet Bolt to deploy agents to new systems.

Limited Time Offer: Get Hard Copy + PDF Certificates + Transcript + Student ID Card worth £160 as a Gift - Enrol Business Administration Now Hi, business enthusiast! When launching a new venture, understanding the fundamentals of Business Administration is crucial to your success. What’s the first thing you need to know? It’s the golden rule for running a thriving business! Embark on your journey to becoming a successful entrepreneur with the Business Administration Level 3 Diploma. This comprehensive course offers an in-depth exploration of Business Administration, providing you with the essential skills and knowledge to excel in various business settings. Enrolling in this Business Administration course is an excellent way to gain a solid foundation in business management and direction. Discover how effective business administration can pave the way for a range of careers with strong growth potential. Whether you're interested in health care management, business management, finance, accounting, or marketing, the skills you acquire will be invaluable in navigating these fields. Our structured bundle includes multiple in-depth courses designed to offer a rich and flexible learning experience. By immersing yourself in this comprehensive Business Administration program, you'll be well-prepared to take on diverse business challenges and make informed decisions. Start your journey today and equip yourself with the expertise needed for a successful career in Business Administration. Along with this Business Administration Bundle, you will get original hardcopy certificates, a transcript and a student ID card. Courses are included in this Bundle: Course 01: Business Administration Level 3 Course 02: Employment Law Level 3 Course 03: Introduction to Accounting Course 04: Level 3 Xero Training Course 05: Business Analysis Level 3 Course 06: GDPR Course 07: Level 3- Project Management Course 08: Customer Relationship Management Course 09:Team Management Course 10: Effective Communication Skills Diploma Course 11: Professional Bookkeeping Course Key Features of the Course FREE Business Administration Level 3 Diploma CPD-accredited certificate Get a free student ID card with Business Administration Level 3 Diploma training (£10 applicable for international delivery) Lifetime access to the Business Administration Level 3 Diploma course materials The Business Administration Level 3 Diploma program comes with 24/7 tutor support Get instant access to this Business Administration Level 3 Diploma course Learn Business Administration Level 3 Diploma training from anywhere in the world The Business Administration Level 3 Diploma training is affordable and simple to understand The Business Administration Level 3 Diploma training is entirely online Learning Outcomes Acquaint yourself on how to represent your boss and company to bring your success to new heights. Earn the skills of an effective administrator to recruit employees, conduct department meetings successfully, and engage with higher management. Strengthen your business writing skills, communication skills and telephone skills. Get the chance to broaden organising skills to schedule meetings and conferences as well as become punctual. Keep track of records and successfully file systems to avoid unnecessary turmoil for your organisation. Demonstrate the capacity to undertake rigorous secondary research on challenges, whether general business or company functions. Demonstrate the ability to apply broad management knowledge in real-world scenarios. Learn how to handle mail services and shipping and travel related arrangements skillfully. Course Curriculum: Course 01: Business Administration Level 3 Representing Your Boss and Company Skills of an Effective Administrator Business Writing Skills Communication Skills Business Telephone Skills Mail Services and Shipping Travel Arrangements Organising Meetings and Conferences Time Management Record Keeping and Filing Systems Effective Planning and Scheduling ---------------Other Courses Are--------------- Course 02: Employment Law Level 3 Course 03: Introduction to Accounting Course 04: Level 3 Xero Training Course 05: Business Analysis Level 3 Course 06: GDPR Course 07: Level 3- Project Management Course 08: Customer Service Management Course 09: Course 10: Effective Communication Skills Diploma Course 11: Professional Bookkeeping Course How will I get my Certificate? After successfully completing the Business Administration 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) 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 Business Administration bundle. Requirements This Business Administration course has been designed to be fully compatible with tablets and smartphones. Career path Upon completing this course bundle, you may pursue the following career paths: Business administrator (£20,000 - £30,000 per year) Business analyst (£25,000 - £35,000 per year) Project manager (£30,000 - £40,000 per year) Customer service representative (£20,000 - £25,000 per year) 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 (Business Administration Level 3) 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.

Project management can seem scary and rather intimidating. The whole aim of this programme is to give people a simple and straightforward way of dealing with projects without having to use complex and confusing systems. This two-day course is designed to introduce the apparently complex world of project management in a simple and practical manner. The programme is for anybody who has to run a project of any nature. It has been attended by people from as diverse fields as events management, fashion, charities, oil companies and so on. The programme is run without using any IT project management systems although an introduction can be given if required. At the end of the programme participants will leave understanding: What a project is and why projects are so important today The roles of a project manager Some key language and concepts A simple 5-step model for organising projects How to make sure you understand what your 'client' really wants A set of three simple tools to plan the project How to make decisions What to monitor when the project is running How to close the project 1 Introduction What is the aim of this programme? 2 Background thinking What is a project? The project manager's eternal triangle (cost-quality-time) What are the characteristics of successful projects? Who are the key characters in a project? What are the roles of a project manager? 3 The project process Why have one? 4 Project initiation What is the aim? Identifying key information Key skill: mission analysis Initial risk analysis Document and sign-off 5 Decision-making - 'Stop, Think, Act!' The 'Stop, Think, Act!' technique Recognise the opportunity to make a decision The 3 Cs - making sure we understand the decisions we have to make Identifying options Making your decision Taking it to action 6 Creativity 7 The planning stage Identify all discrete tasks Sequence and dependencies Time line - critical path Resources Project base-line 8 Execution stage - delivering the result Monitor Evaluate Adapt Control Review 9 The project close Review Documentation Have we delivered? What have we learned?

This one-day course focuses on issues such as writing formulas and accessing help while writing them, and taking formulas to the next level by nesting one inside another for a powerful formula result. It also looks at ways of analysing data with reports, summarised by varying criteria. A range of time-saving tips and tricks are shared. This course will help participants: Calculate with absolute reference Group worksheets Link to tables Use the function library effectively Get to grips with the logical IF function Use conditional formatting Create pivot table reports Use data validation Master the VLOOKUP function 1 Calculating with absolute reference The difference between a relative and absolute formula Changing a relative formula to an absolute Using $ signs to lock cells when copying formulas 2 Grouping worksheets Grouping sheets together Inputting data into multiple sheets Writing a 3D formula to sum tables across sheets 3 Linking to tables Linking to a source table Using paste link to link a table to another file Using edit links to manage linked tables 4 The function library Benefits of writing formulas in the function library Finding the right formula using insert function Outputting statistics with COUNTA and COUNTBLANK Counting criteria in a list with COUNTIFS 5 Logical IF Function Outputting results from tests Running multiple tests for multiple results The concept of outputting results from numbers 6 Conditional formatting Enabling text and numbers to standout Applying colour to data using rules Managing rules Copying rules with the format painter 7 View side by side Comparing two Excel tables together Comparing two sheets together in the same file 8 Pivot table reports Analysing data with pivot tables Managing a pivot table's layout Outputting statistical reports Controlling number formats Visualising reports with pivot charts Inserting slicers for filtering data 9 Data validation Restricting data input with data validation Speeding up data entry with data validation 10 VLOOKUP function Best practices for writing a VLOOKUP A false type lookup A true type lookup Enhance formula results with IFNA 11 Print options Getting the most from print Printing page titles across pages Scaling content for print