18426 Disc 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

Jamf training, Jamf 240 course, Jamf course

Supercharge your skills and career and learn in-demand knowledge needed to build business intelligence dashboards. This beginner to intermediate level course will introduce you to all the Power BI technologies i.e. Power Query, DAX, Data Modelling (Power Pivot), M, types of visualizations, etc.

Learn advanced concepts in DAX, Data Modeling, Power BI architectural design, and more.

Learn the fundamentals of Oil and Gas modeling following best practices. This course will break down the important concepts of modeling allowing you to implement them in the Oil and Gas industry.

Women in Local Government Leadership Workshop is for Local Government professionals looking to learn new skills with like-minded peers and further or advance their within Local government.

Join the Scrum.org accredited Live Virtual Class - Professional Scrum Master I™ (PSM I) to master the fundamentals of Scrum. Learn the framework, mechanics, and roles to ensure successful implementation by your team. Course Description Our Scrum.org certified online professional scrum master courses set industry standards with a remarkable 98% first-time pass rate. Say goodbye to PowerPoint and embrace 100% interactivity. Gain hands-on practical skills, learning how to implement immediately and achieve tangible results. Learn to empower Scrum Teams for organisational value delivery. Gain insight into Scrum theory, empiricism, and its framework-to-principal connection. Understand how to apply Agile principles to real-world contexts. Grasp uncertainty and complexity in product delivery, Scrum values' significance, and the essence of "Done" for transparency. Master agile planning with the Product Backlog. Acquire self-management, interpersonal skills, and the crucial role of a Scrum Master as a leader. Develop the necessary skills, traits, and behaviour for effective Scrum Mastery. Why Train With Us? Explore Agile and Scrum principles with our immersive two-day online course where we prioritise your growth and success. Led by experienced industry professionals and supportive Professional Scrum Trainers, we go beyond PowerPoint to offer engaging, hands-on learning experiences. Gain a profound understanding of Scrum theory and discover practical applications relevant to your workplace challenges enabling immediate and impactful change. From debunking myths to empowering your Scrum Teams with the right practices, we'll be with you every step of the way - from learning to passing the test and implementing it seamlessly into your job context. Who Should Attend This Course? Suitable for all industries tackling complex problems, the Professional Scrum Master training course is designed for: Those aspiring to become Scrum Masters Practitioners and consultants seeking to enhance their Scrum expertise Anyone involved in product delivery through Scrum methodologies Agile managers aiming to understand the Scrum Master's role Your Professional Scrum Trainer Meet Jay, founder of Fractal Systems and a dedicated Professional Scrum Trainer. With over 20 years of experience in team and leadership roles, Jay is well-versed in delivering continuous value. His unique teaching approach involves zero PowerPoint and instead relies on engaging, experience-based sessions using techniques from Liberating Structures and Neuro Linguistic Programming. Jay's expertise lies in business transformations, offering training, mentoring, coaching, and consulting to foster success through collaborative efforts. Rapid learning and practical application are the hallmarks of his approach. Jay & the entire Fractal team are invested in your learning journey and are here to support you from start to end, including offering additional valuable support: Free PSM1 practice assessment for certification success Free PSM1 resource bundle to master Scrum Free PSM1 exam revision sheets Free exam coaching sessions for first-time success in your PSM1 exam Free 1:1 coaching to excel at work as a Professional Scrum Master Our Clients Our Testimonials

Join the Scrum.org accredited Live Virtual Class - Professional Scrum Product Owner Advanced™ training (PSPO Advanced) to master the role of a Product Owner. Learn how to advance your training of Product Ownership and apply it to deliver even more value. Course Description Agile techniques and the Scrum framework revolutionise project and product delivery, enabling teams to work faster and align closely with business needs. A product owner's role within this delivery is critical. Unlike traditional team managers, Product Owners focus on maximising product value rather than individual elements of project delivery. To excel in this role, product owners must combine business strategy with product vision and delivery roadmaps. The ability to operate within complex environments highlights the need for specific training and qualifications. Product Owner Advanced training is specifically designed to empower experienced Product Owners to deliver greater value. An exceptional Product Owner requires skillsets beyond core Agility and Scrum. These include clear decision-making, vision, communication, and influence. Practical experience is highly valued, and the PSPO 2 course emphasises interactive workshops, discussions, and exercises to provide a comprehensive understanding of the multifaceted Product Owner role. This course elevates existing Product Owners' capabilities, providing a clear path for your professional growth and delivering increased value to product stakeholders. Through collaborative and exploratory training, Product Owners' knowledge and experience will reach new heights, improving various aspects of your role. Key areas covered include: Deepening understanding of the Product Owner role, including product understanding, customer identification, and effective communication of product vision and strategy. Leveraging product vision and strategy to gain a competitive edge. Embracing diverse roles and stances essential for Product Owners. Enhancing stakeholder communication and management skills with a focus on different stakeholder groups. Navigating Agile governance, budgeting, and contracting within the Scrum framework. Scaling the Product Owner role for larger projects and products. By the end of this product owner advanced training, participants will be equipped to excel as Product Owners, driving success and value across their product journey. Why Train With Us? Develop advanced product owner skillsets that build on your existing knowledge of the Scrum framework and product owner accountabilities with our immersive two-day online PSPO Advanced course. Led by experienced industry professionals and support Professional Scrum Trainers & Product Owners, the course values team-based exercises and a hands-on learning experience. We help you grow within your Product Owner role through this advanced training, enabling you to better communicate product vision and strategy to teams, ultimately delivering higher value through projects and products with larger scopes. Who Should Attend This Course? The Professional Product Owner – Advanced course is designed for: Experienced Product Owners, ideally with at least one year of experience in the role Scrum Masters and stakeholders collaborating with Product Owners Your Professional Scrum Trainer Meet Jay, founder of Fractal Systems and a dedicated Professional Scrum Trainer. With over 20 years of experience in team and leadership roles, Jay is well-versed in delivering continuous value. His unique teaching approach involves zero PowerPoint and instead relies on engaging, experience-based sessions using techniques from Liberating Structures and Neuro Linguistic Programming. Jay's expertise lies in business transformations, offering training, mentoring, coaching, and consulting to foster success through collaborative efforts. Rapid learning and practical application are the hallmarks of his approach. Jay & the entire Fractal team are invested in your learning journey and are here to support you from start to end, including offering additional valuable support: Free practice assessments for certification success Free resource bundle to master Scrum Free exam revision sheets Free access to an exam simulator Free exam coaching sessions for first-time success Free 1:1 coaching to excel at work Our Clients Our Testimonials

Get a clear strategy for bouncing back after a poor Ofsted inspection outcome; develop your DfE action plan; know what to expect from a progress monitoring inspection.

Getting Started The qualifications of the QUALIFI Level, 5 Extended Diploma in Business Management develop and reward today and future business managers and continue to bring recognition and professionalism to the management sectors. With a focus on practical skills, this diploma equips learners with the skills needed to become effective business managers in today's dynamic and globalised business environment. Key Benefits To understand and apply the principles of leadership in a business environment. Review and apply business management principles within the industry and specific environment. Develop strategic plans that align with the vision and objectives of an organisation. Understand and apply financial management principles to analyse financial statements and make informed decisions. Develop and implement marketing strategies to promote products and services. Lead and manage teams effectively by using appropriate leadership styles. Effectively use verbal and communication skills. Manage one's personal development and growth. To improve learners' employability by allowing them to explore the relationship between management theories and their practical application in the business world. Analyse problem-solving techniques specific to business and industry.   Career Pathways The QUALIFI Level 5 Diploma in Extended Business Management can open many career pathways including, but not limited to: Operations manager with an estimated average salary of £48,814 per annum Accounts manager with an estimated average salary of £46,657,506 per annum Financial analyst with an estimated average salary of £45,000per annum Marketing manager with an estimated average salary of £50,000 per annum Sales manager with an estimated average salary of £48,000 per annum Business Analyst with an estimated average salary of £61,118 per annum Assistant manager with an estimated average salary of £40,222 per annum   About Awarding Body QUALIFI, recognised by Ofqual awarding organisation has assembled a reputation for maintaining significant skills in a wide range of job roles and industries which comprises Leadership, Hospitality & Catering, Health and Social Care, Enterprise and Management, Process Outsourcing and Public Services. They are liable for awarding organisations and thereby ensuring quality assurance in Wales and Northern Ireland. What is included? Outstanding tutor support that gives you supportive guidance all through the course accomplishment through the SBTL Support Desk Portal. Access our cutting-edge learning management platform to access vital learning resources and communicate with the support desk team. Quality learning materials such as structured lecture notes, study guides, and practical applications, which include real-world examples and case studies, will enable you to apply your knowledge. Learning materials are provided in one of the three formats: PDF, PowerPoint, or Interactive Text Content on the learning portal. The tutors will provide Formative assessment feedback to improve the learners' achievements. Assessment materials are accessible through our online learning platform. Supervision for all modules. Multiplatform accessibility through an online learning platform facilitates SBTL in providing learners with course materials directly through smartphones, laptops, tablets or desktops, allowing students to study at their convenience. Live Classes (for Blended Learning Students only) Assessment Time-constrained scenario-based assignments No examinations   Entry Requirements The Qualification has been designed to be accessible without artificial barriers restricting access; for this Qualification, applicants must be 18 or older.   Learners who possess Qualifications at Level 3 and/or 4; Learners who have work experience at a managerial level and demonstrate ambition with clear career goals; Learners who possess a first degree in another discipline and want to develop their careers in business. Progression Completing the QUALIFI Level 5 Diplomas will enable learners to progress to: QUALIFI Level 6 Diploma in related areas. Bachelor'sBachelor's degree final year. Employment in an associated profession.   Why gain a QUALIFI Qualification? This suite of qualifications provides enormous opportunities to learners seeking career and professional development. The highlighting factor of this qualification is that: The learners attain career path support who wish to pursue their career in their denominated sectors; It helps provide a deep understanding of the health and social care sector and managing the organisations, which will, in turn, help enhance the learner's insight into their chosen sector. The qualification provides a real combination of disciplines and skills development opportunities. The Learners attain in-depth awareness concerning the organisation's functioning, aims and processes. They can also explore ways to respond positively to this challenging and complex health and social care environment. The learners will be introduced to managing the wide range of health and social care functions using theory, practice sessions and models that provide valuable knowledge. As a part of this suite of qualifications, the learners will be able to explore and attain hands-on training and experience in this field. Learners also acquire the ability to face and solve issues then and there by exposure to all the Units. The qualification will also help to Apply scientific and evaluative methods to develop those skills. Find out threats and opportunities. Develop knowledge in managerial, organisational and environmental issues. Develop and empower critical thinking and innovativeness to handle problems and difficulties. Practice judgement, own and take responsibility for decisions and actions. Develop the capacity to perceive and reflect on individual learning and improve their social and other transferable aptitudes and skills.       Learners must request before enrolment to interchange unit(s) other than the preselected units shown in the SBTL website because we need to make sure the availability of learning materials for the requested unit(s). SBTL will reject an application if the learning materials for the requested interchange unit(s) are unavailable. Learners are not allowed to make any request to interchange unit(s) once enrolment is complete. UNIT1- Bus1.1: Communication in an Organisation Reference No : D/507/1581 Credit : 20 || TQT : 200 This unit is divided into three parts and examines communications at an organisational level, interpersonal communications and managing internal and external communications. UNIT2- Bus1.2: Leadership and the Organisation Reference No : H/507/1582 Credit : 20 || TQT : 200 This unit looks at developing practical leadership skills at a non-strategic level within a rapidly changing working environment. The unit allows learners to explore the attributes and skills of successful leaders in depth. UNIT3- Bus1.3: Financial Awareness Reference No : M/507/1584 Credit : 20 || TQT : 200 The overriding aim of the unit is to provide the learner with the necessary knowledge to critically evaluate the financial systems, processes and procedures in their organisations. UNIT4- Bus1.4: Managing Change Reference No : A/507/1586 Credit : 20 || TQT : 200 Management has often been defined as ''creating change through people,'' this unit encourages learners to adopt this approach to change. This unit aims to enable learners to understand the issues relating to the management of activities with a particular focus on problem-solving. UNIT5- Bus1.6: Developing Teams Reference No : J/507/1588 Credit : 20 || TQT : 200 The unit focuses on building, developing and supporting teams to enable them to achieve their goals and objectives. Learners will identify the skills and potential of teams and individuals. UNIT6- Bus2.1: Responding to the Changing Business Environment Reference No : R/507/1612 Credit : 20 || TQT : 200 The unit aims to introduce the learner to several dynamic factors that affect how an organisation operates and the required change in management. UNIT7- Bus2.2: Effective Decision Making Reference No : Y/507/1613 Credit : 20 || TQT : 200 The unit aims to equip the learner with the means to manage the decision-making process rather than the outcome or decision itself. By recognising decision-making methods, the learner can stress the need for greater participation of stakeholders to ensure pro-activity and innovation. UNIT8- Bus2.3: Business Development Reference No : D/507/1614 Credit : 20 || TQT : 200 The unit will allow learners to work in a team to investigate new business formats and a feasibility assessment for a potential knowledge-based product or service opportunity identified by the team. UNIT9- Bus2.4: Business Models and Growing Organisations Reference No : H/507/1615 Credit : 20 || TQT : 200 To introduce working for and managing creatively within a smaller growth organisation. This unit examines how the small business grows, the reasons for success and how best to manage available growth options. UNIT10- Bus2.5: Customer Management Reference No : K/507/1616 Credit : 20 || TQT : 200 This unit is designed to help learners understand the role of customer-centred organisations. The unit aims to provide learners with understanding and insight into customer behaviour. It will develop skills, and learners will use tools and practice an organisation can use to retain and improve customer retention and relationships. UNIT11- Bus2.6: Risk Management and Organisations Reference No : T/507/1618 Credit : 20 || TQT : 200 This unit will involve the learner developing risk profiles and identifying risk management strategies for selected case studies. The aim is to provide learners with an understanding of what makes an effective organisation, balancing opportunity with change and closely linked with creativity and innovation. Delivery Methods School of Business & Technology London provides various flexible delivery methods to its learners, including online learning and blended learning. Thus, learners can choose the mode of study as per their choice and convenience. The program is self-paced and accomplished through our cutting-edge Learning Management System. Learners can interact with tutors by messaging through the SBTL Support Desk Portal System to discuss the course materials, get guidance and assistance and request assessment feedbacks on assignments. We at SBTL offer outstanding support and infrastructure for both online and blended learning. We indeed pursue an innovative learning approach where traditional regular classroom-based learning is replaced by web-based learning and incredibly high support level. Learners enrolled at SBTL are allocated a dedicated tutor, whether online or blended learning, who provide learners with comprehensive guidance and support from start to finish. The significant difference between blended learning and online learning methods at SBTL is the Block Delivery of Online Live Sessions. Learners enrolled at SBTL on blended learning are offered a block delivery of online live sessions, which can be booked in advance on their convenience at additional cost. These live sessions are relevant to the learners' program of study and aim to enhance the student's comprehension of research, methodology and other essential study skills. We try to make these live sessions as communicating as possible by providing interactive activities and presentations. Resources and Support School of Business & Technology London is dedicated to offering excellent support on every step of your learning journey. School of Business & Technology London occupies a centralised tutor support desk portal. Our support team liaises with both tutors and learners to provide guidance, assessment feedback, and any other study support adequately and promptly. Once a learner raises a support request through the support desk portal (Be it for guidance, assessment feedback or any additional assistance), one of the support team members assign the relevant to request to an allocated tutor. As soon as the support receives a response from the allocated tutor, it will be made available to the learner in the portal. The support desk system is in place to assist the learners adequately and streamline all the support processes efficiently. Quality learning materials made by industry experts is a significant competitive edge of the School of Business & Technology London. Quality learning materials comprised of structured lecture notes, study guides, practical applications which includes real-world examples, and case studies that will enable you to apply your knowledge. Learning materials are provided in one of the three formats, such as PDF, PowerPoint, or Interactive Text Content on the learning portal. How does the Online Learning work at SBTL? We at SBTL follow a unique approach which differentiates us from other institutions. Indeed, we have taken distance education to a new phase where the support level is incredibly high.Now a days, convenience, flexibility and user-friendliness outweigh demands. Today, the transition from traditional classroom-based learning to online platforms is a significant result of these specifications. In this context, a crucial role played by online learning by leveraging the opportunities for convenience and easier access. It benefits the people who want to enhance their career, life and education in parallel streams. SBTL's simplified online learning facilitates an individual to progress towards the accomplishment of higher career growth without stress and dilemmas. How will you study online? With the School of Business & Technology London, you can study wherever you are. You finish your program with the utmost flexibility. You will be provided with comprehensive tutor support online through SBTL Support Desk portal. How will I get tutor support online? School of Business & Technology London occupies a centralised tutor support desk portal, through which our support team liaise with both tutors and learners to provide guidance, assessment feedback, and any other study support adequately and promptly. Once a learner raises a support request through the support desk portal (Be it for guidance, assessment feedback or any additional assistance), one of the support team members assign the relevant to request to an allocated tutor. As soon as the support receive a response from the allocated tutor, it will be made available to the learner in the portal. The support desk system is in place to assist the learners adequately and to streamline all the support process efficiently. Learners should expect to receive a response on queries like guidance and assistance within 1 - 2 working days. However, if the support request is for assessment feedback, learners will receive the reply with feedback as per the time frame outlined in the Assessment Feedback Policy.