Autoplay
Autocomplete
Previous Lesson
Complete and Continue
ADVANCED EXCEL
Pre-Test
Pre-Test
วิธีการเรียน และ ไฟล์ตัวอย่างระหว่างเรียน
วิธีการเรียน (2:51)
ไฟล์ตัวอย่างระหว่างเรียน
Review Data Types , Custom Formats , Naming Cells
Chapter1-Review Data Types (38:57)
Chapter2-Creating Custom Formats (17:54)
Chapter3-Naming Cells and Lookup Data in Cross-Tab Table (11:22)
Review VLOOKUP
Review VLOOKUP (32:57)
Advanced Functions and Formulas
Chapter4-1 | CHOOSE Functions (16:02)
Chapter4-2 | MATCH and INDEX Functions (42:32)
Chapter4-3 | OFFSET Function (36:18)
Chapter4-4 | INDIRECT (39:37)
Chapter4-5 | VLOOKUP Pictures (4:27)
Chapter5 | Consolidate Data (3:38)
Formula Auditing and Working Across Workbooks
Chapter6-Formula Auditing (6:49)
Chapter7-Working Across Workbooks (9:57)
Advanced Filter
Chapter8-Advanced Filter (20:35)
Review Cell References and Conditional Formatting
Review Cell References (12:53)
Review Conditional Formatting (19:11)
Dynamic Things in Excel
Chapter9-Advanced Conditional Formatting (44:14)
Chapter10-Dynamic Data Managerment with TABLE (18:53)
Chapter11-Form Controls | Creating Interactive Templates (34:47)
Chapter12-Dynamic Charts (28:42)
Macros
Basic Macros (38:42)
Post-Test
Post-Test
Chapter4-2 | MATCH and INDEX Functions
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock