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

143 Courses

Microsoft Excel: Master Power Query in 120 Minutes!

4.5(3)

By Studyhub UK

Overview Do you face struggle when you open a Power Query seeing the number of things to do then and cannot make good use of your time? Then this Microsoft Excel: Master Power Query in 120 Minutes! Course is just what you need.to break free of your worries. Power Query is a business intelligence tool available in Excel that allows you to import data from many sources and then clean, transform and reshape your data as needed. The course is designed for learners opting to learn Power Query, a feature available in Excel. Power query is a data connection technology that enables you to connect combine refine and discover data from various sources to meet analysis needs.  The course will introduce you to the basic features of Power query and then show how to trim and transform Data in Excel Power Query, Format Dates and Values in Excel Power Query. You will also learn how to extract data from folders and doing auto clean up on Excel Power Query. You will also learn to merge and shape data according to analysis requirements and prepare models by tools such as power pivot. Learning Outcomes: Acquire proficiency in using Excel Power Query for efficient data management. Master the art of transforming raw data into actionable insights. Learn advanced techniques for data manipulation and analysis. Develop the ability to streamline complex data processes. Enhance your analytical thinking and problem-solving skills. How is the course assessed? To successfully complete the course you must pass an automated, multiple-choice assessment. The assessment is delivered through our online learning platform. You will receive the results of your assessment immediately upon completion. Will I receive a certificate of completion? Upon successful completion, you will qualify for the UK and internationally-recognised certification and you can choose to make your achievement formal by obtaining your PDF Certificate at a cost of £9 and Hardcopy Certificate for £15. Why study this course Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards and CIQ after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the Course at your own pace, on your own schedule. Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience. Unlock career resources for CV improvement, interview readiness, and job success. Requirements Our Microsoft Excel: Master Power Query in 120 Minutes! 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 paths Data Analyst: £25,000 - £40,000 Per Annum Business Analyst: £30,000 - £50,000 Per Annum Financial Analyst: £28,000 - £45,000 Per Annum Marketing Analyst: £24,000 - £40,000 Per Annum Operations Analyst: £26,000 - £42,000 Per Annum Management Consultant: £35,000 - £55,000 Per Annum Course Curriculum Microsoft Excel: Master Power Query in 120 Minutes! Power Query Intro and Excel version 00:03:00 Excel Power Query - Introduction 00:03:00 Excel Power Query - Query Editor Ribbon 00:09:00 Transform Data - Trim in Excel Power Query 00:05:00 Transform Data - Format Dates and Values in Excel Power Query 00:02:00 Transform Data - Parsing URLs in Excel Power Query 00:05:00 Transform Data - Split Text Fields in Excel Power Query 00:10:00 Transform Data - Group By in Excel Power Query 00:03:00 Transform Data - Unpivoting Columns in Excel Power Query 00:05:00 Transform Data - Pivoting Columns in Excel Power Query 00:02:00 Transform Data - Split Columns into Other Columns in Excel Power Query 00:04:00 Transform Data - Filtering Rows in Excel Power Query 00:05:00 Transform Data - Sorting Columns in Excel Power Query 00:02:00 Transform Data - Transform and Add Columns in Excel Power Query 00:07:00 From Folder - Import From Folder in Excel Power Query 00:07:00 From Folder - Doing Auto Cleanup in Excel Power Query 00:13:00 From Folder - Extract Data from Forms in Excel Power Query 00:13:00 From Workbook - Extract Multiple Criteria in Excel Power Query 00:05:00 From Workbook - Extract Multiple Worksheets in Excel Power Query 00:04:00 Joins - Intro to Joins 00:04:00 Joins - Merging 00:08:00 Joins - Full Outer Join 00:06:00 Joins - Right Anti Join 00:09:00 Power Query - Convert Reports into Pivot Tables 00:05:00 Modulo 00:06:00

Microsoft Excel: Master Power Query in 120 Minutes!
Delivered Online On Demand2 hours 25 minutes
£10.99

The Ultimate Excel VBA Course - Learn and Master VBA Fast

By Packt

Discover how to utilize VBA to automate procedures and effortlessly generate reports with a single button press. Streamline your tasks and achieve seamless productivity by performing various actions at the click of a button. No prior knowledge of VBA is required but familiarity with Excel will be an advantage.

The Ultimate Excel VBA Course - Learn and Master VBA Fast
Delivered Online On Demand2 hours 27 minutes
£82.99

AutoCAD Training for 15 hours - Live and Online

By FirstScale Revit Consultant and Training

AutoCAD Training for 15 hours - Live and Online The AutoCAD Training is for 15 hours that will cover from Introduction to Intermediate in small classes with only 1 people per class. AutoCAD course is for Windows or AutoCAD for MAC platforms. If you have AutoCAD for MAC, please let us know to book the specific course.  The training is tailored to your needs and we will focus the AutoCAD course on the area you want to learn.   During the training, you will receive many AutoCAD tips on how to work fast and efficient.  This live AutoCAD course will be now online at a reduced price.  You will receive a certificate of attendance at the end of the course. After the training, you can book 1 to 1 AutoCAD support to answer your questions and support your journey to learn AutoCAD. This is an extra service that you can book a minimum of 2.5 hours. Spread the cost with interest-free instalments. Buy now, pay later courses! AutoCAD Training: https://www.bimrevittraining.com/autocad-training AutoCAD Course Description AutoCAD Settings and Customization • Workspaces (AutoCAD Classic/2D Drafting & Annotation) • Background Color • Cross Air Size • New / Open and Save • User Preferences • Toolbars • Drawing Units • Drawing Limits • Snap Mode • Grid Display • Ortho Mode • Polar Tracking • Object Snap • Object Snap Tracking   AutoCAD Drawing Tools • Line • Multiple Line • Construction Line • Polyline • Polygon • Rectangle • Arc • Circle • Revision Cloud • Spline • Ellipse / Ellipse Arc • Insert Block • Make Block • Point • Hatch/Gradient • Region • Table • Multiline Text   Modify Tools • Erase • Copy • Mirror • Offset • Array • Move • Rotate • Scale • Stretch • Trim • Extend • Break at Point • Break • Join • Chamfer • Fillet • Explode   Working Methods •Object Properties •Match Properties •Layer Properties Manager •Adding Layers •Working with Layouts •External References •Insert/Edit Images •Insert PDF   AutoCAD Plotting / Publishing •Page Setup Manager •Plot Style Manager •Plotting •Publish •eTransmit

AutoCAD Training for 15 hours - Live and Online
Delivered OnlineFlexible Dates
£525

Film and Game Design Training Classes

By ATL Autocad Training London

Who is this course for? Film and Game Design Training Classes is tailored for individuals passionate about 3D for Games. Ideal for those in London seeking specialized skills for lucrative job opportunities in the gaming industry. Software we teach: 3ds max or Maya, Vray, After effects and Photoshop. Check our Website Duration: 40 hours. 1-on-1 Training. When can I book: 9 am - 4 pm (Choose your preferred day and time once a week). Monday to Saturday: 9 am - 7 pm (Flexible timing with advance booking).  Course Title: Film & Game Design Training Classes Option A - 40-Hour Program: Option A offers comprehensive training for aspiring film and game designers, covering vital industry software and skills. Module 1: 3ds Max and Advanced Animation (20 hours) - Introduction to 3ds Max: Interface overview. - Basic 3D Modeling: Creating simple 3D objects. - Advanced 3D Modeling: Complex modeling techniques. - Texturing and Materials: Applying textures and materials. - Lighting and Rendering: Scene lighting and rendering setup. - Character Animation: Rigging and animating characters. - Advanced Animation Techniques: Keyframes, motion paths, and more. - Scene Composition: Assembling complex scenes. Module 2: Vray (6 hours) - Vray Introduction: Understanding Vray renderer. - Lighting with Vray: Creating realistic lighting setups. - Material Creation: Crafting materials for realistic surfaces. - Rendering with Vray: Optimization and execution. Module 3: Photoshop (6 hours) - Photoshop Basics: Navigating the interface. - Image Editing: Crop, resize, and enhance. - Layer Management: Working with layers. - Text and Typography: Adding and manipulating text. - Photo Manipulation: Advanced image techniques. - Creating Visual Assets: Designing textures and graphics. Module 4: After Effects: Video and Sound Editing (8 hours) - Introduction to After Effects: Interface overview. - Video Editing: Cut, trim, and arrange video clips. - Transitions and Effects: Apply visual effects and transitions. - Sound Editing: Add and edit audio tracks. - Motion Graphics: Create motion graphics and titles. - Exporting and Rendering: Prepare projects for final output. Film & Game Design Training Course Information Are you ready to explore our Training Course for Film & Game Designers? Here's a comprehensive overview to guide you through: When Can I Book This Training Course? Personalize your training with our flexible 1-on-1 sessions. Tailor your schedule by pre-booking your preferred hours. Available Monday to Saturday, 9 a.m. to 7 p.m. For phone bookings, call 02077202581. Training Duration The course spans 40 hours, allowing flexibility for your ideal schedule. Training Method Experience 1-on-1 training, in-person Face to Face or Live Online. Expect personalized attention, tailored content, flexible learning, and individual support. Opt for Live Online 1-on-1 sessions via Zoom for convenience. Enroll Today Ready to start your exciting journey? Click the link below to enroll in our 1-on-1 Course. Film & Game Design Training Overview In our comprehensive training program for film and game designers, refine your skills using industry-leading software tools. This prepares you to bring your creative visions to life. Option A: 3ds Max and Advanced Animation (20 hours) Vray (6 hours) Photoshop (6 hours) Aftereffects: Video and Sound Editing (8 hours) Option B: Maya and Advanced Animation (20 hours) Vray (6 hours) Photoshop (6 hours) Aftereffects: Video and Sound Editing (8 hours) Both options offer flexibility for Mac and Windows operating systems, ensuring accessibility for all learners. Key Benefits Price Assurance: Exceptional value for your film and game design career investment. One-on-One Training: Customized learning for your unique style. Flexible Scheduling: Choose your training time, available Monday to Sunday, 9 am to 8 pm. Lifetime Email and Phone Support: Ongoing assistance beyond training for your career growth. Computer Configuration Assistance: Guidance for seamless software installation. Referral Benefits: Special discounts for referrals and savings on group training. Embark on a transformative journey and unlock your potential in the thrilling fields of film and game design!

Film and Game Design Training Classes
Delivered in London or OnlineFlexible Dates
£1,440

Level 2 & 3 Video Editing

By Imperial Academy

Level 3 QLS Endorsed Course with FREE Certificate | CPD & CiQ Accredited | 120 CPD Points | Lifetime Access

Level 2 & 3 Video Editing
Delivered Online On Demand
£100

Video Editing and Adobe After Effects - Double Endorsed Certificate

By Imperial Academy

2 QLS Endorsed Course | CPD Certified | Free PDF + Hardcopy Certificates | 80 CPD Points | Lifetime Access

Video Editing and Adobe After Effects - Double Endorsed Certificate
Delivered Online On Demand
£150

Brow Lift & Lamination Training

4.9(27)

By Apex Learning

Overview This comprehensive course on Brow Lift & Lamination Training will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Brow Lift & Lamination Training comes with accredited certification, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this Brow Lift & Lamination Training. It is available to all students, of all academic backgrounds. Requirements Our Brow Lift & Lamination Training is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management, Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 5 sections • 12 lectures • 00:47:00 total length •Introduction: 00:01:00 •1. Clean the eyebrows: 00:03:00 •2. Apply The product nr1: 00:02:00 •3. Removing The product nr1: 00:02:00 •4. Apply The product nr2: 00:03:00 •5. Removing The product nr2: 00:02:00 •6. Tint the eyebrows: 00:10:00 •7. Tweeze, wax, trim them: 00:14:00 •8. Strengthening lotion and concealing: 00:08:00 •Tint preparation: 00:02:00 •Resources - Brow Lift & Lamination Training: 00:00:00 •Assignment - Brow Lift & Lamination Training: 00:00:00

Brow Lift & Lamination Training
Delivered Online On Demand47 minutes
£12

Podcasting and Video Editing - Double Endorsed Certificate

By Imperial Academy

2 QLS Endorsed Course | CPD Certified | Free PDF + Hardcopy Certificates | 80 CPD Points | Lifetime Access

Podcasting and Video Editing - Double Endorsed Certificate
Delivered Online On Demand
£150

Process Control and Instrumentation

By EnergyEdge - Training for a Sustainable Energy Future

Enhance your skills in process control and instrumentation with EnergyEdge's comprehensive classroom training. Enroll now and take your career to new heights.

Process Control and Instrumentation
Delivered In-PersonFlexible Dates
£2,299 to £2,399

Professional Brow Lamination Course Online

By Lead Academy

Quality Guarantee: Promising training excellence, satisfaction gurantee Accredited by: The CPD Certification Service Tutor Support: Unlimited support via email, till you complete the course Recognised Certification: Accepted by thousands of professional bodies Start Anytime: With 1 year access to the course materials Online Learning: Learn from anywhere, whenever you want In this course, you will learn the art of brow lamination techniques to create sleek, defined, and uniform eyebrows. You will have the knowledge of brow shaping, product knowledge and safety protocols. Which will help you shape your career in the beauty industry. This course at a glance Eligible to apply for the insurance Accredited by International Practitioners of Holistic Medicine (IPHM) Accredited by CPD UK Understand what is eyebrow lifting and tinting Learn what factors to consider to survive your eyebrows Understand the procedures and applications of brow lifting in-depth Know how to clean the eyebrows, apply the product, and remove the product smoothly Understand how to tint the eyebrows, tweeze, wax, and then trim Learn how strengthening lotion and concealing will maintain your eyebrows Recognise the types of eyebrow tint and steps to prepare the product Identify the safety measures that should be taken while performing the eyebrow lamination treatment Know how to take care of your lifted brows Why Professional Brow Lamination Course right for you? Brow lamination helps in filling gaps in your brows which might have happened from overplucking or over-waxing before. This extensive Brow Lamination Course is suitable for brow lamination artists or for those who want to make a thin brow fuller and more fluffy. This course offers a thorough explanation of the brow lamination procedure as well as instructions on how to produce various appearances, from subtle to dramatic. This extensive course will help you in gaining knowledge about brow lift procedures, benefits, and costs. You will have a basic understanding of brow lift, its applications, products used, and aftercare methods. This course covers the philosophy underlying brow lamination, health and safety, including types of eyebrows, specialised treatments, brow tinting, and brow waxing for the ideal finish. Upon successful completion of this Brow Lamination Course, you will gain extensive knowledge and skills in doing brow lifting or lamination. You will have a basic understanding of how it works and what tools and materials are used to perform the process. Professional Brow Lamination Course Details Accredited by International Practitioners of Holistic Medicine (IPHM) is a leading accredited organisation that certifies and regulates alternative therapists, healers, and training providers around the world. After completing the IPHM accredited course you will be eligible to apply for the insurance.   CPD certificates are accepted by thousands of professional bodies and government regulators here in the UK and around the world. Many organisations look for employees with CPD requirements, which means, that by doing this course, you would be a potential candidate in your respective field.   Course Curriculum Introduction Introduction The Treatment 1. Clean the Eyebrows 2. Apply the Product Nr1 3. Removing the Product Nr1 4. Apply the Product Nr2 5. Removing the Product Nr2 6. Tint the Eyebrows 7. Tweeze, Wax, Trim Them 8. Strengthening Lotion and Concealing Types of Eyebrow Tint and Product Preparation Tint Preparation Who should take this course? Estheticians Makeup artist Cosmetologist Beginner stylists Beautician Brow lamination artist Beginner beauticians Aspiring makeup artist/beautician Anyone working within the beauty industry Owner of brow lamination providers Beginner or anyone desiring to become a brow lamination artist Anyone interested in learning more about the beauty industry This course is not, however, limited to any particular profession or line of employment. Anyone interested in learning the fundamentals of brow lifting or laminating is also encouraged to enrol in this course. Entry Requirements There are no academic entry requirements for this Brow Lamination Course, and it is open to students of all academic backgrounds. However, you are required to have a laptop/desktop/tablet or smartphone and a good internet connection. Assessment Method This professional brow lamination course online assesses learners through multiple-choice questions (MCQs). Upon successful completion of the modules, learners must answer MCQs to complete the assessment procedure. Through the MCQs, it is measured how much a learner could grasp from each section. In the assessment pass mark is 60%. Certification Certificate of Achievement from Lead Academy After successfully passing the MCQ exam you will be eligible to order your certificate of achievement as proof of your new skill. The certificate of achievement is an official credential that confirms that you successfully finished a course with Lead Academy. Certificate can be obtained in PDF version at a cost of £12, and there is an additional fee to obtain a printed copy certificate which is £35. FAQs Is CPD a recognised qualification in the UK? CPD is globally recognised by employers, professional organisations and academic intuitions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. CPD-certified certificates are accepted by thousands of professional bodies and government regulators here in the UK and around the world. Are QLS courses recognised? Although QLS courses are not subject to Ofqual regulation, they must adhere to an extremely high level that is set and regulated independently across the globe. A course that has been approved by the Quality Licence Scheme simply indicates that it has been examined and evaluated in terms of quality and fulfils the predetermined quality standards. When will I receive my certificate? For CPD accredited PDF certificate it will take 24 hours, however for the hardcopy CPD certificate takes 5-7 business days and for the Quality License Scheme certificate it will take 7-9 business days. Can I pay by invoice? Yes, you can pay via Invoice or Purchase Order, please contact us at info@lead-academy.org for invoice payment. Can I pay via instalment? Yes, you can pay via instalments at checkout. How to take online classes from home? Our platform provides easy and comfortable access for all learners; all you need is a stable internet connection and a device such as a laptop, desktop PC, tablet, or mobile phone. The learning site is accessible 24/7, allowing you to take the course at your own pace while relaxing in the privacy of your home or workplace. Does age matter in online learning? No, there is no age limit for online learning. Online learning is accessible to people of all ages and requires no age-specific criteria to pursue a course of interest. As opposed to degrees pursued at university, online courses are designed to break the barriers of age limitation that aim to limit the learner's ability to learn new things, diversify their skills, and expand their horizons. When I will get the login details for my course? After successfully purchasing the course, you will receive an email within 24 hours with the login details of your course. Kindly check your inbox, junk or spam folder, or you can contact our client success team via info@lead-academy.org

Professional Brow Lamination Course Online
Delivered Online On Demand
£25