- 提示:
- 透過本站連結購買Udemy課程，本站將獲得推廣佣金，有助未來提供更多實用進修課程資訊給讀者。
課程資料
報名日期*
全年招生
課程級別
學習模式
修業期
1 小時 22 分鐘
教學語言
英語
授課導師
Chase Raz, M.B.A.
證書
- 可獲發
- (證書的發放與分配，依課程提供者的政策及安排而定。)
評分
*提示: 以上時間表僅供參考，以機構網站為準。
課程簡介
Learn to use some of the most popular Excel functions for tabular lookups. Learn VLOOKUP, HLOOKUP, and LOOKUP functions.
VLOOKUP is one of the most requested Excel function tutorials that I've received in over eight years of providing corporate training in Microsoft Excel. All too often, professional Excel users get caught up in inefficient and problematic workflows, and nested conditionals (nested IF statements) are certainly towards the top of the list. Learn to solve this, and other problems, by utilizing the VLOOKUP, HLOOKUP, and LOOKUP functions.
Some of the abilities you'll gain by understanding these functions are:
Eliminate nested conditional (IF) statements
Pull data from disjointed or broken tables
Allow for autofill even when a reference table is transposed
Create scalable drop-down validation lists
課程章節
- 7 個章節
- 17 堂課
- 第 1 章 Introduction
- 第 2 章 Excel Functions
- 第 3 章 VLOOKUP
- 第 4 章 HLOOKUP
- 第 5 章 LOOKUP
- 第 6 章 Data Validation
- 第 7 章 Conclusion
課程內容
- Replace lengthy nested IF functions in Excel spreadsheets
- Return information associated with a lookup value from a table
- Identify the location of a lookup value within a table
此課程所涵蓋的技能
評價
-
RRoberta Fraine
amazing program helped me understand the lookup funtions better
-
DDerrick Voss
Not yet finished
-
AAndrew Wood
Has given me a much better understanding of how all the different lookup functions work. Great stuff!!
-
VVeronica Gonzales
hey!!! what's going on with the technology...video keeps freezing AND I'm barely in the beginning of the intro course :(
