邱竑明
    • Create new note
    • Create a note from template
      • Sharing URL Link copied
      • /edit
      • View mode
        • Edit mode
        • View mode
        • Book mode
        • Slide mode
        Edit mode View mode Book mode Slide mode
      • Customize slides
      • Note Permission
      • Read
        • Only me
        • Signed-in users
        • Everyone
        Only me Signed-in users Everyone
      • Write
        • Only me
        • Signed-in users
        • Everyone
        Only me Signed-in users Everyone
      • Engagement control Commenting, Suggest edit, Emoji Reply
    • Invite by email
      Invitee

      This note has no invitees

    • Publish Note

      Share your work with the world Congratulations! 🎉 Your note is out in the world Publish Note

      Your note will be visible on your profile and discoverable by anyone.
      Your note is now live.
      This note is visible on your profile and discoverable online.
      Everyone on the web can find and read all notes of this public team.
      See published notes
      Unpublish note
      Please check the box to agree to the Community Guidelines.
      View profile
    • Commenting
      Permission
      Disabled Forbidden Owners Signed-in users Everyone
    • Enable
    • Permission
      • Forbidden
      • Owners
      • Signed-in users
      • Everyone
    • Suggest edit
      Permission
      Disabled Forbidden Owners Signed-in users Everyone
    • Enable
    • Permission
      • Forbidden
      • Owners
      • Signed-in users
    • Emoji Reply
    • Enable
    • Versions and GitHub Sync
    • Note settings
    • Note Insights New
    • Engagement control
    • Make a copy
    • Transfer ownership
    • Delete this note
    • Save as template
    • Insert from template
    • Import from
      • Dropbox
      • Google Drive
      • Gist
      • Clipboard
    • Export to
      • Dropbox
      • Google Drive
      • Gist
    • Download
      • Markdown
      • HTML
      • Raw HTML
Menu Note settings Note Insights Versions and GitHub Sync Sharing URL Create Help
Create Create new note Create a note from template
Menu
Options
Engagement control Make a copy Transfer ownership Delete this note
Import from
Dropbox Google Drive Gist Clipboard
Export to
Dropbox Google Drive Gist
Download
Markdown HTML Raw HTML
Back
Sharing URL Link copied
/edit
View mode
  • Edit mode
  • View mode
  • Book mode
  • Slide mode
Edit mode View mode Book mode Slide mode
Customize slides
Note Permission
Read
Only me
  • Only me
  • Signed-in users
  • Everyone
Only me Signed-in users Everyone
Write
Only me
  • Only me
  • Signed-in users
  • Everyone
Only me Signed-in users Everyone
Engagement control Commenting, Suggest edit, Emoji Reply
  • Invite by email
    Invitee

    This note has no invitees

  • Publish Note

    Share your work with the world Congratulations! 🎉 Your note is out in the world Publish Note

    Your note will be visible on your profile and discoverable by anyone.
    Your note is now live.
    This note is visible on your profile and discoverable online.
    Everyone on the web can find and read all notes of this public team.
    See published notes
    Unpublish note
    Please check the box to agree to the Community Guidelines.
    View profile
    Engagement control
    Commenting
    Permission
    Disabled Forbidden Owners Signed-in users Everyone
    Enable
    Permission
    • Forbidden
    • Owners
    • Signed-in users
    • Everyone
    Suggest edit
    Permission
    Disabled Forbidden Owners Signed-in users Everyone
    Enable
    Permission
    • Forbidden
    • Owners
    • Signed-in users
    Emoji Reply
    Enable
    Import from Dropbox Google Drive Gist Clipboard
       Owned this note    Owned this note      
    Published Linked with GitHub
    • Any changes
      Be notified of any changes
    • Mention me
      Be notified of mention me
    • Unsubscribe
    **Excel學習 教學 影音作者Papaya** :::success - [EP1.Excel 基礎教學 01:Excel 入門](https://www.youtube.com/watch?v=wg3R5LdQ56k) ::: :::success - [EP2.Excel 基礎教學 02:表格設計 & 自動加總](https://www.youtube.com/watch?v=uTfjh3P9suk) ::: :::success - [EP3.Excel 基礎教學 03:凍結窗格 & 分割視窗](https://www.youtube.com/watch?v=fhIwXnZBth0) ::: :::success - [EP4.Excel 基礎教學 04:資料排序](https://www.youtube.com/watch?v=HNjZdVJ845Q) ::: :::success - [EP5.Excel 基礎教學 05:資料篩選](https://www.youtube.com/watch?v=4izfNPmZGiY) ::: :::success - [EP6.Excel 基礎教學 06:格式化為表格 & 交叉分析篩選器](https://www.youtube.com/watch?v=44ldMvpEEGo) ::: :::success - [EP7.Excel 基礎教學 07:設定格式化的條件](https://www.youtube.com/watch?v=yM0MqqiTyhU) ::: :::success - [EP8.Excel 基礎教學 08:工作表設定 & 合併彙算](https://www.youtube.com/watch?v=KMEwqTYlEiY) ::: :::success - [EP9.Excel 基礎教學 09:圖表製作 (上)](https://www.youtube.com/watch?v=PVcp5kmwuCs) ::: :::success - [EP10.Excel 基礎教學 10:圖表製作 (下)](https://www.youtube.com/watch?v=g66Zm1iIqd0) ::: :::success - [EP11.Excel 基礎教學 11:樞紐分析表](https://www.youtube.com/watch?v=Fz8T_5V2hUc) ::: :::success - [EP12.Excel 基礎教學 12:列印分頁設定](https://www.youtube.com/watch?v=Uit-np2yxfY) ::: :::success - [EP13.Excel 基礎教學 13:頁首、頁尾設計 & 浮水印製作](https://www.youtube.com/watch?v=WG60luuBYMo) ::: :::success - [EP14.Excel 基礎教學 14:基礎函數概念](https://www.youtube.com/watch?v=RTPlzLyB-ik) ::: :::success - [EP15.Excel 基礎教學 15:邏輯函數 IF](https://www.youtube.com/watch?v=mBAcmhK-NRg) ::: :::success - [EP16.Excel 基礎教學 16:VLOOKUP 函數 & 絕對參照設定](https://www.youtube.com/watch?v=gOASqU7wHkQ) ::: :::success - [EP17.Excel 基礎教學 17:IFERROR 函數 & 資料驗證](https://www.youtube.com/watch?v=gee-truceaQ) ::: :::success - [EP18.Excel 基礎教學 18:COUNTIF & SUMIF 函數](https://www.youtube.com/watch?v=QVIIiTMvj1w) ::: :::success - [EP19.Excel 基礎教學 19:下拉選單製作 & INDIRECT 函數](https://www.youtube.com/watch?v=Pd1Loi96ZX0) ::: :::success - [EP20.Excel 基礎教學 20:讓你事半功倍的 12 個小技巧](https://www.youtube.com/watch?v=kUZJ-HxXsK4) ::: :::success - [EP21.Excel 基礎教學 21:自訂數值格式](https://www.youtube.com/watch?v=rR2dKiw9mNo) ::: :::success - [EP22.日期函數 & 年資與工時計算 | Excel 教學 22](https://www.youtube.com/watch?v=hJLurVi_VQA) ::: :::success - [EP23.如何使用 Rank 函數進行排名? | Excel 教學 23](https://www.youtube.com/watch?v=7cW49UstbeI) ::: :::success - [EP24.如何用 LEFT / MID / RIGHT 函數擷取儲存格的文字資料? | Excel 教學 24](https://www.youtube.com/watch?v=Gk8ejH3avGk) ::: :::success - [EP25.比 VLOOKUP 還好用的最強函數組合 INDEX & MATCH | Excel 教學 25](https://www.youtube.com/watch?v=OM2cSVEJuB4) ::: :::success - [EP26.保護表格必學四招!讓閒雜人等無法更改你的重要資料 | Excel 教學 26](https://www.youtube.com/watch?v=nc3T6CNKzr4) ::: :::success - [EP27.我的表格有重複資料該怎麼辦?簡單三招讓它們現出原形,從此不再出現 | Excel 教學 27](https://www.youtube.com/watch?v=7drQ-y4OUhg) ::: :::success - [EP28.RAND / RANDBETWEEN 隨機函數 | Excel 教學 28](https://www.youtube.com/watch?v=aY3eKfGLI0E) ::: :::success - [EP29.養成不拖延的好習慣,就從做一個美美的進度追蹤表開始!#Excel 教學 29](https://www.youtube.com/watch?v=6Sjjm_XX-VQ) ::: :::success - [EP30.如何製作一個讓老闆眼睛為之一亮的甘特圖? | Excel 教學 #30](https://www.youtube.com/watch?v=NiFs4GPGWYg) ::: :::success - [EP31.如同多功能瑞士刀的強悍函數 SUMPRODUCT | Excel 教學 #31](https://www.youtube.com/watch?v=WEe7jG0k4hg) ::: :::success - [EP32.「動態陣列」讓寫公式從此變得宇宙無敵簡單! | Excel 教學 #32](https://www.youtube.com/watch?v=g835ZXDLTi0) ::: :::success - [EP33.柏拉圖 (Pareto) - 來自於 80/20 法則的神奇圖表 | Excel 教學 #33](https://www.youtube.com/watch?v=N-2YKrPoJ6o) ::: :::success - [EP34.VLOOKUP 功成身退!全新函數 XLOOKUP 霸氣取而代之!| Excel 教學 #34](https://www.youtube.com/watch?v=_BJrCPfamSc) ::: :::success - [EP35.怪盜現身!如何用 Excel 擷取網頁上的資料? | Excel 教學 #35](https://www.youtube.com/watch?v=b14NBFv6-wI) ::: :::success - [EP36.如何用 Excel 設計線上問卷 + 資料分析? | Excel 教學 #36](https://www.youtube.com/watch?v=FbqJp_CFSn8) ::: :::success - [EP37.如何使用 LET 函數來簡化複雜的公式? | Excel 教學 #38](https://www.youtube.com/watch?v=QdDtn7DAh_U) ::: :::success - [EP38.揮別複製、貼上的日子!學會 Power Query 讓合併表格資料變得超有效率!#Excel 教學 39](https://www.youtube.com/watch?v=c4ZXLLExG_w) ::: :::success - [EP39.錢當然要用在刀口上!用 Excel 的模擬分析功能找出公司的競爭力!Excel 教學 40](https://www.youtube.com/watch?v=TToihGCy4Xg) ::: :::success - [EP40.即使不會寫程式也能用 LAMBDA 自創函數!這麼逆天的功能還不快學起來!Excel 教學 41](https://www.youtube.com/watch?v=RK5jCM6o-PY) ::: :::success - [EP41.如何使用 Lambda 函數的遞迴 (Recursion) 功能 | Excel 教學 42](https://www.youtube.com/watch?v=JPoJs3Q9lV4) ::: :::success - [EP42.16 個面試最常被問到的 Excel 問題和答題攻略 | Excel 教學 43](https://www.youtube.com/watch?v=6xXdlpmZwHI) ::: :::success - [EP43.戰棋函數 OFFSET 能力發動!就算有新資料進來我也不用修改公式範圍了 | Excel 教學 44](https://www.youtube.com/watch?v=eNn6mbJsIHE) ::: :::success - [EP44.如何製作一個 **讓你看起來有點厲害** 的「互動式專案管理儀表板」| Excel 教學 45](https://www.youtube.com/watch?v=OkUAr1IcSSg) ::: :::success - [EP45.如何製作一個 **讓你看起來有點厲害** 的員工排班表 (上) | Excel 教學 46](https://www.youtube.com/watch?v=j6VLcFoQguk) ::: :::success - [EP46.如何製作一個 **讓你看起來有點厲害** 的員工排班表 (下) | Excel 教學 47](https://www.youtube.com/watch?v=ziga9B5Hr_o) ::: :::success - [EP47.實用的知識增加了‼ 讓 VLOOKUP 和「樞紐分析表」同時查詢多個工作表的資料 | Excel 教學 48](https://www.youtube.com/watch?v=nPJB1aw3zTQ) ::: :::success - [EP48.宅經濟當道!網拍小資族必學的 Excel 技巧 ﹥ 庫存出入管理 + 條碼合併列印 + 動態商品圖片 🛍 Excel 教學 49](https://www.youtube.com/watch?v=pwwL80q2txg) ::: :::success - [EP49.解決 Excel 任何疑難雜症的最終方案!快速上手 VBA 讓你變成 Excel 類大師!| Excel 教學 50](https://www.youtube.com/watch?v=Y3dLNYOfFDA) ::: :::success - [EP50.VLOOKUP 一次只能找到一筆資料,但我要找的資料不只一筆該怎麼辦?| Excel 教學 51](https://www.youtube.com/watch?v=aO_B2xj_rhc) ::: :::success - [EP51.Excel 有個古董級的函數,知道的人不多但功能超強?| Excel 52 (資料庫函數 DSUM、DGET 教學)](https://www.youtube.com/watch?v=JM87BiY_tls) ::: :::success - [EP52.這一天終於要來了嗎?使用 AI 人工智慧幫你寫好函數,我們只要躺平出一張嘴就好囉 🎉🎉  | Excel 53](https://www.youtube.com/watch?v=b5HAeTz5lFc) ::: :::success - [EP53.Outlook 友情助陣!使用 VBA 自動寄送包含附件的 Email 給不同收件者 ✉️ | Excel 54](https://www.youtube.com/watch?v=cxtmw3WnlwM) ::: :::success - [EP54.如何用 Excel 打造一個簡易會計系統 + 三大財務報表 (上)](https://www.youtube.com/watch?v=nOKIeGQcnXk) ::: :::success - [EP55.如何用 Excel 打造一個簡易會計系統 + 三大財務報表 (下)](https://www.youtube.com/watch?v=06-FUUEbNvM) ::: :::success - [EP56.如何用 Excel 打造一套簡易訂單系統 (上) (報價單、銷貨明細表等皆適用)](https://www.youtube.com/watch?v=Mzddp3-SDhw) ::: :::success - [EP57.如何用 Excel 打造一套簡易訂單系統 (下) (報價單、銷貨明細表等皆適用)](https://www.youtube.com/watch?v=zbuAjuBv_RI) ::: :::success - [EP58.擺脫月光族的宿命!讓 Excel 變成你的財務幫手,輕鬆記帳讓月底不再吃土!(上集)](https://www.youtube.com/watch?v=DKjTHWB0jZE) ::: :::success - [EP59.擺脫月光族的宿命!讓 Excel 變成你的財務小幫手,輕鬆記帳讓月底不再吃土!(下集)](https://www.youtube.com/watch?v=B7UWyqgVzEA) ::: :::success - [EP60.Excel 還可以這樣玩?輕鬆用 VBA 把 Excel 改造成自己專屬的 POS 零售/點餐系統!](https://www.youtube.com/watch?v=F4ntA-RIS10) ::: :::success - [EP61.Excel 初學者最常犯的六個新手陷阱!避免一眼被看出是 Excel 菜鳥,就要知道 Excel 高手的起手式!](https://www.youtube.com/watch?v=b9WzLHHe0u4) ::: :::success - [EP62.「核取方塊」功能有重大升級!使用 Excel 製作「待辦事項」和「出勤記錄」變得快速又簡單!](https://www.youtube.com/watch?v=_1oIwUT2d2A) ::: :::success - [EP63.常態分布曲線到底怎麼畫?直方圖跟直條圖傻傻分不清?Excel 高級技巧一次揭密](https://www.youtube.com/watch?v=TsoJRPiKPRw) ::: :::success - [EP64.零成本打造 Excel 庫存管理系統 (上)!超強功能+直觀界面 - 讓公司前輩嚇到吃手手對你甘拜下風 ~](https://www.youtube.com/watch?v=SG5kM6We5D8) ::: :::success - [EP65.零成本打造 Excel 庫存管理系統 (下)!超強功能+直觀界面 - 讓公司前輩嚇到吃手手對你甘拜下風 ~](https://www.youtube.com/watch?v=Pdn6rAhmNbw) ::: :::success - [EP66.樞紐分析表要 R.I.P. 了?Excel 新秘密武器 GROUPBY + PIVOTBY 函數讓你的數據分析能力開掛!](https://www.youtube.com/watch?v=ZoIlI5BKpcU) ::: :::success - [EP67.Excel 實用小技巧!將包含日期的表格輕鬆轉換成月曆格式,讓行程安排更加一目瞭然!](https://www.youtube.com/watch?v=_UOhPjvhbjY) ::: :::success - [EP68.Excel 最強的功能不是函數和 VBA?他在鍵盤上敲了 =py 三個字,辦公室的 Excel 老鳥馬上起立讓坐給他了!#Python](https://www.youtube.com/watch?v=kYyIEnTXYRg) ::: :::success - [EP69.Microsoft Excel 基礎教學 | 2025 重製版 (EP.1) 從零開始打好基礎,進入職場必修的一門課!](https://www.youtube.com/watch?v=PFRwOomIhoo) ::: :::success - [EP70.Microsoft Excel 基礎教學 (EP.2) 工作表管理 / 下拉選單 / 資料驗證 / 公式建立 / 相對與絕對參照](https://www.youtube.com/watch?v=qS6__SvYFjM) ::: :::success - [EP71.Microsoft Excel 基礎教學 (EP.3) 邏輯函數 IF / AND / OR / NOT / IFS / SWITCH](https://www.youtube.com/watch?v=MtjE8gdDJMk) ::: :::success - [EP72.Microsoft Excel 基礎教學 (EP.4) 條件式統計函數 COUNTIF(S) / SUMIF(S) / AVERAGEIF(S) / DATEDIF](https://www.youtube.com/watch?v=RUUhtpmvmpU) ::: :::success - [EP73.Microsoft Excel 基礎教學 (EP.5) 查詢參照函數 VLOOKUP / XLOOKUP / IFERROR / INDEX / MATCH](https://www.youtube.com/watch?v=fVSylPMUMNY) ::: :::success - [EP74.Microsoft Excel 基礎教學 (EP.6) 文字處理函數 CONCAT / TEXT / LEFT / MID / RIGHT / FIND](https://www.youtube.com/watch?v=fI5Y_fhqZAo) ::: :::success - [EP75.Microsoft Excel 基礎教學 (EP.7) 條件式格式設定 / 工作表保護與共用 / 分頁列印設定](https://www.youtube.com/watch?v=ij7o7S1f4sA) ::: :::success - [EP76.Microsoft Excel 基礎教學 (EP.8) 圖表繪製:直條圖 / 折線圖 / 組合圖 / 圓形圖 / 環圈圖](https://www.youtube.com/watch?v=lEV849pg04k) ::: :::success - [EP77.Microsoft Excel 基礎教學 (EP.9) 動態陣列函數 SEQUENCE / FILTER / UNIQUE / HSTACK / SORT](https://www.youtube.com/watch?v=8ubTDPARJGk) ::: :::success - [EP78.Microsoft Excel 基礎教學 (EP.10 END) 樞紐分析表 / Power Query / Power Pivot](https://www.youtube.com/watch?v=Nuvau99Sgeg) :::

    Import from clipboard

    Paste your markdown or webpage here...

    Advanced permission required

    Your current role can only read. Ask the system administrator to acquire write and comment permission.

    This team is disabled

    Sorry, this team is disabled. You can't edit this note.

    This note is locked

    Sorry, only owner can edit this note.

    Reach the limit

    Sorry, you've reached the max length this note can be.
    Please reduce the content or divide it to more notes, thank you!

    Import from Gist

    Import from Snippet

    or

    Export to Snippet

    Are you sure?

    Do you really want to delete this note?
    All users will lose their connection.

    Create a note from template

    Create a note from template

    Oops...
    This template has been removed or transferred.
    Upgrade
    All
    • All
    • Team
    No template.

    Create a template

    Upgrade

    Delete template

    Do you really want to delete this template?
    Turn this template into a regular note and keep its content, versions, and comments.

    This page need refresh

    You have an incompatible client version.
    Refresh to update.
    New version available!
    See releases notes here
    Refresh to enjoy new features.
    Your user state has changed.
    Refresh to load new user state.

    Sign in

    Forgot password

    or

    By clicking below, you agree to our terms of service.

    Sign in via Facebook Sign in via Twitter Sign in via GitHub Sign in via Dropbox Sign in with Wallet
    Wallet ( )
    Connect another wallet

    New to HackMD? Sign up

    Help

    • English
    • 中文
    • Français
    • Deutsch
    • 日本語
    • Español
    • Català
    • Ελληνικά
    • Português
    • italiano
    • Türkçe
    • Русский
    • Nederlands
    • hrvatski jezik
    • język polski
    • Українська
    • हिन्दी
    • svenska
    • Esperanto
    • dansk

    Documents

    Help & Tutorial

    How to use Book mode

    Slide Example

    API Docs

    Edit in VSCode

    Install browser extension

    Contacts

    Feedback

    Discord

    Send us email

    Resources

    Releases

    Pricing

    Blog

    Policy

    Terms

    Privacy

    Cheatsheet

    Syntax Example Reference
    # Header Header 基本排版
    - Unordered List
    • Unordered List
    1. Ordered List
    1. Ordered List
    - [ ] Todo List
    • Todo List
    > Blockquote
    Blockquote
    **Bold font** Bold font
    *Italics font* Italics font
    ~~Strikethrough~~ Strikethrough
    19^th^ 19th
    H~2~O H2O
    ++Inserted text++ Inserted text
    ==Marked text== Marked text
    [link text](https:// "title") Link
    ![image alt](https:// "title") Image
    `Code` Code 在筆記中貼入程式碼
    ```javascript
    var i = 0;
    ```
    var i = 0;
    :smile: :smile: Emoji list
    {%youtube youtube_id %} Externals
    $L^aT_eX$ LaTeX
    :::info
    This is a alert area.
    :::

    This is a alert area.

    Versions and GitHub Sync
    Get Full History Access

    • Edit version name
    • Delete

    revision author avatar     named on  

    More Less

    Note content is identical to the latest version.
    Compare
      Choose a version
      No search result
      Version not found
    Sign in to link this note to GitHub
    Learn more
    This note is not linked with GitHub
     

    Feedback

    Submission failed, please try again

    Thanks for your support.

    On a scale of 0-10, how likely is it that you would recommend HackMD to your friends, family or business associates?

    Please give us some advice and help us improve HackMD.

     

    Thanks for your feedback

    Remove version name

    Do you want to remove this version name and description?

    Transfer ownership

    Transfer to
      Warning: is a public team. If you transfer note to this team, everyone on the web can find and read this note.

        Link with GitHub

        Please authorize HackMD on GitHub
        • Please sign in to GitHub and install the HackMD app on your GitHub repo.
        • HackMD links with GitHub through a GitHub App. You can choose which repo to install our App.
        Learn more  Sign in to GitHub

        Push the note to GitHub Push to GitHub Pull a file from GitHub

          Authorize again
         

        Choose which file to push to

        Select repo
        Refresh Authorize more repos
        Select branch
        Select file
        Select branch
        Choose version(s) to push
        • Save a new version and push
        • Choose from existing versions
        Include title and tags
        Available push count

        Pull from GitHub

         
        File from GitHub
        File from HackMD

        GitHub Link Settings

        File linked

        Linked by
        File path
        Last synced branch
        Available push count

        Danger Zone

        Unlink
        You will no longer receive notification when GitHub file changes after unlink.

        Syncing

        Push failed

        Push successfully