7858 Feedback courses delivered Online

Getting Started The CMI Level 2 Award in Team Leading covers team-leading skills and knowledge and is designed for practising or aspiring team leaders who wish to develop their knowledge and team-leading skills. A wide range of units allows individuals and employers to tailor the elements and size of the qualification to their needs specifically. The Level 2 Award in Team Leading is a concise and shorter course that gives you a substantial knowledge of core team-leading skills while focusing on the specific leadership areas appropriate to you and your workplace. You'll have a wide range of modules to choose from, and depending on your career goals, you can select the modules that will be most effective for your progression. Key Benefits This course will bring you many vital benefits, such as; Development of your skills in effective team leading Ensuring teams can meet organisational objectives Improve problem-solving skills Effective decision making Develop your knowledge of the roles and responsibilities of a team leader Key Highlights Are you a practising or aspiring team leader and wish to develop your team-leading skills and knowledge? Then, the CMI Level 2 qualification in Team Leading is the ideal starting point for your career journey. Remember! The assessment for the qualification is done based on assignments only, and you do not need to worry about writing any exam. With the School of Business and Technology London, you can complete the qualification at your own pace choosing online or blended learning from the comfort of your home. Learning and pathway materials and study guides developed by our CMI-approved tutors will be available around the clock in our cutting-edge learning management system. Most importantly, at the School of Business and Technology London, we will provide you with comprehensive tutor support through our dedicated support desk. If you choose your course with blended learning, you will also enjoy live sessions with an assigned tutor, which you can book at your convenience. Career Pathways The CMI Level 2 Team Leading can open many career pathways including, but not limited to: Team Leader, with an estimated average salary of £27,835 per annum Supervisor, with an estimated average salary of £22,480 per annum Team Coordinator, with an estimated average salary of £25634 per annum About Awarding Body Chartered Management Institute established over 60 years ago as the British Institute of Management back then; it has developed the UK's very first diploma in management studies. In the years that followed CMI has consistently been at the forefront of all aspects of management and leadership. Today CMI is the only chartered professional awarding body committed to offering the highest standards in management and leadership excellence. Presently over 100,000 managers use its unique services daily. CMI qualifications aim for managers and leaders at any level, and it remains the only Awarding Body which can award Chartered Manager status - the ultimate management accolade. Employers highly value the qualifications awarded by CMI, and boost your career prospects. What is included? Learn 100% online at your own pace Dedicated support from expert tutors Dedicated Support Desk Portal: You can raise queries, request tutor support and ask for a call back whenever you need guidance and assistance. Elevate Knowledge: Your tutors will provide formative assessment feedback for each module, helping you improve your achievements throughout the program Schedule online personal tutor meetings whenever you want, which will help you get the most out of your studies and provide guidance, support and encouragement 6 months support period 24-hour access to the online learning platform 'MyLearnDirect' Schedule live online classes for each module at your convenience. (Blended learning only) Quality learning resources and study guides developed by CMI-approved tutors. All assessment materials are conveniently accessible through the online learning platform 'MyLearnDirect' Induction: We offer online and flexible learning induction to help you settle in and prepare for your online studies Access to CMI Management Direct. It has 100,000s of reliable and validated management and leadership resources, including company and industry reports, videos, checklists, E-books, and journals. You have access to CMI Membership and Support for the duration of your study Assessment For each module you study, you will complete a written assignment of 1500 to 2,000 words and submit it online at your MyLearnDirect learning portal. The submitted assignments will be assessed by your CMI-approved tutor. Entry Requirements This course is designed for practising or aspiring team leaders who wish to develop their knowledge and team-leading skills. You don't need any formal qualifications to study this course. However, to be eligible for this course, you must:  Be 18 years of age and over Possess the ability to complete the Level 2 course Our friendly admissions advisors will provide the best advice, considering your needs and goals.  Progression On successful completion of a Level 2 qualification in Team Leading, several progression opportunities become available: Enhance your professional status by upgrading your CMI membership. Progress to other qualifications at the same level (e.g. from Level 2 Award to Level 2 Certificate Etc.). Progress to other qualifications at the next level (e.g. from Level 2 Certificate to Level 3 Certificate). Why gain a CMI Qualification? This course is perfect for you if you are a current or aspiring team leader and want to take your career to the next level. You will develop substantial knowledge of core team-leading skills while focusing on the specific leadership areas appropriate to you and your workplace. This course is designed for team leaders; to support the development of their skills in leading a team, making sure that team's work achieves organisational objectives, and contributing to planning, problem solving and decision making. Upon completing this course, you can progress to: CMI Level 3 Qualifications in First Line Management CMI Level 3 Coaching and Mentoring Studying for a CMI qualification offers you more than just academic standing. When you enrol with us for the CMI Level 2 Award in Team Leading, you will have access to CMI Membership and Support for the duration of your study alongside your qualification. CMI graduates achieve remarkable things: 72% agree that their CMI qualification gave them a competitive edge in the job application process. 89% agree they use the skills learnt on their accredited qualification in their current role. 88% agree that the accredited qualification gave them good career prospects. Recent CMI graduates earn a median of 28k compared to just 21k for a typical business studies graduate. Employers highly value the qualifications awarded by CMI, and over 80% of managers agree that a CMI qualification is essential to becoming a professional manager. Learners need to complete any combination of units to a minimum of 5 credits. The minimum Total Qualification Time is 50 hours, including 15 Guided Learning Hours. 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- Personal development as a team leader Reference No : Unit 2001V1 Credit : 6 || TQT : 60 LEARNING OUTCOMES 1. Be able to identify work objectives and the skills and knowledge required to meet them. 2. Be able to agree, implement and review the development plan to meet work objectives 3.Understand team leader's responsibility for welfare in the work area. UNIT2- Communicating with a team Reference No : Unit 2002V1 Credit : 5 || TQT : 50 LEARNING OUTCOMES 1. Understand the role of communication in leading a team 2. Understand how to organise team briefings 3. Understand how to lead team briefings UNIT3- Controlling resources Reference No : Unit 2004V1 Credit : 6 || TQT : 60 LEARNING OUTCOMES 1. Be able to identify and source resources needed to achieve team objectives 2. Be able to manage the resources effectively and efficiently to achieve team objectives 3. Be able to identify and reduce resource wastage UNIT4- Monitoring team performance Reference No : Unit 2003V1 Credit : 5 || TQT : 50 LEARNING OUTCOMES 1. Understand the team objective(s) and plan for achievement. 2. Be able to plan to achieve team objective(s). 3.Be able to monitor and review the team's performance. UNIT5- Building work relationships Reference No : Unit 2005V1 Credit : 5 || TQT : 50 LEARNING OUTCOMES 1. Understand how to communicate and maintain working relationships with the manager 2. Understand how to communicate and maintain working relationships with the team. 3. Understand how to develop work relationships outside the team UNIT6- Developing team needs Reference No : Unit 2006V1 Credit : 6 || TQT : 60 LEARNING OUTCOMES 1. Understand how to plan and implement induction for a new team member 2. Understand how to identify and plan the training needs of team members. 3. Be able to train a team member to carry out a task. UNIT7- Providing customer service Reference No : Unit 2007V1 Credit : 5 || TQT : 50 LEARNING OUTCOMES 1. Be able to identify the team's customers and the level of service required 2. Be able to identify and resolve customer service issues. 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. Management Direct As part of the program, you will get access to CMI Management Direct, which provides a rich foundation of management and resource for students. The Management Direct is packed with content, including: E-Books Articles Leader videos Idea for leaders Models and so much more... 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.

This course leads to the Mediterm Intermediate Award in Medical Terminology (Level 2), studied over approximately 12 weeks (taking more or less time dependent on learner requirements). This course is suitable for those already working in healthcare or those who wish to start a new career in healthcare.

In this course we explore how we have attempted to build inclusive circles of support around individuals and contrast this with a radical approach to problem solving with parents – the Parent Solutions Circle. Parent Solutions is a brand new approach to problem solving with parents based on our live group work in schools. A focus on challenging behaviour brings interest, energy and commitment.  Course Category Inclusion Peer Support Parents and Carers Behaviour and relationships Description In this course we explore how we have attempted to build inclusive circles of support around individuals and contrast this with a radical approach to problem solving with parents – the Parent Solutions Circle Parent Solutions is a brand new approach to problem solving with parents based on our live group work in schools. A focus on challenging behaviour brings interest, energy and commitment. Essentially the approach involves gathering a group of parents and carers together who recognise how challenging their own children are and would like some help to figure out how to be with them or how to manage an aspect of their behaviour. The process is facilitated but majors on the parents offering each other their wisdom and ideas. The directness that only peers can provide to each other makes the work both powerful and effective. Mobilising the wisdom and experiences of parents in a safe way is a delicate art. In this training we will explore how this can best be done. Parents who have been on all the courses and had all the professional advice in world love this way of working because they get to offer each other their experience, ideas and wisdom. The approach is capacity focused, person centred approach to working with parents rather than the dominant deficit oriented and ‘medical model’ of viewing and planning for parents. We work with rather than do things to a group of parents. This training can be modelled with a group of parents or can be demonstrated with a group of professionals. We prefer mixed groups. Learning Objectives For participants to learn how to set up a Parent Solutions Circle For participants to understand the underlying rationale and ethos of this way of working To learn the facilitation process and stages of the Circle process Who Is It For? Anyone interested in working with parents and carers in a way that builds and makes use of their capacities rather than focus on their challenges and difficulties. School leaders and managers Social Care teams Community organisers Psychologists Course Content True parent empowerment Facilitating groups Problem solving process Handling group communication Allowing direct feedback and challenge between participants in a safe way Building relationships Creating natural circles of support that can provide peer support and mutual problem solving If you liked this course you may well like: Creating Community Circles

Successful communications are all about making the message as simple as possible – but this can be difficult when the subjects we're talking about are inherently complicated.  Academic institutions, tech companies, health organisations, charities and many others have complex ideas, processes and systems at the heart of what they do.  This course is for anybody who needs to distill information down into key messages for important stakeholders, funders and investors, decision makers and members of the public.  You’ll learn proven techniques for grabbing attention and changing minds through presentations and public speaking, infographics and data visualisations, and written reports and online posts.  We’ll work with you before the course to ensure that we understand your organisation and what you’re hoping to achieve. Sample learning content Session 1: Understanding your audience Matching your objectives to your audience's motivations. Identifying the right tone and language. Understanding how, where and when your audience wants to be spoken to. Session 2: Refining your objectives  Breaking down strategic aims into tactical steps Metrics and milestones: defining and measuring progress and success. Rapidly building a brief for your communications. Session 3: Telling the story  Using metaphors, visuals, comparisons to frame your narrative. From slide decks to online campaigns - choosing the right formats for delivering your message. Selecting communications channels to maximise reach and impact. Session 4: Keeping it going  Processes and systems for launching and maintaining communications campaigns. Building social proof – creating and curating content. Troubleshooting and preparing for common challenges. Delivery We deliver our courses over Zoom, to maximise flexibility. The training can be delivered in a single day, or across multiple sessions. All of our courses are live and interactive – every session includes a mix of formal tuition and hands-on exercises. To ensure this is possible, the number of attendees is capped at 16 people.  Tutor Alan Rutter is the founder of Fire Plus Algebra. He is a specialist in communicating complex subjects through data visualisation, writing and design. He teaches for General Assembly and runs in-house training for public sector clients including the Home Office, the Department of Transport, the Biotechnology and Biological Sciences Research Council, the Health Foundation, and numerous local government and emergency services teams. He previously worked with Guardian Masterclasses on curating and delivering new course strands, including developing and teaching their B2B data visualisation courses. He oversaw the iPad edition launches of Wired, GQ, Vanity Fair and Vogue in the UK, and has worked with Condé Nast International as product owner on a bespoke digital asset management system for their 11 global markets. Testimonial “We’ve now worked with Alan for almost 3 years, and during that time he has continued to deliver the highest quality training for our clients and delegates. Alan’s passionate delivery style has continued to deliver innovative training solutions to over 1500 delegates across the public, private and voluntary sector. Each of our courses with him has always delivered exceptional feedback and satisfaction levels.” Joe Barlow | Head of Programme, Understanding ModernGov

To drive actions and get decisions made, you need to be able to present effectively to customers, clients, senior managers or colleagues. The perfect presentation is a potent combination of content, design and delivery  You need to distill down complex concepts, large data sets, intricate processes and innovative ideas. You need to make the right design choices to ensure your slide decks communicate quickly (as well as looking great). And you need the confidence and storytelling techniques to lead your audience through the content.  This course is for anyone who regularly needs to create and deliver presentations for different stakeholders. It will cover how to plan, design and deliver brilliant presentations.  Sample learning content  Session 1: Planning a presentation  Assessing the needs and level of understanding of your audience. Frameworks for building a logical and compelling narrative. Emphasising key messages, while allowing for deep dives and questions. Session 2: Presenting data and processes Understand graphical perception and how people absorb visual information. Effective charts for different types of data stories. How to display processes, timelines and organisational structures. Session 3: Design tricks Using colours to add emphasis and meaning. Creating hierarchies of information to help your audience. Building templates and style guides. Session 4: Delivery techniques Perfecting your performance in-person or online. Dealing with difficult questions and hostile audiences. Refining the beginning, middle and end of your narrative. Delivery We deliver our courses over Zoom, to maximise flexibility. The training can be delivered in a single day, or across multiple sessions. All of our courses are live and interactive – every session includes a mix of formal tuition and hands-on exercises. To ensure this is possible, the number of attendees is capped at 16 people.  Tutor Alan Rutter is the founder of Fire Plus Algebra. He is a specialist in communicating complex subjects through data visualisation, writing and design. He teaches for General Assembly and runs in-house training for public sector clients including the Home Office, the Department of Transport, the Biotechnology and Biological Sciences Research Council, the Health Foundation, and numerous local government and emergency services teams. He previously worked with Guardian Masterclasses on curating and delivering new course strands, including developing and teaching their B2B data visualisation courses. He oversaw the iPad edition launches of Wired, GQ, Vanity Fair and Vogue in the UK, and has worked with Condé Nast International as product owner on a bespoke digital asset management system for their 11 global markets. Testimonial "We’ve now worked with Alan for almost 3 years, and during that time he has continued to deliver the highest quality training for our clients and delegates. Alan’s passionate delivery style has continued to deliver innovative training solutions to over 1500 delegates across the public, private and voluntary sector. Each of our courses with him has always delivered exceptional feedback and satisfaction levels." Joe Barlow | Head of Programme, Understanding ModernGov

This highly practical workshop will help you become a more effective negotiator and learn the skills that master negotiators use.

Course Objectives At the end of this course you will be able to: Identify the components of the PowerPoint interface Create slides Format text on slides Add and modify graphical objects to a presentation Work with tables in a presentation Add charts to a presentation Prepare the SlideShow '1 year email support service Take a look at the consistent excellent feedback from our corporate clients visiting our site ms-officetraining co uk Customer Feedback Very patient Trainer. Happy to adapt course + help with problems on existing presentations. Andrea Lethbridge - CNN ' 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 public, one to one, tailored and bespoke courses. Tailored in company training courses: 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. Getting Started with PowerPoint Identify the Components of the PowerPoint Interface Create a PowerPoint Presentation Accessing Help Choose the right view for the task in PowerPoint Normal view Slide Sorter view Notes Page view Outline view Add, rearrange, and delete slides in PowerPoint Working with Themes Add colour and design to my slides with themes Remove the current slide design (theme) Slide Layout What is a slide layout? Apply or change a slide layout Working with text Add text to a slide Create a new text box Format text Tables Add a table to a slide Format a Table Copy and paste a table from Word Insert an Excel spreadsheet within PowerPoint Edit Cells, Rows and Columns Delete a table Graphics Working with Clipart, and Shapes Selecting objects, shapes, pictures or text boxes Arrange a picture, shape or other object Adding Charts to Your Presentation Create a Chart Format a Chart Insert a Chart from Microsoft Excel Inserting date and slide numbers Add slide numbers to your presentation Hide slide numbers on the title slide Change where the page numbers appear on your slides Start your slide numbering with a specific number Print slides, notes, or handouts Create the Slide Show Record your slide show Preview the recorded slide show Turn slide timings off Set the slide timings manually Add or remove transitions between slides Add Animations to Text and Objects Deliver the Presentation Speakers notes Add speaker notes to your slides View your speaker notes as you deliver your slide show Who is this course for? Who is this course for? This course is designed for end users who are interested in learning the fundamentals needed to create and modify engaging presentations. Requirements Requirements General knowledge of the Windows OS Career path Career path Microsoft Office 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

Duration 1 Days 6 CPD hours Overview The Coaching And Mentoring focuses on how to better coach your employees to higher performance. Coaching is a process of relationship building and setting goals. How well you coach is related directly to how well you are able to foster a great working relationship with your employees through understanding them and strategic goal setting. You are in your office looking over your performance report and it happened again. Your low performing employee failed to meet quota this month even after you spoke with them about the importance of meeting goals. This employee has a great attitude and you know they can do better. You just do not know how to motivate them to reach the goal. Money used to work, but that has worn off. You are baffled and you know being frustrated makes matters worse. What do you do? 1 - Defining Coaching and Mentoring Defining mentoring Defining what coaching is and is not Elements of coaching Factors for success Critical Coaching Skills 2 - Coaching Assessment Individual coaching assessment Reflection and discussion of results 3 - Interpersonal Communication Interpersonal communication skills Open and closed questions Probing techniques and process Active listening 4 - Setting Goals with SPIRIT Identifying Values Identifying Dreams Setting S.P.I.R.I.T. goals 5 - Learning Styles and Principles Three learning styles Adult learning principles 6 - The Coaching Model Components of the coaching model Coaching model characteristics Giving effective feedback 7 - Bringing It All Together Coaching skills reinforcement Case studies

This ESOL Level 2 Online Course is accredited by Pearson Edexcel and regulated by Ofqual.  The academic and general qualification Pearson Edexcel is created to advance and improve learners' skills while advancing knowledge. With the aid of Edexcel certifications, students can advance either into a higher education programme or right into the workforce.  Qualifications, exams, and assessments are governed in England by Ofqual (The Office of Qualifications and Examinations Regulation). They are in charge of identifying the knowledge, skills, and understanding that students have displayed, and also ensure that all the assessments and exams reveal what a student has accomplished. Course Curriculum Reading Identifying the Main Point 00:15:00 Predict the Meaning of Unfamilar 00:15:00 Purposes and Types of Texts 00:15:00 Reading Strategies 00:10:00 Scanning Practice. 00:15:00 Speaking and Listening Speaking and Listening 00:20:00 Writing L2 Writing Paragraphs 00:15:00 Set 21 Writing Level 2 - QP 00:15:00 Writing Exam - Task 1 - Plan Writing. 00:20:00 Writing Exam - Task 2 - Fill in a Form. 00:15:00 Obtain Your Certificate Order Your Certificate of Achievement 00:00:00 Get Your Insurance Now Get Your Insurance Now 00:00:00 Feedback Feedback 00:00:00

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