43151 Courses in Cardiff delivered Online

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

Level 5 QLS Endorsed Course with FREE QLS Certificate | CPD Accredited | 150 CPD Points | Lifetime Access

Introduction to Design Thinking: On-Demand Innovation is the cornerstone of highly successful companies, especially those that continue to be successful over the years and decades. Design thinking practices fuel this continual innovation, as they are the critical links from inspiration to delivery, concept to showroom floor, and start-up to global business. Design thinking is a structured approach to promoting innovation and creative problem-solving. It is not a new approach. It has been around for centuries, as the art, architecture, and inventions of mankind illustrate. By examining the steps to achieving great design and maximum utility of product, design thinking approaches provide a framework in which to develop new solutions to problems and new products to sell. This highly interactive course is designed to help participants think like designers to generate innovation, and to help teams to produce more innovation and creativity. Since design thinking is based on doing rather than thinking, we participants are challenged to apply the techniques, in the classroom, to create new ideas and solutions to a case study project. What you will Learn At the end of this program, you will be able to: Explain the underlying principles and value of using Design Thinking for innovation Describe the basic concepts of the Stanford Model for Design Thinking Evaluate a set of basic Design Thinking techniques for application to your projects Apply tools, techniques, and skills aligned with the 5 stages of the Stanford Model Drive innovation through Design Thinking at some level in your work environment Foundation Concepts Problems and solutions The Design Thinking difference Design Thinking skills and abilities Design Thinking mindset Design Thinking frameworks Stages of Design Thinking Problems and solutions The Design Thinking difference Design Thinking skills and abilities Design Thinking mindset Design Thinking frameworks General Practices Team formation Visualization Improvisation Personalization Empathize Practices Overview of Empathize techniques Observation Engagement Interviews Define Practices Overview of Define practices Unpacking techniques Defining the customer techniques Integrating the Define experience Ideate Practices Overview of Ideate practices Reusable techniques for the Ideate stage New Ideate techniques to explore Prototype & Test Practices Overview of Prototype practices Examples of prototypes Overview of Testing practices Forms of testing techniques Adopt and Adapt Design Thinking Overview of Design Thinking implementation Design Thinking implementation challenges Success in implementing Design Thinking Summary and Next Steps Workshop summary Next steps: Personal Action Plans

The Art of Negotiation: Virtual In-House Training Confidence, rapport, curiosity, and patience are essential ingredients to successfully handling a difficult conversation and negotiation. In this course, you will learn to identify and manage aspects of a negotiation, distinguish needs from wants, and manage expectations. The course will cover communication best practices, strategies for handling difficult conversations, and the basics of the art of negotiation. What you Will Learn Master the different ways to say 'no' Determine negotiation strategies based on typical client strategies Develop solutions to break deadlocks Getting Started Introductions Course structure Course goals and objectives Establishing personal learning objectives Foundation Concepts Exercise: Most Challenging Scenarios and Outcomes Debrief: Impact versus intent Addressing customer expectations Needs versus wants Key skills for managing customer relationships Elicitation (requirements gathering) Communication and active listening Sensitivity and empathy Handling Difficult Conversations Saying 'no' The Ladder of Inference 4-Step approach for handling difficult conversations Characteristics of a trusted advisor Communication Best Practices Attunement and active listening Exercise: Identifying Effective Techniques Communication pitfalls and best practices Building rapport and influence Words of wisdom Exercise: Reflection on Challenges Negotiation Strategies Negotiation basics Five phases of negotiation Identifying different strategies Traditional versus Progressive Hard - Soft - Principled Exercise: Your Preferred Techniques Selecting appropriate strategy for project negotiations Common pitfalls to avoid The impact of culture on negotiation Looking at conflict through the lens of negotiation Exercise: Mapping a Resolution

The Art of Negotiation: In-House Training Confidence, rapport, curiosity, and patience are essential ingredients to successfully handling a difficult conversation and negotiation. In this course, you will learn to identify and manage aspects of a negotiation, distinguish needs from wants, and manage expectations. The course will cover communication best practices, strategies for handling difficult conversations, and the basics of the art of negotiation. What you Will Learn Master the different ways to say 'no' Determine negotiation strategies based on typical client strategies Develop solutions to break deadlocks Getting Started Introductions Course structure Course goals and objectives Establishing personal learning objectives Foundation Concepts Exercise: Most Challenging Scenarios and Outcomes Debrief: Impact versus intent Addressing customer expectations Needs versus wants Key skills for managing customer relationships Elicitation (requirements gathering) Communication and active listening Sensitivity and empathy Handling Difficult Conversations Saying 'no' The Ladder of Inference 4-Step approach for handling difficult conversations Characteristics of a trusted advisor Communication Best Practices Attunement and active listening Exercise: Identifying Effective Techniques Communication pitfalls and best practices Building rapport and influence Words of wisdom Exercise: Reflection on Challenges Negotiation Strategies Negotiation basics Five phases of negotiation Identifying different strategies Traditional versus Progressive Hard - Soft - Principled Exercise: Your Preferred Techniques Selecting appropriate strategy for project negotiations Common pitfalls to avoid The impact of culture on negotiation Looking at conflict through the lens of negotiation Exercise: Mapping a Resolution

Scientific information shows that negotiation skills are essential for success in business and life. This Negotiation Skills course will teach you how to influence others, negotiate effectively, and achieve your goals. The Negotiation Skills Programme, stresses how to improve your competency as a person in your chosen field while also outlining essential career insights in the relevant job sector. Along with this Negotiation Skills Course, you will get 11 premium courses, an original hard Hardcopy, 11 PDF Certificates (Main Course + Additional Courses) Student ID card as gifts Learning Outcomes of Negotiation Skills Bundle: Understand the different types of negotiation. Develop effective influencing and negotiation strategies. Build rapport and trust with others. Deal with difficult situations in negotiations. Negotiate effectively online. Prepare for and conduct successful negotiations. This Negotiation Skills Bundle Consists of the following Premium courses: Course 01: Influencing and Negotiating Course 02: Facilities Management Level 3 Course 03: Sales Negotiation Training Course 04: Leadership & Management Diploma Course 05: Psychology Advanced Training Course 06: Emotional Intelligence and Human Behaviour Course 07: Dealing With Difficult People Training Course Course 08: Motivation Skills Course 09: Setting and Achieving Goals Course 10: Assertiveness and Self-Confidence Development Course 11: Equality and Diversity Enrol now in Negotiation Skills To advance your career, and use the premium study materials from Apex Learning. Negotiation Skills Bundle The Negotiation Skills bundle incorporates basic to advanced level skills to shed some light on your way and boost your career. Hence, you can strengthen your Negotiation Skills, Expertise and essential knowledge, which will assist you in reaching your goal. The Course Curriculum of Negotiation Skills Bundle: Course 01: Influencing and Negotiating Unit 01: Influencing Influencing Influencing is about helping others understand Your Personality affects how you influence others Influence by Listening Exercise: Your Influencing Inventory Unit 02: Negotiating What is Negotiation? The Drivers of Success in Negotiation Information and Power in Negotiation Exercise: Prepare to Negotiate Successful Negotiation The Importance of Rapport Questions in Negotiation Reducing Stress in Negotiation Exercise: Examine your Trust Profile Bringing the Negotiation to a Close Dealing with Deadlock Negotiating Online Specific Negotiation Scenarios More Negotiation Scenarios The Negotiator's Toolkit =========>>>>> And 10 More Courses <<<<<========= Certificate of Negotiation Skills: After successfully completing this Negotiation Skills course you will be able to order your CPD Accredited Certificates (PDF + Hard Copy) as proof of your achievement. PDF Certificate: Free (Previously it was £6*11 = £66) Hard Copy Certificate: Free (For The Title Course: Previously it was £10) Enroll in the Negotiation Skills course today and learn how to negotiate effectively in any situation! CPD 110 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Negotiation Skills Bundle Professionals looking to improve their negotiation skills in their current job or to advance in their career Business owners and entrepreneurs who want to negotiate more effectively with clients, suppliers, and partners Anyone who wants to improve their negotiation skills. Requirements Negotiation Skills Bundle Our Negotiation Skills course is your path that might lead to a rewarding career in Negotiation Skills. Career path Having this Negotiation Skills course, will increase the value of your CV and open you up to multiple job sectors. Sales representative: £20,000 - £40,000 Business development manager: £30,000 - £60,000 Account manager: £40,000 - £80,000 Marketing manager: £50,000 - £100,000 Human resources manager: £60,000 - £120,000 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 (Influencing and Negotiating) 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.

Level 1 Award in Touch Typing Skills Master the art of "Touch Typing" with our Level 1 course. From transcription basics to advanced techniques, hone your skills in transcription comprehension and typing accuracy. Explore the world of sales writing, email sales letters, minute-taking, and copywriting, equipping yourself with valuable communication skills for the modern workplace. Learning Outcomes: Demonstrate touch typing proficiency and accuracy. Apply transcription skills with comprehension and precision. Employ advanced transcription techniques effectively. Create persuasive sales writing and email sales letters. Master minute-taking and copywriting for professional communication. More Benefits: LIFETIME access Device Compatibility Free Workplace Management Toolkit Level 1 Award in Touch Typing Skills Course Syllabus Introduction to Touch Typing: Gain a strong foundation in touch typing techniques, mastering proper finger placement and keyboard familiarity. Transcription and Touch Typing Proficiency: Develop exceptional transcription skills through touch typing, ensuring high accuracy and speed in converting spoken content to text. Advanced Touch Typing Techniques: Explore advanced touch typing methods, enabling you to transcribe complex material accurately and efficiently. Touch Typing for Sales Writing: Apply touch typing skills to create persuasive sales materials and craft impactful email sales letters. Minute Taking and Touch Typing: Enhance meeting productivity with proficient touch typing for minute taking and improve your copywriting abilities. Touch Typing Mastery and Certification: Achieve mastery in touch typing and earn a certification that validates your skills for various professional tasks.

Certificate in Executive PA Skills Level 1 Step into the world of elite administrative support with our Certificate in Executive PA Skills Level 1. Master the essential roles and daily routines of an Executive PA. Cultivate a career that combines precision, efficiency, and managerial acumen. Learning Outcomes: Outline the fundamental role of an Executive PA. Organise an efficient workstation and daily routine. Foster professional relationships as an Executive PA. Maintain meticulous records in an Executive PA role. Plan and oversee meeting arrangements. Enhance business writing skills for Executive PA tasks. More Benefits: LIFETIME access Device Compatibility Free Workplace Management Toolkit Key Modules from Certificate in Executive PA Skills Level 1: An Overview of Executive PA: Understand the comprehensive responsibilities and impact of an Executive PA. Workstation and Daily Routine: Set up a productive workstation and establish an effective daily routine as an Executive PA. Relationship Management: Develop strategies for managing professional relationships crucial to an Executive PA's success. Keeping Accurate Records: Learn the art of meticulous record-keeping essential for an Executive PA's role. Travel Arrangements: Master the coordination of travel arrangements to ensure seamless itineraries. Meeting Arrangement: Plan and execute meeting arrangements with the expertise expected of an Executive PA. Diary Management: Manage diaries with an eye for detail, balancing schedules and priorities. Business Writing Skills: Craft clear and professional written communication as a core skill for an Executive PA.

Overview This course is specially designed to enhance the skills required to analyse risk and crisis and the cause behind this. It will feed you with the necessary skills to minimise the chances of risk and in case it happens able to manage the situation in order to keep the business in a stable position. The course content will cover different crises caused due to internal or external issues and different ways to manage them. It will help the professionals to gain skills in planning beforehand various techniques to overcome risk and crisis and implementing the plan during that phase.

Overview This course is specially designed to enhance the skills required to analyse risk and crisis and the cause behind this. It will feed you with the necessary skills to minimise the chances of risk and in case it happens able to manage the situation in order to keep the business in a stable position. The course content will cover different crises caused due to internal or external issues and different ways to manage them. It will help the professionals to gain skills in planning beforehand various techniques to overcome risk and crisis and implementing the plan during that phase.