20533 Courses

Course Objectives At the end of this course you will be able to: Work with advanced lookup and reference functions Create macros to automate common tasks Use advanced techniques to analyse data Create PivotTables and PivotCharts Work with data validation tools Import and export data ' 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 course was very interesting and engaging and will definitely be put to use. The trainer was very helpful and charismatic. Marving Lopez - AM Best Europe Pedro was excellent. Very knowledgeable, clear and great rapport with class. Darren Barkey - Direct Wines Great content and learnt a lot. Really enjoyable :) Kristie-Lee Ryan - Stirling Ackroyd 1 year email support service Take a closer look at the consistent excellent feedback 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 classrom, 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. Please visit our site (ms-officetraining co uk) to get a feel of the excellent feedback our courses have had and look at other courses you might be interested in. Advanced Functions COUNT, COUNTA, COUNTIF, COUNTBLANK, SUMIF, SUBTOTAL IF, OR, AND, IFERROR VLOOKUP to lookup Exact Values and Approximate values MATCH, INDIRECT, ROW/COLUMN, INDEX, OFFSET Analysing Data PMT function to calculate a monthly payment of a loan What If Analysis using Goal Seek Use scenarios to consider many different variables Using Solver Add-in to optimize variables PivotTables Create a PivotTable to analyse worksheet data Add or remove fields in a PivotTable Change the data source for a PivotTable Working with external data sources Using different Statistical Functions Calculate a Running Total, % of Grant Total, Difference From… Using the Slicer and Timeline to filter the PivotTable Using Filters in a PivotTable Group by Date, Auto Group by ranges of values, Custom Group Create a PivotChart The GETPIVOTDATA function Formula auditing Precedents and dependents Error checking Watch a formula and its result by using the Watch Window Evaluate a nested formula one step at a time Data Validation Number Validation Data List Validation Message Prompts and Alerts Conditional Data Validation Data Validation Errors Consolidation Consolidate data by position Consolidate data by category Use a formula to consolidate data Outline (group) data in a worksheet Create an outline of rows Create an outline of columns Copy outlined data Hide or remove an outline Connect external data to your workbook Using the Power Query Editor to import data From Text and CSV, From Access, From Web, From another Workbook Using the Power Query Editor to; Transform your data by Selecting which fields to import, by Splitting Columns, Changing Data Type and more. Deleting Applied Steps Refreshing your data Working with Form Controls; Buttons, Option Buttons and Scroll Bars Introduction to Macros Change Macro Security settings How to Record a macro Some Macro Examples Delete a macro Edit the macro to view the VBA code Copy part of a macro to create another macro Assign a macro to a button Who is this course for? Who is this course for? This course is intended to end users who want to develop their skills so they can use advanced techniques to analyse extensive and complex datasets in Excel and to automate simple tasks with the use of Macros. Requirements Requirements Preferably, delegates should have attended the Excel Intermediate 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

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

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

Age and gravity effects on our skin are offset by non-invasive HIFU treatment using the body's own recuperative powers to lift the skin of the face, neck, under the chin, and décolleté, lift eyebrows and smooth wrinkles and lines. It is safe and effective. HIFU treats tissue otherwise only reached by surgery. HIFU can go beneath the surface of the skin without breaking the outer skin and reach into the dermis and SMAS layer. It is suitable for men as well as women. This training course for HIFU Non-Surgical Facial Therapy is specially developed for the more experienced facial specialist who wants to offer HIFU Non-Surgical Facial Therapy as a new treatment on their menu. Course prerequisites This course is suitable for both medics and non-medics.  Level 3 in Beauty Therapy or equivalent is desirable Good command of English A minimum of 18 years Previous skin and facial training are desirable we suggest that learners new to the industry enrol on our facial and skincare course prior to enrolling on our ClinicCare skin peel course. Course structure A mixture of online study, virtual lectures and an onsite practical session. All courses are intimate with four learners in class 2-1 ratio. Areas covered within the course: Health and safety Anatomy and Physiology Fat types Fat Distribution Role of fat in the body The science behind HIFU for Fat Reduction The science behind HIFU for skin laxity Stages of skin laxity Collage Elastin Fibroblasts Wound healing process Selecting different equipment and the benefits associated Cartridge type Areas suitable for treatment Treatment duration Protocols including frequency, intensity etc Benefits for the client and clinic Contra indications and actions Client suitability and assessment for treatment Risks and side effects Training is complimentary when you purchase the Beautier 4D HIFU machine. Contact us for the course and machine package prices.

A four-hour workshop on how to accelerate the learning and development of your Neurodiverse colleagues.

Unity 3d face to face training customised and bespoke.

Come and have some fun with clay in the peaceful setting of my studio located in the cottage garden of our home on the Cambridgeshire/Norfolk border.

As the field of skin technology and products continues to evolve, skin peels have undergone a remarkable resurgence in popularity. These treatments, also known as "chemical" peels, harness the advancements in specialised products to exfoliate the skin and eliminate dead cells, providing remarkable results while ensuring client comfort. Our course will introduce you to a variety of natural acids, such as glycolic, lactic, and salicylic acid, which are used in modern skin peels. You'll learn the art of mixing peels and working with pre-mixed products, enabling you to customise treatments to address specific skincare concerns and conditions. Our comprehensive training will empower you to confidently combine various skin peels, enhancing the effectiveness of your existing facial treatments. By extending the efficacy of your services, you'll provide your clients with exceptional results and a rejuvenated complexion. Moreover, you'll gain a deep understanding of the science behind skin peels, allowing you to educate your clients on the benefits and guide them towards achieving their skincare goals. Join our Skin Peel Course and unlock the potential of these innovative treatments. With our expert guidance, you'll acquire the expertise and knowledge to become a trusted skincare professional. Course Entry Requirements:  Minimum of 18 years Good command of English Previous skin and facial training are desirable; we suggest that learners new to the industry enrol on our facial and skincare course before enrolling on our ClinicCare skin peel course. Course Pre-Study/Practical & Length: This course is a combination of theory study, virtual lectures and onsite practical  Course Agenda: All courses are intimate with four learners in class 2-1 ratio. Areas covered within this course are: Anatomy and Physiology of the Skin  Infection control  Sharps and hazardous waste Pre-study chemical peel theory Practical training 1 model  Professional live demonstrations Clinical setup Acids covered in this course: Glycolic acid Kojic acid Lactic acid Enzyme peels Mandelic acid  Arbutin Phytic Acid Salicylic acid Equipment / Starter Kits A professional starter kit can be purchased with this course. The kit costs 200 and is an additional cost to the training fees. Key Information A very popular treatment that is growing in popularity. Quick appointments. Minimal downtime which produces quality results. We gear the training around the use of the Clinicare brand which is well-known, reputable and produces effective results. Training in chemical skin peels is the first step for many beauty therapists to become aestheticians. 8 types of chemical peels are covered in this training course, providing you with the knowledge and skills to help clients with a wide range of skin concerns. The course offers hands-on practical training in a small group setting, allowing for personalised instruction and support from the instructor. The course covers a comprehensive curriculum, including the theory behind chemical peels and their various types, as well as practical application techniques. Upon completion, participants will receive a certificate of achievement that demonstrates their newfound knowledge and skills. The use of the Clinicare brand in the training program ensures that participants are learning with products that are highly effective and widely recognised in the beauty industry. The combination of e-learning and practical training provides participants with a well-rounded educational experience, allowing them to build their knowledge and confidence in a convenient and flexible manner. Chemical skin peels are in high demand, making this training program a valuable investment for anyone looking to expand their skills and grow their business. The course is accredited by ABT & CPD, providing participants with the assurance that the training is of high quality and meets industry standards. Course Benefits Benefits for Students Expertise in Skin Rejuvenation: By completing this training course, you will gain in-depth knowledge of chemical skin peels and their application. You will learn various peel types, their effects on the skin, and how to select the appropriate peel for different skin concerns. This expertise will enable you to provide effective treatments and achieve remarkable results for your clients. Versatility in Treating Skin Concerns: Chemical skin peels can address a wide range of skin concerns, including acne, hyperpigmentation, fine lines, and uneven skin texture. By enrolling in this course, you will acquire the skills to tailor treatments to meet individual client needs, helping them achieve healthier, smoother, and more radiant skin. Advanced Techniques and Safety: Our training course focuses on the latest techniques and safety protocols in performing chemical skin peels. You will learn about skin assessment, pre-treatment preparation, peel application methods, post-treatment care, and potential complications. This knowledge will ensure the safety of your clients and enhance your professional credibility. Practical Hands-on Experience: Practical training is an essential component of our course. You will have the opportunity to practice chemical skin peel techniques on models under the guidance of experienced instructors. This hands-on experience will boost your confidence and proficiency in performing the treatments. Benefits for Clients Personalised Treatment Plans: With your comprehensive understanding of chemical skin peels, you will be able to assess clients' skin concerns and develop customised treatment plans. This tailored approach will address their specific needs, leading to more effective and satisfactory results. Improved Skin Texture and Appearance: Chemical skin peels can significantly improve skin texture, reduce hyperpigmentation, diminish acne scars, and minimise the appearance of fine lines and wrinkles. Your expertise in performing these treatments will help clients achieve smoother, clearer, and more youthful-looking skin. Confidence and Trust: Clients will have confidence in your abilities as a trained professional in chemical skin peels. Your knowledge of different peel types and their effects, along with your commitment to safety, will build trust and assurance in your clients, creating a positive treatment experience. Earning Potential Your earning potential can increase after completing the Chemical Skin Peels (ClinicCare) Training Course: Expanded Service Offerings: With expertise in chemical skin peels, you can expand your service menu and offer a popular and in-demand treatment. This diversification can attract new clients and increase your earning potential. Client Retention and Referrals: Satisfied clients who experience positive results from chemical skin peels are more likely to become repeat customers. Additionally, they may refer friends, family, and colleagues to your practice, further growing your client base and increasing your revenue. Professional Advancement: By enhancing your skills and knowledge in chemical skin peels, you position yourself as a knowledgeable and sought-after aesthetics professional. This can lead to opportunities for career advancement, such as working in prestigious clinics, and spas, or establishing your own practice, which can contribute to higher earning potential. Frequently Asked Questions Is this training course suitable for beginners or those with prior experience? Our Chemical Skin Peels (ClinicCare) Training Course is designed for both beginners and experienced professionals in the aesthetics industry. Whether you are just starting your career or looking to enhance your skills, this course will provide you with the necessary knowledge and techniques. What will I learn in this training course? In this course, you will learn about different types of chemical skin peels, their indications, and the process of performing the treatment. You will gain a comprehensive understanding of skin anatomy, product selection, client assessment, treatment planning, application techniques, and post-treatment care. Will I receive hands-on training during the course? Yes, hands-on training is an integral part of our Chemical Skin Peels (ClinicCare) Training Course. You will have the opportunity to practice the techniques on models under the guidance and supervision of our experienced instructors. This practical experience will help you develop confidence and proficiency in performing chemical skin peels. What products or brands will be used in the training course? Our training course focuses on ClinicCare chemical skin peels. ClinicCare is a renowned brand known for its high-quality and effective skincare products. You will learn about their specific range of peels and gain hands-on experience in working with these products. Will I receive a certification upon completion of the course? Yes, upon successfully completing our Chemical Skin Peels (ClinicCare) Training Course, you will receive a certification of completion. This certification validates your training and demonstrates your competence in performing chemical skin peels using ClinicCare products. Are there any post-training support or resources available? Yes, we provide post-training support to our students. Our instructors are available to answer any questions or provide guidance even after you complete the course. Additionally, you will have access to resources and materials that can further enhance your knowledge and skills in chemical skin peels. Can I incorporate chemical skin peels into my existing practice? Absolutely! Chemical skin peels are a popular and effective treatment for various skin concerns. Upon completing the course, you will be equipped with the skills to incorporate chemical skin peels into your existing practice or start offering this service to your clients.

The Level 1 Award in Construction Health & Safety is required by individuals who are looking to become eligible for the Green CSCS Card. A CSCS Card is required in order to access many construction sites, carry out basic duties and build relevant experience to enable them to progress their career onto the next stage allowing them to progress to a level 2 or 3 Qualification. This Level 1 Award will provide the basic knowledge and understanding of health and safety principles and procedures and delivers a comprehensive and technical overview in relation to many construction relevant topics that are operatives require in order to operate safely within the Construction sector. Topics covered include Risk Assessment, Manual Handling, Working at Heights, Moving Vehicles, Dust, Hazardous Substances, Asbestos, Welfare, Personal Hygiene, Fire, Work Equipment, Electricity, Underground Services, PPE, Mandatory signage and more!!!!! Candidates can undertake this qualification in a classroom based delivery followed by the CSCS test within a single day. The administration and photographs are included and the CSCS card is usually received within 5 to 10 days. The one day course can be delivered in any client venue or at various locations around the UK.

Become a professional in the Telecomms industry with our EUSR SHEA Telecommunications Card Training Overview Our Energy Utilities Skills Register Safety Health Environmental Awareness EUSR SHEA Telecommunications Card Training is designed for professionals working in telecommunication-related industries, such as Telephone Exchanges, on the network, customer properties and more. The course equips participants with essential knowledge and skills to ensure safe and environmentally responsible practices on work sites near telecommunication environments. Upon completion, you’ll receive the coveted EUSR SHEA Telecommunications Card.