136 Courses

What is this webinar about? (indicative) Phobias relate to intense fear or anxiety when exposed to specific objects or situations. They are very different to common childhood fears and can be a source of distress and restriction in adults. This workshop will look at specific techniques used in the contemporary treatment of specific phobias. Key Topics (indicative) Contexts DSM-5 and NICE frameworks Development of Phobias Treatment Exposure Based Treatments and Fear Hierarchies for Specific Phobia Safety Behaviours in Specific Phobias Particular Phobias Emetophobia Hemophobia Fear of Flying Summary and Review The workshop assumes no prior specialist knowledge of specific phobias What previous delegates have said about this workshop. A great overview of phobias. Very helpful to see a proposed treatment plan, learn about the processes involved with feared responses and have practical strategies also. I look forward to putting these into practice next week in CBT sessions! This is a fantastic workshop. Very practical. I now feel competent and confident working with clients who have different phobias and their treatment methods. Thank you Useful practical techniques for dealing with phobias in the therapy room Practical CBT lives up to its name again. Practical techniques and important facts you can put to use straightaway. Who is leading this webinar? Professor Patrick McGhee is a CBT therapist, psychologist and UK National Teaching Fellow. Educated at the universities of Glasgow and Oxford, he has completed CPD programmes at Harvard Business School and Ashridge. In 2017 he was a Visiting Fellow/Scholar at the universities of Cornell, Yale and MIT in the USA. He has taught, researched or practised in psychology and therapy for 30 years. His first post was a Research Fellow in Psychiatry and Psychology at St George's Hospital Medical School, University of London. He is the author of Thinking Psychologically (Palgrave) and co-editor of Accounting for Relationships (Methuen). He is an occasional columnist for the Guardian, the BBC and the Times Higher. He currently works in private practice in Greater Manchester. He has full accreditation from the British Association for Behavioural and Cognitive Psychotherapists.

Understand how to easily manage manual bookkeeping and maintain an accurate record with this Bookkeeping Systems course. You will learn how to significantly improve financial transaction maintenance and overall accounting for individuals or businesses. The Bookkeeping Systems Diploma course will teach you the fundamentals of accurate bookkeeping systems within hours. Manual bookkeeping is an effective way to keep a record of financial outgoing and income. It can be simply done by learning the key processes. Bookkeeping is essential for business and you can gain new skills to make you stand out by taking this course. Bookkeeping Systems is a best selling course developed by industry experts and already helped tons of students like you. It is suitable for anyone who wants to improve their knowledge and skills in the or relevant sector.  This course is accredited by CPD, so you will get a career boost upon completing this course. Our Bookkeeping Systems is packed with 8 modules and 56 minutes of study. You will be awarded with a certificate of completion, the proof of your expertise in this field. If you want to get a job or looking for professional skills to excel in this field, a certificate from this course will help you appear as a strong candidate. You can also validate your certification from our website. It doesn't matter if you are willing to study full-time or part-time. This course is designed for any type of student and you can even complete it at your own pace. The materials are accessible from anyplace, any device and anytime.  Besides that, our experienced tutors will help you throughout the comprehensive syllabus of this course and answer all your queries through email.

Webinar - Full Recording This webinar will provide an interactive overview on the use of experiential imagery and visualisation techniques in the treatment of anxiety, depression, trauma and suicide management. OVERVIEW Imagery and Thinking Activation and Consolidation TREATMENT Basic imagery techniques for all clients Imagery Techniques for anxiety, depression and anger Imagery Techniques for PTSD Imagery techniques for Compassion Focused Therapy Imagery Techniques in Suicide prevention Implementation for your practice. Imagery techniques applied to ourselves as therapists Summary What is the workshop about? This workshop will cover the the role of imagery in maintaining psychological distress and the use of visualisation-based techniques in therapeutic practice. There will be practical demonstrations and the opportunity to apply key techniques to therapists ourselves. Who should attend? This workshop is aimed at therapists, counsellors, advisers, educationalists, health care workers, social workers and students in these areas. It is particularly useful for counsellors who do not normally work within a cognitive or behavioural model but want to explore tried and tested techniques. Similarly, counsellors and therapists working within this tradition are likely to find this workshop a useful refresher in the latest approaches. It is also suitable for anyone with an interest in contemporary practice in this area. What have previous delegates said about this workshop? Particularly interesting to apply visualisation techniques to ourselves as therapists. Excellent . Very interesting .Thank you . I am newly qualified and though I have used imagery before, my experience is not that broad, so this was very helpful to understand how useful it can be across different disorders and also for me as a therapist. Excellent pacing, very resourceful and easy to understand. Lots of practical ideas to use for practice. Thank you! I loved this workshop, it was informative and give me more ideas as to how to use imagery. I feel more confident about using imagery in my role Informative, good ideas Engaging, well paced and informative. I'm a qualified CBT therapist and found this really increased my knowledge giving particular skills and ways of delivering. Very enjoyable and informative. I got new ideas for use of visualisation work with clients and also for my own self reflection. Thank you! This was a very informative workshop. I will use it in my practice I found it great, and I have used visualisation in a small way but feel I can approach with more confidence. Resources A full set of slides with extensive clickable links to online resources, is sent free to all delegates after the event. This also includes references to key sources. Who is leading this webinar? Professor Patrick McGhee is a CBT therapist, psychologist and UK National Teaching Fellow. Educated at the universities of Glasgow and Oxford, he has completed CPD programmes at Harvard Business School and Ashridge. In 2017 he was a Visiting Fellow/Scholar at the universities of Cornell, Yale and MIT in the USA. He has taught, researched or practised in psychology and therapy for 30 years. His first post was a Research Fellow in Psychiatry and Psychology at St George's Hospital Medical School, University of London. He is the author of Thinking Psychologically (Palgrave) and co-editor of Accounting for Relationships (Methuen). He is an occasional columnist for the Guardian, the BBC and the Times Higher. He currently works in private practice in Greater Manchester. He has full accreditation from the British Association for Behavioural and Cognitive Psychotherapists.

🌟 Unlock Financial Mastery with 'Mastering Precision in Bookkeeping with QuickBooks' 🌟 Are you ready to revolutionize your bookkeeping skills and take control of your financial success? Look no further! Introducing our exclusive online course: 'Mastering Precision in Bookkeeping with QuickBooks.'   🚀 Why Choose This Course? ✅ Comprehensive QuickBooks Training: Dive deep into the world of QuickBooks with our expert-led modules. From the basics to advanced features, you'll master every aspect of this powerful accounting tool. ✅ Precision in Bookkeeping: Learn the art of precision in bookkeeping-because accuracy is key. Our course will guide you through best practices, ensuring your financial records are flawless and audit-ready. ✅ Hands-On Learning: Gain practical experience through hands-on exercises and real-world scenarios. Apply your knowledge in a simulated environment, so you're ready to handle any bookkeeping challenge. ✅ Time-Saving Techniques: Discover time-saving tips and tricks to streamline your bookkeeping process. Boost your efficiency without compromising accuracy, allowing you to focus on growing your business. ✅ Expert Guidance: Our instructors are seasoned professionals with extensive experience in bookkeeping and QuickBooks. Benefit from their insights, tips, and personalized feedback throughout the course. ✅ Flexible Learning: Access the course anytime, anywhere. Whether you're a busy entrepreneur or a student, our flexible schedule allows you to learn at your own pace. ✅ Lifetime Access: Enjoy lifetime access to the course material and updates. Stay current with the latest QuickBooks features and industry trends, ensuring your skills are always in demand.   📚 What You'll Learn: QuickBooks Fundamentals: Master the basics of QuickBooks, from setting up your account to navigating the interface with ease. Advanced Features: Explore advanced QuickBooks features to enhance your bookkeeping capabilities and automate repetitive tasks. Financial Statement Mastery: Learn to create accurate financial statements that provide valuable insights into your business's financial health. Troubleshooting and Error Resolution: Develop the skills to identify and resolve common QuickBooks issues, ensuring data integrity. Custom Reporting: Customize reports to meet your business's unique needs, empowering you with actionable financial information.   🎓 Who Should Enroll: Small Business Owners Entrepreneurs Accounting Professionals Students pursuing a career in finance or accounting   🌈 Bonuses: Exclusive QuickBooks shortcuts guide Access to a private community for networking and support Q&A sessions with industry experts   Ready to elevate your bookkeeping game and become a QuickBooks pro? Enroll now in 'Mastering Precision in Bookkeeping with QuickBooks' and take the first step toward financial mastery!   Course Curriculum Basic Overview 00:00 AAA-Advisors-Attorneys-Accounts 00:00 Plans and Pricing 00:00 Advantages of The Cloud Based Version 00:00 Purchase of QB Online (Cloud) 00:00 a Basics of QB Set Up 00:00 b Basics of QB Set Up - Part 2 00:00 c Basics of QB Set Up - Part 3 00:00 Installation of Mobile App 00:00 Mileage Tracking 00:00 Entering Sales By Desktop 00:00 Entering Sales By Mobile 00:00 Entering Expenses Paid In Desktop 00:00 Entering Expenses Paid on Mobile 00:00 Capturing Reciepts 00:00 Organizing Reciepts 00:00 Entering Customers 00:00 Entering Invoices Sent To Customers 00:00 Entering Invoices Paid By Customers 00:00 Entering Invoices Sent By Vendors 00:00 Entering Invoices Paid To Vendors 00:00 Conclusion 00:00 Advanced Overview 00:00 Customer Refunds 00:00 Issuing Customer Credits 00:00 Vendor Refunds to You 00:00 Vendor Credits Issued to You 00:00 Deposits and Withdrawals 00:00 Working with 1099 Contractors 00:00 Purchase of Inventory 00:00 Purchasing Inventory 00:00 Accounting for Inventory Sold 00:00 Sending Estimates 00:00 Cash Account Fees - Part 1 00:00 Cash Account Feeds 00:00 Editing Feed Transactions 00:00 Recurring Transactions 00:00 Tracking Sales Taxes 00:00 Collecting Sales Taxes on Invoices 00:00 Paypal Transactions 00:00 Basic Reports 00:00 Basic Reports 00:00 Conclusion 00:00

Overview Finance and Accounting Level 1 & 2 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 Finance and Accounting Level 1 & 2 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: 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 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. Module : 01 Accounting for Beginners Promo 00:01:00 Introduction 00:03:00 First Transactions 00:05:00 T Accounts introduction 00:03:00 T-Accounts conclusion 00:03:00 Trial Balance 00:02:00 Income Statement 00:03:00 Balance Sheet 00:03:00 Module : 02 Balance Sheet Variations 00:03:00 Accounts in practise 00:05:00 Balance Sheets what are they 00:05:00 Balance Sheet Level 2 00:03:00 Income Statement Introduction 00:06:00 Are they Expenses, or Assets 00:03:00 Accounting Jargon 00:02:00 Module : 03 Accruals Accounting is Fundemental 00:03:00 Trial Balance 3 days ago More 00:04:00 Fixed Assets and how it is shown in the Income Statement 00:03:00 Stock movements and how this affects the financials 00:03:00 Accounts Receivable 00:03:00 How to calculate the Return on Capital Employed 00:05:00 Transfer Pricing - International Rules 00:02:00 Handout - Finance and Accounting Level 1 & 2 Handout - Finance and Accounting Level 1 & 2 00:00:00 Assessment Assignment - Finance and Accounting Level 1 & 2 00:00:00

Description: Business Accounting refers to the systematic recording, analysing, interpreting and presenting financial information. An Introduction to Business Accounting - Complete Video Course course provides you with the basic knowledge of Business Accounting for the betterment of your business. In the course, you will learn the accounting equation and different types of financial statements and the ways of analysing transactions using the double-entry system, and by journalizing transactions. The course will also teach you how to post entries, the trial balance, and find errors using horizontal analysis. The Business Accounting course will also teach you the ways of adjusting process, adjusting entries, preparing a worksheet, and creating financial statements. Areas of concentration also include accounting cycles, temporary vs permanent accounting basics, the accounting cycle illustrated steps, the fiscal year, and working capital and current ratio. To sum up, the course will help you to know the basic usage of Business Accounting. Assessment: At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? An Introduction to Business Accounting - Complete Video Course is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our An Introduction to Business Accounting - Complete Video Course is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Professional Bookkeeper Introduction Professional Bookkeeper FREE 00:09:00 Introduction to Accounting and Business Defining a Business 00:07:00 Ethics in Accounting 00:05:00 Generally Accepted Accounting Principles (GAAP) 00:10:00 The Accounting Equation The Accounting Equation 00:07:00 Transactions 00:11:00 Financial Statements 00:13:00 Analyzing Transactions The Accounting Equation and Transactions 00:16:00 Double-Entry System 00:11:00 Transactions - Journalizing 00:17:00 Journal Entries 00:38:00 Entering Information - Posting Entries Posting Entries 00:10:00 The Trial Balance 00:10:00 Finding Errors Using Horizontal Analysis 00:09:00 Horizontal Trend : Balance Sheet 00:21:00 Horizontal Trend: Income Statement 00:36:00 Adjusting Process The Purpose of the Adjusting Process 00:15:00 Adjusting Entries Adjusting Entries - Prepaid Expenses 00:13:00 Adjusting Entries - Accrued Revenues 00:10:00 Adjusting Entries - Depreciation Expense 00:09:00 Adjustment Summary Adjustment Summary - Review 00:13:00 Vertical Analysis 00:33:00 Preparing a Worksheet Preparing a Worksheet 00:06:00 Financial Statements The Income Statement 00:11:00 Financial Statements - Definitions 00:12:00 Completing the Accounting Cycle Temporary vs. Permanent Accounts 00:19:00 The Accounting Cycle Illustrated Accounting Cycle Illustrated - Steps 1-5 00:11:00 Accounting Cycle Illustrated - Steps 6-10 00:12:00 Fiscal Year Fiscal Year 00:09:00 Spreadsheet Exercise Spreadsheet Exercise - Steps 1-4 00:11:00 Spreadsheet Exercise - Steps 5-7 00:37:00 Mock Exam Mock Exam- An Introduction to Business Accounting - Complete Video Course 00:20:00 Final Exam Final Exam- An Introduction to Business Accounting - Complete Video Course 00:20:00 Order Your Certificates and Transcripts Order Your Certificates and Transcripts 00:00:00

Do you want to pursue a career in the sports world? Sports agent professionals are the best alternative for you. The sports agent course- sports agent & athlete management course of Lead Academy will help you to explore the skills that are needed to become one of the successful sports agents. This Course at a Glance Get a brief introduction to the world of sports agents. Learn the duties and functions of a player agent. Understand how professional athletes make networks. Learn to Negotiate With Teams And Sponsors and more. Achieved reward CPD UK accredited certificate. Learn through engaging video-based training sessions. Continuous tutor support is available 24/7. Sports Agent Course - Sports Agent & Athlete Management Course Overview This Sports Agent Course - Sports Agent & Athlete Management Course is developed to provide all the necessary training to become a sports agent. It will teach you from scratch in-depth to become a player agent. You will learn duties and functions, negotiation skills, the connection between sports and laws and more.  Overall, this course will deliver essential facts and significant insights regarding sports agents and athlete management. Additionally, this sports agent course is accredited by CPD UK, valued by employers, professional organisations, and academic institutions. Your training provider can advise you on any further recognition, for example, progression routes into further and higher education. For details, please visit the Learner FAQs on our website. Who should take this course? The Sports Agent Course - Sports Agent & Athlete Management Course is suitable for the following:  Any individual who wishes to pursue a career as a sports agent. The individual wants to learn more about sports agent & athlete management even after basic knowledge of it. Any sports management students can enroll. People who want to increase personal knowledge. Entry Requirements The Sports Agent course and Athlete Management Course Online require no academic qualification. It is accessible to students from diverse backgrounds, and students enthusiastic about learning new things will primarily benefit. However, You need a laptop, desktop, tablet, or smartphone and a reliable internet connection to enter this course. Assessment On the assessment round, you will participate in the MSQ test to examine your learning from this course. After completing the gardening course's all modules, learners must answer MCQs to complete the assessment procedure.  The MCQ test measures how much a learner can grasp from each section. In the assessment test, you must get 60% as a pass mark. Course Curriculum Module 1: Introduction ● What is a Sports Agent? ● What does a sports agent's job involve? ● Salary and pay scale ● Skills necessary for a sports agent Module 2: Duties and Functions ● Duties and Responsibilities of a Sports Agent ● Educational Background of Sports Agents Module 3: Networking ● Getting your name out there ● Handling rejection ● Making a good impression ● Building a relationship ● Make things easy for the client Module 4: Analysing Worth ● Assessing your client's worth ● Market analysis ● Accepting and accounting for client weaknesses ● Assessing for the right target Module 5: Public Relations ● What does Public Relations mean in sports? ● Why Public relations is important for a sports agent? ● Sports PR Best Practices Module 6 : Finance ● Financial Strategy, Planning and Budgeting in the World of Sports ● Spending in Sports ● Short-term and Long-term Budgeting ● Sport Finance Reporting and Analysis ● Other Factors that Play a Role in Sport Finance Module 7: Negotiating with Teams And Sponsors ● How to negotiate? ● Knowing the tricks ● Pressure tactics ● Manipulative tactics ● Power tactics ● Bad negotiation techniques ● Analysing your opponent Module 8: Sport and the Law ● How does the Law relate to Sport? ● The Structure of Sport ● European Model of Sport ● The North American model of Sport ● Government Involvement in Sport ● Rights of Participants ● Commercial decisions ● The Safety of Spectators Conclusion Recognised Accreditation CPD Certification Service CPD stands for Continuing Professional Development. This term refers to learning activities that professionals undertake to improve their skills and capabilities. Employers and professional organizations globally recognize CPD UK. Thus, a certificate from CPD Certification Service creates value for your professional goal and achievement. Certificate of Achievement Certificate of Achievement from Lead Academy After successfully passing the MCQ exam, you can order your certificate of achievement as proof of your new skill. The certificate of achievement is an official credential that confirms that you successfully finished a course with Lead Academy. The certificate can be obtained in PDF version for £12, and there is an additional fee to receive a printed copy certificate which is £35. FAQs How will I be a sports agent in the UK? To become a sports agent in the UK, you must have a solid idea about how the sports industry works. You can only start something by knowing it well. Thus, get into this Sports Agent course, and become one of them. How much does a player agent earn in the UK? A Sports Agent earns approximately £42,518 per year in London. What will be my responsibility if I become a sports agent? A player agent has many responsibilities like negotiation, networking and more. You must play this role with utmost sincerity. You must acquire skills to do that, and you will learn those comprehensively in the course. How will I purchase this course? First, select your desired course plan among the multiple existing course plans on the right side of your screen, then select the payment type, and once you made the payment, you can access the course any time you want. I made my payment. How will I get access to the Sports Agent course? A confirmation email will be sent to your registered email after payment. Hereafter anytime, you can start your learning journey with Lead Academy. I am from outside the UK. Will I get access to the Course? Yes, you can. Since it is an e-learning course, anyone from anywhere can enrol on our courses. What is an Accredited course? The professional body approves the procedures if any e-learning platform claims its courses are accredited. What is the benefit of doing an accredited course? You will only realise the benefit of having a CPD-accredited certificate once you face the corporate world. As employees, job places and more value the CPD-accredited certificate, you must own this certificate by doing the course with us. What do you mean by a CPD course? CPD refers to Continuing Professional Development, and the CPD-accredited course is developed for individuals who want to improve and update their skills within their professional field continuously. This certificate claims that the certificate holder's knowledge is up-to-date in their work area.

Description The use of accounting is very significant regardless of the size of the company since it helps to provide a methodological procedure for detailing the activities of the business. The Finance and Accounting Level 1 and 2 course teaches you the ins and outs of finance and accounting in a fun and comprehensive guide to the mind. Through the course, you'll learn the fundamental measures of finance and accounting to manage the accounts of your business. You'll also understand the necessary accounting terms and concepts and learn to prepare reports on financial information about the performance, financial position, and cash flows of a business. Here's what the course includes: Planning and preparation for accurate Financial Statements for your business The importance of Balance Sheet and the contrast within presenting a Balance Sheet style in the US and UK Maintain adequate and systematic records of business transactions Alternatives for raising extra capital and company budgeting Once you've completed this course, you can successfully contribute to the overall stability and progress of the business. Assessment: This course does not involve any MCQ test. Students need to answer assignment questions to complete the course, the answers will be in the form of written work in pdf or word. Students can write the answers in their own time. Once the answers are submitted, the instructor will check and assess the work. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? Finance and Accounting Level 1 and 2 is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our Finance and Accounting Level 1 and 2 is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Module : 01 Chris Moore - Accounting for Beginners Promo FREE 00:01:00 Chris Moore - 1. Introduction 00:03:00 Chris Moore - 2. First Transactions 00:05:00 Chris Moore - 3. T Accounts introduction 00:03:00 Chris Moore - 4. T-Accounts conclusion 00:03:00 Chris Moore - 5. Trial Balance 00:02:00 Chris Moore - 6. Income Statement 00:03:00 Chris Moore - 7. Balance Sheet 00:03:00 Module : 02 Chris Moore - 8. Balance Sheet Variations 00:03:00 Chris Moore - 9. Accounts in practise 00:05:00 Chris Moore - 10. Balance Sheets what are they 00:05:00 Chris Moore - 11. Balance Sheet Level 2 00:03:00 Chris Moore - 12. Income Statement Introduction 00:06:00 Chris Moore - 13. Are they Expenses, or Assets 00:03:00 Chris Moore - 14. Accounting Jargon 00:02:00 Module : 03 Chris Moore - 15. Accruals Accounting is Fundemental 00:03:00 Chris Moore - 16. Trial Balance 3 days ago More 00:04:00 Chris Moore - 17. Fixed Assets and how it is shown in the Income Statement 00:03:00 Chris Moore - 18. Stock movements and how this affects the financials 00:03:00 Chris Moore - 19. Accounts Receivable 00:03:00 Chris Moore - 20. How to calculate the Return on Capital Employed 00:05:00 Chris Moore - 21. Transfer Pricing - International Rules 00:02:00 Handout - Finance and Accounting Handout - Finance and Accounting 00:00:00 Assessment Assignment - Finance and Accounting Level 1 and 2 00:00:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Course overview Take a practical approach to enhance your Excel modelling skills with the Advanced Excel Models using Formulas, VBA & Power Query course. In this course, you will learn how to build robust Excel models using Formulas, VBA and Power Query. This Advanced Excel Models using Formulas, VBA & Power Query course offers a wide range of training modules to enhance your abilities to create better models. You will discover the advanced Excel formulas to prepare reports, forecast and perform mathematical calculations. We will introduce you to the three excel models and show the functions used to prepare these pro models. In addition, you will learn the Excel formulas for prepaid expenses and explore the steps to create dynamic dashboards based on Power Query and Pivot Table without any formula. Learning outcomes Familiarize yourself with the advanced Excel formulas Be able to manage prepaid expenses Deepen your understanding of the prepaid expense models Learn about the pro Excel models and formulas Strengthen your knowledge of Power Query and PowerPivot Learn how to create Power query and pivot table based dashboard without any formula Who Is This Course For? This Advanced Excel Models using Formulas, VBA & Power Query course is recommended to anyone interested in learning how to prepare robust Excel models using advanced formulas, Power Query and VBA. In addition, the skills gained from this training will provide excellent opportunities for career advancement. Entry Requirement This course is available to all learners of all academic backgrounds. Learners should be aged 16 or over. Good understanding of English language, numeracy and ICT skills are required to take this course. Certification After you have successfully completed the course, you will obtain an Accredited Certificate of Achievement. And, you will also receive a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hardcopy for £39 or in PDF format at the cost of £24. PDF certificate's turnaround time is 24 hours, and for the hardcopy certificate, it is 3-9 working days. Why Choose Us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos and materials from the industry-leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; United Kingdom & internationally recognized accredited qualification; Access to course content on mobile, tablet and desktop from anywhere, anytime; Substantial career advancement opportunities; 24/7 student support via email. Career Path The Advanced Excel Models using Formulas, VBA & Power Query Course provides essential skills that will make you more effective in your role. It would be beneficial for any related profession in the industry, such as: Data Analyst System Support and Reporting Analyst Introduction Course Outline and Introduction 00:04:00 Minimum Requirements for the Course 00:01:00 Prepayments Introduction 00:01:00 Prepaid Expenses Models: Resources Download Month End Date Prepaid Expenses Amortization Calculation 00:00:00 Exact Prepaid Expenses Payment Date Calculation 00:00:00 Accounting for Prepaid Expenses Prepaid Expenses Accounting Definition: Prepayments 00:03:00 Prepaid Expense Example: How Accounting works for Prepayments 00:03:00 Advantages and Disadvantages of Prepaid Expenses 00:03:00 Excel Formulas Detailed: Introduction to three Excel Models Introduction to PRO Excel Models and Formulas 00:06:00 Date Function 00:05:00 EOMONTH Function 00:04:00 DATEVALUE function 00:03:00 IF Function 00:08:00 IFS Function (Office 365 Only) 00:07:00 VLOOKUP Function 00:07:00 MATCH Function 00:05:00 INDIRECT Function 00:02:00 NAMED Ranges: Name Manager 00:03:00 Advanced Version of VLOOKUP Function 00:07:00 Formula Based Prepaid Expenses Model Introduction to Model and Control Panel Tab (Important Sheet Tab) 00:08:00 Formula Based Prepaid Expenses Model - Deep Dive (Part 1) 00:05:00 Formula Based Prepaid Expenses Model - Deep Dive (Part 2) 00:06:00 Formula Based Prepaid Expenses Model - Deep Dive (Part 3) 00:06:00 IFS Function - Month End date Prepayment calculation 00:04:00 Prepaid Expenses - Closing Balance Summary Tab (Formula Based Summary) 00:09:00 Protecting Formulas Cells and Fields in the Model 00:04:00 Calculate Prepaid Expenses Amortisation from Exact Start Date Exact Date Prepaid Amortisation calculation Intro 00:03:00 Formulas update and Model Changes for Exact Prepaid Exps Calculation 00:03:00 Formulas Update for Exact Date Prepaid Exps Amortisation (Part 1) 00:04:00 Formulas Update for Exact Date Prepaid Exps Amortisation (Part 2) 00:03:00 Formulas Update for Exact Date Prepaid Exps Amortisation (Part 3) 00:02:00 Formulas Update for Exact Date Prepaid Exps Amortisation (Part 4) 00:07:00 IFS Function - Exact Date Prepayments Amortisation 00:04:00 Data Validation Controls (Enhancing Data Input Controls with Protection) 00:10:00 Bonus: Prepayment Model with Opening Balance Calculation (Part 1) 00:08:00 Bonus: Prepayment Model with Opening Balance Calculation (Part 2) 00:09:00 Additional Material: Resources 00:00:00 Prepaid Expenses Summary with Power Query and Pivot Table Power Query and Pivot Table Prepayment Summary Table Intro 00:06:00 What is Power Query and Some Awesome Resources for Power Query learning 00:07:00 Power Query and Pivot Table Summary - Deep Dive (Part 1) 00:05:00 Power Query and Pivot Table Summary - Deep Dive (Part 2) 00:04:00 Power Query and Pivot Table Summary - Deep Dive (Part 3) 00:05:00 Power Query and Pivot Table Summary - Deep Dive (Part 4) 00:09:00 Using Array Formulas to Add Formula Protection 00:04:00 Bonus: Allocate Prepaid Expenditure Cost Centre Wise - 1 00:02:00 Bonus: Allocate Prepaid Expenditure Cost Centre Wise - 2 00:08:00 Bonus: Prepayment Model with Opening Balance Calculation (PQ and PT Version) 00:13:00 Advanced VBA Prepaid Expenses Amortisation Model Changing Macros Security in Excel 00:05:00 Complete Walkthrough - Advanced VBA Prepaid Expenses Amortisation Model 00:06:00 Bonus : New Version - Excel VBA Model for Prepayment Expenditure 00:08:00 BONUS: Dynamic Dashboard for Divisional Profit and Loss statements: Easy Way Dynamic Dashboard Overview 00:07:00 Importing Profit and Loss Statements Source Files and creating YTD P&L Sheets 00:08:00 Creating Dynamic Data Validation 00:02:00 Creating Named Ranges for Dynamic Table Arrays 00:03:00 Dynamic Date Column Headings for each Divisional PL Table 00:02:00 Dynamic Month and YTD Dashboard tables headings (PRO TIP) 00:03:00 Dynamic VLOOKUP Formula - Preparing First section of the Dashboard 00:04:00 Creating Rolling Dashboard with Dynamic VLOOKUP Function 00:08:00 IMPORTANT : Error Checking for your reports/Dashboard (PRO TIP) 00:03:00 Data Prep for Visualization: AREA Charts (Awesome trick using #NA Function) 00:05:00 Visualization: AREA Charts for Month - Revenue, Gross Profit and Net Profit 00:05:00 Visualization DONUT Charts Revenue, Gross Profit and Net Profit (Part 1) 00:03:00 Visualization DONUT Charts Revenue, Gross Profit and Net Profit (Part 2) 00:06:00 Power Query & Pivot Tables based Dashboard without any Formulas, Fully Dynamic Introduction - Formula-less Dashboard - Fully Dynamic and easily refreshed 00:05:00 Understanding the data files before building dashboard 00:02:00 Consolidating Reports with Power Query (Get & Transform) , How to install PQ 00:08:00 Dynamic File Path Trick in Power Query with Parameters (Amazing trick) 00:06:00 Conditional Cumulative totals with SUMIFS Function 00:04:00 Bonus: Conditional Cumulative totals with Power Query Custom Formula (M Code) 00:06:00 Dashboard Creation - Pivot Table showing Month and YTD KPIs division wise 00:06:00 Dashboard Creation Donuts Charts linked with Pivot Table (Replicate Charts fast) 00:08:00 Dashboard Creation - Line Charts 00:08:00 Update Dashboard with Additional Divisional Data with Few Click (Magical) 00:03:00 Thankyou Thank you 00:02:00 Ultimate Prepaid Expenditure Model (Super Bonus) 00:02:00 Resources Resources - Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query 00:00:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Learn how to use Xero Accounting and Bookkeeping software with our online course. You will discover how to set up and manage various functions, such as invoicing, bank reconciliation, payroll management, and more. This course is ideal for anyone who wants to pursue a career in accounting, bookkeeping, finance, or related fields.