1868 Beauty courses

Description: A hairstyle is a dominant area of styling. When it comes to Bridal hair styling, it is more important as your hairstyle can change the whole look. Proper hair styling can make your day memorable. If you want to master the bridal hair styling, the Bridal Hair Certificate course is designed for you. Throughout the course, you will master all the essential techniques that you need to know about becoming a freelance bridal hair stylist. You will learn various bridal hairstyles such as traditional up-dos, free-flowing styles and combinations of the two. The course provides a detailed discussion on the preparation process and teaches you how to set and complete a highly-sought after, modern romantic look. Shortly, the course covers the knowledge about the necessary equipment, best curly hair for loose, beachy waves, techniques for creating Hollywood-glam inspired waves, how to choose the right pin, strategies of making a messy bun with maximum hold, and more. By studying the course, you will not only be able to start your career as a bridal hair stylist but also able to market your business rightly. Assessment: This course does not involve any MCQ test. Students need to answer assignment questions to complete the course, the answers will be in the form of written work in pdf or word. Students can write the answers in their own time. Once the answers are submitted, the instructor will check and assess the work. 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? Bridal Hair Certificate 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 Bridal Hair Certificate 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. Updated Version - Bridal Hair Certificate Module 01: Introduction to Bridal Hair Introduction to Bridal Hair 00:20:00 Module 02: Hair and Scalp Care for Brides Hair and Scalp Care for Brides 00:18:00 Select Module 03: Basic Bridal Hair Styling Techniques Module 03: Basic Bridal Hair Styling Techniques Basic Bridal Hair Styling Techniques 00:18:00 Module 04: Bridal Hair Updos and Braids Bridal Hair Updos and Braids 00:17:00 Select Module 05: Bridal Hair Coloring and Extensions Module 05: Bridal Hair Coloring and Extensions Bridal Hair Coloring and Extensions 00:18:00 Select Module 06: Advanced Bridal Hair Styling Module 06: Advanced Bridal Hair Styling Advanced Bridal Hair Styling 00:17:00 Old Version - Bridal Hair Certificate Bridal Hairstyles Preparation and Required Tools 01:00:00 Modern Romance Up-Do Part 1 - Hollywood Glam 01:00:00 Modern Romance Up-Do Part 2 - Pinning it Up 00:30:00 Other Popular Bridal Styles 01:00:00 Tips and Marketing 00:30:00 Unique Hairstyles Fishtail Braid Updo | The JLO Braid 00:15:00 Game of Thrones Inspired Hair Tutorial | The Khaleesi Braid 00:15:00 Slip Tie Braid | Knotted Mohawk Braid 00:30:00 Pull Back Ladder Braid Hairstyle Tutorial 00:15:00 Braided Flower Bun 00:15:00 Slip Knot Technique - 2 Strand Braid 00:15:00 French Pull-Through Braid Ponytail 00:30:00 Wedding Prom and Party Hairstyles 00:15:00 Romantic Hairstyle for Long Hair 00:15:00 Greek Goddess-Inspired Hairstyles! 00:15:00 Bridal Hairstyles 00:15:00 Updo Hairstyles 00:15:00 Half Updo Hairstyle 00:15:00 Updo Braided Elsa-Inspired Hairstyle Tutorial 00:15:00 Bridal Updo For Medium Hair and Long Hair 00:15:00 Outstanding Bridal Hairstyle 00:30:00 Romantic Side-Swept Updo 00:15:00 Order Your Certificates and Transcripts Order Your Certificates and Transcripts 00:00:00

Learn Intermediate Belly Dance in a short time in this level 2 course and have fun working out whilst learning a new skill in your own time, at your own pace and in your own space, no matter where you are!

Hot Stone Massage: Hot Stone Massage Course Online Unlock the Secrets of Ultimate Relaxation and Healing with Hot Stone Massage Therapy! Are you passionate about the art of massage therapy and eager to enhance your skills? Do you dream of offering your clients a truly transformative experience that leaves them feeling rejuvenated and deeply relaxed? Look no further! Our comprehensive Hot Stone Massage: Hot Stone Massage Course is here to help you master the ancient healing technique of hot stone massage from the comfort of your own home. What is Hot Stone Massage Therapy? Hot Stone Massage: Hot Stone Massage Course is a blissful practice that combines the power of heated basalt stones with the art of therapeutic touch. This centuries-old technique involves placing smooth, heated stones on key points of the body, allowing their warmth to penetrate deeply into the muscles, melting away tension, and promoting a profound sense of tranquility and wellness. Our Hot Stone Massage: Hot Stone Massage Course is carefully designed to equip you with all the essential knowledge and skills needed to become a proficient hot stone massage therapist. Our Hot Stone Massage: Hot Stone Massage Course is developed by experienced professionals in the field of massage therapy, ensuring you receive a comprehensive education that covers both theory and practical aspects of hot stone massage. With our online platform, you can study at your own pace and convenience. No need to rearrange your schedule or commute to a physical location. Learn from the comfort of your own home or anywhere you have an internet connection. Upon successful completion of this exclusive Hot Stone Massage: Hot Stone Massage Course, you will receive a prestigious certification, showcasing your expertise in Hot Stone Massage: Hot Stone Massage Course. This qualification will enhance your professional credibility and open doors to new opportunities. You will have lifetime access to the Hot Stone Massage: Hot Stone Massage Course materials, ensuring that you can revisit the content whenever you need a refresher. Stay up-to-date with the latest techniques and industry trends. Don't miss this incredible opportunity to elevate your massage practice and bring the transformative power of hot stone therapy to your clients. Enroll in our Hot Stone Massage: Hot Stone Massage Course today and embark on a journey of relaxation, healing, and professional growth. Main Course: Hot Stone Massage Therapy Course Free Course included with Hot Stone Massage Therapy Course Course 01: Indian Head Massage Course Course 02: Aromatherapy Course 03: Level 5 Nutritional Therapy Course 04: Level 3 Certificate In Sports Massage Therapy Course 05: Cupping Therapy [ Note: Free PDF certificate as soon as completing Hot Stone Massage: Hot Stone Massage With Indian Head Massage Course] Hot Stone Massage: Hot Stone Massage With Indian Head Massage Course Online Course Curriculum of Hot Stone Massage: Hot Stone Massage Course Module 01: Introduction to Hot Stone Massage Module 02: Massage Therapy Module 03: Anatomy and Physiology Module 04: Types of Stone Therapies Module 05: Consultation and Assessment Module 06: A Complete Hot Stone Massage Treatment Module 07: Aftercare Module 08: Ethics and Legalities Module 09: Business Practices Course Curriculum of Indian Head Massage Course Module 01: Introduction to Indian Head Massage Module 02:Essential Anatomy and Physiology for Indian Head Massage Module 03: Conditions Affecting the Head, Neck and Shoulders Module 04: Consultation for Indian Head Massage Module 05: Indian Head Massage Case Studies Module 06: Indian Head Massage Techniques Module 07: Stress Management Module 08: Health, Safety, Security and Employment Standards Module 09: Promotion and Marketing Assessment Method of Hot Stone Massage: Hot Stone Massage Course After completing Hot Stone Massage: Hot Stone Massage Course, you will get quizzes to assess your learning. You will do the later modules upon getting 60% marks on the quiz test. Apart from this, you do not need to sit for any other assessments. Certification of Hot Stone Massage: Hot Stone Massage Course After completing the Hot Stone Massage: Hot Stone Massage Course, you can instantly download your certificate for FREE. The hard copy of the certification will also be delivered to your doorstep via post, which will cost £13.99. Who is this course for? Hot Stone Massage: Hot Stone Massage With Indian Head Massage Course Online This Hot Stone Massage: Hot Stone Massage Course is open to everyone. Requirements Hot Stone Massage: Hot Stone Massage With Indian Head Massage Course Online To enrol in this Hot Stone Massage: Hot Stone Massage Course, students must fulfil the following requirements: Good Command over English language is mandatory to enrol in Hot Stone Massage: Hot Stone Massage Course. Be energetic and self-motivated to complete our Hot Stone Massage: Hot Stone Massage Course. Basic computer Skill is required to complete our Hot Stone Massage: Hot Stone Massage Course. If you want to enrol in our Hot Stone Massage: Hot Stone Massage Course, you must be at least 15 years old. Career path Hot Stone Massage: Hot Stone Massage With Indian Head Massage Course Online

The Indian Bridal Makeup course is divided into three parts, covering various aspects of bridal makeup application, including skincare, eye makeup techniques, face makeup application, and lip makeup. Each module is delivered in short and concise video tutorials. Learning Outcomes: Understand the fundamentals of Indian Bridal Makeup and its significance in wedding ceremonies. Learn how to prep and prime different skin types, including combination skin, to create a flawless base. Acquire skills to apply various eyeshadow shades like golden, copper, and brown for stunning eye makeup. Master the art of eyeliner application, especially on slightly hooded eyes. Learn how to curl flat lashes and apply false lashes to enhance the eye look. Gain expertise in creating a smoked-out look on the lower lashline and completing the eye makeup. Learn color correcting techniques to address dark pigmentation concerns. Acquire knowledge of applying foundation, highlighting, and contouring for medium to tan complexions. Learn the correct technique for applying bronzer and cream blush to add dimension and glow to the face. Acquire skills to create a 3D glow effect for a radiant look. Why buy this Indian Bridal Makeup? Unlimited access to the course for forever Digital Certificate, Transcript, student ID all included in the price Absolutely no hidden fees Directly receive CPD accredited qualifications after course completion Receive one to one assistance on every weekday from professionals Immediately receive the PDF certificate after passing Receive the original copies of your certificate and transcript on the next working day Easily learn the skills and knowledge from the comfort of your home Certification After studying the course materials of the Indian Bridal Makeup there will be a written assignment test which you can take either during or at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60. Who is this course for? This Indian Bridal Makeup course is ideal for Students Recent graduates Job Seekers Anyone interested in this topic People already working in the relevant fields and want to polish their knowledge and skill. Prerequisites This Indian Bridal Makeup does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Indian Bridal Makeup was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Career path As this course comes with multiple courses included as bonus, you will be able to pursue multiple occupations. This Indian Bridal Makeup is a great way for you to gain multiple skills from the comfort of your home. Course Curriculum Makeup Look Part 1 Module 1: Introduction to Indian Bridal Makeup 00:02:00 Module 2: Preparing & Priming A Combinational Skintype 00:03:00 Module 3: Applying Golden, Copper, Brown Eyeshadow Shades 00:09:00 Module 4: Applying Eyeliner on Eyeliner on Eyes with Slightly Hoodedness 00:03:00 Module 5: How to Curl Flat Lashes and Apply False Lashes 00:02:00 Module 6: Applying a Smoked Out Look on the Lower Lashline & Completing the Eye makeup Look 00:03:00 Module 7: Colour Correcting Dark Pigmentations 00:01:00 Module 8: Applying Foundation, Highlight & Contour a Medium to Tan Complexions 00:05:00 Module 9: Apply Bronzer Correctly 00:01:00 Module 10: Applying Cream Blush for More Glow 00:01:00 Module 11: Creating the Perfect 3D Glow Effect 00:01:00 Module 12: Creating Flawless Natural Looking Eyebrows 00:02:00 Module 13: Applying the Perfect Red Ombre Lips 00:03:00 Module 14: Fixing the Makeup plus Results & Bridal Photos 00:02:00 Makeup Look Part 2 Module 15: Skincare & Primer 00:03:00 Module 16: Create a Smokey Eyeliner 00:12:00 Module 17: Applying the Half Cut Crease Technique 00:08:00 Module 18: Face Makeup Application 00:07:00 Module 19: Cherry Red to Burgundy Ombre Lips & Results 00:04:00 Makeup Look Part 3 Module 20: Skin Prepping & Priming with Different Products 00:01:00 Module 21: Master the Cut-Crease Eyemakeup Technique 00:12:00 Module 22: Apply Eyeliner & Complete Cut-Crease Eye-Makeup 00:07:00 Module 23: Complete the Face Makeup 00:09:00 Module 24: Pink to Purple Ombre Lips and Results 00:03:00

CPD Accredited | Career Oriented Learning Modules | 24x7 Tutor Support | Lifetime Access

Body Massage: Body Massage Course Online Unlock the Power of Body Massage: Body Massage Course: Enrol Now! A Body Massage: Body Massage Course can be the best option for those who enjoy helping others and want to use their knowledge of the body to help people relax through various massaging techniques. This Body Massage: Body Massage Course teaches people how to perform various massage techniques. Body Massage: Body Massage Course is the art of relaxing the body's muscles by applying pressure in various ways. This is frequently beneficial in the treatment of pain, chronic conditions, stress, and relaxation. Why choose this Body Massage: Body Massage Course from the School of Health Care? Self-paced course, access available from anywhere in the world. High-quality study materials that are easy to understand. Body Massage: Body Massage Course developed by industry experts. After each module, there will be an MCQ quiz to assess your learning. Assessment results are generated automatically and instantly. 24/7 support is available via live chat, phone call, or email. Free PDF certificate after completing the Body Massage: Body Massage Course. [ Note: Free PDF certificate will provide as soon as completing the Body Massage: Body Massage Course] Body Massage: Body Massage Course Online This Body Massage: Body Massage Course consists of 10 modules. Course Curriculum of Body Massage: Body Massage Course Module 01: Health, safety and hygiene Module 02: Professional conduct, ethics and preparation Module 03: Classification of massage and the effleurage group Module 04: The petrissage group Module 05: The percussion and vibration groups Module 06: Massage routines Module 07: Adapting massage for specific conditions Module 08: Additional techniques Module 09: Mechanical massage Module 10: Introduction to sports massage Assessment Method of Body Massage: Body Massage Course After completing Body Massage: Body Massage Course, you will get quizzes to assess your learning. You will do the later modules upon getting 60% marks on the quiz test. Apart from this, you do not need to sit for any other assessments. Certification of Body Massage: Body Massage Course After completing the Body Massage: Body Massage Course, you can instantly download your certificate for FREE. The hard copy of the certification will also be delivered to your doorstep via post, which will cost £13.99. Who is this course for? Body Massage: Body Massage Course Online This Body Massage: Body Massage Course is suitable for anyone who wants to start a new career in Massage Therapy and gain relevant skills. This Body Massage: Body Massage Course is also suitable for anyone interested in gaining in-demand massage therapy skills to help launch a career as a massage therapy personnel or improve their business aptitude. Requirements Body Massage: Body Massage Course Online To enrol in this Body Massage: Body Massage Course, students must fulfil the following requirements: Good Command over English language is mandatory to enrol in our Body Massage: Body Massage Course. Be energetic and self-motivated to complete our Body Massage: Body Massage Course. Basic computer Skill is required to complete our Body Massage: Body Massage Course. If you want to enrol in our Body Massage: Body Massage Course, you must be at least 15 years old. Career path Body Massage: Body Massage Course Online The knowledge and skills you will gain through this Body Massage: Body Massage Course may lead you to a variety of career opportunities.

Overview This comprehensive course on Bridal and Occasional Makeup Artist Masterclass will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Bridal and Occasional Makeup Artist Masterclass 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 Bridal and Occasional Makeup Artist Masterclass. It is available to all students, of all academic backgrounds. Requirements Our Bridal and Occasional Makeup Artist Masterclass is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible on tablets and smartphones so you can access your course on wifi, 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 • 5 lectures • 03:23:00 total length •The Base: 00:47:00 •Eye Makeup: 00:50:00 •Lips, Cheeks and Brows: 00:47:00 •Special Considerations for Weddings and Events: 00:20:00 •Bridal & Special Occasion Makeup as a Business: 00:39:00

Overview This comprehensive course on Complete Makeup Training for Lips will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Complete Makeup Training for Lips 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 Complete Makeup Training for Lips. It is available to all students, of all academic backgrounds. Requirements Our Complete Makeup Training for Lips 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 • 15 lectures • 14:15:00 total length •Introduction: 00:01:00 •01 Disinfection and anaesthetic: 00:02:00 •02 Cream removal and drawing: 00:16:00 •03 white pen application: 00:05:00 •04 Check with client: 00:01:00 •05 The outline: 00:12:00 •06 Lower lip shade: 00:11:00 •07 Upper lip shading: 00:14:00 •08 Shade repeat lower lip: 00:09:00 •09 Shade repeat upper lip: 00:10:00 •10 Finish, balm and concealer: 00:01:00 •Retouch lower lip: 00:27:00 •Retouch upper lip: 00:26:00 •Resource - Complete Makeup Training for Lips: 00:00:00 •Assignment - Complete Makeup Training for Lips: 2 days, 12 hours

Hairdressing: Hairdressing Online If you want to learn about Hairdressing: Hairdressing course and become an expert in the field, you have arrived at the right place. Industry experts designed this Hairdressing: Hairdressing course to enable you to learn quickly and efficiently and at your own pace and convenience. Our Hairdressing: Hairdressing course offers an immersive and comprehensive training experience to equip you with the skills and knowledge necessary for success in the industry. This Hairdressing: Hairdressing course also emphasizes the importance of customer service, communication, and professionalism. You will learn how to interact with clients and provide them with the highest level of service. Upon completion of the Hairdressing: Hairdressing course, you will be well-prepared to launch your career as a Hair & Beard Barber. Whether you're looking to work in a barbershop or start your own business, our course will give you the skills and confidence you need to succeed. Apply now and start your journey to a rewarding career in the grooming industry. Special Offers of this Hairdressing: Hairdressing Course This Diploma of Hairdressing: Hairdressing Course includes a FREE PDF Certificate. Lifetime access to this Hairdressing: Hairdressing Course Instant access to this Hairdressing: Hairdressing Course Get FREE Tutor Support from Monday to Friday in this Hairdressing: Hairdressing Course Main Course: Diploma of Hairdressing Free Courses: Course 01: Hair & Beard Barbering Course 02: Salon Management [ Note: Free PDF certificate will provide as soon as completing the Hairdressing: Hairdressing course] Hairdressing: Hairdressing Online Industry Experts Designed this Hairdressing: Hairdressing course into 14 detailed modules. Assessment Method of Hairdressing: Hairdressing Online After completing each module of the Hairdressing: Hairdressing course, you will find automated MCQ quizzes. To unlock the next module, you need to complete the quiz task and get at least 60% marks. Certification of Hairdressing: Hairdressing Online After completing the MCQ/Assignment assessment for this Hairdressing: Hairdressing course, you will be entitled to a Certificate of Completion from Training Tale. Who is this course for? Hairdressing: Hairdressing Online People who are eager to pursue a career as professional barbers can choose this Hairdressing: Hairdressing course. Anyone can work as an independent stylist or might wind up cutting hair for celebrities if they do our Hairdressing course. Requirements Hairdressing: Hairdressing Online There is no specific requirement to enrol for this Hairdressing: Hairdressing course. However, you need to be over 16. Career path Hairdressing: Hairdressing Online Beautician Hair Stylist Hairdresser Makeup Artist Fashion Stylist Barber Hairdresser Certificates Certificate of completion Digital certificate - Included

Join our Microsoft Excel course and discover your hidden skills, setting you on a path to success in this area. Get ready to improve your skills and achieve your biggest goals. The Microsoft Excel course has everything you need to get a great start in this sector. Improving and moving forward is key to getting ahead personally. The Microsoft Excel course is designed to teach you the important stuff quickly and well, helping you to get off to a great start in the field. So, what are you looking for? Enrol now! You will Learn The Following Things: Learn strategies to boost your workplace efficiency. Hone your skills to help you advance your career. Acquire a comprehensive understanding of various topics and tips. Learn in-demand skills that are in high demand among UK employers This course covers the topic you must know to stand against the tough competition. The future is truly yours to seize with this Microsoft Excel. Enrol today and complete the course to achieve a certificate that can change your career forever. Details Perks of Learning with IOMH One-to-one support from a dedicated tutor throughout your course. Study online - whenever and wherever you want. Instant Digital/ PDF certificate 100% money back guarantee 12 months access Process of Evaluation After studying the course, an MCQ exam or assignment will test your skills and knowledge. You have to get a score of 60% to pass the test and get your certificate. Certificate of Achievement After completing the Microsoft Excel course, you will receive your CPD-accredited Digital/PDF Certificate for £5.99. To get the hardcopy certificate for £12.99, you must also pay the shipping charge of just £3.99 (UK) and £10.99 (International). Who Is This Course for? This Microsoft Excel is suitable for anyone aspiring to start a career in relevant field; even if you are new to this and have no prior knowledge, this course is going to be very easy for you to understand.  On the other hand, if you are already working in this sector, this course will be a great source of knowledge for you to improve your existing skills and take them to the next level.  This course has been developed with maximum flexibility and accessibility, making it ideal for people who don't have the time to devote to traditional education. Requirements There is no prerequisite to enrol in this course. You don't need any educational qualification or experience to enrol in the Microsoft Excel course. Do note: you must be at least 16 years old to enrol. Any internet-connected device, such as a computer, tablet, or smartphone, can access this online course. Career Path The certification and skills you get from this Microsoft Excel Course can help you advance your career and gain expertise in several fields, allowing you to apply for high-paying jobs in related sectors. Course Curriculum Unit 01: Excel from A-Z Course Introduction Excel from A-Z Course Intro 00:03:00 Excel Job Opportunities 00:03:00 Excel Job Types 00:04:00 Microsoft Excel Marketplace 00:04:00 What is Microsoft Excel? 00:04:00 Who is This Course For? 00:03:00 Unit 02: Getting Started With Excel Finding & Opening Excel 00:01:00 Excel's Start Screen 00:03:00 Explaining the Excel Interface 00:03:00 Excel Interface Continued 00:01:00 Excel Workbook vs. Excel Worksheet 00:02:00 Saving an Excel Document 00:04:00 Customizing the Quick Access Toolbar 00:02:00 Customizing the Excel Ribbon 00:03:00 Excel Shortcut Keys 00:02:00 Unit 03: Values, Referencing and Formulas Creating Excel Labels 00:03:00 Entering Numeric Values in Excel 00:03:00 Formatting Date Values in Excel 00:05:00 Building Basic Formulas in Excel 00:05:00 Order of Operations 00:06:00 Relative vs. Absolute Cell References 00:07:00 Unit 04: Intro to Excel Functions Excel Functions Explained 00:03:00 The SUM() Function 00:08:00 The MIN() & MAX() Function 00:04:00 The AVERAGE() Function 00:02:00 COUNT() Functions 00:05:00 Unit 05: Adjusting Excel Worksheets Moving & Copying Data 00:07:00 Insert & Delete Rows and Columns 00:05:00 Adjusting the Width and Height of Cells 00:05:00 Hiding and Unhiding Excel Rows and Columns 00:04:00 Renaming, Moving & Deleting Excel Worksheets 00:05:00 Adding Protection to Specific Cells 00:04:00 Protecting the Structure of a Workbook 00:02:00 Adding a Workbook Password to Open File 00:02:00 Unit 06: Visually Pleasing Cell Formatting Formatting Fonts and Cell Background Color 00:05:00 Adding Cell Borders 00:05:00 Formatting Data Appropriately 00:05:00 The Magic behind Excel's Format Painter 00:03:00 Creating Styles for Formatting Efficiency 00:06:00 Merging Cells for a Cleaner Look 00:03:00 The Power of Conditional Formatting 00:06:00 Unit 07: How to Insert Images and Shapes! Grab User's Attention using Illustrations 00:09:00 Customizing Icons 00:05:00 Create Compelling Graphics with SmartArt 00:06:00 Unit 08: Visualize Data with Charts The Commonly Used Column Chart 00:03:00 Changing the Chart Design.mp4 00:02:00 Formatting Elements of a Chart 00:06:00 Modifying the Data, Type & Location of a Chart 00:06:00 Unit 09: Excel's Printing Options Print Preview Options 00:04:00 Excel's Page Layout View 00:07:00 Printing a Specific Range of Cells 00:03:00 Converting Spreadsheets to PDF Files 00:02:00 Unit 10: Benefits of Using Excel Templates Why Create an Excel Template 00:01:00 How to Create an Excel Template 00:05:00 Unit 11: Working with Excel Datasets How to Prepare Data for Analysis 00:04:00 How to Sort Data in Excel 00:03:00 Multi-Level Sorting 00:03:00 Custom Sorting Datasets in Excel 00:02:00 Applying Filters to Datasets 00:05:00 Creating Subtotals within a Dataset 00:06:00 Converting Datasets into Tables 00:06:00 Little Slice of Pie Charts 00:05:00 Finding & Removing Duplicate Values 00:07:00 Unit 12: Excel Database Functions The SUMIF() Function 00:09:00 The DSUM() Function 00:08:00 The DSUM() Function Cont. 00:07:00 The SUBTOTAL() Function 00:06:00 Unit 13: Excel Data Validation What is Excel Data Validation? 00:02:00 Creating a Drop Down List with Data Validation 00:07:00 Different Types of Excel Data Validation 00:06:00 Adding Custom Alerts to Data Validation 00:07:00 Creating a Dynamic Drop Down List 00:03:00 Complex Validation: Dependent Drop Down List! 00:09:00 Unit 14: Excel PivotTables Creating an Excel Pivot Table 00:06:00 Modifying Excel PivotTables 00:06:00 Grouping & Filtering PivotTable Data 00:06:00 Drilling Down into PivotTable Data 00:02:00 Creating Pivot Charts & Utilizing Slicers 00:08:00 Unit 15: Excel's PowerPivot Add-In What is PowerPivot? 00:04:00 Activating the Excel PowerPivot Add-In 00:02:00 Creating Relationships between Data Tables.mp4 00:06:00 Using Data Models to Create PivotTables 00:05:00 How to Create PowerPivot KPI's 00:08:00 Unit 16: Excel's Conditional Functions Excels IF Function 00:05:00 IF() Function with AND() Criteria 00:05:00 IF() Function with OR() Criteria 00:05:00 Nesting Multiple IF() Functions 00:07:00 The COUNTIF() Function 00:04:00 Key Benefits of Named Ranges 00:04:00 Unit 17: Excel's Lookup Function VLOOKUP() Function 00:09:00 The Beauty of Excel's IFERROR() Function 00:04:00 HLOOKUP() Function 00:06:00 The INDEX Function 00:05:00 MATCH() Function 00:05:00 INDEX() and MATCH() Combined 00:05:00 Two-Way Lookup with INDEX() and MATCH() 00:04:00 Unit 18: Text Based Functions in Excel LEFT(), RIGHT() and MID() Function 00:07:00 Extracting Specific Text using LEN() & SEARCH() 00:13:00 Combining Text with CONCATENATE() 00:06:00 Quick Tips & Other Text Based Functions 00:06:00 Unit 19: Auditing Formulas and Views in Excel Tracing Precedents & Dependents in Formulas 00:04:00 Showing Formulas 00:02:00 Grouping Data 00:03:00 3D Referencing in Formulas 00:05:00 Utilizing the Watch Window in Excel 00:03:00 How to Freeze Panes in Excel 00:03:00 Unit 20: Excel's 'what If?' Tools Excel's Scenario Manager Tool 00:06:00 Goal Seek in Excel 00:06:00 Compare Results with Excel Data Tables 00:04:00 Solver Tool 00:11:00 Unit 21: Welcome to Excel VBA The Power Behind Excel VBA 00:03:00 A Look Inside the Visual Basic Editor (VBE) 00:04:00 Recording a Macro 00:09:00 Saving & Opening a Macro-Enabled Workbook 00:02:00 Unit 22: The VBA Language Modules and Procedures 00:07:00 Objects, Methods and Properties 00:06:00 Excel VBA Variables 00:05:00 Unit 23: Writing VBA Code Referencing a Range 00:13:00 InputBox & MsgBox 00:06:00 Using Variables in VBA Code 00:05:00 If Then Else Statement 00:10:00 Worksheet Functions inside VBA 00:08:00 Creating User Defined Functions 00:09:00 User Defined Functions within VBA Scripts 00:06:00 Unit 24: Important VBA Tools and Logic Find Last Row of Data 00:06:00 Find Last Column of Data 00:03:00 With Statement 00:05:00 Debugging & Error Handling 00:07:00 Debugging & Error Handling Cont. 00:07:00 Unit 25: Excel VBA Loop For Next Loop 00:09:00 Do Until Loop 00:06:00 For Each Loop 00:04:00 Unit 26: Triggering Macros Assigning Macros to Shapes 00:04:00 Form Controls vs ActiveX Controls 00:08:00 Worksheet Events 00:04:00 Workbook Events 00:03:00 Fun with VBA Events! 00:07:00 Unit 27: Excel User Forms Creating an Excel UserForm 00:03:00 Adding Controls to UserForms 00:10:00 How to Show an UserForm 00:03:00 Passing TextBox Values to Desired Cells 00:07:00 Passing Option Buttons to Desired Cells 00:07:00 UserForm ComboBoxes 00:08:00 Clearing Values from UserForm Controls 00:03:00 How to Close an UserForm 00:02:00 UserForms and Protected Sheets 00:05:00 Unit 28: Starting a Career in Excel Creating an Excel Resume 00:05:00 Getting Started with Freelancing 00:06:00 How to Become an Excel Freelancer 00:05:00 Top Freelance Websites 00:05:00 How to Get Your First Client 00:08:00 Personal Branding 00:07:00 Networking Do's and Don'ts 00:04:00 Importance of Having a Website 00:04:00 Resources Resources - Microsoft Excel 00:00:00