31963 Courses in Cardiff delivered On Demand

Fitness Instructor Course Overview If you’re passionate about health and fitness and want to help others reach their goals, our Fitness Instructor Course is the perfect place to begin. This course offers a comprehensive introduction to personal training, covering everything from anatomy and client assessment to resistance training and cardio programming. You’ll learn the key roles and responsibilities of a fitness coach, dive deep into the muscular and cardiovascular systems, and gain practical knowledge through detailed exercise demonstrations. From planning training sessions to understanding muscle growth and fat loss, this course is designed to equip you with the tools to guide clients effectively and confidently. Whether you're a beginner or looking to build on your existing knowledge, this course is structured to help you become a competent and confident fitness instructor—ready to make a difference. Extra Included: Free Accredited Certificate Included Lifetime Access Free Student ID Card Learning Outcome Understand the responsibilities of a fitness instructor Gain in-depth knowledge of anatomy and muscle function Learn to assess clients and create personalised training plans Master key concepts of resistance training and progressive overload Develop expertise in cardio workouts and HIIT training Learn the fundamentals of flexibility and proper warm-up techniques Get practical instruction on essential exercises like squats, deadlifts, and push-ups Who is this Fitness Instructor Course for? This Fitness Instructor Course is perfect for aspiring fitness coaches and personal trainers looking to gain professional-level knowledge and skills. It’s also a great fit for health and sports science students who want to build a strong foundation in fitness training and exercise science. Gym enthusiasts who are eager to understand the principles behind effective workouts will find immense value, as will anyone with a passion for fitness and a desire to help others achieve their health goals. Entry Requirements There are no formal prerequisites for this course. It is open to anyone interested in fitness and training, regardless of prior experience. A basic understanding of exercise and a willingness to learn is all you need to get started. Accredited Certification After successfully completing the course, you can get a UK and internationally accepted certificate to share your achievement with potential employers or include it in your CV. For the PDF certificate, you’ll need to pay £9.99. You can get the hard copy for 15.99, which will reach your doorstep by post.

QuickBooks Online Bookkeeping Course Overview Bookkeeping is a complex yet very crucial task for an organisation or a business. It requires skills and expertise to maintain accuracy in online bookkeeping. The Quickbooks Online Bookkeeping course is here to help you understand all the functions and tools of Quickbook. Within a few hours, you will know the ins and outs of Quickbook online bookkeeping. The Quickbooks Online Bookkeeping course will teach you the fundamentals of Quickbook. Step-by-step, you will learn how to write reports, paying suppliers, posting customer invoices and more. You will acquire the skills to manage payroll and calculate VAT. Every module will include new and advanced techniques of Bookkeeping and gradually increase your proficiency in this subject. Good bookkeeping skills are always on demand. Join the Quickbooks Online Bookkeeping course to learn everything you need to become a competent bookkeeper. It will provide you with additional skills to stay ahead of the competition. Learning Outcome Set up and navigate QuickBooks Online confidently Create and manage customer and supplier records Post invoices, credit notes, and handle payments with ease Record petty cash, sundry receipts, and cheque transactions Prepare and submit VAT returns using QuickBooks Reconcile bank statements and manage outstanding items Post wage journals and journal adjustments Generate reports for accurate business decision-making Who is this QuickBooks Online Bookkeeping Course for? This course has been expertly designed for those who want practical, real-world bookkeeping skills without wading through jargon. You’ll go from “just looking” at QuickBooks to actually understanding how to use it like a seasoned bookkeeper. Plus, our self-paced lessons let you learn whenever and wherever, with instructor-led support to guide you along the way. By the end, you’ll have a strong working knowledge of QuickBooks Online and the confidence to use it in your role—or for your own business. Career Path Completing this course can open doors to various finance and admin roles across industries. Some potential job paths in the UK include: Junior Bookkeeper – earn between £20,000 – £25,000 per year Accounts Assistant – typically earns £22,000 – £28,000 annually Office Administrator (with bookkeeping duties) – earns around £21,000 – £26,000 Finance Support Officer – earns between £24,000 – £30,000 Freelance Bookkeeper – can earn £15 – £35 per hour, depending on experience and clients

Fostering a growth mindset in education transforms assessments into tools for learning, encouraging resilience, effort, and continuous improvement beyond traditional grading for enhanced student development.

Feeling unheard or overlooked? Impact conversations without risking relationships… Find out how to have the influence you want in challenging conversations - in just 10 minutes! Despite our best efforts, sometimes a work relationship or situation becomes challenging – what then? You need to be assertive to get things back on track. There is an art to doing this well and feeling proud of yourself for making your voice heard in the right way. The 3 things you'll learn in this FREE introductory training: 1. The skills you already have for making an impact that you might not give credit to 2. The areas you can develop in order to make impactful points well 3. How to frame your point succinctly and boost others' confidence and trust in you Feeling clear and confident about framing yourself and your messages for win-win results.

Discover how assignment experts enhance study skills, boost academic performance, and provide personalized support to help students succeed in their educational journey. Unlock your potential today!

🌬️ Breathe Easy with Respiratory Protection and Safety Training Course! 🛡️ Are you ready to safeguard your respiratory health and ensure workplace safety? Dive into the world of respiratory protection and safety with our comprehensive training course. Designed to equip you with the knowledge and skills needed to navigate hazardous environments with confidence, this course is your ticket to a safer, healthier future. Let's explore why enrolling in our Respiratory Protection and Safety Training Course is a game-changer for you and your career.   🔍 Why Respiratory Protection and Safety Training? In today's world, respiratory hazards abound in various workplaces, from construction sites to industrial facilities and healthcare settings. Understanding how to protect yourself from airborne contaminants and hazardous particles is crucial for maintaining optimal health and safety standards. Our Respiratory Protection and Safety Training Course provide you with the essential tools and techniques to mitigate risks, prevent respiratory illnesses, and ensure compliance with regulatory standards.   📚 Course Highlights: Comprehensive Curriculum: Our course covers a wide range of topics, including respiratory hazards, respirator types, fit testing, maintenance procedures, and emergency protocols. Expert Instruction: Learn from experienced instructors who are experts in respiratory protection and safety, providing you with invaluable insights and practical guidance. Interactive Learning: Engage in dynamic lectures, hands-on exercises, case studies, and simulations to reinforce your understanding and skills. Practical Applications: Gain real-world experience through simulations and scenarios that mimic workplace environments, allowing you to apply your knowledge in realistic settings. Certification: Upon successful completion of the course, receive a certification that demonstrates your proficiency in respiratory protection and safety, enhancing your credibility and marketability.   👨‍🔬 Who is this for? Healthcare Professionals: Nurses, doctors, and healthcare workers who deal with infectious diseases and airborne contaminants. Construction Workers: Individuals working in construction, demolition, or renovation projects where dust, fumes, and other respiratory hazards are prevalent. Industrial Workers: Factory workers, miners, and manufacturing personnel exposed to airborne chemicals, gases, and particulates. Emergency Responders: Firefighters, paramedics, and rescue workers who encounter hazardous materials and environmental contaminants in the line of duty.   🚧 Career Path: Health and Safety Officer: Become a crucial member of organizations, ensuring compliance with health and safety regulations and implementing respiratory protection protocols. Occupational Health Specialist: Specialize in assessing workplace hazards, designing control measures, and promoting respiratory safety practices to protect workers' health. Industrial Hygienist: Conduct air quality assessments, monitor respiratory hazards, and develop strategies to mitigate risks in industrial settings. Safety Trainer: Share your expertise by training employees on respiratory protection and safety measures, fostering a culture of safety and compliance within organizations.   📝 FAQs (Frequently Asked Questions): Q: Is this course suitable for beginners? A: Absolutely! Our Respiratory Protection and Safety Training Course cater to individuals of all levels, from beginners to experienced professionals. We provide comprehensive instruction and guidance to ensure everyone can grasp the concepts and apply them effectively.   Q: How long does it take to complete the course? A: The duration of the course may vary depending on the format and pace of learning. However, typically, our course can be completed within a few weeks, allowing you to quickly acquire the necessary skills and knowledge to enhance your respiratory protection practices.   Q: Will I receive a certification upon completion? A: Yes, upon successful completion of the course, you will receive a certification that demonstrates your proficiency in respiratory protection and safety. This certification is recognized and valued by employers across various industries.   Q: Can I access the course materials online? A: Yes, our Respiratory Protection and Safety Training Course offer online access to course materials, allowing you to learn at your own pace and convenience. You can access lectures, resources, and interactive activities from anywhere with an internet connection.   Q: How will this course benefit my career? A: By completing our course, you will gain valuable skills and knowledge that are highly sought after in today's workforce. Whether you're looking to advance in your current role, transition to a new career path, or enhance your professional credentials, our Respiratory Protection and Safety Training Course can open doors to exciting opportunities.   🌐 Take the First Step Towards Respiratory Safety! Don't wait until it's too late. Enroll now in our Respiratory Protection and Safety Training Course and embark on a journey towards safeguarding your health and securing your future. Together, let's breathe easy and thrive in a safer, healthier workplace! 🌬️🔒👩‍🔬 Course Curriculum Module 1_ Introduction to Respiratory Protection Introduction to Respiratory Protection 00:00 Module 2_ Respiratory System and Its Functions Respiratory System and Its Functions 00:00 Module 3_ Respiratory Hazards and Risk Assessment Respiratory Hazards and Risk Assessment 00:00 Module 4_ Types of Respiratory Protection Equipment Types of Respiratory Protection Equipment 00:00 Module 5_ Proper Use and Fit of Respirators Proper Use and Fit of Respirators 00:00 Module 6_ Respirator Cleaning and Maintenance Respirator Cleaning and Maintenance 00:00

🌟 Discover the Power of Knowledge with Hydrogen Sulfide Training! 🚧 Are you ready to unlock the secrets of safety in hazardous environments? Dive into our comprehensive Hydrogen Sulfide Training course, designed to equip you with essential knowledge and skills to navigate the dangers of hydrogen sulfide exposure. Join us on a journey where safety meets expertise, empowering you to protect yourself and others in potentially life-threatening situations.   🛡️ Why Hydrogen Sulfide Training? Hydrogen sulfide (H2S) is a colorless, highly toxic gas commonly found in industries such as oil and gas, wastewater treatment, and chemical manufacturing. Exposure to hydrogen sulfide can pose serious health risks, including respiratory issues, neurological damage, and even death. By undergoing Hydrogen Sulfide Training, you'll gain the knowledge and skills needed to recognize, assess, and mitigate the risks associated with hydrogen sulfide exposure, ensuring the safety of yourself and your colleagues.   🎓 Benefits of Taking the Course: Safety Awareness: Gain a comprehensive understanding of the hazards associated with hydrogen sulfide exposure, empowering you to make informed decisions and take appropriate precautions in hazardous environments. Risk Mitigation: Learn strategies for identifying and assessing hydrogen sulfide risks, as well as implementing effective control measures to minimize exposure and prevent accidents. Emergency Preparedness: Enhance your ability to respond to hydrogen sulfide emergencies with confidence, knowing how to safely evacuate, provide first aid, and coordinate emergency response efforts. Compliance: Stay compliant with industry regulations and standards governing hydrogen sulfide safety, reducing the risk of fines, penalties, and legal liabilities for your organization. Career Advancement: Position yourself as a valuable asset in industries where hydrogen sulfide exposure is a concern, opening up opportunities for career advancement and specialization in safety-related roles.   🔍 Who is This For? Industrial Workers: Those working in industries such as oil and gas, chemical manufacturing, wastewater treatment, and agriculture where hydrogen sulfide exposure is common. Safety Professionals: Safety officers, supervisors, and managers responsible for ensuring workplace safety and compliance with regulations. Emergency Responders: Firefighters, paramedics, and other emergency personnel who may encounter hydrogen sulfide emergencies in the field. Students and Researchers: Individuals studying environmental science, occupational health, or related fields who want to deepen their understanding of hydrogen sulfide hazards.   🛠️ Career Path: Upon completing Hydrogen Sulfide Training, you'll be equipped with valuable skills and knowledge that can lead to various career paths, including: Safety Specialist: Specialize in hydrogen sulfide safety and risk management, working to ensure the safety of workers in hazardous environments. Environmental Health and Safety (EHS) Manager: Oversee safety programs and protocols within organizations, including managing risks associated with hydrogen sulfide exposure. Industrial Hygienist: Conduct assessments and implement controls to protect workers from exposure to hazardous substances, including hydrogen sulfide. Emergency Response Coordinator: Coordinate emergency response efforts in the event of hydrogen sulfide incidents, ensuring a swift and effective response to protect lives and property.   📚 FAQs (Frequently Asked Questions):   Q: What is hydrogen sulfide, and why is it dangerous? A: Hydrogen sulfide is a colorless, highly toxic gas with a characteristic odor of rotten eggs. It is commonly found in industries such as oil and gas, wastewater treatment, and chemical manufacturing. Exposure to hydrogen sulfide can pose serious health risks, including respiratory issues, neurological damage, and even death. Q: Who should take Hydrogen Sulfide Training? A: Hydrogen Sulfide Training is suitable for anyone working in industries where hydrogen sulfide exposure is a concern, including industrial workers, safety professionals, emergency responders, and students studying related fields. Q: What topics are covered in the course curriculum? A: The course curriculum covers essential topics such as the properties and hazards of hydrogen sulfide, risk assessment and mitigation strategies, emergency response procedures, and regulatory compliance requirements. Q: How long does the course take to complete? A: The duration of the course varies depending on the learning format and pace of the participant. Typically, the course can be completed in a few hours to a few days. Q: Is the course certification recognized? A: Yes, upon successful completion of the course, participants will receive a certificate of completion, which is widely recognized in industries where hydrogen sulfide safety is a concern.   🌐 Secure Your Future with Hydrogen Sulfide Training! Don't wait until it's too late - invest in your safety and the safety of those around you by enrolling in Hydrogen Sulfide Training today. With the knowledge and skills gained from this course, you'll be empowered to navigate hazardous environments with confidence and peace of mind. Your safety is our priority - join us on this transformative journey now! 🚀🛡️🌟 Course Curriculum Module 1_ Introduction to Hydrogen Sulfide Introduction to Hydrogen Sulfide 00:00 Module 2_ Sources and Occurrences of Hydrogen Sulfid Sources and Occurrences of Hydrogen Sulfid 00:00 Module 3_ Health Effects of Hydrogen Sulfide. Health Effects of Hydrogen Sulfide. 00:00 Module 4_ Regulations and Standards for Hydrogen Sul Regulations and Standards for Hydrogen Sul 00:00 Module 5_ Hydrogen Sulfide Management and Control Hydrogen Sulfide Management and Control 00:00 Module 6_ Hydrogen Sulfide Training and Education Hydrogen Sulfide Training and Education 00:00

🌟 Unleash Your Creativity: Design & Enhance With Photoshop Online Course 🌟 Are you ready to transform your creative vision into stunning visual masterpieces? Dive into the world of endless possibilities with our exclusive online course: 'Design & Enhance With Photoshop.'   🎨 Unlock Your Creative Potential: Whether you're a seasoned designer or a beginner eager to explore the realm of digital artistry, this course is crafted just for you. From the basics to advanced techniques, we'll guide you through every facet of Adobe Photoshop, empowering you to create captivating designs that leave a lasting impression.   🚀 What You'll Learn: Master Photoshop Tools: From layers and masks to brushes and filters, become proficient in utilizing Photoshop's extensive toolkit. Design Principles: Learn the fundamental principles of design, color theory, and composition to create visually appealing graphics. Photo Editing Magic: Discover the secrets of professional photo editing, retouching, and enhancement for jaw-dropping results. Typography Mastery: Elevate your designs with impactful text, mastering the art of font selection, spacing, and alignment. Create Engaging Visual Content: Craft social media graphics, banners, posters, and more that stand out in the digital landscape.   🌐 Why Choose Our Course: Flexible Learning: Access the course anytime, anywhere, and at your own pace. Fit learning seamlessly into your busy schedule. Expert Guidance: Benefit from the expertise of seasoned design professionals who share real-world insights and tips. Hands-On Projects: Apply your skills through practical, hands-on projects that reinforce your learning and build your portfolio.   🎓 Who is This Course For? Graphic Designers Photographers Content Creators Social Media Managers Marketing Professionals Anyone Passionate About Visual Arts   🌈 Elevate Your Design Game Today! Don't miss out on the opportunity to enhance your creative journey. Join 'Design & Enhance With Photoshop' now and turn your imagination into captivating visual stories!   🔥 Enroll Now and Design Your Success! 🔥 Course Curriculum Basic Overview 00:00 Pricing and Licensing Options 00:00 Basic File Types and Options 00:00 Working with the Interface 00:00 Working with A Basic Canvas 00:00 Working with Layers 00:00 Working with the Move Tool 00:00 Working with Shapes 00:00 Working with the Marquee Tool 00:00 Working with Colors 00:00 Working with the Paintbucket 00:00 Working with the Eraser Tool 00:00 Working with the Text Tool 00:00 Working with Images 00:00 Working with Sizing 00:00 Working With Transparent Layers 00:00 Using the Crop Tool 00:00 Working with Layer Styles 00:00 Working with Rotation of Images and Layers 00:00 Conclusion 00:00 Advanced Overview 00:00 Having Graphic Designs Created 00:00 Making PSD Thumbnails Visible on Your PC 00:00 Creating A Simple Design - Part 1 00:00 Creating A Simple Design - Part 2 00:00 Changing the Backgrond Image 00:00 Changing the Font or Text 00:00 Working with Photoshop Actions 00:00 Sources for Photoshop Actions 00:00 Selecting Photoshop Actions 00:00 Producing Photoshop Actions - Part 1 00:00 Show Transform Controls 00:00 Producing Photshop Actions - Part 2 00:00 Creating a Multiple 3D Image Shot 00:00 Sizing of File Formats 00:00 Saving For Certain File Formats 00:00 Live Application - Part 1 00:00 Live Application - Part 2 00:00 Multiple Shot Live Application 00:00 Conclusion 00:00

🌟 Unlock the Power of Excel 2019! 🌟 Are you ready to master Microsoft Excel 2019 and elevate your skills to new heights? Introducing our comprehensive online course: 'Microsoft Excel 2019 - Beginner Level Training.' 🚀 Dive into Excel's World-Class Features 🚀 📚 Section 1 - Excel Beginner Get started with a solid foundation. Learn the interface, navigation, and essential tools to kickstart your Excel journey. 📊 Section 2 - Excel Fundamentals Discover the core functionalities of Excel 2019, from cells and formulas to tables and more. Lay the groundwork for proficient data manipulation. ️ Section 3 - Entering and Editing Text Master the art of inputting and refining text within Excel. Gain efficiency and accuracy in handling textual data. Section 4 - Basic Excel Functions Explore the fundamental functions that make Excel a powerhouse. From basic calculations to data analysis, unlock Excel's potential. 🔄 Section 5 - Modifying an Excel Worksheet Learn techniques to manage, organize, and customize worksheets effectively. Boost productivity and streamline your workflow. 🎨 Section 6 - Formatting Data Transform raw data into visually appealing, easy-to-read formats. Elevate your reports and presentations with polished data formatting skills. 🖼️ Section 7 - Images, Shapes, and Smart Art Enhance your spreadsheets with visuals! Master the incorporation of images, shapes, and smart art for impactful data representation. 🖨️ Section 8 - Printing in Excel Navigate the intricacies of printing in Excel. Optimize layouts and settings to produce professional-looking documents. 📑 Section 9 - Templates Harness the power of pre-designed templates. Learn how to utilize and customize templates for various Excel projects efficiently. 🎓 Section 10 - Excel Beginner - Conclusion Wrap up your journey with a comprehensive understanding of Excel's beginner level. Recap key takeaways and prepare to advance your skills further. 🔥 Join Now and Excel in Excel 2019! 🔥 👩‍💻 Whether you're a student, professional, or an Excel enthusiast, this course is your gateway to proficiency in Microsoft Excel 2019. Enroll today and unlock a world of possibilities with data manipulation, analysis, and presentation! 🌟 Don't miss this opportunity! Enroll now and empower yourself with Excel mastery! 🌟 Course Curriculum Section 1 - Excel Beginner Introduction 01:02 Section 2 - Excel Fundamentals Launching Excel 01:59 Start Up Screen 02:54 The Excel Interface 06:46 The Quick Access Toolbar 02:13 The Ribbon 04:43 Creating New Excel Workbooks 01:27 Saving Excel Files 02:22 Opening Excel Files 01:38 Beginner Shortcut Keys 01:37 Section 3 - Entering and Editing Text Entering Text 06:41 Working with Numbers 06:55 An Introduction to Dates 01:15 Find and Replace 04:10 Sorting Data 04:13 Working with Cell References 06:05 Relative Versus Absolute Cell Reference in Formulas 06:24 Understanding the Order of Operation 02:41 Section 4 - Basic Excel Functions The structure of an Excel Function 00:00 Working with the Sum Function 00:00 Working with Min and Max 00:00 Working with Averages 00:00 Working with Count and CountA 00:00 Section 5 - Modifying an Excel Worksheet Moving and Copying Data 00:00 Inserting and Deleting Rows and Columns 00:00 Changing the Width and Height of Cells 00:00 Hiding and Unhiding Rows, Columns and Sheets 00:00 Renaming Worksheets 00:00 Deleting Worksheets 00:00 Moving and Copying Worksheets 00:00 Section 6 - Formatting Data Adding Borders to Cells 00:00 Formatting Percentages 00:00 Merging and Centering Cells 00:00 A Quick look at Styles 00:00 Basic Conditional Formatting 00:00 Section 7 - Images, Shapes and Smart Art Inserting Images and Shapes 00:00 Working with SmartArt 00:00 Section 8 - Printing in Excel Print Preview 00:00 Margins, Scaling and Orientation 00:00 Printing 00:00 Section 9 - Templates Intro to Excel Templates 00:00 Opening an Existing Template 00:00 Creating a Custom Template 00:00 Section 10 - Excel Beginner - Conclusion Conclusion 00:00

🌟 Unlock the Full Power of Microsoft Excel 2019! 🌟 Ready to take your Excel skills to the next level? Dive into our comprehensive online course - 'Microsoft Excel 2019 - Advanced Level Training' - designed to transform you into an Excel maestro! 🚀 Here's What You'll Master: 📊 Section 1: Excel - Advanced - Get hands-on with advanced techniques and shortcuts to streamline your workflow. 📂 Section 2: Working with Multiple Workbooks - Seamlessly manage multiple workbooks and boost your productivity effortlessly. 🔒 Section 3: Protecting Worksheets and Workbooks - Learn how to safeguard your data with robust protection strategies. 📝 Section 4: Conditional Formulas - Unravel the power of conditional logic and unleash the true potential of formulas. 🧮 Section 5: Advanced Functions - Elevate your Excel expertise by mastering complex functions for data analysis. 📚 Section 6: Text Based Functions - Manipulate text effortlessly and efficiently with advanced text-based functions. 🔍 Section 7: What IF Tools - Explore the 'What If' analysis tools to make informed decisions and predictions. 🏁 Section 8: Excel Advanced - Conclusion - Wrap up with a comprehensive understanding and practical application of advanced Excel features. 🎁 Section 9: Bonus #1 - Advanced Pivot Tables - Delve into bonus content covering advanced techniques for Pivot Tables, a must-have skill for data analysis pros. 🌟 Why Choose Our Course? 🔐 Expert Guidance: Led by seasoned Excel professionals, ensuring clarity and depth in learning. 🔄 Practical Assignments: Apply your newfound skills through real-world exercises. 📈 Career Growth: Elevate your career prospects by mastering sought-after Excel abilities. 🌐 Accessible Learning: Study at your own pace from anywhere, anytime with our user-friendly online platform. 🤝 Join our vibrant community of learners dedicated to mastering Excel's advanced functionalities. 💡 Enroll now and revolutionize your Excel prowess with 'Microsoft Excel 2019 - Advanced Level Training'! Don't miss this chance to become an Excel wizard! 💡   Course Curriculum Section 1 - Excel - Advanced Excel Advanced Introduction 01:39 Advanced Shortcut Keys 02:58 Section 2 - Working with Multiple Workbooks Tracing Precedents 00:00 Tracing Dependants 00:00 Watch Window 00:00 Show Formulas 00:00 Section 3 - Protecting Worksheets and Workbooks Protecting Cells in a Worksheet 00:00 Protecting the Workbook Structure 00:00 Encryption with Passwords 00:00 Section 4 - Conditional Formulas Name Ranges 00:00 Simple IF Function 00:00 IF, AND 00:00 IF, OR 00:00 Nested Formulas 00:00 CountIF and CountIFs 00:00 SumIF and SumIFs 00:00 Section 5 - Advanced Functions Advanced VLookUp 00:00 IF and IS Error - Part 1 00:00 IF and IS Error - Part 2 00:00 Advanced Index Match 00:00 Dates - Part 1 00:00 Dates - Part 2 00:00 Replace and Substitute - Part 1 00:00 Replace and Substitute - Part 2 00:00 Section 6 - Text Based Functions Left, Right and Mid Function 00:00 Search Function 00:00 Concatenate and Search 00:00 Indirect - Static 00:00 Indirect - Dynamic 00:00 Section 7 - What IF Tools Goal Seek 00:00 Data Tables 00:00 Scenarios 00:00 Solver 00:00 Section 8 - Excel Advanced - Conclusion Excel Advanced - Conclusion 00:00 Section 9 - Bonus # 1 - Advanced Pivot Tables Building a Mini Dashboard 00:00