事務所新生Excel教學網站 - 會計
By Faithe
at 2020-08-25T01:11
at 2020-08-25T01:11
Table of Contents
下禮拜又到大批新人進入事務所的時間,
花了兩三個月把之前寫的東西(#1TOiAShe)修訂後做成網站,
並增加一些新的主題,例如XLOOKUP公式等,公式介紹部分與Web Excel連結,可於網頁
嵌入的Excel儲存格直接檢視公式或進行編輯。
網址:https://excel-starter.netlify.app/
網站大綱如下:
‧Excel 基本概念及快捷鍵
。基本概念
。快捷鍵
‧Excel 公式
。SUMIF
。SUMIFS
。SUMPRODUCT
。VLOOKUP
。INDEX/MATCH
。INDEX/SMALL/ROW
。XLOOKUP
。IF
。YEAR/MONTH/DAY
。LEFT/RIGHT/MID/LEN/SEARCH
‧Excel 小技巧
。快速篩選
。開新視窗
。快速填入
。選擇性貼上
‧Excel 樞紐分析表
‧Excel 資料剖析
‧Excel 檔案修復及整理
。檔案毀損修復
。檔案整理加速
‧Excel 自訂快捷鍵
。VBA 增益集安裝
。VBA 增益集移除
。VBA 自訂快捷鍵
。自訂快速存取工具列
‧Excel 巨集及VBA
。Excel 巨集及VBA
。VBA 編寫自定義快捷鍵
。VBA 自學資源
‧小工具
。PDF2Excel
未來如果有想到新的主題也會直接改到網站上。
--------------------------------------------
要說的話與之前那篇文章一樣就不再重複,
祝各位新生在事務所生活順利!
--
Accoding: https://www.facebook.com/AccodingTW/
--
花了兩三個月把之前寫的東西(#1TOiAShe)修訂後做成網站,
並增加一些新的主題,例如XLOOKUP公式等,公式介紹部分與Web Excel連結,可於網頁
嵌入的Excel儲存格直接檢視公式或進行編輯。
網址:https://excel-starter.netlify.app/
網站大綱如下:
‧Excel 基本概念及快捷鍵
。基本概念
。快捷鍵
‧Excel 公式
。SUMIF
。SUMIFS
。SUMPRODUCT
。VLOOKUP
。INDEX/MATCH
。INDEX/SMALL/ROW
。XLOOKUP
。IF
。YEAR/MONTH/DAY
。LEFT/RIGHT/MID/LEN/SEARCH
‧Excel 小技巧
。快速篩選
。開新視窗
。快速填入
。選擇性貼上
‧Excel 樞紐分析表
‧Excel 資料剖析
‧Excel 檔案修復及整理
。檔案毀損修復
。檔案整理加速
‧Excel 自訂快捷鍵
。VBA 增益集安裝
。VBA 增益集移除
。VBA 自訂快捷鍵
。自訂快速存取工具列
‧Excel 巨集及VBA
。Excel 巨集及VBA
。VBA 編寫自定義快捷鍵
。VBA 自學資源
‧小工具
。PDF2Excel
未來如果有想到新的主題也會直接改到網站上。
--------------------------------------------
要說的話與之前那篇文章一樣就不再重複,
祝各位新生在事務所生活順利!
--
Accoding: https://www.facebook.com/AccodingTW/
--
Tags:
會計
All Comments
By Jessica
at 2020-08-29T09:35
at 2020-08-29T09:35
By Robert
at 2020-08-30T17:00
at 2020-08-30T17:00
By Mia
at 2020-09-01T03:32
at 2020-09-01T03:32
By Zanna
at 2020-09-03T00:29
at 2020-09-03T00:29
By Andrew
at 2020-09-03T12:06
at 2020-09-03T12:06
By Doris
at 2020-09-04T08:42
at 2020-09-04T08:42
By Kama
at 2020-09-07T10:01
at 2020-09-07T10:01
By Zenobia
at 2020-09-10T18:47
at 2020-09-10T18:47
By Belly
at 2020-09-13T00:52
at 2020-09-13T00:52
By Megan
at 2020-09-14T03:11
at 2020-09-14T03:11
By Tracy
at 2020-09-17T10:57
at 2020-09-17T10:57
By Victoria
at 2020-09-20T13:12
at 2020-09-20T13:12
By Elvira
at 2020-09-23T17:27
at 2020-09-23T17:27
By Olive
at 2020-09-27T07:07
at 2020-09-27T07:07
By Andy
at 2020-09-30T15:36
at 2020-09-30T15:36
By Charlotte
at 2020-10-01T23:05
at 2020-10-01T23:05
By Yuri
at 2020-10-03T15:16
at 2020-10-03T15:16
By Regina
at 2020-10-04T12:20
at 2020-10-04T12:20
By Olive
at 2020-10-05T23:42
at 2020-10-05T23:42
By Jake
at 2020-10-10T13:19
at 2020-10-10T13:19
By Skylar Davis
at 2020-10-14T00:09
at 2020-10-14T00:09
By Oliver
at 2020-10-15T13:05
at 2020-10-15T13:05
By Caitlin
at 2020-10-18T12:05
at 2020-10-18T12:05
By Dorothy
at 2020-10-23T01:59
at 2020-10-23T01:59
By Noah
at 2020-10-26T16:53
at 2020-10-26T16:53
By Zanna
at 2020-10-30T20:41
at 2020-10-30T20:41
By Vanessa
at 2020-11-02T07:28
at 2020-11-02T07:28
By Kumar
at 2020-11-06T21:07
at 2020-11-06T21:07
By Caitlin
at 2020-11-11T17:44
at 2020-11-11T17:44
By Gilbert
at 2020-11-13T01:32
at 2020-11-13T01:32
By Necoo
at 2020-11-16T04:22
at 2020-11-16T04:22
By David
at 2020-11-17T01:39
at 2020-11-17T01:39
By Caitlin
at 2020-11-20T00:47
at 2020-11-20T00:47
Related Posts
北一109記帳士相關法規概要教材
By Hazel
at 2020-08-24T21:14
at 2020-08-24T21:14
北一109全科的教材
By Ula
at 2020-08-24T16:02
at 2020-08-24T16:02
設備的入帳成本一題
By Linda
at 2020-08-24T15:55
at 2020-08-24T15:55
政府補助的淨額法
By Rosalind
at 2020-08-24T15:53
at 2020-08-24T15:53
銀行存款餘額一題
By Kelly
at 2020-08-24T15:51
at 2020-08-24T15:51