Diet and nutrition are the two components of a healthy body. Enrich your knowledge of these key ingredients from the Diet And Nutrition Course. The lessons from this course will help you keep your body in the top form and also assist you in pursuing a career in the nutrition industry. From the Diet And Nutrition Course, you will receive a clear understanding of diet and nutrition. The engaging modules will provide you with valuable information on energy metabolism and food digestion. You will pick up the strategies for losing weight and building muscles. This course will introduce you to the optimal diet for athletes. You will develop the expertise to deal with your customers and provide them with proper diet plans. This Diet And Nutrition Course will elevate your knowledge of diet and nutrition. You will not only develop your understanding but also receive a valuable certificate. This certificate will help you build an impressive resume. Join now! Learning Objectives Get introduced to the theories of nutrition Enrich your knowledge of energy metabolism and food digestions Grasp the techniques of losing weight Learn the process of building muscles Deepen your understanding of the nutrition and diets suitable for athletes Develop the skills to deal with the customers Who is this Course for? This Diet And Nutrition Course is ideal for aspiring nutritionists or those who wish to gain the relevant skills and knowledge to fast track their careers. It is for those who have little or no knowledge of the principles of diet and nutrition or those who are new to the field and want to test their skills and knowledge. There are no entry requirements for this course; however, an eye for detail and a creative mind is essential. Entry Requirement This course is available to all learners of all academic backgrounds. A good understanding of the English language, numeracy, and ICT are required to attend this course. 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 £4.99 and the hard copy for £9.99. Also, you can order both PDF and hardcopy certificates for £12.99. Career path On successfully completing the Diet And Nutrition Course, learners can progress to a more advanced program from our course list. Career opportunities in this field include freelancing or working in-house, within a range of professional settings, with the opportunity to earn a high salary. Related professions in this industry include: Nutritionist Dietitian Personal trainer Fitness instructor Sports coach Course Curriculum Diet And Nutrition Diploma Promo Video 00:03:00 Introduction Introduction & What You Will Learn 00:03:00 The Roles & Responsibilitites Of A Diet Coach 00:02:00 Nutrition Theory What Is Nutrition 00:01:00 Meal Planning Explained 00:04:00 Calories Explained 00:04:00 Macronutrients Explained 00:01:00 What Is Protein: Explained 00:02:00 How Much Protein Does Your Body Need 00:04:00 What Is Dietary Fat: Explained 00:03:00 How Much Fat Does Your Body Need 00:04:00 What Are Carbohydrates: Explained 00:03:00 The Different Types Of Carbs 00:05:00 How Many Carb Does Your Body Need 00:03:00 Meal Timing Explained 00:01:00 When & How Often Should You Consume Protein 00:04:00 When & How Often Should You Consume Carbs 00:02:00 When & How Often Should You Consume Fat 00:01:00 Food Sources Explained 00:02:00 Protein Composition 00:02:00 Carbohydrate Composition 00:03:00 Fat Composition 00:01:00 Energy Metabolism Energy Metabolism Explained 00:02:00 Aerobic vs Anaerobic Energy Metabolism 00:02:00 Food Digestion Digestion Introduction 00:03:00 Carbohydrate Digestion 00:02:00 Protein Digestion 00:02:00 Fat Digestion 00:02:00 Working With Clients Client Assessment 00:01:00 Client Interview 00:04:00 How To Set SMART Dieting Goals 00:06:00 How To Design Your First Diet Plan 00:09:00 Body Mass Index Explained 00:03:00 Helping Clients Lose Weight The Science Of Successful Weight Loss 00:05:00 Determining Calorie Needs 00:03:00 How To Take Diet Breaks Correctly 00:05:00 Breaking Through Fat Loss Plateaus 00:04:00 Explaining Unexpected Weight Changes 00:03:00 Is Starvation Mode Real? 00:03:00 Adjusting Your Diet For Weight Loss 00:05:00 Helping Clients Build Muscle How To Create A Muscle Building Diet 00:04:00 The Perfect Pre-Workout Meal 00:04:00 The Perfect Post-Workout Meal 00:02:00 The Best Muscle Building Foods 00:02:00 Foods To Boost Testosterone 00:04:00 Famous Diets Explained Famous Diets Introduction 00:01:00 Gluten Free Diet Explained 00:03:00 Paleo Diet Explained 00:04:00 Low Carb Diet Explained 00:03:00 Intermittent Fasting Explained 00:03:00 Vegan Diet Explained 00:05:00 Ketogenic Diet Explained 00:06:00 Optimal Diets For Athletes Athlete Diets Introduction 00:01:00 Strength Training 00:02:00 Endurance Training 00:02:00 Ball Sports & Martial Arts 00:02:00 Supplements Supplement Introduction 00:01:00 Whey Protein 00:06:00 BCAAs 00:04:00 Creatine 00:04:00 Fish Oil 00:03:00 Glutamine 00:05:00 Vitamins & Minerals Why Mulitvitamins arent a good 00:02:00 What happens when you overdoese on vitamins 00:04:00 Vitamin A Supplements 00:03:00 Vitamin B Supplements 00:02:00 Vitamin C Supplements 00:03:00 Vitamin D 00:02:00 Vitamin E 00:01:00 Vitamin K 00:01:00 9 Calcium supplements copy 00:03:00 Magnesium 00:01:00 Phosphorus 00:01:00 Potassium 00:01:00 Sodium 00:01:00 Copper 00:01:00 Iron 00:01:00 Zinc 00:02:00 Course Certification Order Your Certificates or Transcripts 00:00:00
Are you looking for a proper guideline to start your career as a freelancer in a sound bite? Do you want to boost you up learning the key issues of outsourcing? If so, take a look at our Outsourcing Training Course course. Its precise contents will assist you in understanding all you need to know about this field. The course guides you on how to improve your efficiency cutting down costs, boosting up products development, and allowing to focus on the core competencies for your individual or business growth. It instructs you to choose the exact task based on your skills, interest, and passion. Besides, being an entrepreneur, you will get the best and effective service form the expert all over the world. The course mainly focuses on how you utilize all these advantages precisely to establish your career. What you'll learn You'll know how to start outsourcing RIGHT NOW - even if you're brand new You'll know how to properly hire from different platforms You'll know how to manage your VAs and Outsourcers work You'll know how to pay either hourly or flat rates - depending on the job done You'll know how to hire professional VAs to do your work You'll know how to get the best worker out of a group of 3-5 qualified individuals You'll know how to have efficient 5 minute interviews with your potential workers You'll know common pay rates You'll know the schedule and time it'll take (on average) to hire an employee You'll know how to collaborate with your workers Requirements You should know how to use a PC at a beginner level Introduction Introduction FREE 00:01:00 The Outsourcing Platforms 00:07:00 What to Outsource 00:01:00 Outsourcing on Fiverr 00:13:00 Outsourcing on UpWork 00:31:00 Outsourcing with Management + Questions 00:08:00 Outsourcing with Freelancer 00:09:00 Outsourcing with Craigslist 00:03:00 Common Pay Rates 00:03:00 Hourly vs Flat Rate 00:07:00 Hiring Approach 00:07:00 Hiring Schedule 00:06:00 Efficient Interviews 00:02:00 Pro Hire 00:06:00 How to Collaborate 00:04:00 Changing Scope & Handling Difficulties 00:10:00 Assessment
Dive into the world of organic chemistry with the Complete Organic Chemistry Demystified course. This course will provide you with an overall idea of organic chemistry. Within no time, you will be able to build a solid foundation in this area. Through this Complete Organic Chemistry Demystified course, you will learn how to draw organic molecules. The informative modules will educate you on acid-base reactions. You will develop an in-depth understanding of geometry, nomenclature, conformations and more. In addition, you will receive detailed lessons on substitute reactions and elimination reactions. This course will also educate you on synthetic techniques. This Complete Organic Chemistry Demystified course is the perfect place to explore different aspects of organic chemistry. If you aspire to pursue a career in the relevant fields, this course is the ideal training ground for you. Enrol now! Learning Objectives Get introduced to the basic steps of drawing organic molecules Enrich your knowledge of acid-base relations Learn the principles of geometry and nomenclature Develop a clear understanding of conformations Deepen your understanding of substitute reactions and elimination reactionsGain in-depth knowledge of synthetic techniques Who is this Course for? This Complete Organic Chemistry Demystified course is ideal for aspiring professionals or those who wish to gain the relevant skills and knowledge to fast track their careers. It is for those who have little or no knowledge of the principles of organic chemistry or those who are new to the field and want to test their skills and knowledge. There are no entry requirements for this course; however, an eye for detail and a creative mind is essential. Entry Requirement This course is available to all learners of all academic backgrounds. A good understanding of the English language, numeracy, and ICT are required to attend this course. 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 £4.99 and the hard copy for £9.99. Also, you can order both PDF and hardcopy certificates for £12.99. Career path Upon successfully completing the Complete Organic Chemistry Demystified course, learners can progress to a more advanced program from our course list. Career opportunities in this field include freelancing or working in-house, within a range of professional settings, with the opportunity to earn a high salary. Related professions in this industry include: Chemistry teacher Food scientist Forensic analyst Environmental scientist Materials scientist Analytical chemist Pharmacologist Course Curriculum Module 01: About the Course Introduction 00:02:00 Module 02: Drawing Organic Molecules How to read bond-line drawings 00:18:00 How to draw bond-line drawings 00:18:00 Identifying formal charges 00:22:00 Finding lone pairs that are not drawn 00:23:00 Module 03: Resonance What is resonance? 00:05:00 Drawing resonance structures (part 1) 00:40:00 Formal charges in resonance structures 00:19:00 Drawing resonance structures (part 2) 00:25:00 Recognizing patterns 00:30:00 The relative importance of resonance structures 00:19:00 Module 04: Acid-Base Reactions Introduction to acid - base 00:03:00 Charged atoms 00:08:00 Resonance 00:11:00 Induction 00:09:00 Orbitals 00:03:00 Charged atoms - Resonance - Induction - Orbitals 00:07:00 Showing an acid-base mechanism 00:14:00 Acid-Base equilibrium position 00:06:00 Module 05: Geometry Orbitals 00:15:00 Goemetry of orbitals 00:15:00 Impact of resonance on geometry 00:01:00 Module 06: Nomenclature Introduction to nomenclature 00:03:00 Functional group 00:07:00 Unsaturation 00:04:00 Parent 00:09:00 Substituents 00:10:00 'cis' - 'trans' stereoisomerism 00:04:00 'E' - 'Z' stereoisomerism 00:04:00 Localizing substituents in parent chain 00:12:00 From structure to name 00:20:00 Module 07: Conformations Introduction to conformations 00:02:00 Newman projection 00:10:00 Relative stability of Newman projections 00:08:00 Drawing chair conformations 00:02:00 Drawing substituents in chair conformations 00:11:00 Ring flipping 00:10:00 Comparing stability of chair conformations 00:10:00 Module 08: Configurations Introduction to configurations 00:01:00 Locating stereocenters 00:04:00 Determining the configuration of a stereocenter 00:18:00 Nomenclature 00:12:00 Enantiomers 00:08:00 Diastereomers 00:05:00 Meso compounds 00:04:00 Fischer projections 00:11:00 Module 09: Mechanisms Introduction to mechanisms 00:02:00 Nucleophiles and electrophiles 00:09:00 Arrows used for mechanisms 00:14:00 Carbocation 00:15:00 Module 10: Substitution Reactions SN1 SN2 mechanisms 00:10:00 Factor #1: the electrophile 00:06:00 Factor #2: the nucleophile 00:04:00 Factor #3: the leaving group 00:05:00 Factor #4: the solvent 00:05:00 Combining all 4 factors 00:09:00 Module 11: Elimination Reactions Introduction to elimination reactions 00:02:00 E1 mechanism 00:08:00 E2 mechanism 00:20:00 Module 12: Substitution vs Elimination Introduction to substitution vs elimination 00:03:00 Determining the function of the reagent 00:04:00 Identifying the mechanism(s) 00:11:00 Predicting regiochemical and stereochemical outcomes 00:16:00 Module 13: Addition Reactions Introduction to addition reactions 00:01:00 Regiochemistry 00:05:00 Stereochemistry 00:18:00 Hydrogenation: adding H-H 00:07:00 Hydrohalogenation: adding hydrogen halide, H-X 00:09:00 Hydrobromination : adding H-Br 00:09:00 Hydration: adding H-OH 00:12:00 Adding Br and Br 00:05:00 Halohydrin formation: adding Br and OH 00:08:00 'Anti' dihydroxylation: adding OH and OH 00:07:00 'syn' dihydroxylation : adding OH and OH 00:04:00 Ozonolysis 00:03:00 Reactions summary 00:01:00 Module 14: Synthesis Techniques One-step synthesis 00:03:00 Combining reactions: changing the position of a leaving group 00:03:00 Combining reactions: changing the position of a double bond 00:02:00 Combining reactions: introducing functionality 00:03:00 Module 15: Wrapping Up and Bonus Thank you for enrolling and announcing part 2 00:01:00 Certificate and Transcript Order Your Certificates or Transcripts 00:00:00
Do you long for transforming your thoughts and plan a reality? Are you inspired to create innovative products but you don't know where and how to start? Or would you just like to get into outsourcing to become more efficient? If yes, then the Diploma in Outsourcing is perfect for you! Description: In this course, you will develop an understanding of the common characteristics of being an outsourcer. You will gain a good knowledge of the development process and the planning process involved in outsourcing. You will also have a good understanding of the business ecosystem and knowledge of successful business models. Moreover, this is your opportunity to utilise your creativeness with recently gained specialised skills to figure out how to create innovative and useful products. Who is the course for? Professionals who want to learn about outsourcing. Beginners who have an interest in learning how to become effective through outsourcing. Entry Requirement: This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. Assessment: At the end of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After you have successfully passed the test, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. PDF certificate's turnaround time is 24 hours and for the hardcopy certificate, it is 3-9 working Why choose us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos/materials from the industry leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally recognised accredited qualification; Access to course content on mobile, tablet or desktop from anywhere anytime; The benefit of career advancement opportunities; 24/7 student support via email. Career Path: The Diploma in Outsourcing will be very beneficial and helpful to individuals who are interested in designing and creating products who also want to venture into new business. Diploma in Outsourcing WHY WOULD YOU OUTSOURCE? 00:15:00 DECIDING WHAT TO OUTSOURCE 00:30:00 FINDING CONTENT WRITERS 00:30:00 GRAPHIC DESIGNERS, WEBSITE DESIGNERS, ETC 00:30:00 CODERS AND PROGRAMMERS 01:00:00 VIRTUAL ASSISTANTS AND CUSTOMER SERVICE 00:30:00 OUTSOURCING SEO & PROMOTION 00:15:00 FREELANCE SITES AND HOW THEY WORK 01:00:00 OUTSOURCING ISSUES 00:30:00 Mock Exam Mock Exam-Diploma in Outsourcing 00:20:00 Final Exam Final Exam-Diploma in Outsourcing 00:20:00 Order Your Certificate and Transcript Order Your Certificates and Transcripts 00:00:00
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
Overview Uplift Your Career & Skill Up to Your Dream Job - Learning Simplified From Home! Kickstart your career & boost your employability by helping you discover your skills, talents and interests with our special Freelancers Course. You'll create a pathway to your ideal job as this course is designed to uplift your career in the relevant industry. It provides professional training that employers are looking for in today's workplaces. The Freelancers Course is one of the most prestigious training offered at StudyHub and is highly valued by employers for good reason. This Freelancers Course has been designed by industry experts to provide our learners with the best learning experience possible to increase their understanding of their chosen field. This Freelancers Course, like every one of Study Hub's courses, is meticulously developed and well researched. Every one of the topics is divided into elementary modules, allowing our students to grasp each lesson quickly. At StudyHub, we don't just offer courses; we also provide a valuable teaching process. When you buy a course from StudyHub, you get unlimited Lifetime access with 24/7 dedicated tutor support. Why buy this Freelancers? 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 Freelancers 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 Freelancers 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 Freelancers does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Freelancers 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 Freelancers is a great way for you to gain multiple skills from the comfort of your home. Course Curriculum Module 01: Introduction to Brand Management Introduction to Brand Management 00:50:00 Module 02: Introduction to Time Management Introduction to Time Management 00:45:00 Module 03: Introduction to Entrepreneurship & Financial Independence Introduction to Entrepreneurship & Financial Independence 00:45:00 Module 04: Introduction to Emotional Intelligence Introduction to Emotional Intelligence 00:45:00 Module 05: Introduction to Social Media Marketing Introduction to Social Media Marketing 00:30:00 Module 06: Introduction to Sales & Negotiations Introduction to Sales & Negotiations 01:00:00 Module 07: Introduction to Business Formation & Management Introduction to Business Formation & Management 00:40:00 Module 08: Introduction to Principles of Marketing Introduction to Principles of Marketing 00:45:00 Module 09: Introduction to Principles of Accounting Introduction to Principles of Accounting 00:45:00 Module 10: Customer Service Relations Customer Service Relations 00:35:00 Module 11: Critical Creative Thinking Critical/Creative Thinking 00:40:00 Module 12: Problem Design Solving Problem Design & Solving 00:30:00
In this course, our focus is to create an entire foliage pack completely made in Blender-one of the top open-source and free 3D modeling software out there. You will learn how to create 12 different foliage types with over 30 variations, including plants, grass, water lilies, and reeds; you will also learn how to integrate them into UE5 (Unreal Engine 5).
Description This Fiverr Training Course is a practical approach, guiding you to understand what is Fiverr all about, how to create a Gis, how to creat and configure your Fiverr Account, how to Generate Traffic to your profile, how to identify Hot Selling Gigs. The course will also explain in detail about how to become a successful Freelancer. You will get the very basics to the most advanced ninja strategy that will allow you to go out there and make a 5 figure side income from Fiverr alone. This course will allow you to have success even as a beginner. The course will teach the best practice, create excellent gigs and sell them. Also, this will allow you to make money as a freelancer, have an internet based income stream and allow you to work from anywhere you want. 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? Fiverr Training 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 Fiverr Training 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. Module: 01 1. Introduction FREE 00:01:00 2. The Big Picture 00:11:00 3. Register on Fiverr 00:01:00 4. What a Buyer Sees on Fiverr 00:19:00 5. Dashboard Breakdown 00:10:00 6. Fiverr Levels 00:07:00 Module: 02 7. Success Hack For Your Gigs to Sell 00:09:00 8. Fiverr's Cut is More Than Fair 00:02:00 9. Fiverr No No's 00:04:00 10. Top Selling Gigs on Fiverr 00:09:00 11. Optimizing Your Fiverr Gigs 00:22:00 12. Optimize Your Profile to Rank Higher in Fiverr 00:08:00 Module: 03 13. How to ALWAYS Get 5 Star Reviews 00:02:00 14. 100 Clicks a Day 00:09:00 15. 100 Clicks A Day (Email's The Cornerstone) 00:03:00 16. The Attractive Character Overview 00:10:00 17. Attractive Character II 00:18:00 18. Email Sequence Explanation 00:01:00 Module: 04 19. Soap Opera Sequence 00:13:00 20. Seinfeld Email Sequence 00:11:00 21. Autoresponder & Email Examples 00:25:00 22. What is a Squeeze 00:05:00 23. Squeeze Page Secrets 00:08:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00
Level 5 QLS Course | 150 CPD Points | Advanced Learning Materials | Lifetime Access | Tutor Support