Homepage
Open in app
Sign in
Get started
Curtis’s Digital Life
OneNote
Document
Spreadsheet
Presentation
Apple
About
LinkedIn
Excel
使用Google Apps Script 及SQL在試算表中提取指定義工的所有時數記錄
使用Google Apps Script 及SQL在試算表中提取指定義工的所有時數記錄
最近我加入了一間NGO工作,該NGO主要服務對象是四肢嚴重殘疾的人士。本文簡記如何實作一個提取目標記錄的程式。
🐟Curtis Chan FishSunSun
Dec 22, 2019
Retrieving volunteer records by SQL with Google Apps Script in Google Spreadsheet
Retrieving volunteer records by SQL with Google Apps Script in Google Spreadsheet
Recently, I am working for an NGO supporting those severe handicapped. This article documents how I retrieve target entries…
🐟Curtis Chan FishSunSun
Dec 21, 2019
我用來寫心理學大學畢業論文的App
我用來寫心理學大學畢業論文的App
用PsychoPy 來收集數據、Excel 清理數據、 R 來作心理統計學分析;再加 Word、 InDesign、Zotero來進行APA格式排版及引用來源管理。還有,寫論文也不一定要坐在電腦前,只要連接到網絡,電話或平板電腦也是寫作的好地方。
🐟Curtis Chan FishSunSun
May 28, 2019
邊到都 Excel :除咗函數 VLOOKUP 來評學生表現,仲有咩其他板斧?
邊到都 Excel :除咗函數 VLOOKUP 來評學生表現,仲有咩其他板斧?
上一篇文,我講咗我點樣用 Excel 來幫我搞掂嗰畢業論文一啲部分。呢次我來我就來重温一啲有用嘅 LOOKUP 函數,以及 highlight 一啲用 Excel 嘅好習慣。呢度用嗰例字講老師想檢查一下學生嘅學習成果。
🐟Curtis Chan FishSunSun
May 19, 2019
City Hunt 遊戲自動計算
City Hunt 遊戲自動計算
Google Sheets:SUMIF、格式條件化、凍結欄位
🐟Curtis Chan FishSunSun
Jun 14, 2016
Excel Everywhere: Performance Grading by more than VLOOKUP
Excel Everywhere: Performance Grading by more than VLOOKUP
Last article I discussed my Excel experience when doing a final year project. This time I will review some handy class of lookup function…
🐟Curtis Chan FishSunSun
Apr 29, 2019
Excel Everywhere: Texts Combination and Separation
Excel Everywhere: Texts Combination and Separation
Yo, this is my first sharing about how to work with Microsoft Office, literally, everywhere. As part of Microsoft service, Office 365…
🐟Curtis Chan FishSunSun
Apr 26, 2019
About Curtis’s Digital Life
Latest Stories
Archive
About Medium
Terms
Privacy
Teams