VLOOKUP 功成身退！全新函數 XLOOKUP 霸氣取而代之！| Excel 教學 #34 - Vidude

3 Views· 27 July 2022

VLOOKUP 功成身退！全新函數 XLOOKUP 霸氣取而代之！| Excel 教學 #34

0

0

Advertisement

Advertise With Vidude

Subscribers

Education

【內容綱要】
00:00 開場白
01:50 一般查詢
03:06 向左查詢
03:54 錯誤提示
04:30 近似比對
05:48 橫向查詢
06:33 模糊查詢
07:05 逆向查詢
07:52 雙向查詢
【練習檔下載】
載點一： https://tinyurl.com/teepzrv
載點二： https://share.weiyun.com/5DHpONl
【影片中操作的軟體版本】
Office 365
【加入頻道會員 - 每月有不定期的會員專屬教學短片喔！👍】
https://tinyurl.com/sxt3d2b
【Papaya 使用的影片剪輯軟體】
Camtasia Studio
Adobe After Effects
【影片中使用的多媒體素材來源】
https://www.flaticon.com
https://www.freepik.com

#Papaya電腦教室 #Excel #XLOOKUP #函數

Show more

Shorts

Giga Chad Charges Cybertruck 🗿⚡️ #gigachad #cybertruck

Giga Chad Charges Cybertruck 🗿⚡️ #gigachad #cybertruck

Motivational speech | motivational Spicer | khan sir motivational video

Motivational speech | motivational Spicer | khan sir motivational video

Grace Charis

Grace Charis

Gigantic squid attacks big squid #fishing #viral #fyp

Gigantic squid attacks big squid #fishing #viral #fyp

Continuous production for decades is the best way to explain oneself.#craft #handmade #clay#art

Continuous production for decades is the best way to explain oneself.#craft #handmade #clay#art

Here's how this one company turns 200,000 luffas into sponges. #luffas #sponges #sustainability

Here's how this one company turns 200,000 luffas into sponges. #luffas #sponges #sustainability

Up next

Autoplay

Advertisement

Advertise With Vidude

0 Comments

Film & Animation Music & Arts Pets & Animals Sports & Outdoors Travel & Events Gaming People & Vlogs Comedy Entertainment News & Politics How-to & Style Design & Creativity Homes & Real Estate Autos & Vehicles Education Science & Technology Fashion & Beauty Cooking & Foodie TV & Drama Products & Reviews Health & Wellbeing Brand & Premieres Documentary Local Business & Services Other