來看看怎麼用智慧型方塊，讓你在試算表的管理上更方便！

職場產業

投資理財

學習

智慧型方塊，「@」一下更方便！

The official video for “Never Gonna Give You Up” by Rick Astley

‘Hold Me In Your Arms’ – deluxe blue vinyl,  2CD and digital deluxe out 12th May 2023 Pre-order here – https://rick-astley.lnk.to/HMIYA2023ID

“Never Gonna Give You Up” was a global smash on its release in July 1987, topping the charts in 25 countries including Rick’s native UK and the US Billboard Hot 100.  It also won the Brit Award for Best single in 1988. Stock Aitken and Waterman wrote and produced the track which was the lead-off single and lead track from Rick’s debut LP “Whenever You Need Somebody”.  The album was itself a UK number one and would go on to sell over 15 million copies worldwide.

The legendary video was directed by Simon West – who later went on to make Hollywood blockbusters such as Con Air, Lara Croft – Tomb Raider and The Expendables 2.  The video passed the 1bn YouTube views milestone on 28 July 2021.

Subscribe to the official Rick Astley YouTube channel: https://RickAstley.lnk.to/YTSubID

Follow Rick Astley:
Facebook: https://RickAstley.lnk.to/FBFollowID 
Twitter: https://RickAstley.lnk.to/TwitterID 
Instagram: https://RickAstley.lnk.to/InstagramID 
Website: https://RickAstley.lnk.to/storeID 
TikTok: https://RickAstley.lnk.to/TikTokID

Listen to Rick Astley:
Spotify: https://RickAstley.lnk.to/SpotifyID 
Apple Music: https://RickAstley.lnk.to/AppleMusicID 
Amazon Music: https://RickAstley.lnk.to/AmazonMusicID 
Deezer: https://RickAstley.lnk.to/DeezerID 

Lyrics:
We’re no strangers to love
You know the rules and so do I
A full commitment’s what I’m thinking of
You wouldn’t get this from any other guy

I just wanna tell you how I’m feeling
Gotta make you understand

Never gonna give you up
Never gonna let you down
Never gonna run around and desert you
Never gonna make you cry
Never gonna say goodbye
Never gonna tell a lie and hurt you

We’ve known each other for so long
Your heart’s been aching but you’re too shy to say it
Inside we both know what’s been going on
We know the game and we’re gonna play it

And if you ask me how I’m feeling
Don’t tell me you’re too blind to see

Never gonna give you up
Never gonna let you down
Never gonna run around and desert you
Never gonna make you cry
Never gonna say goodbye
Never gonna tell a lie and hurt you

#RickAstley #NeverGonnaGiveYouUp #WheneverYouNeedSomebody #OfficialMusicVideo

Rick Astley - Never Gonna Give You Up (Official Music Video)

今天來聊聊一個新手必學的兩個函式：SUMIF 跟 SUMIFS！

SUMIF / SUMIFS，按條件加總

來試試看用 GPT_TABLE 函式，把它加入到你的工作流裡吧！

音樂藝文

GPT for Sheets（五）：產生表格

今天介紹 TOCOL 和 TOROW 這兩個最近新增的函式，它們的功用是可以把資料拉〜成一條，而 TOCOL 則是把資料轉成一欄、而 TOROW 是把資料轉成一列。

親子與教育

TOCOL、TOROW，把資料拉成一條！

我們接下來要進入 GPT for Sheets 外掛程式的第四篇文章了！這次要介紹的是 GPT_FILL，只要給它足夠的資訊，它就可以按照前面的內容，神奇地自動填入相對應的內容。

GPT for Sheets（四）：自動填入

在上次提到的 GPT 函式，可以讀取你的指令，把結果回傳到儲存格裡。例如說，我在 GPT 傳的指令是「寫五個 Google 試算表的教學部落格的宣傳標語」：
雖然結果是 OK 的，可是這個結果都擠在同一個儲存格，有點小不方便。
這時候 GPT_LIST 函式就會特別有用，它會幫你直接把結果產生在一欄

GPT for Sheets（三）：產生清單

這次要介紹的是 IFNA 和 IFERROR 這兩個函式，它們可以幫助我們在試算表中可以靈活處理錯誤和缺失的數據。語法很單純，但也很實用！我們一起來看看怎麼做。

處理錯誤的 IFNA 跟 IFERROR

打鐵趁熱，馬上來接著介紹 GPT for Sheets 外掛程式提供的函式裡最基本的 GPT 函式吧。想把 GPT 應用在 Google 試算表上的話，這篇必看！

GPT for Sheets（二）：GPT 函式和基本功能

之前提過 IF 跟 IFS 這兩個可以做條件判斷的函式，但你知道其實條件判斷還有一手！今天要介紹的叫 SWITCH 函式，它跟 IF、IFS 一樣，可以做多條件的判斷，且可以在沒有相符結果時，傳回你指定的預設值。

SWITCH，多條件判斷還有這一手！

這次要介紹的兩個叫做 VSTACK 跟 HSTACK，可以讓你把範圍縱向或橫向堆疊起來，省去合併資料的一點麻煩！

Spreadsheets