Beginner's Guide to Microsoft Excel
Using Index Match and HLookup
Beginner's Guide to Microsoft Excel
0%
Completed
المحتوى
Introduction to Microsoft Excel
Video - 11:32 mins
Getting Started with Excel
Video - 11:32 mins
Organizing Your Data in Excel
Video - 11:32 mins
Essential Excel Formulas for Beginners
Video - 11:32 mins
Utilizing the IF Function in Excel
Video - 11:32 mins
Creating Pivot Tables in Excel
Video - 11:32 mins
Text Functions in Excel
Video - 11:32 mins
Understanding Cell References in Excel
Video - 11:32 mins
Using Text to Columns in Excel
Video - 11:32 mins
Mastering Paste Special and Speak Cells
Video - 11:32 mins
Creating Custom Lists in Excel
Video - 11:32 mins
Exploring Flash Fill in Excel
Video - 11:32 mins
Using Nested IF and Logical Functions
Video - 11:32 mins
Adding Comments and Custom Views
Video - 11:32 mins
Creating Charts and Graphs in Excel
Video - 11:32 mins
Using the DATE Function in Excel
Video - 11:32 mins
Rotating Text and Printing in Excel
Video - 11:32 mins
Inserting Headers and Footers in Excel
Video - 11:32 mins
Implementing Data Validation in Excel
Video - 11:32 mins
Recording Macros in Excel
Video - 11:32 mins
Understanding Relative References in Excel
Video - 11:32 mins
Creating Macros in Excel
Video - 11:32 mins
Naming Arrays in Excel
Video - 11:32 mins
Using VLOOKUP in Excel
Video - 11:32 mins
Understanding VLOOKUP Rules
Video - 11:32 mins
Consolidating Data in Excel
Video - 11:32 mins
Counting Functions in Excel
Video - 11:32 mins
Single Criteria Statistical Functions
Video - 11:32 mins
Multiple Criteria Statistical Functions
Video - 11:32 mins
Using Index Match and HLookup
Video - 11:32 mins
Protecting Worksheets in Excel
Video - 11:32 mins
Creating Hyperlinks in Excel
Video - 11:32 mins
Sorting Data in Excel
Video - 11:32 mins
Filtering Data in Excel
Video - 11:32 mins
Advanced Filtering Techniques in Excel
Video - 11:32 mins
Chart Shortcuts in Excel
Video - 11:32 mins
Creating Combo and Pie Charts
Video - 11:32 mins
Using Sparkline Charts in Excel
Video - 11:32 mins
Creating Pivot Charts in Excel
Video - 11:32 mins
Conditional Formatting Basics
Video - 11:32 mins
Advanced Conditional Formatting Techniques
Video - 11:32 mins
Using Icon Sets in Conditional Formatting
Video - 11:32 mins
Advanced Conditional Formatting Formulas
Video - 11:32 mins
Customizing Pivot Tables - Part 1
Video - 11:32 mins
Customizing Pivot Tables - Part 2
Video - 11:32 mins
Using Slicers in Pivot Tables
Video - 11:32 mins
Slicers and Timelines in Pivot Tables
Video - 11:32 mins
Creating Dependent Dropdown Lists
Video - 11:32 mins
Generating Summary Reports in Excel
Video - 11:32 mins
Understanding Objects in Excel
Video - 11:32 mins
Tables vs. Cell Ranges in Excel
Video - 11:32 mins
Using Slicers on Charts
Video - 11:32 mins
Creating Linked Objects in Excel
Video - 11:32 mins
Excel Ctrl Shortcuts
Video - 11:32 mins
Function Keys Shortcuts in Excel
Video - 11:32 mins
Alt Key Shortcuts in Excel
Video - 11:32 mins
Shift Function Key Shortcuts in Excel
Video - 11:32 mins
Ctrl Function Key Shortcuts in Excel
Video - 11:32 mins
Alt and Shift Shortcuts in Excel
Video - 11:32 mins
Free Online Excel Training for Beginners
Video - 11:32 mins
Excel VBA Tutorial for Beginners | Excel VBA Training | FREE Online Excel VBA course
Video - 11:32 mins
Microsoft Excel Tutorial for Beginners | The Beginner s Guide to Excel | Excel Basics Tutorial
Video - 11:32 mins
Excel VBA Full Course | Excel VBA Tutorial For Beginners | Learn Excel VBA In 10 Hours
Video - 11:32 mins
Final Exam - Beginner’s Guide to Microsoft Excel
Quiz
Final Exam - Beginner’s Guide to Microsoft Excel
Quiz
Final Exam - Beginner’s Guide to Microsoft Excel
Quiz
More
Announcements
Reviews
Course Info
Learn how to use Index Match and HLookup for advanced data retrieval techniques in Excel.
Sign in
Sign up
Sign in
Don’t have an account?
Sign up
Remember me
Lost your password?
Sign up
Already have an account?
Sign in
