Homepage
Open in app
Sign in
Get started
Curtis’s Digital Life
OneNote
Document
Spreadsheet
Presentation
Apple
About
LinkedIn
Tagged in
Excel
Curtis’s Digital Life
Reflection of many techniques, tips that increase one’s value in digital era, by Curtis Chan
More information
Followers
99
Elsewhere
More, on Medium
Excel
🐟Curtis Chan FishSunSun
in
Curtis’s Digital Life
Dec 22, 2019
使用Google Apps Script 及SQL在試算表中提取指定義工的所有時數記錄
最近我加入了一間NGO工作,該NGO主要服務對象是四肢嚴重殘疾的人士。本文簡記如何實作一個提取目標記錄的程式。
Read more…
79
🐟Curtis Chan FishSunSun
in
Curtis’s Digital Life
Dec 21, 2019
Retrieving volunteer records by SQL with Google Apps Script in Google Spreadsheet
Recently, I am…
Read more…
17
🐟Curtis Chan FishSunSun
in
Curtis’s Digital Life
May 28, 2019
我用來寫心理學大學畢業論文的App
用PsychoPy 來收集數據、Excel 清理數據、 R 來作心理統計學分析;再加 Word、 InDesign、Zotero來進行APA格式排版及引用來源管理。
Read more…
142
🐟Curtis Chan FishSunSun
in
Curtis’s Digital Life
May 19, 2019
邊到都 Excel :除咗函數 VLOOKUP 來評學生表現,仲有咩其他板斧?
上一篇文,我講咗我點樣用 Excel 來幫我搞掂嗰畢業論文一啲部分。呢次我來我就來重温一啲有用嘅 LOOKUP 函數,以及…
Read more…
114
🐟Curtis Chan FishSunSun
in
Curtis’s Digital Life
Jun 14, 2016
City Hunt 遊戲自動計算
Google Sheets:SUMIF、格式條件化、凍結欄位
Read more…
13
🐟Curtis Chan FishSunSun
in
Curtis’s Digital Life
Apr 29, 2019
Excel Everywhere: Performance Grading by more than VLOOKUP
Last article I discussed my Excel…
Read more…
40
1 response
🐟Curtis Chan FishSunSun
in
Curtis’s Digital Life
Apr 26, 2019
Excel Everywhere: Texts Combination and Separation
Read more…