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

51136 Courses

SAP S4HANA Controlling Level 2

By Course Cloud

The comprehensive SAP S4HANA Controlling Level 2 has been designed by industry experts to provide learners with everything they need to enhance their skills and knowledge in their chosen area of study. Enrol on the SAP S4HANA Controlling Level 2 today, and learn from the very best the industry has to offer! This best selling SAP S4HANA Controlling Level 2 has been developed by industry professionals and has already been completed by hundreds of satisfied students. This in-depth SAP S4HANA Controlling Level 2 is suitable for anyone who wants to build their professional skill set and improve their expert knowledge. The SAP S4HANA Controlling Level 2 is CPD-accredited, so you can be confident you're completing a quality training course will boost your CV and enhance your career potential. The SAP S4HANA Controlling Level 2 is made up of several information-packed modules which break down each topic into bite-sized chunks to ensure you understand and retain everything you learn. After successfully completing the SAP S4HANA Controlling Level 2, you will be awarded a certificate of completion as proof of your new skills. If you are looking to pursue a new career and want to build your professional skills to excel in your chosen field, the certificate of completion from the SAP S4HANA Controlling Level 2 will help you stand out from the crowd. You can also validate your certification on our website. We know that you are busy and that time is precious, so we have designed the SAP S4HANA Controlling Level 2 to be completed at your own pace, whether that's part-time or full-time. Get full course access upon registration and access the course materials from anywhere in the world, at any time, from any internet-enabled device.  Our experienced tutors are here to support you through the entire learning process and answer any queries you may have via email.

SAP S4HANA Controlling Level 2
Delivered Online On Demand
£319

Motivation Skills

By OnlineCoursesLearning.com

Inspiration Skills Is it accurate to say that you are prepared to transform yourself to improve things? This course tells you the best way to turn into the individual you've for a long while been itching to be. What's the mystery? Inspiration. Do you experience difficulty getting roused? It very well may be hard to muster the nerve to complete things. Yet, inspiration is vital to carrying on with a gainful life. In this way, it's fundamental that we figure out how to get inspired and stay roused to complete what we need to. This course clarifies the rudiments of what you need to think about inspiration. We talk regarding why it very well may be hard to get roused, tips for expanding your inspiration and how to remain propelled. In the event that you're hoping to turn into a more inspired individual, this course is a positive development. Inspiration is a psychological distraction. Along these lines, the principal thing we do in this course is to take a gander at the sort of reasoning that obliterates inspiration. In the event that you don't comprehend why you experience difficulty getting spurred, it very well may be difficult to tell where to begin. When we comprehend where the difficulty lies, we can start to deal with the issue. In this course we go over the means that help individuals change their reasoning and at last, change their conduct and become more roused. The last advance is to make a big difference for yourself and not return to your old ways. This is canvassed in the last piece of the course. You Will Learn: What hinders inspiration and how to stop it Why you may battle with inspiration Instructions to start to propel yourself The most effective method to think emphatically and stay spurred Advantages of Taking This Course Persuade yourself to be a more beneficial individual Figure out how to think all the more emphatically Gain a superior demeanor throughout everyday life Become the individual you have for a long while been itching to be

Motivation Skills
Delivered Online On Demand
£50

Construction Safety and Project Management

4.5(3)

By Studyhub UK

Do you want to prepare for your dream job but strive hard to find the right courses? Then, stop worrying, for our strategically modified Construction Safety and Project Management bundle will keep you up to date with the relevant knowledge and most recent matters of this emerging field. So, invest your money and effort in our 33 course mega bundle that will exceed your expectations within your budget. The Construction Safety and Project Management related fields are thriving across the UK, and recruiters are hiring the most knowledgeable and proficient candidates. It's a demanding field with magnitudes of lucrative choices. If you need more guidance to specialise in this area and need help knowing where to start, then StudyHub proposes a preparatory bundle. This comprehensive Construction Safety and Project Management bundle will help you build a solid foundation to become a proficient worker in the sector. This Construction Safety and Project Management Bundle consists of the following 30 CPD Accredited Premium courses - Course 01:Construction Management and Procurement Course 02:Construction Industry Scheme (CIS) Course 03:Construction Project Management Level 4 Course 04:Construction Site Management Level 4 Course 05:Construction Cost Estimation Diploma Course 06:Construction Safety Course 07:Domestic Plumbing, Installations and Repair Diploma Course 08:Level 3 Heating, Ventilation & Air Conditioning (HVAC) Technician Course 09:Domestic Appliance Repairing Course Course 10:Functional Skills IT Course 11:Delegation Skills Course 12:Effective Communication Skills Course 13:Domestic Gas Engineer Course 14:Level 2 Domestic Gas Course Course 15:Oil and Gas Management Course 16:Domestic Gas Working Course Course 17:Gas Safety Course 18:Fire Safety | Online Course Course 19:Electrical Components And Circuits - Wiring & Busbars Course 20:Light Current Systems for Electrical Engineering Course 21:Electrical Machines for Electrical Engineering Course 22:Environmental Engineering Course 23:Sustainable Energy and Development Diploma Course 24:Environment Management Course 25:Power Electronics for Electrical Engineering Course 26:Engineering Management Course 27:Electric Circuits for Electrical Engineering Course 28:Trigonometry for Electrical Engineering Course 29:Electrical Technician Course 30:Electronic & Electrical Devices Maintenance 3 Extraordinary Career Oriented courses that will assist you in reimagining your thriving techniques- Course 01: Career Development Plan Fundamentals Course 02: CV Writing and Job Searching Course 03: Interview Skills: Ace the Interview Learning Outcome This tailor-made Construction Safety and Project Management bundle will allow you to- Uncover your skills and aptitudes to break new ground in the related fields Deep dive into the fundamental knowledge Acquire some hard and soft skills in this area Gain some transferable skills to elevate your performance Maintain good report with your clients and staff Gain necessary office skills and be tech savvy utilising relevant software Keep records of your work and make a report Know the regulations around this area Reinforce your career with specific knowledge of this field Know your legal and ethical responsibility as a professional in the related field This Construction Safety and Project Management Bundle resources were created with the help of industry experts, and all subject-related information is kept updated on a regular basis to avoid learners from falling behind on the latest developments. Certification After studying the complete training you will be able to take the assessment. After successfully passing the assessment you will be able to claim all courses pdf certificates and 1 hardcopy certificate for the Title Course completely free. Other Hard Copy certificates need to be ordered at an additional cost of •8. CPD 330 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Ambitious learners who want to strengthen their CV for their desired job should take advantage of the Construction Safety and Project Management bundle! This bundle is also ideal for professionals looking for career advancement. Requirements To participate in this course, all you need is - A smart device A secure internet connection And a keen interest in Construction Safety and Project Management Career path Upon completing this essential Bundle, you will discover a new world of endless possibilities. These courses will help you to get a cut above the rest and allow you to be more efficient in the relevant fields.

Construction Safety and Project Management
Delivered Online On Demand7 days
£279

SQL Querying Fundamentals - Part 1

By Nexus Human

Duration 1 Days 6 CPD hours This course is intended for Individuals with basic computer skills, familiar with concepts related to database structure and terminology, and who want to use SQL to query databases. Overview Upon successful completion of this course, students will be able to: - connect to the SQL Server database and execute a simple query. - include a search condition in a simple query. - use various functions to perform calculations on data. - organize data obtained from a query before it is displayed on-screen. - retrieve data from tables. - format an output, save a result, and generate a report. In this course, students will compose SQL queries to retrieve desired information from a database. 1 - Executing a Simple Query Connect to the SQL Database Query a Database Save a Query Modify a Query Execute a Saved Query 2 - Performing a Conditional Search Search Using a Simple Condition Compare Column Values Search Using Multiple Conditions Search for a Range of Values and Null Values Retrieve Data Based on Patterns 3 - Working with Functions Perform Date Calculations Calculate Data Using Aggregate Functions Manipulate String Values 4 - Organizing Data Sort Data Rank Data Group Data Filter Grouped Data Summarize Grouped Data Use PIVOT and UNPIVOT Operators 5 - Retrieving Data from Tables Combine Results of Two Queries Compare the Results of Two Queries Retrieve Data by Joining Tables Check for Unmatched Records Retrieve Information from a Single Table Using Joins 6 - Presenting Query Results Save the Query Result Generate an XML Report

SQL Querying Fundamentals - Part 1
Delivered OnlineFlexible Dates
£495

Level 2 NVQ Diploma in Construction Operations

By REX Training Services

Level 2 NVQ Diploma in construction operations

Level 2 NVQ Diploma in Construction Operations
Delivered Online On Demand
£900

VTCT Level 2 Beauty Therapy

4.9(16)

By Omni Academy

This is the first stage in becoming a fully qualified Beauty Therapist. You will learn about health and safety for your work area, your client and yourself. We will provide you with the skills and information on how to perform traditional and contemporary beauty therapy treatments safely and effectively, to the current industry standards.

VTCT Level 2 Beauty Therapy
Delivered In-PersonJoin Waitlist
£2,655

Office Management, Minute Taking and Document Control-Endorsed Certificate

4.7(47)

By Academy for Health and Fitness

***24 Hour Limited Time Flash Sale*** Office Management, Minute Taking and Document Control-Endorsed Certificate Admission Gifts FREE PDF & Hard Copy Certificate| PDF Transcripts| FREE Student ID| Assessment| Lifetime Access| Enrolment Letter In the fast-paced environment of the UK workplace, efficient office management is paramount. Did you know that, according to a recent survey, about 83% of UK businesses emphasised the need for skilled office managers to boost productivity? Are you prepared to enhance office efficiency and handle documentation like a pro? This Office Management bundle is designed to elevate your administrative and management skills, setting you apart in the professional world. You'll learn effective office management techniques, master the art of minute-taking, and gain expertise in document control. Develop strong communication skills to build successful teams and navigate complex projects. Additionally, gain a solid understanding of compliance and risk management to ensure your organization operates smoothly. Finally, learn strategies to conquer workplace disorganization and create a more productive environment. Key Features of the Office Management, Minute Taking and Document Control-Endorsed Certificate Bundle: 3 QLS-Endorsed Courses: We proudly offer 3 QLS-endorsed courses within our Office Management, Minute Taking and Document Control-Endorsed Certificate bundle, providing you with industry-recognized qualifications. Plus, you'll receive a free hardcopy certificate for each of these courses. QLS Course 01: Office Management and Administration Diploma QLS Course 02: Minute Taking Executive Training Level 5 QLS Course 03: Document Control 5 CPD QS Accredited Courses: Additionally, our bundle includes 5 relevant CPD QS accredited courses, ensuring that you stay up-to-date with the latest industry standards and practices. Course 01: Team Building Masterclass Course 02: Communication Building Masterclass Course 03: Effective Communication with Better Email Course 04: Compliance and Risk Management Diploma Course 05: Mastering Organizational Chaos In Addition, you'll get Five Career Boosting Courses absolutely FREE with this Bundle. Course 01: Professional CV Writing Course 02: Job Search Skills Course 03: Self-Esteem & Confidence Building Course 04: Professional Diploma in Stress Management Course 05: Complete Communication Skills Master Class Convenient Online Learning: Our Office Management, Minute Taking and Document Control-Endorsed Certificate courses are accessible online, allowing you to learn at your own pace and from the comfort of your own home. Don't miss this opportunity to enhance your professional profile and open doors to new career prospects. Enroll in the Office Management, Minute Taking, and Document Control Bundle today and unlock a world of possibilities! Learning Outcomes of Office Management Implement effective office management strategies and administrative best practices. Develop proficiency in minute-taking and accurate record-keeping. Establish robust document control systems for efficient information management. Foster strong team collaboration and effective communication skills. Analyze compliance and risk management principles for organizational success. Implement strategies to overcome organizational chaos and enhance productivity. Why Choose Us? Get a Free CPD Accredited Certificate upon completion of Office Management Get a free student ID card with Office Management Training program (£10 postal charge will be applicable for international delivery) The Office Management is affordable and simple to understand This course is entirely online, interactive lesson with voiceover audio Get Lifetime access to the Office Management course materials The Office Management comes with 24/7 tutor support Start your learning journey straightaway! *** Course Curriculum *** QLS Course 01: Office Management and Administration Diploma Personal Assistant Admin Support Organisational Skills Telephone Etiquette Business Writing Time Management Body Language and Effective Communication Meeting Management QLS Course 02: Minute Taking Executive Training Level 5 Module 01: Introduction To Minute Writing Module 02: Preparation For Minute Taking Module 03: The Meeting Structure Module 04: Minute Meeting, Decision And Action Module 05: Roles And Responsibility Of Minute Taker Module 06: Tips For Minute Taking Module 07: Technology In Minute Taking Module 08: Building Confidence QLS Course 03: Document Control Module 1: Introduction To Document Control Module 2: Principles Of Document Control And Elements Of Document Control Environment Module 3: Document Control Lifecycle Module 4: Document Control Strategies And Instruments Module 5: Document Management Module 6: Quality Assurance And Controlling Quality Of Documents Module 7: Project Document Control Module 8: Electronic Document Management Systems And Soft Copy Documentation =========>>>>> And 10 More Courses <<<<<========= How will I get my Certificate? After successfully completing the course, you will be able to order your Certificates as proof of your achievement. PDF Certificate: Free (Previously it was £12.99*13 = £168) QLS Endorsed Hard Copy Certificate: Free (For The 3 QLS Course: Previously it was £119*3 =357) CPD 450 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone interested in learning more about the topic is advised to take this bundle. This bundle is ideal for: Professionals seeking to enhance their office management and administration skills. Individuals interested in developing expertise in minute-taking and executive training. Document control professionals aiming to strengthen their knowledge and skills. Team leaders and managers looking to improve team dynamics and communication. Requirements You will not need any prior background or expertise to enrol in this bundle. Career path After completing this bundle, you are to start your career or begin the next phase of your career. Office Manager: £25,000 - £45,000 per year Executive Assistant: £28,000 - £45,000 per year Document Controller: £23,000 - £40,000 per year Compliance Officer: £30,000 - £50,000 per year Team Leader: £25,000 - £40,000 per year Communications Specialist: £25,000 - £45,000 per year Certificates Certificate in Document Control at QLS Level 3 Hard copy certificate - Included Please note that International students have to pay an additional £10 as a shipment fee. Certificate in Office Management at QLS Level 3 Hard copy certificate - Included Please note that International students have to pay an additional £10 as a shipment fee. CPD Accredited Digital Certificate Digital certificate - Included Upon passing the Course, you need to order a Digital Certificate for each of the courses inside this bundle as proof of your new skills that are accredited by CPD QS for Free. CPD Accredited Hard Copy Certificate Hard copy certificate - Included Please note that International students have to pay an additional £10 as a shipment fee. Diploma in Minute Taking at QLS Level 5 Hard copy certificate - Included Please note that International students have to pay an additional £10 as a shipment fee.

Office Management, Minute Taking and Document Control-Endorsed Certificate
Delivered Online On Demand38 hours
£249

Interview Skills - Achieve Own Job Goals

By Training Tale

The relevant industry experts developed this Interview Skills - Achieve Own Job Goals course. Searching for a job can be exciting; it can also be fraught with anxiety and discomfort due to change and the unknown. Whether you are already in the midst of a job search or are considering one, this Interview Skills - Achieve Own Job Goals course will provide you with the skills necessary to identify and apply for suitable jobs, as well as to prepare for and conduct yourself in a job interview. The job market today is not what it was even five years ago. Knowing where to go, who to talk to, and what opportunities are available will help you transition from someone who fantasizes about having a job to someone who has the job they've always wanted. The purpose of this Interview Skills - Achieve Own Job Goals course is to help you determine your skillset, the type of work that is important and realistic to include in your search, and how to get started. Learning Outcomes After completing this Interview Skills - Achieve Own Job Goalscourse, the learner will be able to: Learn how to identify achievable job goals. Gain a thorough understanding of the key qualities required for employment from an employer's perspective. Know the different types of CVs and cover letters used to apply for jobs. Know how to identify suitable job opportunities and apply for them. Understand how to prepare for an interview. Understand how to conduct yourself in an interview situation. Know how to reflect on your own performance following an interview situation. Why Choose Interview Skills - Achieve Own Job Goals Course from Us Self-paced course, access available from anywhere. Easy to understand, high-quality study materials. Course developed by industry experts. MCQ quiz after each module to assess your learning. Automated and instant assessment results. 24/7 support via live chat, phone call or email. Free PDF certificate as soon as completing the course. Assessment Method After completing each module of the Interview Skills - Achieve Own Job Goals, you will find automated MCQ quizzes. To unlock the next module, you need to complete the quiz task and get at least 60% marks. Once you complete all the modules in this manner, you will be qualified to request your certification. Certification After completing the MCQ/Assignment assessment for this course, you will be entitled to a Certificate of Completion from Training Tale. It will act as proof of your extensive professional development. The certificate is in PDF format, which is completely free to download. A printed version is also available upon request. It will also be sent to you through a courier for £13.99. **Interview Skills - Achieve Own Job Goals** Detailed Curriculum of Interview Skills - Achieve Own Job Goals [Bundle Course 1] Module 01: Preparing to Achieve Own Job Goals Understand how to identify achievable job goals Understand the key qualities required for employment from an employer perspective Be able to identify own employability skill Module 02: Promoting Yourself and Preparing for a Job Interview Know the different types of CV and cover letter used to apply for jobs Understand where and how to search for jobs Be able to identify suitable job opportunities and apply for them Understand how to prepare for an interview Be able to conduct self in an interview situation Be able to reflect on own performance following an interview situation [Bundle Course 2] Module 01: Workplace Stress Define Workplace Stress The Most Important Factors Influencing Workplace Stress The Fallout of Workplace Stress Module 02: Rational and Irrational Beliefs Rational Emotive Behaviour Therapy Define Rational Thinking & Irrational Thinking The Origin of Irrational Thinking The Silver Lining Irrational Core Beliefs Acceptance Module 03: The ABC Framework of REBT Situation Disputing Module 04: Cognitive Therapy (CT) Cognitive Therapy (CT) Cognitive Errors Negative Automatic Thoughts (NATs) and Dysfunctional Beliefs Recognizing Our Dysfunctional Beliefs Example Recapitulation of CT and REBT Module 05: Cognitive Behavioural Therapy (CBT) in the Workplace How Can (CBT) Techniques Help Us in the Workplace? Situations That We Face at Work Which May Cause Stress The Advantages of Cognitive Behavioural Therapy in the Workplace Cognitive Behavioural Therapy (CBT) for Us Module 06: Conclusion Conclusion Module 07: Identifying and Challenging Distorted Negative Thoughts Exercise 1: Lost Your Job Exercise 2: Failed in Your Job Interview Exercise 3: Not the All-Rounder Exercise 4: Feeling Inferior Exercise 5: Mundane Work Exercise 6: Being Laughed At Exercise 7: The Boss Is Dumping His Work on You Exercise 8: Feel Incompetent Exercise 9: Can't Stand Up for Yourself Exercise 10: Boss Does Not Like You Exercise 11: Failed to Do What You Had Planned Exercise 12: Lack Common Sense Exercise 13: You Help Others but They Don't Help You Exercise 14: Feeling Inferior Exercise 15: Never Speak Up at Meetings Exercise 16: Never Speak Up at Meetings (This Time for a Different Reason) Exercise 17: Never Speak Up at Meetings (For Yet Another Reason) Exercise 18: Complaint Against You Exercise 19: Impress the Chairman Exercise 20: A Disastrous Day Exercise 21: Interview After-Effects Exercise 22: Anxiety Jitters at Presentations Exercise 23: Not Popular Exercise 24: Ethical Dilemma [Bundle Course 3] Module 01: Difficult People and Their Difficult Behaviour Introduction Openly Hostile, Aggressive Behaviour Disguised Hostility: Passive-Aggressive Behaviour Passive Behaviour Module 02: Communicating With Difficult People Introduction Minimal Encouragers Reflective Listening Questions About Feelings Non-Verbal Communication Talking to Difficult People Module 03: Standing Up to Difficult People Introduction How to be Assertive Building the Confidence to be More Assertive Choosing How to Respond Module 04: A Quick Guide to the Seven Classically Difficult Types Hostile, Aggressive, Belligerent and Offensive Complainer, Grouches and the Sourpuss The Silent Unresponsive and the Quiet Ones The Super Agreeable: A Bit Like a Spaniel Puppy The Negativist The Know-All The Indecisive, The Ditherer, The Hesitant Module 05: Dealing with Bosses Who Drive You Barmy Introduction Mr Angry Never Let Them See You Sweat Module 06: Colleagues to Throttle Introduction Competition Crazy Rivals, Antagonists and Getting Personal It Is Always the Quiet Ones Module 07: Dealing With Impossible People Impossible People Critical, Impossible-to-Please Impossible People Persistently Negative Impossible People Drama Queens Self-Centred Impossible People Bullies How to Deal with Impossible People Module 08: The Temper Tantrum Type How to Spot a Temper Tantrum Type How Did Temper Tantrum Types Get That Way? How to Avoid Temper Tantrum Types Getting Temper Tantrum Types to Act Their Age Who is this course for? **Interview Skills - Achieve Own Job Goals** The Interview Skills - Achieve Own Job Goals is ideal for anyone who wants to learn how to apply for the job they want. Requirements **Interview Skills - Achieve Own Job Goals** There are no specific requirements for this Interview Skills - Achieve Own Job Goals Course because it does not require any advanced knowledge or skills. Students who intend to enrol in this course must meet the following requirements: Good command of the English language Must be vivacious and self-driven Basic computer knowledge A minimum of 16 years of age is required

Interview Skills - Achieve Own Job Goals
Delivered Online On Demand32 hours
£12

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

Comprehensive Aesthetic Specialist Training Package

By Cosmetic College

Take your beauty therapy skills to the next level with our Comprehensive Aesthetic Specialist Training Package. This all-inclusive package combines six of our most sought-after VTCT Level 4 courses, providing you with the knowledge and practical experience to offer a wide range of advanced aesthetic treatments. Our package includes the following courses: Level 4 Award in Skin Needling: Learn the art of skin rejuvenation with this microneedling course, which is ever growing in the industry. Level 4 Award in Dermaplaning: Learn the art of dermaplaning, a popular exfoliating treatment that removes dead skin cells and peach fuzz, leaving the skin smooth and radiant. Level 4 Award in High-Intensity Focused Ultrasound (HIFU): Gain the skills to offer HIFU treatments, a non-invasive procedure that tightens and lifts the skin, reducing the appearance of wrinkles and improving skin elasticity. Level 4 Certificate in Radio Frequency: Master the principles and practice of radio frequency therapy, a treatment that stimulates collagen production to reduce the appearance of fine lines and loose skin. Level 4 Chemical Skin Peels: Learn to perform skin peeling treatments, which can improve the appearance of the skin by reducing the visibility of scars, wrinkles, and hyperpigmentation. Level 4 in Ultrasound: Add ultrasound therapy to your repertoire, a treatment that can promote cellular renewal and repair, tone muscles, increase blood circulation, and improve skin care product penetration. Laser Hair Removal: Become a fully qualified laser aesthetic technician, capable of providing high-quality, safe, and effective laser hair removal treatments. Benefits of the Package: This comprehensive package is designed to equip you with a broad range of skills, making you a versatile and highly sought-after professional in the aesthetics industry. By completing these courses, you will not only expand your treatment offerings but also enhance your career prospects, whether you're looking to work in a salon, spa, or start your own business. What's Included: Each course in this package includes the VTCT Level 4 Qualification, all certificate and examination fees, refreshments, a complimentary treatment for your model, a professional treatment kit, membership discounts, and access to online community support groups. Flexible Payment Options: We understand that investing in your future is a big decision. That's why we offer flexible payment options, allowing you to spread your training costs over 3, 6, 9, or 12 months interest-free. Secure your place in our Comprehensive Aesthetic Specialist Training Package today with a minimal deposit. Join Us: Embark on a transformative journey with the Cosmetic College. Enhance your skills, boost your career, and become a highly qualified aesthetic specialist. Contact us today to learn more about our Comprehensive Aesthetic Specialist Training Package.

Comprehensive Aesthetic Specialist Training Package
Delivered In-PersonFlexible Dates
£5,000