426 Courses delivered Online

Freelancing on UpWork Course Overview This course on Freelancing on UpWork provides a comprehensive introduction to successfully launching and growing a freelance career using one of the world’s leading online platforms. Learners will explore essential strategies for creating a compelling profile, identifying suitable jobs, crafting effective proposals, and mastering pricing techniques to secure projects. The course equips individuals with the knowledge to build a strong presence, communicate professionally with clients, and enhance their reputation for sustained freelance success. Upon completion, learners will gain confidence in navigating UpWork’s system and understanding how to optimise their chances of winning contracts, enabling them to establish a reliable freelance income and expand their professional opportunities. Course Description Designed for aspiring freelancers, this course covers every step of engaging with UpWork’s platform effectively. Topics include creating a professional and attractive profile tailored to target clients, understanding how to submit well-crafted proposals that highlight relevant skills, and managing pricing strategies to remain competitive while maximising earnings. Additionally, learners will examine the benefits of account upgrades and how to close sales successfully. The course combines detailed explanations and illustrative examples to enhance understanding and develop key freelancing skills such as client communication, project selection, and reputation management. By the end of the course, participants will be able to confidently manage their freelance projects on UpWork and take control of their career progression within the gig economy. Freelancing on UpWork Curriculum Module 01: Introduction & Overview Module 02: Setting Up Your UpWork Profile Module 03: Submitting Proposals To Jobs Module 04: Pricing, Upgrading & Closing Sales Module 05: Conclusion (See full curriculum) Who is this course for? Individuals seeking to start a freelance career on UpWork. Professionals aiming to expand their client base and income sources. Beginners with an interest in digital freelancing and remote work. Entrepreneurs wanting to understand freelance marketplaces. Career Path Freelance Consultant Remote Project Specialist Digital Marketing Freelancer Content Creator or Copywriter Web Developer or Designer Virtual Assistant Independent Contractor in Various Industries

Photography isn’t just a passion anymore—it’s a career. From freelancers to media houses, brands are constantly on the lookout for visual storytellers who bring both artistic flair and business savvy. The Introduction to Photography Mini Bundle is built to help you stand out in a highly visual world. With photography, digital photography, communication skills, email marketing, and sales writing in one place, you're not just shooting images—you're building a career. Whether you're starting a business, launching a brand, or joining a creative team, this bundle puts you on the fast track to hireability. Description Great pictures don’t sell themselves—professionals do. That’s why the Introduction to Photography Mini Bundle is more than just about camera work. It’s about being employable in a digital-first world where clients and employers want photographers who understand communication skills, write compelling sales writing, and craft strategic email marketing campaigns. You’ll build your foundation in photography and digital photography, but that’s just the beginning. Pair it with exceptional communication skills and you’re already above the competition. Add in expertise in email marketing and sales writing, and you go from freelancer to high-demand content creator. Employers in media, advertising, ecommerce, publishing, and content production are looking for talent that combines creative execution with marketing know-how. Whether it’s branding through digital photography, engaging clients with strong communication skills, or converting leads with effective sales writing, this bundle sets you up for real results. FAQ Who is this bundle for? This is ideal for aspiring photographers, content creators, marketers, influencers, and anyone looking to combine photography with business. If you want to work in media or marketing, digital photography, communication skills, and sales writing are in high demand. Why include marketing and writing skills in a photography bundle? Because clients don’t just pay for pretty pictures. They pay for results. Email marketing and sales writing skills make your content sell—not just look good. Add strong communication skills, and you become the full package. Is now the right time to take this bundle? Absolutely. The rise of social media and ecommerce means brands need skilled photographers with a business mindset. If you’ve only focused on photography or digital photography, now’s the time to expand. Don’t wait until everyone else is offering the full skill set.

This course offers everything you need to become a React developer, from basic to advanced concepts. The course delves deep into custom hooks, Tailwind CSS, React Router, Redux, Firebase, and React Skeleton. You will learn to build real-world apps with React (eCommerce, Movie Informer, Todolist Manager, Blog, and Word Counter).

The Ecommerce Marketing Mini Bundle is for ambitious professionals who want to stand out in today’s digital economy. Whether you’re a business owner, freelancer, or job seeker, mastering Online Business, Viral Marketing, Online Entrepreneurship, Business Management, and Email Marketing puts you ahead of the curve—and ahead of your competitors. Every company today—big or small—is investing in Online Business, harnessing Viral Marketing, empowering Online Entrepreneurship, demanding strong Business Management, and executing smart Email Marketing. This bundle helps you check every box employers are looking for. Description The digital economy waits for no one. That’s why the Ecommerce Marketing Mini Bundle empowers you with five crucial skills: Online Business, Viral Marketing, Online Entrepreneurship, Business Management, and Email Marketing. These aren’t just trends—they’re the foundation of every thriving digital brand. If you're applying for jobs in ecommerce, digital marketing, online retail, or SaaS startups, you’ll constantly see roles demanding Online Business awareness, creative Viral Marketing skills, Online Entrepreneurship insight, real-world Business Management, and effective Email Marketing execution. This bundle instantly elevates your credibility. Want to impress clients? Launch a startup? Apply to a digital agency? The first things they’ll look for: Online Business, Viral Marketing, Online Entrepreneurship, Business Management, and Email Marketing. And now they’re all on your resume. Don't wait to be outpaced. Your competitors are already chasing the same roles, armed with experience in Online Business, Viral Marketing, Online Entrepreneurship, Business Management, and Email Marketing. You can either catch up—or move ahead with this bundle. FAQ Q: Who is this bundle for? A: Anyone building or working within a digital brand. Whether you're focused on Online Business, Viral Marketing, Online Entrepreneurship, Business Management, or Email Marketing, this bundle applies. Q: Can this help me land freelance or remote jobs? A: Yes. Most remote work requires experience in Online Business, Viral Marketing, Online Entrepreneurship, Business Management, or Email Marketing. You’ll have all five. Q: Is this suitable for startup founders? A: Absolutely. Whether you're launching a brand or scaling one, the combined value of Online Business, Viral Marketing, Online Entrepreneurship, Business Management, and Email Marketing is undeniable. Q: Why should I act now? A: Digital roles are filling fast. If you’re not highlighting Online Business, Viral Marketing, Online Entrepreneurship, Business Management, and Email Marketing on your application, you're losing out.

The Handyperson/Handyman Mini Bundle is the ultimate toolkit for those ready to turn skills into steady work. Whether you’re looking for employment in facilities maintenance, want to offer your services as a freelancer, or just need practical skills that always stay in demand, this bundle positions you ahead of the curve—with job-focused coverage of Electrician, Car Maintenance, Bike Maintenance, Bicycle Maintenance, and Fire Safety. These aren’t niche skills—they’re the backbone of residential and commercial upkeep. Employers constantly seek professionals with training in Electrician, Car Maintenance, Bike Maintenance, Bicycle Maintenance, and Fire Safety. Description The job market rewards the skilled and the self-reliant. That’s why the Handyperson/Handyman Mini Bundle equips you with five foundational skill areas that lead directly to hireability: Electrician, Car Maintenance, Bike Maintenance, Bicycle Maintenance, and Fire Safety. Facility managers, automotive repair shops, residential service companies, and building safety departments are hiring—right now. And they’re looking for people with practical knowledge in Electrician, Car Maintenance, Bike Maintenance, Bicycle Maintenance, and Fire Safety. With this bundle on your resume, you’re no longer overlooked. You’ll be able to show employers that you’re not just willing to work—you’re qualified to handle everything from Electrician tasks, to Car Maintenance, Bike Maintenance, and Bicycle Maintenance, while understanding key principles of Fire Safety that protect lives and property. Whether you're looking to get employed or build your own mobile handyman business, having a background in Electrician, Car Maintenance, Bike Maintenance, Bicycle Maintenance, and Fire Safety makes you more valuable than 90% of applicants. FAQ Q: Who should take this bundle? A: Anyone interested in skilled trades, facilities jobs, or freelance handyman work. Employers across industries want staff trained in Electrician, Car Maintenance, Bike Maintenance, Bicycle Maintenance, and Fire Safety. Q: Is this suitable for beginners? A: Yes. Even without prior experience, you’ll be prepared to enter roles requiring Electrician, Car Maintenance, Bike Maintenance, Bicycle Maintenance, and Fire Safety skills. Q: Is there demand for these services? A: Absolutely. Electrician, Car Maintenance, Bike Maintenance, Bicycle Maintenance, and Fire Safety are essential in homes, offices, rental properties, and public buildings. There's always work. Q: Why not just learn one of these areas? A: Because today’s employers value versatility. Someone who knows Electrician, Car Maintenance, Bike Maintenance, Bicycle Maintenance, and Fire Safety brings far more value than someone with just one specialty.

🌟 Unlock Your Upwork Success with 'Work on Upwork - Become an Irresistible Hire' Course! 🌟 Are you ready to transform your freelancing journey and become the go-to hire on Upwork? Look no further! Our comprehensive course is designed to elevate your profile, attract premium clients, and skyrocket your success on the world's leading freelance platform.   🚀 What You'll Gain:   Master the Upwork Marketplace: Learn the insider strategies to navigate Upwork's platform effortlessly and stand out among the competition. Craft a Winning Profile: Create a compelling profile that grabs attention and showcases your expertise to clients. Irresistible Proposals: Craft persuasive proposals that seal the deal and win high-paying projects consistently. Effective Communication Skills: Nail client interactions and maintain professionalism at every step. Build a Stellar Portfolio: Showcase your skills and past work effectively to attract top-tier clients. 🌟 Why Choose 'Work on Upwork - Become an Irresistible Hire'? Expert Guidance: Learn from industry professionals who've mastered the art of Upwork success. Actionable Insights: Practical, step-by-step guidance to implement strategies immediately. Tailored Learning: Modules designed to suit beginners and experienced freelancers alike. Ongoing Support: Access to a community of like-minded freelancers and continuous updates on Upwork's best practices. 🎯 Take charge of your freelance career today and unlock doors to premium projects with our 'Work on Upwork - Become an Irresistible Hire' course!     Enroll now and step into a world of endless freelance opportunities on Upwork. Don't just dream of success-make it a reality!   Course Curriculum

The Connect With Customers Over Mobile course helps you understand how to reach and engage your audience through mobile platforms. You will explore the essentials of digital marketing and learn how to use mobile marketing, social media, and content strategies to drive business growth. With practical lessons on growth hacking, email, SEO, and major platforms like Facebook, Instagram, Twitter, and YouTube, this course gives you a full view of modern mobile marketing techniques. You’ll also learn how to map the customer journey to ensure stronger, lasting connections with your audience. Course Curriculum ✓ Homemade Pet Food – Why it is so beneficial ✓ Making Pet Food for First Time – What Precautions to Take ✓ Natural Pet Food Making Techniques ✓ Home made Pet Food for Dogs ✓ Homemade Pet Food for Cat ✓ Making Homemade Dry Pet Food ✓ Great Way to Save Money Spent on Pet Food ✓ What Kind of Food Animals Love ✓ Nutrients to Supply Pets with Food Made at Homes ✓ Tips to Make Excellent Quality Food Learning Outcomes Understand the basics of digital marketing Apply growth hacking strategies to gain more customers Analyse and optimise the customer journey Create effective content for mobile marketing Improve visibility using SEO techniques Build engaging email marketing campaigns Promote effectively on Facebook Use Instagram to connect with a mobile audience Engage followers and customers on Twitter Create compelling video campaigns on YouTube and mobile platforms Who is this course for? This course is perfect for marketers, small business owners, entrepreneurs, or anyone who wants to learn how to connect with customers using mobile tools. Whether you are starting out or looking to refresh your digital skills, this course will help you reach your audience more effectively. Eligibility Requirements There are no formal requirements for this course. Anyone with a basic understanding of internet use and a keen interest in marketing can enrol and benefit from the lessons. Career Path After finishing this course, you can explore roles in digital marketing, social media management, content creation, or brand promotion. It also provides a solid foundation for growing your own business or becoming a freelancer in the marketing space. With the demand for mobile-focused marketers on the rise, this course can open doors to many exciting job opportunities. (Learn more about this online course)

🌟 Unlock Your Freelance Potential with 'Independent Endeavors: Empowering Your Freelance Journey' by Brad Hussey! 🚀   Are you ready to break free from the constraints of the traditional 9-to-5 grind and embark on a fulfilling freelance career? Join renowned expert Brad Hussey in an exhilarating online course designed to equip you with the tools, strategies, and insider insights to thrive in the world of freelancing!   🎯 What You'll Gain: ️ Proven Techniques: Learn Brad Hussey's time-tested strategies honed through years of successful freelancing. ️ Masterful Skills: Acquire essential skills in client acquisition, project management, pricing strategies, and more. ️ Confidence Booster: Gain the confidence to navigate challenges and make informed decisions as an independent professional. ️ Exclusive Insights: Benefit from Brad's firsthand experiences and industry secrets for sustainable freelance success.   🌐 Course Highlights: 🚀 Comprehensive Modules: Dive deep into modules crafted to elevate your freelance career, covering everything from building your brand to managing client relationships. 🔑 Interactive Learning: Engage with interactive sessions, live Q&A, and practical assignments to reinforce your newfound knowledge. 📈 Ongoing Support: Access a supportive community and ongoing resources to guide you even after course completion. 🤝 Join the Thriving Community: Connect with like-minded individuals, network with industry experts, and foster collaborations that could amplify your freelance journey! 💡 Why Choose Brad Hussey's Course? Brad Hussey is not just an instructor; he's a seasoned professional with a passion for empowering freelancers. His commitment to your success is reflected in the course's tailored content and actionable insights.   🌟 Ready to Transform Your Freelance Journey? Don't miss this opportunity to take charge of your career and thrive in the world of freelancing. Enroll now in 'Independent Endeavors: Empowering Your Freelance Journey with Brad Hussey' and kickstart your path to freelance freedom! 🚨 Limited Seats Available! Reserve Your Spot Today! 🚀   Course Curriculum Freelancing Freedom with Brad Hussey Welcome 00:00 Module 1 00:00 Module 2 00:00 Module 3 00:00 Module 4 00:00 Module 5 00:00

Dive into the world of linguistic expertise with our course, 'Translation: Freelance Translator.' This program is a treasure trove of knowledge for those poised to navigate the thriving industry of translation as independent professionals. Picture a career where language is not just a tool but a bridge connecting cultures and businesses across the globe. The course begins by shedding light on the translation sector, followed by an in-depth look into the freelance landscape. It's a journey from understanding the basics of translation to mastering the art of freelancing. The modules are thoughtfully designed to guide you through every phase of establishing yourself as a freelance translator. From setting up an efficient home office to embracing the professional ethics vital in this field, the course covers it all. You'll delve into practical aspects like client acquisition, workflow management, and leveraging CAT tools to enhance productivity. Learn to market your skills effectively and ensure quality in every project. This course isn't just about translation; it's about empowering you with the know-how to launch and sustain a successful freelance translation business. Learning Outcomes Obtain a thorough understanding of the translation industry and freelance opportunities. Equip yourself with the essentials of beginning a freelance translator career. Develop expertise in client relations, project handling, and CAT tool utilisation. Master marketing techniques tailored for freelance translators. Emphasise adherence to professional ethics and quality standards in translation. Why choose this Translation: Freelance Translator course? Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards and CIQ after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the Course at your own pace, on your own schedule. Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience. Unlock career resources for CV improvement, interview readiness, and job success. Who is this Translation: Freelance Translator course for? Budding translators aiming to venture into freelancing. Language enthusiasts wishing to utilise their skills in a freelance capacity. Translation sector professionals seeking freelance opportunities. Graduates in linguistics or language studies exploring career options in translation. Freelance translators looking to refine their business strategies and skills. Career path Freelance Language Translator - £21,000 to £39,000 Interpreting Specialist - £23,000 to £37,000 Translation Service Coordinator - £25,000 to £41,000 Localisation Specialist - £24,000 to £36,000 Multilingual Consultant - £22,000 to £34,000 Copywriter with Language Specialisation - £20,000 to £32,000 Prerequisites This Translation: Freelance Translator does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Translation: Freelance Translator 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. Certification After studying the course materials, there will be a written assignment test which you can take at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £4.99 Original Hard Copy certificates need to be ordered at an additional cost of £8. Course Curriculum Module 01: An Overview of Translation An Overview of Translation 00:30:00 Module 02: Introduction to Freelancing Introduction to Freelancing 00:30:00 Module 03: Introduction to Freelance Translator Introduction to Freelance Translator 00:30:00 Module 04: Activities Before Getting Started Activities Before Getting Started 00:30:00 Module 05: Finding Clients Finding Clients 00:30:00 Module 06: Managing the Work Managing the Work 00:30:00 Module 07: Marketing Marketing 00:30:00 Module 08: CAT Tools in Translation CAT Tools in Translation 00:30:00 Module 09: Getting Paid for The Work Getting Paid for The Work 00:30:00 Module 10: Setting Up Home Office Setting Up Home Office 00:30:00 Module 11: Professional Ethics of Freelance Translators Professional Ethics of Freelance Translators 00:30:00 Module 12: Ensuring Quality Ensuring Quality 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