1991 Courses delivered Online

Better Business Cases™ Foundation and Practitioner Using this best-practice approach will allow organizations to reduce unnecessary spending and improve the decision-making process which gives you a greater chance of securing necessary funding and support for initiatives. The goal of the combined foundation and practitioner course is to develop a candidate's ability to deliver a comprehensive business case through encouraging expanded knowledge to guide the practical application of theoretical foundations. Upon the completion of this course, a candidate will be able to start applying the model to a real business case development project. The outline presented in the course overview will be addressed in the first 2 days, with the Foundation exam conducted on the morning of Day 3. Then the topics will be revisited at a deeper level, for 2 more days, with the Practitioner exam conducted on the afternoon of Day 5. What you will Learn At the end of this program, you will be able to: Develop the lifecycle of a business case and establish the relationships between the five cases Apply the steps in the business case development framework, in order to support the production of a business case, using the Five Case Model, for a given scenario. Overview of Better Business Cases Alignment with the strategic planning process Importance of the Business Case using the Five Case Model Overview of the Five Case Model Purpose of the key stages in the development of a spending proposal Purpose of a Business Justification Case Business Case Development Process Purpose of project / programme assurance and assurance reviews Responsibility for producing the Business Case Determining the Strategic Context and Undertaking the Strategic Assessment Scoping the Scheme and Preparing the Strategic Outline Case Planning the Scheme and Preparing the Outline Business Case Procuring the Solution and Preparing the Full Business Case Implementation and monitoring Evaluation and feedback Making the Case for Change Agree on the strategic context Determine spending objectives, existing arrangements, and business needs Determine potential business scope and key service requirements Determine benefits, risks, constraints, and dependencies Exploring the Preferred Way Forward Agree on critical success factors Determine long list options and SWOT analysis Recommend a preferred way forward Determining Potential Value for Money Revisit the short list Prepare the economic appraisal for short-listed options Undertake benefits appraisal Undertake risk appraisal Select preferred option and undertake sensitivity analysis Preparing for the Potential Deal Determine the procurement strategy Determine service streams and required outputs Outline potential risk apportionment Outline potential payment mechanisms Ascertain contractual issues and accountancy treatment Ascertaining Affordability and Funding Requirement Prepare the financial model Prepare the financial appraisals Planning for Successful Delivery Plan programme / project management Plan change and contract management Plan benefits realization Plan risk management Plan programme / project assurance and post-project evaluation Procuring the Value for Money Solution Revisit the case for change Revisit the OBC options Detail procurement process and evaluation of best and final offers (BAFOs) Contracting for the Deal Set out the negotiated deal and contractual arrangements Set out the financial implications of the deal Ensuring Successful Delivery Finalize project management arrangements and plans Finalize change management arrangements and plans Finalize benefits realization arrangements and plans Finalize risk management arrangements and plans Finalize contract management arrangements and plans Finalize post-project evaluation arrangements and plans

Do you want to prepare for your dream job but strive hard to find the right courses? Then, stop worrying, for our strategically modified Accounting Assistant bundle will keep you up to date with the relevant knowledge and most recent matters of this emerging field. So, invest your money and effort in our 30 course mega bundle that will exceed your expectations within your budget. The Accounting Assistant related fields are thriving across the UK, and recruiters are hiring the most knowledgeable and proficient candidates. It's a demanding field with magnitudes of lucrative choices. If you need more guidance to specialise in this area and need help knowing where to start, then StudyHub proposes a preparatory bundle. This comprehensive Accounting Assistant bundle will help you build a solid foundation to become a proficient worker in the sector. This Accounting Assistant Bundle consists of the following 25CPD Accredited Premium courses - Course 1: Accounting and Finance Course 2: Applied Accounting Course 3: Managerial Accounting Masterclass Course 4: Changes in Accounting: Latest Trends Encountered by CFOs in 2022 Course 5: Tax Accounting Course 6: Introduction to VAT Course 7: Time Management Training - Online Course Course 8: Excel Data Analysis Course 9: Excel Vlookup, Xlookup, Match and Index Course 10: Risk Assessment & Management Course 11: Commercial Law Course 12: Key Account Management Course Course 13: Xero Accounting and Bookkeeping Online Course 14: Quickbooks Online Course 15: Sage 50 Accounts Course 16: Cost Control Process and Management Course 17: Learn to Read, Analyse and Understand Annual Reports Course 18: Financial Statements Fraud Detection Training Course 19: Finance Principles Course 20: Financial Management Course 21: Financial Modelling Course - Learn Online Course 22: Improve your Financial Intelligence Course 23: Financial Analysis Course 24: Banking and Finance Accounting Statements Financial Analysis Course 25: Financial Ratio Analysis for Business Decisions 5 Extraordinary Career Oriented courses that will assist you in reimagining your thriving techniques- Course 1: Career Development Plan Fundamentals Course 2: CV Writing and Job Searching Course 3: Interview Skills: Ace the Interview Course 4: Video Job Interview for Job Seekers Course 5: Create a Professional LinkedIn Profile Learning Outcome This tailor-made Accounting Assistant bundle will allow you to- Uncover your skills and aptitudes to break new ground in the related fields Deep dive into the fundamental knowledge Acquire some hard and soft skills in this area Gain some transferable skills to elevate your performance Maintain good report with your clients and staff Gain necessary office skills and be tech savvy utilising relevant software Keep records of your work and make a report Know the regulations around this area Reinforce your career with specific knowledge of this field Know your legal and ethical responsibility as a professional in the related field This Accounting Assistant Bundle resources were created with the help of industry experts, and all subject-related information is kept updated on a regular basis to avoid learners from falling behind on the latest developments. Certification After studying the complete training you will be able to take the assessment. After successfully passing the assessment you will be able to claim all courses pdf certificates and 1 hardcopy certificate for the Title Course completely free. Other Hard Copy certificates need to be ordered at an additional cost of •8. CPD 300 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Ambitious learners who want to strengthen their CV for their desired job should take advantage of the Accounting Assistant bundle! This bundle is also ideal for professionals looking for career advancement. Requirements To participate in this course, all you need is - A smart device A secure internet connection And a keen interest in Accounting Assistant Career path Upon completing this essential Bundle, you will discover a new world of endless possibilities. These courses will help you to get a cut above the rest and allow you to be more efficient in the relevant fields.

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

Advanced Diploma | 20 in 1 CPD Certified Bundle | ++Gifts: Free 20 PDF+ 1 Transcript Certificates | 24/7 Learner Support

Level 5 Diploma (FREE QLS Endorsed Certificate)| 11 CPD Courses+11 PDF Certificate| 145 CPD Points| CPD & CiQ Accredited

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 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

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

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 5 QLS Endorsed Diploma | 150 CPD Points | +Gifts: QLS Certificate + PDF Certificate | 24/7 Learner Support