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 Certificates Certificates Certificate of completion Digital certificate - Included
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.
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?
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
Leading People through Change: On-Demand: On-Demand Research shows that 70% of change initiatives fail in large organizations. The largest factor contributing to this failure rate is leadership - the inability to plan and lead people through change. In many change situations, tremendous focus is put on strategy, processes, and systems, while the issue of changing people's behavior is assumed it will 'just happen'. In this interactive course, you will learn why the people side of change is crucial. We will begin by understanding why and how people resist change, and how important it is to become strong and effective change champions. Next, we will focus on critical change management practices - creating our vision of the future state, planning for acceptance in our change audience and stakeholders, mitigating threats, and capitalizing on opportunities. We will use metrics to plan, show progress, and confirm success. Lastly, we will focus on the need to reinforce and sustain change, and to prevent relapse to old ways and methods. What you will Learn At the end of this program, you will be able to: Realize the nature of change and describe how resistance manifests in people Compare prevalent change models and categorize their similarities Identify and rate the skills, traits, and behaviors of effective change champions Envision the future state and assess stakeholders Plan for change communication, training, and risks Evaluate change effectiveness using feedback and metrics Develop reinforcement practices for benefits and communication Foundation Concepts What is Change? Resistance to Change Common Change Management Theories Becoming a Change Champion Plan Envisioning the future state Planning for people Change management plan Do Change communication Training Piloting Risks Study Feedback Metrics Variance analysis Act Benefits realization Change sustainment Reinforcement messaging and communications
Leading People Through Change (Free L&I Conference Course) (On-Demand) Research shows that 70% of change initiatives fail in large organizations. The largest factor contributing to this failure rate is leadership - the inability to plan and lead people through change. In many change situations, tremendous focus is put on strategy, processes, and systems, while the issue of changing people's behavior is assumed it will 'just happen'. In this interactive course, you will learn why the people's side of change is crucial. We will begin by understanding why and how people resist change, and how important it is to become strong and effective change champions. Next, we will focus on critical change management practices - creating our vision of the future state, planning for acceptance in our change audience and stakeholders, mitigating threats, and capitalizing on opportunities. We will use metrics to plan, show progress, and confirm success. Lastly, we will focus on the need to reinforce and sustain change, and to prevent relapse to old ways and methods. What you will Learn At the end of this program, you will be able to: Realize the nature of change and describe how resistance manifests in people Compare prevalent change models and categorize their similarities Identify and rate the skills, traits, and behaviors of effective change champions Envision the future state and assess stakeholders Plan for change communication, training, and risks Evaluate change effectiveness using feedback and metrics Develop reinforcement practices for benefits and communication Foundation Concepts What is Change? Resistance to Change Common Change Management Theories Becoming a Change Champion Plan Envisioning the future state Planning for people Change management plan Do Change communication Training Piloting Risks Study Feedback Metrics Variance analysis Act Benefits realization Change sustainment Reinforcement messaging and communications
Leading People Through Change (Free L&I Conference Course): On-Demand The goal of this course is for you to effectively lead and manage people through times of change. Research shows that 70% of change initiatives fail in large organizations. The largest factor contributing to this failure rate is leadership - the inability to plan and lead people through change. In many change situations, tremendous focus is put on strategy, processes, and systems, while the issue of changing people's behavior is assumed it will 'just happen'. In this interactive course, you will learn why the people's side of change is crucial. We will begin by understanding why and how people resist change, and how important it is to become strong and effective change champions. Next, we will focus on critical change management practices - creating our vision of the future state, planning for acceptance in our change audience and stakeholders, mitigating threats, and capitalizing on opportunities. We will use metrics to plan, show progress, and confirm success. Lastly, we will focus on the need to reinforce and sustain change, and to prevent relapse to old ways and methods. What You Will Learn At the end of this program, you will be able to: Realize the nature of change and describe how resistance manifests in people Compare prevalent change models and categorize their similarities Identify and rate the skills, traits, and behaviors of effective change champions Envision the future state and assess stakeholders Plan for change communication, training, and risks Evaluate change effectiveness using feedback and metrics Develop reinforcement practices for benefits and communication Foundation Concepts What is Change? Resistance to Change Common Change Management Theories Becoming a Change Champion Plan Envisioning the future state Planning for people Change management plan Do Change communication Training Piloting Risks Study Feedback Metrics Variance analysis Act Benefits realization Change sustainment Reinforcement messaging and communications
Portfolio Management Skills: On-Demand Project Management Institute (PMI)® Charter Global Registered Education Provider (R.E.P.) International Institute for Learning (IIL) has been reviewed and approved as a provider of project management training by PMI®. Become a strong, effective change advocate for meaningful portfolio management. This course is designed to equip and enable you to effectively and efficiently support the Executive Leadership and Operational Management to plan, implement, manage, and evolve portfolio management in your organization. It focuses on helping you become a strong and effective change advocate for meaningful portfolio management that delivers objective measurements of benefit contribution towards the strategic objectives to lead, manage, and continuously improve portfolio management governance, processes, and frameworks with and through the direction of a portfolio practice, principles, and delivery boards. What you Will Learn At the end of this program, you will be able to: Articulate the benefits of portfolio management Link the initiatives in an organization with its strategic objectives Participate in the introduction of portfolio management in an organization Create or improve the portfolio governance structure Lead the inventory of ongoing and new initiatives Assist the executives in the prioritization of initiatives through the use of Multi-criteria Analysis and other selection tools Support the executives in balancing the portfolio based on the optimal use of resources and priorities Create a portfolio delivery plan Define thresholds and variance reporting criteria Assist the executives and the financial team in the definition of Stage Gate Funding Lead the Stage Gate reviews Analyze the benefits that are being realized by the initiatives Foundation Concepts Definitions Benefits of Portfolio Management Objectives of Portfolio Management Portfolio Life Cycles Governing the Portfolio Portfolio Governance structure Roles and responsibilities Initial activities when starting portfolio management Prioritizing Initiatives Prioritize purpose Multi-Criteria Analysis Analytical Hierarchy Process (AHP) Strategic alignment Balancing the Portfolio Allocating resources and budgets Communicating decisions of initiatives status Planning the Portfolio Planning review cycles Using Stage Gate Funding Setting thresholds and variance reporting Tool examples Managing the Portfolio Delivery Project and Program Life Cycles Stage Gate Reviews Loop back to Prioritize, Balance and Plan Interaction with the Portfolio Delivery Board Project, Program and Functional Managers' roles and responsibilities