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
The TQUK Level 3 Certificate in Supporting Teaching & Learning in Schools (RQF) Teaching Assistant Qualification is to enable you to gain a recognised (RQF) qualification as a Teaching Assistant. As a Teaching Assistant you are responsible for carrying out practical and administrative tasks, and you are required to work under the direction of the class teacher in the supervision and support of pupils’ learning. In doing this you are helping to make more time available for the Teacher to teach on a daily basis.
A personalised resilience profile and 60 minute coaching and exploration session for those who want to develop their capacity to adapt positively in an ever changing world.
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
Discover the zenith of gastronomy with our comprehensive course bundle: "Food Manager, Restaurant and Catering Management - QLS Endorsed". Unlock a world of theoretical knowledge across eight diverse yet interrelated courses, all primed to sculpt you into a formidable figure in the Food & Hospitality industry. This bundle includes three prestigious QLS-endorsed courses: Food and Beverage Manager, Hospitality & Restaurant Management, and Catering & Food Safety. Each course is accompanied by a tangible hardcopy certificate, validating your mastery in these areas. In addition to these, we've incorporated five relevant CPD QS accredited courses to further bolster your theoretical comprehension. These courses weave together a tapestry of understanding that will set you apart in any professional kitchen or catering venture. Key Features of the Food Manager, Restaurant and Catering Management - QLS Endorsed Bundle: 3 QLS-Endorsed Courses: We proudly offer 3 QLS-endorsed courses within our Food Manager, Restaurant and Catering Management - QLS Endorsed bundle, providing you with industry-recognized qualifications. Plus, you'll receive a free hardcopy certificate for each of these courses. QLS Course 01: Food and Beverage Manager QLS Course 02: Hospitality & Restaurant Management QLS Course 03: Catering & Food Safety 5 CPD QS Accredited Courses: Additionally, our bundle includes 5 relevant CPD QS accredited courses, ensuring that you stay up-to-date with the latest industry standards and practices. Course 01: Food Labelling Regulations Training Course 02: HACCP Training Course 03: Food Allergen Awareness Level 3 Course 04: How to Improve Your Food Hygiene Rating Course 05: Immunity Boosting Food In Addition, you'll get Five Career Boosting Courses absolutely FREE with this Bundle. Course 01: Professional CV Writing Course 02: Job Search Skills Course 03: Self-Esteem & Confidence Building Course 04: Professional Diploma in Stress Management Course 05: Complete Communication Skills Master Class Convenient Online Learning: Our Food Manager, Restaurant and Catering Management - QLS Endorsed courses are accessible online, allowing you to learn at your own pace and from the comfort of your own home. Embrace this rare opportunity to delve into an all-encompassing study of food management and catering. Take the first step towards a fulfilling career by arming yourself with an enriched understanding of food, its safety, and the dynamic world of restaurant and hospitality management. Learning Outcomes: Understand the responsibilities of a Food and Beverage Manager. Comprehend the intricacies of Restaurant and Hospitality Management. Develop knowledge of safe catering and food safety practices. Understand Food Labelling Regulations and HACCP Training. Be aware of food allergens and methods to boost food hygiene ratings. Understand the role of Immunity Boosting Food in the hospitality sector. Apply principles of design and graphic design using Canva in your professional pursuits. Unearth a treasure trove of knowledge with our "Food Manager, Restaurant and Catering Management - QLS Endorsed" course bundle. This comprehensive package provides an in-depth theoretical understanding of eight crucial areas in the food and hospitality industry. With QLS endorsed and CPD QS accredited courses, it's an immersive educational journey that promises an enriching learning experience. CPD 250 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Individuals seeking to build a career in food and beverage management. Professionals looking to enhance their knowledge in hospitality and restaurant management. Those interested in catering and food safety. Anyone interested in understanding food labelling, allergen awareness, and health-oriented food concepts. Career path Food and Beverage Manager (Salary Range: £28,000-£40,000) Restaurant Manager (Salary Range: £25,000-£38,000) Catering Manager (Salary Range: £25,000-£35,000) Food Safety Officer (Salary Range: £20,000-£32,000) Health and Safety Coordinator in Food Sector (Salary Range: £22,000-£30,000) Nutritional Advisor (Salary Range: £20,000-£35,000) Certificates Digital certificate Digital certificate - Included Hard copy certificate Hard copy certificate - Included
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: 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