1740 Sup courses in London

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

The YMCA qualifications support every learner, whether they are taking their first steps into fitness or simply wish to boost their skills. Course Overview Through completion of this qualification, learners will develop an awareness of mental health and be able to signpost others to mainstream medical or alternative support organisations. The purpose of this qualification is to develop learners' understanding of mental health, mental ill health and the risks associated with mental health conditions. Learners will also learn about sources of support available to individuals with mental health conditions. Endorsed by the Chartered Institute for the Management of Sport and Physical Activity (CIMSPA), this qualification can be used towards members' annual Continuous Professional Development (CPD) requirements. Enables learners to understand: • Mental health, mental ill health and mental health conditions • Attitudes to mental health • The importance of physical activity and exercise for mental health. Provides learners with knowledge of: • Risks associated with mental health conditions • Mainstream and alternative methods of supporting individuals with mental health conditions. Structure and Assessment: To achieve the YMCA Level 2 Award in Mental Health Awareness and Understanding Approaches to Support Individuals (603/7146/8), learners must successfully complete one unit. Entry Requirments Learners should be aged 16 plus No formal prerequisites, however it is recommended that learners hold YMCA Awards Level 2 Certificate in Fitness Instructing or equivalent. Progression Routes This qualification doesn't provide automatic progression onto another YMCA Awards qualification, however it may provide progression opportunities on to qualifications related to careers in mental health, health and social care, counselling or psychology. Learners taking this qualification may also consider further training at the same and higher levels in a range of qualifications. For example: • YMCA Level 2 Award in Nutrition for Healthy Living (600/5269/7). • YMCA Level 2 Certificate in Gym Instructing (603/2767/4). • YMCA Level 2Certificate in Group Exercise Instructing (603/7154/7). • YMCA Level 2 Diploma in Exercise and Fitness Instructing (Coming soon). • YMCA Level 3 Award in Emergency First Aid at Work (603/1902/1). • YMCA Level 3 Award in First Aid at Work (603/1903/3). • YMCA Level 3 Diploma in Personal Training (Practitioner) (603/2438/7). • YMCA Level 3 Diploma in Teaching Pilates (Practitioner) (603/3855/6). • YMCA Level 3 Diploma in Teaching Yoga (Practitioner) (603/3617/1). DURATION 29 Hours WHATS INCLUDED Course Material Case Study Experienced Lecturer Refreshments Certificate

This CPD course meets the criteria for the General Dental Council’s development outcomes C. This course includes medical emergencies as set out by the GDC in the dental practice. Immediate Life Support (ILS) Level 3 (VTQ) course is designed to meet the requirements of ILS courses laid down by UK Resus Council guidelines and is certified by ProTrainings. This CPD course meets the criteria for the General Dental Council’s development outcomes C. This course includes medical emergencies as set out by the GDC in the dental practice. This course includes the latest CPR and Coronavirus recommendations. The aim is to train healthcare personnel in cardiopulmonary resuscitation, simple airway management and safe defibrillation by enabling them to manage patients in cardiac arrest until the arrival of a cardiac arrest team and to participate as members of that team. The course is run over one day and consists of lectures and practical sessions. The course looks at how to identify the causes and promote the prevention of cardiopulmonary arrest. Recognise and treat the deteriorating patient using the ABCDE approach and undertake the skills of quality CPR and defibrillation. It also covers simple airway manoeuvres and utilises non-technical skills to facilitate initial leadership and effective team membership. Dates for 2024 (please choose one for your course): 21 August, 18 November Duration : 6 hours (1 day) Time: 9:30am to 5pm Fee: £195.00 Location – The Foundry, 156 Blackfriars Rd, London SE1 8EN (Southwark Station (2-3 min walk) and Waterloo/Blackfriars Station (10 min walk)) Two Certificates on completion (available for collection from the Academy in between 5 to 7 days) Regulated Certificate – valid for 1 year Verifiable CPD Certificate – 6 hours

If you're interested in advancing your career in the education and training industry, this course is perfect for you. The course covers the essential skills and knowledge required to internally assure the quality of assessment in the education and training sector. Upon completion, you'll be able to conduct internal quality assurance activities and assess the competence of assessors. This certification is ideal for those who aspire to become internal quality assurers, lead internal quality assurance teams, or wish to enhance their career prospects in the education and training industry. Our course is available at a competitive price of 499 and is delivered online through our e-learning platform. You'll be able to complete the course at your own pace and convenience, with support from our experienced instructors. This course is ideal for those who want to advance their career in the education and training industry. Become a certified internal quality assurer with our VTCT Level 4 Award in the Internal Quality Assurance of Assessment Processes and Practice course.

The primary outcome of the VTCT Level 3 Certificate in Assessing Vocational Achievement is to prepare you to enter the specific sector of education and training as a vocational assessor. All the units in this qualification relate directly to the specific job role of vocational assessor. The VTCT Level 3 Certificate in Assessing Vocational Achievement is a substantial vocational qualification that will prepare you for a career as a vocational assessor. This qualification is designed for learners aged 19 years or older and will support you to gain employment as a vocational assessor, as the units contained in this qualification cover all the skills and knowledge required for this role. This is a practical-based qualification intended for those who assess both occupational competence in the work environment, and vocational skills, knowledge and understanding in environments other than the workplace (i.e. workshop, classroom or other training environment). Entry onto this qualification will require you to have full competence in the vocational subject area that you will be assessing and you will need access to a cohort of learners, so that you can gather evidence of real assessments. This qualification includes units covering the principles and practices of assessment, assessing learners' occupational competence in the work place and assessing vocational skills, and knowledge and understanding of education and training. This qualification is the only Level 3 certificate offered by VTCT in Assessing Vocational Achievement.

Course Objectives At the end of this course you will be able to: Do advance Table design Do advance Query design and Action Querys Do advance Form design with the use of macros and buttons Export and import data to and from different sources. 1 year email support service Take a look at the consistent excellent feedback from our corporate clients visiting our site ms-officetraining co uk 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. Advanced Table Design Advanced Field Properties Table Properties Advanced Query Design Advanced Naming Conventions Join Tables in Queries Manage Query Joins Use Self-Joins in Queries Summarise Data in Queries Parameter Queries Action Queries Crosstab Queries Advanced Form Design Create Subforms and Linked Forms Form Controls Command Buttons Form Properties Interface, Start-Up and Navigations Forms Working with Macros Create Single Macros Run Macros Work with Sub Macros Use Conditional Macros Run Macros from Buttons Assign Macros to Events Extending Data Reach Import Data Export Data Work with Linked Tables Managing Databases Object Dependencies Database Documenter Performance Analyzers Regular Management of a Database Access Database Security Who is this course for? Who is this course for? The course is aimed at all users who would like to obtain the necessary skills to create advanced table, query, form and reports as well as to automate tasks with the use of macros. 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

Unity 3d face to face training customised and bespoke.

This is a highly interactive programme designed by the communication experts at TCM. The course helps learners to develop essential skills for everyday management. On this programme, delegates learn how to navigate the complex maze of having difficult conversations, managing performance, and giving bad news. Offering a proactive and hands on approach to teaching, the TCM trainers equip delegates with the confidence to have those crucial conversations, to prevent disputes before they escalate out of control and, to be assertive in addressing performance issues to achieve engagement and sustainable outcomes.

Overview Account Management is an important role within any organisation. Account Managers are responsible for nurturing customer relationships and increasing sales with their organisation’s key customers. The Account Manager will usually act as a first point of contact for clients; responding to complaints, purchases, project requests and any general queries. Their approach should help maintain client relationships in order to ensure that they continue to use the company for business. This one day course can help them learn the key skills they need. Description Build a strong account management team that are able to effectively manage customer relationships and drive sales The role of account manager is both important and demanding. The account manager acts as the ‘face’ of the business and should professionally represent the business by creating a strategy for success and delivering a high level of customer service. Account managers need to be effective communicators, needing to both engage with the client and also develop internal relationships to ensure promises are delivered upon. Another key responsibility of the account manager is to identify business opportunities and help drive business results for their company. Account Management can be a very challenging role depending on the number of clients, the range of industries the clients represent, and the nature and attitude of the client. The main focus of the role is to provide continual client service to clients, this may include quarterly or annual business reviews, additions to the account in terms of extra services supplied plus face-to-face and online meetings, on a regular basis. The Account Manager will also be responsible for delivering high levels of client service to ensure that clients do not leave and will need to create a strategy around this. This strategy will depend on the type of client in terms of size of the business commitment, Key Performance Indicators plus contractual agreements which may dictate the framework for the relationship. Building a personal relationship as well as a business one is key to becoming an effective Account Manager. After all, “It is easier to fire a business associate or employee than it is to fire a friend”. Why should people attend this training course? Well, just imagine if your employees were better able to: Build effective business relationships with clients and help drive sales performance. Add value to clients and help ensure their requirements are met or exceeded. Measure the performance of their key accounts and adapt their approach accordingly. Understand the key attributes required for success and work on developing them. Set a strategy for sales success and create action plans for pre-defined goals. Monitor and measure their own performance and set their own targets. Ultimately, this training course will help employees to focus on what is required to succeed in the role of account manager, building a strategy with clear actions and helping the organisation to business success. Who is this course for? This Account Management training course is for anyone that works in an account management role or relevant sales function and will assist the participants in improving their working practices, developing customer relationships and in turn increasing business performance and sales success. Requirements for Attendance Prior sales experience is recommended, but an awareness of the sales process as a minimum will suffice.

Serious about starting your own candle business? Set yourself up for success from the very beginning, in a private course with Paula Mateo, award winning founder of Old Bexley Soap & Candle Co.