2224 Courses delivered Online

Picture this: You're sitting in a high-rise office, surrounded by tall skyscrapers and busy city streets. You're dressed in a sharp suit, with a cup of coffee in hand and a satisfied smile on your face. You've just completed a successful meeting with a client and you're feeling confident and proud of the work you do. This is the life you could have as a qualified accountant, pension advisor, and tax accountant. Our bundle course, Accounting, Pension with Tax Accounting, is your ticket to this exciting career path. Including 3 QLS-endorsed courses and 5 CPD-QS accredited courses, you'll have everything you need to become a master in your field. Not only will you receive in-depth knowledge and skills, but you'll also be able to showcase your achievements with 3 hardcopy certificates upon completion. So why should you consider learning about accounting, pensions, and tax accounting in the UK? Statistics show that the demand for accountants in the UK is growing, with the average salary for an accountant in the UK being £39,000 per year. So why wait? Enrol in our Accounting, Pension with Tax Accounting bundle course today and start your journey towards a successful and fulfilling career. Don't miss out on this opportunity to take control of your finances and your future. Invest in yourself and reap the rewards for years to come! QLS Endorsed Courses: Course 01: Certificate in Pension at QLS Level 3 Course 02: Certificate in Accounting at QLS Level 4 Course 03: Diploma in Advanced Tax Accounting at QLS Level 5 CPD QS Accredited Courses: Course 04: Accounting and Finance Course 05: Accounting Essentials and UK Taxation Course 06: Property Law and Taxation for Accountants and Lawyers Course 07: Management Accounting Tools Course 08: Applied Accounting Take your career to the next level with our bundle that includes not only technical courses but also five guided courses focused on personal development and career growth. Course 09: Leadership and Management Course Course 10: Career Development and Passion Course 11: Professional CV Writing Course 12: Boost Your Confidence and Self-Esteem Course 13: Public Speaking: Confident Delivery Skills Learning Outcomes: Understanding of basic accounting principles and practices. Knowledge of pension planning and management. Expertise in tax accounting and compliance. Ability to use accounting software and tools. Understanding of property law and taxation. Knowledge of management accounting techniques. Introduction to Accounting: This course covers the basics of accounting, including bookkeeping, financial statements, and accounting principles. The modules will provide learners with a solid foundation in accounting and will cover topics such as double-entry bookkeeping, the accounting equation, and the preparation of financial statements. Pension: This course focuses on pension planning and management. The modules will cover the different types of pensions, pension schemes, and the role of a pension advisor. Learners will gain an understanding of the various options available for pension planning and how to make informed decisions about their own pensions. Advanced Tax Accounting: This course is designed for learners who have a basic understanding of tax accounting and want to further their knowledge. The modules will cover advanced topics such as tax compliance, tax planning, and tax law. Certification Learners will qualify for the highly sought-after QLS Endorsed Certificate after successfully passing the assessment at the conclusion of each endorsed course. The Quality Licence Scheme is a credible and renowned endorsement that marks high qualityand excellence in the UK. It is well accepted and sought after by industry experts and recruiters. Learners who purchase this bundle will receive Three Hardcopy QLS Certificates at their door! CPD 25 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Individuals who want to start a career in accounting, pensions, or tax accounting. Professionals who want to enhance their existing knowledge and skills in the field. Entrepreneurs who want to understand their financial obligations and responsibilities better. Students who are interested in pursuing a career in accounting, pensions, or tax accounting. Career path Accountant: £30,000 - £60,000 per year Pension Advisor: £35,000 - £50,000 per year Tax Accountant: £35,000 - £65,000 per year Financial Analyst: £40,000 - £70,000 per year Management Accountant: £35,000 - £60,000 per year Certificates Certificate of completion Hard copy certificate - Included

14 in 1 "Charity Accounting" Bundle only at £79 Get Hard Copy + PDF Certificates + Transcript + Student ID Card + e-Learning App as a Gift - Enrol Now Tired of browsing and searching for a Charity Accounting course you are looking for? Can't find the complete package that fulfils all your needs? Then don't worry as you have just found the solution. Take a minute and look through this extensive bundle that has everything you need to succeed. After surveying thousands of learners just like you and considering their valuable feedback, this all-in-one Charity Accounting bundle has been designed by industry experts. We prioritised what learners were looking for in a complete package and developed this in-demand Charity Accounting course that will enhance your skills and prepare you for the competitive job market. Also, our experts are available for answering your queries on Charity Accounting and help you along your learning journey. Advanced audio-visual learning modules of these Charity Accounting courses are broken down into little chunks so that you can learn at your own pace without being overwhelmed by too much material at once. Furthermore, to help you showcase your expertise in Charity Accounting, we have prepared a special gift of 1 hardcopy certificate and 1 PDF certificate for the title course completely free of cost. These certificates will enhance your credibility and encourage possible employers to pick you over the rest. This Charity Accounting Bundle Consists of the following Premium courses: Course 01: Charity Accounting Course 02: Fundraising Course 03: Double Your Donations & Succeed at Fundraising Course 04: Financial Analysis Course 05: Budgeting and Forecasting Course 06: Introduction to Accounting Course 07: Key Account Management Course Course 08: Professional Bookkeeping Course Course 09: Microsoft Excel Training: Depreciation Accounting Course 10: Certificate in Compliance Course 11: Certificate in Anti Money Laundering (AML) Course 12: Introduction to Data Analysis Course 13: GDPR Data Protection Level 5 Course 14: Human Rights Enrol now in Charity Accounting to advance your career, and use the premium study materials from Apex Learning. How will I get my Certificate? After successfully completing the course, you will be able to order your CPD Accredited Certificates (PDF + Hard Copy) as proof of your achievement. PDF Certificate: Free (For The Title Course ) Hard Copy Certificate: Free (For The Title Course ) The bundle incorporates basic to advanced level skills to shed some light on your way and boost your career. Hence, you can strengthen your Charity Accounting expertise and essential knowledge, which will assist you in reaching your goal. Curriculum of Bundle Course 01: Charity Accounting Module 01: The Concept of Charity Accounting Module 02: Accounting Standards, Policies, Concepts and Principles Module 03: Fund Accounting Module 04: Charity Reporting and Accounts Module 05: Trustees' Annual Report Module 06: Balance Sheet Module 07: Statement of Financial Activities Module 08: Understanding the Income Streams and Expenditure of Charity Module 09: Statement of Cash Flows Module 10: Taxation for Charities and External Scrutiny Module 11: Things to Look Out for in Post Covid Situation Course 02: Fundraising 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 Course 03: Double Your Donations & Succeed at Fundraising Module 01: Week 01 Why Should Anyone Donate To Your Organization? Module 02: Week 02 How To Use Emotion To Be More Effective. Module 03: Week 03 How to Create Headlines and Subject Lines That Bring In Money Module 04: Week 04 a Welcome Mat Could Save Your Back Module 05: Week 05 How to Tell Stories That People Remember Module 06: Gems to Remember Module 07: How to Attract Major Gifts - Part 1 Of 2 Module 08: How to Attract Major Gifts - Part 2 Of 2 Course 04: Financial Analysis Section-1. Introduction Section-2. Profitability Section-3. Return Ratio Section-4. Liqudity Ratio Section-5.Operational Analysis Section-6. Detecting Manipulation Course 05: Budgeting and Forecasting Unit-1. Introduction Unit-2. Detail Budget Requirement Unit-3. Process of Making Budget Course 06: Introduction to Accounting Section 01: Accounting Fundamental Section 02: Accounting Policies Course 07: Key Account Management Course Module 1: Introduction to Key Account Management Module 2: Purpose of Key Account Management Module 3: Understanding Key Accounts Module 4: Elements of Key Account Management Module 5: What Makes a Good Key Account Manager Module 6: Building and Delivering Value to Key Accounts Module 7: Key Account Planning Module 8: Business Customer Marketing and Development Module 9: Developing Key Relationships Module 10: The Importance of Record Keeping for Key Account Management Module 11: Internal KAM Aspects Module 12: The Value Proposition Course 08: Professional Bookkeeping Course Section 01: Introduction Section 02: Basic Accounting Terms Section 03: Common Transactions Section 04: Practice Course 09: Microsoft Excel Training: Depreciation Accounting Introduction Depreciation Amortization and Related Terms Various Methods of Depreciation and Depreciation Accounting Depreciation and Taxation Master Depreciation Model Conclusion Course 10: Certificate in Compliance Module 1: Introduction to Compliance Module 2: Compliance Management System Module 3: Basic Elements of Effective Compliance Module 4: Compliance Audit Module 5: Compliance and Ethics Module 6: Introduction to Risk and Basic Risk Types Module 7: Further Risk Types Module 8: Introduction to Risk Management Module 9: Risk Management Process Module 10: Risk Assessment and Risk Treatment Module 11: Types of Risk Management Course 11: Certificate in Anti Money Laundering (AML) Module 01: Introduction to Money Laundering Module 02: Proceeds of Crime Act 2002 Module 03: Development of Anti-Money Laundering Regulation Module 04: Responsibility of the Money Laundering Reporting Office Module 05: Risk-based Approach Module 06: Customer Due Diligence Module 07: Record Keeping Module 08: Suspicious Conduct and Transactions Module 09: Awareness and Training Course 12: Introduction to Data Analysis Module 01: Introduction Module 02: Agenda and Principles of Process Management Module 03: The Voice of the Process Module 04: Working as One Team for Improvement Module 05: Exercise: The Voice of the Customer Module 06: Tools for Data Analysis Module 07: The Pareto Chart Module 08: The Histogram Module 09: The Run Chart Module 10: Exercise: Presenting Performance Data Module 11: Understanding Variation Module 12: The Control Chart Module 13: Control Chart Example Module 14: Control Chart Special Cases Module 15: Interpreting the Control Chart Module 16: Control Chart Exercise Module 17: Strategies to Deal with Variation Module 18: Using Data to Drive Improvement Module 19: A Structure for Performance Measurement Module 20: Data Analysis Exercise Module 21: Course Project Module 22: Test your Understanding Course 13: GDPR Data Protection Level 5 Module 01: GDPR Basics Module 02: GDPR Explained Module 03: Lawful Basis for Preparation Module 04: Rights and Breaches Module 05: Responsibilities and Obligations Course 14: Human Rights Module 1: Basic Concept of Freedom and Human Rights Module 2: Classification of Human Rights Module 3: Women's and Children's Right Module 4: Various Aspects of Freedom Module 5: Various International Human Rights Organisations CPD 145 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone from any background can enrol in this Charity Accounting bundle. Requirements Our Charity Accounting course is fully compatible with PCs, Macs, laptops, tablets and Smartphone devices. Career path Having this Charity Accounting expertise will increase the value of your CV and open you up to multiple job sectors. Certificates Certificate of completion Digital certificate - Included Certificate of completion Hard copy certificate - Included P.S. The delivery charge inside the UK is £3.99, and the international students have to pay £9.99.

Overview This comprehensive course on Business Strategy Consulting will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Business Strategy Consulting comes with accredited certification, 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? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this Business Strategy Consulting. It is available to all students, of all academic backgrounds. Requirements Our Business Strategy Consulting 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 Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management, Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 17 sections • 88 lectures • 07:09:00 total length •Welcome to this Mini MBA Business Strategy Consulting Course: 00:03:00 •Mini MBA Business Strategy - Executive Summary - What you will learn: 00:10:00 •What is Business Strategy?: 00:05:00 •Business Vision and the Mission Statement: 00:04:00 •The Strategy Hierarchy within a Firm: 00:06:00 •Introduction to Business Strategy Design: 00:02:00 •Business Model Design with the Business Model Canvas: 00:13:00 •Business Model Canvas Template: 00:01:00 •Lafley & Martin's Five Step Strategy Model: 00:05:00 •Hambrick & Frederickson's Strategy Diamond: 00:06:00 •Understanding Life Cycles: 00:02:00 •The Industry Life Cycle: 00:07:00 •The Business Life Cycle: 00:06:00 •The Product Life Cycle: 00:05:00 •The Corporate Funding Life Cycle: 00:04:00 •External Analysis Using Broad Factors: 00:02:00 •PEST Analysis: 00:08:00 •PESTEL Analysis: 00:05:00 •PESTEL Analysis Template: 00:01:00 •CASE STUDY EXERCISE: PESTEL Analysis of Starbucks: 00:02:00 •CASE STUDY SOLUTION: PESTEL Analysis of Starbucks: 00:07:00 •CASE STUDY EXERCISE: PESTEL Analysis of the Global Aviation Industry: 00:07:00 •CASE STUDY SOLUTION: PESTEL Analysis of the Global Aviation Industry: 00:02:00 •Strategic Options from Internal and External Analysis: 00:16:00 •SWOT Analysis: 00:05:00 •Conducting A SWOT Analysis: 00:04:00 •SWOT Analysis Template: 00:02:00 •TOWS Matrix Analysis: 00:05:00 •TOWS Analysis Template: 00:14:00 •SOAR: 00:04:00 •SOAR Analysis Template: 00:01:00 •CASE STUDY EXERCISE: SWOT Analysis - Amazon: 00:02:00 •CASE STUDY SOLUTION: SWOT ANALYSIS - Amazon: 00:09:00 •Michael Porter and Business Strategy Analysis: 00:02:00 •Industry Analysis and Introducing Michael Porter: 00:10:00 •Competitive Forces Model - Porter's Five Forces: 00:12:00 •Full List of Porter's Five Forces Factors: 00:02:00 •Michael Porter's Five Forces Template: 00:01:00 •CASE STUDY EXERCISE PORTERS FIVE FORCES Global Aviation Industry: 00:02:00 •CASE STUDY SOLUTION: Porter's Five Forces - Global Airline Industry: 00:15:00 •Generic Strategies and Industry Forces: 00:10:00 •Michael Porter's Value Chain Analysis: 00:07:00 •Value Chain Analysis Template: 00:02:00 •Boston Consulting Group (BCG) Matrix: 00:07:00 •BCG Matrix and the Life Cycle: 00:03:00 •BCG Matrix Advantages and Disadvantages: 00:03:00 •Adapting the BCG Matrix: 00:05:00 •Boston Consulting Group (BCG) Matrix Template: 00:03:00 •CASE STUDY EXERCISE: BCG Matrix - Facebook: 00:02:00 •CASE STUDY SOLUTION: BCG Matrix - Facebook: 00:04:00 •CASE STUDY EXERCISE: BCG Matrix - Apple: 00:02:00 •CASE STUDY SOLUTION: BCG Matrix - Apple: 00:04:00 •CASE STUDY EXERCISE: BCG Matrix - Unilever: 00:02:00 •CASE STUDY SOLUTION: BCG Matrix - Unilever: 00:05:00 •Competitive Advantage - Deriving Strategy from Inside the Firm: 00:03:00 •Core Competency: 00:05:00 •VRIO - Resources to Competitive Advantage: 00:06:00 •CASE STUDY EXERCISE: Core Competency - Apple: 00:02:00 •CASE STUDY SOLUTION: Core Competency - Apple: 00:05:00 •Defining the Unique Selling Proposition: 00:05:00 •ADL Matrix - Understanding Your Competitive Position: 00:07:00 •ADL Matrix Template: 00:02:00 •Ansoff Product Market Matrix - How to Grow Your Business: 00:05:00 •Organic vs Inorganic Growth: 00:02:00 •Internal and External Growth Strategies Expanded: 00:11:00 •CASE STUDY EXERCISE: Amazon's Growth Strategy: 00:02:00 •CASE STUDY SOLUTION - Amazon's Growth Strategy: 00:06:00 •Blue Ocean Strategy: 00:05:00 •Blue Ocean Case Study - Apple: 00:05:00 •Comparing Red Ocean and Blue Ocean Strategies: 00:04:00 •How to Survive in an Over Fished Ocean: 00:05:00 •How to Create a Comparative Competitive Analysis on a Page: 00:04:00 •Making the Connection between Strategy and Finance: 00:04:00 •What is an Integrated Financial Model?: 00:06:00 •Key Drivers of an Integrated Financial Model: 00:08:00 •Model Structure: 00:03:00 •Detailed Model Schedules: 00:07:00 •Chart of Accounts: 00:02:00 •Financial Statement Inputs and Outputs: 00:03:00 •10 Steps to Building an Integrated Financial Model: 00:05:00 •Summary of the Strategic Analysis Process: 00:03:00 •Understanding the Strategic Planning Process: 00:06:00 •Four Step Strategic Management Process: 00:03:00 •Strategy Formulation in Six Steps: 00:07:00 •Mintzberg's Five Configurations: 00:05:00 •Course Summary and Wrap Up: 00:05:00 •Additional Materials: 00:00:00 •Assignment - Business Strategy Consulting: 00:00:00

Level 4 QLS Endorsed Course with FREE Certificate | CPD & CiQ Accredited | 120CPD Points | Lifetime Access

Level 5 QLS Endorsed Diploma | 150 CPD Points | +Gifts: QLS Certificate + PDF Certificate | 24/7 Learner Support

This course gives an in-depth overview of the two major documents that shape today's international tax environment: the U.S. Foreign Account and Tax Compliance Act (FATCA) & OECD's Common Reporting Standards (CRS). The course will make you able to: Identify FATCA and CRS application principles List FATCA and CRS key requirements and approaches Match the due diligence and reporting requirements under FATCA and CRS Identify tax residency status Gain insight on the curing of indicia

Level 4 QLS Endorsed Diploma | 120 CPD Points | +Gifts: QLS Certificate + PDF Certificate | 24/7 Learner Support

Lean Accounting and Throughput Accounting aim to align costs with the flow of work through a Value Stream or process. Throughput accounting is concerned with supporting management accounting, while Lean accounting focuses on improving the flow of work through a business process. The Theory of Constraints, Throughput Accounting and Lean Accounting Level 2 course is open to everyone, but is ideal for those who already have an understanding of the basic principles of accounting. It covers the basics of the Theory of Constraints in detail, as well as the core principles and tools of throughput and Lean accounting. If you are an accounting student, accountant, financial manager or business manager, then this certification is ideal for you. Gain advanced accounting skills and knowledge by enrolling in this practical training course today. This best selling Theory of Constraints, Throughput Accounting and Lean Accounting Level 2 has been developed by industry professionals and has already been completed by hundreds of satisfied students. This in-depth Theory of Constraints, Throughput Accounting and Lean Accounting Level 2 is suitable for anyone who wants to build their professional skill set and improve their expert knowledge. The Theory of Constraints, Throughput Accounting and Lean Accounting Level 2 is CPD-accredited, so you can be confident you're completing a quality training course will boost your CV and enhance your career potential. The Theory of Constraints, Throughput Accounting and Lean Accounting Level 2 is made up of several information-packed modules which break down each topic into bite-sized chunks to ensure you understand and retain everything you learn. After successfully completing the Theory of Constraints, Throughput Accounting and Lean Accounting Level 2, you will be awarded a certificate of completion as proof of your new skills. If you are looking to pursue a new career and want to build your professional skills to excel in your chosen field, the certificate of completion from the Theory of Constraints, Throughput Accounting and Lean Accounting Level 2 will help you stand out from the crowd. You can also validate your certification on our website. We know that you are busy and that time is precious, so we have designed the Theory of Constraints, Throughput Accounting and Lean Accounting Level 2 to be completed at your own pace, whether that's part-time or full-time. Get full course access upon registration and access the course materials from anywhere in the world, at any time, from any internet-enabled device. Our experienced tutors are here to support you through the entire learning process and answer any queries you may have via email.

Overview This comprehensive course on Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query comes with accredited certification 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? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is this course for? There is no experience or previous qualifications required for enrolment on this Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query. It is available to all students, of all academic backgrounds. Requirements Our Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible on tablets and smartphones so you can access your course on wifi, 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 Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management, Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 12 sections • 76 lectures • 06:08:00 total length •Course Outline and Introduction: 00:04:00 •Minimum Requirements for the Course: 00:01:00 •Prepayments Introduction: 00:01:00 •Month End Date Prepaid Expenses Amortization Calculation: 00:00:00 •Exact Prepaid Expenses Payment Date Calculation: 00:00:00 •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 •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 •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 •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 •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 •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 •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 •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 •Thank you: 00:02:00 •Ultimate Prepaid Expenditure Model (Super Bonus): 00:02:00 •Resources - Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query: 00:00:00

17-in-1 CPD Certified Bundle | Free 17 PDF & Transcript Certificate Included | 24/7 Learner Support