Business Analyst Job Ready Program with Complete Career Guide 2026 is designed for aspiring Business Analysts, career changers, graduates, and fitness industry professionals seeking CPD-accredited certification to build job-ready business analysis, data analytics, forecasting, Excel, finance, supply chain, marketing analytics, project management, and career guidance skills for analyst roles.
4.9
(3 Reviews)
78 Students
Exclusive Deal! 0% Off, Today Only!
Sale Ends In
In the UK, employers reported 1.26 million employees with skills gaps in 2024, showing strong demand for professionals who can analyse problems, use data, improve processes, and support smarter decisions. The Business Analyst Job Ready Program with Complete Career Guide 2026 is designed to help you build those essential , career-focused skills from the ground up.
You will learn business analysis, business management, project management, data analytics, Excel forecasting, financial modelling, cashflow management, supply chain, marketing analytics, customer analytics, risk management, communication, negotiation, and productivity skills. The course also includes exams, assignments, downloadable resources, and career guidance to support job readiness.
By completing this CPD-accredited course, you can strengthen your CV, improve workplace confidence, support business decisions, and prepare for roles in business analysis, operations, finance, analytics, retail, or management.
This Business Analyst Job Ready Program with Complete Career Guide 2026 is designed to provide a complete understanding of business analysis, data analytics, financial forecasting, project management, and workplace productivity, making it an ideal course for anyone looking to build a career as a Business Analyst or strengthen their business decision-making skills.
Throughout this CPD-accredited course, you will develop essential knowledge of business management, strategic analysis, business process modelling, Excel data analysis, financial modelling, forecasting, cashflow management, supply chain, customer analytics, marketing analytics, risk management, and communication skills used in modern business environments.
In addition to technical and analytical skills, this course also helps you understand finance, accounting, operations, leadership, negotiation, human resources, and project scheduling. These career-focused modules will help you analyse business problems, interpret data, support better decisions, improve processes, and prepare confidently for business analyst, operations, finance, management, or analytics-related roles.
By completing this Business Analyst Job Ready Program with Complete Career Guide 2026 online course, you will:
Whether you are starting your career, changing profession, or looking to grow in a business-focused role, this Business Analyst Job Ready Program with Complete Career Guide 2026 provides the essential knowledge and essential skills required to succeed in modern business environments.
As a comprehensive business analyst training course, it is designed to support real workplace needs, helping you build confidence in business analysis, data analytics, Excel forecasting, financial modelling, project management, process improvement, communication, and decision-making.
This course supports your progression into roles such as business analyst, data analyst, operations analyst, finance analyst, project coordinator, management trainee, or business consultant, giving you a strong foundation to enter the business sector or advance your existing professional skills.
This course is ideal for individuals who want to start, change, or progress their career in business analysis, data analytics, finance, operations, or management-related roles.
It is suitable for:
There are no specific prerequisites to enrol in this Business Analyst Job Ready Program with Complete Career Guide 2026. Anyone interested in business analysis, data analytics, finance, operations, or management can take this course.
The course is fully accessible from any internet-enabled smart device, allowing you to study online from the comfort of your home at your own pace.
All you need is basic literacy, a passion for learning, and to be over the age of 16.
After successfully completing the Business Analyst Job Ready Program with Complete Career Guide 2026 course, you will qualify for a CPD Certificate as proof of your continued professional development and achievement. This certificate can enhance your professional profile and showcase your commitment to building relevant skills and knowledge. You can receive your digital certificate for only £10, or request a printed hard copy sent by post for just £29 or both for £39.
For assessing your learning, you have to complete an automated MCQ exam. It is required for the students to score at least 60% to pass the exam and fulfil the Quality Licence Scheme-endorsed certificate criteria. Learners can apply for the certificate after they clear the exam.
There are assignment questions provided at the end of the course. You are suggested to complete the questions to enrich your understanding of the course. You can complete this according to your preferred time. The expert tutor will provide feedback on your performance after assessing your assignment.
The Business Analyst Job Ready Program with Complete Career Guide 2026 is an online knowledge-based training course designed to build business analysis, data analytics, Excel, finance, forecasting, project management, and decision-making skills. While it does not guarantee employment or provide a professional licence, it can support progression into various business, finance, analytics, operations, and management-related roles.
This course covers business analysis, business management, data analytics, Excel forecasting, financial modelling, project management, supply chain, marketing analytics, customer analytics, accounting, risk management, and career preparation. It is designed to build essential knowledge for business and analyst-related roles.
Yes. This course is suitable for beginners, graduates, career changers, and professionals who want to build business analysis skills step by step. No previous business analyst experience is required to get started.
Yes. The Business Analyst Job Ready Program with Complete Career Guide 2026 is delivered online, allowing you to study from home at your own pace using any internet-enabled device.
Yes. After successfully completing the course, learners can receive a CPD-accredited certificate. This can help demonstrate your learning and strengthen your CV for business, finance, analytics, or management-related opportunities.
This course provides knowledge-based training and career-focused skills, but it does not guarantee employment or provide a professional licence. It is designed to support your preparation for business analyst and related roles.
This course can support your progression towards roles such as Business Analyst, Junior Business Analyst, Data Analyst, Business Process Analyst, Finance Analyst, Operations Analyst, Supply Chain Analyst, Project Coordinator, or Management Consultant.
You will learn how to analyse business problems, understand processes, work with data, use Excel tools, build financial models, forecast performance, manage risk, prepare dashboards, and support better business decisions.
The course includes mock exams, final exams, assignments, and learning activities across selected topics. These assessments help check your understanding and support your learning progress.
This course is ideal for aspiring Business Analysts, graduates, career changers, office administrators, finance professionals, operations staff, retail professionals, entrepreneurs, and anyone interested in business analysis, data, finance, or project management.
Business analysts help organisations solve problems, improve processes, and make smarter decisions. This course helps you build job-ready knowledge in business analysis, analytics, finance, forecasting, communication, and project management to improve your professional confidence and career prospects.
| Topic 01: Business Analysis | |||
| Module 01: Introduction to Business Management | |||
| Introduction to Business Management | 00:25:00 | ||
| Module 02: Operations Management | |||
| Operations Management | 00:24:00 | ||
| Module 03: Introduction to Business Analysis | |||
| Introduction to Business Analysis | 00:14:00 | ||
| Module 04: Strategic Analysis and Product Scope | |||
| Strategic Analysis and Product Scope | 00:28:00 | ||
| Module 05: Project Management | |||
| Project Management | 00:19:00 | ||
| Module 06: Business Development and Succession Planning | |||
| Business Development and Succession Planning | 00:24:00 | ||
| Module 07: Business Process Management | |||
| Business Process Management | 00:44:00 | ||
| Module 08: Planning & Forecasting Operations | |||
| Planning & Forecasting Operations | 00:21:00 | ||
| Module 09: Performance Management | |||
| Performance Management | 00:18:00 | ||
| Module 10: Management of Cash and Credit | |||
| Management of Cash and Credit | 00:19:00 | ||
| Module 11: Managing Risk and Recovery | |||
| Managing Risk and Recovery | 00:26:00 | ||
| Module 12: Quality Management | |||
| Quality Management | 00:21:00 | ||
| Module 13: Communication Skills | |||
| Communication Skills | 00:25:00 | ||
| Module 14: Business Environment | |||
| Business Environment | 00:16:00 | ||
| Module 15: Organisational Skills | |||
| Organisational Skills | 01:16:00 | ||
| Module 16: Negotiation Techniques | |||
| Negotiation Techniques | 00:16:00 | ||
| Module 17: Human Resource Management | |||
| Human Resource Management | 00:25:00 | ||
| Module 18: Motivation and Counselling | |||
| Motivation and Counselling | 00:19:00 | ||
| Module 19: Customer Service | |||
| Customer Service | 00:16:00 | ||
| Module 20: Time Management | |||
| Time Management | 00:40:00 | ||
| Module 21: Conflict Management | |||
| Conflict Management | 00:14:00 | ||
| Mock Exam | |||
| Mock Exam – Business Analysis | 00:20:00 | ||
| Final Exam | |||
| Final Exam – Business Analysis | 00:20:00 | ||
| Topic 02: Business and Data Analytics for Beginners | |||
| Section 01: Business and Data Analytics | |||
| Introduction to Business and Data Analytics | 00:07:00 | ||
| Where are Insights Business Analytics Being Used | 00:11:00 | ||
| Problem Framing Process | 00:11:00 | ||
| Section 02: Business Process Model | |||
| Business Process Modelling | 00:10:00 | ||
| Outcome of the First Step | 00:06:00 | ||
| Outcome of the Second Step | 00:07:00 | ||
| Data Understanding | 00:07:00 | ||
| How Do You Exploit Data that no One Else Has? | 00:10:00 | ||
| Informational System Usually | 00:08:00 | ||
| Section 03: Working on Data | |||
| Data Preparation | 00:04:00 | ||
| Evaluation | 00:05:00 | ||
| Deployment | 00:07:00 | ||
| Major Health Insurance Company | 00:09:00 | ||
| Process | 00:09:00 | ||
| Topic 03: Financial Forecasting Model for New Business | |||
| Section 01: Financial Modelling - Introduction | |||
| Course Promo | 00:07:00 | ||
| Course Road Map and Outline | 00:03:00 | ||
| What is Financial Modelling? | 00:02:00 | ||
| Inputs and Outputs in Financial Modelling Process | 00:01:00 | ||
| What is Financial Modelling used for? | 00:06:00 | ||
| Key Components of a Financial Model | 00:03:00 | ||
| Short Overview of completed Financial Model | 00:06:00 | ||
| Section 02: Finance and Accounting Basics for Financial Modelling | |||
| Accounting Basics and Accounting Equation | 00:04:00 | ||
| Accounting Basics – Debits and Credits | 00:08:00 | ||
| Accrual Accounting v Cash Accounting | 00:06:00 | ||
| Prepaid Expenses and Unearned Revenue with Accrual v Cash Accounting | 00:04:00 | ||
| Section 03: Key Components of Financial Modelling Explained | |||
| Balance Sheet Basics for Financial Modelling | 00:06:00 | ||
| Income Statement or Profit or Loss Statement (Explained) | 00:05:00 | ||
| Cashflow Statement – Basics about Cashflow Statement | 00:04:00 | ||
| Two Methods of Cashflow Statement Explained | 00:05:00 | ||
| Indirect Method of Cashflow Explained in detail | 00:12:00 | ||
| Section 04: Basics of Excel Formulas and Functions (For Financial Model Building) | |||
| Introduction of the Formulas and Functions for the Financial Model | 00:04:00 | ||
| Basics of Choose Function – Explained | 00:13:00 | ||
| Basics of MAX and MIN Functions – Explained | 00:07:00 | ||
| Basics of IF Function | 00:07:00 | ||
| Basics of IF Function and NestedIF Statements | 00:06:00 | ||
| VLOOKUP Function – Explained | 00:06:00 | ||
| Match Function – Explained | 00:11:00 | ||
| VLOOKUP Function with Match Function | 00:06:00 | ||
| SUM IF Function – Explained | 00:05:00 | ||
| OFFSET Full Introduction | 00:14:00 | ||
| IFS Function | 00:08:00 | ||
| Section 05: Introduction to the Financial Model in Excel | |||
| Brief Overview of Financial Model | 00:01:00 | ||
| What are the Excel Basics of Financial Model | 00:06:00 | ||
| Walkthrough of the Completed Model | 00:17:00 | ||
| Build as many Scenarios you want with this Financial Model | 00:08:00 | ||
| Section 06: Building Income Statement for New Business | |||
| Sales Forecast – Basic Structure | 00:06:00 | ||
| Sales Forecast – Growth Rate and Validation tab | 00:10:00 | ||
| Sales Forecast – Growth Type Selection with Form Controls | 00:07:00 | ||
| Sales Forecasting Finalisation | 00:07:00 | ||
| Model Cost of Goods Sold – Opening Stock | 00:04:00 | ||
| Cost of goods sold – Growth Rates modelling | 00:08:00 | ||
| Model Cost of Goods Sold – Opening Stock | 00:04:00 | ||
| Cost of Goods Sold Finalising | 00:11:00 | ||
| Cost of Goods Sold/Gross Profit Change – Logic Behind Setting Up | 00:03:00 | ||
| Direct cost and Gross Profit | 00:05:00 | ||
| Indirect Operating Overheads – Dynamic Property Rental cost | 00:10:00 | ||
| Indirect Operating Overheads – Other Overheads | 00:06:00 | ||
| Indirect Operating Overheads – Using IFS Function | 00:06:00 | ||
| Fixed Assets and Depreciation Schedule | 00:05:00 | ||
| Fixed Assets Schedule – Setting Gross Cost and Depreciation | 00:07:00 | ||
| Fixed Assets Schedule – Finalising and Linking Depreciation to PL | 00:07:00 | ||
| Fixed Assets Schedule – Sales and Purchase of Assets | 00:03:00 | ||
| Equity and Loan Schedule – Preparation and Linking to PL | 00:09:00 | ||
| Finishing up Income Statement Modelling | 00:03:00 | ||
| Section 07: Building Cashflow Statement for New Business | |||
| Cash Inflow – Cash Sales and Collection from Credit Sales | 00:14:00 | ||
| Cash Inflow – Dynamic Growth Rate setup with Form Controls | 00:04:00 | ||
| Cash Inflow – Credit days selection drop-down menu with Form controls | 00:04:00 | ||
| Cash Inflow – Dynamic Collection days with OFFSET Function | 00:09:00 | ||
| Cash outflow – Model Cash Purchases and Payments to suppliers | 00:12:00 | ||
| Cash outflow – Direct overheads and Indirect overheads | 00:12:00 | ||
| Cash Conversion Ratio – Measure Net Profit to Cashflow for business | 00:04:00 | ||
| Cash outflow – Capex Payment, Line of Credit and Funding Movement | 00:07:00 | ||
| Section 08: Building Trade Finance Schedule (LOC) for New Business | |||
| Build a Revolving Line of Credit Schedule/Overdraft Credit Schedule | 00:07:00 | ||
| Revolving Line of Credit – Interest Modelling | 00:02:00 | ||
| Revolving Line of Credit – Linking LOC Funding to Cashflow Statement | 00:11:00 | ||
| Section 09: Error Proofing Entire Model - IMPORTANT (New Business) | |||
| How to Setup Validation and Error Check for the entire Model – Part 1 | 00:08:00 | ||
| How to Setup Validation and Error Check for the entire Model – Part 2 | 00:06:00 | ||
| How to Setup Validation and Error Check – Conclusion | 00:03:00 | ||
| Section 10: Fixed Assets Schedule - Expansion (New Business) | |||
| Fixed Asset Schedule Expansion and Why we need it | 00:03:00 | ||
| Fixed Assets Schedule Expansion – Building it Step by step | 00:16:00 | ||
| Section 11: Indirect Method of Cashflow Statement and Balance Sheet (New Business) | |||
| Building Balance Sheet – Assets Modelling | 00:10:00 | ||
| Building Balance Sheet – Liability Side | 00:08:00 | ||
| Indirect Method of CF Statement – Cashflow Model Part 1 | 00:08:00 | ||
| Indirect Method of CF Statement – Cashflow Building Part 2 | 00:06:00 | ||
| Updating Error Checks and Validations | 00:07:00 | ||
| Creating KPI Cards for New Business Financial Model | 00:08:00 | ||
| Section 12: Building Financial Model for Existing Business | |||
| Building Existing Business Financial Model – Updating Ranges Tab | 00:06:00 | ||
| Building Existing Business Financial Model – Creating Periods | 00:06:00 | ||
| Building Existing Business Financial Model – Updating Validations and Error Checks | 00:11:00 | ||
| Building Existing Business Financial Model – Finalisation and KPI Cards | 00:11:00 | ||
| Section 13: Building Dashboards for Financial Model | |||
| Overview of the New Financial Model | 00:09:00 | ||
| Data Table Preparation for the charts – Part 1 | 00:09:00 | ||
| Data Table Preparation for the charts – Part 2 | 00:04:00 | ||
| Data Table Preparation for the charts – Part 3 | 00:03:00 | ||
| Building First Column Chart – Sales and Gross Profit | 00:04:00 | ||
| Building Column Chart – with Max and Min Gross Profit % | 00:06:00 | ||
| Building Column Chart – with Max and Min Net Profit % | 00:04:00 | ||
| Building Column Chart for 12 Months Sales and Gross Profit | 00:03:00 | ||
| Building Column Chart for 12 Months Gross Profit % and Net Profit % | 00:09:00 | ||
| Building Column Chart for Cashflow, Collection and Payments for 12 Month | 00:08:00 | ||
| Building Column Chart for Trend of Operating Cashflow for 12 Months | 00:08:00 | ||
| Building a Donut Chart – Sales Products Distribution | 00:07:00 | ||
| Download FREE Stock Images for Dashboard’s Background | 00:05:00 | ||
| Importing Background Image and Setting up Dashboard | 00:05:00 | ||
| Creating Chart Backgrounds for an Amazing visual effect | 00:06:00 | ||
| Finalising New Business’s Dashboard with KPI Cards | 00:09:00 | ||
| Existing Business’s Dashboard Creation – Reusing New Business Dashboard | 00:12:00 | ||
| Waterfall Chart for Net Cashflow Performance | 00:15:00 | ||
| Section 14: Bonus: Financial Model in Google Sheets | |||
| Overview of the Financial Model in Google Sheets | 00:19:00 | ||
| WaterChart for Net Cashflow Performance in Google Sheets | 00:07:00 | ||
| Section 15: Course Wrap up and Thank you | |||
| Wrap up and Thank you (Some Important points) | 00:01:00 | ||
| Downloadable Resources | |||
| Resource – Financial Forecasting Model for New Business | 00:00:00 | ||
| Topic 04: Data Analysis and Forecasting in Excel | |||
| Modifying a Worksheet | |||
| Insert, Delete, and Adjust Cells, Columns, and Rows | 00:10:00 | ||
| Search for and Replace Data | 00:09:00 | ||
| Use Proofing and Research Tools | 00:07:00 | ||
| Working with Lists | |||
| Sort Data | 00:10:00 | ||
| Filter Data | 00:10:00 | ||
| Query Data with Database Functions | 00:09:00 | ||
| Outline and Subtotal Data | 00:09:00 | ||
| Analyzing Data | |||
| Apply Intermediate Conditional Formatting | 00:07:00 | ||
| Apply Advanced Conditional Formatting | 00:05:00 | ||
| Visualizing Data with Charts | |||
| Create Charts | 00:13:00 | ||
| Modify and Format Charts | 00:12:00 | ||
| Use Advanced Chart Features | 00:12:00 | ||
| Using PivotTables and PivotCharts | |||
| Create a PivotTable | 00:13:00 | ||
| Analyze PivotTable Data | 00:12:00 | ||
| Present Data with PivotCharts | 00:07:00 | ||
| Filter Data by Using Timelines and Slicers | 00:11:00 | ||
| Working with Multiple Worksheets and Workbooks | |||
| Use Links and External References | 00:12:00 | ||
| Use 3-D References | 00:06:00 | ||
| Consolidate Data | 00:05:00 | ||
| Using Lookup Functions and Formula Auditing | |||
| Use Lookup Functions | 00:12:00 | ||
| Trace Cells | 00:09:00 | ||
| Watch and Evaluate Formulas | 00:08:00 | ||
| Automating Workbook Functionality | |||
| Apply Data Validation | 00:13:00 | ||
| Search for Invalid Data and Formulas with Errors | 00:04:00 | ||
| Work with Macros | 00:18:00 | ||
| Creating Sparklines and Mapping Data | |||
| Create Sparklines | 00:07:00 | ||
| Navbar Collapsible Content | 00:04:00 | ||
| Forecasting Data | |||
| Determine Potential Outcomes Using Data Tables | 00:08:00 | ||
| Determine Potential Outcomes Using Scenarios | 00:09:00 | ||
| Navbar Placement | 00:04:00 | ||
| Forecasting Data Trends | 00:05:00 | ||
| Topic 05: Business Analystics for Beginners Using SASS | |||
| Section 01: Introduction | |||
| SAS Introduction | 00:07:00 | ||
| Introduction to SAS Program | 00:05:00 | ||
| Section 02: SAS Dataset | |||
| Read SAS Dataset | 00:09:00 | ||
| Practice Read Dataset | 00:08:00 | ||
| Practical Example on Read Dataset | 00:02:00 | ||
| Introduction to SAS Dataset | 00:12:00 | ||
| SAS Dataset Practical Example | 00:07:00 | ||
| SAS Dataset Practical Program | 00:06:00 | ||
| DateValue | 00:03:00 | ||
| SAS Formats Part 1 | 00:13:00 | ||
| SAS Formats Part 2 | 00:09:00 | ||
| Reading Excel Worksheets | 00:05:00 | ||
| Reading Excel Worksheet Example | 00:11:00 | ||
| Date Format Example | 00:06:00 | ||
| Section 03: Raw Data File Standard And Example | |||
| Raw Data File Standard Part 1 | 00:09:00 | ||
| Raw Data File Standard Part 2 | 00:08:00 | ||
| Raw Data File Standard Example | 00:06:00 | ||
| Section 04: Raw Data File Non Standard | |||
| Raw Data File Non Standard | 00:07:00 | ||
| Raw Data File Non Standard Example | 00:06:00 | ||
| Length Statement | 00:02:00 | ||
| Compilation Execution | 00:04:00 | ||
| Heading | 00:01:00 | ||
| Dataerrors | 00:05:00 | ||
| Data Errorsz Example | 00:03:00 | ||
| Validate Data Procfreq | 00:05:00 | ||
| Validate Data Procpront | 00:07:00 | ||
| Validate Data Peocmeans | 00:05:00 | ||
| Dat Constant | 00:07:00 | ||
| Assignment Statement | 00:09:00 | ||
| If Then Statement | 00:09:00 | ||
| If Then Do End Statement | 00:09:00 | ||
| Diff Where and If Statement | 00:02:00 | ||
| Keep Drop | 00:08:00 | ||
| Keep Drop Example | 00:04:00 | ||
| Section 05: Append | |||
| Append | 00:09:00 | ||
| Append Examples part 1 | 00:09:00 | ||
| Append Examples part 2 | 00:07:00 | ||
| Concatenate | 00:12:00 | ||
| Merge | 00:06:00 | ||
| Merge One to One | 00:07:00 | ||
| Merge One to Many | 00:04:00 | ||
| Merge Non Match | 00:04:00 | ||
| Section 06: Option Statements | |||
| Global Statements | 00:09:00 | ||
| Global Statements Examples Part 1 | 00:08:00 | ||
| Global Statements Examples Part 2 | 00:06:00 | ||
| Section 07: Title n Foot Note | |||
| Title n Foot Note | 00:05:00 | ||
| Title n Foot Note Example | 00:08:00 | ||
| By Statement | 00:08:00 | ||
| Multiple Where Stament | 00:03:00 | ||
| Section 08: ODS statements | |||
| ODS | 00:07:00 | ||
| ODS Example | 00:04:00 | ||
| Section 09: Date Functions | |||
| Sas Date Function | 00:10:00 | ||
| Sas Date Function Example | 00:08:00 | ||
| Sas Functions Part 1 | 00:10:00 | ||
| Sas Functions Part 2 | 00:08:00 | ||
| Sas Functions | 00:07:00 | ||
| Sas Functions Example Part 1 | 00:07:00 | ||
| Sas Functions Example Part 2 | 00:09:00 | ||
| Section 10: Multiple SAS datasets | |||
| Multiple SAS Datasets Part 1 | 00:05:00 | ||
| Multiple SAS Datasets Part 2 | 00:02:00 | ||
| Multiple SAS Datasets Example | 00:10:00 | ||
| Section 11: Select Group | |||
| Select Group | 00:09:00 | ||
| Select Group Example | 00:08:00 | ||
| Section 12: Do Loop | |||
| Do Loop Part 1 | 00:07:00 | ||
| Do Loop Part 2 | 00:06:00 | ||
| Do Loop Example | 00:07:00 | ||
| Section 13: Array | |||
| Array Part 1 | 00:05:00 | ||
| Array Part 2 | 00:08:00 | ||
| Array DoLoop | 00:06:00 | ||
| ArrayTemp | 00:05:00 | ||
| Array Example | 00:10:00 | ||
| Sas Statement Part 1 | 00:04:00 | ||
| Sas Statement Part 2 | 00:05:00 | ||
| Topic 06: Supply Chain Management for Different Retail Formats | |||
| Supply Chain Management for Different Retail Formats | |||
| Lesson 01: Introduction Retail Customer Service Customer Service Mix | 00:08:00 | ||
| Lesson 02: Customer Service Pyramid Customer Service over Retail Life cycle | 00:07:00 | ||
| Lesson 03: Ways to improve Customer Service for a Retailer | 00:09:00 | ||
| Lesson 04: Order Management Process Concept of Perfect Order | 00:06:00 | ||
| Lesson 05: Multi Channel Retailing | 00:09:00 | ||
| Lesson 06: Retail Returns Reverse Logistics | 00:08:00 | ||
| Lesson 07: Reverse Logistics process | 00:11:00 | ||
| Lesson 08: Retail Loyalty Programmes | 00:08:00 | ||
| Lesson 09: Retail kiosk advanced payment technologies conclusion | 00:09:00 | ||
| Topic 07: Customer Analytics Training | |||
| Section 01: Basics Of Customer Analytics And Customer Life Cycle | |||
| What Is Customer Analytics | 00:04:00 | ||
| Customer Life Cycle | 00:04:00 | ||
| Section 02: Customer Onboarding | |||
| Customer Onboarding When Whom | 00:01:00 | ||
| Customer Onboarding Process For A Typical Bank | 00:04:00 | ||
| Section 03: Customer Activation | |||
| What Is Activation And Why Is It Necessary | 00:01:00 | ||
| The Importance Of Customer Activation | 00:03:00 | ||
| Section 04: Cross Selling | |||
| What Is Cross Sell And Why Cross Sell | 00:03:00 | ||
| How Do We Cross Sell Effectively | 00:06:00 | ||
| Upgrade Upsell | 00:06:00 | ||
| Section 05: Campaign Life Cycle | |||
| Campaign Life Cycle Transition To Lead Management | 00:04:00 | ||
| Stages Of Campaign | 00:04:00 | ||
| Campaign Execution | 00:03:00 | ||
| Campaign Channels | 00:07:00 | ||
| Campaign Assessment | 00:05:00 | ||
| Section 06: Conclusion | |||
| Conclusion | 00:08:00 | ||
| Topic 08: Fundamentals of Marketing Analytics | |||
| Section 01: Introduction To Marketing Analytics Overview | |||
| Introduction | 00:02:00 | ||
| What Is Marketing | 00:04:00 | ||
| Why Do We Need Marketing | 00:08:00 | ||
| Section 02: Basic Concepts In Marketing Analytics Overview | |||
| What To Market | 00:03:00 | ||
| Whom And When To Market | 00:06:00 | ||
| How Analytics Drives Marketing Strategies | 00:08:00 | ||
| Acquisition To Retention | 00:08:00 | ||
| Customer Profitability To Contact Strategy | 00:06:00 | ||
| Campaign Analytic | 00:12:00 | ||
| Topic 09: Supply Chain Masterclass in Retail | |||
| Supply Chain Masterclass in Retail | |||
| Lesson 01: Retail: An Introduction | 00:18:00 | ||
| Lesson 02: Retail India: A Case Study | 00:15:00 | ||
| Lesson 03: Retail Location: An Advantage | 00:17:00 | ||
| Lesson 04: Retailing: An Overview | 00:03:00 | ||
| Lesson 05: Evolution of Indian Retail | 00:12:00 | ||
| Lesson 06: Indian Retail Key Enablers | 00:08:00 | ||
| Lesson 07: Supply Chain Management for Retailing A challenge for Retailers | 00:10:00 | ||
| Lesson 08: Porters Value Chain | 00:13:00 | ||
| Lesson 09: Characteristics of an Efficient Supply Chain | 00:09:00 | ||
| Lesson 10: Supply Chain Components | 00:06:00 | ||
| Lesson 11: Macro Process In SCM | 00:10:00 | ||
| Lesson 12: Stages In SCM | 00:11:00 | ||
| Lesson 13: SCM Issues | 00:09:00 | ||
| Lesson 14: Push Based SCM | 00:12:00 | ||
| Lesson 15: Pull Based SCM | 00:06:00 | ||
| Conclusion | 00:06:00 | ||
| Topic 10: Business Productivity Training | |||
| Introduction | |||
| Prof Paul Course Intro | 00:03:00 | ||
| Productivity Training | |||
| Productivity – Part 1 | 00:12:00 | ||
| Productivity – Part 2 | 00:12:00 | ||
| Productivity – Part 3 | 00:13:00 | ||
| Teamwork Training | |||
| Project Management – Part 1 | 00:15:00 | ||
| Project Management – Part 2 | 00:17:00 | ||
| Teamwork Training | |||
| Teamwork – Part 1 | 00:12:00 | ||
| Teamwork – Part 2 | 00:12:00 | ||
| Teamwork – Part 3 | 00:13:00 | ||
| Communication Training | |||
| Communication – Part 1 | 00:17:00 | ||
| Communication – Part 2 | 00:18:00 | ||
| Topic 11: Dealing With uncertainty: Make Budgets and Forecasts | |||
| Dealing With uncertainty: Make Budgets and Forecasts | |||
| Introduction to the Course | 00:01:00 | ||
| Course Curriculum | 00:02:00 | ||
| Why do We do Budgeting? | 00:06:00 | ||
| Paper Exercise or Something Useful? | 00:06:00 | ||
| Two Key Budgets and What They Contain | 00:05:00 | ||
| Suggestive Process of Budgeting | 00:05:00 | ||
| Pre-Requirements of Budgeting | 00:04:00 | ||
| Three Key Components of Budgets | 00:09:00 | ||
| Practical Process of Budgeting and Forecasting | 00:10:00 | ||
| Basics of Revenue Budgeting | 00:05:00 | ||
| Revenue Budget – Information Needed | 00:04:00 | ||
| Revenue Budget – Practical Example | 00:04:00 | ||
| Estimating Overall Impact of Revenue | 00:02:00 | ||
| Cost and Expenses Budget – Information Needed | 00:08:00 | ||
| Labour Cost Budgeting | 00:05:00 | ||
| Other Expenses Budgeting Process | 00:03:00 | ||
| Capital Expenditure Budgeting | 00:05:00 | ||
| Qualitative Aspects of Budgeting | 00:04:00 | ||
| Marketing Budget | 00:04:00 | ||
| How to Make Budgets and Forecasts | 01:52:00 | ||
| Introduction to Budgeting and Forecasting During Uncertainty | 00:03:00 | ||
| Causes of Uncertainty | 00:04:00 | ||
| Change the Purpose of Budgeting | 00:04:00 | ||
| Budgeting for Strategic Success | 00:04:00 | ||
| Key Aspects of Strategic Budgeting | 00:05:00 | ||
| How Often We should do Budgeting | 00:06:00 | ||
| 5 Principles of Business Planning During Uncertainty | 00:05:00 | ||
| Alternative Options for Annual Budget | 00:07:00 | ||
| Topic 12: Cashflow Management and Forecasting | |||
| Module 01 | |||
| Introduction | 00:03:00 | ||
| What is Cashflow? | 00:04:00 | ||
| Forecasting | 00:07:00 | ||
| Planning and Management | 00:05:00 | ||
| Planning Part 2 | 00:12:00 | ||
| Module 02 | |||
| Where it can go Wrong | 00:09:00 | ||
| Personal Cashflow Analysis | 00:05:00 | ||
| Personal Cashflow Analysis my Numbers Story | 00:06:00 | ||
| Debt | 00:10:00 | ||
| Conclusion | 00:04:00 | ||
| Topic 13: Raising Money & Valuations | |||
| Raising Money & Valuations | |||
| Traditional Capital Raising | 00:07:00 | ||
| Startup Financing and Stages | 00:15:00 | ||
| Early Stage Financing – Own capital, crowdfunding and leasing | 00:13:00 | ||
| Early Stage FInancing – Angel Investing, VC Capital | 00:17:00 | ||
| Why we need valuation and is it objective | 00:07:00 | ||
| Business Valuation Concepts | 00:07:00 | ||
| process of valuations and factors that affect valuations | 00:11:00 | ||
| Valuation Methods and Market Approach | 00:13:00 | ||
| Income Valuation Approach | 00:09:00 | ||
| Discounting rate and how we determine it | 00:13:00 | ||
| Other Methods of valuation and Conclusion | 00:18:00 | ||
| Assignment | |||
| Assignment – Raising Money & Valuations | 00:00:00 | ||
| Topic 14: Cost Control & Project Scheduling | |||
| Chapter 1 | |||
| Monitoring and Controlling Fundamentals | 00:45:00 | ||
| Chapter 2 | |||
| Schedule Control | 00:55:00 | ||
| Chapter 3 | |||
| Cost Control | 00:43:00 | ||
| Assignment | |||
| Assignment – Cost Control & Project Scheduling | 00:00:00 | ||
| Topic 15: Mini MBA | |||
| Module 01: Appreciating the Mini MBA | |||
| Appreciating the Mini MBA | 00:10:00 | ||
| Module 02: The Foundations of Business | |||
| The Foundations of Business | 00:10:00 | ||
| Module 03: Understanding Business Law | |||
| Understanding Business Law | 00:00:00 | ||
| Module 04: Competitive Business Strategies | |||
| Competitive Business Strategies | 00:10:00 | ||
| Module 05: Departments in Business | |||
| Departments in Business | 00:10:00 | ||
| Module 06: Planning the Right Strategy for Business | |||
| Planning the Right Strategy for Business | 00:05:00 | ||
| Module 07: Managing Human Resources in Business | |||
| Managing Human Resources in Business | 00:10:00 | ||
| Module 08: Economics Influences on Business | |||
| Economics Influences on Business | 00:10:00 | ||
| Module 09: Business Accounting | |||
| Business Accounting | 00:10:00 | ||
| Module 10: Finance in Business | |||
| Finance in Business | 00:10:00 | ||
| Module 11: Business Marketing | |||
| Business Marketing | 00:10:00 | ||
| Module 12: Advertising and Promotion | |||
| Advertising and Promotion | 00:10:00 | ||
| Module 13: The Art of Negotiation | |||
| The Art of Negotiation | 00:05:00 | ||
| Module 14: Communication and Presentation | |||
| Communication and Presentation | 00:05:00 | ||
| Module 15: Organisational Behaviour in Business | |||
| Organisational Behaviour in Business | 00:10:00 | ||
| Module 16: Building Teams in Business | |||
| Building Teams in Business | 00:05:00 | ||
| Module 17: Business Leadership | |||
| Business Leadership | 00:05:00 | ||
| Module 18: Operations Management | |||
| Operations Management | 00:15:00 | ||
| Module 19: The Importance of Risk Management | |||
| The Importance of Risk Management | 00:10:00 | ||
| Module 20: Project Management | |||
| Project Management | 00:05:00 | ||
| Module 21: Quantitative Research and Analysis | |||
| Quantitative Research and Analysis | 00:05:00 | ||
| Module 22: Qualitative Research and Analysis | |||
| Qualitative Research and Analysis | 00:05:00 | ||
| Module 23: Becoming an Entrepreneur | |||
| Becoming an Entrepreneur | 00:05:00 | ||
| Module 24: Corporate Social Responsibility (CSR) | |||
| Corporate Social Responsibility (CSR) | 00:10:00 | ||
| Module 25: Avoiding Management Mistakes | |||
| Avoiding Management Mistakes | 00:05:00 | ||
| Topic 16: Business Accounting Training | |||
| Professional Bookkeeper Introduction | |||
| Professional Bookkeeper | 00:09:00 | ||
| Introduction to Accounting and Business | |||
| Defining a Business | 00:07:00 | ||
| Ethics in Accounting | 00:05:00 | ||
| Generally Accepted Accounting Principles (GAAP) | 00:10:00 | ||
| The Accounting Equation | |||
| The Accounting Equation | 00:07:00 | ||
| Transactions | 00:11:00 | ||
| Analyzing Transactions | |||
| The Accounting Equation and Transactions | 00:16:00 | ||
| Double-Entry System | 00:12:00 | ||
| Transactions – Journalizing | 00:17:00 | ||
| Entering Information - Posting Entries | |||
| Posting Entries | 00:10:00 | ||
| The Trial Balance | 00:10:00 | ||
| Finding Errors Using Horizontal Analysis | 00:09:00 | ||
| Horizontal Trend : Balance Sheet | 00:21:00 | ||
| Horizontal Trend: Income Statement | 00:36:00 | ||
| Adjusting Process | |||
| The Purpose of the Adjusting Process | 00:15:00 | ||
| Adjusting Entries | |||
| Adjusting Entries – Prepaid Expenses | 00:13:00 | ||
| Adjusting Entries – Accrued Revenues | 00:10:00 | ||
| Adjusting Entries – Depreciation Expense | 00:09:00 | ||
| Adjustment Summary | |||
| Adjustment Summary – Review | 00:13:00 | ||
| Vertical Analysis | 00:33:00 | ||
| Preparing a Worksheet | |||
| Preparing a Worksheet | 00:06:00 | ||
| Financial Statements | |||
| The Income Statement | 00:11:00 | ||
| Financial Statements – Definitions | 00:12:00 | ||
| Completing the Accounting Cycle | |||
| Temporary vs. Permanent Accounts | 00:19:00 | ||
| The Accounting Cycle Illustrated | |||
| Accounting Cycle Illustrated – Steps 1-5 | 00:11:00 | ||
| Accounting Cycle Illustrated – Steps 6-1 | 00:12:00 | ||
| Fiscal Year | |||
| Fiscal Year | 00:09:00 | ||
| Spreadsheet Exercise | |||
| Spreadsheet Exercise – Steps 1-4 | 00:11:00 | ||
| Spreadsheet Exercise – Steps 5-7 | 00:37:00 | ||
| Mock Exam | |||
| Mock Exam- Business Accounting Training | 00:20:00 | ||
| Final Exam | |||
| Final Exam- Business Accounting Training | 00:20:00 | ||
| Topic 17: Financial Analysis: Finance Reports | |||
| Financial Analysis: Reading Financial Statements like a Pro | |||
| Welcome to the Course! Get the Overview of What You’ll Learn | 00:04:00 | ||
| What is a 10-K? | 00:07:00 | ||
| Evaluating Profitability by Analyzing the Income Statement | 00:19:00 | ||
| Evaluating Operations: Tying Operating Metrics to Financial Results | 00:07:00 | ||
| Evaluating Financial Strength: Balance Sheet Analysis | 00:14:00 | ||
| Evaluating Cash Flow Generation | 00:09:00 | ||
| Performing Investment Analysis | 00:15:00 | ||
| Assignment | |||
| Assignment – Financial Analysis: Finance Reports | 00:00:00 | ||
| Topic 18: Presenting Financial Information | |||
| Presenting Financial Information | |||
| Module 01: Presenting Financial Information | 00:06:00 | ||
| Module 02: The Hierarchy of Performance Indicators | 00:05:00 | ||
| Module 03: The Principle of Effective Reports | 00:06:00 | ||
| Module 04: Guidelines for Designing Management Reports | 00:05:00 | ||
| Module 05: Methods of Presenting Performance Data | 00:04:00 | ||
| Module 06: The Control Chart: Highlighting the Variation in the Data | 00:07:00 | ||
| Module 07: The Pareto Chart: Highlighting Priorities | 00:01:00 | ||
| Module 08: Exercise: The Control Chart | 00:05:00 | ||
| Module 09: An Example Management Report | 00:03:00 | ||
| Module 10: Interpreting Performance Data | 00:04:00 | ||
| Module 11: Supporting Colleagues by Giving Feedback | 00:05:00 | ||
| Module 12: Data Visualisation Part 01 | 00:09:00 | ||
| Module 13: Data Visualisation Part 02 | 00:07:00 | ||
| Module 14: Data Visualisation Part 03 | 00:09:00 | ||
| Module 15: Data Visualisation Part 04 | 00:04:00 | ||
| Module 16: Final Thoughts on Presenting Financial Information | 00:04:00 | ||
| Assignment | |||
| Assignment – Presenting Financial Information | 00:00:00 | ||
| Topic 19: Finance: Financial Risk Management | |||
| Finance: Financial Risk Management | |||
| Lesson 01: Introduction | 00:01:00 | ||
| Lesson 02: Derivatives-Concepts and types of derivatives | 00:09:00 | ||
| Lesson 03: Future contracts, understanding future concepts deviating risks | 00:07:00 | ||
| Lesson 04: Settlement in future markets | 00:13:00 | ||
| Lesson 05: Option contracts, call option, Analysis of Holder and Writer in call option | 00:16:00 | ||
| Lesson 06: Put option, Analysis of Holder and writer in put option | 00:11:00 | ||
| Lesson 07: Types of options in the expiration date | 00:09:00 | ||
| Topic 20: Financial Modelling Course – Learn Online | |||
| Financial Modelling | |||
| Welcome to the Course! Get the Overview of What You’ll Learn | 00:04:00 | ||
| Planning your Financial Model | 00:09:00 | ||
| Building a Model Template | 00:12:00 | ||
| Projecting the Income Statement | 00:13:00 | ||
| Projecting the Balance Sheet | 00:17:00 | ||
| Projecting Cash Flows | 00:14:00 | ||
| Advanced Financial Modeling | 00:14:00 | ||
| BONUS LESSON: Top 5 Excel Features for Financial Modellers | 00:08:00 | ||
| Topic 01: Business Analysis | |||
| Module 01: Introduction to Business Management | |||
| Introduction to Business Management | 00:25:00 | ||
| Module 02: Operations Management | |||
| Operations Management | 00:24:00 | ||
| Module 03: Introduction to Business Analysis | |||
| Introduction to Business Analysis | 00:14:00 | ||
| Module 04: Strategic Analysis and Product Scope | |||
| Strategic Analysis and Product Scope | 00:28:00 | ||
| Module 05: Project Management | |||
| Project Management | 00:19:00 | ||
| Module 06: Business Development and Succession Planning | |||
| Business Development and Succession Planning | 00:24:00 | ||
| Module 07: Business Process Management | |||
| Business Process Management | 00:44:00 | ||
| Module 08: Planning & Forecasting Operations | |||
| Planning & Forecasting Operations | 00:21:00 | ||
| Module 09: Performance Management | |||
| Performance Management | 00:18:00 | ||
| Module 10: Management of Cash and Credit | |||
| Management of Cash and Credit | 00:19:00 | ||
| Module 11: Managing Risk and Recovery | |||
| Managing Risk and Recovery | 00:26:00 | ||
| Module 12: Quality Management | |||
| Quality Management | 00:21:00 | ||
| Module 13: Communication Skills | |||
| Communication Skills | 00:25:00 | ||
| Module 14: Business Environment | |||
| Business Environment | 00:16:00 | ||
| Module 15: Organisational Skills | |||
| Organisational Skills | 01:16:00 | ||
| Module 16: Negotiation Techniques | |||
| Negotiation Techniques | 00:16:00 | ||
| Module 17: Human Resource Management | |||
| Human Resource Management | 00:25:00 | ||
| Module 18: Motivation and Counselling | |||
| Motivation and Counselling | 00:19:00 | ||
| Module 19: Customer Service | |||
| Customer Service | 00:16:00 | ||
| Module 20: Time Management | |||
| Time Management | 00:40:00 | ||
| Module 21: Conflict Management | |||
| Conflict Management | 00:14:00 | ||
| Mock Exam | |||
| Mock Exam – Business Analysis | 00:20:00 | ||
| Final Exam | |||
| Final Exam – Business Analysis | 00:20:00 | ||
| Topic 02: Business and Data Analytics for Beginners | |||
| Section 01: Business and Data Analytics | |||
| Introduction to Business and Data Analytics | 00:07:00 | ||
| Where are Insights Business Analytics Being Used | 00:11:00 | ||
| Problem Framing Process | 00:11:00 | ||
| Section 02: Business Process Model | |||
| Business Process Modelling | 00:10:00 | ||
| Outcome of the First Step | 00:06:00 | ||
| Outcome of the Second Step | 00:07:00 | ||
| Data Understanding | 00:07:00 | ||
| How Do You Exploit Data that no One Else Has? | 00:10:00 | ||
| Informational System Usually | 00:08:00 | ||
| Section 03: Working on Data | |||
| Data Preparation | 00:04:00 | ||
| Evaluation | 00:05:00 | ||
| Deployment | 00:07:00 | ||
| Major Health Insurance Company | 00:09:00 | ||
| Process | 00:09:00 | ||
| Topic 03: Financial Forecasting Model for New Business | |||
| Section 01: Financial Modelling - Introduction | |||
| Course Promo | 00:07:00 | ||
| Course Road Map and Outline | 00:03:00 | ||
| What is Financial Modelling? | 00:02:00 | ||
| Inputs and Outputs in Financial Modelling Process | 00:01:00 | ||
| What is Financial Modelling used for? | 00:06:00 | ||
| Key Components of a Financial Model | 00:03:00 | ||
| Short Overview of completed Financial Model | 00:06:00 | ||
| Section 02: Finance and Accounting Basics for Financial Modelling | |||
| Accounting Basics and Accounting Equation | 00:04:00 | ||
| Accounting Basics – Debits and Credits | 00:08:00 | ||
| Accrual Accounting v Cash Accounting | 00:06:00 | ||
| Prepaid Expenses and Unearned Revenue with Accrual v Cash Accounting | 00:04:00 | ||
| Section 03: Key Components of Financial Modelling Explained | |||
| Balance Sheet Basics for Financial Modelling | 00:06:00 | ||
| Income Statement or Profit or Loss Statement (Explained) | 00:05:00 | ||
| Cashflow Statement – Basics about Cashflow Statement | 00:04:00 | ||
| Two Methods of Cashflow Statement Explained | 00:05:00 | ||
| Indirect Method of Cashflow Explained in detail | 00:12:00 | ||
| Section 04: Basics of Excel Formulas and Functions (For Financial Model Building) | |||
| Introduction of the Formulas and Functions for the Financial Model | 00:04:00 | ||
| Basics of Choose Function – Explained | 00:13:00 | ||
| Basics of MAX and MIN Functions – Explained | 00:07:00 | ||
| Basics of IF Function | 00:07:00 | ||
| Basics of IF Function and NestedIF Statements | 00:06:00 | ||
| VLOOKUP Function – Explained | 00:06:00 | ||
| Match Function – Explained | 00:11:00 | ||
| VLOOKUP Function with Match Function | 00:06:00 | ||
| SUM IF Function – Explained | 00:05:00 | ||
| OFFSET Full Introduction | 00:14:00 | ||
| IFS Function | 00:08:00 | ||
| Section 05: Introduction to the Financial Model in Excel | |||
| Brief Overview of Financial Model | 00:01:00 | ||
| What are the Excel Basics of Financial Model | 00:06:00 | ||
| Walkthrough of the Completed Model | 00:17:00 | ||
| Build as many Scenarios you want with this Financial Model | 00:08:00 | ||
| Section 06: Building Income Statement for New Business | |||
| Sales Forecast – Basic Structure | 00:06:00 | ||
| Sales Forecast – Growth Rate and Validation tab | 00:10:00 | ||
| Sales Forecast – Growth Type Selection with Form Controls | 00:07:00 | ||
| Sales Forecasting Finalisation | 00:07:00 | ||
| Model Cost of Goods Sold – Opening Stock | 00:04:00 | ||
| Cost of goods sold – Growth Rates modelling | 00:08:00 | ||
| Model Cost of Goods Sold – Opening Stock | 00:04:00 | ||
| Cost of Goods Sold Finalising | 00:11:00 | ||
| Cost of Goods Sold/Gross Profit Change – Logic Behind Setting Up | 00:03:00 | ||
| Direct cost and Gross Profit | 00:05:00 | ||
| Indirect Operating Overheads – Dynamic Property Rental cost | 00:10:00 | ||
| Indirect Operating Overheads – Other Overheads | 00:06:00 | ||
| Indirect Operating Overheads – Using IFS Function | 00:06:00 | ||
| Fixed Assets and Depreciation Schedule | 00:05:00 | ||
| Fixed Assets Schedule – Setting Gross Cost and Depreciation | 00:07:00 | ||
| Fixed Assets Schedule – Finalising and Linking Depreciation to PL | 00:07:00 | ||
| Fixed Assets Schedule – Sales and Purchase of Assets | 00:03:00 | ||
| Equity and Loan Schedule – Preparation and Linking to PL | 00:09:00 | ||
| Finishing up Income Statement Modelling | 00:03:00 | ||
| Section 07: Building Cashflow Statement for New Business | |||
| Cash Inflow – Cash Sales and Collection from Credit Sales | 00:14:00 | ||
| Cash Inflow – Dynamic Growth Rate setup with Form Controls | 00:04:00 | ||
| Cash Inflow – Credit days selection drop-down menu with Form controls | 00:04:00 | ||
| Cash Inflow – Dynamic Collection days with OFFSET Function | 00:09:00 | ||
| Cash outflow – Model Cash Purchases and Payments to suppliers | 00:12:00 | ||
| Cash outflow – Direct overheads and Indirect overheads | 00:12:00 | ||
| Cash Conversion Ratio – Measure Net Profit to Cashflow for business | 00:04:00 | ||
| Cash outflow – Capex Payment, Line of Credit and Funding Movement | 00:07:00 | ||
| Section 08: Building Trade Finance Schedule (LOC) for New Business | |||
| Build a Revolving Line of Credit Schedule/Overdraft Credit Schedule | 00:07:00 | ||
| Revolving Line of Credit – Interest Modelling | 00:02:00 | ||
| Revolving Line of Credit – Linking LOC Funding to Cashflow Statement | 00:11:00 | ||
| Section 09: Error Proofing Entire Model - IMPORTANT (New Business) | |||
| How to Setup Validation and Error Check for the entire Model – Part 1 | 00:08:00 | ||
| How to Setup Validation and Error Check for the entire Model – Part 2 | 00:06:00 | ||
| How to Setup Validation and Error Check – Conclusion | 00:03:00 | ||
| Section 10: Fixed Assets Schedule - Expansion (New Business) | |||
| Fixed Asset Schedule Expansion and Why we need it | 00:03:00 | ||
| Fixed Assets Schedule Expansion – Building it Step by step | 00:16:00 | ||
| Section 11: Indirect Method of Cashflow Statement and Balance Sheet (New Business) | |||
| Building Balance Sheet – Assets Modelling | 00:10:00 | ||
| Building Balance Sheet – Liability Side | 00:08:00 | ||
| Indirect Method of CF Statement – Cashflow Model Part 1 | 00:08:00 | ||
| Indirect Method of CF Statement – Cashflow Building Part 2 | 00:06:00 | ||
| Updating Error Checks and Validations | 00:07:00 | ||
| Creating KPI Cards for New Business Financial Model | 00:08:00 | ||
| Section 12: Building Financial Model for Existing Business | |||
| Building Existing Business Financial Model – Updating Ranges Tab | 00:06:00 | ||
| Building Existing Business Financial Model – Creating Periods | 00:06:00 | ||
| Building Existing Business Financial Model – Updating Validations and Error Checks | 00:11:00 | ||
| Building Existing Business Financial Model – Finalisation and KPI Cards | 00:11:00 | ||
| Section 13: Building Dashboards for Financial Model | |||
| Overview of the New Financial Model | 00:09:00 | ||
| Data Table Preparation for the charts – Part 1 | 00:09:00 | ||
| Data Table Preparation for the charts – Part 2 | 00:04:00 | ||
| Data Table Preparation for the charts – Part 3 | 00:03:00 | ||
| Building First Column Chart – Sales and Gross Profit | 00:04:00 | ||
| Building Column Chart – with Max and Min Gross Profit % | 00:06:00 | ||
| Building Column Chart – with Max and Min Net Profit % | 00:04:00 | ||
| Building Column Chart for 12 Months Sales and Gross Profit | 00:03:00 | ||
| Building Column Chart for 12 Months Gross Profit % and Net Profit % | 00:09:00 | ||
| Building Column Chart for Cashflow, Collection and Payments for 12 Month | 00:08:00 | ||
| Building Column Chart for Trend of Operating Cashflow for 12 Months | 00:08:00 | ||
| Building a Donut Chart – Sales Products Distribution | 00:07:00 | ||
| Download FREE Stock Images for Dashboard’s Background | 00:05:00 | ||
| Importing Background Image and Setting up Dashboard | 00:05:00 | ||
| Creating Chart Backgrounds for an Amazing visual effect | 00:06:00 | ||
| Finalising New Business’s Dashboard with KPI Cards | 00:09:00 | ||
| Existing Business’s Dashboard Creation – Reusing New Business Dashboard | 00:12:00 | ||
| Waterfall Chart for Net Cashflow Performance | 00:15:00 | ||
| Section 14: Bonus: Financial Model in Google Sheets | |||
| Overview of the Financial Model in Google Sheets | 00:19:00 | ||
| WaterChart for Net Cashflow Performance in Google Sheets | 00:07:00 | ||
| Section 15: Course Wrap up and Thank you | |||
| Wrap up and Thank you (Some Important points) | 00:01:00 | ||
| Downloadable Resources | |||
| Resource – Financial Forecasting Model for New Business | 00:00:00 | ||
| Topic 04: Data Analysis and Forecasting in Excel | |||
| Modifying a Worksheet | |||
| Insert, Delete, and Adjust Cells, Columns, and Rows | 00:10:00 | ||
| Search for and Replace Data | 00:09:00 | ||
| Use Proofing and Research Tools | 00:07:00 | ||
| Working with Lists | |||
| Sort Data | 00:10:00 | ||
| Filter Data | 00:10:00 | ||
| Query Data with Database Functions | 00:09:00 | ||
| Outline and Subtotal Data | 00:09:00 | ||
| Analyzing Data | |||
| Apply Intermediate Conditional Formatting | 00:07:00 | ||
| Apply Advanced Conditional Formatting | 00:05:00 | ||
| Visualizing Data with Charts | |||
| Create Charts | 00:13:00 | ||
| Modify and Format Charts | 00:12:00 | ||
| Use Advanced Chart Features | 00:12:00 | ||
| Using PivotTables and PivotCharts | |||
| Create a PivotTable | 00:13:00 | ||
| Analyze PivotTable Data | 00:12:00 | ||
| Present Data with PivotCharts | 00:07:00 | ||
| Filter Data by Using Timelines and Slicers | 00:11:00 | ||
| Working with Multiple Worksheets and Workbooks | |||
| Use Links and External References | 00:12:00 | ||
| Use 3-D References | 00:06:00 | ||
| Consolidate Data | 00:05:00 | ||
| Using Lookup Functions and Formula Auditing | |||
| Use Lookup Functions | 00:12:00 | ||
| Trace Cells | 00:09:00 | ||
| Watch and Evaluate Formulas | 00:08:00 | ||
| Automating Workbook Functionality | |||
| Apply Data Validation | 00:13:00 | ||
| Search for Invalid Data and Formulas with Errors | 00:04:00 | ||
| Work with Macros | 00:18:00 | ||
| Creating Sparklines and Mapping Data | |||
| Create Sparklines | 00:07:00 | ||
| Navbar Collapsible Content | 00:04:00 | ||
| Forecasting Data | |||
| Determine Potential Outcomes Using Data Tables | 00:08:00 | ||
| Determine Potential Outcomes Using Scenarios | 00:09:00 | ||
| Navbar Placement | 00:04:00 | ||
| Forecasting Data Trends | 00:05:00 | ||
| Topic 05: Business Analystics for Beginners Using SASS | |||
| Section 01: Introduction | |||
| SAS Introduction | 00:07:00 | ||
| Introduction to SAS Program | 00:05:00 | ||
| Section 02: SAS Dataset | |||
| Read SAS Dataset | 00:09:00 | ||
| Practice Read Dataset | 00:08:00 | ||
| Practical Example on Read Dataset | 00:02:00 | ||
| Introduction to SAS Dataset | 00:12:00 | ||
| SAS Dataset Practical Example | 00:07:00 | ||
| SAS Dataset Practical Program | 00:06:00 | ||
| DateValue | 00:03:00 | ||
| SAS Formats Part 1 | 00:13:00 | ||
| SAS Formats Part 2 | 00:09:00 | ||
| Reading Excel Worksheets | 00:05:00 | ||
| Reading Excel Worksheet Example | 00:11:00 | ||
| Date Format Example | 00:06:00 | ||
| Section 03: Raw Data File Standard And Example | |||
| Raw Data File Standard Part 1 | 00:09:00 | ||
| Raw Data File Standard Part 2 | 00:08:00 | ||
| Raw Data File Standard Example | 00:06:00 | ||
| Section 04: Raw Data File Non Standard | |||
| Raw Data File Non Standard | 00:07:00 | ||
| Raw Data File Non Standard Example | 00:06:00 | ||
| Length Statement | 00:02:00 | ||
| Compilation Execution | 00:04:00 | ||
| Heading | 00:01:00 | ||
| Dataerrors | 00:05:00 | ||
| Data Errorsz Example | 00:03:00 | ||
| Validate Data Procfreq | 00:05:00 | ||
| Validate Data Procpront | 00:07:00 | ||
| Validate Data Peocmeans | 00:05:00 | ||
| Dat Constant | 00:07:00 | ||
| Assignment Statement | 00:09:00 | ||
| If Then Statement | 00:09:00 | ||
| If Then Do End Statement | 00:09:00 | ||
| Diff Where and If Statement | 00:02:00 | ||
| Keep Drop | 00:08:00 | ||
| Keep Drop Example | 00:04:00 | ||
| Section 05: Append | |||
| Append | 00:09:00 | ||
| Append Examples part 1 | 00:09:00 | ||
| Append Examples part 2 | 00:07:00 | ||
| Concatenate | 00:12:00 | ||
| Merge | 00:06:00 | ||
| Merge One to One | 00:07:00 | ||
| Merge One to Many | 00:04:00 | ||
| Merge Non Match | 00:04:00 | ||
| Section 06: Option Statements | |||
| Global Statements | 00:09:00 | ||
| Global Statements Examples Part 1 | 00:08:00 | ||
| Global Statements Examples Part 2 | 00:06:00 | ||
| Section 07: Title n Foot Note | |||
| Title n Foot Note | 00:05:00 | ||
| Title n Foot Note Example | 00:08:00 | ||
| By Statement | 00:08:00 | ||
| Multiple Where Stament | 00:03:00 | ||
| Section 08: ODS statements | |||
| ODS | 00:07:00 | ||
| ODS Example | 00:04:00 | ||
| Section 09: Date Functions | |||
| Sas Date Function | 00:10:00 | ||
| Sas Date Function Example | 00:08:00 | ||
| Sas Functions Part 1 | 00:10:00 | ||
| Sas Functions Part 2 | 00:08:00 | ||
| Sas Functions | 00:07:00 | ||
| Sas Functions Example Part 1 | 00:07:00 | ||
| Sas Functions Example Part 2 | 00:09:00 | ||
| Section 10: Multiple SAS datasets | |||
| Multiple SAS Datasets Part 1 | 00:05:00 | ||
| Multiple SAS Datasets Part 2 | 00:02:00 | ||
| Multiple SAS Datasets Example | 00:10:00 | ||
| Section 11: Select Group | |||
| Select Group | 00:09:00 | ||
| Select Group Example | 00:08:00 | ||
| Section 12: Do Loop | |||
| Do Loop Part 1 | 00:07:00 | ||
| Do Loop Part 2 | 00:06:00 | ||
| Do Loop Example | 00:07:00 | ||
| Section 13: Array | |||
| Array Part 1 | 00:05:00 | ||
| Array Part 2 | 00:08:00 | ||
| Array DoLoop | 00:06:00 | ||
| ArrayTemp | 00:05:00 | ||
| Array Example | 00:10:00 | ||
| Sas Statement Part 1 | 00:04:00 | ||
| Sas Statement Part 2 | 00:05:00 | ||
| Topic 06: Supply Chain Management for Different Retail Formats | |||
| Supply Chain Management for Different Retail Formats | |||
| Lesson 01: Introduction Retail Customer Service Customer Service Mix | 00:08:00 | ||
| Lesson 02: Customer Service Pyramid Customer Service over Retail Life cycle | 00:07:00 | ||
| Lesson 03: Ways to improve Customer Service for a Retailer | 00:09:00 | ||
| Lesson 04: Order Management Process Concept of Perfect Order | 00:06:00 | ||
| Lesson 05: Multi Channel Retailing | 00:09:00 | ||
| Lesson 06: Retail Returns Reverse Logistics | 00:08:00 | ||
| Lesson 07: Reverse Logistics process | 00:11:00 | ||
| Lesson 08: Retail Loyalty Programmes | 00:08:00 | ||
| Lesson 09: Retail kiosk advanced payment technologies conclusion | 00:09:00 | ||
| Topic 07: Customer Analytics Training | |||
| Section 01: Basics Of Customer Analytics And Customer Life Cycle | |||
| What Is Customer Analytics | 00:04:00 | ||
| Customer Life Cycle | 00:04:00 | ||
| Section 02: Customer Onboarding | |||
| Customer Onboarding When Whom | 00:01:00 | ||
| Customer Onboarding Process For A Typical Bank | 00:04:00 | ||
| Section 03: Customer Activation | |||
| What Is Activation And Why Is It Necessary | 00:01:00 | ||
| The Importance Of Customer Activation | 00:03:00 | ||
| Section 04: Cross Selling | |||
| What Is Cross Sell And Why Cross Sell | 00:03:00 | ||
| How Do We Cross Sell Effectively | 00:06:00 | ||
| Upgrade Upsell | 00:06:00 | ||
| Section 05: Campaign Life Cycle | |||
| Campaign Life Cycle Transition To Lead Management | 00:04:00 | ||
| Stages Of Campaign | 00:04:00 | ||
| Campaign Execution | 00:03:00 | ||
| Campaign Channels | 00:07:00 | ||
| Campaign Assessment | 00:05:00 | ||
| Section 06: Conclusion | |||
| Conclusion | 00:08:00 | ||
| Topic 08: Fundamentals of Marketing Analytics | |||
| Section 01: Introduction To Marketing Analytics Overview | |||
| Introduction | 00:02:00 | ||
| What Is Marketing | 00:04:00 | ||
| Why Do We Need Marketing | 00:08:00 | ||
| Section 02: Basic Concepts In Marketing Analytics Overview | |||
| What To Market | 00:03:00 | ||
| Whom And When To Market | 00:06:00 | ||
| How Analytics Drives Marketing Strategies | 00:08:00 | ||
| Acquisition To Retention | 00:08:00 | ||
| Customer Profitability To Contact Strategy | 00:06:00 | ||
| Campaign Analytic | 00:12:00 | ||
| Topic 09: Supply Chain Masterclass in Retail | |||
| Supply Chain Masterclass in Retail | |||
| Lesson 01: Retail: An Introduction | 00:18:00 | ||
| Lesson 02: Retail India: A Case Study | 00:15:00 | ||
| Lesson 03: Retail Location: An Advantage | 00:17:00 | ||
| Lesson 04: Retailing: An Overview | 00:03:00 | ||
| Lesson 05: Evolution of Indian Retail | 00:12:00 | ||
| Lesson 06: Indian Retail Key Enablers | 00:08:00 | ||
| Lesson 07: Supply Chain Management for Retailing A challenge for Retailers | 00:10:00 | ||
| Lesson 08: Porters Value Chain | 00:13:00 | ||
| Lesson 09: Characteristics of an Efficient Supply Chain | 00:09:00 | ||
| Lesson 10: Supply Chain Components | 00:06:00 | ||
| Lesson 11: Macro Process In SCM | 00:10:00 | ||
| Lesson 12: Stages In SCM | 00:11:00 | ||
| Lesson 13: SCM Issues | 00:09:00 | ||
| Lesson 14: Push Based SCM | 00:12:00 | ||
| Lesson 15: Pull Based SCM | 00:06:00 | ||
| Conclusion | 00:06:00 | ||
| Topic 10: Business Productivity Training | |||
| Introduction | |||
| Prof Paul Course Intro | 00:03:00 | ||
| Productivity Training | |||
| Productivity – Part 1 | 00:12:00 | ||
| Productivity – Part 2 | 00:12:00 | ||
| Productivity – Part 3 | 00:13:00 | ||
| Teamwork Training | |||
| Project Management – Part 1 | 00:15:00 | ||
| Project Management – Part 2 | 00:17:00 | ||
| Teamwork Training | |||
| Teamwork – Part 1 | 00:12:00 | ||
| Teamwork – Part 2 | 00:12:00 | ||
| Teamwork – Part 3 | 00:13:00 | ||
| Communication Training | |||
| Communication – Part 1 | 00:17:00 | ||
| Communication – Part 2 | 00:18:00 | ||
| Topic 11: Dealing With uncertainty: Make Budgets and Forecasts | |||
| Dealing With uncertainty: Make Budgets and Forecasts | |||
| Introduction to the Course | 00:01:00 | ||
| Course Curriculum | 00:02:00 | ||
| Why do We do Budgeting? | 00:06:00 | ||
| Paper Exercise or Something Useful? | 00:06:00 | ||
| Two Key Budgets and What They Contain | 00:05:00 | ||
| Suggestive Process of Budgeting | 00:05:00 | ||
| Pre-Requirements of Budgeting | 00:04:00 | ||
| Three Key Components of Budgets | 00:09:00 | ||
| Practical Process of Budgeting and Forecasting | 00:10:00 | ||
| Basics of Revenue Budgeting | 00:05:00 | ||
| Revenue Budget – Information Needed | 00:04:00 | ||
| Revenue Budget – Practical Example | 00:04:00 | ||
| Estimating Overall Impact of Revenue | 00:02:00 | ||
| Cost and Expenses Budget – Information Needed | 00:08:00 | ||
| Labour Cost Budgeting | 00:05:00 | ||
| Other Expenses Budgeting Process | 00:03:00 | ||
| Capital Expenditure Budgeting | 00:05:00 | ||
| Qualitative Aspects of Budgeting | 00:04:00 | ||
| Marketing Budget | 00:04:00 | ||
| How to Make Budgets and Forecasts | 01:52:00 | ||
| Introduction to Budgeting and Forecasting During Uncertainty | 00:03:00 | ||
| Causes of Uncertainty | 00:04:00 | ||
| Change the Purpose of Budgeting | 00:04:00 | ||
| Budgeting for Strategic Success | 00:04:00 | ||
| Key Aspects of Strategic Budgeting | 00:05:00 | ||
| How Often We should do Budgeting | 00:06:00 | ||
| 5 Principles of Business Planning During Uncertainty | 00:05:00 | ||
| Alternative Options for Annual Budget | 00:07:00 | ||
| Topic 12: Cashflow Management and Forecasting | |||
| Module 01 | |||
| Introduction | 00:03:00 | ||
| What is Cashflow? | 00:04:00 | ||
| Forecasting | 00:07:00 | ||
| Planning and Management | 00:05:00 | ||
| Planning Part 2 | 00:12:00 | ||
| Module 02 | |||
| Where it can go Wrong | 00:09:00 | ||
| Personal Cashflow Analysis | 00:05:00 | ||
| Personal Cashflow Analysis my Numbers Story | 00:06:00 | ||
| Debt | 00:10:00 | ||
| Conclusion | 00:04:00 | ||
| Topic 13: Raising Money & Valuations | |||
| Raising Money & Valuations | |||
| Traditional Capital Raising | 00:07:00 | ||
| Startup Financing and Stages | 00:15:00 | ||
| Early Stage Financing – Own capital, crowdfunding and leasing | 00:13:00 | ||
| Early Stage FInancing – Angel Investing, VC Capital | 00:17:00 | ||
| Why we need valuation and is it objective | 00:07:00 | ||
| Business Valuation Concepts | 00:07:00 | ||
| process of valuations and factors that affect valuations | 00:11:00 | ||
| Valuation Methods and Market Approach | 00:13:00 | ||
| Income Valuation Approach | 00:09:00 | ||
| Discounting rate and how we determine it | 00:13:00 | ||
| Other Methods of valuation and Conclusion | 00:18:00 | ||
| Assignment | |||
| Assignment – Raising Money & Valuations | 00:00:00 | ||
| Topic 14: Cost Control & Project Scheduling | |||
| Chapter 1 | |||
| Monitoring and Controlling Fundamentals | 00:45:00 | ||
| Chapter 2 | |||
| Schedule Control | 00:55:00 | ||
| Chapter 3 | |||
| Cost Control | 00:43:00 | ||
| Assignment | |||
| Assignment – Cost Control & Project Scheduling | 00:00:00 | ||
| Topic 15: Mini MBA | |||
| Module 01: Appreciating the Mini MBA | |||
| Appreciating the Mini MBA | 00:10:00 | ||
| Module 02: The Foundations of Business | |||
| The Foundations of Business | 00:10:00 | ||
| Module 03: Understanding Business Law | |||
| Understanding Business Law | 00:00:00 | ||
| Module 04: Competitive Business Strategies | |||
| Competitive Business Strategies | 00:10:00 | ||
| Module 05: Departments in Business | |||
| Departments in Business | 00:10:00 | ||
| Module 06: Planning the Right Strategy for Business | |||
| Planning the Right Strategy for Business | 00:05:00 | ||
| Module 07: Managing Human Resources in Business | |||
| Managing Human Resources in Business | 00:10:00 | ||
| Module 08: Economics Influences on Business | |||
| Economics Influences on Business | 00:10:00 | ||
| Module 09: Business Accounting | |||
| Business Accounting | 00:10:00 | ||
| Module 10: Finance in Business | |||
| Finance in Business | 00:10:00 | ||
| Module 11: Business Marketing | |||
| Business Marketing | 00:10:00 | ||
| Module 12: Advertising and Promotion | |||
| Advertising and Promotion | 00:10:00 | ||
| Module 13: The Art of Negotiation | |||
| The Art of Negotiation | 00:05:00 | ||
| Module 14: Communication and Presentation | |||
| Communication and Presentation | 00:05:00 | ||
| Module 15: Organisational Behaviour in Business | |||
| Organisational Behaviour in Business | 00:10:00 | ||
| Module 16: Building Teams in Business | |||
| Building Teams in Business | 00:05:00 | ||
| Module 17: Business Leadership | |||
| Business Leadership | 00:05:00 | ||
| Module 18: Operations Management | |||
| Operations Management | 00:15:00 | ||
| Module 19: The Importance of Risk Management | |||
| The Importance of Risk Management | 00:10:00 | ||
| Module 20: Project Management | |||
| Project Management | 00:05:00 | ||
| Module 21: Quantitative Research and Analysis | |||
| Quantitative Research and Analysis | 00:05:00 | ||
| Module 22: Qualitative Research and Analysis | |||
| Qualitative Research and Analysis | 00:05:00 | ||
| Module 23: Becoming an Entrepreneur | |||
| Becoming an Entrepreneur | 00:05:00 | ||
| Module 24: Corporate Social Responsibility (CSR) | |||
| Corporate Social Responsibility (CSR) | 00:10:00 | ||
| Module 25: Avoiding Management Mistakes | |||
| Avoiding Management Mistakes | 00:05:00 | ||
| Topic 16: Business Accounting Training | |||
| Professional Bookkeeper Introduction | |||
| Professional Bookkeeper | 00:09:00 | ||
| Introduction to Accounting and Business | |||
| Defining a Business | 00:07:00 | ||
| Ethics in Accounting | 00:05:00 | ||
| Generally Accepted Accounting Principles (GAAP) | 00:10:00 | ||
| The Accounting Equation | |||
| The Accounting Equation | 00:07:00 | ||
| Transactions | 00:11:00 | ||
| Analyzing Transactions | |||
| The Accounting Equation and Transactions | 00:16:00 | ||
| Double-Entry System | 00:12:00 | ||
| Transactions – Journalizing | 00:17:00 | ||
| Entering Information - Posting Entries | |||
| Posting Entries | 00:10:00 | ||
| The Trial Balance | 00:10:00 | ||
| Finding Errors Using Horizontal Analysis | 00:09:00 | ||
| Horizontal Trend : Balance Sheet | 00:21:00 | ||
| Horizontal Trend: Income Statement | 00:36:00 | ||
| Adjusting Process | |||
| The Purpose of the Adjusting Process | 00:15:00 | ||
| Adjusting Entries | |||
| Adjusting Entries – Prepaid Expenses | 00:13:00 | ||
| Adjusting Entries – Accrued Revenues | 00:10:00 | ||
| Adjusting Entries – Depreciation Expense | 00:09:00 | ||
| Adjustment Summary | |||
| Adjustment Summary – Review | 00:13:00 | ||
| Vertical Analysis | 00:33:00 | ||
| Preparing a Worksheet | |||
| Preparing a Worksheet | 00:06:00 | ||
| Financial Statements | |||
| The Income Statement | 00:11:00 | ||
| Financial Statements – Definitions | 00:12:00 | ||
| Completing the Accounting Cycle | |||
| Temporary vs. Permanent Accounts | 00:19:00 | ||
| The Accounting Cycle Illustrated | |||
| Accounting Cycle Illustrated – Steps 1-5 | 00:11:00 | ||
| Accounting Cycle Illustrated – Steps 6-1 | 00:12:00 | ||
| Fiscal Year | |||
| Fiscal Year | 00:09:00 | ||
| Spreadsheet Exercise | |||
| Spreadsheet Exercise – Steps 1-4 | 00:11:00 | ||
| Spreadsheet Exercise – Steps 5-7 | 00:37:00 | ||
| Mock Exam | |||
| Mock Exam- Business Accounting Training | 00:20:00 | ||
| Final Exam | |||
| Final Exam- Business Accounting Training | 00:20:00 | ||
| Topic 17: Financial Analysis: Finance Reports | |||
| Financial Analysis: Reading Financial Statements like a Pro | |||
| Welcome to the Course! Get the Overview of What You’ll Learn | 00:04:00 | ||
| What is a 10-K? | 00:07:00 | ||
| Evaluating Profitability by Analyzing the Income Statement | 00:19:00 | ||
| Evaluating Operations: Tying Operating Metrics to Financial Results | 00:07:00 | ||
| Evaluating Financial Strength: Balance Sheet Analysis | 00:14:00 | ||
| Evaluating Cash Flow Generation | 00:09:00 | ||
| Performing Investment Analysis | 00:15:00 | ||
| Assignment | |||
| Assignment – Financial Analysis: Finance Reports | 00:00:00 | ||
| Topic 18: Presenting Financial Information | |||
| Presenting Financial Information | |||
| Module 01: Presenting Financial Information | 00:06:00 | ||
| Module 02: The Hierarchy of Performance Indicators | 00:05:00 | ||
| Module 03: The Principle of Effective Reports | 00:06:00 | ||
| Module 04: Guidelines for Designing Management Reports | 00:05:00 | ||
| Module 05: Methods of Presenting Performance Data | 00:04:00 | ||
| Module 06: The Control Chart: Highlighting the Variation in the Data | 00:07:00 | ||
| Module 07: The Pareto Chart: Highlighting Priorities | 00:01:00 | ||
| Module 08: Exercise: The Control Chart | 00:05:00 | ||
| Module 09: An Example Management Report | 00:03:00 | ||
| Module 10: Interpreting Performance Data | 00:04:00 | ||
| Module 11: Supporting Colleagues by Giving Feedback | 00:05:00 | ||
| Module 12: Data Visualisation Part 01 | 00:09:00 | ||
| Module 13: Data Visualisation Part 02 | 00:07:00 | ||
| Module 14: Data Visualisation Part 03 | 00:09:00 | ||
| Module 15: Data Visualisation Part 04 | 00:04:00 | ||
| Module 16: Final Thoughts on Presenting Financial Information | 00:04:00 | ||
| Assignment | |||
| Assignment – Presenting Financial Information | 00:00:00 | ||
| Topic 19: Finance: Financial Risk Management | |||
| Finance: Financial Risk Management | |||
| Lesson 01: Introduction | 00:01:00 | ||
| Lesson 02: Derivatives-Concepts and types of derivatives | 00:09:00 | ||
| Lesson 03: Future contracts, understanding future concepts deviating risks | 00:07:00 | ||
| Lesson 04: Settlement in future markets | 00:13:00 | ||
| Lesson 05: Option contracts, call option, Analysis of Holder and Writer in call option | 00:16:00 | ||
| Lesson 06: Put option, Analysis of Holder and writer in put option | 00:11:00 | ||
| Lesson 07: Types of options in the expiration date | 00:09:00 | ||
| Topic 20: Financial Modelling Course – Learn Online | |||
| Financial Modelling | |||
| Welcome to the Course! Get the Overview of What You’ll Learn | 00:04:00 | ||
| Planning your Financial Model | 00:09:00 | ||
| Building a Model Template | 00:12:00 | ||
| Projecting the Income Statement | 00:13:00 | ||
| Projecting the Balance Sheet | 00:17:00 | ||
| Projecting Cash Flows | 00:14:00 | ||
| Advanced Financial Modeling | 00:14:00 | ||
| BONUS LESSON: Top 5 Excel Features for Financial Modellers | 00:08:00 | ||

