17809 Courses delivered Online

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

Learn the art of effective email communication and how to write emails that grab attention, convey your message clearly, and get the desired response. With modules covering the fundamentals of writing effective emails, managing your inbox, writing styles and tone, and more, you'll gain the skills you need to succeed in today's fast-paced business world. The world of business is constantly evolving, and with it comes a growing demand for effective communication. In today's digital age, email is the go-to form of communication in the business world, with over 306 billion emails sent and received every day. As a result, there are numerous opportunities available in the field of email writing. Learning Outcomes: Understand the principles of effective email communication Learn to write clear, concise, and compelling emails Develop strategies for managing your inbox and staying organised Discover different writing styles and how to adapt your tone to different situations Learn tips and tricks for writing effective emails Understand the importance of exercising caution when sending emails In today's digital age, email is the go-to form of communication in the business world. However, with so many emails flooding our inboxes, it can be challenging to stand out from the crowd. That's where our Email Writing course comes in. Our course covers all the essential aspects of effective email writing, from understanding the fundamentals of email communication to developing strategies for managing your inbox and staying organised. Through a series of modules, you'll learn the art of crafting clear, concise, and compelling emails that get results. You'll explore different writing styles and tone, discover tips and tricks for writing effective emails, and understand the importance of exercising caution when sending emails. Whether you're a business professional looking to improve your communication skills or someone looking to enter the recruitment field, our Email Writing course is for you. So, enrol today and take the first step towards mastering the art of effective email communication. Certification Upon completion of the course, learners can obtain a certificate as proof of their achievement. You can receive a £4.99 PDF Certificate sent via email, a £9.99 Printed Hardcopy Certificate for delivery in the UK, or a £19.99 Printed Hardcopy Certificate for international delivery. Each option depends on individual preferences and locations. CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Business professionals looking to improve their email writing skills Individuals looking to enter the recruitment field Anyone who wants to improve their communication skills Students who want to enhance their writing skills Career path Recruitment Consultant: £22,000 - £45,000 HR Manager: £25,000 - £75,000 Marketing Manager: £25,000 - £70,000 Sales Executive: £18,000 - £40,000 Customer Service Representative: £16,000 - £28,000 Executive Assistant: £20,000 - £45,000

Understand why it is difficult for us to accept changes when they occur - both in our personal and professional lives. Outline the emotional stages of the change curve which maps out distinct stages all individuals go through after a change, and learn to utilise a range of strategies to cope with changes.

Understand what is meant by the term mental health and the factors that can influence it. Know how to take care of your mental health, actively manage illness, and where to find additional help should you need it.

An indepth online course for developing 3 simple garment blocks: a skirt; a dartless bodice with sleeve and a dartless dress, used to create easy fitting garments of your own design.

In this competitive job market, you need to have some specific skills and knowledge to start your career and establish your position. This Poetry Writing Course will help you understand the current demands, trends and skills in the sector. The course will provide you with the essential skills you need to boost your career growth in no time. The Poetry Writing Course will give you clear insight and understanding about your roles and responsibilities, job perspective and future opportunities in this field. You will be familiarised with various actionable techniques, career mindset, regulations and how to work efficiently. This course is designed to provide an introduction to Poetry Writing Course and offers an excellent way to gain the vital skills and confidence to work toward a successful career. It also provides access to proven educational knowledge about the subject and will support those wanting to attain personal goals in this area. Learning Objectives Learn the fundamental skills you require to be an expert Explore different techniques used by professionals Find out the relevant job skills & knowledge to excel in this profession Get a clear understanding of the job market and current demand Update your skills and fill any knowledge gap to compete in the relevant industry CPD accreditation for proof of acquired skills and knowledge Who is this Course for? Whether you are a beginner or an existing practitioner, our CPD accredited Poetry Writing Course is perfect for you to gain extensive knowledge about different aspects of the relevant industry to hone your skill further. It is also great for working professionals who have acquired practical experience but require theoretical knowledge with a credential to support their skill, as we offer CPD accredited certification to boost up your resume and promotion prospects. Entry Requirement Anyone interested in learning more about this subject should take this Poetry Writing Course. This course will help you grasp the basic concepts as well as develop a thorough understanding of the subject. The course is open to students from any academic background, as there is no prerequisites to enrol on this course. The course materials are accessible from an internet enabled device at anytime of the day. CPD Certificate from Course Gate At the successful completion of the course, you can obtain your CPD certificate from us. You can order the PDF certificate for £9 and the hard copy for £15. Also, you can order both PDF and hardcopy certificates for £22. Career path The Poetry Writing Course will help you to enhance your knowledge and skill in this sector. After accomplishing this course, you will enrich and improve yourself and brighten up your career in the relevant job market. Course Curriculum Module 01: Introduction to Poetry Writing Introduction to Poetry Writing 00:18:00 Module 02: Reading Poetry Reading Poetry 00:21:00 Module 03: Beginning The Journey Beginning The Journey 00:15:00 Module 04: Important Details of Poetry Important Details of Poetry 00:25:00 Module 05: Poetic Language Poetic Language 00:18:00 Module 06: The Sound of Poetry The Sound of Poetry 00:24:00 Module 07: The Poet's Craft The Poet's Craft 00:14:00 Module 08: Open-Form and Closed-Form Poetry Open-Form and Closed-Form Poetry 00:22:00 Module 09: Traditional Forms of Verse Traditional Forms of Verse 00:21:00 Module 10: Vision and Revision Vision and Revision 00:19:00 Module 11: Getting Published Getting Published 00:20:00 Certificate and Transcript Order Your Certificates or Transcripts 00:00:00

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

This course comes bundled with basic to advanced level knowledge on Spring and Spring Boot with 200+ questions and answers. With REST API, JPA, Hibernate, and Spring Data JPA, you have the upper hand in your interviews for sure.

Description: To work in an office properly, you need to achieve some basic etiquette and communication skills along with your department related skill. Throughout the course, you will know all the essential tips and techniques for maintaining an excellent workforce in your office environment. Like other bundled video course, the present course is divided into several sections and sub-sections. The first section, Introduction to HR concepts, discusses the fundamental HR terms including the employee recruitment, training and managing conflict while the second part Communication Essential describes the proper format of communication. Communication varies based on your purpose. In the Communication course, you will be introduced to business communication, written communication, verbal and non-verbal communication, etc. Then the Professionalism in the Office Skills teaches you the strategies for increasing your professional image. On the other hand, you will know the business etiquette and manner in the Business Etiquette and Professionalism section. Next, the part Thinking Critically helps you to consider any situation critically so that you can take the right decision at the right time. After that, Time Management section guides you to manage your time efficiently. Finally, you will understand the present condition and market position of an organisation to decide the further step for your organisation in The Strategic Planning video lessons. In short, after completing the course, you will learn the essential etiquette for organising a competent workforce. Assessment: At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? Workplace Essentials Training - Complete Video Course is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our Workplace Essentials Training - Complete Video Course is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Human Resources Assistant Introduction Human Resources Assistant FREE 00:10:00 Potential Careers 00:05:00 Attracting and Retaining Employees HRM Overview 00:13:00 Forecasting Demand 00:10:00 Cultural Diversity 00:11:00 Diversity Survey 00:09:00 Recruiting, Selection, and Orientation Job Analysis 00:10:00 Application 00:20:00 Bad Resume 00:05:00 Good Resume 00:12:00 Cover Letter 00:10:00 Selection 00:11:00 Form I-9 00:17:00 Form W-9 00:07:00 Form W-4 00:10:00 Form 1095-B 00:07:00 Compensation and Benefits 00:17:00 Training and Development Personal and Professional Development 00:14:00 Training Evaluation Form 00:12:00 Performance Appraisal Performance Appraisal 00:19:00 Appraisal 00:14:00 Legal Environment of HRM National Labor Relations Act 00:12:00 Labor-Management Relations Act 00:14:00 Occupational Safety and Health Act 00:13:00 Motivating Employees Motivation 00:17:00 Physiological Needs 00:16:00 Motivation-Hygiene Theory 00:12:00 Firm Characteristics 00:22:00 Contemporary Motivation Theory Weakness of Maslow and Herzberg's Theories 00:18:00 Expectancy Theory 00:13:00 Motivation Techniques Management by Objectives 00:17:00 Behavior Modification 00:19:00 Telecommuting 00:20:00 Teams and Teamwork What is a Team? 00:09:00 Stages of Development 00:06:00 Team Cohesiveness 00:09:00 Business Communication Identifying Basic Communication Techniques FREE 00:09:00 Formal and Informal Communication 00:02:00 Verbal and Non-verbal Communication Describing Verbal and Non-verbal Communication 00:04:00 Understanding Body Language 00:05:00 Making Effective Presentations 00:10:00 Fundamentals of Productive Meetings 00:08:00 Written Communication Written Communication 00:13:00 Electronic Communication Electronic Communication 00:19:00 Communicating with Graphics Creating Graphics for Business Communication 00:04:00 Communicating Static Information 00:03:00 Communicating Dynamic Information 00:03:00 Effectively Working for Your Boss Representing Your Boss 00:06:00 Communicating Your Boss's Decisions 00:03:00 Supporting Your Boss and Colleagues 00:04:00 Building a Partnership with Your Boss 00:13:00 Positioning Yourself as a Professional Attitude in the Workplace FREE 00:10:00 Professionalism 00:03:00 Making Changes through Personal Accountability 00:07:00 Enhancing Your Professional Image Your Image as a Whole 00:05:00 Becoming More Marketable 00:03:00 Communicating and Image 00:08:00 Expanding Your Skills Time Management 00:14:00 Project Management Techniques 00:03:00 Making Decisions 00:06:00 Communicating for Results Keys to Effective Communication 00:26:00 Presentations 00:09:00 Meetings 00:07:00 Building Relationships and Networks Work and Your Personality 00:05:00 Networking 00:07:00 Roles in the Office MRP 00:18:00 Principles of Professional Behavior What is Etiquette? FREE 00:05:00 Always Be Your Best 00:12:00 Always Be Your Best When Meeting and Greeting 00:06:00 Interview Etiquette Types of Interviews 00:07:00 Planning for the Interview 00:07:00 During the Interview 00:13:00 Planning and Attending Business Meetings Types of Meetings 00:06:00 Planning Conference Call Meetings 00:10:00 Meal Meetings 00:09:00 Electronic Etiquette Voicemail 00:08:00 Instant Messaging 00:09:00 Multicultural Etiquette Five Steps to Dealing with Diversity 00:13:00 Facing New Problems The Critical Thinking Process FREE 00:24:00 Group Dynamics 00:17:00 Critical Thinking Methods 00:04:00 Problem Solving Approaches 00:09:00 Establishing the Problem A Identify the Problem 00:08:00 Exploring the Problem 00:06:00 Discovering the Solution Assembling Potential Ideas 00:09:00 Determining the Best Solution 00:04:00 Evaluating Cost and Benefit 00:05:00 Building Your Case 00:02:00 Accepting a Decision Accepting a Decision 00:13:00 Identifying Goals Identifying Goals FREE 00:10:00 Effective Energy Distribution Energy Distribution 00:09:00 Time Logs 00:11:00 Working with Your Personal Style Personal World View 00:10:00 Strengths 00:09:00 Building Your Toolbox A Building Your Toolbox 00:10:00 Establishing Your Action Plan Establishing Your Action Plan 00:11:00 Preparing for the Strategic Planning Process Preparing for the Strategic Planning Process FREE 00:16:00 Establish a Committee 00:06:00 Gather Operational Data 00:13:00 Initiating the Strategic Planning Process Develop a Mission Statement 00:12:00 Develop a Vision Statement 00:06:00 Assess Internal and External Environments 00:12:00 Performing SWOT Analysis 00:08:00 Developing the Strategic Plan Prioritize What the Strategic Plan Will Address 00:03:00 Set Goals and Objective 00:07:00 Develop Strategy for Achieving Goals 00:02:00 Draft the Strategic Plan 00:09:00 Executing the Plan Assign Responsibility and Authority 00:10:00 Establish a Monitoring System 00:06:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

MASTERCLASS 8 CPD POINTS 1 DAY INTENSIVE COURSE  ONLINE or IN-CLINIC NOTE! After booking we will contact you for scheduling the exact course date! Courses dates are subject to change due to mentors availability. We will inform you via email if a date becomes available! CLINICAL PRP • Sports medicine • Traumatology • Ophthalmic • Burn trauma • Wound healing –diabetic foot • Skin grafting • Dentistry-sinus lift • Tooth implants.   PRP theory & equipment: Training Online Theory will enable you to understand: Anatomy Vascular Supply, Contraindications Patient consultation Complications Management Post treatment advice Dealing with equipment A certification of training will be provided upon completion of the course. Aesthetic PRP • Skin rejuvenation • Hair restoration • Fat grafting in combination PRP • Post laser •Acne & Rosacea •Acne scar •TissueVolumisation alternative of HA fillers •Aesthetic gynecology /urology.   Plathelet Rich Plasma We will cover pertinent information including mechanism of action, safety and efficacy issues, management and treatment of complications, dilution guidelines, and more. Hands on practical session – skin rejuvenation and hair loss Extraction, Preparation and Dosage Management Injection techniques – face, neck and head (hair loss); also the use of cannula Upon successful completion of the course, you will receive a certificate and title of PRP Certified Practitioner.   MASTER CLASS PRP & PRF During the course we are providing . Taking blood and how to use a Centrifuge . PRP injecting techniques in face neck and décolletage hands. PRP Microneedling using a DERMAPEN. Combination treatment PRP with Mesotherapy. MECHANISM OF ACTION Platelets + Leucocytes form 3D mesh release of GF Chemo attraction and migration of macrophages and stem cells Stem cells proliferates by mitosis Stem cells undergo differentiation process BENEFIT FROM PRP TREATMENT & THERAPYExperience the advantages of PRP treatment and therapy, utilizing autologous blood with natural growth factors for disease-free and hypoallergenic benefits. Boost wound healing by regulating mitosis, proliferation, and differentiation, enhancing tissue with collagen, elastin, and hyaluronic acid. Benefit from improved tissue oxygenation, nutrition flow, and support for procedures like hair transplants, fat transfers, and skin grafts.PRP works effectively in skin rejuvenation, facial resurfacing, microneedling, and combines well with HA, PDO threads, skin boosters, peeling, or CO2 lasers. It also proves beneficial for hair restoration, showing positive results in various protocols for Androgenic alopecia and age-related hair loss.PRP where works .Skin rejuvenation-facial resurfacing.application-injection alone. Microneedling Combination with HA,Combination with PDO threads,Skin boosters , peeling or CO2 lasers Hair restoration, Multiple protocols with positive results Evidence for improvement of: Androgenic alopecia-male and females, “spot hair lost” Improvement of age related hair loss. You need to be medically qualified as a doctor, dentist, nurse, pharmacist or paramedic with full governing body registration and have completed a Foundation Filler Course and to have administered a number of cases. Additional information ATTENDANCE ONLINE (Theory), IN CLINIC (Practice) COURSE LEVEL EXPERT | Masterclass Course