• Professional Development
  • Medicine & Nursing
  • Arts & Crafts
  • Health & Wellbeing
  • Personal Development

45431 PE courses

Fox Eye & Pixie Lift Thread Training Course

By Cosmetic College

This treatment is an innovative technique which uses dissolvable sutures to lift and elongate the eye to create a more almond shape whilst lifting the brow tail to create a feminine effect. This non-invasive procedure works by inserting a blunt cannula and a dissolvable thread discreetly under the surface of the skin. The thread provides a source of tension which will gradually attach itself to the tissue and stimulate the body's collagen production. Additionally included in this course you will learn how to provide pixie nose lift treatments for your clients. This technique is popular as it's the most cost-effective and offers a great option for those wanting to build up the effect of the lift over time. Course Entry Requirements: This course is suitable for those with or without a medical background. It is designed to provide the student with the ability to seek employment or start their own business upon qualification. At a minimum, students will be required to be qualified for at least one of the following: Medically qualified as a nurse, doctor or dentist with current registration with the NMC, GMC or GDC. NVQ Level 3 in Beauty Therapy, ITEC or HND 12 months of needling experience 6 Months of micropigmentation experience and Anatomy & Physiology Level 3 If your qualification does not appear above, we offer a fast track access course for those completely new to the industry.  Course agenda Background of PDO Threads Health & safety In-depth anatomy and physiology Emergency protocols Product knowledge Sourcing clinical oversight (Prescriber) Complications prevention Client suitability Equipment use Needle stick injury protocol Pain management with the use of injectable anaesthetic Adverse effects Complications management Emergency Protocols Anaphylaxis Aftercare Consent forms Consultation process Client selection Live demonstrations Live model experience Recommended treatment charges Insurance Legalities Advance your training with our complete PDO Threads training package Take your training to the next level by enrolling on our complete PDO Thread training package. Included within this package: PDO COG Threads PDO Mono Threads Fox Eye Thread Lifts Pixie Nose Tip Lifts Check out the package here Course Benefits Student Benefits Advanced Skill Development: This course provides students with specialised training in the techniques of thread lifting specifically for creating the fox eye and pixie lift effects. It allows students to expand their skill set and offer unique and in-demand treatments to their clients. Increased Client Satisfaction: With the growing popularity of the fox eye and pixie lift trends, clients are actively seeking practitioners who can deliver these desired outcomes. By mastering these techniques, students can meet their client's expectations and provide them with the desired eye and facial rejuvenation results. Higher Earning Potential: As students acquire specialised skills in the fox eye and pixie lift thread techniques, they can command higher fees for these advanced treatments. The ability to offer unique and sought-after procedures often translates into increased earning potential for practitioners. Career Advancement Opportunities: With expertise in the fox eye and pixie lift thread techniques, students may have more opportunities for career advancement. Client Benefits Expertise in Trending Procedures: Clients can be confident that their practitioner is trained and knowledgeable in the specific techniques required to achieve the fox eye and pixie lift effects. This expertise increases the likelihood of achieving desired results. Personalised Treatment Plans: Practitioners who have completed this training can provide clients with tailored treatment plans based on their unique facial features and desired outcomes. This customised approach helps ensure client satisfaction. Safe and Effective Procedures: Clients can trust that their practitioner is skilled in performing thread lifting procedures safely and effectively, minimising the risk of complications and ensuring a positive treatment experience. Natural-looking Results: The fox eye and pixie lift thread techniques aim to enhance natural beauty and create subtle yet noticeable improvements. Clients can expect results that look natural, youthful, and in harmony with their overall facial aesthetics. Earning Potential The earning potential and salary expectation for practitioners who have completed the Fox Eye & Pixie Lift Thread Training Course can vary based on several factors. These factors include the practitioner's location, years of experience, client base, and the pricing structure of their services. By acquiring the skills and expertise in performing the fox eye and pixie lift thread techniques, practitioners can attract clients who are specifically interested in these procedures. This specialisation and ability to meet the growing demand for these treatments can contribute to higher earning potential.

Fox Eye & Pixie Lift Thread Training Course
Delivered In-PersonFlexible Dates
£550

Flex Flexperts Machine Polishing Course

5.0(2)

By Uk Detailing Academy

As the official Flex Polisher training provider for the UK, UK Detailing Academy has worked with Flex to develop the Flexxperts course for professional detailers wanting to get the best from the Flex range of polishing machines and accessories, improve their technique, and machine polish the Flex way. Also run as a group several times a year in addition to the One to One option. For more information on the course itself, please see below. Please select from the available dates below, and then select your T-Shirt size and whether you would like to preorder a discounted machine for collection on the day at your included and exclusive Flexxpert discount rate. As part of Flex's commitment to enhanced development for users of our professional tool range, Flex UK have come together with the UK Detailing Academy to deliver the Flexperts Approved program. During this Flex Machine Polishing course, we aim to show delegates the full range that Flex tools have to offer, and at the same time deliver practical usage instructions for each tool to ensure you are getting the optimum performance and delivering the high-end quality Flex is known for worldwide. The Flexpert certification is designed to not only introduce you to the full range of Flex machine polishers and their use. We want you to gain the full benefit of our wealth of history and experience in the detailing market. During this session, you will learn more about pads, and the compound technology which accompanies them. Covering best practices and techniques will help you achieve immense results efficiently, and demonstrate the proficiency required to be awarded the Flexpert Approved Detailing Partner accreditation. The award represents an industry badge of your commitment to our high standards and knowledge which you can display to your clients, demonstrating that your business and brand's professional development and standards are associated with the world's premium polisher manufacturer. We will be covering a huge variety of detailing essential topics, starting with talking about Flex as a company and our shared ethos, before moving on to theory and demonstration of the tools, hopefully furthering existing knowledge and ensuring a consistent standard for all who work under the Flex badge. Course Length 1 Day (0930-1600) Group Size One-to-One Location UK Detailing Academy, 2 Purlieus Barn, Ewen, Cirencester, GL7 6BY Experience / Qualification Car Care Professionals Only Refreshments or Lunch Refreshments included

Flex Flexperts Machine Polishing Course
Delivered In-PersonFlexible Dates
£495

Enthusiast Detailing 201 - Individual

5.0(2)

By Uk Detailing Academy

Detailing day for the experienced hyper-enthusiast. Our 201 Enthusiast detailing day was created for the hyper enthusiast who wants to correct and enhance their own vehicle, rather than just care for it. If you've attended our 101 Enthusiast, you're all covered skills-wise for the prior knowledge element, but for all others to benefit from this event you will need a solid knowledge of preparation work and wash procedure, as this is mostly focused on what comes after - namely paint correction. This is an intensive one-day group course, and there is time allotted at the end of the session to inspect your own vehicles if you need advice on particular issues. Our 201 Enthusiast detailing day was created for the hyper-enthusiast who wants to correct and enhance their own vehicle, rather than just care for it. If you've attended our 101 Enthusiast, you're all covered skills-wise for the prior knowledge element, but for all others to benefit from this event you will need a solid knowledge of preparation work and wash procedure, as this is mostly focused on what comes after - namely paint correction. During the day we will be covering: Compound types and chemistry. Paint types and how to approach them. Pre-work decon wash, including clay and clay pads, decon pros/cons. Masking and surface protection tips. Lighting and inspection technique. Machine work, including Dual Action and Forced Rotation polishers, to correct and enhance the paint surface. Deeper defect removal, scratch hand sanding. Coatings, including ceramic and polymer, and their application. The day concludes with a Q&A session with a walk around your vehicles to advise on any issues. This is quite an intense enthusiast detailing day, as we are trying to fit so much in, so we will be running from 9.30 am until 16:00 with a break for lunch. You will have hands-on experience all day and will be working your way through all steps of a full correction, it will then be up to you to build on the knowledge you have gained by practising on your own vehicle, with ongoing support if needed. The course is run from our fully equipped studio in the heart of Gloucestershire, with easy access to the M4/M5, and under an hour and a half to the M25. Course Length 1 Day (0930-1600) Group Size One-to-One, Up to 6 people Location UK Detailing Academy, 2 Purlieus Barn, Ewen, Cirencester, GL7 6BY Refreshments or Lunch Refreshments included Experience / Qualification 101 Competent, Open to all

Enthusiast Detailing 201 - Individual
Delivered In-PersonFlexible Dates
£495

Helicopter Commercial Pilot's Licence

4.8(24)

By Heliflight

The UK CAA Commercial Pilot's Licence (CPL(H)) If you want to fly professionally as a career, you will need a Commercial Pilot’s Licence (CPL (H)). This is the standard professional licence which can only be taken at Approved Flight Training Organisations like Heliflight.  Heliflight offers a modular flight training approach to obtaining a CPL (H) that helps you to train at your own pace and manage your finances. Before you start training for your CPL, you will need to hold a PPL (H), issued in accordance with Annex 1 to the Chicago convention and have logged 155 hours of helicopter flying including 50 hours PIC of which 10 hours must be cross-country. You will also be studying a range of theory in greater depth than for your PPL. This study can be done at home in your own time on a distance learning course. Heliflight will guide on where best to complete this ground school. There is also a compulsory ground school part of the course that lasts three weeks in total. This will also give you the opportunity to make friends with fellow pilots as you work towards passing your theoretical exams. These exams must be passed prior to taking your Skills test, but Heliflight recommends that they are passed prior to commencing your flight training. The theoretical knowledge exams cover the following subjects: - • Air law • Meteorology • Aircraft general knowledge airframe/systems/powerplant • General navigation • Aircraft general knowledge - instrumentation • Radio navigation • Mass and balance • Operational procedures • Performance • Principles of flight • Flight planning and monitoring • Visual flight rules (VFR) communications • Human performance The flight training will comprise of at least 30 hours of dual flight instruction, including 10 hours of instrument instruction and 20 hours of visual flight instruction. Your commercial flying course will hone the flying skills you developed on your PPL and build upon them. You’ll become adept at emergency procedures including practicing landing a helicopter without power. You will also need to complete at least 5 hours of night flight instruction, comprising 3 hours of dual instruction, which will include at least 1 hour of cross-country navigation and 5 solo night circuits, each including a take-off and landing.  You will not need to complete the additional night flight instruction if you already hold a night rating (helicopter). At the end of training, and when all requirements for licence issue have been met, you will need to take a skill test with an examiner. If you would like further information about the CPL (H) course and the other training available from Heliflight, please contact us. We’ll be happy to help. For current prices please call us.

Helicopter Commercial Pilot's Licence
Delivered In-Person in CheltenhamFlexible Dates
£360 to £510

Character Animation in 3ds Max Training

By London Design Training Courses

Why Choose Character Animation in 3ds Max Training Course? Click here for more info. Top character animation course in 3ds Max, this course provides an accessible learning experience. Learning character animation enables you to create your own short films. It's not just a means of income; it evolves into a passion.  Duration: 20 hrs Method: 1-on-1, Personalized attention. Schedule: Tailor your own hours of your choice, available from Monday to Saturday between 9 am and 7 pm. Enroll in our exclusive "Character Animation Fundamentals in 3ds Max" course at London Design Training, guided by experienced tutors Sitwat Ali, Qasim Ali, and Jess. Gain in-depth insights into animating 3D characters, covering essential techniques like character rigging, pose creation, and seamless pose-to-pose animation. 3ds Max Character Animation Course Duration: 20 hours Course Overview: Master the art of character animation in 3ds Max with our comprehensive course. Ideal for beginners and those with some 3D modeling and animation experience, this course covers everything you need to know to bring characters to life. Course Outline: Introduction to Character Animation Explore animation principles Get familiar with 3ds Max animation tools Learn to create character rigs and manage the timeline Basic Animation Principles Understand keyframes and animation cycles Apply the 12 principles of animation Work with the graph editor and ease-in/out techniques Advanced Animation Techniques Utilize the reaction manager for complex animations Master non-linear animation methods Animate with inverse kinematics, custom controllers, expressions, and scripts Creating Characters Craft a character model with proper topology Create UV maps and apply textures Prepare characters for rigging Facial Animation Learn facial animation principles Create blend shapes and morph targets Master lip syncing techniques Body Animation Animate walk cycles and character motion Achieve believable character poses Implement character physics Advanced Character Animation Work with motion capture data Use CAT and Biped tools Understand motion blur and create special effects Render and output animations Character Animation Projects Bring all skills together in practical projects Create basic and complex character animations Course Requirements: Computer with 3ds Max installed Basic computer operations knowledge Passion for character animation Course Goals: Upon completion, you'll have a thorough grasp of character animation in 3ds Max, capable of creating realistic and sophisticated character animations using advanced techniques. You'll be equipped with the skills to continue honing your character animation abilities independently.

Character Animation in 3ds Max Training
Delivered in London or OnlineFlexible Dates
£660

Microsoft Excel Advanced - In-company

By Microsoft Office Training

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 from our growing 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. Our competitive rates start from £550.00 per day of training Tailored 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. 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

Microsoft Excel Advanced - In-company
Delivered in London or UK Wide or OnlineFlexible Dates
£650

Advanced Anti Wrinkle Training

By Cosmetic College

Advanced Anti Wrinkle Injections Training is designed for healthcare professionals, including medical doctors, nurses, dermatologists, and aesthetic practitioners, who want to enhance their expertise in administering anti-wrinkle injections. This specialised course provides advanced training to meet the growing demand for high-quality anti-wrinkle treatments. Course Entry Requirements: This course is suitable for learners who have completed the foundation anti-wrinkle course. This training course requires you to be an active practising aesthetic injector with a minimum of six months experience with a demonstrable portfolio of client treatments. Course Pre-Study/Practical & Length: 20 hours of pre-study E-learning and 1 practical day Course Agenda: Theory Mimetic muscles Muscle names, groups and types Branching nerves of the face Aftercare Managing expectations Client consultation protocols (medical history & client consent) Hygiene, sharps disposal and legal aspects Practical Injection techniques Live demonstrations Practical Live Models Treatment Areas Bunny Lines Lip Lines Marionettes Nasal Tip Lift Gummy Smile Flip Lip Chin Dimpling Masseters Neckbands Bruxism Course Benefits Benefits for Students Advanced Techniques and Knowledge: Our course provides students with advanced training in anti-wrinkle injections. You will learn the latest techniques, industry trends, and cutting-edge advancements in the field. This knowledge will set you apart as a skilled practitioner and allow you to offer a wider range of treatments to your clients. Hands-on Experience: We prioritise practical learning by offering extensive hands-on training opportunities. Under the guidance of experienced instructors, you will gain valuable experience in administering anti-wrinkle injections. This practical training will enhance your confidence and proficiency, preparing you to deliver excellent results. Professional Development: By enrolling in our advanced course, you are investing in your professional development. You will expand your skill set, stay updated with industry standards, and increase your expertise in anti-wrinkle injections. This will strengthen your professional reputation and open doors to new career opportunities. Benefits for Clients Advanced Treatment Options: By enrolling in our Advanced Anti Wrinkle Injections Training Course, you will be able to offer a broader range of advanced treatment options to your clients. You will learn techniques to address specific concerns, target different areas of the face, and achieve natural-looking results. Clients can benefit from customised treatments tailored to their unique needs. Enhanced Safety and Effectiveness: As a trained professional, you will understand the importance of safety and efficacy in anti-wrinkle injections. Our course emphasises best practices, proper injection techniques, and comprehensive patient assessment. By prioritising safety and delivering effective treatments, you can provide clients with peace of mind and exceptional results. Trust and Confidence: Clients seek skilled practitioners who can deliver the desired outcomes with anti-wrinkle injections. By completing our advanced training course, you will acquire the knowledge and expertise to meet client expectations. As a result, clients will have trust and confidence in your abilities, leading to a positive reputation and potential referrals. Earning Potential By expanding your skill set and offering advanced anti-wrinkle injection treatments, you can significantly increase your earning potential. Advanced procedures often command higher prices, and as a skilled practitioner, you can attract a larger clientele. Additionally, satisfied clients are more likely to become repeat customers and recommend your services to others, further enhancing your earning potential. Enrolling in our Advanced Anti Wrinkle Injections Training Course at Cosmetic College will not only benefit you as a student but also provide valuable advantages for your clients and potential earning potential in the field of aesthetics. Start your journey towards professional excellence and financial success by enrolling today. Frequently Asked Questions Is this course suitable for beginners or those with prior experience? Our Advanced Anti Wrinkle Injections Training Course is designed for healthcare professionals and aesthetics practitioners with prior experience in administering basic anti-wrinkle injections. It is not suitable for complete beginners. We recommend having a foundation in basic injection techniques before enrolling in this advanced course. What qualifications or prerequisites do I need to enrol in the advanced course? To enrol in our Advanced Anti Wrinkle Injections Training Course, you should have completed a basic anti-wrinkle injections course and have experience in administering basic injections. Additionally, a background in healthcare or aesthetics can be beneficial. Please contact our admissions team for a comprehensive evaluation of your qualifications. Will I receive a certification upon completion? Yes, upon successfully completing our advanced training course, you will receive a certification in Advanced Anti Wrinkle Injections. This certification acknowledges your advanced skills and expertise in administering anti-wrinkle injections, which can enhance your professional reputation and career prospects. What topics are covered in the course curriculum? Our course curriculum covers advanced topics related to anti-wrinkle injections, such as advanced injection techniques, combination treatments, handling complications, managing patient expectations, and creating personalised treatment plans. The curriculum is designed to deepen your understanding and mastery of advanced techniques in the field. Are there any hands-on training opportunities? Absolutely! Our Advanced Anti Wrinkle Injections Training Course includes hands-on training sessions. Under the guidance of experienced instructors, you will have the opportunity to practice and refine your skills in administering advanced anti-wrinkle injections. This practical experience is crucial for your professional development. Will I have access to ongoing support after completing the course? Yes, we provide ongoing support to our students even after they complete the training course. Our instructors and support staff are available to answer any questions, provide guidance, and offer assistance as you navigate your career in advanced anti-wrinkle injections. We aim to support your continued growth and success. Are there financing options available for the course? We offer flexible payment options and financing plans to make our Advanced Anti Wrinkle Injections Training Course more accessible. Please reach out to our admissions team for detailed information on available payment options and financing plans.

Advanced Anti Wrinkle Training
Delivered In-PersonFlexible Dates
£550

Microsoft Excel Advanced (now with live online classes) One-to-One Training

By Microsoft Office Training

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

Microsoft Excel Advanced (now with live online classes) One-to-One Training
Delivered In-Person in LondonFlexible Dates
£650

18th Edition BS 7671

5.0(9)

By Optima Electrical Training

Even if you have completed a level 3 NVQ or a previous version of the wiring regulations, you still will have to prove you are conversant with the current standards. So therefore, keeping up to date with the latest wiring regulations satisfies these requirements. Although the BS 7671 can be a tricky book to navigate, our course has been designed in such a way as to ensure that you will have the knowledge to identify and find the topics covered in each of the relevant parts of the book. Further information can be found here: C&G 2382-22 BS7671 18th Edition — Optima Electrical Training (optima-ect.com)

18th Edition BS 7671
Delivered In-Person in London + 2 more or UK WideFlexible Dates
£495

Microsoft Word Intermediate - In-company (now with live online classes)

By Microsoft Office Training

Course Objectives At the end of this course you will be able to: Customise tables and charts Customise formatting with styles and themes Modify pictures in a document Create customised graphic elements Insert content using Quick Parts Control text flow Use templates to automate document creation Perform mail merges Use macros to automate common tasks '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 Excelent enviroment for training. Tahnk you. Jenny Price - ACER ' 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. Our competitive rates start from £550.00 per day of training Tailored 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. Working with Tables and Charts Sort Table Data Control Cell Layout Perform Calculations in a Table Create a Chart Customising Formats Using Styles and Themes Create and Modify Text Styles Create Custom List or Table Styles Apply Document Themes Using Images in a Document Resize an Image Adjust Image Appearance Integrate Pictures and Text Insert and Format Screenshots Use the Snipping tool Creating Custom Graphic Elements Create Text Boxes and Pull Quotes Draw Shapes Add WordArt and Other Text Effects Create Complex Illustrations with SmartArt Inserting Content Using Quick Parts Insert Building Blocks Create and Modify Building Blocks Insert Fields Using Quick Parts Controlling Text Flow Control Paragraph Flow Insert Section Breaks Insert Columns Link Text Boxes to Control Text Flow Using Templates Create a Document Using a Template Create a Template Using Mail Merge The Mail Merge Features Merge Envelopes and Labels Create a Data Source Using Word Using Macros Automate Tasks Using Macros Create a Macro Who is this course for? Who is this course for? This course is designed for users who to create or modify complex business documents as well as customised Word efficiency tools Requirements Requirements Preferably, delegates should have attended the Word Introduction course. 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 Certificates Certificates Certificate of completion Digital certificate - Included

Microsoft Word Intermediate - In-company (now with live online classes)
Delivered in London or UK Wide or OnlineFlexible Dates
£650