Search
【內容綱要】
00:00 開場白
01:20 UNIQUE 函數
01:54 Spilling (溢出) 的特性
04:26 FILTER 函數
05:47 建立動態陣列的下拉選單
06:58 SORT 函數
【練習檔下載】
https://tinyurl.com/vwxhatn
【影片中使用的軟體版本】
Office 365 https://tinyurl.com/yyhsunt5
【加入頻道會員 - 每月有不定期的會員專屬教學短片喔！👍】
https://tinyurl.com/sxt3d2b
【加入新開張的 Papaya 臉書粉絲團 😎】
https://www.facebook.com/papayaclassroom
【影片中使用的圖片素材】
https://www.flaticon.com
【Papaya 使用的影片剪輯軟體】
https://www.techsmith.com/video-editor.html (Camtasia Studio )
#papaya電腦教室 #Excel #函數 #教學 #動態陣列
FB：https://www.facebook.com/ellenenjoylife/
IG：ellen_enjoylife
📫marcdaisy61@gmail.com
_______________________________________________________________
圖文心得版👉http://marcdaisy61.pixnet.net/blog/post/349731445
*Makeup：
SUGAO 絲緞感潤色飾底乳 (綠&黃)
Tatcha
The Silk Canvas Protective Primer
Shu Uemura 植村秀
Unlimited 無限輕透持妝粉底液 (674 light shell)
CLIO 光感無痕遮瑕蜜
(#3 明亮色)
YSL TOUCHE ÉCLAT Radiant Touch Highlighting Pen
超模聚焦明采筆 (01號色)
Dior 搶眼造型眉筆
Diorshow Brow Styler (001 Brown)
KATE 3D時尚眉彩膏 (BR-2)
Excel 持久捲翹彈力睫毛夾
MISSHA Color Filter Shadow Palette 完美濾鏡眼頰彩盤
(No.2 Budapest Filter/布達佩斯浪漫玫瑰)
Innisfree (My palette) my eyeshadow
(Glitter 02)
Benefit Cheek Parade Palette
CANMAKE Powder Cheeks
(PW38 Plum Pink)
A'PIEU x MARYMOND
(#01 Dear. Magnolia)
Marc Jacobs Beauty
Magic Marc'er Precision Pen Waterproof Liquid Eyeliner
(Blacquer)
NARS Climax Mascara
ROMAND Juicy Lasting Tint 果凍持久染唇釉
(#07 JUJUBE)
Music 🌜
LAKEY INSPIRED - In My Clouds
(Spotify: https://goo.gl/aLkwM5)
(SoundCloud: https://soundcloud.com/lakeyinspired/in-my-clouds)
籌備左好耐，大家亦等左好耐的年度最愛片終於搞掂了！以上全部純屬個人意見，亦歡迎大家話我知你哋鍾意用什麼產品！睇完記得Like同Subscribe！Thankyou so much for watching and Love you all~~ xoxo?
如果你想我的影片有更多人看到的話可捐獻字幕啊，萬分感激～xx
♥ Follow me ♥
Instagram: @hiddie http://www.instagram.com/hiddie/
SnapChat: @hiddietse
Facebook: http://facebook.com/hiddietmakeup
Blogspot: http://hiddietmakeup.blogspot.com/
Weibo: http://weibo.com/hiddie
Product mentioned:
Too Faced Hangover Primer
It Cosmetics Your Skin But Better CC+ Cream
Giorgio Armani Power Fabric Foundation 4.5
https://www.youtube.com/watch?v=fWHC-lve2wg
*MAC Studio Fix Fluid Foundation NC15
https://www.youtube.com/watch?v=vMy_MOCca3o
Estée Lauder Double Wear Nude Water 1W1 Bone
https://www.youtube.com/watch?v=8JRwJWPz3LE
Giorgio Armani To Go Essence-In Foundation Cushion No.4
https://www.youtube.com/watch?v=fzufKv2vbGA
By Terry Hyaluronic Hydra-Powder
Hourglass Ambient Lighting Powder - Diffused Light
Nars Radiant Creamy Concealer
It Cosmetics Bye Bye Underage Concealer - Light
Nars Soft Matte Complete Concealer
Excel 3 in 1 Brow Pencil
New Born 3 in 1 Brow Pencil
Pony Effect Sharping Brow Definer
Anastasia Beverly Hills Brow Wiz - Medium Brown
Kate Brow Powder
*Rimmel Brow Shake Filling Powder
Urban Decay Eyeshadow Primer Potion
Too Faced Sweet Peach Palette
Love Liner Liquid Eyeliner
Tom Ford Eye Defining Pen
Marc Jacobs #instamarc - 40 Mirage Filter
*Rimmel Kate Sculpting Palette - 003 Golden Bronze
Charlotte Tilbury Cheek To Chic Blush - Ecstasy
Suqqu Pure Color Blush - 01 Tsubomizaki
Becca Shimmering Skin Perfector Mineral Blush - Champagne Split - Flowerchild, Champagne Pop
MAC Extra Dimension Skinfinish - Oh, darling
Dior Lip Tattoo - 451 Natural coral
Fancl Mild Cleansng Oil
Bifesta Eye Makeup Remover
Bioderma Sensibio
Cetaphil Gentle Skin Cleanser
Is Clinical Cleansing Complex
Curel Intensive Moisture Lotion
Curel Intensive Moisture Milk
Curel Intensive Moisture Cream
Fresh Rose Floral Toner
La Mer The Tonic
Eternus-D Delicate Repair Serum
*SK II Genoptics Aura Essence
*SK II R.N.A. Power Radical New Age Eye Cream
*SK II R.N.A. Power Radical New Age Cream
(* sent by PR)
This is not a sponsored video.
6.1 Tidy Data. Each column is a variable. Each row is an observation. 一個欄位（Column）內只有一個數值，最好要有凡人看得懂的Column Name; 不同的觀察值應該要 ... ... <看更多>
Excel 教學 39 ▷10:50. ... 適用於Excel365底下的Filter函數，可以讓你篩選資料更輕而一舉2.不是Excel365的朋友們，可以使用進階篩選，一樣可以達到類似的效果唷~ ▻此 ... ... <看更多>
excel filter教學 在 #職場excel - Explore | Facebook 的推薦與評價
《Excel教學@廣東話》Excel if 公式の2 - 進階篇以巢式if 檢查多重條件對錯輸出多種 ... Labels」、「報表篩選Report Filter」、「時間軸Timeline」 及「交叉分析篩選 ... ... <看更多>