Excel Skills Directory
Browse our comprehensive collection of Excel skills. From beginner fundamentals to advanced techniques.
VLOOKUP
Formulas
Search for a value in the first column of a range and return a value in the same row from another column.
XLOOKUP
Formulas
The modern, powerful alternative to VLOOKUP – faster, more flexible, and error-resistant.
Pivot Tables
Data Analysis
Create dynamic summary tables to analyze and explore your data interactively.
Conditional Formatting
Formatting
Apply formatting to cells based on their values to highlight important information.
INDEX-MATCH
Formulas
A more flexible alternative to VLOOKUP for looking up values in any direction.
Power Query
Data Analysis
Connect to, combine, and refine data from multiple sources.
Charts & Graphs
Visualization
Visualize your data with various chart types for better insights.
SUMIF & SUMIFS
Formulas
Sum values based on one or multiple criteria.
Dropdown Lists
Data Management
Create professional selection lists for fast and error-free data entry.
Data Validation
Data Management
Control what data can be entered into cells to maintain data quality.
Macros & VBA
Automation
Automate repetitive tasks with recorded macros and VBA programming.
Need Help with a Specific Skill?
Ask our AI assistant for personalized guidance and instant answers to your Excel questions.
Ask AI Assistant