Excel 小技巧

原本論文的模擬想用EXCEL完成,但後來又怕EXCEL登不了大場面XD,就改用matlab了,但程式寫寫也滿大的,用matlab應該還是比較好一點啦~

可是EXCEL的書借都借了,就順便翻一翻囉~
將cell的變數改成常數->按F9
顯示cell的公式->Ctrl+`
有一個應用,假設每個月最多可以還兩萬塊,這樣最多可以帶多少錢,在2007的Data頁面的What If Analysis
複製文字->REPT()
取得ASCII->CODE()可以取中文

This entry was posted in 電腦和網際網路. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s