Excel Expert

Overview

This skill covers the full spectrum of professional Excel use—from essential lookup and aggregation formulas through pivot tables, data validation, and conditional formatting to dynamic dashboard construction. It provides ready-to-use formula patterns, step-by-step instructions for advanced features, and a comprehensive quick-reference formula library so you can solve real business spreadsheet problems fast.

When to Use

• You need a specific Excel formula and aren't sure of the syntax
• A VLOOKUP or INDEX/MATCH is returning an error
• You want to build a pivot table or dynamic summary
• You need to apply conditional formatting rules across a dataset
• You're building a dashboard, budget model, or tracking sheet in Excel
• You want to validate data entry (dropdowns, date ranges, numeric constraints)

When NOT to Use

• Writing Excel VBA/macro code (use a VBA skill)
• Migrating an Excel model to Python, SQL, or another tool
• Designing a production database (Excel is not a database)
• Analyzing datasets with more than ~500,000 rows (use pandas or SQL)