5.10. Problems with VLOOKUP | XLLEARNER

Autoplay
Autocomplete

Previous Lesson Complete and Continue

Excel Essentials

Section 1: Introduction

1.1. Introduction (1:33)
1.2. How to Use Platform for Best Learning Experience (1:32)
1.3. Work Files for Download
1.4. Work Files for Download-older version (Excel 97-2003)

Section 2: Getting Started with Excel

2.1. What is Excel (2:10)
2.2. Understanding Workbooks and Worksheets (3:01)
2.3. Navigation Through Worksheet (5:05)
2.4. Quick Access Toolbar and Ribbon Menu (4:01)
2.5. Shortcut Menus and Mini Toolbar (2:18)
Section 2 Practice Files
Section 2 Quiz

Section 3: Entering Data to Excel

3.1. Data Entry Editing and AutoFill (4:43)
3.2. Flash Fill (1:57)
3.3. Dates and Times (5:16)
3.4. Undo Redo Save and Save As (4:41)
3.5. Rows and Columns Insert Delete Hide and Unhide (7:54)
3.6. Moving Copying and Deleting Data (4:12)
3.7. Finding and Replacing Data (3:31)
Section 3 Practice Files
Section 3 Quiz

Section 4: Formatting

4.1. Font Styles Colors and Effects (3:33)
4.2. Borders and Background Color (5:51)
4.3. Row Heights and Column Widths (3:42)
4.4. Alignment Wrap and Merge (4:50)
4.5. Formatting Numbers and Dates (6:28)
4.6. Conditional Formatting (4:27)
Section 4 Practice Files
Section 4 Quiz

Section 5: Formulas and Functions

5.1. Introductions to Formulas and Functions (5:45)
5.2. Relative Absolute and Mixed References (4:36)
5.3. SUM and AVERAGE (2:05)
5.4. Statistical Functions MIN MAX (4:00)
5.5. IF and Nested IF (4:41)
5.6. COUNT COUNTA (4:27)
5.7. SUMIF AVERAGEIF (4:41)
5.8. ROUND (2:45)
5.9. VLOOKUP (6:08)
5.10. Problems with VLOOKUP (3:56)
5.11. XLOOKUP (3:11)
5.12. RAND (3:13)
5.13. CONCAT (2:15)
5.14. Text Functions 1 (4:47)
5.15. Text Functions 2 (4:16)
5.16. New Text Functions (2:49)
5.17. Date and Time Functions (2:10)
5.18. What Next With Formulas (1:20)
Section 5 Practice Files
Section 5 Quiz

Section 6: Adjusting Worksheet Views and Layout

6.1. Printing (3:32)
6.2. Freezing and Splitting (4:36)
Section 6 Practice Files
Section 6 Quiz

Section 7: Managing and Analyzing Data

7.1. Sorting Data (3:33)
7.2. Using Filters (3:19)
7.3. Pivot Tables (3:38)
7.4. Tables (3:42)
7.5. Text to Columns and Removing Duplicates (3:14)
7.6. Charts (3:29)
Section 7 Practice Files
Section 7 Quiz

Section 8: Other operations with Worksheets

8.1. Renaming Inserting and Deleting Sheets (3:15)
8.2. Moving Copying and Grouping Sheets (2:36)
8.3. Protecting Worksheets and Workbooks (2:29)
Section 8 Practice Files
Section 8 Quiz

Section 9: Conclusion

9.1. What Next (1:01)

Teach online with

5.10. Problems with VLOOKUP

Complete and Continue