43588 Courses in Cardiff delivered Online

Course Objectives At the end of this course you will be able to: Work with advanced lookup and reference functions Create macros to automate common tasks Use advanced techniques to analyse data Create PivotTables and PivotCharts Work with data validation tools Import and export data ' Customer Feedback Best Training Ever! Just finished a bespoke 1-1 training course in Excel Advanced, Macros & VBA. Pedro is an excellent trainer, imparting his skills and knowledge in the best way - appropriately to audience skills, knowledge and ability. Pedro is always approachable, encouraging and supportive, giving delegates the optimum learning environment. I would not hesitate to recommend Pedro as a trainer, whatever your level of ability. Amanda Morris - Treasury & Systems Accountant at Reall - Real Equity for All The course was very interesting and engaging and will definitely be put to use. The trainer was very helpful and charismatic. Marving Lopez - AM Best Europe Pedro was excellent. Very knowledgeable, clear and great rapport with class. Darren Barkey - Direct Wines Great content and learnt a lot. Really enjoyable :) Kristie-Lee Ryan - Stirling Ackroyd 1 year email support service Take a closer look at the consistent excellent feedback from our growing corporate clients visiting our site ms-officetraining co uk With more than 20 years experience, we deliver courses on all levels of the Desktop version of Microsoft Office and Office 365; ranging from Beginner, Intermediate, Advanced to the VBA level. Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering public, one to one, tailored and bespoke courses. Our competitive rates start from £550.00 per day of training Tailored training courses: You can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs. Please visit our site (ms-officetraining co uk) to get a feel of the excellent feedback our courses have had and look at other courses you might be interested in. Advanced Functions COUNT, COUNTA, COUNTIF, COUNTBLANK, SUMIF, SUBTOTAL IF, OR, AND, IFERROR VLOOKUP to lookup Exact Values and Approximate values MATCH, INDIRECT, ROW/COLUMN, INDEX, OFFSET Analysing Data PMT function to calculate a monthly payment of a loan What If Analysis using Goal Seek Use scenarios to consider many different variables Using Solver Add-in to optimize variables PivotTables Create a PivotTable to analyse worksheet data Add or remove fields in a PivotTable Change the data source for a PivotTable Working with external data sources Using different Statistical Functions Calculate a Running Total, % of Grant Total, Difference From… Using the Slicer and Timeline to filter the PivotTable Using Filters in a PivotTable Group by Date, Auto Group by ranges of values, Custom Group Create a PivotChart The GETPIVOTDATA function Formula auditing Precedents and dependents Error checking Watch a formula and its result by using the Watch Window Evaluate a nested formula one step at a time Data Validation Number Validation Data List Validation Message Prompts and Alerts Conditional Data Validation Data Validation Errors Consolidation Consolidate data by position Consolidate data by category Use a formula to consolidate data Outline (group) data in a worksheet Create an outline of rows Create an outline of columns Copy outlined data Hide or remove an outline Connect external data to your workbook Using the Power Query Editor to import data From Text and CSV, From Access, From Web, From another Workbook Using the Power Query Editor to; Transform your data by Selecting which fields to import, by Splitting Columns, Changing Data Type and more. Deleting Applied Steps Refreshing your data Working with Form Controls; Buttons, Option Buttons and Scroll Bars Introduction to Macros Change Macro Security settings How to Record a macro Some Macro Examples Delete a macro Edit the macro to view the VBA code Copy part of a macro to create another macro Assign a macro to a button Who is this course for? Who is this course for? This course is intended to end users who want to develop their skills so they can use advanced techniques to analyse extensive and complex datasets in Excel and to automate simple tasks with the use of Macros. Requirements Requirements Preferably, delegates should have attended the Excel Intermediate course. Career path Career path Excel know-how can instantly increase your job prospects as well as your salary. 80 percent of job openings require spreadsheet and word-processing software skills Certificates Certificates Certificate of completion Digital certificate - Included

Begin your journey towards a rewarding and successful career by enrolling in our all-inclusive bundle of 8 Construction Management, WELL Building Standard & Construction Safety courses. At UKHF Online, we have carefully selected and combined these courses to equip you with the vital skills and knowledge necessary to thrive in Construction Management, WELL Building Standard & Construction Safety. Whether you're a student, recent graduate, or job seeker, our Construction Management, WELL Building Standard & Construction Safety bundle is designed to enhance your CV, impress potential employers, and set you apart from the competition. Key Features of the Construction Management, WELL Building Standard & Construction Safety Bundle: 3 QLS-Endorsed Courses: We proudly offer 3 QLS-endorsed courses within our Construction Management, WELL Building Standard & Construction Safety bundle, providing you with industry-recognized qualifications. Plus, you'll receive a free hardcopy certificate for each of these courses. QLS Course 01: Construction Management QLS Course 02: WELL Building Standard QLS Course 03: Construction Safety 5 CPD QS Accredited Courses: Additionally, our bundle includes 5 relevant CPD QS accredited courses, ensuring that you stay up-to-date with the latest industry standards and practices. Course 01: Construction Industry Scheme (CIS) Course 02: Construction Cost Estimation Diploma Course 03: Construction Safety Course 04: Landscape Architecture Course 05: Land Surveying In Addition, you'll get Five Career Boosting Courses absolutely FREE with this Bundle. Course 01: Professional CV Writing Course 02: Job Search Skills Course 03: Self-Esteem & Confidence Building Course 04: Professional Diploma in Stress Management Course 05: Complete Communication Skills Master Class Learning Outcomes of this Bundle: Master the foundational principles and techniques of Construction Management, WELL Building Standard & Construction Safety. Develop advanced proficiency in Construction Management, WELL Building Standard & Construction Safety methodologies and strategies. Acquire in-depth knowledge of the latest trends and advancements in Construction Management, WELL Building Standard & Construction Safety. Enhance your problem-solving and critical thinking abilities within the context of Construction Management, WELL Building Standard & Construction Safety. This bundle is a comprehensive collection of courses that have been meticulously designed to provide you with a well-rounded education in Construction Management, WELL Building Standard & Construction Safety. With a combination of 3 QLS-endorsed courses and 5 CPD QS-accredited courses, this bundle offers you the perfect balance of essential knowledge and valuable skills. What's more, we are proud to offer free hardcopy certificates for each course within the Construction Management, WELL Building Standard & Construction Safety bundle, giving you the recognition you deserve. CPD 260 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Individuals looking to establish a career in the construction industry Professionals seeking to enhance their existing skills and knowledge Anyone interested in learning more about construction management, safety regulations and sustainable building design Career path Landscape Architect: £22,000 - £45,000 Land Surveyor: £20,000 - £45,000 Construction Cost Estimator: £24,000 - £48,000 Health and Safety Officer: £25,000 - £50,000 Certificates Digital certificate Digital certificate - Included Hard copy certificate Hard copy certificate - Included

Course Overview The comprehensive Skateboarding for Beginners has been designed by industry experts to provide learners with everything they need to enhance their skills and knowledge in their chosen area of study. Enrol on the Skateboarding for Beginners today, and learn from the very best the industry has to offer! This best selling Skateboarding for Beginners has been developed by industry professionals and has already been completed by hundreds of satisfied students. This in-depth Skateboarding for Beginners is suitable for anyone who wants to build their professional skill set and improve their expert knowledge. The Skateboarding for Beginners is CPD-accredited, so you can be confident you're completing a quality training course will boost your CV and enhance your career potential. The Skateboarding for Beginners is made up of several information-packed modules which break down each topic into bite-sized chunks to ensure you understand and retain everything you learn. After successfully completing the Skateboarding for Beginners, you will be awarded a certificate of completion as proof of your new skills. If you are looking to pursue a new career and want to build your professional skills to excel in your chosen field, the certificate of completion from the Skateboarding for Beginners will help you stand out from the crowd. You can also validate your certification on our website. We know that you are busy and that time is precious, so we have designed the Skateboarding for Beginners to be completed at your own pace, whether that's part-time or full-time. Get full course access upon registration and access the course materials from anywhere in the world, at any time, from any internet-enabled device.  Our experienced tutors are here to support you through the entire learning process and answer any queries you may have via email.

The 1st4sport Level 2 Certificate in Coaching Multi-Skills Development in Sport qualifies your learners to work as independent multi-skills development coaches in sport and physical activity. Minimum numbers apply. Course description This qualification is designed to prepare learners for deployment as independent coaches of multi-skills and physical activity and will introduce learners to the principles of coaching fundamental movement skills and sport specific skills. The concluding assessment will evaluate the planning, delivery and review of a series of linked and progressive coaching sessions. Is it for me? The qualification is designed for those who wish to deliver multi-skills as an independent coach and wish to take responsibility for the ongoing development of participants at a variety of ages within Sport / Physical Activity Sectors. What will I achieve? A level 2 multi-skills coach will be able to apply this knowledge to plan, deliver and review sessions purely linked to the development of fundamental movement skills or sport-specific skills. This qualification is usually a key requirement to be able to coach in a Education environment.

All in One Bundle Special Discount Offer Are you looking to enhance your Office Skills for Admin, Secretarial, PA (Executive PA)? If yes, then you have come to the right place. Our comprehensive courses on Microsoft Excel- Office Skills for Admin, Secretarial, PA (Executive PA) will assist you in producing the best possible outcome by learning the Office Skills for Admin, Secretarial, PA (Executive PA). Course 01: This Microsoft Office Bundle Microsoft Excel 2019 Microsoft Word 2019 Microsoft PowerPoint 2019 Microsoft Access 2019 Course 02: Admin, Secretarial, PA The Office Skills for Admin, Secretarial, PA (Executive PA) bundle is for those who want to be successful. In the Office Skills for Admin, Secretarial, PA (Executive PA) bundle, you will learn the essential knowledge needed to become well versed in Office Skills for Admin, Secretarial, PA (Executive PA). Our Office Skills for Admin, Secretarial, PA (Executive PA) bundle starts with the basics of Office Skills for Admin, Secretarial, PA (Executive PA) and gradually progresses towards advanced topics. Therefore, each lesson of this Microsoft Excel- Office Skills for Admin, Secretarial, PA (Executive PA) is intuitive and easy to understand. Why would you choose the course from Compliance Central: Lifetime access to courses materials Full tutor support is available from Monday to Friday Learn at your own pace from the comfort of your home Accessible, informative learning modules designed by expert instructors Get 24/7 help or advice from our email and live chat teams with the bundle Study in your own time through your computer, tablet or mobile device Curriculum Breakdown of the Microsoft Office Skills for Admin, Secretarial, PA (Executive PA) Microsoft Excel 2019 Microsoft Excel 2019 New Features Getting Started with Microsoft Excel Performing Calculations Modifying a Worksheet Formatting a Worksheet Printing Workbooks Managing Workbooks Microsoft Word 2019 Microsoft Word 2019 New Features Getting Started with Word Formatting Text and Paragraphs Working More Efficiently Managing Lists Adding Tables Inserting Graphic Objects Controlling Page Appearance Preparing to Publish a Document Microsoft PowerPoint 2019 Microsoft PowerPoint 2019 New Features PowerPoint Interface Presentation Basics Formatting Inserting Options Working with Objects Table Charts Review and Presentation Microsoft Access 2019 Microsoft Access 2019 New Features Introduction to Access Modify Data Working with Queries Access Forms Working with Reports CPD 25 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The Microsoft Office Skills for Admin, Secretarial, PA (Executive PA) bundle helps aspiring professionals who want to obtain the knowledge and familiarise themselves with the skillsets to pursue a career in Office Skills for Admin, Secretarial, PA (Executive PA). Requirements To enrol in this Microsoft Office Skills for Admin, Secretarial, PA (Executive PA) course, all you need is a basic understanding of the English Language and an internet connection. Career path The Microsoft Office Skills for Admin, Secretarial, PA (Executive PA) bundle will enhance your knowledge and improve your confidence in exploring opportunities in various sectors related to Microsoft Office Skills for Admin, Secretarial, PA (Executive PA). Certificates 2 CPD Accredited PDF Certificate Digital certificate - Included 2 CPD Accredited PDF Certificate for Free CDP Accerdited Hardcopy Certificate Hard copy certificate - £10.79 Delivery Charge: Inside the UK: Free Outside of the UK: £9.99 each

***24 Hour Limited Time Flash Sale*** Agricultural Science, Forestry & Horticulture Endorsed Training Admission Gifts FREE PDF & Hard Copy Certificate| PDF Transcripts| FREE Student ID| Assessment| Lifetime Access| Enrolment Letter Begin your journey towards a rewarding and successful career by enrolling in our all-inclusive bundle of 8 Agricultural Science, Forestry & Horticulture Endorsed Training courses. At UKHF Online, we have carefully selected and combined these courses to equip you with the vital skills and knowledge necessary to thrive in Agricultural Science, Forestry & Horticulture Endorsed Training. Whether you're a student, recent graduate, or job seeker, our Agricultural Science, Forestry & Horticulture Endorsed Training bundle is designed to enhance your CV, impress potential employers, and set you apart from the competition. Key Features of the Agricultural Science, Forestry & Horticulture Endorsed Training Bundle: 3 QLS-Endorsed Courses: We proudly offer 3 QLS-endorsed courses within our Agricultural Science, Forestry & Horticulture Endorsed Training bundle, providing you with industry-recognized qualifications. Plus, you'll receive a free hardcopy certificate for each of these courses. QLS Course 01: Agricultural Science QLS Course 02: Horticulture QLS Course 03: Forestry 5 CPD QS Accredited Courses: Additionally, our bundle includes 5 relevant CPD QS accredited courses, ensuring that you stay up-to-date with the latest industry standards and practices. Course 01: Botany Course 02: Arboriculture Course 03: Mushroom Growing Course Course 04: Gardening : Hydroponics Gardening Course 05: Land Management In Addition, you'll get Five Career Boosting Courses absolutely FREE with this Bundle. Course 01: Professional CV Writing Course 02: Job Search Skills Course 03: Self Esteem & Confidence Building Course 04: Professional Diploma in Stress Management Course 05: Complete Communication Skills Master Class Convenient Online Learning: Our Agricultural Science, Forestry & Horticulture Endorsed Training courses are accessible online, allowing you to learn at your own pace and from the comfort of your own home. Learning Outcomes of the Agricultural Science, Forestry & Horticulture Endorsed Training Bundle: Master the foundational principles and techniques of Agricultural Science, Forestry & Horticulture Endorsed Training. Develop advanced proficiency in Agricultural Science, Forestry & Horticulture Endorsed Training methodologies and strategies. Acquire in-depth knowledge of the latest trends and advancements in Agricultural Science, Forestry & Horticulture Endorsed Training. Enhance your problem-solving and critical thinking abilities within the context of Agricultural Science, Forestry & Horticulture Endorsed Training. Cultivate strong communication and collaboration skills essential for success in Agricultural Science, Forestry & Horticulture Endorsed Training. The Agricultural Science, Forestry & Horticulture Endorsed Training bundle is a comprehensive collection of courses that have been meticulously designed to provide you with a well-rounded education in Agricultural Science, Forestry & Horticulture Endorsed Training. With a combination of 3 QLS-endorsed courses and 5 CPD QS-accredited courses, this bundle offers you the perfect balance of essential knowledge and valuable skills. What's more, we are proud to offer free hardcopy certificates for each course within the Agricultural Science, Forestry & Horticulture Endorsed Training bundle, giving you the recognition you deserve. CPD 250 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This course suits anyone interested in pursuing a career in the agricultural, forestry, or horticultural industry. It is particularly relevant for: Students are interested in pursuing a degree in agriculture, forestry, or horticulture. Professionals working in the agricultural, forestry, or horticultural industry who want to enhance their skills and knowledge. Individuals who want to start their own agricultural, forestry, or horticultural business. Farmers, ranchers, and other agricultural workers who want to improve their practices. Environmentalists and conservationists who want to learn more about sustainable agriculture and forestry. Career path Agricultural Scientist Horticulturist Forester Land Manager Environmental Consultant Arborist Mushroom Grower Certificates Digital certificate Digital certificate - Included Hard copy certificate Hard copy certificate - Included

Premium Bundle of all Time | Ofqual Regulation + NCFE Awards + CPD Accreditation | Assessment & Tutor Support Included

In today's bustling world, the power of genuine listening is often overlooked, particularly in leadership positions. The 'Effective Listening Skills for Leaders' course delves deep into the core principles that underpin this invaluable skill, enabling leaders to build stronger connections, foster understanding, and drive meaningful change. From laying the foundation of active listening to mastering its nuanced techniques, this course offers a comprehensive guide for those eager to elevate their leadership prowess. Learning Outcomes Comprehend the core principles and importance of effective listening in leadership roles. Identify barriers to active listening and develop strategies to overcome them. Apply advanced techniques to ensure full engagement and understanding during conversations. Reflect on personal listening habits, recognising areas for improvement. Construct a personalised action plan for continuous enhancement of listening capabilities. Why buy this Effective Listening Skills for Leaders course? Unlimited access to the course for forever Digital Certificate, Transcript, student ID all included in the price Absolutely no hidden fees Directly receive CPD accredited qualifications after course completion Receive one to one assistance on every weekday from professionals Immediately receive the PDF certificate after passing Receive the original copies of your certificate and transcript on the next working day Easily learn the skills and knowledge from the comfort of your home Certification After studying the course materials of the Effective Listening Skills for Leaders there will be a written assignment test which you can take either during or at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60. Who is this Effective Listening Skills for Leaders course for? Emerging leaders keen on amplifying their communication skills. Managers desiring a deeper connection with their teams. Professionals aiming to reduce misunderstandings and conflicts at work. Individuals keen on enhancing personal relationships through better listening. Anyone aspiring to boost their leadership potential through effective communication. Prerequisites This Effective Listening Skills for Leaders does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Effective Listening Skills for Leaders 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. Career path Team Leader: £25,000 - £35,000 Project Manager: £35,000 - £50,000 Human Resources Manager: £30,000 - £45,000 Operations Manager: £40,000 - £55,000 Executive Coach: £50,000 - £70,000 Organisational Development Consultant: £45,000 - £60,000 Course Curriculum Section 01: Introduction Introduction & Welcome 00:02:00 Section 02: Foundation of Listening What is Your Listening Barrier? 00:07:00 Nonverbal Cues and Body Language Tips 00:05:00 Types of Listening for Leaders 00:05:00 Section 03: Listening Skills & Practice Comprehensive Listening 00:07:00 Let's Practice Listening for Comprehension 00:07:00 Empathetic Listening 00:09:00 Let's Practice Listening with Empathy 00:08:00 Critical Listening 00:08:00 Let's Practice Critical Listening 00:06:00 Appreciative Listening 00:03:00 Section 04: Wrap Up and Next Steps Next Steps 00:02:00

Do you want to brush up on your communication skills? Do you get nervous while communicating both verbally and nonverbally? If you do so, this course comes to your rescue! This comprehensive course describes the importance of strong business communication skills for career development. With this course, take the opportunity to get closer to mastering the most powerful communication skills, from professional writing to business presentations, verbal to non-verbal communication, and written communication to electronic communication. With units ranging from communicating with graphics, representing your boss to supporting and building partnerships with your boss and colleagues, the course provides a comprehensive knowledge of developing business connections that increase productivity, employee loyalty, customer satisfaction and build trust. In just 2 Hours 26 minutes you will: Develop the ability to communicate effectively with superiors, colleagues, and staff Effectively convey and receive messages in person and through phone, email, text message and social media Make a solid first impression and impress your boss, teammates, and clients Appear approachable and excel at both face-to-face and written communication Become an excellent communicator and know what form of communication to use 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? Level 2 Certificate in Workplace Communication Skills is suitable for anyone who want to gain extensive knowledge, potential experience and professional skills in the related field. This course is designed by industry experts so you don't have to worry about the quality. Most importantly, this course does not require any experience or qualification to get enrolled. You will learn everything that is required from this course directly. This is a great opportunity for all student from any academic backgrounds to learn more on this subject. This qualification is ideal for: Managers Team Leaders Executives Administrators Employees Businesspeople Directors

Overview Overview This course is designed to develop skills and gain more knowledge of Change Management. For people who want to transform their skills and career and explore every opportunity, this course well suits their needs. It is very important to understand Change Management and adopt the changes within the organisation and work culture. It will be impossible to grow or even to improve ourselves without any changes. Changes happen to take place either in a positive nature or in negative nature. No matter how it happens to appear, we need skills to respond to the changes and respond accordingly.  We need to enhance our skills on a daily basis in this changing environment to handle what we encounter. It is observed that Change is very important for growth, diversity and success. Every business needs to go through the changing process to adapt the new things and walk with the new developments. Thus, as a professional, we also are in need to continually change to maintain and improve our competencies and skills and to achieve our targeted goals. We need to be extroverted with the environment to understand what is happening, where, when and what change needs to be brought.