254 Freelancing courses in Cardiff delivered Online

Course Description Freelance writing is the practice of writing for money, in its simplest state. Freelance writers produce whatever written text is needed by their clientele, generally at home in their own office, for money. If you want to be freelance writer or want to get the success keys, you are welcome to join Freelance Writing Course. You will gain the skills necessary to thrive in the freelance writing world. Learn the secret self-promotion tactics of a seasoned freelancer quickly. Feel motivated and full of self-belief in a new home based career. You will learn everything you need to know about magazine article and travel writing, ghost writing, genre fiction writing, nonfiction book writing, children's book writing, to effective copy writing, and much more. What's In the Course? Discover why I am the right teacher for you. Indeed, I may be the ONLY writing teacher out there who has actually made a good living from writing. Most teachers either live in dusty classrooms teaching theory, or are so called 'gurus' who have no real world experience and yet spout even more theory from behind a blog or a flashy website. Not me, I'm the real deal. I've been making a living from freelance writing for over 25 years, online and offline - so I know how it's done, how it works, and how to make a shed-load of money doing it. Let me show you the best attributes to develop to make your new career a certainty. Talk to me about your problems within the course and let me help you gain the right mindset, attitude, and motivation. I'll be candid and assist you as much as is humanly possible. Plus, I'll be upfront about the money you can make, which is sometimes a lot more than you'd think! The key to making freelance writing work is to create multiple streams of income, so that you're getting a constant flow of money coming in from all kinds of writing work: magazine articles, travel writing, ghosting writing, editing jobs, writing fiction and nonfiction, getting published by the trade AND/OR self publishing certain things. The trick is to diversify and not rely totally on just one form of income. I'll explain fully how that is done effectively at the beginning of the course. Many new writers don't fully appreciate how to run a lucrative business. Basically writing for a living is a business too - and you need to approach it like one. In one crucial set of videos I explain how to plan and strategize your success and use priorities and measurement of your activities to maximize your earning potential. Plus tips on how to reduce your taxes and properly manage your finances. Writing success is about managing your activities - daily - and responding to feedback. My course ensures you don't get caught in a rut and that you respond quickly to the demands that writing for a living will engender. Included are downloadable activity sheets that will help you identify the best paying jobs. More than any other freelance business, you are a product of your own destiny when it comes to writing. You decide on what you want. You decide what you want to do with your time. You are the master of your universe - and you reap the rewards of true independence. During the course I explain how your mindset is your best friend, your best asset, and your key to true success. It's what is in your heart that matters - and I explain why. After this master class in self management I then go on introduce the concept of Practical Cash Creation. This detailed module explains the reality of writing for a living and what it means, how it can impact your life and those around you, how making money changes your life - and your partner's - all for the good. There are more downloadable income to activity schedules and spreadsheets in these modules to help you chart your progress and track your journey to success. Finally we reach the actual meat and potatoes of the course - actual money making activities explained in detail: how actual cash is generated from a myriad of sources. The information in these videos will literally blow you away. Never in one place have so many secrets been laid bare, especially about an industry normally shrouded in secrecy. Now it's no longer necessary for you to learn the hard way - all by yourself and over a long period of time (years!) because I have done all that FOR YOU. All the information you need is here. All the right tips and tactics that work are ALL HERE. Just for you. Writing for Magazines is traditionally seen as the freelancers main income source and the subject receives its full attention from me. The fact is, magazine articles may only make up a small part of your overall income but everything you learn about pitching for work will help sharpen your freelance writing skills. In this series of lectures I help you with Sample Query letters, assistance choosing topics that can't fail to have an editor salivating and a market listing to die for. Non Fiction Writing is covered in a series of SEVEN videos that show you how to construct sure-fire submissions to publishers on all kinds of books: science, fashion, history, whatever you like. You see the thing is that you don't have to write entire books to get paid to write them. Better to pitch nonfiction ideas to publishers FIRST and then let them commission you to write them. This is how true professionals work - and I show you the exact method by which you can compete and win with ease. Again I include an up to the minute listing of nonfiction publishers who are desperate for new book ideas from you. Writing Genre Fiction for big money is the dream of almost all new authors. But how is this achieved? Look no further. Over EIGHT info packed videos and FOUR full-length e-books, I explain how to write effective romance, thrillers, fantasy, horror, science fiction and cross-genre fiction for the modern marketplace, whether you're targeting traditional publishers or you want to self publish on Amazon. This module alone is worth far more than the super low price I'm asking for this extraordinary course. You won't believe what you get! Writing for Children is another favorite choice among new authors who sense there is much money to be made from spinning short tales for kids. It is true that the children's market is huge and lucrative but, do you really have what it takes to be a winner in this field? This special SEVEN part lecture series will put you on the right track. Compiled with the help of a multi-published children's author, this section alone is super valuable to any writer's career. Includes great instruction on technique and comprehensive market listing of children's book publishers Writing for the Corporate World has always been a great fallback for me. If ever there's a market that's always hungry, it's the business world. But many people misunderstand how most companies go about attracting freelance writers... because mostly they don't. We writers often have to make the first move. This section gives you the foolproof strategy I have always used to get business work. It's quick, easy, and costs nothing - but the pay is out of this world! Learn the one trick I present in this eye-popping SIX part section and you'll always be wealthy! Travel Writing - the dream ticket. What could be more exotic and glamorous? Writing travel articles is a bit like being James Bond without the gun! But what do travel magazines really want? What do travel book publishers need? In this wonderful new section I give you the facts. Everything you need to know about writing compelling articles, plus advice on how to get holiday gigs, and how best to do research on location and take photos that will become your way into the big time! Includes a complete list of travel writing publishers and high paying magazine markets. Becoming a Ghost Writer is about getting it all: money without the hassle of being a touring author. Honestly, if you're looking for sure-fire income, there is never a shortage of people looking for ghost writers. And it's incredibly well paid. Your biggest hurdle is finding the right kind of clients, by which I mean the PAYING ones. Only one in ten ghost writing clients want to pay you - even though they will lie and tell you they'll pay you later, which they often won't. This section is all about using business skills to attract paying clients, how to construct ghost writing contracts and how to do a great job quickly AND get paid UPFRONT. Getting Rich as a Copywriter is an ambition like no other. As we speak it is possible to spend up to $2000 on a copywriting course ALONE. But here, within Secrets of a Freelance Writer, over EIGHT packed lectures, you get every piece of information on copywriting you'll ever need. Don't waste your money on hack copywriters who have to sell their overpriced courses to make their mortgage payments. Find out everything you need to know from me, a freelancer - and a nice guy - who has used advanced copywriting skills to build a million dollar empire over the last decade and a half. Get in the know - and quickly! Self Publishing Online is now a necessary skill for all new writers. You simply can't survive as a credible author these days without having an online presence and a means by which to sell you own books. Many traditional authors are making the switch to digital author simply because the royalties publishers pay are too low. Amazon pays 70% to 90%. Traditional publisher pay 10%. It's easy to see why the majority of new authors now CHOOSE self publishing over the long and often disappointing slog of getting an agent then a literary deal where you'll end up barely able to pay the rent and bills. Learn how to self publish online like a professional and watch the money come rolling in! What are you waiting for? Offline Self-Publishing too is still a valid way of making cash quickly - if you know how to do it properly. There are many pitfalls to vanity publishing and you don't want to do that. But if you're a teacher, a coach, or a speaker then publishing your own book in a limited POD run to can be earning money you would normally be leaving on the table. In this four part section, let me show you the best advice for self publishing offline in this digital age. Includes downloadable resources. Grants and Funding for Writers. Did you know there are individuals, government departments, and corporations who regularly give money to authors, writers and poets? Getting grants and funding can be a useful tool to helping your bank balance and your kudos rating but many artists struggle over where and how to begin with this minefield of possibilities. This special section takes the mystery out of getting grants and applying for art funding. Helping Other Writers is one major key to getting wealthy as an author. As the number of wordsmiths taking themselves seriously these days, the larger the market grows for people who need help, help only YOU can give. You may not have considered this as a market before. You may not have thought yourself good enough. No matter. This unique look at cash creation shows you, over TEN fact filled lectures exactly how to make a great living simply helping other writers to succeed. And it's easy to attract the work and keep getting gigs for as long as you like! Self Promotion is necessary but need not be hard. Many writers don't want to promote themselves and then are overwhelmed by all the possibilities, many of which are a waste of time. Let me show you the best ways to promote yourself - the ones that work - so you can save time and get on with what really matters: the writing. Over this extraordinary FIVE part section - the likes of which you've never seen - I'll give you the lowdown on promotion tactics that make money and make sure you benefit from your new career. In the Conclusion, we look at maintaining a freelance career, which is all about combining self belief and proper business practice with writing. The fact is you don't need to be the best writer in the world to make a living as an author, a copywriter, a ghost writer or even a magazine article writer. Your enthusiasm and your dedication will take you a lot further than your talent. Freelance Writing is a dream job where you are rich, independent and FREE. Come join me. Let me show you how it's done! As well as giving all the information about writing for a living you could ever need, this unique course presents a step-by-step, motivational program for personal writing success, whatever your level of expertise. All you need is your enthusiasm and a willingness to learn and you will begin a new life of independence and freedom within days of taking this fun and insightful study aid. GO FOR IT! Join me now. Introduction to Freelance Writing Am I The Right Teacher For You? You Betcha! FREE 00:01:00 What You Need To Succeed FREE 00:02:00 Your Key is Your Attitude FREE 00:02:00 How Much Money Are We Talking Here? FREE 00:01:00 Creating Multiple Streams of Income The Main Point of This Course 00:02:00 Strategy and Measurement 00:02:00 Setting Your Priorities 00:02:00 Mindset of the Freelancer Mindset 00:02:00 Heart of Gold, Pot of Gold 00:02:00 Acquiring The Very Best Attitude 00:02:00 Practical Cash Creation Practical Cash Creation 00:01:00 The Reality of Writing for a Living 00:02:00 Activity To Income Schedule 00:00:00 Your Daily Writing Activities 00:00:00 Tracking Your income Tracking Your Income ONE 00:02:00 Tracking Your Income TWO 00:01:00 Income Tracking Sheet 00:00:00 Freelancer Spreadsheet Template 00:00:00 Writing For Magazines Writing For Magazines 00:02:00 Choosing Topics For Magazine Articles 00:01:00 Markets for Nonfiction Articles 00:00:00 Sample Magazine Query Letter 00:00:00 Writing Non Fiction For Publication and Sale Writing Non Fiction for Profit ONE 00:02:00 Writing Non Fiction For Profit TWO 00:02:00 Writing Non Fiction For Profit THREE 00:01:00 Writing Non Fiction For Profit FOUR 00:02:00 Writing Non Fiction For Profit FIVE 00:02:00 Writing Non Fiction For Profit SIX 00:02:00 Writing Non Fiction For Profit SEVEN 00:02:00 Writing Genre Fiction For Money and Kudos Introduction to Writing Genre Fiction 00:02:00 Writing Genre Fiction TWO 00:02:00 Writing Genre Fiction THREE - Romance 00:03:00 Writing Genre Fiction FOUR - Thrillers 00:01:00 Writing Genre Fiction FIVE - Science Fiction 00:01:00 Writing Genre Fiction SIX - Horror 00:02:00 Writing Genre Fiction SEVEN - Fantasy 00:01:00 Writing Genre Fiction EIGHT - Cross Genre 00:01:00 Writing For Children Writing for Children ONE 00:01:00 Writing for Children TWO 00:02:00 Writing for Children THREE 00:02:00 Writing for Children FOUR 00:02:00 Writing for Children FIVE 00:02:00 Writing for Children SIX 00:02:00 Writing for Children SEVEN 00:02:00 Marketing Listing of Children Book Publishers 00:00:00 Writing for Corporate Companies Writing for Business ONE 00:01:00 Writing for Business TWO 00:02:00 Writing for Business THREE 00:02:00 Writing for Business FOUR 00:02:00 Writing for Business FIVE 00:02:00 Writing for Business SIX 00:02:00 Travel Writing Travel Writing ONE 00:02:00 Travel Writing TWO 00:02:00 Travel Writing THREE 00:02:00 Travel Writing FOUR 00:02:00 Travel Writing FIVE 00:01:00 Travel Writing SIX 00:01:00 Travel Writing Publishers 00:00:00 Ghost Writing Ghost Writing ONE 00:02:00 Ghost Writing TWO 00:02:00 Ghost Writing THREE 00:02:00 Ghost Writing FOUR 00:01:00 Ghost Writing FIVE 00:02:00 Ghost Writing Resources 00:00:00 The Art of Writing Ad Copy The Art of Writing Copy ONE 00:02:00 The Art of Writing Copy TWO 00:02:00 The Art of Writing Copy THREE 00:02:00 The Art of Writing Copy FOUR 00:02:00 The Art of Writing Copy FIVE 00:02:00 The Art of Writing Copy SIX 00:02:00 The Art of Writing Copy SEVEN 00:02:00 The Art of Writing Copy EIGHT 00:02:00 Self Publishing Online Self Publishing Online ONE 00:02:00 Self Publishing Online TWO 00:02:00 Self Publishing Online THREE 00:01:00 Self Publishing Online FOUR 00:02:00 Self Publishing Online FIVE 00:02:00 Self Publishing Online SIX 00:02:00 Self Publishing Online SEVEN 00:01:00 Self Publishing Offline Offline Publishing Advice ONE 00:02:00 Offline Publishing Advice TWO 00:02:00 Offline Publishing Advice THREE 00:02:00 Offline Publishing Advice FOUR 00:02:00 Offline Publishing Resources 00:00:00 Grants and Funding for Writers Grants and Funding ONE 00:02:00 Grants and Funding TWO 00:01:00 Grants and Funding THREE 00:02:00 Grants Currently Available to Writers 00:00:00 Getting Wealthy by Helping Other Writers Helping Other Writers ONE 00:01:00 Helping Other Writers TWO 00:02:00 Helping Other Writers THREE 00:02:00 Helping Other Writers FOUR 00:02:00 Helping Other Writers FIVE 00:02:00 Helping Other Writers Six 00:01:00 Helping Other Writers SEVEN 00:01:00 Helping Other Writers EIGHT 00:02:00 Helping Other Writers NINE 00:01:00 Helping Other Writers TEN 00:00:00 Self Promotion Self Promotion Advice ONE 00:02:00 Self Promotion Advice TWO 00:01:00 Self Promotion Advice THREE 00:02:00 Self Promotion Advice FOUR 00:01:00 Self Promotion Advice FIVE 00:02:00 Self Belief and Your Career The End of the Course 00:01:00 Self Publishing - AGAIN 00:02:00 Maintaining a Freelance Career 00:02:00 Self Belief 00:02:00 Useful Websites for Self Publishing 00:00:00

QLS Endorsed + CPD QS Accredited - Dual Certification | Instant Access | 24/7 Tutor Support | All-Inclusive Cost

In this competitive job market, you need to have some specific skills and knowledge to start your career and establish your position. This Landing Page Design and Optimisation will help you understand the current demands, trends and skills in the sector. The course will provide you with the essential skills you need to boost your career growth in no time. The Landing Page Design and Optimisation will give you clear insight and understanding about your roles and responsibilities, job perspective and future opportunities in this field. You will be familiarised with various actionable techniques, career mindset, regulations and how to work efficiently. This course is designed to provide an introduction to Landing Page Design and Optimisation and offers an excellent way to gain the vital skills and confidence to work toward a successful career. It also provides access to proven educational knowledge about the subject and will support those wanting to attain personal goals in this area. Learning Objectives Learn the fundamental skills you require to be an expert Explore different techniques used by professionals Find out the relevant job skills & knowledge to excel in this profession Get a clear understanding of the job market and current demand Update your skills and fill any knowledge gap to compete in the relevant industry CPD accreditation for proof of acquired skills and knowledge Who is this Course for? This Landing Page Design And Optimisation is ideal for aspiring professionals 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 Landing Page Design & Conversion Rate Optimisation 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 £9 and the hard copy for £15. Also, you can order both PDF and hardcopy certificates for £22. Career Path On successfully completing the Landing Page Design And Optimisation, 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: Digital Marketing Manager Campaign Executive Course Curriculum Module 01: Landing Page Design and Optimisation Fundamentals Download all Section One Slides 00:48:00 Welcome to this course! Let's lay the groundwork for good landing page design 00:13:00 The Myth Of The Perfect Landing Page Conversion Rate 00:12:00 The 3 Main Types of Landing Pages and How To Use Them Effectively 00:19:00 Common Business Models and Understanding Your Conversion Actions 00:19:00 The AIDA Sales Funnel and The Online Decision Making Process 00:17:00 The Awareness Stage of the Funnel: Where It All Begins 00:18:00 The Interest Stage of the Funnel Tell Me More 00:14:00 The Desire Stage of the Funnel I Want What You Sell 00:13:00 The Action Stage of the Funnel I'm Going to Buy What You Sell 00:09:00 The Fogg Behavior Model and how it Applies to Good Landing Page Design 00:20:00 Making Your Landing Page Design Memorable 00:14:00 Module 02: Principles of Good Landing Page Design: Examples, Case Studies & Best Practices Download all Section Two Slides 00:06:00 The Primacy of Product and The Concept of Usability in Landing Page Design 00:15:00 Eschew Obfuscation: Clarity and the Quest for Fewer Question Marks 00:11:00 The 5 Second Usability Test in Landing Page Design (and how you can use it now) 00:31:00 The Art and Science Behind Designing High-Converting Calls To Action (CTA's) 00:19:00 Readability and Visual Hierarchy Landing Page Design 00:20:00 Respecting Web Conventions in Landing Page Design 00:13:00 Using Videos, Graphics and Imagery to Increase Landing Page Conversion Rates 00:20:00 Information Architecture and Accessibility - Landing Page Design Best Practices 00:20:00 Trust, Safety and Credibility (Part 1) Landing Page Design Best Practices 00:16:00 Trust, Safety and Credibility (Part 2) Landing Page Design Best Practices 00:09:00 Dedicated Landing Page Design Best Practices (Part 1) 00:15:00 Dedicated Landing Page Design Best Practices (Part 2) 00:12:00 Module 03: Principles of Persuasion in Landing Page Design Download all Section Three Slides 00:32:00 Using Scarcity to Improve Conversion Rates on Your Landing Pages 00:10:00 Principles of Persuasion - Reciprocal Concessions & Reciprocity in Landing Pages 00:12:00 Principles of Persuasion Anchoring and Cognitive Dissonance Theory 00:19:00 Module 04: Designing and Building a Landing Page Step by Step in Unbounce My Favorite Landing Page Builders and Getting Started With Our Unbounce Page 00:10:00 Getting Familiar With the Unbounce Page Builder and Adding Our Header Section 00:07:00 Creating a Logo in Photoshop and Using the Unbounce Image Uploader Tool 00:16:00 Working With Background Imagery in Landing Pages and Developing Our Hero Section 00:16:00 Creating a Form, Action Block, and Finishing the Hero Section in Unbounce 00:19:00 Discussing Landing Page Design Changes and Creating our Primary Content Section 00:16:00 Finishing Page Content, Adding Icons, Footer and Working With Buttons Unbounce 00:11:00 Publishing Your Unbounce Landing Page on Your Custom Domain 00:04:00 Adding Custom CSS in Unbounce to Create Professional Drop Shadows 00:06:00 Making Your Landing Page Design Work Better With Custom Javascript Snippets 00:08:00 Mobile Site Layout in Unbounce Based on Mobile Landing Page Design Guidelines 00:03:00 Designing Your Form Confirmation Dialogue in Unbounce and Testing Your Live Form 00:03:00 Assigning A/B Testing Variants in Unbounce and Assigning Traffic Weights 00:12:00 Integrating Your Unbounce Form Submissions With Your Mailchimp Account 00:09:00 Module 05: Bonus Goodbye For Now I Will Miss You Dearly 00:03:00 Module 06: Bonus Content: Real-Life Audits - Landing Page Design Best Practices Western Computer Audit Part 1 00:08:00 Western Computer Audit Part 2 00:09:00 Western Computer Audit Part 3 00:15:00 Western Computer Audit Part 4 00:14:00 Certificate and Transcript Order Your Certificates or Transcripts 00:00:00

In this competitive job market, you need to have some specific skills and knowledge to start your career and establish your position. This Freelance Masterclass - Become An Expert Copywriter will help you understand the current demands, trends and skills in the sector. The course will provide you with the essential skills you need to boost your career growth in no time. The Freelance Masterclass - Become An Expert Copywriter will give you clear insight and understanding about your roles and responsibilities, job perspective and future opportunities in this field. You will be familiarised with various actionable techniques, career mindset, regulations and how to work efficiently. This course is designed to provide an introduction to Freelance Masterclass - Become An Expert Copywriter and offers an excellent way to gain the vital skills and confidence to work toward a successful career. It also provides access to proven educational knowledge about the subject and will support those wanting to attain personal goals in this area. Learning Objectives Learn the fundamental skills you require to be an expert Explore different techniques used by professionals Find out the relevant job skills & knowledge to excel in this profession Get a clear understanding of the job market and current demand Update your skills and fill any knowledge gap to compete in the relevant industry CPD accreditation for proof of acquired skills and knowledge Who is this Course for? Whether you are a beginner or an existing practitioner, our CPD accredited Freelance Masterclass - Become An Expert Copywriter is perfect for you to gain extensive knowledge about different aspects of the relevant industry to hone your skill further. It is also great for working professionals who have acquired practical experience but require theoretical knowledge with a credential to support their skill, as we offer CPD accredited certification to boost up your resume and promotion prospects. Entry Requirement Anyone interested in learning more about this subject should take this Freelance Masterclass - Become An Expert Copywriter. This course will help you grasp the basic concepts as well as develop a thorough understanding of the subject. The course is open to students from any academic background, as there is no prerequisites to enrol on this course. The course materials are accessible from an internet enabled device at anytime of the day. CPD Certificate from Course Gate At the successful completion of the course, you can obtain your CPD certificate from us. You can order the PDF certificate for £9 and the hard copy for £15. Also, you can order both PDF and hardcopy certificates for £22. Career path The Freelance Masterclass - Become An Expert Copywriter will help you to enhance your knowledge and skill in this sector. After accomplishing this course, you will enrich and improve yourself and brighten up your career in the relevant job market. Course Curriculum Section 01: Introduction Preview of Course 00:05:00 Section 02: Freelance Masterclass - Become An Expert Copywriter Getting Started as a Copywriter 00:03:00 Skills Needed by a Copywriter 00:03:00 Communicating With Your Prospect to Improve Conversion Rate 00:04:00 Making and Closing a Deal 00:03:00 Niches That Use Copywriters 00:04:00 Becoming a Freelance Copywriter 00:04:00 Section 03: Getting Started as a Copywriter Polished writing skills 00:05:00 Headline creation 00:03:00 Awareness of user experience 00:04:00 Specialization 00:03:00 Marketing awareness 00:04:00 Section 04: Becoming a Freelance Copywriter Flexibility With Your Time 00:05:00 Wear Whatever You Want When You Work 00:03:00 Location 00:05:00 Your Own Boss 00:04:00 An unlimited income 00:03:00 Section 05: Communicating With Your Prospect to Improve Conversion Rate Map Your Audience Personas 00:03:00 Leverage Persuasive Hacks 00:04:00 Write Instant-Clarity Headlines 00:04:00 Leverage the AIDA Strategy 00:05:00 Improve Click-Through Rates 00:04:00 Section 06: Making and Closing a Deal The Ever Popular Call to Action 00:04:00 Creating a Sense of Urgency 00:03:00 5 tips for writing compelling copy 00:03:00 Don't Forget a Guarantee 00:04:00 Be Persuasive from Start to Finish 00:04:00 Section 07: Niches That Use Copywriters Break Into the Self-Improvement Market 00:04:00 Fundraising - Selling Your Services to Non-Profit Companies 00:04:00 Health Copywriting- Working to Improve People's Lives 00:03:00 Financial Services 00:03:00 Christian Market - Writing for a Higher Purpose 00:03:00 Section 08: Skills Needed by a Copywriter A Sense Of Adventure And Curiosity 00:03:00 Stellar Research Skills 00:04:00 The Ability To Create Something New, Even If It's Old 00:03:00 An Understanding Of User Experience 00:04:00 Create Empathy, Even If You're Not An Empathetic Person 00:04:00 Section 09: Conclusion Review of Course 00:04:00 Certificate and Transcript 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

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

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

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

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