1812 Courses in Liverpool delivered Online

Pet Food Making Online Course Level 2 Pet nutrition is the important subject that every pet lovers and owners need to be familiarized with. You are in luck since this course provides different pet food making options that fit the nutritional needs of your pet. This Pet Food Making Online Course Level 2 is an intermediate course for perfect pet lovers or animal professional who want to make healthy pet food. Pet enthusiasts like you will surely appreciate how this course is designed to help you provide proper nutrition and pet care. Course Curriculum Pet Food Making Homemade Pet Food – Why it is so beneficial Making Pet Food for the First Time – What Precautions to Take Natural Pet Food Making Techniques Homemade Pet Food for Dogs Homemade Pet Food for Cats Making Homemade Dry Pet Food A Great Way to Save Money Spent on Pet Food What Kind of Food Animals Love Nutrients to Supply Pets with Food Made at Home Tips to Make Excellent Quality Food Conclusion Pet Nutrition Pet Food Types Benefits of Proper Nutrition Diet and Nutrition Advice for Your Dog Dog Food Digestion & Healthy Eating Guide Pet Weight Pets Not Eating & Overeating Pet Foods to Avoid Feeding Rabbits Feeding Hamsters Feeding Fishes Feeding Birds Feeding Reptiles (Learn more about this online course)

Discover the fascinating world of alternative medicine with this CPD Accredited 3-course bundle focused on Homeopathy, Paramedicine Study, and the Safe Handling of Medicines. This course offers an in-depth understanding of homeopathic principles, remedies, and theories, while also expanding your knowledge of paramedical care and the essentials of medication safety. Whether you're interested in holistic wellness or looking to add depth to your existing healthcare knowledge, this programme covers essential areas of alternative and supportive medicine in a structured and accessible format. Designed for anyone with an interest in non-conventional approaches to health, this bundle gives you the knowledge to explore natural remedies and health-support strategies confidently. From the foundations of homeopathic healing to the importance of safe medicine administration, each course is crafted to deliver clear, engaging content that meets professional learning needs. Study at your own pace, online, with materials created to inform, inspire, and broaden your understanding of alternative medicine. These comprehensive courses are available in this Alternative Medicine - Homeopathy - CPD Accredited 3 Courses Bundle Course 01: Alternative Medicine - Homeopathy Course 02: Paramedicine Study Course 03: Safe Handling of Medicines **Special Offer: Free PDF and Hard Copy Certificates** Key Benefits Get instant PDF and Hard Copy certificate Fully online courses Developed by qualified professionals Self-paced learning and laptop, tablet, and smartphone-friendly 24/7 Learning Assistance Course Curriculum: Course 01: Alternative Medicine - Homeopathy Module 01: Introduction to Homeopathy Module 02: Principles and Theories behind the Practice Module 03: Homoeopathic Remedies Module 04: Practice of Homoeopathy on the Nervous System Module 05: Practice of Homeopathy on the Respiratory System Module 06: Practice of Homoeopathy on the Circulatory System Module 07: Practice of Homoeopathy on the Digestive System Module 08: Practice of Homeopathy on the Musculoskeletal System Module 09: Practice of Homoeopathy on The Reproductive Systems Module 10: Practice of Homoeopathy on the Immune System Module 11: Practice of Homoeopathy on the Limbic System Module 12: Homoeopathy for Skin Problems Module 13: Homoeopathy for Children and Women's Health Module 14: First Aid with Homoeopathic Remedies Module 15: How to Treat Patients Module 16: Homoeopathy's Role in Present and Future Course 02: Paramedicine Study Module 01: Introduction to Paramedicine Module 02: Roles and Responsibilities of Paramedics in the UK Module 03: Basic Human Anatomy Module 04: Initial Assessment Module 05: Medication Administration Module 06: Common Injuries Module 07: Major Injuries Module 08: Other Medical Emergencies Module 09: Infection Control Module 10: Paediatric Paramedicine Module 11: Pain Management Module 12: Emergency Response Planning and Management Module 13: Paramedicine Risk Management Module 14: CPR and AED Administration Module 15: Ambulance Administration Module 16: Law and Legislations for Paramedics Module 17: Paramedic Procedures in Response to Covid-19 Course 03: Safe Handling of Medicines Module 01: Introduction to Medicines Module 02: Legislation and Licensing Module 03: Key Principles of Medication Management Module 04: Professional Communication and Medication Safety Module 05: Safe Administration of Medicines Module 06: Patient Involvement in Medication Safety Module 07: Storage, Supply and Disposal of Medication Module 08: Safe Handling of Hazardous Drugs Module 09: Record-Keeping and Audit Process Module 10: The Safe Use of Medication during the COVID-19 Pandemic Course Assessment You will immediately be given access to a specifically crafted MCQ test upon completing each Alternative Medicine - Homeopathy - CPD Accredited 3 Courses Bundle course. For each test, the pass mark will be set to 60%. Accredited Certificate After successfully completing this Alternative Medicine - Homeopathy - CPD Accredited 3 Courses Bundle course, you will qualify for the CPD Quality Standards (CPD QS) certified certificate from Training Express. CPD 35 CPD hours / points Accredited by The CPD Quality Standards (CPD QS) Who is this course for? The Alternative Medicine - Homeopathy - CPD Accredited 3 Courses Bundle training is ideal for highly motivated individuals or teams who want to enhance their skills and efficiently skilled employees. Requirements There are no formal entry requirements for the course, with enrollment open to anyone! Please Note: This course is not a regulated course and doesn't provide any professional qualifications. This course aims to provide basic information about the topics. Career path Learn the essential skills and knowledge you need to excel in your professional life with the help & guidance from our Alternative Medicine - Homeopathy - CPD Accredited 3 Courses Bundle training.

Embarking on a journey into the digital realm? Dive deep into the vast ocean of web development with our course: 'Start Your Career as Web Developer - Complete Training'. This comprehensive programme unfolds the mysteries of HTML, revealing its foundational to advanced layers. As you delve further, JavaScript beckons, introducing you to its core elements, from basic operations to error handling. But that's not all. PHP emerges on the horizon, offering an exploration from rudimentary concepts to intricate object-oriented programming and real-world applications. Equip yourself with the essence of web development and illuminate the pathways of the digital world. Learning Outcomes Grasp the foundational to advanced principles of HTML. Understand and apply JavaScript concepts from introductory to advanced error handling techniques. Master PHP from its fundamental aspects to advanced object-oriented programming and database integration. Develop and implement web applications integrating PHP with MySQL. Implement client-side and server-side validations using JavaScript and PHP. Why choose this Start Your Career as Web Developer - Complete Training? Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments are designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the Start Your Career as Web Developer - Complete Training Course at your own pace, on your own schedule. Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience. Who is this Start Your Career as Web Developer - Complete Training for? Aspiring web developers seeking a structured pathway into the field. Current web designers looking to expand their skills into development. IT students aiming to bolster their academic understanding with applied knowledge. Entrepreneurs aiming to manage or understand their website's backend. Tech enthusiasts with a curiosity about the workings of web development. Career path Web Developer: £28,000 - £50,000 Front-End Developer: £30,000 - £50,000 Back-End Developer: £35,000 - £55,000 Full Stack Developer: £40,000 - £60,000 PHP Developer: £30,000 - £52,000 JavaScript Developer: £35,000 - £57,000 Prerequisites This Start Your Career as Web Developer - Complete Training does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Start Your Career as Web Developer - Complete Training was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Certification After studying the course materials, there will be a written assignment test which you can take at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £4.99 Original Hard Copy certificates need to be ordered at an additional cost of £8. Course Curriculum Introduction Introduction 00:03:00 How to Get Course requirements 00:02:00 Getting Started on Windows, Linux or Mac 00:02:00 How to ask Great Questions 00:01:00 FAQ's 00:01:00 HTML Introduction HTML 00:05:00 Choosing Code Editor 00:06:00 Installing Code Editor (Sublime Text) 00:04:00 Overview of a Webpage 00:05:00 Structure of a Full HTML Webpage 00:07:00 First Hello World! Webpage 00:09:00 HTML Basic Heading tags 00:09:00 Paragraph 00:08:00 Formatting Text 00:12:00 List Items Unordered 00:05:00 List Items Ordered 00:04:00 Classes 00:09:00 IDs 00:06:00 Comments 00:04:00 HTML Intermediate Images 00:12:00 Forms 00:05:00 Marquee 00:06:00 Text area 00:06:00 Tables 00:06:00 Links 00:07:00 Navbar - Menu 00:04:00 HTML Entities 00:05:00 Div tag 00:06:00 Google Maps 00:07:00 HTML Advanced HTML Audio 00:07:00 HTML Video 00:05:00 Canvas 00:06:00 Iframes 00:05:00 Input Types 00:04:00 Input Attributes 00:06:00 Registration Form 00:04:00 Contact Us Form 00:10:00 Coding Exercise 00:01:00 Solution for Coding Exercise 00:02:00 JavaScript Introduction What is JavaScript 00:09:00 Hello World Program 00:14:00 Getting Output 00:11:00 Internal JavaScript 00:13:00 External JavaScript 00:09:00 Inline JavaScript 00:04:00 Async and defer 00:06:00 JavaScript Basics Variables 00:13:00 Data Types 00:10:00 Numbers 00:06:00 Strings 00:07:00 String Formatting 00:05:00 JavaScript Operators Arithmetic operators 00:07:00 Assignment operators 00:03:00 Comparison operators 00:06:00 Logical operators 00:08:00 JavaScript Conditional Statements If-else statement 00:05:00 If-else-if statemen 00:04:00 JavaScript Control Flow Statements While loop 00:09:00 Do-while loop 00:03:00 For loop 00:08:00 Coding Exercise 00:02:00 Solution for Coding Exercise 00:02:00 JavaScript Functions Creating a Function 00:07:00 Function Call() 00:07:00 Function with parameters 00:05:00 JavaScript Error Handling Try-catch 00:05:00 Try-catch-finally 00:17:00 JavaScript Client-Side Validations On Submit Validation 00:09:00 Input Numeric Validation 00:12:00 PHP Introduction What is PHP 00:08:00 Installing XAMPP for PHP, MySQL and Apache 00:12:00 Installing Code Editor(Visual Studio Code) 00:07:00 Creating PHP Project on XAMPP 00:03:00 Hello World Program 00:06:00 PHP Basic Variables 00:16:00 Echo and Print 00:08:00 Data Types 00:11:00 Numbers 00:06:00 Boolean 00:04:00 Arrays 00:06:00 Multi-Dimensional Array 00:07:00 Sorting Arrays 00:04:00 Constants 00:05:00 PHP Strings Strings 00:04:00 String Formatting 00:05:00 String Methods 00:08:00 Coding Exercise 00:01:00 Solution for Coding Exercise 00:01:00 PHP Operators Arithmetic operators 00:03:00 Assignment operators 00:02:00 Comparison operators 00:05:00 Increment - decrement operators 00:03:00 Logical operators 00:06:00 Ternary operator 00:03:00 PHP Decision-making System If statement 00:05:00 If-else statement 00:02:00 If-else-if-else statement 00:03:00 Switch-case statement 00:05:00 PHP Control flow statements Flow Chart 00:06:00 While loop 00:09:00 Do-while loop 00:04:00 For loop 00:15:00 Foreach loop 00:04:00 Coding Exercise 00:01:00 Solution for Coding Exercise 00:01:00 PHP Functions Creating a Function 00:08:00 Function with Arguments 00:08:00 Default Argument 00:03:00 Function return values 00:06:00 Call-by-value 00:02:00 Call-by-reference 00:03:00 PHP Super globals $_POST Method 00:06:00 $_GET Method 00:02:00 PHP Advanced Form Handling 00:08:00 Date and Time 00:08:00 Include 00:06:00 Require 00:02:00 Sessions 00:08:00 File Reading 00:02:00 File Upload 00:06:00 PHP Object-oriented programming[OOPs] What is OOP 00:03:00 Class and Objects 00:11:00 Constructor 00:04:00 Destructor 00:03:00 Access Modifiers 00:10:00 Inheritance 00:12:00 Method overriding 00:06:00 Abstract Class 00:03:00 Interface 00:08:00 PHP - MySQL Application [CRUD] MySQL Basic PhpMyAdmin 00:04:00 Creating Database and Table 00:07:00 Database Connection 00:05:00 PHP Form Create records 00:16:00 PHP Form Reading records 00:11:00 PHP Form Update Data 00:15:00 PHP Form Delete record 00:04:00 PHP Real-world code forms Registration Form 00:04:00 MD5 Algorithm for Encrypting 00:03:00 Sha Algorithm 00:02:00 Login Form 00:12:00 PHP Validations On Submit Validation 00:09:00 Input Numeric Validation 00:12:00 Login Form Validation 00:05:00 Form Server-side all Data Validation 00:06:00 Form Server-side Validation 00:06:00 PHP Error handling Try-throw-catch 00:06:00 Try-throw-catch-finally 00:02:00

Develop your graphic design skills and learn the professional Photoshop tools and techniques Looking to become a highly skilled Photoshop expert? Explore multiple graphic design training sessions and learn special Photoshop skills that’ll let you spread your creative wings. Here’s a Photoshop course full of valuable knowledge and tips that will help you edit and produce professional-grade images, photos, vectors and graphics by practicing with exciting tasks and exercises. The course is available for people with little or no experience in professional design and want to get their skills to a high level quickly. You can study at your own pace, anytime, anywhere; all you need is an internet connection. The flexibility of the course makes it easy to fit into your schedule and let you study stress-free from day one. You will master the Photoshop and learn everything about its interface and editing tools as well as how to use more advanced functions. Whether you want to use Photoshop for personal projects or integrate it into your professional work, this course has everything you need. Our expert will give you the tips on how to use Photoshop efficiently and will take you from beginner to pro. After taking the course, you will be completely comfortable navigating Photoshop and producing high-quality creative content. You will feel confident with your newfound ability to create astounding graphics with Photoshop. The Photoshop course explains everything in a simple, easy to follow format. Within it, you will find easy ways to use the vast array of tools available. You will learn from an expert with extensive professional Photoshop experience. Get creative! Start today! Join this comprehensive Photoshop course and get the benefits: Learning from a professional instructor24/7 access from any devicePractical exercisesTests, quizzes and recapsCertificate of completionExtra materials and downloadable bonuses100% satisfaction guarantee Your Singing Instructor: Claude Simmons Photoshop expert Learn from an industry-leading expert in the digital creative sector!  You will learn from a Photoshop pro with over 10 years of experience using the program in a professional capacity. The course instructor has worked with many global brands and will share his expertise on how to enhance your photos, create graphics and develop professionally. Our course expert is passionate about simplifying the creative process and inspiring you to produce visually pleasing content using Adobe Photoshop. He will share the top tips and tricks on how to deliver consistently high-quality content for your projects without breaking a sweat. Claude will guide you from the very basics to the complex tools, so you become proficient in all areas of Photoshop. Sign up today to learn from one of the top creatives in the industry. Overview of the course:   – VIDEO PRESENTATIONS –   1. Practical knowledge about using Photoshop for both fun and professional purposes Getting to grips with the graphic designer knowledge, including: composition, UX, using colors, typography, formats, styles and more! You will learn how to choose best tools for a professional effect, both hardware and software. 2. Step-by-step video guides for complete skill enhancement Learn about Adobe cloud environment and Photoshop image and photo enhancing capabilities, work space, file formats and color modes.   – PRACTICAL PART –   Training videos and video tutorials In the course you can find in-depth tutorials that will help you discover all useful functions including retouch and photomontage. With this comprehensive and intensive course you will gain new skills quickly, so that you can implement them right away.   – REPETITIONS AND TESTS –   1. Repetition of acquired knowledge and tests Throughout the course, you will have 5 repetitions and 5 tests that will allow you to consolidate your knowledge. 2. Final test Passing the final test means that you have the knowledge and skills needed to use Photoshop at a professional level.   – EXERCISES AND TASKS – Design preparation and workshop Efficient use of Photoshop interface Designing with basic tools Creating retouches and photomontages Advanced designing with expert features   – BONUS MATERIALS – Photoshop tips and tricks guide Compendium of image formats Layout templates Thematic combinations (themes) Experience Beginner-IntermediateLanguage English, German, French, Polish, Portuguese A letter from your expert instructor Why join the Kemp Center’s Photoshop course?Using digital creative platforms is a must in today’s world. Learning how to use Photoshop and gaining creative skills will give you an advantage, both professionally and while working on your passion projects. Photoshop can give you that extra edge. Stand out from others by showing you can create the thing that everyone wants – engaging graphic content.While learning Photoshop can enhance your career, it’s also very fun! You can use the program to retouch images, create compositions with graphics and text or create your own funny GIFs. Whatever you want to do, Photoshop has features to help you bring your creative visions to life. So don’t wait up, and start getting creative today!Our Photoshop course is comprehensive and covers all the basics but also teaches about Photoshop’s advanced features. After completing the course, you will become a confident graphic designer and, once you’re familiar with the interface, you can release your creative imagination.This course is for both beginners and more advanced users and you can decide yourself how deep you want to go with it.The course package contains extensive material presented in an engaging format. You will have a lot of fun going through the course on state of the art Kemp Center platform. You will learn and play by using specific examples, spaced repetitions and varied practical exercises. Taking the Photoshop course is a fun, affordable way to learn how to create and edit photos and graphics. Whatever your creative project is, Photoshop can do it. From creating image templates, mood boards or photo collages to designing your own 2D or 3D art, you will be able to do it all!Claude Simmons, Photoshop expert

Data privacy isn’t optional—it’s a legal and ethical necessity. This GDPR Training Course bundle provides a clear, structured understanding of the General Data Protection Regulation (GDPR), covering its core principles, lawful bases, rights of individuals, and responsibilities for organisations. Whether you’re handling customer data, managing internal records, or overseeing workplace policies, this course offers a concise yet thorough foundation to keep your operations in line with the latest data protection requirements. The bundle also includes modules on Document Control and Workplace Confidentiality—key areas often overlooked in data protection conversations. These additional courses give learners the knowledge to manage sensitive information responsibly, maintain integrity across workflows, and reduce risk through informed decisions. Designed for professionals across a wide range of industries, this flexible, fully online training package helps ensure your workplace aligns with GDPR standards while fostering a secure information culture. These comprehensive courses are available in this GDPR Training Course - CPD Accredited 3 Courses Bundle Course 01: GDPR Training Course Course 02: Document Control Course 03: Workplace Confidentiality ** Special Offer: Free PDF and Hard Copy Certificates** Key Benefits Get instant PDF and Hard Copy certificate Fully online courses Self-paced learning and laptop, tablet, and smartphone-friendly 24/7 Learning Assistance Course Curriculum: GDPR Basics GDPR Explained Lawful Basis for Preparation Rights and Breaches Responsibilities and Obligations Ethical and Social Issues and Data Protection, Course Assessment You will immediately be given access to a specifically crafted MCQ test upon completing each GDPR Training Course - CPD Accredited 3 Courses Bundle bundle course. For each test, the pass mark will be set to 60%. Accredited Certificate After successfully completing this GDPR Training Course - CPD Accredited 3 Courses Bundle course, you will qualify for the CPD Quality Standards (CPD QS) certified certificate from Training Express. CPD 30 CPD hours / points Accredited by The CPD Quality Standards (CPD QS) Who is this course for? The GDPR Training Course - CPD Accredited 3 Courses Bundle training is ideal for highly motivated individuals or teams who want to enhance their skills and efficiently skilled employees. Requirements There are no formal entry requirements for the course, with enrollment open to anyone! Career path Learn the essential skills and knowledge you need to excel in your professional life with the help & guidance from our GDPR Training Course - CPD Accredited 3 Courses Bundle training.

Navigating forklift operations safely and efficiently is essential for any workplace aiming to maintain a secure and productive environment. This CPD accredited three-course bundle offers a thorough understanding of forklift machinery, covering everything from basic introduction to recognising operational risks. Learners will gain valuable insight into various types of forklifts and how to manage loads with due attention to safety protocols, ensuring a strong foundation in safe forklift usage. Each module delves into critical aspects such as correct refuelling and recharging procedures alongside detailed coverage of relevant regulations and safety measures. Designed for those seeking to enhance their knowledge in this field without attending in-person sessions, this course bundle offers flexible, well-structured learning that fits comfortably around any schedule. Whether for employers wanting to ensure team members are well-informed or individuals aiming to broaden their awareness, this training provides essential knowledge to support safe forklift operations across industries. These comprehensive courses are available in this Forklift Training - CPD Accredited 3 Courses Bundle Course 01: Forklift Training Course 02: Manual Handling Course 03: Workplace Health and Safety ** Special Offer: Free PDF and Hard Copy Certificates** Key Benefits Get instant PDF and Hard Copy certificate Fully online courses Self-paced learning and laptop, tablet, and smartphone-friendly 24/7 Learning Assistance Course Curriculum: Module 01: Introduction to Forklifts Module 02: Types of Forklifts Module 03: Operating Forklifts Safely Module 04: Moving and Handling Loads Safely Module 05: Refuelling and Recharging Safely Module 06: Operational Risks and Hazards Module 07: Regulations and Safety Measures Course Assessment You will immediately be given access to a specifically crafted MCQ test upon completing each Forklift Training - CPD Accredited 3 Courses Bundle bundle course. For each test, the pass mark will be set to 60%. Accredited Certificate After successfully completing this Forklift Training - CPD Accredited 3 Courses Bundle course, you will qualify for the CPD Quality Standards (CPD QS) certified certificate from Training Express. CPD 30 CPD hours / points Accredited by The CPD Quality Standards (CPD QS) Who is this course for? The Forklift Training - CPD Accredited 3 Courses Bundle training is ideal for highly motivated individuals or teams who want to enhance their skills and efficiently skilled employees. Requirements There are no formal entry requirements for the course, with enrollment open to anyone! Career path Learn the essential skills and knowledge you need to excel in your professional life with the help & guidance from our Forklift Training - CPD Accredited 3 Courses Bundle training.

This one-day workshop will give you a better understanding of the components and operations of an Access database. It is designed to build on a user's existing skills and includes useful action queries to allow greater manipulation of a database. This workshop will help participants: Ensure the integrity of their databases Manage field properties Use the query functions effectively Save time with the query expression builder Create different types of query more quickly Design better forms Link expressions in forms Create better and more useful reports Import and export tables more easily 1 Table relationship integrity Identifying relationships Identifying criteria for data integrity Applying referential integrity Managing relationship join types 2 Table field properties Field properties overview Using input mask field Using default value fields Using field validation rules 3 Query functions Running aggregate function calculations Running sum, average, count, max and min functions Grouping calculated data 4 Query calculations Using query operators and expressions Adding calculated fields to a query Using the query expression builder 5 Action queries Creating make table queries Creating append queries Creating update queries Creating delete queries 6 Designing forms Adding form controls Aligning and arranging form controls Adding pictures and labels to forms Adding new fields to a form Controlling tab order Adding command buttons Adding a combo box control Formatting data using conditional formatting 7 Form expressions (calculations) Using the form expression builder Working with a property sheet within a form Linking expressions within a form 8 Working with reports Creating reports with the report wizard Inserting report fields Formatting fields Inserting report headers and footers Working with a property sheet within a report 9 Grouped reports Creating groups with the report wizard Sorting grouped data Grouping alphabetically Grouping on date intervals Creating sub reports Adding calculations to groups 10 Importing and exporting tables Importing tables into Access Exporting tables from Access Importing and linking data in Access

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

This one-day workshop is designed to enhance your PowerPoint skills to achieve dynamic presentations that work with you, making it easier to deliver a polished, professional presentation. You will learn advanced PowerPoint skills that will save you time and elevate your presentations. This course will help participants: Create custom shows to personalise presentations for individual clients Make the Slide Master work collectively with slide layouts and themes Seamlessly interact with external content using links Work with advanced animations and transitions, and video/audio tools 1 Themes and Masters Add a Design theme to a presentation Make changes to the Slide Master Delete layouts from the slide master Saving a slide master with themes as a template 2 Advanced graphics and diagrams Drawing, duplicating and resizing shapes Grouping, aligning and stacking shapes and graphics Using SmartArt for diagrams and organisation charts 3 Graphs and charts Inserting and formatting a chart Linking an Excel chart to a slide Linking Excel tables to a slide Animating charts 4 Video, Custom animation and Hyperlinks Adding and editing video Animating pictures and drawings Hyperlink to another Slide or Website Compressing and optimising media 5 Presenting Reuse slides Hide slides Rehearsing timings Enabling a presentation to run continuously

This one-day workshop is designed to build upon skills already acquired using Microsoft Word, whether participants are self-taught or have previously attended a course. It gives participants a good understanding of managing different types of paragraph indents, and managing automated numbered paragraph lists. This course will help participants: Create and manage the layout of paragraphs Create and manage multi-level numbered paragraphs Effectively insert, use and manage section breaks Create and manage columns Find, create and apply styles Create and update a table of contents from styles Work with styles to manage formatting Work with sums in tables and use table headings Input and edit text using AutoText Work with SmartArt graphics Link to other files using paste special 1 Managing paragraph layout Controlling paragraph layouts with indents Creating and managing paragraph hanging indents 2 Numbering paragraphs Creating a new multi-level numbered paragraph Managing existing multi-level numbered paragraphs 3 Inserting columns Creating columns from existing paragraphs Setting up columns Managing columns 4 Document section breaks Controlling document layout using section breaks Managing page orientation using section breaks Managing page numbering using section breaks 5 Using styles Applying quick styles Finding existing styles Creating and saving styles Modifying styles Creating a table of contents from styles Updating a table of contents 6 Using quick parts Saving content to quick parts Modifying saved quick parts Inserting content using AutoText Editing AutoText entries Inputting text using AutoCorrect 7 Advanced table features Sorting table columns Running sums in tables Repeating table headings at top of page Importing Excel content in tables Using table properties 8 Creating a mail merge Creating letters, labels and emails Merging addresses from external files Using Outlook's address book to merge Merging to email 9 SmartArt graphic Visually communicate content with SmartArt Choosing a SmartArt graphic Inputting into SmartArt Modifying and formatting SmartArt graphics 10 Linking to other files Linking to files using paste special Linking an Excel chart to a document Managing linked content from Word