650 Courses in Cardiff delivered On Demand

Gain the skills and credentials to kickstart a successful career and learn from the experts with this step-by-step

The course focuses on the five domains that should be known for the CompTIA PenTest+ PT0-002 exam. Learn to successfully plan and scope a pen test engagement with a client, find vulnerabilities, exploit them to get into a network, then report on those findings to the client with the help of this comprehensive course.

Develop confidence and clarity in your public speaking skills. This training equips you with the tools to engage, persuade, and deliver impactful presentations effectively.

Power Query and Power Pivot in Microsoft Excel:  A Quickstart Guide   Course Description   Copyright Ross Maynard 2022   Course Description Power Query and Power Pivot are two tools available in Microsoft Excel. If you are serious about data analysis, then you need to know how to use these tools. This Quickstart guide will give you the skills you need to get started with these powerful features. The Power Query tool allows you to import external data and then modify it to meet your needs, before loading it into Excel. These editing tasks are all things you can do manually in Excel, but Power Query greatly speeds things up when you have a large volume of data. The Power Pivot tool allows you to connect multiple data tables in an extended pivot table. Power Pivot also introduces new analysis and query tools to further enhance data analysis. If data analysis is your thing, then this course will help you get up to speed with these feature-filled tools. Through screen-capture video, the course provides a step-by-step guide to the foundation skills needed to use both Power Query and Power Pivot effectively. The course is designed to make your first steps into Power Query easy and to build your confidence to use them on your own. Both Power Query and Power Pivot are also available in Microsoft Power BI – the data visualisation suite. Once you have learned how to use Power Query and Power Pivot in Excel with this course, you’ll have a head start in getting to grips with Power BI Get up to speed with Power Query and Power Pivot in Microsoft Excel with this Quickstart guide.     Key Learning Points  On completion of the course, delegates will be able to: Use Power Query to load data from an external source into Microsoft Excel Clean and manipulate external data before loading it into Excel Consolidate separate files with Power Query Update Excel tables with new data in the same format Use Power Query to “unpivot” report tables to prepare the data for analysis Explain the core functionality of Power Pivot Link data tables together in the Power Pivot data model Create pivot tables that draw data from several source data tables Create performance measures and new analysis in the Power Pivot data model Use the most popular DAX query language functions in Power Pivot     Curriculum Lesson 1: Power Query Quickstart Lesson 2: Consolidating Files with Power Query Lesson 3: Unpivoting a Table Lesson 4: Power Pivot Quickstart Lesson 5: Power Pivot – Adding Data and Functionality Lesson 6: Key DAX Functions for Power Pivot Lesson 7: The DAX CALCULATE Function Lesson 8: Key Learning Points     Pre-Course Requirements There are no pre-course requirements     Additional Resources Starter spreadsheets for each lesson are provided so that learners can follow the steps presented.     Course Tutor Your tutor is Ross Maynard. Ross is a Fellow of the Chartered Institute of Management Accountants in the UK and has 30 years’ experience as a process improvement consultant specialising in business processes and organisation development. Ross is also a professional author of online training courses. Ross lives in Scotland with his wife, daughter and Cocker Spaniel     Questions What is the main feature of Power Query? The ability to link data tables together to create pivot tables that allow data to be drawn from any and all of the source tables The ability to clean and manipulate large volumes of external data efficiently and to load the result into Microsoft Excel The removal of Microsoft Excel’s restrictions on file sizes and the number of rows of data allowed The ability to visualise data in dashboards and management reports     What is the main feature of Power Pivot? The ability to link data tables together to create pivot tables that allow data to be drawn from any and all of the source tables The ability to clean and manipulate large volumes of external data efficiently and to load the result into Microsoft Excel The removal of Microsoft Excel’s restrictions on file sizes and the number of rows of data allowed The ability to visualise data in dashboards and management reports     Which of the following actions cannot be performed within Power Query? Split text into multiple columns Trimming text and removing spaces Creating calculated columns using DAX functions Make date based calculations   Which of the following statements is true? You can use Power Query to combine files that have the same format and open them all in the same spreadsheet You can use Power Query to link data tables and create pivot tables that pull data items from all the linked tables You can use Power Query to create interactive dashboard reports You can use Power Query to export data files to Microsoft Access and other databases     Which of the following provides a compelling case to use Power Pivot in Microsoft Excel? The data visualisation and presentation features of Power Pivot are much more powerful than those in Excel Power Pivot offers the ability to clean large files of data imported from other systems quickly Existing reports and tables can be “reverse engineered” (unpivoted) to create data tables for more advanced analysis Files sizes in Power Pivot are smaller than in Excel and there is no limit on the number of rows of data that can be stored. This makes it much faster and more efficient to use Power Pivot for large data sets     Power Pivot uses analysis functions from the DAX formula language. What does “DAX” stand for? Digital Architecture Extraction Data Arbitrage Extrapolation Display Analytics Extension Data Analysis Expressions Deeply Annoying Exercise   The DAX CALCULATE function is one of the most powerful and useful functions available in Power Pivot. Which statement best describes it? It performs row by row calculations defined by the user and adds the total of them all together for a specified table It performs row by row calculations defined by the user and displays the maximum result for a specified table It performs a defined calculation and then applies filters specified by the user It filters the data in a specified table according to criteria set by the user   As well as in Power Pivot in Microsoft Excel, in what application are DAX functions also available? Microsoft PowerPoint Microsoft Forms Microsoft Teams Microsoft Power BI   How do DAX functions differ from Microsoft Excel functions? DAX functions are designed specifically for use with SQL based data sources DAX functions are completely new and provide additional functionality within Microsoft Excel DAX functions never take a cell reference or a range as reference, but instead take a column or table as reference DAX date and time functions return a date as a serial number, whereas Excel date and time functions return a datetime data type  

Follow your dreams by enrolling on the Office Administration Management and Office Skills course today and develop the experience, skills and knowledge you need to enhance your expert development. Office Administration Management and Office Skills will help you arm yourself with the qualities you need to work towards your dream job. Study the Office Administration Management and Office Skills training course online with Janets through our online learning platform and take the first steps towards a successful long-term career. The Office Administration Management and Office Skills course will allow you to enhance your CV, impress potential employers, and stand out from the crowd.  This Office Administration Management and Office Skills course consists of a number of easy to digest, in-depth modules, designed to provide you with a detailed, expert level of knowledge. Study the Office Administration Management and Office Skills course through a mixture of instructional video lessons and online study materials. Receive online tutor support as you study the Office Administration Management and Office Skills course, to ensure you are supported every step of the way. Get a digital certificate as proof of your Office Administration Management and Office Skills course completion. Janets is one of the top online training course providers in the UK, and we want to make education accessible to everyone! Learn the essential skills you need to succeed and build a better future for yourself with the Office Administration Management and Office Skills course. The Office Administration Management and Office Skills course is designed by industry experts and is tailored to help you learn new skills with ease.  The Office Administration Management and Office Skills is incredibly great value and allows you to study at your own pace. With full course access for one year, you can complete the Office Administration Management and Office Skills when it suits you. Access the Office Administration Management and Office Skills course modules from any internet-enabled device, including computers, tablets, and smartphones. The Office Administration Management and Office Skills course is designed to increase your employability and equip you with everything you need to be a success. Enrol on the Office Administration Management and Office Skills now and start learning instantly! What You Get Out Of Studying Office Administration Management and Office Skills With Janets: Receive a digital Certificate upon successful completion of the Office Administration Management and Office Skills course Get taught by experienced, expert instructors Study at a time and pace that suits your learning style Get instant feedback on assessments 24/7 help and advice via email or live chat Get full tutor support on weekdays (Monday to Friday) Description The Office Administration Management and Office Skills training course is delivered through Janets' online learning platform. Access the Office Administration Management and Office Skills content from any internet-enabled device whenever or wherever you want to. The Office Administration Management and Office Skills course has no formal teaching deadlines, meaning you are free to complete the course at your own pace. Certificate of Achievement Endorsed Certificate of Achievement from the Quality Licence Scheme Once the course has been completed and the assessment has been passed, all students are entitled to receive an endorsed certificate. This will provide proof that you have completed your training objectives, and each endorsed certificate can be ordered and delivered to your address for only £119.00. Please note that overseas students may be charged an additional £10 for postage. CPD Certificate of Achievement from Janets Upon successful completion of the course, you will be able to obtain your course completion e-certificate free of cost. Print copy by post is also available at an additional cost of £9.99 and PDF Certificate at £4.99. Endorsement This course and/or training programme has been endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. This course and/or training programme is not regulated by Ofqual and is not an accredited qualification. Your training provider will be able to advise you on any further recognition, for example progression routes into further and/or higher education. For further information please visit the Learner FAQs on the Quality Licence Scheme website. Method of Assessment To successfully complete the course, students will have to take an automated multiple-choice exam. This exam will be online and you will need to score 60% or above to pass the course. After successfully passing the exam, you will be able to apply for Quality Licence Scheme endorsed certificate of achievement. To verify your enhanced skills in the subject, we recommend that you also complete the assignment questions. These can be completed at any time which is convenient for yourself and will be assessed by our in-house specialised tutors. Full feedback will then be given on your current performance, along with any further advice or support. Who Is This Course For: The Office Administration Management and Office Skills is ideal for those who already work in this sector or are an aspiring expert. This Office Administration Management and Office Skills course is designed to enhance your expertise and boost your CV. Learn key skills and gain an expert lesson to prove your newly-acquired knowledge. Requirements: The Office Administration Management and Office Skills is open to all students and has no formal entry requirements. To study the Office Administration Management and Office Skills course, all your need is a passion for learning, a good understanding of English, numeracy, and IT skills. You must also be over the age of 16. Career Path: The Office Administration Management and Office Skills is ideal for anyone who wants to pursue their dream career in a relevant industry. Learn the skills you need to boost your CV and go after the job you want. Complete the Office Administration Management and Office Skills  and gain an industry-acknowledged lesson that will help you excel in finding your ideal job.

Training others effectively isn’t just about knowing your material; it’s about delivering it in a way that actually makes people stay awake—and possibly even learn something. The Certificate in Training Delivery (Train the Trainer) With Complete Career Guide Course has been developed for individuals who want to develop sharp, professional communication and instructional delivery without falling into the PowerPoint abyss. Whether you're stepping into the world of training or you're looking to sharpen your delivery style, this course provides a structured online learning pathway tailored to support confident, credible instruction—minus the awkward icebreakers. This online training delivery course explores key teaching techniques, adult learning theory, session planning, learner engagement, and feedback approaches—all with a steady eye on clarity, confidence, and effectiveness. Delivered entirely online, it’s designed for those with a flair for facilitating (or at least an ambition to be slightly less terrifying in front of a group). Alongside the core training content, you'll find a complete career guide to help you map the training landscape and navigate your next professional steps with the composure of someone who didn’t just wing it. ________________________________________________________________________ Key Features: CPD Certified Certificate in Training Delivery (Train the Trainer) With Complete Career Guide 10 Instant e-certificate and hard copy dispatch by next working day Fully online, interactive course with audio voiceover Developed by qualified professionals in the field Self-paced learning and laptop, tablet, smartphone-friendly 24/7 Learning Assistance Discounts on bulk purchases Course Curriculum: Module 01: Train The Trainer - Part 1 Module 02: Introduction And Welcome Module 03: Start With An Amazing Opener Module 04: Training On Facilitating Classroom Activity Module 05: Introduction And Welcome Module 06: Get Buy-In For The Activity Module 07: Find Trainees Who Need Help Module 08: Tutor Effectively During Activities Module 09: Manage The Activity Pace Module 10: Prepare To Lead An Activity Module 11: Train The Trainer Coach: Complete Guide To Coaching Trainers Module 12: Train The Trainer Coliseum: How To Train Very Large Classes Module 13: Hook A Large Class Module 14: Teach A Large Class Module 15: Support A Large Class Module 16: Train The Trainer Recharge: The Healthy Trainer Module 17: Welcome To Healthy Trainer Module 18: Manage Yourself Module 19: Manage Your Issues Module 20: Manage Your Classroom Module 21: Manage Your Audience Module 22: Manage Your Feedback Module 23: Train The Trainer Serenity Course Module 24: Welcome To Serenity Module 25: Stop Interruptions Module 26: Handle Negativity Module 27: Manage Inattention ________________________________________________________________________ Complete Career Guide for Certificate in Training Delivery (Train the Trainer) (A to Z) This isn't just a course; it's your ticket to thriving in the sector and your roadmap to the Train the Trainer. In addition to mastering the essentials of Train the Trainer, you'll also gain valuable skills in CV writing, job searching, communication, leadership, and project management. These 9 complementary courses are designed to empower you at every stage of your journey. Stand out in your career, from crafting a winning CV to excelling in interviews. Develop the leadership skills to inspire your team and efficiently manage projects. This holistic approach ensures you're not just job-ready but career-ready. Enrol today, and let's build your success story together in Train the Trainer. Your dream career starts here! List of career guide courses included in Certificate in Training Delivery (Train the Trainer) With Complete Career Guide: Course 01: Professional CV Writing and Job Searching Course 02: Communication Skills Training Course 03: Career Development Training Course 04: Time Management Course 05: Returning to Work Training Course 06: Level 3 Diploma in Project Management Course 07: Leadership Skills Course 08: Body Language Course 09: Interview and Recruitment ________________________________________________________________________ Learning Outcomes: Apply effective opening techniques to engage trainees immediately. Facilitate classroom activities with skill and confidence. Identify and support trainees in need during activities. Coach and guide trainers with comprehensive techniques. Manage and deliver training to large classes successfully. Cultivate a healthy trainer mindset for sustained performance. ________________________________________________________________________ Accreditation All of our courses, including the Certificate in Training Delivery (Train the Trainer) With Complete Career Guide, are fully accredited, providing you with up-to-date skills and knowledge and helping you to become more competent and effective in your chosen field. Certification Once you've successfully completed your Certificate in Training Delivery (Train the Trainer) With Complete Career Guide, you will immediately be sent your digital certificates. Also, you can have your printed certificate delivered by post (shipping cost £3.99). Our certifications have no expiry dates, although we recommend renewing them every 12 months. Assessment At the end of the courses, there will be an online assessment, which you will need to pass to complete the course. Answers are marked instantly and automatically, allowing you to know straight away whether you have passed. If you haven't, there's no limit on the number of times you can take the final exam. All this is included in the one-time fee you paid for the course itself. CPD 100 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Aspiring trainers seeking comprehensive training skills. Professionals desiring expertise in coaching and large-class training. Individuals aiming to enhance classroom management and audience interaction. Those interested in addressing interruptions, negativity, and inattention effectively. Career path Classroom Trainer - £30K to 40K/year. Training Coach - £35K to 45K/year. Large-Class Facilitator - £32K to 42K/year. Health and Wellness Trainer - £28K to 38K/year. Serenity Coach - £30K to 40K/year. Certificates 10 CPD Accredited e-Certificates Digital certificate - Included 10 CPD Accredited Hard Copy Certificates Hard copy certificate - Included

Microsoft Project 2021 is a complete lifecycle project management tool that manages complex projects efficiently. This all-encompassing course molds you into an expert in project management with fundamentals to advanced techniques to handle projects of all sizes and gain confidence and proficiency in project planning, execution, and reporting.

Hiring someone is more than posting a job ad and hoping for the best. It’s about getting the right person, in the right role, at the right time—without losing your mind in the process. This Employee Recruitment and Onboarding Course walks you through how to attract top talent, filter through applications without falling asleep, and set new hires up for success without sending them a 72-slide PowerPoint on day one. If you’ve ever wondered why someone ghosted after the interview or started on Monday and disappeared by Friday, this course has answers. We’ll cover job descriptions that don’t sound like a robot wrote them, interviews that actually tell you something, and onboarding strategies that help people stick around past the welcome email. No fluff. No filler. Just the steps you need to shape a hiring process that works—from the first ad to a settled, confident new team member. Whether you're part of HR or doing everything yourself in a growing business, this course was built with you (and your headache) in mind. Key Features CPD Accredited FREE PDF + Hardcopy certificate Fully online, interactive course Self-paced learning and laptop, tablet and smartphone-friendly 24/7 Learning Assistance Discounts on bulk purchases Course Curriculum of Employee Recruitment and Onboarding Module 01 : Purpose of Onboarding Module 02 : Introduction to Onboarding Module 03 : Onboarding Preparation Module 04 : Onboarding Checklist Module 05 : Creating an Engaging Program Module 06 : Following Up with New Employees Module 07 : Setting Expectations Module 08 : Providing Feedback Learning Outcomes: Define the Significance of Onboarding: Grasp the pivotal role of onboarding in integrating new employees . Craft Engaging Onboarding Programs: Develop captivating initiatives for seamless assimilation . Master Expectation Setting: Learn to establish clear, achievable goals for new team members . Hone Feedback Delivery: Cultivate skills to provide constructive input to nurture growth . Execute Thorough Onboarding Preparation: Streamline processes for maximum effectiveness . Implement Follow-Up Strategies: Ensure sustained support for new employees . Accreditation This course is CPD Quality Standards (CPD QS) accredited, providing you with up-to-date skills and knowledge and helping you to become more competent and effective in your chosen field. CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? HR Professionals seeking to enhance their onboarding processes. Managers looking to refine their recruitment and integration strategies. Entrepreneurs aiming to create a welcoming and productive work environment. Small business owners keen on maximising employee potential. Team Leaders eager to strengthen team cohesion and performance. Administrative Personnel involved in the recruitment process. Start-up Founders looking to establish effective onboarding practices. Individuals transitioning to HR roles. Career path Recruitment Coordinator HR Specialist Talent Acquisition Manager Onboarding Consultant Employee Experience Coordinator People Operations Manager Certificates Digital certificate Digital certificate - Included Once you've successfully completed your course, you will immediately be sent a FREE digital certificate. Hard copy certificate Hard copy certificate - Included Also, you can have your FREE printed certificate delivered by post (shipping cost £3.99 in the UK). For all international addresses outside of the United Kingdom, the delivery fee for a hardcopy certificate will be only £10. Our certifications have no expiry dates, although we do recommend that you renew them every 12 months.

The Office Admin and Customer Service Diploma is designed to prepare you for an exciting career in office administration by increasing your skill level in computer applications, public speaking, interpersonal relations, and information management. In addition to skill development, employment preparation is also covered, including resume and cover letter writing, mock interviews, and job shadowing. You will also be able to learn the structures and objectives involved in conducting of admin assistant and customer service. Why choose this course Earn an e-certificate upon successful completion. Accessible, informative modules taught by expert instructors Study in your own time, at your own pace, through your computer tablet or mobile device Benefit from instant feedback through mock exams and multiple-choice assessments Get 24/7 help or advice from our email and live chat teams Full Tutor Support on Weekdays Course Design The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace. You are taught through a combination of Video lessons Online study materials Mock exams Multiple-choice assessment Certification After the successful completion of the final assessment, you will receive a CPD-accredited certificate of achievement. The PDF certificate is for £9.99, and it will be sent to you immediately after through e-mail. You can get the hard copy for £15.99, which will reach your doorsteps by post. Who is this course for? Office Admin and Customer Service Diploma is suitable for anyone who want to gain extensive knowledge, potential experience and professional skills in the related field. This is a great opportunity for all student from any academic backgrounds to learn more on this subject. Career path Training offered by the Office Admin and Customer Service Diploma could potentially benefit a range of roles, but would particularly enhance careers in Office Administration Sales Customer Service Receptionist and Secretarial Work Business Management Marketing Other professional admin roles

Fall into Savings. Enjoy the biggest price fall this Season! 14 in 1 Bundle only at £100 Get Hard Copy + PDF Certificates + Transcript + Student ID Card 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 Medical Receptionist Training bundle that has everything you need to succeed in Medical Receptionist and other relevant fields! After surveying thousands of learners just like you and considering their valuable feedback, this all in one Medical Receptionist bundle has been designed by Medical Receptionist Training industry experts. We prioritised what learners were looking for in a complete package and developed this in-demand Medical Receptionist course that will enhance your skills and prepare you for the competitive job market. Also, our Medical Receptionist experts are available for answering your queries and help you along your learning journey. Advanced Medical Receptionist Training audiovisual 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 Medical Receptionist, 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 Bundle Consists of the following Premium courses: Course 01: Medical Receptionist: Responsibilities and Skills Course 02: Clinical Coding Course 03: Medical Transcription Course 04: GDPR in Healthcare Course 05: Document Control Course 06: Electronic Document Management System Step Course 07: Customer Relationship Management Course 08: Phone-Based Customer Service Course 09: Effective Communication Skills Diploma Course 10: Touch Typing Essentials Course 11: Level 2 Microsoft Office Essentials Course 12: Personal Hygiene Course 13: Stress Management Training Course 14: Time Management Training Enrol now in Medical Receptionist Training to advance your career, and use the premium study materials from Apex Learning. Benefits you'll get from choosing Apex Learning: Pay once and get lifetime access to 14 CPD courses Free e-Learning App for engaging reading materials & helpful assistance Certificates, student ID for the course included in a one-time fee Free up your time - don't waste time and money travelling for classes Accessible, informative modules designed by expert instructors Learn about at your ease - anytime, from anywhere Study from your computer, tablet or mobile device CPD accredited course - improve the chance of gaining professional skills Curriculum of the Bundle Course 01: Responsibilities and Skills Introduction to Medical and Clinical Administration Introduction to Healthcare and Receptionists Organise Schedules Maintaining Medical Records Effective Filing Systems in Medical Offices Confidentiality in a Medical Environment Medical Jargon and Terminology Controlling Stocks and Supplies Medical (Clinical) Coding and Billing Information Technology in Health Care Legal aspects and Ethics Maintaining Workplace Safety Time Management Course 02: Clinical Coding Introduction PCS 3M Workshop PCS 3M Workshop And much more... Course 03: Medical Transcription Introduction to Medical Transcription The What, How, Who and Why of Medical Transcription Understanding Medical Reports And much more... Course 04: GDPR in Healthcare Introduction to GDPR GDPR and Healthcare Setting General Data Protection Regulations Explained And much more... Course 05: Document Control Introduction to Document Control Principles of Document Control and Elements of Document Control Environment Document Control Lifecycle And much more... Course 06: Electronic Document Management System Step Introduction Role and Important of Document Controller Document and Record management And much more... Course 08: Phone-Based Customer Service Introduction to Customer Service What's Different about Good Customer Service? Customer Relationship Management And much more... Course 09: Effective Communication Skills Diploma Business Communication Verbal and Non-verbal Communication Written Communication And much more... Course 10: Touch Typing Essentials Introduction How to Set up Your Computer How to type the letters F and J How to type the letters D and And much more... Course 11: Level 2 Microsoft Office Essentials Excel 2016 Word 2016 PowerPoint2016 Access 2016 Course 12: Personal Hygiene Introduction to Personal Hygiene and a Brief History Looking Clean, Smelling Clean Improving and Maintaining Oral Health And much more... Course 13: Stress Management Training Beginning Concepts Specific Stress Management Techniques MORE Stress Reduction Strategies And much more... Course 14: Time Management Training Importance and Benefits of Time Management Assess Your Current Work Practice Identifying the Priorities Say 'No' to Procrastination And much more... 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 bundle. Requirements Our course is fully compatible with PCs, Macs, laptops, tablets and Smartphone devices. Career path Having these various expertise will increase the value in 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 (Responsibilities and Skills) 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.