50884 Courses in Cardiff delivered Online

Course Objectives The goal of this course is to provide you with the knowledge required to use more advanced functions and formulas and work with various tools to analyse and present data in spreadsheets, such as sorting, filtering, applying conditional formatting and charting the data. ' Customer Feedback Really useful and engaging course. Learnt a lot that will be very beneficial in my job. Trainer was great. Kelly Moreley - TACT Very happy with the course. Worked as a good refresher from what I knew already and enhanced my knowledge further in formulas + vlookup and shortcut keys. Jenny Price - Acer 1 year email support service Take a look at the consistent excellent feedback from our 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. Tailored training courses: In, in company training, you can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs. Recap on Excel formulas and calculations Overview of formulas in Excel Relative, Absolute and Mixed cell references Group editing worksheets Autofill and Flash Fill Changing Excel’s environment Options Changing the default number of sheets Creating an Autofill Custom List Adding tools to the Quick Access Toolbar Mastering Excel Tables Introducing Excel Tables Formatting a Table Creating Calculated Columns Using Slicers to filter your data Using Totals to get statistics out of your data Removing duplicates Converting Tables back to normal Ranges Using names Ranges In Excel formulas As a way of navigating through the workbook Advanced Formulas Simple IF examples Using IF to check if a cell is blank Nested IFs VLOOKUP HLOOKUP Text Functions Date Functions Conditional formatting Apply Conditional Formatting Customising Conditional Formatting Using Icons in Conditional Formatting Using Formulas to conditionally format cells Linking spreadsheets and workbooks Making a reference to another worksheet Making a reference to another workbook Editing links Troubleshooting links Analysing databases Quick analysis Sorting a database Apply filters to a database Advance filter Sorting and Filtering by Conditional Formats Charts Analyse trends in data using Sparklines Creating charts from start to finish Exploring the different Chart Types Apply Chart Styles Formatting Chart Elements Filtering Charts by Series or Categories Adding a Trendline to a Chart Create a Chart Template Attaching security to a spreadsheet and workbook Protect Cells Protect Structure of worksheets Protect a Workbook by adding passwords Introduction to Pivot Tables What are Pivot Tables? Using recommended pivot tables to analyse your data Who is this course for? Who is this course for? For those who want to explore in more detail formulas and functions, data analysis and data presentation. Requirements Requirements Preferably, delegates would have attended the Excel Introduction 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

***24 Hour Limited Time Flash Sale*** Corporate Finance: Management & Analysis Admission Gifts FREE PDF & Hard Copy Certificate| PDF Transcripts| FREE Student ID| Assessment| Lifetime Access| Enrolment Letter Are you a professional feeling stuck in your career, struggling to keep up with the ever-changing demands of the industry? Or perhaps you're a beginner, unsure of where to start or how to break into your desired field. Whichever stage you're in, our exclusive Corporate Finance: Management & Analysis Bundle provides unique insights and tools that can help you achieve your goals. Designed to cater to the needs of both seasoned professionals and aspiring newcomers, our Corporate Finance: Management & Analysis bundle is a comprehensive program that will equip you with the essential skills and knowledge you need to succeed. Whether you're looking to advance in your current role or embark on a new career journey, this bundle has everything you need to take your professional life to the next level. But that's not all. When you enrol in Corporate Finance: Management & Analysis Online Training, you'll receive 30 CPD-Accredited PDF Certificates, Hard Copy Certificates, and our exclusive student ID card, all absolutely free. Courses Are Included In this Corporate Finance: Management & Analysis Career Bundle: Course 01: Fundamentals of Corporate Finance Course 02: Corporate Finance: Working Capital Management Course 03: Corporate Finance: Profitability in a Financial Downturn Course 04: Financial Management Course 05: Xero Accounting and Bookkeeping Online Course 06: Basic Data Analysis Course 07: Financial Ratio Analysis for Business Decisions Course 08: Changes in Accounting: Latest Trends Encountered by CFOs in 2022 Course 09: Commercial Law Course 10: Raise Money and Valuation for Business Course 11: Improve your Financial Intelligence Course 12: Cost Control Process and Management Course 13: UK Tax Accounting Course 14: Financial Modelling Course - Learn Online Course 15: Financial Modeling Using Excel Course 16: Financial Analysis Course 17: Dynamic Excel Gantt Chart and Timelines Course 18: Stock Trading & Investing Course 19: Business Model Canvas for Business Plan Course 20: Stock Market Day Trading Strategies for Beginners Course 21: Financial Ratio Analysis for Business Decisions Course 22: Corporate & Strategic Communication Skills for Managers Course 23: Learn to Read, Analyse and Understand Annual Reports Course 24: Fundamentals of Zero Based Budgeting Course 25: Develop Your Career in Finance: Blue Ocean Strategy Course 26: Excel Vlookup, Xlookup, Match and Index Course 27: Debt Management - Online Course Course 28: Financial Statements Fraud Detection Training Course 29: Personal Productivity Course Course 30: Banking and Finance Accounting Statements Financial Analysis With Corporate Finance: Management & Analysis, you'll embark on an immersive learning experience that combines interactive lessons with voice-over audio, ensuring that you can learn from anywhere in the world, at your own pace. And with 24/7 tutor support, you'll never feel alone in your journey, whether you're a seasoned professional or a beginner. Don't let this opportunity pass you by. Enrol in Corporate Finance: Management & Analysis today and take the first step towards achieving your goals and dreams. Why buy this Corporate Finance: Management & Analysis? Free CPD Accredited Certificate upon completion of Corporate Finance: Management & Analysis Get a free student ID card with Corporate Finance: Management & Analysis Lifetime access to the Corporate Finance: Management & Analysis course materials Get instant access to this Corporate Finance: Management & Analysis course Learn Corporate Finance: Management & Analysis from anywhere in the world 24/7 tutor support with the Corporate Finance: Management & Analysis course. Start your learning journey straightaway with our Corporate Finance: Management & Analysis Training! Corporate Finance: Management & Analysis premium bundle consists of 30 precisely chosen courses on a wide range of topics essential for anyone looking to excel in this field. Each segment of Corporate Finance: Management & Analysis is meticulously designed to maximise learning and engagement, blending interactive content and audio-visual modules for a truly immersive experience. Certification You have to complete the assignment given at the end of the Corporate Finance: Management & Analysis course. After passing the Corporate Finance: Management & Analysis exam You will be entitled to claim a PDF & Hardcopy certificate accredited by CPD Quality standards completely free. CPD 300 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This bundle is ideal for: Students seeking mastery in this field Professionals seeking to enhance their skills Anyone who is passionate about this topic Requirements This Corporate Finance: Management & Analysis doesn't require prior experience and is suitable for diverse learners. Career path This Corporate Finance: Management & Analysis bundle will allow you to kickstart or take your career in the related sector to the next stage. Certificates CPD Accredited Digital certificate Digital certificate - Included CPD Accredited Hard copy certificate Hard copy certificate - Included If you are an international student, then you have to pay an additional 10 GBP for each certificate as an international delivery charge.

QLS Endorsed + CPD QS Accredited - Dual Certification | Instant Access | 24/7 Tutor Support | All-Inclusive Cost

Constantly making up and breaking up Improve communication Self-regulation Improve understanding Address trust and respect issues Healthy relationship course Be a better partner training for both parties Emotional intelligence and relationship disciplines training 6 sessions 1-hour x 6 https://relationshipsmdd.com/product/our-relationship-is-an-emotional-rollercoaster/

Get a Free 1 QLS Endorsed Certificate Course with 10 Additional CPD Accredited Bundle Courses In A Single Payment. If you wish to gain a solid and compact knowledge of Mentoring Training (Mentorship) and boost yourself for your desired career, then take a step in the right direction with this industry-standard, comprehensive course designed by professionals. This bundle package includes 1 Premium, The Quality Licence Scheme-endorsed course, 10 additional CPD Accredited Certificate courses, with expert assistance, and a FREE courses assessment included. Learn a range of in-demand technical skills to help you progress your career with 12 months of unlimited access to this bundle of courses. If you enrol in this package, you will not be charged any extra fees. This Mentoring Training (Mentorship) Bundle Package includes: Course 01: Diploma in Mentoring Course at QLS Level 5 10 Additional CPD Accredited Premium Courses - Course 01: Becoming Career Smart: How to Sell Yourself Course 02: Transformational Leadership: Ultimate Leadership Course Course 03: Productivity Development Course 04: Growth Mindset for Success Course 05: Smart Goal Setting Course 06: Performance Coaching Course 07: Communication Skills Masterclass Course 08: Super Learning Course 09: Workplace Stress Management Diploma Course 10: Online Time Management Training Success becomes a lot simpler with this bundle package, which allows you to monetise your skills. This bundle is appropriate for both part-time and full-time students, and it can be completed at your own pace. This premium online bundle course, named Mentoring Training (Mentorship), supports your professional growth with Quality Licence Scheme endorsement, as well as CPD accreditation. You'll be able to practice on your own time and at your speed while still gaining an endorsed certificate. You'll get an unrivalled learning experience, as well as a Free Student ID card, which is included in the Bundle price. This ID card entitles you to discounts on bus tickets, movie tickets, and library cards. With this high-quality package, all students have access to dedicated tutor support and 24/7 customer service. Throughout the extensive syllabus of this Mentoring Training (Mentorship) package, you'll find the required assistance and also answers to all of your questions. The course materials are designed by experts and you can access these easily from any of your smartphones, laptops, PCs, tablets etc. Master the skills to arm yourself with the necessary qualities and explore your career opportunities in relevant sectors. Why Prefer this Bundle Course? Upon successful completion of the bundle, you will receive a completely free certificate from the Quality Licence Scheme. Option to receive 10 additional certificates accredited by CPD to expand your knowledge. Get a Free Student ID card with this course! (£10 postal charges will be applicable for international delivery) Our bundle's learning materials have engaging voiceover and visual elements for your convenience. For a period of 12 months, you will have 24/7 access to all bundle course material. Complete the bundle, at your own pace. Each of our students gets full 24/7 tutor support After completing our Bundle, you will receive efficient assessments and immediate results. Start your learning journey straight away with this bundle and take a step toward a brighter future! *** Course Curriculum: *** The Mentoring Training (Mentorship) bundle courses have the following curriculum: Course 01: Diploma in Mentoring Course at QLS Level 5 Module 01: Introduction to Coaching and Mentoring Module 02: The Process of Mentoring Module 03: Matching Mentors and Mentees Module 04: Making Mentoring Work for You Module 05: Ethical Aspects of Coaching and Mentoring Module 06: Coaching and Mentoring Models (Part 01) Module 07: Coaching and Mentoring Models (Part 02) Module 08: Effective Communication Skills for Mentoring Module 09: Personal Skills Module 10: Management Skills What is the Bundle Assessment Process? We offer an integrated assessment framework to make the process of evaluation and accreditation for learners easier. You have to complete the assignment questions given at the end of thecourse and score a minimum of 60% to pass each exam. Our expert trainers will assess your assignment and give you feedback after you submit the assignment. You will be entitled to claim a certificate endorsed by the Quality Licence Scheme after you have completed all of the Diploma in Mentoring at QLS Level 5 exams. CPD 250 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Are you the right candidate for this Mentoring Training (Mentorship) bundle? The package training is perfect for highly motivated people who want to improve their technical skills and prepare for the career they want! This bundle is also ideal for those who want to learn more about this subject in-depth and stay up to date with the latest details. Enrollment in this bundle is open to everybody. You can access the Mentoring Training (Mentorship) bundle materials from anywhere in the world; there are no restrictions. You should enrol in this bundle if you: Wish to gain a better understanding of the related field. Already working in this field and want to learn more. Is a student pursuing a relevant field of study? looking for a job in the Coaching & Mentoring industry. Requirements You will not need any prior background or expertise. All you need to take this Mentoring Training (Mentorship) bundle is - A smart device. A secure internet connection. Being over the age of 16. And a strong drive for learning and literacy. Career path The Mentoring Training (Mentorship) bundle course aims to help you get the job or even the long-awaited promotion of your dreams. With the support and guidance of our package, you will learn the skills and knowledge that are important to your career. Certificates Diploma in Mentoring at QLS Level 5 Hard copy certificate - Included For Additional The Quality Licence Scheme Courses, You have to pay the price based on the Level of these Courses: Level 1 - £59 Level 2 - £79 Level 3 - £89 Level 4 - £99 Level 5 - £119 Level 6 - £129 Level 7 - £139 CPD Accredited Certificate 29 GBP for Printed Hardcopy Certificate inside the UK 39 GBP for Printed Hardcopy Certificate outside the UK (International delivery) CPD Accredited Certificate Digital certificate - £10 Upon passing the Bundle, you need to order to receive a Digital Certificate for each of the courses inside this bundle as proof of your new skills that are accredited by CPD.

Scrum Product Owner Workshop: In-House Training: Virtual In-House Training The Product Owner is responsible for maximizing the value of the product and the work of the Development Team. The Product Owner must be knowledgeable, available, and empowered to make decisions quickly in order for an Agile project to be successful. The Product Owner's key accountability is the Product Backlog. Managing, maintaining, and evolving the Product Backlog involves: Establishing a clear Vision that engages the Development Team and stakeholders Clearly expressing Product Backlog items Ordering the items in the Product Backlog to best achieve the Vision and goals Ensuring that the Product Backlog is visible, transparent, and clear to all Working with the Development Team throughout the project to create a product that fits the customer's needs The overall course goal is to support you in becoming an effective Product Owner. What you will Learn You'll learn how to: Differentiate between poor, good, and great Product Owner attributes, and their impact on the team, product, stakeholders, and the organization Engage your stakeholders by knowing your customers and market Develop an effective and value-driven Product Backlog Evaluate the Product Owner's role in Scrum's 5 events and team engagement Foundation Concepts Agile foundation Product owner role Product Ownership Product ownership Project vision Understanding your customers and market Personas Stakeholder management and engagement The Product Backlog Epics and user stories Preparing user stories for a sprint The product backlog Visualizing the product backlog Product backlog prioritization Technical debt Sprint Planning and Delivery Sprint planning The sprint Sprint Reviews, Retrospectives, and Closing Sprint reviews Key agile patterns Retrospectives Closing the project

***24 Hour Limited Time Flash Sale*** Financial Engineering & Risk Management Admission Gifts FREE PDF & Hard Copy Certificate| PDF Transcripts| FREE Student ID| Assessment| Lifetime Access| Enrolment Letter Do you know that the UK finance sector contributes over 12% to the national GDP? But with such a significant role come inherent risks and complexities. Are you equipped to navigate this dynamic landscape? This Financial Engineering & Risk Management bundle delivers the analytical abilities and financial intelligence today's businesses need. Designed to cater to the needs of both seasoned professionals and aspiring newcomers, our Financial Engineering & Risk Management bundle is a comprehensive program that will equip you with the essential skills and knowledge you need to succeed. Whether you're looking to advance in your current role or embark on a new career journey, this bundle has everything you need to take your professional life to the next level. But that's not all. When you enrol in Financial Engineering & Risk Management Online Training, you'll receive 30 CPD-Accredited PDF Certificates, Hard Copy Certificates, and our exclusive student ID card, all absolutely free. Courses Are Included In this Financial Engineering & Risk Management Career Bundle: Course 01: Diploma in Financial Analysis at QLS Level 5 Course 02: Financial Management Course 03: Risk Management Course 04: Financial Ratio Analysis for Business Decisions Course 05: Accounting Basics Course 06: Fundamentals of Zero-Based Budgeting Course 07: Quickbooks Online Course 08: Cost Control & Project Scheduling Course 09: Dealing With Uncertainty: Make Budgets and Forecasts Course 10: Sage 50 Accounts Course 11: Presenting Financial Information Course 12: Commercial Law Course 13: Improve Your Financial Intelligence Course 14: Excel Vlookup, Xlookup, Match, and Index Course 15: Changes in Accounting: Latest Trends Encountered by CFOs in 2022 Course 16: Excel Pivot Tables for Data Reporting Course 17: Dynamic Excel Gantt Chart and Timelines Course 18: Raising Money & Valuations Course 19: Stock Trading Analysis with Volume Trading Course 20: Banking and Finance Accounting Statements Financial Analysis Course 21: Financial Statements Fraud Detection Training Course 22: Corporate Finance: Working Capital Management Course 23: Anti-Money Laundering (AML) Training Course 24: Know Your Customer (KYC) Course 25: Day Trade Stocks with Price Action and Tape Reading Strategy Course 26: UK Tax Accounting Course 27: Making Budget & Forecast Course 28: Develop Your Career in Finance: Blue Ocean Strategy Course 29: Xero Accounting and Bookkeeping Online Course 30: Corporate Finance: Profitability in a Financial Downturn With Financial Engineering & Risk Management, you'll embark on an immersive learning experience that combines interactive lessons with voice-over audio, ensuring that you can learn from anywhere in the world at your own pace. Learning Outcomes of Financial Engineering & Risk Management Analyse financial statements for informed decision making. Implement effective risk management strategies. Master budgeting, forecasting, and cost control techniques. Utilize accounting software like QuickBooks and Sage 50. Gain insights into the latest accounting trends and regulations. Develop strong financial literacy and critical thinking skills. Enrol in Financial Engineering & Risk Management today and take the first step towards achieving your goals and dreams. Why buy this Financial Engineering & Risk Management? Free CPD Accredited Certificate upon completion of Financial Engineering & Risk Management Get a free student ID card with Financial Engineering & Risk Management Lifetime access to the Financial Engineering & Risk Management course materials Get instant access to this Financial Engineering & Risk Management course Learn Financial Engineering & Risk Management from anywhere in the world 24/7 tutor support with the Financial Engineering & Risk Management course. Start your learning journey straightaway with our Financial Engineering & Risk Management Training! The Financial Engineering & Risk Management premium bundle consists of 30 precisely chosen courses on a wide range of topics essential for anyone looking to excel in this field. Each segment of Financial Engineering & Risk Management is meticulously designed to maximise learning and engagement, blending interactive content and audio-visual modules for a truly immersive experience. Certification You have to complete the assignment given at the end of the Financial Engineering & Risk Management course. After passing the Financial Engineering & Risk Management exam You will be entitled to claim a PDF & Hardcopy certificate accredited by CPD Quality standards completely free. CPD 450 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This bundle is ideal for: Students seeking mastery in this field Professionals seeking to enhance their skills Anyone who is passionate about this topic Requirements This Financial Engineering & Risk Management doesn't require prior experience and is suitable for diverse learners. Career path This Financial Engineering & Risk Management bundle will allow you to kickstart or take your career in the related sector to the next stage. Financial analyst Budget analyst FP&A manager Accounting manager Financial consultant Certificates CPD Accredited Digital certificate Digital certificate - Included CPD Accredited Hard copy certificate Hard copy certificate - Included If you are an international student, then you have to pay an additional 10 GBP for each certificate as an international delivery charge. Diploma in Financial Analysis at QLS Level 5 Hard copy certificate - Included

The Disability Studies Training Course provides in-depth insights into the challenges and opportunities within the field of disability. Whether you are looking to understand the social, legal, or healthcare aspects of disability, this course offers a broad exploration of relevant topics. You will develop a strong understanding of disability theories, models, and the key policies that shape the lives of individuals with disabilities. With engaging modules, you'll explore diverse areas, from education and employment to healthcare provision and social support systems, offering a holistic view of how society interacts with and supports disabled individuals. Designed for those interested in creating a more accessible and supportive environment for all, this course delves into the critical issues that people with disabilities face in their daily lives. By studying various perspectives on disability, you will gain a well-rounded knowledge base, preparing you to better advocate for and work alongside individuals with disabilities in various settings. Whether you're looking to improve your understanding for personal growth or career development, this course provides valuable insights into an important and often underrepresented area of study. 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 Module 1: Introduction to Disability Studies Module 2: Social and Cultural Perspectives on Disability Module 3: Disability and Society Module 4: Health and Well-being for People with Disabilities Module 5: Disability and Intersectionality Module 6: Disability and Global Perspectives Learning Outcomes: Analyse societal perceptions influencing disability dynamics. Demonstrate a nuanced understanding of disability's social and cultural dimensions. Evaluate the impact of disability on individuals and wider society. Implement strategies to enhance health and well-being for people with disabilities. Recognise and navigate intersections between disability and various identities. Apply a global perspective to understand diverse manifestations of disability. 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. Certificate After completing this course, you will get a FREE Digital Certificate from Training Express. CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Individuals passionate about social justice. Students aspiring to work in healthcare or advocacy. Educators seeking a deeper understanding of diversity. Professionals in social work or community development. Anyone interested in fostering an inclusive society. Advocates for human rights and equality. Individuals pursuing careers in public health. Those committed to promoting global inclusivity. Career path Disability Rights Advocate Inclusive Education Coordinator Community Support Worker Public Health Consultant Diversity and Inclusion Specialist NGO Program 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.

Course Objectives This course aims to provide delegates with a foundation for Excel knowledge and skills. ' Customer Feedback Very professional and well mannered, fun and pleasant at the same time. I learnt a lot Carolina Foster - CNN Very helpful course. Would definitely take another one. Pedro was very patient and made it fun and engaged with us all. Laura Smith - James Grant Great course and excellent trainer. Thanks Tracy Preston - Western Power Distribution 1 year email support service Take a look at the consistent excellent feedback from our 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. What is Excel? The Excel Interface Ribbon, Tabs and Groups Microsoft Office Backstage view Working with Workbooks Create a blank Workbook Create a Workbook using a Template Opening and saving Files Working with worksheets Worksheet navigation Select one or multiple Worksheets Insert, Move, Copy or Delete a Worksheet Working with Cells, Rows & Columns Cell References How to select cells or ranges Different types of data Move, Copy and Delete cells Pasting Options Find and Replace Working with Rows and Columns Overview of formulas in Excel Autocalculation The parts of an Excel formula Using calculation operators in Excel formulas The difference between Absolute, Relative and Mixed references Using Excel functions; Sum, Average, Max and Min Cell Formatting Font Format options Number Format options Change the Fill and Borders Cell Alignment An Introduction to Charts Create a simple Chart Format your chart Page Layout and Print Page Layout and Page Break View Change the Page Orientation Set Page Margins Headers and Footers in a worksheet Print a worksheet or workbook Who is this course for? Who is this course for? All users who want to master the main features of Microsoft Excel Requirements Requirements General knowledge of the Windows OS Certificates Certificates Certificate of completion Digital certificate - Included

Level 5 QLS Endorsed | 150 CPD Points| +Gifts: QLS Certificate + PDF Certificate | Lifetime Access| 24/7 Learner Support