如何從無到有架出一個大型excel底稿 - 會計

By Rosalind
at 2022-10-28T23:28
at 2022-10-28T23:28
Table of Contents
大家好,
想請教大家如何培養‘’從無到有架出一個大型底稿‘’的能力?
剛進事務所,常常看到前期底稿的公式總是密密麻麻一大串,
If裡面又好幾個if,
外加好幾個公式包在一起,
或是貼上一個值或重整樞紐,
就能自動串接更新好幾個sheet的內容。
雖然逐一拆解後,
是能理解公式的架構的,
但若要憑空產出這樣的大型底稿,
實在非我能力所及。
想請教大家,若要具備這樣的能力,
應該如何培養?
除了熟悉excel公式運用外(這個可參考坊間excel教材),
關於邏輯設計的面向,能夠如何培養呢?
有前輩建議去學寫程式,不知這對會計工作的底稿架設是有用的嗎?
謝謝大家
--
想請教大家如何培養‘’從無到有架出一個大型底稿‘’的能力?
剛進事務所,常常看到前期底稿的公式總是密密麻麻一大串,
If裡面又好幾個if,
外加好幾個公式包在一起,
或是貼上一個值或重整樞紐,
就能自動串接更新好幾個sheet的內容。
雖然逐一拆解後,
是能理解公式的架構的,
但若要憑空產出這樣的大型底稿,
實在非我能力所及。
想請教大家,若要具備這樣的能力,
應該如何培養?
除了熟悉excel公式運用外(這個可參考坊間excel教材),
關於邏輯設計的面向,能夠如何培養呢?
有前輩建議去學寫程式,不知這對會計工作的底稿架設是有用的嗎?
謝謝大家
--
Tags:
會計
All Comments

By Hedwig
at 2022-11-01T22:09
at 2022-11-01T22:09

By John
at 2022-10-30T14:30
at 2022-10-30T14:30

By Callum
at 2022-11-03T13:11
at 2022-11-03T13:11

By Ula
at 2022-10-30T14:30
at 2022-10-30T14:30

By Caitlin
at 2022-11-03T13:11
at 2022-11-03T13:11

By Enid
at 2022-10-30T14:30
at 2022-10-30T14:30

By Gilbert
at 2022-11-03T13:11
at 2022-11-03T13:11

By James
at 2022-10-30T14:30
at 2022-10-30T14:30

By Lucy
at 2022-11-03T13:11
at 2022-11-03T13:11

By Catherine
at 2022-10-30T14:30
at 2022-10-30T14:30

By Elvira
at 2022-11-03T13:11
at 2022-11-03T13:11

By Adele
at 2022-10-30T14:30
at 2022-10-30T14:30

By Annie
at 2022-11-03T13:11
at 2022-11-03T13:11

By Todd Johnson
at 2022-10-30T14:30
at 2022-10-30T14:30

By Anthony
at 2022-11-03T13:11
at 2022-11-03T13:11

By Kyle
at 2022-10-30T14:30
at 2022-10-30T14:30

By Agnes
at 2022-11-03T13:11
at 2022-11-03T13:11

By Lucy
at 2022-10-30T14:30
at 2022-10-30T14:30

By Kelly
at 2022-11-03T13:11
at 2022-11-03T13:11

By Carolina Franco
at 2022-10-30T14:30
at 2022-10-30T14:30

By Brianna
at 2022-11-03T13:11
at 2022-11-03T13:11

By Yedda
at 2022-10-30T14:30
at 2022-10-30T14:30
Related Posts
2022會計師應屆一次及格

By Liam
at 2022-10-27T17:53
at 2022-10-27T17:53
111會計師應屆一次及格心得

By Harry
at 2022-10-25T23:19
at 2022-10-25T23:19
111年會計師上榜心得 (代po)

By Callum
at 2022-10-25T20:44
at 2022-10-25T20:44
111會計師考取心得(代po)

By Tracy
at 2022-10-25T11:19
at 2022-10-25T11:19
111會計師考取心得(代po)

By Ula
at 2022-10-22T17:33
at 2022-10-22T17:33