53680 Courses in Bristol delivered Online

Overview This comprehensive course on Patient Customer Service Training will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Patient Customer Service Training comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? 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 Patient Customer Service Training. It is available to all students, of all academic backgrounds. Requirements Our Patient Customer Service Training is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 2 sections • 12 lectures • 06:15:00 total length •Introduction to Patient Customer Service: 00:25:00 •Effective Patient Customer Service Training: 00:26:00 •Areas of Patient Customer Service: 00:36:00 •Customer Service Operative Skills: 00:36:00 •Organising Schedules: 00:44:00 •Medical Jargon and Terminology: 00:44:00 •Effective Filing Systems in Medical Offices: 00:35:00 •Patient Customer Service Soft Skills: 00:28:00 •What Customer Service Is to Different Medical Professionals: 00:36:00 •Providing Customer Service and Support to Colleagues: 00:27:00 •Handling Difficult Customers: 00:38:00 •Assignment - Patient Customer Service Training: 2 days

Overview This comprehensive course on PAT Trainingwill deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This PAT Training comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast-track your career ladder. How will I get my certificate? 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 PAT Training . It is available to all students, of all academic backgrounds. Requirements Our PAT Trainingis fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more Course Curriculum 15 sections • 16 lectures • 06:35:00 total length •Introduction to PAT: 00:25:00 •Relevant Statutory Provisions for PAT: 00:25:00 •Safety Responsibilities & Maintenance Provisions: 00:20:00 •Risk Assessment: 00:30:00 •Reducing and Controlling Risks: 00:30:00 •Electrical Units and Appliance Classification: 00:20:00 •Equipment Coverage & Maintenance Needs: 00:25:00 •Initial Visual Examination: 00:25:00 •Initial Visual Examination: 00:25:00 •Instruments for Testing and Equipment Inspection: 00:20:00 •Electrical Installation Testing: 00:35:00 •Lead & RCD Testing: 00:20:00 •Safety Precautions in Electrical Testing: 00:30:00 •Reporting and Record-keeping: 00:25:00 •Testing for New or Used Equipment: 00:15:00 •British Standards and Latest Changes: 00:25:00

Overview This comprehensive course on Passive Income - An Ultimate Guide will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Passive Income - An Ultimate Guide comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? 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 Passive Income - An Ultimate Guide. It is available to all students, of all academic backgrounds. Requirements Our Passive Income - An Ultimate Guide is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 10 sections • 39 lectures • 02:30:00 total length •Preview Of Course: 00:04:00 •What Are Recurring Income Streams: 00:05:00 •What is Residual Income: 00:04:00 •Types of Recurring Income: 00:04:00 •Types of Residual Income: 00:05:00 •Relationship Between Recurring, Residual. and Passive Income: 00:04:00 •Building Wealth Strategies: 00:04:00 •How They're Similar and also Different: 00:04:00 •What is Passive Income and Its Relationship to Passive and Residual Income: 00:04:00 •Examples of Passive Income: 00:04:00 •The Truth About Active Income vs Passive Income: 00:03:00 •Active Income Becomes Passive Income: 00:03:00 •Hard contracts: 00:05:00 •Auto-renewal subscriptions: 00:04:00 •Build a Membership Program for Your Business: 00:03:00 •Become an Affiliate for Other Companies Products: 00:03:00 •Combine Online Membership and Physical Product Delivery: 00:04:00 •Consider Investing: 00:04:00 •Write a Book or E-Book: 00:04:00 •Build an Online Course: 00:05:00 •Create an App: 00:04:00 •Launch a Podcast: 00:02:00 •What Is the Recurring Revenue Model?: 00:04:00 •What Should You Sell to Make the Recurring Revenue Model Work?: 00:05:00 •The Importance of Recurring Revenue in a Thriving Business: 00:03:00 •Reasons Fortune 500 Companies Are Moving to Recurring Revenue Models: 00:03:00 •How Recurring Revenue Increases Business Value: 00:06:00 •What Is Residual Income And Why Do You Want It?: 00:03:00 •What is Residual Income & Why is it Important for Building Wealth?: 00:04:00 •Reasons Why Passive Income Is Important: 00:04:00 •How Does Residual Revenue Work?: 00:04:00 •Why Residual Income is Important for Financial Independence: 00:05:00 •Effective Wealth Building Strategies Used by Personal Finance Pros: 00:04:00 •Develop A Wealthy Mindset: 00:03:00 •Strategies for Building Wealth: 00:05:00 •Strategies to Build Wealth Fast (That Your Financial Advisor Won't Tell You): 00:04:00 •How to Begin to Build Wealth: 00:04:00 •Review Of Course: 00:03:00 •Assignment - Passive Income - An Ultimate Guide: 00:00:00

Overview This comprehensive course on Paint Your Own Portraits in Watercolour will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Paint Your Own Portraits in Watercolour 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 Paint Your Own Portraits in Watercolour. It is available to all students, of all academic backgrounds. Requirements Our Paint Your Own Portraits in Watercolour 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 3 sections • 11 lectures • 02:51:00 total length •Introduction: 00:02:00 •Materials: 00:02:00 •Introduction and Using Grids: 00:08:00 •Tracing: 00:02:00 •Sketching Male and Female Portraits (Face-on): 00:14:00 •Sketching Male and Female Portraits (Side-face): 00:14:00 •'Paint Along' Demonstration 1: 00:29:00 •'Paint Along' Demonstration 2: 00:27:00 •'Paint Along' Demonstration 3: 00:16:00 •'Paint Along' Demonstration 4: 00:27:00 •'Paint Along' Finishing Touches: 00:30:00

Overview This comprehensive course on Paediatric First Aid Training Course will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Paediatric First Aid Training Course comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast-track your career ladder. How will I get my certificate? 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 Paediatric First Aid Training Course. It is available to all students, of all academic backgrounds. Requirements Our Paediatric First Aid Training Course is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 1 sections • 8 lectures • 03:09:00 total length •Module 01: Introduction to Paediatric First Aid#: 00:18:00 •Module 02: Assessment and Assistance: 00:22:00 •Module 03: Equipment and Techniques: 00:29:00 •Module 04: Loss of Responsiveness and CPR: 00:20:00 •Module 05: Paediatric First Aid for Common Illnesses: 00:38:00 •Module 06: First Aid for Acute Medical Conditions: 00:22:00 •Module 07: Call for an Emergency: 00:14:00 •Module 08: Caring for Children: 00:26:00

Overview This comprehensive course on Oil & Gas : Markets Trading Pricing & Economic Framework Level 2 will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Oil & Gas : Markets Trading Pricing & Economic Framework Level 2 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 Oil & Gas : Markets Trading Pricing & Economic Framework Level 2. It is available to all students, of all academic backgrounds. Requirements Our Oil & Gas : Markets Trading Pricing & Economic Framework Level 2 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 11 sections • 51 lectures • 01:55:00 total length •Introduction: 00:04:00 •A marker price: 00:02:00 •Different strategies: 00:02:00 •Introduction: 00:01:00 •The 1970s : Long term contracts: 00:02:00 •The 1980s : The development of spot markets: 00:02:00 •The netback contracts: 00:05:00 •The 1990s : The development of financial markets: 00:02:00 •Introduction: 00:01:00 •The different types of agreements: 00:03:00 •Crude oil price setting mechanism: 00:02:00 •Product price setting mechanism: 00:02:00 •Barter agreements: 00:01:00 •Single cargo sales: 00:02:00 •Long term contracts: 00:02:00 •Definition: 00:02:00 •Spot markets in the world: 00:02:00 •Operators on the spot markets: 00:01:00 •The balance between crude oil and product prices: 00:02:00 •Spot transactions: 00:02:00 •The Brent market: 00:02:00 •The Brent crude oil: 00:01:00 •Price transparency: 00:03:00 •Indexing crude oil prices : The adjustment factor: 00:03:00 •Indexing crude oil prices : Reference indices: 00:02:00 •Indexing crude oil prices : The price timing: 00:06:00 •The limitation of the system: 00:03:00 •Example #1 : The Rotterdam products market: 00:03:00 •How prices are reported: 00:02:00 •The forward market: 00:03:00 •The principle of cover: 00:02:00 •Speculation: 00:01:00 •The players on the forward markets: 00:01:00 •Dated Brent and 15 Day Brent: 00:05:00 •The limitations of the forward markets: 00:01:00 •The historical development of the petroleum exchanges: 00:03:00 •Futures contracts: 00:01:00 •How the markets work : Generalities: 00:02:00 •How the markets work : The clearing house: 00:01:00 •How the markets work : The deposit: 00:01:00 •How the markets work : The margin call: 00:01:00 •The participants: 00:04:00 •Pricing structures : Backwardation and Contango: 00:02:00 •The limitations of the futures markets: 00:07:00 •The definition of an option: 00:01:00 •Example of the use of an option : Call option: 00:02:00 •Example of the use of an option : Put option: 00:01:00 •The cost of an option: 00:02:00 •The definition of a swap: 00:01:00 •Example of the use of a swap: 00:04:00 •Course conclusion: 00:02:00

Overview This comprehensive course on Office Admin and Reception will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Office Admin and Reception comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? 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 Office Admin and Reception. It is available to all students, of all academic backgrounds. Requirements Our Office Admin and Reception is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 17 sections • 56 lectures • 11:17:00 total length •Module 01: Introduction to Reception and Receptionist: 00:28:00 •Module 02: Business Telephone Skills: 00:21:00 •Module 03: Representing Your Boss and Company: 00:36:00 •Module 04: Mail Services and Shipping: 00:27:00 •Module 05: Travel Arrangements: 00:26:00 •Module 06: Organising Meeting and Conferences: 00:27:00 •Module 07: Time Management: 00:37:00 •Module 08: Record Keeping and Filing Systems: 00:30:00 •Module 09: Business Writing Skills: 00:42:00 •Module 10 :Organisational Skills: 00:27:00 •Module 11: Communication Skills: 00:27:00 •Module 12: Customer Service: 00:18:00 •Module 13: Effective Planning and Scheduling: 00:48:00 •Module 14: Invoicing/Petty Cash: 00:29:00 •Module 15: Business Environment: 00:18:00 •How to Get the most of the course: 00:01:00 •Text formulas in Excel: 00:08:00 •Text Formulas Exercise: 00:01:00 •Text Formulas Exercise (answers): 00:01:00 •Mathematical Formulas In Excel: 00:04:00 •Mathematical Formulas Exercise: 00:01:00 •Mathematical Formulas Exercise (answers): 00:01:00 •Date and Time Formulas In Excel: 00:05:00 •Date and Time Formulas Exercise: 00:01:00 •Date and Time Exercise Formulas (answers): 00:01:00 •Logic Formulas In Excel: 00:12:00 •Logic Formula Exercise: 00:01:00 •Logic Formula Exercise (answers): 00:01:00 •Financial Formula In Excel: 00:06:00 •Financial Formula Exercise: 00:01:00 •Financial Formula Exercise (answers): 00:02:00 •Informational Formula In Excel: 00:04:00 •Informational Formula Exercise: 00:01:00 •Informational Formula Exercise (answers): 00:01:00 •Getting Traffic To Your Site: 01:00:00 •Menu Example with Excel Vlookup: 00:08:00 •Wildcard Search with Excel Vlookup: 00:09:00 •Looking to the Left with Excel Vlookup: 00:17:00 •2-Way Lookup: 00:14:00 •Comparing Lists with Excel Vlookup: 00:03:00 •Microsoft Excel Vlookup Tips and Tricks: 00:14:00 •Power Query Intro and Excel version: 00:03:00 •Excel Power Query - Introduction: 00:03:00 •Enabling M in Power Query: 00:02:00 •Transform Data - Trim in Excel Power Query: 00:05:00 •Transform Data - Format Dates and Values in Excel Power Query: 00:02:00 •Simple Expressions: 00:08:00 •Simple Expressions - Nested Expressions: 00:03:00 •Transform Data - Parsing URLs in Excel Power Query: 00:05:00 •Variables: 00:08:00 •Formatting Excel Keyboard Shortcuts: 00:02:00 •Table Excel Keyboard Shortcuts: 00:02:00 •Editing Excel Keyboard Shortcuts: 00:05:00 •Formula Excel Keyboard Shortcuts: 00:03:00 •Workbook Excel Keyboard Shortcuts: 00:02:00 •Handy Excel Shortcuts Keyboard Shortcuts: 00:05:00

Overview Statistics reveal that over 67% of senior executives deem negotiation skills as 'crucial' for managerial roles, reinforcing the quintessential role of negotiation in today's business landscape. 'Negotiation Essential Skills - Level 3' is a meticulously crafted course to bridge the knowledge gap in this domain.  Delving deep into the rudiments of Understanding Negotiation, learners will traverse the intricacies of Phase One - Exchanging Information before transitioning to the strategic elements of Phase Two - Bargaining. The curriculum further elucidates the concept of Mutual Gain, leading to the decisive Phase Three - Closing.  With modules such as Dealing with Difficult Issues, Negotiating Outside the Boardroom, and Negotiating on Behalf of Someone Else, this course ensures a holistic understanding of the subject. 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 Negotiation Essential Skills - Level 3. It is available to all students, of all academic backgrounds. Requirements Our Negotiation Essential Skills - Level 3 is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 11 sections • 10 lectures • 01:23:00 total length •Understanding Negotiation: 00:10:00 •Getting Prepared: 00:09:00 •Laying the Groundwork: 00:07:00 •Phase One - Exchanging Information: 00:07:00 •Phase Two - Bargaining: 00:09:00 •About Mutual Gain: 00:13:00 •Phase Three - Closing: 00:06:00 •Dealing with Difficult Issues: 00:09:00 •Negotiating Outside the Boardroom: 00:07:00 •Negotiating on Behalf of Someone Else: 00:06:00

Overview This comprehensive course on Minute Taking for PA and Admin Assistants | Animated Online Course will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Minute Taking for PA and Admin Assistants | Animated Online Course 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 Minute Taking for PA and Admin Assistants | Animated Online Course. It is available to all students, of all academic backgrounds. Requirements Our Minute Taking for PA and Admin Assistants | Animated Online Course 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 2 sections • 7 lectures • 00:27:00 total length •Module 01: Introduction to Minute Writing: 00:06:00 •Module 02: Preparation for Minute Taking: 00:05:00 •Module 03: The Meeting Structure: 00:04:00 •Module 04: Minute Meetings, Decisions and Actions: 00:03:00 •Module 05: Minute Taking Techniques: 00:04:00 •Module 06: Building Confidence: 00:05:00 •Additional Reading Materials - Minute Taking for PA and Admin Assistants: 00:00:00

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