3201 Accounting & Finance courses in Pontypridd delivered Online

In today's rapidly evolving world, mastering Fundraising Fundamental Strategies is paramount for individuals seeking to make an impact in various sectors. Understanding the intricacies of fundraising is not just beneficial but essential for the sustainability of organizations. The Fundraising Fundamental Strategies Course offers a comprehensive overview, covering modules ranging from the basics of fundraising to advanced techniques such as Crowdfunding and Volunteer Management. In a competitive job market like the UK, possessing these skills significantly enhances one's employability. With a growing emphasis on philanthropy and corporate social responsibility, fundraisers are in high demand across industries. Learning these strategies opens doors to diverse job opportunities, with salaries ranging from £25,000 to £40,000 per annum, depending on experience and expertise. The advantages of this course are immense, especially considering that the fundraising sector is expanding steadily, with a projected growth rate of 10% over the next decade. Embracing Fundraising Fundamental Strategies not only enriches individuals' skill sets but also contributes to the betterment of society at large. Key Features: CPD Certified Developed by Specialist Lifetime Access Course Curriculum Module 01: Introduction to Fundraising Module 02: Hiring and Training Development Staff Module 03: The Fundraising Cycle Module 04: Establishing Governance Module 05: Managing Budget, Taxes and Accounting Module 06: Fundraising Sources Module 07: Arranging Successful Fundraising Events Module 08: Marketing, Public Relations and Communications Module 09: Tools and Resources that Can Help in Fundraising Module 10: Crowdfunding Module 11: The Organisation and Use of Volunteers Module 12: Risk Management Module 13: Legal Responsibilities Learning Outcomes: Recognize key concepts in fundraising to inform strategic decisions effectively. Implement effective hiring and training strategies for development staff members. Demonstrate understanding of the fundraising cycle and its constituent stages. Establish robust governance structures to ensure ethical and legal compliance. Manage budgets, taxes, and accounting processes within fundraising contexts proficiently. Utilise various fundraising sources, including crowdfunding, for organisational sustainability. CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This Fundraising Fundamental Strategies course is accessible to anyone eager to learn more about this topic. Through this course, you'll gain a solid understanding of Fundraising Fundamental Strategies. Moreover, this course is ideal for: Non-profit professionals seeking comprehensive fundraising knowledge. Individuals aspiring to work in fundraising or development roles. Charity workers aiming to enhance fundraising proficiency. Volunteers interested in supporting fundraising efforts within organisations. Small business owners seeking to improve fundraising strategies. Requirements There are no requirements needed to enrol into this Fundraising Fundamental Strategies course. We welcome individuals from all backgrounds and levels of experience to enrol into this Fundraising Fundamental Strategies course. Career path After finishing this Fundraising Fundamental Strategies course you will have multiple job opportunities waiting for you: Fundraising Manager - £30K to 45K/year. Development Officer - £25K to 35K/year. Marketing Coordinator (Non-profit) - £22K to 32K/year. Volunteer Coordinator - £20K to 30K/year. Finance and Administration Manager (Non-profit) - £28K to 40K/year. Certificates Digital certificate Digital certificate - Included Will be downloadable when all lectures have been completed.

Learn the basics of financial awareness and better understand the language used by accountants and how financial statements fit together within organisations. Course overview Duration: 2 days (13 hours)  This workshop will provide participants with a grasp of basic financial awareness, to help them to better understand the language used by accountants and how financial statements fit together. Training is done in a jargon-free way that is aimed building attendees’ confidence in using financial terms and concepts within their organisation.  Competent financial management has many aspects, it is wide reaching and requires multiple skills but if participants work to become organised and effective in planning, these skills can be easily acquired. There is a misconception that to be a good operational manager dealing with financial decisions people must be accounting or numerical geniuses. There are basic skills that attendees can easily learn that will support them in those areas.  Objectives  By the end of the course you will be able to: Identify the importance of financial management and its impact Identify the link between financial information and decision making Set, manage, monitor and review budgets Analyse financial statements Demonstrate the link between the statements, budgets and decision making. Content Financial Management Budgeting process (generic / client specific if possible) Forecasting and re forecasting process The need for accurate forecasting Accrual v cash accounting revisited Financial Objectives of the business Users of the accounts Financial Tools Depreciation and Amortisation Accruals and Prepayments Deferred and Accrued Income Costs, Opex and Capex Financial Statements The Income Statement The Balance Sheet Understanding capital employed The relationship between balance sheet and income statement The cash flow statement Profitability: gross, operating and net margins Review of client’s management information reports Building the Business Case Break even analysis Discounted Cash Flow Discount factors Net Present Value (NPV) Internal Rate of Return (IRR)

Overview Sage 50 Accounting & Payroll 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 Sage 50 Accounting & Payroll 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 05 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: Comprehensive and up-to-date curriculum 24/7 tutor support Interactive Content Affordable price Courses accredited by the UK's top awarding bodies 100% online 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 After you have successfully completed your assignment, you will be qualified to apply for a CPD Certification from The Teachers Training. The PDF certificate can be downloaded after you have completed your course. 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. Sage 50 Accounts Sage 50 Bookkeeper - Coursebook 01:54:00 Introduction and TASK 1 00:17:00 TASK 2 Setting up the System 00:23:00 TASK 3 a Setting up Customers and Suppliers 00:17:00 TASK 3 b Creating Projects 00:05:00 TASK 3 c Supplier Invoice and Credit Note 00:13:00 TASK 3 d Customer Invoice and Credit Note 00:10:00 TASK 4 Fixed Assets 00:08:00 TASK 5 a and b Bank Payment and Transfer 00:30:00 TASK 5 c and d Supplier and Customer Payments and DD STO 00:18:00 TASK 6 Petty Cash 00:11:00 TASK 7 a Bank Reconnciliation Current Account 00:17:00 TASK 7 b Bank Reconciliation Petty Cash 00:09:00 TASK 7 c Reconciliation of Credit Card Account 00:16:00 TASK 8 Aged Reports 00:13:00 TASK 9 a Payroll 00:07:00 9 b Payroll Journal 00:10:00 TASK 10 Value Added Tax - Vat Return 00:12:00 Task 11 Entering opening balances on Sage 50 00:13:00 TASK 12 a Year end journals - Depre journal 00:05:00 TASK 12 b Prepayment and Deferred Income Journals 00:08:00 TASK 13 a Budget 00:05:00 TASK 13 b Intro to Cash flow and Sage Report Design 00:08:00 TASK 13 c Preparation of Accountants Report & correcting Errors (1) 00:10:00 Sage 50 Payroll Payroll Basics 00:10:00 Company Settings 00:08:00 Legislation Settings 00:07:00 Pension Scheme Basics 00:06:00 Pay Elements 00:14:00 The Processing Date 00:07:00 Adding Existing Employees 00:08:00 Adding New Employees 00:12:00 Payroll Processing Basics 00:11:00 Entering Payments 00:12:00 Pre-Update Reports 00:09:00 Updating Records 00:09:00 e-Submissions Basics 00:09:00 Process Payroll (November) 00:16:00 Employee Records and Reports 00:13:00 Editing Employee Records 00:07:00 Process Payroll (December) 00:12:00 Resetting Payments 00:05:00 Quick SSP 00:10:00 An Employee Leaves 00:13:00 Final Payroll Run 00:07:00 Reports and Historical Data 00:08:00 Year-End Procedures 00:09:00 Assignment Assignment - Sage 50 Accounting & Payroll 00:00:00

Are you ready to embark on an enlightening journey of wisdom with the CRM bundle, and pave your way to an enriched personal and professional future? If so, then Step into a world of knowledge with our course bundle - CRM : Customer Relationship Management. Delve into eight immersive CPD Accredited courses, each a standalone course: Customer Relationship Management Know Your Customer (KYC) Phone-Based Customer Service Customer Service Fraud Officer Win Customers Efficiently: Customer Service Diploma Know the Selling Strategies that Boost Customer Acquisition Sales: Psychology of Customers Effective Communication Skills Traverse the vast landscapes of theory, unlocking new dimensions of understanding at every turn. Let the CRM : Customer Relationship Management bundle illuminate your path to wisdom. The CRM : Customer Relationship Management bundle offers a comprehensive exploration into a rich tapestry of vast knowledge across eight carefully curated courses. The journey is designed to enhance your understanding and critical thinking skills. Each course within the bundle provides a deep-dive into complex theories, principles, and frameworks, allowing you to delve into the nuances of the subject matter at your own pace. In the framework of the CRM : Customer Relationship Management package, you are bestowed with complimentary PDF certificates for all the courses included in this bundle, all without any additional charge. Adorn yourself with the CRM bundle, empowering you to traverse your career trajectory or personal growth journey with self-assurance. Register today and ignite the spark of your professional advancement! So, don't wait further and join the CRM : Customer Relationship Management community today and let your voyage of discovery begin! Learning Outcomes: Attain a holistic understanding in the designated areas of study with the CRM bundle. Establish robust bases across each course nestled within the CRM bundle. Decipher intricate concepts through the articulate content of the CRM bundle. Amplify your prowess in interpreting, scrutinising, and implementing theories. Procure the capacity to engage with the course material on an intellectual and profound level. Become proficient in the art of problem-solving across various disciplines. Stepping into the CRM bundle is akin to entering a world overflowing with deep theoretical wisdom. Each course within this distinctive bundle is an individual journey, meticulously crafted to untangle the complex web of theories, principles, and frameworks. Learners are inspired to explore, question, and absorb, thus enhancing their understanding and honing their critical thinking skills. Each course invites a personal and profoundly enlightening interaction with knowledge. The CRM bundle shines in its capacity to cater to a wide range of learning needs and lifestyles. It gives learners the freedom to learn at their own pace, forging a unique path of discovery. More than just an educational journey, the CRM bundle fosters personal growth, enabling learners to skillfully navigate the complexities of the world. The CRM bundle also illuminates the route to a rewarding career. The theoretical insight acquired through this bundle forms a strong foundation for various career opportunities, from academia and research to consultancy and programme management. The profound understanding fostered by the CRM bundle allows learners to make meaningful contributions to their chosen fields. Embark on the CRM journey and let knowledge guide you towards a brighter future. CPD 80 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Individuals keen on deepening their firm understanding in the respective fields. Students pursuing higher education looking for comprehensive theory modules. Professionals seeking to refresh or enhance their knowledge. Anyone with a thirst for knowledge and a passion for continuous learning. Career path Armed with the CRM bundle, your professional journey can reach new heights. The comprehensive theoretical knowledge from this bundle can unlock diverse career opportunities across several fields. Whether it's academic research, consultancy, or programme management, the CRM bundle lays a solid groundwork. Certificates CPD Certificate Of Completion Digital certificate - Included 8 Digital Certificates Are Included With This Bundle CPD Quality Standard Hardcopy Certificate (FREE UK Delivery) Hard copy certificate - £9.99 Hardcopy Transcript - £9.99

Are you ready to embark on an enlightening journey of wisdom with the Facilities Management bundle, and pave your way to an enriched personal and professional future? If so, then Step into a world of knowledge with our bundle - Diploma in Facilities Management. Delve into eight immersive CPD Accredited courses, each a simple course: Course 1: Facilities Management Diploma Course 2: Project Management Training Course 3: Operations Management Course 4: Business Management Course 5: Team Management Level 5 Course 6: Financial Management Course 7: Payroll Management and Systems Diploma Course 8: Decision Making and Critical Thinking Traverse the vast landscapes of theory, unlocking new dimensions of understanding at every turn. Let the Diploma in Facilities Management bundle illuminate your path to wisdom. The Diploma in Facilities Management bundle offers a comprehensive exploration into a rich tapestry of vast knowledge across eight carefully curated courses. The journey is designed to enhance your understanding and critical thinking skills. Each course within the bundle provides a deep-dive into complex theories, principles, and frameworks, allowing you to delve into the nuances of the subject matter at your own pace. In the framework of the Diploma in Facilities Management package, you are bestowed with complimentary PDF certificates for all the courses included in this bundle, all without any additional charge. Adorn yourself with the Facilities Management bundle, empowering you to traverse your career trajectory or personal growth journey with self-assurance. Register today and ignite the spark of your professional advancement! So, don't wait further and join the Diploma in Facilities Management community today and let your voyage of discovery begin! Learning Outcomes: Upon completion of the Diploma in Facilities Management Bundle, you will be able to: Attain a holistic understanding in the designated areas of study with the Facilities Management bundle. Establish robust bases across each course nestled within the Facilities Management bundle. Decipher intricate concepts through the articulate content of the Facilities Management bundle. Amplify your prowess in interpreting, scrutinising, and implementing theories. Procure the capacity to engage with the course material on an intellectual and profound level. Become proficient in the art of problem-solving across various disciplines. Stepping into the Diploma in Facilities Management bundle is akin to entering a world overflowing with deep theoretical wisdom. Each course within this distinctive bundle is an individual journey, meticulously crafted to untangle the complex web of theories, principles, and frameworks. Learners are inspired to explore, question, and absorb, thus enhancing their understanding and honing their critical thinking skills. Each course invites a personal and profoundly enlightening interaction with knowledge. The Facilities Management bundle shines in its capacity to cater to a wide range of learning needs and lifestyles. It gives learners the freedom to learn at their own pace, forging a unique path of discovery. More than just an educational journey, the Diploma in Facilities Management bundle fosters personal growth, enabling learners to skillfully navigate the complexities of the world. The Facilities Management bundle also illuminates the route to a rewarding career. The theoretical insight acquired through this bundle forms a strong foundation for various career opportunities, from academia and research to consultancy and programme management. The profound understanding fostered by the Facilities Management bundle allows learners to make meaningful contributions to their chosen fields. Embark on the Facilities Management journey and let knowledge guide you towards a brighter future. CPD 80 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Individuals keen on deepening their firm understanding in the respective fields. Students pursuing higher education looking for comprehensive theory modules. Professionals seeking to refresh or enhance their knowledge. Anyone with a thirst for knowledge and a passion for continuous learning. Requirements Without any formal requirements, you can delightfully enrol in this Diploma in Facilities Management Bundle. Career path Armed with the Diploma in Facilities Management bundle, your professional journey can reach new heights. The comprehensive theoretical knowledge from this bundle can unlock diverse career opportunities across several fields. Whether it's academic research, consultancy, or programme management, the Facilities Management bundle lays a solid groundwork. Certificates CPD Certificate Of Completion Digital certificate - Included 8 Digital Certificates Are Included With This Bundle CPD Quality Standard Hardcopy Certificate (FREE UK Delivery) Hard copy certificate - £9.99 Hardcopy Transcript: £9.99

AML course will help you to learn how to handle regulatory expectations and protect your organisation, business, and profession from money laundering risks.

Business Finance and Revenue Operations Diploma Upgrade your financial acumen with the Business Finance and Revenue Operations Diploma. This course is designed to equip you with essential skills and knowledge, spanning from the fundamentals of business finance to the intricacies of revenue operations. Learning Outcomes: Acquire a thorough understanding of the various branches of business finance. Master the business finance cycle, from planning to execution. Distinguish between personal and business finance. Analyze financial performance through business finance analysis. Gain proficiency in revenue operations skills. Learn the art of aligning revenue teams for optimum performance. More Benefits: LIFETIME access Device Compatibility Free Workplace Management Toolkit Key Modules from Business Finance and Revenue Operations Diploma: Branches of Business Finance: Explore the key branches of business finance, such as corporate finance, investments, and financial markets, to develop a holistic understanding of the field. Business Finance Cycle: Familiarize yourself with the stages of the business finance cycle, including budgeting, forecasting, and long-term planning. Personal Finance: Delve into the distinctions between personal and business finance, focusing on risk management, investment strategies, and liquidity management. Business Finance Analysis: Learn advanced techniques for analyzing a company's financial health, including key performance indicators and financial ratios. Revenue Operations Skills: Acquire the necessary skill set for effective revenue operations, encompassing data analysis, automation, and cross-functional collaboration. Aligning Revenue Teams: Understand the importance of aligning revenue-generating teams like sales, marketing, and customer success for achieving organisational goals.

Master the critical domain of Know Your Client (KYC) practices with this in-depth course. Gain a comprehensive understanding of KYC regulations, client due diligence, anti-money laundering, and more. Elevate your compliance acumen and set a new standard in client onboarding and risk assessment.

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

Learning Objectives Introduction , Getting Started with VBA , Working with Variables , Working with Conditional Logic , Working with Strings and String Functions , Working with Loops , Working with Sub Procedures Options and Functions , Working with User Forms , Debugging your Code , Conclusion   Pre-Requisites Intermediate Microsoft Excel training or equivalent experience is recommended.   Description This course will teach students proper Visual Basic programming techniques along with an understanding of Excel's object structure. Students will learn how to work with variables, how to use various conditional logic statements such as If and Else, and how to work with string functions. Students will also learn how to work with various loops such as next loops and each loops, as well as how to create user forms. Finally, students will get an in-depth understanding of the debugging tools available and how to effectively debug their code. Course Introduction Introduction 00:03:00 Section 01 Lesson 1-Adding the Developer Toolbar 00:05:00 Lesson 2-Understanding the VBA Editor 00:11:00 Lesson 3-Recording a Macro in Personal 00:10:00 Lesson 4-Understanding the Elements of the VBA Language 00:07:00 Lesson 5-Understanding Methods 00:05:00 Lesson 6-Understanding Comments 00:06:00 Lesson 7-Working with the Range Property and Worksheet Object 00:07:00 Lesson 8-Adding a Macro Button to a Spreadsheet 00:03:00 Lesson 9-Working with the ActiveCell Object 00:02:00 Lesson 10-Working with the Offset Property 00:08:00 Section 02 Lesson 1-Understanding Variables 00:07:00 Lesson 2-Working with Integer Variables 00:03:00 Lesson 3-Understanding Option Explicit 00:05:00 Lesson 4-Working with Other Variable Types 00:07:00 Section 03 Lesson 1-Working with IF Statements 00:04:00 Lesson 2-Working with ELSE 00:03:00 Lesson 3-Working with ELSEIF 00:03:00 Lesson 4-Understanding Conditional Operators 00:06:00 Lesson 5-Working with NOT, AND, and OR 00:07:00 Lesson 6-Working with Nested IF 00:04:00 Lesson 7-Working with Select Case 00:06:00 Lesson 8-Working with WITH and END WITH 00:05:00 Section 04 Lesson 1-Working with Text Strings 00:05:00 Lesson 2-Working with LCASE and UCASE Functions 00:05:00 Lesson 3-Working with LEN and TRIM Functions 00:07:00 Lesson 4-Working with LEFT, RIGHT, and MID Functions 00:07:00 Section 05 Lesson 1-Understanding Loops 00:02:00 Lesson 2-Working with For Next Loops 00:07:00 Lesson 3-Working with For Each Loops 00:06:00 Lesson 4-Working with Cells Property 00:08:00 Lesson 5-Working with Do Until Loops 00:09:00 Lesson 6-Working with Do While Loops 00:05:00 Section 06 Lesson 1-Calling Sub Procedures 00:05:00 Lesson 2-Working with Exit Sub 00:04:00 Lesson 3-Working with Message Boxes 00:08:00 Lesson 4-Working with Input Boxes 00:08:00 Lesson 5-Working with VBA Functions 00:12:00 Lesson 6-Working with Object Variable and Set 00:06:00 Section 07 Lesson 1-Understanding and Creating a User Form 00:08:00 Lesson 2-Adding Controls to a User Form 00:16:00 Lesson 3-Adding Code for a User Form 00:10:00 Lesson 4-Launching a User Form from Excel 00:05:00 Section 08 Lesson 1-Getting Started with Debugging 00:10:00 Lesson 2-Stepping Through Your Code 00:06:00 Lesson 3-Working with Breakpoints 00:03:00 Lesson 4-Working with the Immediate Window 00:05:00 Lesson 5-Working with the Locals Window 00:05:00 Lesson 6-Working with the Err Object 00:06:00 Lesson 7-Getting Help-v2 00:07:00 Course Recap Recap 00:02:00 Additional Materials Resource - Excel 365 VBA Expert 00:00:00 Final Exam Final Exam - Excel 365 VBA Expert 00:20:00