Excel Advanced Advanced Excel Tasks
ADVANCED Advanced Excel Tasks
Work with array formulas lookup and advanced functions linked and consolidated data hyperlinks and shared workbooks.
Advanced Excel Tasks Overview
This topic brings together array formulas lookup and advanced functions linking and consolidating data hyperlinks and shared workbook tasks.
The course source combines several advanced worksheet techniques that support calculation lookup data integration navigation and collaboration.
Essential Terms
Review important terminology for the advanced tasks in this topic.
Array Formulas and VLOOKUP
Work with basic array formulas functions within arrays IF and IFERROR then use VLOOKUP for exact approximate and array based lookup tasks.
Advanced Functions
Use INDEX and MATCH individually or together and apply logical AND OR and nested logical functions.
INDEX and MATCH
Use INDEX and MATCH and combine the two functions for advanced lookup tasks.
Logical Functions
Use AND and OR to evaluate logical conditions.
Nested Logic
Use nested logical functions such as IF with OR and AND.
Link Consolidate and Combine Data
Connect information across workbook and worksheet structures using the techniques specified in the course source.
Hyperlinks and Shared Workbooks
Create and manage hyperlinks then work with shared workbooks including tracking changes and resolving conflicts.
Interactive Advanced Task Explorer
Explore the six major topic areas included in this part of the course.
Key Takeaways
Advanced Excel work combines formulas lookup techniques data connections navigation and collaboration tools.
Array formulas VLOOKUP INDEX MATCH logical functions linking consolidation hyperlinks and shared workbooks each solve a different advanced worksheet task.
Shared workbook work includes opening and editing a shared workbook tracking changes and resolving conflicts.
Knowledge Check
Test your understanding of the advanced Excel tasks in this topic.