Sanctions Awareness Designed for non-sanctions experts Sanctions compliance is a high-profile area of risk management and regulatory scrutiny. This online course is designed for non-specialists and is a great starting point for those looking to gain knowledge and demystify this complex area. Sanctions fundamentals- get to grips with sanctions and their significance in today's international environment Application and impact- understand how sanctions are applied, their impact and the different categories of sanctions Challenges- identify what are they and how to apply the learnings in your workplace Red flags- know what to look out for when dealing with customers and clients. What are sanctions and who imposes them? Types of sanctions Who, what and where in the world? Other stakeholders involved Sanctions hazard perception
Do you wonder how to best use Google+ to enhance your marketing? Do you want to create google plus profile with high number of followers? Do you want to attract customers in the fastest time possible? Do you want to learn the strategies that all very successful 'plussers' know? If yes, you'll benefit from this google plus marketing course Description: Google+ is not a social network for senseless feline pictures or video jokes (despite the fact that you can share those, in the event that you like).Google+ is mostly for marketers, industry specialists and entrepreneurs of any sort. As it were, that makes it practically as professionally oriented as LinkedIn. In any case, Google+ is frequently underrated as a traffic era tool and just a couple of clients truly know how to utilize it to make create engagement and a loyal following. On the off chance that you are one of the individuals who are as yet uncertain about the 'hidden power' of Google+, this course is just tailored for you. By the end of this course, the students will be able to set up their profile, connect with other leaders & businesses in their industry, obtain 1000 targeted followers and give their business an almost immediate boost using Google+. Who is the course for? Anyone who has basic knowledge of computers and want to start a small business Anyone who wants to learn how to grow their Google Plus page. Anyone looking to grow their business and expand their network on Google plus Entry Requirement: This course is available to all learners, of all academic backgrounds. However, an education and experience in accounting is an advantage. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. Assessment: At the end of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After you have successfully passed the test, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hardcopy at a cost of £39 or in PDF format at a cost of £24. PDF certificate's turnaround time is 24 hours and for the hardcopy certificate, it is 3-9 working days. Why choose us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos/materials from the industry leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally recognised accredited qualification; Access to course content on mobile, tablet or desktop from anywhere anytime; The benefit of career advancement opportunities; 24/7 student support via email. Career Path: Diploma in Google Plus Marketing course is a useful qualification to possess, and would be beneficial for the following careers: Integrating products in Google Merchant Google Account Developer Google plus freelance google marketing. Diploma in Google Plus Marketing Introduction to Google +/+1 01:00:00 How to Sign Up for a Google Account 01:00:00 Google Plus Profile for Marketing 02:00:00 Google Buzz 01:00:00 Using Circles for Marketing 02:00:00 Google Streams of Information 01:00:00 Realtime Chat 00:15:00 Google Plus Hangouts 01:00:00 Google Sparks 00:30:00 Google Plus Button and Google Plus Statistics 01:00:00 Google Plus Realtime Search 00:30:00 Use Google Chrome Extensions With Google Plus 00:30:00 Tips on Getting More Google +1 Recommendations 00:30:00 Conclusion 00:15:00 Mock Exam Mock Exam- Diploma in Google Plus Marketing 00:20:00 Final Exam Final Exam- Diploma in Google Plus Marketing 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00
Secure access to the full recording of the workshop of 1 Oct 2023 with Prof Patrick McGhee and Alison Triste. This workshop provides a practical introduction to Brief CBT for Children and Young People. We will examine the distinctive challenges of working with children and young people and provide practical guidance on using Brief CBT (B-CBT) with this group. Guidance is given on working with parents, caregivers, teachers and siblings. The approach and workshop is based on the work of Alison Triste as reflected in her new book, CBT for Young People. This workshop and the book offer a simple, practical approach which can be used by qualified therapists and counsellors as a foundation for delivery of B-CBT for C&YP Topics and Schedule (indicative) Welcome, Introduction and Overview Contemporary Issues in Working with C&YP (Patrick McGhee) Brief CBT - A Practical Framework for Working with C&YP (Alison Triste) Case Study and Breakout Groups (Patrick McGhee) Q&A Summary and Next Steps Workshop Objectives Provide an overview of contemporary ideas and practice in CBT for C&YP Introduce the Triste Brief CBT Framework Apply key ideas to specific examples Review application to own practice About the Presenters Alison Triste BSc (Hons) Psychology, PgDip Cognitive Behavioural Therapy, BABCP Accredited, Gm BPS Alison is a BABCP Accredited Cognitive Behavioural Psychotherapist with 10 years of experience. She provides evidence-based CBT treatments for anxiety, depression, OCD, PTSD, phobias, and other mental health problems. With accreditations from the BPS and BABCP, she offers a collaborative and safe environment to help clients build resilience and manage their emotions. She describes her passion as "enabling children and adults to maximize their potential by working collaboratively to meet their treatment goals by using a combination of symptom reduction protocols in addition to Positive Psychology." In addition to providing private therapy services, she supervises CBT Therapists working with children, adolescents, and adults in a variety of settings including the NHS; Child and Adolescent Mental Health Services (CAMHS); schools; and private practices. Professor Patrick McGhee Professor Patrick McGhee is a CBT therapist, psychologist and UK National Teaching Fellow. Educated at the universities of Glasgow and Oxford, he has completed CPD programmes at Harvard Business School and Ashridge. In 2017 he was a Visiting Fellow/Scholar at the universities of Cornell, Yale and MIT in the USA. He has taught, researched or practised in psychology and therapy for 30 years. His first post was a Research Fellow in Psychiatry and Psychology at St George's Hospital Medical School, University of London. He is the author of Thinking Psychologically (Palgrave) and co-editor of Accounting for Relationships (Methuen). He is an occasional columnist for the Guardian, the BBC and the Times Higher. He currently works in private practice in Greater Manchester. He has full accreditation from the British Association for Behavioural and Cognitive Psychotherapies. Tags
Duration 3 Days 18 CPD hours This course is intended for This course is primarily designed for students who want to gain the skills necessary to use VBA to automate tasks in Excel such as collecting data from external sources, cleaning, and manipulating data. The target student may also want to learn how to create custom worksheet functions to streamline worksheet formulas and make complex worksheets easier to support, maintain, and understand. Overview In this course, you will develop and deploy VBA modules to solve business problems. You will: Identify general components of VBA and their appropriate use in solving business solutions. Record VBA macros to automate repetitive tasks. Use reference tools built into Excel to get help on VBA programming language and objects used in the Excel VBA environment. Write VBA code to create a custom worksheet function. Eliminate, avoid, or handle errors in VBA code, and optimize its performance. Control how and when macros run. Develop UserForm objects to create custom dialog boxes and windows. Use VBA to read and write data from local files and cloud services. Use VBA to clean and transform data. Run programs and commands outside of Excel and share VBA projects with other users VBA (Visual Basic for Applications) enables you to enhance and extend the capabilities of Microsoft© Excel© and other applications in the Microsoft© Office application suite. You can use VBA to perform tasks that would be difficult or impossible to do using only worksheet functions, and you can automate a wide range of tasks involving the collection, processing, analysis, and visualization of data. This course will give you a good foundation for understanding, creating, and using VBA in your own Excel workbooks, show you how to work with data across different applications, and how to package the macros and functions you create so you can back them up, move them to other computers, and share them with other users Prerequisites To ensure your success in this course, you should be an experienced Excel user who is comfortable creating and working with Excel workbooks, including tasks such as entering worksheet formulas, using absolute and relative addressing, formatting cells, and creating pivot tables and charts. This level of skill could be acquired by taking the Microsoft Excel for Office 365? (Desktop or Online) courses, Parts 1, 2, and 3 1 - Using VBA to Solve Business Problems Topic A: Use Macros to Automate Tasks in Excel Topic B: Identify Components of Macro-Enabled Workbooks Topic C: Configure the Excel VBA Environment 2 - Automating Repetitive Tasks Topic A: Use the Macro Recorder to Create a VBA Macro Topic B: Record a Macro with Relative Addressing Topic C: Delete Macros and Modules Topic D: Identify Strategies for Using the Macro Recorder 3 - Getting Help on VBA Topic A: Use VBA Help Topic B: Use the Object Browser to Discover Objects You Can Use in VBA Topic C: Use the Immediate Window to Explore Object Properties and Methods 4 - Creating Custom Worksheet Functions Topic A: Create a Custom Function Topic B: Make Decisions in Code Topic C: Work with Variables Topic D: Perform Repetitive Tasks 5 - Improving Your VBA Code Topic A: Debug VBA Errors Topic B: Deal with Errors Topic C: Improve Macro Performance 6 - Controlling How and When Macros Run Topic A: Prompt the User for Information Topic B: Configure Macros to Run Automatically 7 - Developing Custom Forms Topic A: Display a Custom Dialog Box Topic B: Program Form Events 8 - Using VBA to Work with Files Topic A: Use VBA to Get File and Directory Structure Topic B: Use VBA to Read Text Files Topic C: Use VBA to Write Text Files 9 - Using VBA to Clean and Transform Data Topic A: Automate Power Query Topic B: Transform Data Using VBA and Workbook Functions Topic C: Use Regular Expressions Topic D: Manage Errors in Data 10 - Extending the Programming Environment Beyond the Workbook Topic A: Run Other Programs and Commands Topic B: Share Your VBA Projects
Looking to elevate your marketing game? Let's face it - while many marketers and brand managers have the drive and ambition, they often lack formal training in their field. That's where the Mini MBA series steps in. Imagine having the essential theoretical foundations to confidently lead marketing strategies, manage teams, and climb the career ladder. With the Mini MBA, you don't just imagine - you achieve. Drawing from the world's top online business teaching platform, the Mini MBA offers flexible, accessible, and affordable training tailored for marketers aiming for the top. It's not just about learning; it's about transforming into a more effective and inspired marketer. Join over 30,000 alumni who have experienced the transformative power of the Mini MBA. They didn't just gain knowledge; they gained clarity, confidence, and a great time along the way. Ready to take your marketing skills to new heights? The Mini MBA is your ticket to success. Skills you will learn from the Mini MBA: Strategic Planning Organsational goal Setting Financial Management Managing Finances Marketing Campaigns Brand Management Effective Leadership Team Management Risk Management Key Features Our trusted, high quality and affordable online courses are designed to train individuals to become experts in their field. CPD Certified Instant e-certificate and hard copy dispatch by next working day Fully online, interactive course with audio voiceover Self-paced learning accessible via laptop, tablet and smartphone 24/7 Learning assistance and tutor support Discounts on bulk purchases Course Curriculum Module 01: Appreciating the Mini MBA Module 02: The Foundations of Business Module 03: Understanding Business Law Module 04: Competitive Business Strategies Module 05: Departments in Business Module 06: Planning the Right Strategy for Business Module 07: Managing Human Resources in Business Module 08: Economics Influences on Business Module 09: Business Accounting Module 10: Finance in Business Module 11: Business Marketing Module 12: Advertising and Promotion Module 13: The Art of Negotiation Module 14: Communication and Presentation Module 15: Organisational Behaviour in Business Module 16: Building Teams in Business Module 17: Business Leadership Module 18: Operations Management Module 19: The Importance of Risk Management Module 20: Project Management Module 21: Quantitative Research and Analysis Module 22: Qualitative Research and Analysis Module 23: Becoming an Entrepreneur Module 24: Corporate Social Responsibility (CSR) Module 25: Avoiding Management Mistakes Learning outcomes of the Mini MBA: Enhanced Business Acumen Improved Decision-Making Effective Communication Leadership Development Develop Entrepreneurial Mindset Accreditation This course is fully CPD 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 course, you will immediately be sent a digital certificate. Also, you can have your printed certificate delivered by post (shipping cost £3.99). Our certifications have no expiry dates, although we do recommend that you renew them every 12 months. CPD 40 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Marketing Managers Brand Managers Business Owners Project Managers HR Managers Requirements Minimum graduated from any discipline. Career path Marketing Director Business Development Manager Financial Analyst Operations Manager Entrepreneur Certificates Hardcopy Certificate Hard copy certificate - Included You will get the hard copy certificates for Free! The delivery charge of the hard copy certificate inside the UK is £3.99 each. PDF Certificate Digital certificate - Included
Level 2, 3 & 4 QLS Endorsed Diploma | QLS Hard Copy Certificate Included | Plus 10 CPD Courses | Lifetime Access
A six-week self study finance course brought to you by award-winning Financial Adviser and Money Coach Claire Sweet
***24 Hour Limited Time Flash Sale*** Financial Wellness, Corporate Finance and Financial Advisor Admission Gifts FREE PDF & Hard Copy Certificate| PDF Transcripts| FREE Student ID| Assessment| Lifetime Access| Enrolment Letter Discover the keys to financial success with our exclusive bundle of 8 courses: Financial Wellness, Corporate Finance, and Financial Advisor. This comprehensive package combines the expertise of 3 QLS-endorsed courses and 5 CPD QS-accredited courses, offering you a wealth of knowledge in the world of finance. What sets this bundle apart is the opportunity to receive hardcopy certificates for the QLS-endorsed courses, adding a tangible credential to your professional profile. This bundle is ideal for professionals seeking to expand their financial acumen, whether you're an accountant, financial analyst, business owner, or aspiring financial advisor. It's also suitable for individuals who want to take control of their personal finances and make informed decisions for their financial well-being. Don't miss out on this opportunity to elevate your financial knowledge and open doors to exciting career prospects. Key Features of the Financial Wellness, Corporate Finance and Financial Advisor Bundle: 3 QLS-Endorsed Courses: We proudly offer 3 QLS-endorsed courses within our Financial Wellness, Corporate Finance and Financial Advisor bundle, providing you with industry-recognized qualifications. Plus, you'll receive a free hardcopy certificate for each of these courses. QLS Course 01: Financial Wellness: Managing Personal Cash Flow QLS Course 02: Corporate Finance: Profitability in a Financial Downturn QLS Course 03: Finance: Financial Advisor 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: Internal audit skills Course 02: Financial Modelling Using Excel Course 03: Financial Reporting Course 04: Financial Management Course 05: AML 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 Financial Wellness, Corporate Finance and Financial Advisor courses are accessible online, allowing you to learn at your own pace and from the comfort of your own home. Learning Outcomes: Understand the principles and techniques of managing personal cash flow. Navigate corporate finance strategies during financial downturns. Develop the skills required to become a trusted financial advisor. Gain proficiency in internal audit techniques and best practices. Master financial modeling using Excel to analyze complex financial data. Acquire knowledge of financial reporting standards and procedures. Familiarize yourself with financial management principles and strategies. Embark on a transformative journey into the world of finance with our captivating bundle of Financial Wellness, Corporate Finance, and Financial Advisor courses. This comprehensive package combines the expertise of 3 QLS-endorsed courses and 5 CPD QS-accredited courses, equipping you with the essential knowledge and skills needed to excel in the finance industry. Designed for both professionals and individuals seeking to enhance their financial literacy, this bundle offers a unique blend of theoretical insights and practical applications. From mastering personal cash flow management to navigating corporate finance strategies during financial downturns, you'll gain invaluable expertise to make informed financial decisions. CPD 250 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Accountants looking to expand their financial knowledge. Financial analysts seeking to enhance their understanding of corporate finance. Business owners aiming to make strategic financial decisions. Aspiring financial advisors wanting to establish their expertise. Career path Financial Analyst: £35,000 - £60,000 per annum Financial Manager: £50,000 - £100,000 per annum Internal Auditor: £30,000 - £60,000 per annum Financial Advisor: £40,000 - £100,000 per annum Finance Director: £70,000 - £150,000 per annum Risk Manager: £45,000 - £100,000 per annum Certificates Digital certificate Digital certificate - Included Hard copy certificate Hard copy certificate - Included
Microsoft Excel® in Depth The goal of this course is to provide a deeper understanding of Excel and its intricacies and a new ability to use it efficiently producing the best solutions for your projects. This practical course provides a solid background of the features of Excel and a deeper understanding of its features, benefits and uses. This is not a beginner's course in Excel. You will learn some advanced features such as Pivot Tables, Charting, Tables, Sorting, Filtering and Functions. The goal of this course is to provide a deeper understanding of Excel and its intricacies and a new ability to use it efficiently producing the best solutions for your projects. What you Will Learn You'll learn how to: Use functions like IF, AVERAGE, SUMIF, SUMIFS, SUMPRODUCT, INDEX, MATCH, CHOOSE, DATE, and many more Create meaningful charts Use pivot tables Use Conditional Formatting, Data Validation Take advantage of using Named ranges, do sorting, filtering, tables Getting Started The building blocks of Excel, built-in functions, will be examined The basics of formatting your data will be examined Shortcuts and data manipulation will be explored Built-in features like those mentioned in the 'What you will learn' section above will be explored in detail Excel Functions - VLOOKUP, IF, INDEX, MATCH, CHOOSE, SUMIF, SUMIFS, SUMPRODUCT, DATE, so many more Using Named ranges, Data Validation, Sorting, and Filtering Learn the Name manager; Learn the difference between local and global names; Ensure correct access to linked workbooks; Ensure data accuracy; Learn how to use cascading data validation (for example, once a user chooses 'cars', another cell allows only Ford, Toyota, etc.); Sorting by more than 3 fields; Filtering by font, pattern, or value; See your data based on things like dates in the 3rd quarter, or fields where quantity x price is greater than some fixed value Conditional formatting and data formatting Make relevant data stand out Isolate highs and lows Make error cells invisible Learn about Data bars, Icon sets, and Color scales Highlight differences between worksheets Learn all the codes in the Format/Number list Using cell Styles Learn all about alignment, protection, borders, colors and more Pivot Tables Learn how to summarize large amounts of data with a few clicks Learn various ways of presenting the data Learn the various pivot table tools Learn how to customize and format a pivot table to suit your needs Learn how to group data Learn how to use the various options to present your data Charts Learn how to create a chart with one keystroke! Learn the 11 types of built-in charts Learn how to create a chart with one keystroke! Learn how to customize the charts to make the information tell the right story Learn how to use the design, layout, and formatting available to charts in Excel 2007 Learn embedded charts versus chart sheets Learn how to use modify all the pieces of a chart Array formulas Learn how to use the most powerful formulas in Excel Learn how to combine many formulas into one compact array-formula Learn the real power of these formulas and why regular formulas can't do the job Learn how to use built-in array formulas, like TREND or TRANSPOSE