Course Objectives At the end of this course you will be able to: Record and edit a Macro Assign macros to keyboard shortcuts, Quick Access Toolbar, Buttons and Shape objects. Use the Visual Basic Editor; change the properties of an object; add a module to a project; write the code for a procedure and then run it; and use the Object Browser to search procedures Manipulate data by declaring variables of different data types; combine data by using expressions; use functions to accept input and display output; and declare variables and procedures with the appropriate scope Use decision structures to create procedures that make decisions; and use loop structures to perform repetitive tasks Create an error handling routine in case things go wrong with VBA code ' 1 year email support service Take a closer look at the consistent excellent feedback from our growing corporate clients visiting our site ms-officetraining co uk Customer Feedback Best Training Ever! Just finished a bespoke 1-1 training course in Excel Advanced, Macros & VBA. Pedro is an excellent trainer, imparting his skills and knowledge in the best way - appropriately to audience skills, knowledge and ability. Pedro is always approachable, encouraging and supportive, giving delegates the optimum learning environment. I would not hesitate to recommend Pedro as a trainer, whatever your level of ability. Amanda Morris - Treasury & Systems Accountant at Reall - Real Equity for All The trainer was very knowledgeable, kept everyone involved and was enthusiastic. A great experience.. Simon Harper - Lloyd's of London My learning experience was awesome. Perdinand Reagan - Subsea7 Very nice and relaxed approach to teaching. Was definitely a good learning experience. Jerome Pupe - S5 Agency World The Trainer – Very positive + patient + helpful + thorough Agnes Souza - Direct Wines ' 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 classroom, one to one, tailored and bespoke courses. Tailored 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. Introduction to Macros and VBA Introducing Visual Basic for Applications Recording a Macro Naming conventions for Macro Procedures Running a Macro Absolute or Relative Cell Referencing Saving and Opening Files with Macros Making macros always available Adding Macros to Keyboard Shortcuts, Quick Access Toolbar, Buttons and Shapes Editing a Macro in the Visual Basic Editor Understanding the Development Environment Customising the Editor Tips for General Typing in VBA Using Visual Basic Help Working with Procedures Program Design Understanding Modules Naming Rules Creating a Module Understanding Procedures Programming Macro Concepts Creating a Subroutine Creating a Function Understanding Arguments Exiting Procedures Calling Procedures Objects, Properties, Methods and Events Understanding Objects Properties, Methods, and Events Navigating the Object Hierarchy Understanding Collections Accessing a Member of a Collection Understanding Hierarchy Using the Object Browser Using the With Statement Working with Properties Working with Methods Creating an Event Procedure Reserved Macro Names Using Expressions, Variables and Intrinsic Functions Understanding Expressions and Statements Declaring Variables Understanding Data Types Determining the Value of Variables Working with Variable Scope Using Built-in VBA Functions Understanding Constants Using Message Boxes Controlling the Answer to a Message Box Using Input Boxes Declaring and Using Object Variables Controlling Program Execution Understanding Control-of-Flow Structures Using the If...End If Decision Structures Nested If Statements Using the Select Case ... End Select Structure Using the Do ... Loop Structure Using the For ... Next Structure Using the For Each ... Next Structure Guidelines for Use of Control-of-Flow Structures Debugging and Handling Errors Understanding Errors Using Debugging Tools Setting Breakpoints and Using Break Mode Stepping Through Code Trapping Errors with the On Error Statement Understanding the Err Object Working with Inline Error Handling Writing an Error-Handling Routine Working with Forms and Controls Understanding UserForms Creating a Form Displaying and Removing a Form Aligning and Sizing Controls Using the Toolbox Working with a Form's Properties, Methods, and Events Working with Form and Control Properties, Methods and Event Setting the Tab Order Populating a Control Who is this course for? Who is this course for? This course is designed to give proficiency in the Visual Basic Editor (VBE), predominantly making use of Excel objects, understanding Object's Properties, Events and Methods, basic VBA Object oriented programming, event handling, control structures, and debugging tools. Requirements Requirements Preferably, delegates should have attended the Excel Advanced 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
Do you want to prepare for your dream job but strive hard to find the right courses? Then, stop worrying, for our strategically modified Business Analysis: Market Research Analyst bundle will keep you up to date with the relevant knowledge and most recent matters of this emerging field. So, invest your money and effort in our 40 course mega bundle that will exceed your expectations within your budget. The Business Analysis: Market Research Analyst related fields are thriving across the UK, and recruiters are hiring the most knowledgeable and proficient candidates. It's a demanding field with magnitudes of lucrative choices. If you need more guidance to specialise in this area and need help knowing where to start, then StudyHub proposes a preparatory bundle. This comprehensive Business Analysis: Market Research Analyst bundle will help you build a solid foundation to become a proficient worker in the sector. This Business Analysis: Market Research Analyst Bundle consists of the following 30 CPD Accredited Premium courses - Course 1: Fundamentals of Business Analysis Course 2: Business Intelligence Analyst Course 3: Business Intelligence and Data Mining Course 4: Research Methods in Business Course 5: Financial Modelling for Decision Making and Business plan Course 6: Investment Course 7: Business Productivity Training Course 8: Business Consultant Course 9: Foundations of Business Strategy Consulting Course 10: Business Performance Management Course 11: Financial Analysis Course 12: Financial Statement Analysis Masterclass Course 13: Stakeholder Management Analyst Course 14: Public Speaking Course 15: Complete Communication Skills Master Class for Life Course 16: Receptionist Skills Course 17: Minute Taking Executive Training Course 18: Time Management Training - Online Course Course 19: Investment Analyst Course 20: Market Research Analyst Course 21: Make Business Plans: Forecasting and Budgeting Course 22: Business Accounting Training Course 23: Basic Business Finance Course 24: Strategic Business Planning Course 25: Business Development Course 26: Business Plan for Entrepreneours Course 27: Branding Fundamentals for New Business Course 28: Business Development & Sales Course 29: Marketing Strategies for Business Course 30: Financial Ratio Analysis for Business Decisions 10 Extraordinary Career Oriented courses that will assist you in reimagining your thriving techniques- Course 1: Career Development Plan Fundamentals Course 2: CV Writing and Job Searching Course 3: Interview Skills: Ace the Interview Course 4: Video Job Interview for Job Seekers Course 5: Create a Professional LinkedIn Profile Course 6: Business English Perfection Course Course 7: Networking Skills for Personal Success Course 8: Boost Your Confidence and Self-Esteem Course 9: Public Speaking Training Course 10: Learn to Fight Procrastination Learning Outcome This tailor-made Business Analysis: Market Research Analyst bundle will allow you to- Uncover your skills and aptitudes to break new ground in the related fields Deep dive into the fundamental knowledge Acquire some hard and soft skills in this area Gain some transferable skills to elevate your performance Maintain good report with your clients and staff Gain necessary office skills and be tech savvy utilising relevant software Keep records of your work and make a report Know the regulations around this area Reinforce your career with specific knowledge of this field Know your legal and ethical responsibility as a professional in the related field This Business Analysis: Market Research Analyst Bundle resources were created with the help of industry experts, and all subject-related information is kept updated on a regular basis to avoid learners from falling behind on the latest developments. Certification After studying the complete training you will be able to take the assessment. After successfully passing the assessment you will be able to claim all courses pdf certificates and 1 hardcopy certificate for the Title Course completely free. Other Hard Copy certificates need to be ordered at an additional cost of •8. CPD 400 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Ambitious learners who want to strengthen their CV for their desired job should take advantage of the Business Analysis: Market Research Analyst bundle! This bundle is also ideal for professionals looking for career advancement. Requirements To participate in this course, all you need is - A smart device A secure internet connection And a keen interest in Business Analysis: Market Research Analyst Career path Upon completing this essential Bundle, you will discover a new world of endless possibilities. These courses will help you to get a cut above the rest and allow you to be more efficient in the relevant fields.
Course Details Please note there is an additional charge for both OP & Sup units needing to be completed via re-assessment, please call the YCDI team if you are unsure - 01782 438813. If your streetworks card is about to or has already expired, you will need to take a NRSWA reassessment course. You are not able to work on a streetworks site with expired certificates. You can take reassessments at anytime before your certificates expire and the remaining time left before expiry is now added to your new card. For example, if you take your reassessment with 6 months still remaining, it will be added to your new card when you receive it, resulting in 5 years and 6 months on your card expiry. If you completed your NRSWA Operative or Supervisor course with us, we will advise you that you will need to complete the reassessment course within 3 months of the expiry date. If you are unsure what course is best for you, contact a member of our team who will be happy to help you. Prepare for your reassessment with our practice quiz. Although this quiz is aimed at people taking the full 5-day course, the questions will still be helpful revision before taking your reassessments.
Leadership Skills 1 Day Training in Bristol
This fashion design course for beginners and intermediates is a group class aimed to support aspiring designers or designers in need of guidance in the realisation of a viable and realistic collection of bags and/or accessories.This course enables you to understand essential skills required to become a fashion bag designer ans well as guiding you through the steps necessary for designing, developing, prototyping and manufacturing your collection. WHY THIS IS NOT THE USUAL ‘ACCESSORY DESIGN’ COURSEThis course is designed by a team of designers, prototype makers and handbag manufacturers.It is both a theoretical and practical course which will teach you what the industry requires from designers in order to be able to understand and correctly translate their ideas into finished products.This course is focused on giving you an overview on the complexity and extensiveness of the process that designing a collection of handbags requires.The course will assist you in understanding the prerequisites before and during the design of your styles. This knowledge will enable you to circumvent a lengthy, costly, and occasionally frustrating process when it comes time to prototype and manufacture your collection. WHY WE CREATED A FASHION DESIGN COURSEAfter years of experience in designing and developing collections for our customers, we realised that there was a substantial lack of clear information available about what designing a collection of handbags and fashion accessories truly requires and how it is achieved.We created this course with the aim of helping the new generation of designers, as well as designers which are still struggling, in developing their ideas and empower them to clearly and correctly communicate them to whoever is going to prototype their collection.We essentially have created this tuition based on the needs and problems of our customers, hoping to promote and facilitate creatives in the realisation of their projects. WHO IS THIS COURSE FOR?This course is designed for aspiring designers and professionals seeking expert advice from the industry. It caters to those in need of guidance to optimise their design process or understand the nuances of working as a fashion accessory designer.No previous experience is required. WHAT WILL BE TAUGHT?The designing classes cover various topics, including:Preliminary considerations before designingUnderstanding the concept and use of a moodboardOverview of researching crucial aspects like target audience, market placement, pricing strategy, etc.Overview on leather and hardware and their impact on costImportance of construction and finishing optionsAnatomy of a handbag, including lining and reinforcementsUnderstanding how to structure a collection with a collection planPlanning a balanced collection of fashion accessoriesDifferences and purposes of illustrations vs technical drawingsSketching techniques, including drawing in perspective and technical drawingsProduct development for a specific designUnderstanding what technical information the prototype maker requiresOverview of the prototyping processOverview of manufacturing options and processes for your collection HOW WILL THE ABOVE BE TAUGHT:The class will take place in person at our London studio and the lesson will alternate between theoretical lessons and practical exercises. INCLUDED IN THE COURSE:You will also receive access to a collection of handouts providing relevant information, useful resources and support in continuing your designing process independently.The handouts will contain:– A glossary containing essential key words related to the topic of the lesson– An illustrated glossary containing information about type of bags and bags’ features– An illustrated guide on common hardware used in bags and accessories– Documents about leather types, finishings, tanning processes– Information about perspective and guides to be used as reference to develop your drawings– A list of recommended suppliers for both leather and fittings (physically in London and online)– A glossary containing information about leather types and characteristics WHAT ARE THE ENTRY REQUIREMENTS?You should be able to use measurements and understand verbal and written English instructions. ARE THERE ANY OTHER COSTS? IS THERE ANYTHING I NEED TO BRING?Materials to exercise with are included.Feel free to bring a notepad, if you would like to take some notes, we will provide the rest. HOW LONG IS THIS TUITION?:This tuition will require up to 16 hours to complete.We aim to provide customised and high-quality tuition services and by only allowing max 6 students at a time, we are able to focus on each person needs and interests.As every student has a different level of ability and previous experience, this course might lead some students to complete the core aspects of the lesson in a shorter time frame than others.Students who complete the course early will be welcome to stay and use the studio facilities to exercise on the topics of the lesson.
Managing Multiple Projects: On-Demand Succeeding in today's competitive marketplace often requires cycle time reduction - reducing the duration of projects and getting results faster. This workshop will address managing multiple projects within the context of program or product management. Are your projects taking longer and longer to complete? Are results less than optimal because of time pressures on resources? Would you like to increase project 'throughout'? Succeeding in today's competitive marketplace often requires cycle time reduction - reducing the duration of projects and getting results faster. This workshop will address managing multiple projects within the context of program or product management. Planning and managing individual projects is challenging. When introducing the real-life limitation of resources and other outside influences into the multi-project environment, those challenges are magnified, and new challenges are introduced. This interactive workshop will position you for immediate action. The goal of this course is to equip you with the necessary knowledge, skills, and techniques so that you can effectively and productively manage multiple projects. What you Will Learn You'll learn how to: Manage stakeholder relationships and expectations Prioritize and sequence multiple projects Manage time and stress within a multiple project environment Effectively manage logical dependencies among projects Optimize the use of resources across multiple projects using concepts from Critical Chain methods Manage risk and communications in a multiple project environment Getting Started Introductions Course structure Course goals and objectives Foundation Concepts Portfolio, program, and project management principles The multiple project environment The MMP Process Model Developing the Multiple Project List Multiple project portfolio management Project selection Project categories and types The multiple project list Multiple Project Logical Dependencies Project dependencies Types of multiple project portfolios Categories of logical dependencies across multiple projects Project priorities in the multiple project schedule Multiple Project Resource Management Multiple project resources and resource management concepts Multiple project resource loading Resource pool and resource database Multiple project resource issues and outsourcing Critical chain resource management, including drum resources and multi-tasking Managing Risk Across Multiple Projects Multiple project risk management process Identifying, assessing, and responding to multiple project risks Critical chain and multiple project risks Risk interrelationship management methods Creating and Executing the Multiple Project Plan The multiple project plan Multiple project scheduling Multiple project budgeting Executing and maintaining the multiple project plan Controlling in the multiple project environment Tools in multiple project management Multiple Project Communications Effective communication in the multiple project environment Common communication barriers Multiple project communications plan Resolving multiple project conflicts Summary and Next Steps What did we learn, and how can we implement this in our work environments?
This is a highly interactive programme designed by the communication experts at TCM. The course helps learners to develop essential skills for everyday management. On this programme, delegates learn how to navigate the complex maze of having difficult conversations, managing performance, and giving bad news. Offering a proactive and hands on approach to teaching, the TCM trainers equip delegates with the confidence to have those crucial conversations, to prevent disputes before they escalate out of control and, to be assertive in addressing performance issues to achieve engagement and sustainable outcomes.
Assuring Quality Through Acceptance Testing: On-Demand It is also the business analyst's responsibility to confirm that the resulting solution developed by IT does, in fact, solve the defined problem. This is done first through testing, especially acceptance testing, and then through monitoring of the installed solution in the user community. It is the business analyst's job to define the business problem to be solved by IT. It is also the business analyst's responsibility to confirm that the resulting solution developed by IT does, in fact, solve the defined problem. This is done first through testing, especially acceptance testing, and then through monitoring of the installed solution in the user community. The business analyst is not only concerned with the testing itself, but also with the management and monitoring of the users doing the acceptance testing, and recording, analyzing, and evaluating the results. What you will Learn Upon completion, participants will be able to: Create a set of acceptance test cases Manage and monitor an acceptance test stage where users perform the testing Work with the development team in the systems testing stage Assess the solution once it is in the business environment Foundation Concepts The role of the business analyst An introduction to the BABOK® Guide BA roles and relationships through the project life cycle Introduction to assuring software quality through acceptance testing The Scope of IT Testing Overview of testing stages The testing process Testing documentation Pre-Acceptance Testing The BA's role in testing Early development testing stages (unit and integration) Late development testing stage (system) The Acceptance Test Stage - Part I (Planning, Design, and Development) Overview of user acceptance testing Acceptance test planning Designing user acceptance tests Developing individual user acceptance test cases Building effective user acceptance test scenarios The Acceptance Test Stage - Part II (Execution and Reporting) Operating guidelines Execution Reporting Post-Acceptance Testing Overview Project implementation Project transition (project closure) Production through retirement Testing Commercial Off-the-Shelf (COTS) Software Overview Selecting the software Implementing the software Summary What did we learn and how can we implement this in our work environments?
Work Breakdown Structures It's amazing how often project managers begin the project planning process by making an outlined list of every task they believe will be required to complete a project and then proclaim they have created the work breakdown structure (WBS) for the project. The result is a list of hundreds, or even thousands of tasks, many of them having durations of a few days or a few hours. Essentially, what they have done is create a 'to do' list, which they then use as a 'checklist' to measure progress. This approach leads to, and even encourages, micromanagement of the resources working on the project without consideration of more critical aspects of project management such as: requirements management, risk management, procurement management, estimating, scheduling, executing, and controlling. Further, it makes it impossible to see the big picture, at levels of detail, in keeping with the needs of sponsors, clients, project and functional managers, team leaders, and project performers. Join us for this exciting program and learn how to use the WBS to make better-informed business decisions. What You Will Learn You will learn how to: Describe the need for a project WBS Describe the WBS role in the project Gain practical experience in the development, decomposition, and use of the WBS Determine the appropriate level of detail in the WBS. Explain how the WBS integrates with project requirements, risk, procurement, estimating, scheduling, and overall project execution. Provide the basic tools to enhance efficient re-use of key information in your future projects Foundation Concepts Key definitions History of the WBS Importance of the WBS Overall structure Terminology Other breakdown structures WBS tools WBS & Scope Project scope management processes Specification of the project objectives WBS design based on project deliverable WBS decomposition process and 'The 100% rule' Work Packages and Control Accounts WBS & Risk Risk management planning and WBS Risk identification to enhance the WBS Risk analysis and the WBS Risk responses and updating the WBS Implementing risk response and Monitoring risks and the WBS WBS & Estimating Use of WBS in the estimating process Components and work packages Sizing and algorithmic estimates WBS & Scheduling Component Scheduling - High-Level Milestones WBS activity decomposition WBS elements dependencies Work Package Level Schedules Responsibility assignment matrix WBS & Execution and Control Earned Value Management and tracking of work performance Progress reports, forecasts, and corrective and preventive actions used to manage work performance Necessary information to close out a project
Project Leadership Skills - Français (On-Demand) Pour être efficace au sein d'une organisation, les responsables de projet doivent avoir une grande variété de compétences et d'aptitudes. Parmi celles-ci figurent: la création et l'exécution d'une vision; motiver les autres; influencer sans autorité; la mise en réseau; communiquer haut, bas et latéralement; la négociation; gestion des parties prenantes; et gérer les conflits. Cet atelier vise à développer les compétences générales essentielles à la direction d'une équipe et à la création d'un changement d'entreprise durable. Les participants auront un aperçu des sciences sociales et de la science du cerveau pour motiver et responsabiliser les autres. Ils apprendront et expérimenteront diverses stratégies et tactiques d'influence. Les participants découvriront également leurs préférences personnelles en matière de communication, leurs points forts et leurs angles morts et apprendront comment communiquer au mieux avec d'autres personnes qu'ils jugent «difficiles». Ils apprendront mieux à gérer le côté humain du changement et à apprendre des stratégies pour gérer chaque étape. Dans le processus. Les activités pratiques de négociation et de gestion des conflits renforcent l'apprentissage théorique, l'enracinant dans la vie réelle et le rendant exploitable. What you will Learn At the end of this program, you will be able to: Explain the importance of a vision in driving motivation and engagement Apply a scientific approach to better motivate those around you Strategically maximize your personal and positional power for better project results Determine influence and network development strategies necessary for personal development Know how to respond to communication challenges related to different personality styles Make the link between the expectations of stakeholders and the success criteria of a project Assess key stakeholders across different dimensions of complexity Apply the four rules of principled negotiation to real-life conflict situations Recognize key aspects of a physiological response to conflict Make the right choice of tools and techniques to "demine" an emotional situation Maximize different strategies and tactics to manage ambiguity at work Manage vision and purpose / Motivate others Communication and alignment with the vision Link the present to the future The Importance of Purpose The art and science of motivation Network development and influence Positive policy and project success Types of power in an organization power and influence Network Development Best Practices Communication The medium and the message Personality and communication styles Communication challenges Stakeholder management / Negotiation Identification of stakeholders Stakeholder analysis The basics of negotiation reasoned negotiation Manage the conflict Conflict dynamics The Anatomy of Conflict Conflict management approaches and tools Dealing with Ambiguity