6125 Courses delivered Online

Master financial ratio analysis and enhance your decision-making skills with our specialized course. Learn to interpret financial statements, assess company performance, and make informed business decisions. Gain practical insights into key financial ratios and their implications for profitability, liquidity, and solvency. Whether you're a business owner, manager, or aspiring analyst, this course equips you with the tools to analyze financial data effectively and drive strategic decision-making.

Overview This comprehensive course on Stock Market Investing for Beginners will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Stock Market Investing for Beginners comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? At the end of the course there will be an online written test, which you can take either during or after the course. After successfully completing the test you will be able to order your certificate, these are included in the price. Who is This course for? There is no experience or previous qualifications required for enrolment on this Stock Market Investing for Beginners . It is available to all students, of all academic backgrounds. Requirements Our Stock Market Investing for Beginners is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 20 sections • 20 lectures • 02:10:00 total length •Module 01: Introduction to the Course .: 00:01:00 •Module 02: Introduction to Stocks.: 00:04:00 •Module 03: Money Required for Primary Investment.: 00:02:00 •Module 04: Opening an Investment Account.: 00:05:00 •Module 05: Brokerage Account Walkthrough.: 00:13:00 •Module 06: Finding Winning Stocks.: 00:24:00 •Module 07: Earning from Dividends.: 00:06:00 •Module 08: Diversifying Portfolio.: 00:05:00 •Module 09: Investment Plan.: 00:07:00 •Module 10: Rebalancing Portfolio.: 00:05:00 •Module 11: Understanding Order Types.: 00:05:00 •Module 12: Investment Tax.: 00:06:00 •Module 13: Investment Rules: Rule-1: 00:01:00 •Module 14: Investment Rules: Rule-2.: 00:01:00 •Module 15: Investment Rules: Rule-3.: 00:02:00 •Module 16: Investment Rules: Rule-4.: 00:02:00 •Module 17: Investment Rules: Rule-5.: 00:01:00 •Module 18: Stock Market Dictionary.: 00:10:00 •Module 19: Setting Up the Trading Platform.: 00:30:00 •Assignment -Stock Market Investing for Beginners: 00:00:00

Taxation is an evergreen, typically stable, and fast-growing job. Contrary to common assumptions, the life of a tax professional is exciting and fast-paced rather than tedious and repetitive. Along with accounting expertise, it is necessary to have strong analytical, commercial, and problem-solving skills. If you have what it takes to succeed as a tax expert, we offer an out-of-the-box and strategically designed UK Tax Accounting at QLS Level 5 course to get you started. This course will assist you in establishing a solid foundation in UK Tax Accounting. You will learn all there is to know about individual taxation, national insurance, and submitting a self-assessment tax return. You will also be familiar with income tax, including the roles of the payee, payroll, and wages. In addition, you will learn about corporate tax, as well as double-entry accounting. In the last session, you will learn about the fascinating career options available as a Tax Accountant in the United Kingdom. To remain competitive as a tax professional, it is critical to be upto date, broaden your experience, and implement cutting-edge tactics. With the help of this course, you may hone your skills, or someone interested in learning Tax can get new knowledge and prepare for numerous opportunities to present themselves. So hurry up and enrol today! Learning Outcomes Upon completion of the UK Tax Accounting at QLS Level 5 course, you will be able to, Learn about the tax system and administration in the UK. File a self-assessment tax return. Understanding income tax principles. Manage any tax issues that businesses deal with regularly. Discover the fundamentals of payroll. Experts created the course to provide a rich and in-depth training experience for all students who enrol in it. Enrol in the course right now and you'll have immediate access to all of the UK Tax Accounting course materials. Then, from any internet-enabled device, access the course materials and learn when it's convenient for you. Start your learning journey straight away with this course and take a step toward a brighter future! Why Prefer this Course? Opportunity to earn a certificate endorsed by the Quality Licence Scheme and another certificate accredited by CPDQS after completing this course Student ID card with amazing discounts - completely for FREE! (£10 postal charge will be applicable for international delivery) Standard-aligned lesson planning Innovative and engaging content and activities Assessments that measure higher-level thinking and skills Complete the program in your own time, at your own pace Each of our students gets full 24/7 tutor support *** Course Curriculum *** >> UK Tax Accounting << Module 01: Introduction to Accounting Module 02: Income Statement and Balance Sheet Module 03: Tax System and Administration in the UK Module 04: Tax on Individuals Module 05: National Insurance Module 06: How to Submit a Self-Assessment Tax Return Module 07: Fundamentals of Income Tax Module 08: Payee, Payroll, and Wages Module 09: Value-Added Tax Module 10: Corporation Tax Module 11: Double Entry Accounting Module 12: Career as a Tax Accountant in the UK Assessment Process We offer an integrated assessment framework to make the process of evaluating learners easier. After completing an online module, you will be given immediate access to a specially designed MCQ test. The results will be immediately analyzed, and the score will be shown for your review. The passing score for each test will be set at 60%. You will be entitled to claim a certificate endorsed by the Quality Licence Scheme after you have completed all of the exams. CPD 150 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Is This Course Right for You? Anyone interested in learning more about this subject should take this course. This will help you grasp the basic concepts as well as develop a thorough understanding of the subject. All are welcome to take this course. There are no prerequisites for enrolment, and you can access the course materials from any location in the world. Requirements If you have a passion for knowledge and want to learn something new, register on this course without any delay. We only ask that all students have a passion for learning and literacy, and be over the age of 16. Complete the course online from your computer, tablet, or smartphone, and learn in a way that suits you. Career path Tax Accountant. Tax Administrator. Tax Consultant. The average salary of these professions ranges from £40,000 to £70,000 per annum. Certificates CPD Accredited Certificate Digital certificate - £10 Diploma in UK Tax Accounting at QLS Level 5 Hard copy certificate - £119 Additional info After successfully completing the Diploma in UK Tax Accounting at QLS Level 5, you can order an original hardcopy certificate of achievement endorsed by the Quality Licence Scheme. The certificate will be home-delivered, with a pricing scheme of - 119 GBP inside the UK 129 GBP (including postal fees) for international delivery CPD Accredited Certificate 29 GBP for Printed Hardcopy Certificate inside the UK 39 GBP for Printed Hardcopy Certificate outside the UK (international delivery)

Learn new skills and develop your professional knowledge with UK Tax Accounting and learn from home at a pace that suits you. The course has been expertly designed for you to complete through distance e-learning also gain relevant skills and acquire tremendous knowledge on the subject all without leaving your own home! The certification you achieve after completing the course will help you greatly in procuring a job in the relevant field. Once you enrol on the course, you will have full course access for one year, meaning you are free to complete the course at a pace that suits you. Enrol on the UK Tax Accounting now and start studying using any internet-enabled device, including computers, tablets, and smartphones. With 24/7 student support offered to you on this course, you can be sure of quick and comprehensive assistance whenever you need it. Enrol now on the course and get access to top-quality training modules which will cover the essential topics you need to excel in your chosen field and help push you towards your dream job! Why Prefer this Course? Opportunity to earn a certificate accredited by CPD after completing this course Student ID card with amazing discounts - completely for FREE! (£10 postal charges will be applicable for international delivery) Standard-aligned lesson planning Innovative and engaging content and activities Assessments that measure higher-level thinking and skills Complete the course program in your own time, at your own pace Each of our students gets full 24/7 tutor support *** Course Curriculum *** Module 01: Introduction to Accounting Module 02: Income Statement and Balance Sheet Module 03: Tax System and Administration in the UK Module 04: Tax on Individuals Module 05: National Insurance Module 06: How to Submit a Self-Assessment Tax Return Module 07: Fundamentals of Income Tax Module 08: Payee, Payroll and Wages Module 09: Value Added Tax Module 10: Corporation Tax Module 11: Double Entry Accounting Module 12: Career as a Tax Accountant in the UK Assessment Process Once you have finished the learning stages in this course, your abilities will be assessed by an automated multiple-choice question session, after which you will receive the results immediately. Showcase Your Accomplishment of New Skills: Get a Certification of Completion The learners have to successfully complete the assessment of this course to achieve the CPD accredited certificate. Digital certificates can be ordered for only £10. The learner can purchase printed hard copies inside the UK for £29, and international students can purchase printed hard copies for £39. CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The course has been professionally designed for motivated learners who are looking to add a new skill to their CV and stand head and shoulders above the competition. Learn the latest industry-specific information with UK Tax Accounting. Enrol on the course and learn a new professional skill from anywhere, at any time! Requirements Enrol on the UK Tax Accounting with no formal entry requirements! If you have a passion for knowledge and want to learn something new, register on the UK Tax Accounting without any delay. We only ask that all students have a passion for learning and literacy, and be over the age of 16. Complete the UK Tax Accounting online from your computer, tablet, or smartphone, and learn in a way that suits you.

All in One Bundle Special Discount Offer Are you looking to enhance your Quickbooks and Accountancy skills? If yes, then you have come to the right place. Our comprehensive courses on Quickbooks and Accountancy will assist you in producing the best possible outcome by learning the Quickbooks and Accountancy skills. Main Course: Quickbooks Bonus Courses: Course 01: Introduction to Accounting Course 02: Tax Accounting The Quickbooks and Accountancy bundle is for those who want to be successful. In the Quickbooks and Accountancy bundle, you will learn the essential knowledge needed to become well versed in Quickbooks and Accountancy . Our Quickbooks and Accountancy bundle starts with the basics of Quickbooks and Accountancy and gradually progresses towards advanced topics. Therefore, each lesson of this Quickbooks and Accountancy is intuitive and easy to understand. Why would you choose the Quickbooks and Accountancy course from Compliance Central: Lifetime access to Quickbooks and Accountancy courses materials Full tutor support is available from Monday to Friday with the Quickbooks and Accountancy course Learn Quickbooks and Accountancy skills at your own pace from the comfort of your home Gain a complete understanding of Quickbooks and Accountancy course Accessible, informative Quickbooks and Accountancy learning modules designed by expert instructors Get 24/7 help or advice from our email and live chat teams with the Quickbooks and Accountancy bundle Study Quickbooks and Accountancy in your own time through your computer, tablet or mobile device. A 100% learning satisfaction guarantee with your Quickbooks and Accountancy Course Improve your chance of gaining in demand skills and better earning potential by completing the Quickbooks and Accountancy Curriculum Breakdown for Quickbooks Course: Course 01: Getting prepared - access the software and course materials Course 02: Getting started Course 03: Setting up the system Course 04: Nominal ledger Course 05: Customers Course 06: Suppliers Course 07: Sales ledger Course 08: Purchases ledger Course 09: Sundry payments Course 10: Sundry receipts Course 11: Petty cash Course 12: VAT - Value Added Tax Course 13: Bank reconciliation Course 14: Payroll / Wages CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The Quickbooks and Accountancy bundle helps aspiring professionals who want to obtain the knowledge and familiarise themselves with the skillsets to pursue a career in Quickbooks and Accountancy. It is also great for professionals who are already working in Quickbooks and Accountancy and want to get promoted at work. Requirements To enrol in this Quickbooks and Accountancy course, all you need is a basic understanding of the English Language and an internet connection. Career path The Quickbooks and Accountancy bundle will enhance your knowledge and improve your confidence in exploring opportunities in various sectors related to Quickbooks and Accountancy . Certificates Certificate of completion Digital certificate - Included Get CPD accredited PDF certificates for Free. Certificate of completion Hard copy certificate - Included Get a CPD accredited Hardcopy certificate for Free. After successfully completing this Forex course, you get a PDF and a hardcopy certificate for free. The delivery charge of the hardcopy certificate inside the UK is £3.99 and international students need to pay £9.99 to get their hardcopy certificate.

Highlights of the Course Course Type: Online Learning Duration: 1 to 2 hours Tutor Support: Tutor support is included Customer Support: 24/7 customer support is available Quality Training: The course is designed by an industry expert Recognised Credential: Recognised and Valuable Certification Completion Certificate: Free Course Completion Certificate Included Instalment: 3 Installment Plan on checkout What you will learn from this course? Gain comprehensive knowledge about Excel for financial modelling Understand the core competencies and principles of Excel for financial modelling Explore the various areas of Excel for financial modelling Know how to apply the skills you acquired from this course in a real-life context Become a confident and expert office admin Quick Excel for Financial Modeling Course Online Master the skills you need to propel your career forward in accounting. This course will equip you with the essential knowledge and skillset that will make you a confident accountant and take your career to the next level. This comprehensive Quick Excel for Financial Modeling Course Online is designed to help you surpass your professional goals. The skills and knowledge that you will gain through studying this Quick Excel for Financial Modeling Course Online will help you get one step closer to your professional aspirations and develop your skills for a rewarding career. This Quick Excel for Financial Modelling at QLS Level 5 course is endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. This comprehensive course will teach you the theory of effective accounting practice and equip you with the essential skills, confidence and competence to assist you in the accounting industry. You'll gain a solid understanding of the core competencies required to drive a successful career in accounting. This course is designed by industry experts, so you'll gain knowledge and skills based on the latest expertise and best practices. This extensive course is designed for accountant or for people who are aspiring to specialise in accounting.This Quick Excel for Financial Modelling at QLS Level 5 course has been endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. This course is not regulated by Ofqual and is not an accredited qualification. Enrol in this Quick Excel for Financial Modeling Course Online today and take the next step towards your personal and professional goals. Earn industry-recognised credentials to demonstrate your new skills and add extra value to your CV that will help you outshine other candidates. Who is this Course for? This comprehensive Quick Excel for Financial Modeling Course Online is ideal for anyone wishing to boost their career profile or advance their career in this field by gaining a thorough understanding of the subject. Anyone willing to gain extensive knowledge on this accounting can also take this course. Whether you are a complete beginner or an aspiring professional, this course will provide you with the necessary skills and professional competence, and open your doors to a wide number of professions within your chosen sector. Entry Requirements This Quick Excel for Financial Modeling Course Online has no academic prerequisites and is open to students from all academic disciplines. You will, however, need a laptop, desktop, tablet, or smartphone, as well as a reliable internet connection. Assessment This Quick Excel for Financial Modeling Course Online assesses learners through multiple-choice questions (MCQs). Upon successful completion of the modules, learners must answer MCQs to complete the assessment procedure. Through the MCQs, it is measured how much a learner could grasp from each section. In the assessment pass mark is 60%. Advance Your Career This Quick Excel for Financial Modeling Course Online will provide you with a fresh opportunity to enter the relevant job market and choose your desired career path. Additionally, you will be able to advance your career, increase your level of competition in your chosen field, and highlight these skills on your resume. Recognised Accreditation This course is accredited by continuing professional development (CPD). CPD UK is globally recognised by employers, professional organisations, and academic institutions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. What is CPD? Employers, professional organisations, and academic institutions all recognise CPD, therefore a credential from CPD Certification Service adds value to your professional goals and achievements. Benefits of CPD Improve your employment prospects Boost your job satisfaction Promotes career advancement Enhances your CV Provides you with a competitive edge in the job market Demonstrate your dedication Showcases your professional capabilities What is IPHM? The IPHM is an Accreditation Board that provides Training Providers with international and global accreditation. The Practitioners of Holistic Medicine (IPHM) accreditation is a guarantee of quality and skill. Benefits of IPHM It will help you establish a positive reputation in your chosen field You can join a network and community of successful therapists that are dedicated to providing excellent care to their client You can flaunt this accreditation in your CV It is a worldwide recognised accreditation What is Quality Licence Scheme? This course is endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. Benefits of Quality License Scheme Certificate is valuable Provides a competitive edge in your career It will make your CV stand out Course Curriculum Introduction Course Overview 00:04:00 Planning your Financial Model 00:09:00 Building a Model Template 00:12:00 Projecting the Income Statement 00:13:00 Projecting the Balance Sheet 00:17:00 Projecting Cash Flows 00:14:00 Advanced Financial Modeling 00:14:00 BONUS LESSON: Top 5 Excel Features for Financial Modellers 00:08:00 Supporting Materials Slides: Financial Modeling Using Excel 00:00:00 Financial Modeling Using Excel Glossary/Index 00:00:00 Excel Files “Start and Solution” 00:00:00 Obtain Your Certificate Order Your Certificate of Achievement 00:00:00 Get Your Insurance Now Get Your Insurance Now 00:00:00 Feedback Feedback 00:00:00

What Will I Learn? Know what Arbitrage is and how to make money with arbitrage Be able to apply 3 easy and efficient methods of online arbitrage Get started with online arbitrage and build an online business Know what marketplaces to use for online arbitrage Know the tips & tricks to maximise results and optimise their businesses Requirements No prior experience or special equipment is needed. Description Arbitrage is one of the best and most lucrative business models since the Internet changed the way economy and commerce is done forever. This is a business model that you can start today without actually having to invest any money at all and it's also an activity that can be started part-time or as a sidekick for anyone looking to create multiple streams of income. The fun fact is that people all around the world are using the power of arbitrage and the internet to build time freedom and the lifestyle that they desire. People are doing even multiple 5 figures per month using the power of Arbitrage in different fields of physical products, services and digital products. In this course, you will learn 3 easy methods to start your own online arbitrage business today without actually having to invest any money at all. Practically in this course, you will learn: How Arbitrage Works What are Physical Products Arbitrage and how to do it How to do Services Arbitrage What are Digital Products and how to do arbitrage with them Which are the best marketplaces to do arbitrage on Tips & Tricks to maximise your earnings and optimise your business and much more... So, join this class today and learn how to take advantage of the powerful concept or Arbitrage combined with the Internet! PS: Inside you will discover 3 highly lucrative arbitrage models that YOU CAN START TODAY! Who is the target audience? Anyone interested in starting an online business with 0 costs Anyone interested in building a new income source Anyone interested in learning how to make money online with arbitrage Introduction to the Business Model Introduction to Arbitrage 00:06:00 Working with Physical Products Arbitrage 00:06:00 Working with Digital Products Arbitrage 00:09:00 How to Leverage Online Marketplaces The Power of Online Marketplaces 00:04:00 Working with Ebay - TOP TIPS 00:04:00 Using Etsy and Storenvy 00:07:00 2 Efficient Methods to Find Products to Sell 00:06:00 Maximizing your Ebay Results How to setup your Ebay Account 00:04:00 Preparing your Ebay Seller Account 00:02:00 Seting the right Ebay Seller Preferences 00:07:00 How to create an Ebay Listing 00:11:00 Arbitrage With Designs And GearBubble Introduction To Gearbubble 00:16:00 How To Use Gearbubble 00:10:00

If you want to start your import-export business but don't know where to start, this Import/Export Business course will guide you through the process. Through this course, you'll learn the process of purchasing products, packing, shipping, and selling them for maximum profits. This Import/Export Business course will teach you the essential steps to start your import-export business. It will introduce you to the import-export operations. You will learn how to choose the right products for your business. You'll also learn how to target the market and find your ideal customers. Our exclusive lectures will also educate you on supply chain management and familiarise you with the necessary tools for trading.  Learning Objectives Learn how to organise for import and export operations Be able to choose the right products for your business Know how to target the market and find the ideal customers Understand the process of searching, marketing, and distribution Learn about documentation and supply chain management Know about the pricing, payment, and shipping procedureDetermine the necessary tools for trading Who is this Course for? This Import/Export Business course 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 import-export business 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 Anyone interested in learning more about this subject should take this Import/Export Business course. 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 £4.99 and the hard copy for £9.99. Also, you can order both PDF and hardcopy certificates for £12.99. Career path On successful completion of the Import/Export Business 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: Import Operator Import Clerk Import Manager Import Administrator Import & Export Controller Supply Chain Coordinator Import & Export Coordinator Sales & Shipping Administrator Management Consultant Lead Course Curriculum Module 01: Introduction to Import Export Introduction to Import Export 00:20:00 Module 02: Organising the Import Export Operation Organising the Import Export Operation 00:26:00 Module 03: Products for Your Import Export Business Products for Your Import Export Business 00:23:00 Module 04: Target the Marketing and Find Your Customers Target the Marketing and Find Your Customers 00:23:00 Module 05: Searching, Marketing, and Distribution Searching, Marketing, and Distribution 00:24:00 Module 06: Documentation and Supply Chain Management Documentation and Supply Chain Management 00:14:00 Module 07: Pricing, Payment and Shipping Procedure Pricing, Payment and Shipping Procedure 00:22:00 Module 08: Necessary Tools for Trading Necessary Tools for Trading 00:12:00 Assignment Assignment - Import/Export Business 00:00:00 Certificate and Transcript Order Your Certificates or Transcripts 00:00:00

Gain the solid skills and knowledge to kickstart a successful career and learn from the experts with this

Excel Crash Course is yet another 'Teacher's Choice' course from Teachers Training for a complete understanding of the fundamental topics. You are also entitled to exclusive tutor support and a professional CPD-accredited certificate in addition to the special discounted price for a limited time. Just like all our courses, this Excel Crash Course and its curriculum have also been designed by expert teachers so that teachers of tomorrow can learn from the best and equip themselves with all the necessary skills. Consisting of several modules, the course teaches you everything you need to succeed in this profession. The course can be studied part-time. You can become accredited within 03 Hours studying at your own pace. Your qualification will be recognised and can be checked for validity on our dedicated website. Why Choose Teachers Training Some of our website features are: This is a dedicated website for teaching 24/7 tutor support Interactive Content Affordable price Courses accredited by the UK's top awarding bodies 100% online Flexible deadline Entry Requirements No formal entry requirements. You need to have: Passion for learning A good understanding of the English language Be motivated and hard-working Over the age of 16. Certification CPD Certification from The Teachers Training Successfully completing the MCQ exam of this course qualifies you for a CPD-accredited certificate from The Teachers Training. You will be eligible for both PDF copy and hard copy of the certificate to showcase your achievement however you wish. You can get your digital certificate (PDF) for £4.99 only Hard copy certificates are also available, and you can get one for only £10.99 You can get both PDF and Hard copy certificates for just £12.99! The certificate will add significant weight to your CV and will give you a competitive advantage when applying for jobs. Analysis of Twitter Dataset and Designing Heatmaps Introduction to the Excel crash course 00:06:00 Understanding the Twitter Dataset 00:05:00 Extracting Other Details for Analysis 00:09:00 Creating Pivot Tables 00:08:00 Applying Conditional Formatting using Color Scales 00:03:00 Adding Slicers to Dashboard 00:02:00 Applying Custom Number Formats 00:03:00 Adding Custom Images to Charts 00:11:00 Interlude - Data Manipulation Challenge 00:02:00 Adding Heatmap Legend 00:02:00 Wrapping Up - Introduction to Open Analytics 00:02:00 Advanced Currency Converter using Dynamic Arrays Introduction to Modern Excel Tables and Dynamic Arrays 00:11:00 Using Power Query for Data Manipulation 00:08:00 Applying Power Query Data Transformations 00:06:00 Structured Table Referencing 00:12:00 XLOOKUP Function and Pivot Table Calculations 00:05:00 Laundry Service Model and Invoicing Dashboard Introduction to the Project 00:01:00 Overview of the Laundry Model Project 00:04:00 Understanding the Inputs 00:03:00 Formatting the Input Tables 00:04:00 Duplicate and Combine Tables with Power Query 00:09:00 Rounding Digits in Power Query 00:02:00 Load Specific Tables from Power Query 00:02:00 Feature Extraction and Named Ranges 00:10:00 Combining Elements - Data Validation with Named Ranges 00:08:00 Combining Elements - Understanding the INDIRECT Function 00:02:00 Combining Elements - Dynamic Drop-down Menu with Data Validation 00:04:00 Combining Elements - INDEX and MATCH with Multiple Criteria 00:12:00 Understanding the MATCH Formula with Multiple Criteria 00:06:00 Business Invoice Dashboard Design 00:06:00