44798 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

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

The Fire Alarm Foundation course is designed to give participants a practical knowledge of the operation and installation of Fire Alarm Systems at a foundation level. During this practical and theory-based course students will gain the skills and knowledge to install and wire up a Fire Alarm Control Panel to typical auxiliary equipment such as Break Glass Units, Smoke Detectors, Heat Detectors, Bells, and Sirens.

Course Overview Without having good observation skills, you can never become a competent caregiver. The Observation Skills for Carers Training Course is constructed to help you build effective observation skills and assist you in becoming an excellent caregiver. The Observation Skills for Carers Training Course will teach you the most important observation skills. You will grasp the techniques of child observation and learn how to design child observation plans. From the easy to follow modules, you will understand the social policy and social work observation. Step by step, you will build the essential abilities for health observation. You will be able to secure the vital skills for clinical management. The Observation Skills for Carers Training Course is a brilliant way to build a wide range of observational skills. Enrol in the course today and increase your employability in the relevant industry. Learning Outcomes Acquire the core observation skills Understand the fundamentals of child observation Learn about different observational methods and techniques Study the basics of social policy and social work observation Build the essential skills for basic health observation Deepen your knowledge and understanding of clinical management observation Why Take This Course From John Academy? Affordable, well-structured and high-quality e-learning study materials Meticulously crafted engaging and informative tutorial videos and materials Efficient exam systems for the assessment and instant result Earn UK & internationally recognised accredited qualification Easily access the course content on mobile, tablet, or desktop from anywhere, anytime Excellent career advancement opportunities Get 24/7 student support via email What Skills Will You Learn from This Course? Observation Skills Developing and implementing observation plans Caregiving Who Should Take this Online Observation Skills for Carers Course? Whether you're an existing practitioner or an aspiring professional, this course is an ideal training opportunity. It will elevate your expertise and boost your CV with key skills and a recognised qualification attesting to your knowledge. Are There Any Entry Requirements? This Online Observation Skills for Carers is available to all learners of all academic backgrounds. But learners should be aged 16 or over to undertake the qualification. And a good understanding of the English language, numeracy, and ICT will be helpful. Online Observation Skills for Carers Certification After completing and passing the Online Observation Skills for Carers successfully, you will be able to obtain a Recognised Certificate of Achievement. Learners can obtain the certificate in hard copy at £14.99 or PDF format at £11.99. Career Path The Online Observation Skills for Carers course provides essential skills that will make you more effective in your role. It would be beneficial for any related profession in the industry, such as: Nurse Healthcare Assistant Clinical Support Worker Health and Social Care Support Worker Care Assistant Childcare worker Module 01: Introduction to Observation Skill Introduction to Observation Skill 00:19:00 Module 02: Child Observation Child Observation 00:14:00 Module 03: Child Observation Plan and Documentation Child Observation Plan and Documentation 00:18:00 Module 04: Observational Methods and Studies Observational Methods and Studies 00:21:00 Module 05: Social Policy and Social Work Observation Social Policy and Social Work Observation 00:15:00 Module 06: Basic Health Observation Basic Health Observation 00:30:00 Module 07: Clinical Management Observation Clinical Management Observation 00:21:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

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

Document Control: Document Control Course Online Do you wish to strengthen your document control abilities? If so, you are welcome to enrol in our specially created Document Control Course, which is intended to provide participants an in-depth understanding. You will learn about the advantages of document management as well as the document control lifecycle in this Document Control course. The Document Control course also explains how to make a document control system more efficient. Additionally, the Document Control course places a strong emphasis on the underlying expertise, best practices, and legal ideas related to document control. Following your completion of our Document Control programme, you'll be more efficient at work. Join in our Document Control programme to get the skills you need to become more productive and structured. Learning Outcome of Document Control Course After completing the Document Control, learners will know about: Introduction to document control. The basics of document control. Keep document identification as a Document Control expert. Document classifying, filing & information security for Document Controlling. Document Control also explains documents lifecycle and document distribution. Project document control, prepare final documentation controlling and specifications for Document Control in an organisation. The Document Control course teaches electronic document management systems. Interactions with project teams, engineering teams, managers described in other modules of Document Control course. Main Course: Document Control Course Free Courses are including with this Document Control: Document Control Course Along with The Document Control Course, We Offer a free Office Management and Administration Course Along with The Document Control Course, We Offer a free Executive Secretary & PA Training Course Special Offers of this Document Control: Document Control Course This Document Control Course includes a FREE PDF Certificate. Lifetime access to this Document Control Course Instant access to this Document Control Course Get FREE Tutor Support to this Document Control Course Document Control: Document Control Course Online You will learn the fundamentals of document control as well as how to recognize it in this course on document control. The classification and security of the document management system are also covered in the Document management course. Furthermore, the course on document control has a strong emphasis on the document control lifecycle, legal ideas, best practices, and underlying expertise. After completing our Document Control program, you will be more efficient at creating the final paperwork and management. You may manage teams, engineering, and document control as a document control specialist. Who is this course for? Document Control: Document Control Course Online This Document Control course is open to students without any prior understanding of Document Control. Requirements Document Control: Document Control Course Online To enrol in this Document Control: Document Control Course, students must fulfil the following requirements. To join in our Document Control: Document ControlCourse, you must have a strong command of the English language. To successfully complete our Document Control: Document Control Course, you must be vivacious and self driven. To complete our Document Control: Document Control Course, you must have a basic understanding of computers. A minimum age limit of 15 is required to enrol in this Document Control: Document Control Course. Career path Document Control: Document Control Course Online Training in Document Control: document Control is a special chance to develop important abilities and progress your career.

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.

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