【2022年】十大Excel 建模課程熱門排行推薦與優惠精選!

 

本文章推薦「Marketing Analytics: Forecasting Models with Excel」、「BeyondFormulas: Complete MS Excel Techniques & Modeling」、「All Weather Investing Via Quantitative Modeling In Excel」等相關Excel 建模線上課程,讓您滿足學習的慾望。

你是否想透過線上學習得到更多的技能,增加自己的技能樹?現在是學生的您,透過線上學習可以將更多專業知識用在課業學習上更加強所學。還是您是朝九晚五的上班族,尋找可以為工作上帶來更上一層樓的技能?或您是因為興趣或想培養其他興趣?

線上課程不受地理位置影響,不受時間早晚影響,老師來自世界各地,也不受學習程度影響的特色,讓您無時無刻想學都可以,想多看幾次增加熟悉度也可以。不同領域的老師將針對不同主題滿足您的學習目的,推薦的課程項目會陸續更新,絕對提供您最熱門人氣高的線上課程。

  • 線上課程老師來自於全球,文章推薦的熱門課程除了繁中課程以外還會有機會看到簡中和英文課程,可以針對自己喜好挑選。
  • 呈現的價錢會因為一些活動而有折扣,但折扣有可能一段時間後結束而調整回原價,最終價錢煩請到課程頁面進行確認。





Excel 建模課程總覽

為了節省您的時間,本列表整理每個課程精要,讓您可以快速瀏覽這文章所提供的課程是否是您所需要的,點選您有興趣課程的「課程名稱」或「課程圖示」可以進一步跳到文章所屬課程的介紹區塊瞭解更多資訊。

課程名稱Marketing Analytics: Forecasting Models with ExcelNumerical Methods in EXCEL/VBA PROGRAMINGBeyondFormulas: Complete MS Excel Techniques & ModelingBuild Excel Models using Advanced Formulas, VBA, Power QueryAll Weather Investing Via Quantitative Modeling In ExcelStock Sector Investing Via Quantitative Modeling In ExcelDefensive Stock Investing Via Quantitative Modeling In ExcelReal Estate Development in Excel (Includes Template)Create a 3-Statement Budget Model in ExcelDecision Modeling and Risk Analysis with Excel
課程圖示
1

Marketing Analytics: Forecasting Models with Excel

2

Numerical Methods in EXCEL/VBA PROGRAMING

3

BeyondFormulas: Complete MS Excel Techniques & Modeling

4

Build Excel Models using Advanced Formulas, VBA, Power Query

5

All Weather Investing Via Quantitative Modeling In Excel

6

Stock Sector Investing Via Quantitative Modeling In Excel

7

Defensive Stock Investing Via Quantitative Modeling In Excel

8

Real Estate Development in Excel (Includes Template)

9

Create a 3-Statement Budget Model in Excel

10

Decision Modeling and Risk Analysis with Excel

課程原價NT$ 990NT$ 2,990NT$ 590NT$ 590NT$ 2,690NT$ 2,490NT$ 2,690NT$ 990
課程售價NT$ 370NT$ 390NT$ 370NT$ 370NT$ 6,590NT$ 6,590NT$ 370NT$ 370NT$ 370
課程評價(人數)4.4 分(1,190 個評分)4.1 分(71 個評分)4.5 分(264 個評分)4.3 分(39 個評分)4.7 分(107 個評分)4.5 分(92 個評分)4.7 分(66 個評分)4.1 分(68 個評分)4.5 分(60 個評分)4.7 分(39 個評分)
課程時長7 小時9.5 小時8.5 小時6 小時8.5 小時8.5 小時7 小時1 小時5.5 小時6 小時
學生人數108,594 人5,474 人2,329 人722 人650 人647 人480 人471 人284 人189 人
課程特色Master Marketing Analytics| Forecasting and Time Series analysis | Sales Forecasting| Build Forecasting models in ExcelLearn the workings of the most common numerical methods and a step by step process on how to program each of themLearn all crucial Microsoft Excel Techniques & How to apply them to real-world business modeling problemsDesign Robust Excel Models for Accounting and Reporting, learn to Build Automated Dashboards using Power Query and VBAMaster The Principles of A Resilient Investing Strategy using Stocks & Bonds ETF called Risk Parity Used In Hedge FundsEnhance investing by selecting the right stock sectors and using a hedge to navigate stock market downturnsMaster The Principles of A Defensive Stock Investing or Trading Strategy called Trend Following Used In Hedge FundsLearn Industry Standard Analysis and Valuation Techniques For Real Estate DevelopmentLearn how to build professional 3-statement budget models in ExcelDecision making using sensitivity analysis, decision tree, utility theory, Bayesian statistics, Monte Carlo simulation.
連結UdemyUdemyUdemyUdemyUdemyUdemyUdemyUdemyUdemyUdemy



Excel 建模課程介紹

推薦的課程以倒序的方式呈現,越往下查看會看到越熱門的,期望您能找到滿意的學習主題!

10

Decision Modeling and Risk Analysis with Excel

Decision making using sensitivity analysis, decision tree, utility theory, Bayesian statistics, Monte Carlo simulation.
NT$ 990
NT$ 370

點擊看Udemy

課程老師Gancheng Sun
課程評價4.7 分(39 個評分)
課程時長6 小時
學生人數189 人

課程介紹

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

關注這課程的人也購買了這些…

9

Create a 3-Statement Budget Model in Excel

Learn how to build professional 3-statement budget models in Excel
NT$ 2,690
NT$ 370

點擊看Udemy

課程老師Dobromir Dikov
課程評價4.5 分(60 個評分)
課程時長5.5 小時
學生人數284 人

課程介紹

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

關注這課程的人也購買了這些…



8

Real Estate Development in Excel (Includes Template)

Learn Industry Standard Analysis and Valuation Techniques For Real Estate Development
NT$ 2,490
NT$ 370

點擊看Udemy

課程老師Daniel Davis
課程評價4.1 分(68 個評分)
課程時長1 小時
學生人數471 人

課程介紹

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

關注這課程的人也購買了這些…

7

Defensive Stock Investing Via Quantitative Modeling In Excel

Master The Principles of A Defensive Stock Investing or Trading Strategy called Trend Following Used In Hedge Funds
NT$ 2,690
NT$ 6,590

點擊看Udemy

課程老師AllQuant .
課程評價4.7 分(66 個評分)
課程時長7 小時
學生人數480 人

課程介紹

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

關注這課程的人也購買了這些…



6

Stock Sector Investing Via Quantitative Modeling In Excel

Enhance investing by selecting the right stock sectors and using a hedge to navigate stock market downturns
NT$ 6,590

點擊看Udemy

課程老師AllQuant .
課程評價4.5 分(92 個評分)
課程時長8.5 小時
學生人數647 人

課程介紹

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

關注這課程的人也購買了這些…

5

All Weather Investing Via Quantitative Modeling In Excel

Master The Principles of A Resilient Investing Strategy using Stocks & Bonds ETF called Risk Parity Used In Hedge Funds

點擊看Udemy

課程老師AllQuant .
課程評價4.7 分(107 個評分)
課程時長8.5 小時
學生人數650 人

課程介紹

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

關注這課程的人也購買了這些…



4

Build Excel Models using Advanced Formulas, VBA, Power Query

Design Robust Excel Models for Accounting and Reporting, learn to Build Automated Dashboards using Power Query and VBA
NT$ 590
NT$ 370

點擊看Udemy

課程老師Prashant Panchal, ACA
課程評價4.3 分(39 個評分)
課程時長6 小時
學生人數722 人

課程介紹

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)

關注這課程的人也購買了這些…

3

BeyondFormulas: Complete MS Excel Techniques & Modeling

Learn all crucial Microsoft Excel Techniques & How to apply them to real-world business modeling problems
NT$ 590
NT$ 370

點擊看Udemy

課程老師Brandon Trew
課程評價4.5 分(264 個評分)
課程時長8.5 小時
學生人數2,329 人

課程介紹

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

關注這課程的人也購買了這些…



2

Numerical Methods in EXCEL/VBA PROGRAMING

Learn the workings of the most common numerical methods and a step by step process on how to program each of them
NT$ 2,990
NT$ 390

點擊看Udemy

課程老師Shams El-Din El-Fouly
課程評價4.1 分(71 個評分)
課程時長9.5 小時
學生人數5,474 人

課程介紹

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

關注這課程的人也購買了這些…

1

Marketing Analytics: Forecasting Models with Excel

Master Marketing Analytics| Forecasting and Time Series analysis | Sales Forecasting| Build Forecasting models in Excel
NT$ 990
NT$ 370

點擊看Udemy

課程老師Start-Tech Academy
課程評價4.4 分(1,190 個評分)
課程時長7 小時
學生人數108,594 人

課程介紹

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

關注這課程的人也購買了這些…



Excel 建模課程總覽

看完了一連串課程的介紹後,你是否還想要再一次進行課程總比較呢?

課程名稱Marketing Analytics: Forecasting Models with ExcelNumerical Methods in EXCEL/VBA PROGRAMINGBeyondFormulas: Complete MS Excel Techniques & ModelingBuild Excel Models using Advanced Formulas, VBA, Power QueryAll Weather Investing Via Quantitative Modeling In ExcelStock Sector Investing Via Quantitative Modeling In ExcelDefensive Stock Investing Via Quantitative Modeling In ExcelReal Estate Development in Excel (Includes Template)Create a 3-Statement Budget Model in ExcelDecision Modeling and Risk Analysis with Excel
課程圖示
1

Marketing Analytics: Forecasting Models with Excel

2

Numerical Methods in EXCEL/VBA PROGRAMING

3

BeyondFormulas: Complete MS Excel Techniques & Modeling

4

Build Excel Models using Advanced Formulas, VBA, Power Query

5

All Weather Investing Via Quantitative Modeling In Excel

6

Stock Sector Investing Via Quantitative Modeling In Excel

7

Defensive Stock Investing Via Quantitative Modeling In Excel

8

Real Estate Development in Excel (Includes Template)

9

Create a 3-Statement Budget Model in Excel

10

Decision Modeling and Risk Analysis with Excel

課程原價NT$ 990NT$ 2,990NT$ 590NT$ 590NT$ 2,690NT$ 2,490NT$ 2,690NT$ 990
課程售價NT$ 370NT$ 390NT$ 370NT$ 370NT$ 6,590NT$ 6,590NT$ 370NT$ 370NT$ 370
課程評價(人數)4.4 分(1,190 個評分)4.1 分(71 個評分)4.5 分(264 個評分)4.3 分(39 個評分)4.7 分(107 個評分)4.5 分(92 個評分)4.7 分(66 個評分)4.1 分(68 個評分)4.5 分(60 個評分)4.7 分(39 個評分)
課程時長7 小時9.5 小時8.5 小時6 小時8.5 小時8.5 小時7 小時1 小時5.5 小時6 小時
學生人數108,594 人5,474 人2,329 人722 人650 人647 人480 人471 人284 人189 人
課程特色Master Marketing Analytics| Forecasting and Time Series analysis | Sales Forecasting| Build Forecasting models in ExcelLearn the workings of the most common numerical methods and a step by step process on how to program each of themLearn all crucial Microsoft Excel Techniques & How to apply them to real-world business modeling problemsDesign Robust Excel Models for Accounting and Reporting, learn to Build Automated Dashboards using Power Query and VBAMaster The Principles of A Resilient Investing Strategy using Stocks & Bonds ETF called Risk Parity Used In Hedge FundsEnhance investing by selecting the right stock sectors and using a hedge to navigate stock market downturnsMaster The Principles of A Defensive Stock Investing or Trading Strategy called Trend Following Used In Hedge FundsLearn Industry Standard Analysis and Valuation Techniques For Real Estate DevelopmentLearn how to build professional 3-statement budget models in ExcelDecision making using sensitivity analysis, decision tree, utility theory, Bayesian statistics, Monte Carlo simulation.
連結UdemyUdemyUdemyUdemyUdemyUdemyUdemyUdemyUdemyUdemy



從老師查找更多課程

以上推薦的課程還沒挑到自己有興趣的嗎?
還是您有熱衷某個老師開的課程呢?
本頁除了提供Excel 建模的課程以外,也列出這些課程所屬的老師的主要資訊頁,您可以從下列選單中了解更多相關介紹或看他們開的其他課程,期望您最終能找到自己想學習的項目。



【2022年】十大Excel 建模課程熱門排行推薦與優惠精選!

參考其他行銷分析與自動化線上課程

除了本文介紹的課程種類以外,想要瞭解行銷分析與自動化領域還有哪些不同類型的課程值得一探究竟嗎?讓您可以從不同面向更紮實的學習,點擊參考以下其他熱門主題文章。絕對提供您最優惠人氣滿檔的課程,歡迎繼續延伸閱讀。