Excel Function Collections

Collections group Excel functions by topic to help you understand formulas in context instead of learning them in isolation. Rather than scrolling through long alphabetical lists, collections allow you to focus on a specific problem area—such as data analysis, text cleaning, financial calculations, or lookup logic.

Each collection brings together the most relevant Excel functions for a particular use case and explains why and when they are typically used. This makes it easier to build a mental model of how functions work together in real spreadsheets, not just how they look in syntax.

Pick a collection below to explore detailed explanations and a curated list of Excel functions that are commonly used for that topic.