1644 Courses delivered On Demand

Overview This comprehensive course on Investment Analyst will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Investment Analyst 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 Investment Analyst. It is available to all students, of all academic backgrounds. Requirements Our Investment Analyst 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 • 11 lectures • 03:35:00 total length •Introduction to Financial Investigator: 00:21:00 •Introduction to Financial Investigation: 00:12:00 •Valuation Methods in Investment Banking: 00:29:00 •Leveraged Buyout (LBO): 00:21:00 •Initial Public Offering (IPO): 00:28:00 •Merger and Acquisition: 00:15:00 •Characteristics of Financial Crimes: 00:20:00 •Categories of Financial Crimes: 00:20:00 •Financial Crime Response Plan: 00:18:00 •Collecting, Preserving and Gathering Evidence: 00:13:00 •Laws against Financial Fraud: 00:18:00

Overview This comprehensive course on Price Action Day Trading with Tape Reading will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Price Action Day Trading with Tape Reading 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 Price Action Day Trading with Tape Reading. It is available to all students, of all academic backgrounds. Requirements Our Price Action Day Trading with Tape Reading 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 5 sections • 13 lectures • 01:29:00 total length •Introduction: 00:02:00 •1.1 Tape Reading: 00:02:00 •1.2 Level 1 vs Level 2: 00:03:00 •1.3 Supply and Demand: 00:06:00 •1.4 Time and sales: 00:03:00 •1.5 Importance of Tape Reading: 00:03:00 •2.1 Hidden Buyers: 00:11:00 •2.2 Hidden Sellers: 00:09:00 •2.3 Fakeouts and Manipulation Tactics: 00:05:00 •2.4 Identifying Reversals with Tape Reading: 00:08:00 •3.1 Setting Up Trading Platform: 00:30:00 •3.2 Risk Free Practice Trading: 00:07:00 •Assignment - Price Action Day Trading with Tape Reading: 00:00:00

Overview This comprehensive course on Enterprise Resource Planning will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Enterprise Resource Planning 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 Enterprise Resource Planning. It is available to all students, of all academic backgrounds. Requirements Our Enterprise Resource Planning 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 6 sections • 42 lectures • 01:55:00 total length •Operations of an Economic Entity: Enterprise Resource Planning: 00:03:00 •The Hierarchical Perspective: 00:02:00 •Enterprise Resource Planning ERP: 00:01:00 •Technology's Role in Business: 00:03:00 •Types of Information Systems: 00:03:00 •Interrelations between Systems: 00:01:00 •Functional IT Systems: 00:01:00 •Enterprise Resource Planning: External Priorities: 00:02:00 •Why ERP?: 00:02:00 •Overall Implementation Requisites for ERP: 00:02:00 •Challenges of ERP Implementation in Business: 00:02:00 •Senior and Project Management: 00:03:00 •Critical Factors for Successful ERP Implementation: 00:07:00 •Implementation Steps: 00:03:00 •ERP: Integration and Supply Chain Support: 00:02:00 •Web Services Integration Options: 00:02:00 •Market Information and Sales Orders: 00:02:00 •Benefits of the Marketing Information System: 00:02:00 •Customer Relationship Management: 00:02:00 •Customer Relationship Management Functions: 00:02:00 •ERP: HR Planning and Utilization: 00:03:00 •What is an HRIS?: 00:05:00 •ERP: Electronic Commerce - Accounting System Interface: 00:04:00 •E-Commerce Supply Chain Management Solutions: 00:04:00 •Problems in ERP and E-Commerce Integration: 00:01:00 •Operational Indicator, KPI's and Metrics: 00:03:00 •What is Metrics?: 00:01:00 •Need for Metrics in Testing and Quality Analysis: 00:01:00 •Metrics Continued: 00:04:00 •What are Quality Metrics?: 00:03:00 •Tips of Selection of Quality Metrics: 00:02:00 •Lead, Spot & Lagged Indicators - Drive, Monitor & Report Indicators: 00:05:00 •Lean Manufacturing and Agility: 00:05:00 •Quantitative vs. Qualitative Indicators and Measurement Scope: 00:02:00 •Measurement and Presentation Tools: 00:02:00 •Mechanisms of Success: 00:03:00 •Monitoring, Evaluation and Reporting: 00:05:00 •Balanced Scorecard Perspectives: 00:04:00 •Strategy Mapping: 00:03:00 •Balanced Scorecards vs. Dashboards: 00:04:00 •Metrics Measurements: IT Systems in ERP: 00:04:00 •Assignment -Operations Management: Enterprise Resource Planning: 00:00:00

Overview This comprehensive course on Financial Management will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Financial Management 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 Financial Management. It is available to all students, of all academic backgrounds. Requirements Our Financial Management 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 10 sections • 10 lectures • 02:55:00 total length •Introduction To Financial Management: 00:10:00 •Fundamentals Of Budgeting: 00:18:00 •The Balance Sheet: 00:15:00 •Income Statement: 00:12:00 •The Cash Flow Statement: 00:14:00 •Statement of Stockholders' Equity: 00:12:00 •Analysing and Interpreting Financial Statements: 00:50:00 •Inter-relationship between All the Financial Statements: 00:16:00 •International Aspects of Financial Management: 00:28:00 •Assignment - Financial Management: 00:00:00

Overview This comprehensive course on Accounting and Finance will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Accounting and Finance comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market. So enroll 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 Accounting and Finance. It is available to all students, of all academic backgrounds. Requirements Our Accounting and Finance 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 • 10 lectures • 03:39:00 total length •Introduction to Accounting and Finance: 00:22:00 •The Role of an Accountant: 00:23:00 •Accounting Process and Mechanics: 00:27:00 •Introduction to Financial Statements: 00:15:00 •Financial Statement Analysis: 00:30:00 •Budgeting and Budgetary Control: 00:19:00 •Financial Markets: 00:21:00 •Financial Risk Management: 00:25:00 •Investment Management: 00:19:00 •Auditing: 00:18:00

Overview Uplift Your Career & Skill Up to Your Dream Job - Learning Simplified From Home! Kickstart your career & boost your employability by helping you discover your skills, talents and interests with our special Solidworks Drawing Tools Training: Test Preparation Course. You'll create a pathway to your ideal job as this course is designed to uplift your career in the relevant industry. It provides professional training that employers are looking for in today's workplaces. The Solidworks Drawing Tools Training: Test Preparation Course is one of the most prestigious training offered at StudyHub and is highly valued by employers for good reason. This Solidworks Drawing Tools Training: Test Preparation Course has been designed by industry experts to provide our learners with the best learning experience possible to increase their understanding of their chosen field. This Solidworks Drawing Tools Training: Test Preparation Course, like every one of Study Hub's courses, is meticulously developed and well researched. Every one of the topics is divided into elementary modules, allowing our students to grasp each lesson quickly. At StudyHub, we don't just offer courses; we also provide a valuable teaching process. When you buy a course from StudyHub, you get unlimited Lifetime access with 24/7 dedicated tutor support. Why buy this Solidworks Drawing Tools Training: Test Preparation? Unlimited access to the course for forever Digital Certificate, Transcript, student ID all included in the price Absolutely no hidden fees Directly receive CPD accredited qualifications after course completion Receive one to one assistance on every weekday from professionals Immediately receive the PDF certificate after passing Receive the original copies of your certificate and transcript on the next working day Easily learn the skills and knowledge from the comfort of your home Certification After studying the course materials of the Solidworks Drawing Tools Training: Test Preparation there will be a written assignment test which you can take either during or at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for free. Original Hard Copy certificates need to be ordered at an additional cost of £8. Who is this course for? This Solidworks Drawing Tools Training: Test Preparation course is ideal for Students Recent graduates Job Seekers Anyone interested in this topic People already working in the relevant fields and want to polish their knowledge and skill. Prerequisites This Solidworks Drawing Tools Training: Test Preparation does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Solidworks Drawing Tools Training: Test Preparation was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Career path As this course comes with multiple courses included as bonus, you will be able to pursue multiple occupations. This Solidworks Drawing Tools Training: Test Preparation is a great way for you to gain multiple skills from the comfort of your home. Course Curriculum Introduction About the course 00:02:00 DRAWING BASICS Setting up drawing sheet 00:01:00 Orthographic views and edit sheet 00:04:00 Projected view and view properties 00:02:00 Smart dimension and Model Item 00:05:00 Saving options 00:01:00 DRAWING TECHNIQUES 1 Relative to model view 00:03:00 Section view 00:04:00 Auxiliary view 00:03:00 Detail view 00:02:00 Broken-out section view 00:02:00 Break view 00:02:00 Alternate position view 00:02:00 View focus 00:02:00 DRAWING TECHNIQUES 2 Bill of Materials (BOM) creation 00:03:00 Missing item in BOM 00:02:00 Custom properties in BOM 00:02:00 Equations in BOM 00:03:00 BOM properties and Item numbers 00:02:00 Hide/Show component 00:02:00 Linked notes 00:02:00 Measuring tool 00:02:00 Isometric section view 00:01:00 SAMPLE EXAM QUESTIONS QUESTION 1 00:03:00 QUESTION 2 00:01:00 QUESTION 3 00:02:00 QUESTION 4 00:02:00 QUESTION 5 00:01:00 QUESTION 6 00:02:00 OFFICIAL EXAM EXAMPLE QUESTION 1 00:03:00 QUESTION 2 00:02:00 QUESTION 3 00:02:00 QUESTION 4 00:03:00 QUESTION 5 00:01:00 QUESTION 6 00:02:00 Assignment Assignment - Solidworks Drawing Tools Training: Test Preparation 00:00:00

Master Quickbooks for all your accounting and bookkeeping needs with this step-by-step training course! The Complete QuickBooks Bookkeeping with Excel and Xero Accounting will build your proficiency in Quickbooks in no time, with instructor-led guidance taking you through fundamental procedures. You will also develop your accounting knowledge, gaining in-demand skills to work for the finance department of top organisations. This practical training course includes up-to-date knowledge, shortcuts and tips for faster, more efficient accounting and bookkeeping. Kickstart your career today and go from beginner to expert in no time! Why buy this Complete QuickBooks Bookkeeping with Excel and Xero Accounting? Unlimited access to the course for forever Digital Certificate, Transcript, student ID all included in the price Absolutely no hidden fees Directly receive CPD accredited qualifications after course completion Receive one to one assistance on every weekday from professionals Immediately receive the PDF certificate after passing Receive the original copies of your certificate and transcript on the next working day Easily learn the skills and knowledge from the comfort of your home Certification After studying the course materials of the Complete QuickBooks Bookkeeping with Excel and Xero Accounting you will be able to take the MCQ test that will assess your knowledge. After successfully passing the test you will be able to claim the pdf certificate for £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60. Who is this course for? This Complete QuickBooks Bookkeeping with Excel and Xero Accounting does not require you to have any prior qualifications or experience. You can just enrol and start learning. Prerequisites This Complete QuickBooks Bookkeeping with Excel and Xero Accounting was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Career path As this course comes with multiple courses included as bonus, you will be able to pursue multiple occupations. This Complete QuickBooks Bookkeeping with Excel and Xero Accounting is a great way for you to gain multiple skills from the comfort of your home. Course Curriculum Getting prepared - access the software and course materials The structure of the course - first things first! 00:05:00 Set up free trial 00:03:00 Getting started Starting A New Company File 00:11:00 Setting up the system Enter opening balances 00:02:00 Reverse opening balances - accruals and prepayments 00:06:00 Report Journal 00:05:00 Nominal ledger Amend The Nominal Ledger 00:07:00 Report listing the nominal ledgers 00:02:00 Customers Enter customers 00:09:00 Report on customer contact information 00:01:00 Suppliers Enter Suppliers 00:05:00 Supplier Contact List 00:02:00 Sales ledger Enter Invoices 00:09:00 Invoice Entering 00:03:00 Invoice batch 00:06:00 Post Sales Credit Notes 00:08:00 Report showing Customer Activity 00:03:00 Aged Debtors 00:02:00 Purchases ledger Post Supplier Invoices 00:03:00 Entering a Batch of Supplier Bills 00:09:00 Credit Notes Suppliers 00:05:00 Reclassify Supplier Bills - Flash Bulbs Purchased 00:04:00 Supplier Account Activity Report 00:04:00 Sundry payments Post Cheques 00:07:00 Reports showing supplier payments 00:01:00 Sundry receipts Receipts from customers 00:07:00 Report showing customer receipts 00:02:00 Petty cash Post Petty Cash Transactions and Report 00:04:00 Post cash payments to ledgers 00:02:00 Enter petty cash items 00:14:00 Report on Petty Cash Payments Proper 00:05:00 Post Sundry Payments 00:05:00 Report Bank Payments 00:03:00 VAT - Value Added Tax VAT Return 00:03:00 Bank reconciliation Reconcile The Bank 00:10:00 Provide A Report Showing Any Unreconnciled Transaction 00:02:00 Payroll / Wages Post the Wages Journal 00:08:00 Posting Journal Adjustments 00:02:00 Reports Month end adjustments 00:03:00 Month end reports 00:06:00 Tasks Task- Clearing the accounts 00:06:00 Task - Customer report 00:01:00 Additional Resources Course Paper 00:00:00

Overview Gain the expertise you need to succeed by immersing yourself in our thorough Mortgage Adviser Course.With the information and skills from this programme, you will be able to confidently assist customers in becoming homeowners by helping them understand the complexities of mortgages. Along with developing your skills in loan research, credit evaluation, and customised financial planning, you'll explore regulations and market trends.But it doesn't end there! When you finish, you'll receive a CPD Accredited Certification, which will have a significant impact on your resume and help you stand out in the job market. Imagine yourself empowering clients to realise their goals of becoming homeowners by confidently negotiating complex financial conditions.Make sure you don't miss this chance. Take a course now to open the door to a fulfilling career in mortgage advice! 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? Upon successful completion of the Mortgage Adviser Course, obtaining your certificate is a straightforward process. Here's how it works: Course Completion: Once you've successfully finished the course, you'll be eligible to receive your certificate. Order Your Certificate: You can conveniently order your certificate directly through our platform. Requirements Our Mortgage Adviser Course is designed for maximum flexibility and accessibility: It is optimised for use on PCs, Macs, laptops, tablets, and smartphones. Study easily on your tablet or smartphone, accessible with any Wi-Fi connection. No time limit for completion; study at your own pace and on your own schedule. Basic English proficiency is required to ensure effective learning. Career path Having this qualification will enhance your CV and open you up to multiple sectors, such as : Mortgage Adviser: £25k - £60k per year Financial Consultant: £30k - £70k per year Mortgage Broker: £35k - £75k per year Senior Mortgage Adviser: £40k - £80k per year Mortgage Team Manager: £45k - £90k per year Note: Salaries vary based on experience, location, and industry. Course Curriculum 10 sections • 10 lectures • 04:27:00 total length •Introduction to Mortgage and Mortgage Adviser: 00:18:00 •Basics of Mortgage Purchase: 00:24:00 •Market Research: 01:15:00 •Mortgage Finances: 00:23:00 •Being a Successful Mortgage Advisor: 00:18:00 •Mortgage Regulation and Law: UK: 00:21:00 •The Mortgage Conduct of Business (MCOB): 00:30:00 •The Mortgage Conduct of Business (MCOB), Part 2: 00:33:00 •UK Mortgage Market and Borrowers: 00:25:00 •Assignment - Mortgage Adviser Course: 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

Overview This comprehensive course on Develop Your Career in Finance: Blue Ocean Strategy will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Develop Your Career in Finance: Blue Ocean Strategy 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 Develop Your Career in Finance: Blue Ocean Strategy. It is available to all students, of all academic backgrounds. Requirements Our Develop Your Career in Finance: Blue Ocean Strategy 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 • 9 lectures • 01:06:00 total length •Course Introduction: 00:02:00 •What is the Blue Ocean Strategy: 00:07:00 •Methods used in Blue Ocean Strategy - Value Innovation and Actions: 00:05:00 •Applying Blue Ocean Strategy for Career, Future Business Trends: 00:08:00 •How you can apply 4 Point Action for career planning: 00:12:00 •What is Personal Brand and Step1 in creating PB: 00:06:00 •Steps 2 to 8 in Personal Branding: 00:14:00 •Example of a LinkedIn Profile for Personal Branding: 00:08:00 •Summarising the way forward in career development: 00:04:00