課程介紹

You’re looking for a complete course on understanding Forecasting models and forecasting analytics to drive business decisions involving production schedules, inventory management, manpower planning, demand forecasting, and many other parts of the bu

…[更多細節]

哪些人適合這堂課？

• Anyone curious to master Forecasting Models from beginner to advanced

學習目標

• Become proficient in using powerful tools such as excel solver to create forecasting models
• Learn about two of the most used forecasting tools: simple linear and simple multiple regression
• Learn how to estimate the trend and seasonal aspects of sales
• Learn to generate forecasts using the Ratio to Moving Average forecasting method
• Forecast using dynamic trend and seasonal index using Winter’s method
• Learn forecasting for new product launch with little or no history about sales of a product
• Learn how to use S Curves to Forecast Sales of a New Product
• Learn how to forecast product sales even before the product comes to market using popular the Bass diffusion model
• Indepth knowledge of data collection and data preprocessing for Linear Regression problem
• Understand how to interpret the result of Linear Regression model and translate them into actionable insight

課程介紹

Numerical modeling is a very powerful branch of mathematics. It is capable to solve very complex problems using very simple techniques.

It is a branch that can differentiate and integral without the need to use any of the sometimes complex different

…[更多細節]

哪些人適合這堂課？

• Students enrolled in their first numerical Methods Class and interested in additional mentoring
• Students interested to learn the most common Numerical Methods Techniques used in science and engineering
• Students interested in understanding how to program and create Numerical Modeling Techniques from scratch
• Students interested in Learning VBA Programming Language

學習目標

• Program using VBA Programming Language
• Approximate functions using Taylor series expansions
• Approximate derivatives using conventional and high accuracy formulas
• Approximate integrals using Trapezoidal rule, Simpson’s 1/3 rule and Romberg integration
• Find roots of equations using bisection, False position, newton Raphson and secant methods
• Find analytically the optimum min and max of a function
• Solve Ordinary differential Equations using Runge Kutta Methods (i.e. Euler, Heun’s, Midpoint and Ralston Methods in addition to fourth order Runge Kutta Method
• Find numerically the optimum min and max using Golden section Search method, newton Raphson Technique and finally the gradient decent/ascent method
• Solve Systems of Equations using Gauss elimination, Gauss Jordan and LU Decomposition and generate inverse matrices
• Perform curve fitting using regression analysis including linear and polynomial regression in addition to linearization for fitting more complex functions
• Perform curve fitting using Cubic Spline

課程介紹

*** This training teaches you:
1) All of the crucial excel techniques you should care about: including model structure, data handling, smart lookups, aggregation & basic statistics, tables, pivot tables, charts, VBA macros & custom formulas, and many

…[更多細節]

哪些人適合這堂課？

• Students / graduates trying to get hired for analytical skills
• Consultants and corporate analysts looking to develop core skills
• Entrepreneurs needing to model their new businesses
• Experienced professionals trying to brush up on new tools

學習目標

• Take any business problem, and solve it using structured (consulting-like) problem solving tools
• Analyze data in excel using all of the most useful excel tools for real world data analysis
• Get around excel like a pro with an excel keyboard shortcut game
• Evaluate advanced scenarios and sensitivity analyses with your model in just a few steps

課程介紹

If you’re an accountant, analyst or business professional looking to take your Excel skills to the next level, this is the course you’ve been looking for!

This Course will teach you how to prepare efficient Excel model with advanced (powerful) fo

…[更多細節]

哪些人適合這堂課？

• Any one who wants to learn Advanced modeling techniques and Tricks in Microsoft Excel
• Accountants who wants to efficiently manage their Prepaid Expenses and Balance Sheet Reconciliations
• Non-Accounting professional/Entrepreneurs who wants to estimate impact of Prepaid Expenses on their investment and Profit and Loss over fixed term
• Analysts /Auditors who want to audit effectively for Prepaid Expenses
• Business Budgets and Forecast Activities where prepaid expenses are crucial part of Balance Sheet and Income Statements

學習目標

• Advanced Formulas and Functions to prepare Accounting Schedules (such as prepaid expenditure) and many other amorisation models
• How to leverage awesome data transformation tool called Power Query (Get & Transform)
• How to Manage Prepaid Expenses accounting professional way (or any other amortisation schedule)
• How to Forecast and Budget Prepaid Expenses and its impact on three Financial Statements
• Maintaining the utmost accuracy while closing month end books (Accountants) for Prepaid Expenditures
• Dynamic Data Visualization and Dashboard Preparation using Formulas and Functions
• Dynamic Dashboards and Data Visualization with Power Query (Next level Data modeling tricks)

課程介紹

WHAT YOU WILL GET IN THIS COURSE

Fully completed model file that you can use for live investing or improve on.

Over 8 hours of lectures developed by professionals with more than 30 years of joint experience in the asset management, hedge fund, and

…[更多細節]

哪些人適合這堂課？

• Anyone who is keen to learn a solid investment approach used by hedge fund professionals founded on math and common sense.
• Anyone who is interested in generating stable returns with lower risk over the long term.
• Anyone who is serious about taking charge of their investment.
• This is NOT for people expecting an active trading course or something that will make you a millionaire overnight.

學習目標

• Learn about quantitative Investing & how it is different from conventional methods of investing
• Master the science and art of diversification to build an all-weather portfolio that remains robust under harsh market conditions
• Know the pitfalls of buying and holding a pure stock portfolio
• Understand why traditional asset allocation methods such as 50/50 or 60/40 are not ideal
• Understand the concept of risk and how to look at investments from the perspective of risk
• Know the criteria to choose the right assets in portfolio construction
• Master an established quantitative method used in hedge funds called Risk Parity to allocate capital across different assets
• Understand how Risk Parity works and why it is adaptive to market conditions
• Know both the strengths and weaknesses in Risk Parity
• Use critical Excel lookup, logic, math and statistical functions required for modelling in this course.
• Understand the intuition, math and know how to implement financial concepts such as Returns, Correlation, Risk, Marginal Risk Contribution
• Know how to model a buy and hold portfolio
• Know what is rebalancing and how to model a portfolio with periodic rebalancing
• Know how to perform portfolio weights optimization
• Know what are the transaction costs involved and how to incorporate them into the model
• Understand the concept of leverage and how we can use it to boost our returns
• Learn how to incorporate leverage and borrowing costs into the model
• Learn the concept and math behind key investment performance metrics such as Sharpe Ratio
• Know how to operate the Risk Parity model

課程介紹

WHAT YOU WILL GET IN THIS COURSE

Fully completed model file that you can use for live investing or improve on.

Over 8 hours of lectures developed by professionals with more than 30 years of joint experience in the asset management, hedge fund, and

…[更多細節]

哪些人適合這堂課？

• Anyone who is keen to learn a solid investment approach used by hedge fund professionals founded on math and common sense.
• Anyone who is interested in generating stable returns with lower risk over the long term.
• Anyone who is serious about taking charge of their investment.
• This is NOT for people expecting an active trading course or something that will make you a millionaire overnight.

學習目標

• Learn about quantitative Investing & how it is different from conventional methods of investing
• Know the pitfalls of buying and holding a pure stock portfolio
• Know the different stocks sectors and their ETFs
• Understand the concept and rationale behind sector rotation
• Learn a quantitative approach to select the right sectors for investment
• Learn how the use of a dynamic hedge can improve the overall investment performance
• Know both the strengths and weaknesses of the Sector Rotation Strategy
• Use critical Excel lookup, logic, math and statistical functions required for modelling in this course.
• Understand the intuition, math and know how to implement financial concepts such as Returns, Correlation and Risk
• Learn the concept and math behind key investment performance metrics such as Sharpe Ratio
• Learn how to model a buy and hold portfolio
• Learn what is rebalancing and how to model a portfolio with periodic rebalancing
• Learn how to implement a sector scoring and ranking system
• Learn how to incorporate a dynamic hedge into the sector rotation strategy
• Know what are the transaction costs involved and how to incorporate them into the model
• Understand the concept of leverage and how we can use it to boost our returns
• Learn how to incorporate leverage and borrowing costs into the model
• Know how to operate the Sector Rotation Model

課程介紹

WHAT YOU WILL GET IN THIS COURSE

Fully completed model file that you can use for live investing or improve on.

Over 6 hours of lectures developed by professionals with more than 30 years of joint experience in the asset management, hedge fund, and

…[更多細節]

哪些人適合這堂課？

• Anyone who is keen to learn a solid investment approach used by hedge fund professionals founded on sound principles and common sense.
• Anyone who is interested in generating decent returns with moderate risk over the long term.
• Anyone who is serious about taking charge of their investment.
• This is NOT for people expecting an active trading course or something that will make you a millionaire overnight.

學習目標

• Learn about quantitative Investing & how it is different from conventional methods of investing
• Master the science and art of building a defensive stock portfolio that is resilient during bear markets
• Know the pitfalls of buying and holding a pure stock portfolio
• Know the criteria to choose the right stocks universe for trend following
• Master an established quantitative method used in hedge funds called Trend Following to trade stocks
• Understand how Trend Following works and why it is adaptive to market conditions
• Know both the strengths and weaknesses in Trend Following
• Use critical Excel lookup, logic, math and statistical functions required for modeling in this course
• Understand the intuition, math and know how to implement financial concepts such as Returns and Risk
• Know how to model a buy and hold portfolio
• Know what are the transaction costs involved and how to incorporate them into the model
• Understand the concept of leverage and how we can use it to boost our returns
• Learn how to incorporate leverage and borrowing costs into the model
• Learn the concept and math behind key investment performance metrics such as Sharpe Ratio
• Know how to operate the Trend Following model

課程介紹

This course will teach you how to financially model a multi-family real estate development project and comes with a downloadable, complete Excel model.  The model that comes with this course is plug and play with minimal work necessary to adapt it to

…[更多細節]

哪些人適合這堂課？

• Anyone looking to learn the finances behind real estate development.
• Anyone looking for a functional financial model they can use to impress future employers, or use for a RE development project
• Anyone trying to learn the financial terms and techniques of real estate development
• Anyone looking to grow their Excel skills

學習目標

• This course comes with a fully built, plug and play model which you can download and use to analyze any real estate project
• You will learn how to value a multi-family real estate project using industry standard techniques
• You will be able to impress current and future employers with your understanding of real estate finance

課程介紹

If you are currently working in an FP&A role, or anywhere between accounting and finance, there’s a high chance you’ll probably face the challenge of preparing a budget statement. It would be great if you are ready to tackle such a challenge with con

…[更多細節]

哪些人適合這堂課？

• Junior to Mid-Senior finance and accounting professionals, who are engaged in the budgeting process
• Business owners and entrepreneurs who want to understand how budgeting works in practice
• Managers in start-ups where no finance professionals are available
• Students in Finance and Economics majors

學習目標

• Know how to organize models in Excel
• Be able to budget the business performance
• Know how to model financial statements
• Understand how the financial statements are linked together
• Enhance your current Excel files
• Format spreadsheets in a professional way
• Know how to forecast sales and expenses
• Understand the key assumptions that drive a budget

課程介紹

We all have one thing in common – we don’t know what will happen tomorrow. Living together in this world full of uncertainties, some decisions are rather difficult to make:

I want to save some money for my future, but how should I allocate my invest

…[更多細節]

哪些人適合這堂課？

• Entrepreneurs who wants to grow their businesses
• People who want to learn more about Excel
• Anyone who wants to analyze the uncertainties before making decisions
• People who what to learn more about data analysis and modeling
• People who what to learn more about statistics

學習目標

• Excel
• Uncertainty Modeling
• Decision Analysis
• Data Analysis
• Goal Seek
• VLOOKUP
• Pivot Table
• Data Analysis Toolpak
• Solver
• Sensitivity Analysis
• Tornado Chart
• Treeplan
• Decision Tree
• Value of Information
• Monte Carlo Simulation
• XLRisk
• Utility Theory
• Utility Function
• Exponential Utility Function
• Statistics
• Central Limit Theorem
• Probability Distribution