AS
Aman's Blog
Docs Tutorials References Exercises Shop About Me
Docs Tutorials References Exercises Shop About Me
AI Tools FFmpeg Excel Python SQL PowerBI Vim Bash/Zsh CLI Tools LaTeX Perl Movies Finance Android
MacOS Windows ICSE CBSE IITJEE NEET
Tools
Advanced Formulas
INDEX & MATCH: The Dynamic Duo
Analysis
Pivot Tables Explained Solving Backwards with Goal Seek Scenario Analysis with Data Tables
Formulas
Mastering VLOOKUP The Power of XLOOKUP
Functions
Logical Functions: IF & AND VLOOKUP Masterclass
Fundamentals
Absolute vs Relative References Navigating the Excel Interface
Resources
Developer Tools

Free Courses

Master Excel, PowerBI, and Bash with my free comprehensive courses.

Enroll Now

Excel

Mastering VLOOKUP

Jan 20, 2025 8 min Beginner

Pivot Tables Explained

Feb 14, 2025 15 min Advanced

Logical Functions: IF & AND

Feb 1, 2025 10 min Intermediate

Solving Backwards with Goal Seek

Jan 24, 2025 5 min Beginner

Scenario Analysis with Data Tables

Jan 23, 2025 7 min Intermediate

Absolute vs Relative References

Jan 14, 2025 8 min Beginner

Navigating the Excel Interface

Jan 11, 2025 5 min Beginner

VLOOKUP Masterclass

Dec 4, 2024 12 min Intermediate

The Power of XLOOKUP

Jan 21, 2025 6 min Intermediate

INDEX & MATCH: The Dynamic Duo

Jan 22, 2025 10 min Advanced