Over 500 working Excel formulas with detailed explanations, videos, and related links. Includes key functions like VLOOKUP, XLOOKUP, INDEX & MATCH, FILTER, RANK, ROUND, AVERAGE, COUNTIFS, SUMIFS, UNIQUE, SORT, TEXTSPLIT, and more.

Formula | Related Functions |
---|---|

Rank function example | RANK |

Rank if formula | COUNTIFS RANK |

Rank race results | RANK |

Rank values by month | LARGE INDEX MATCH TEXT IF |

Rank with ordinal suffix | CHOOSE ABS MOD |

Rank without ties | RANK COUNTIF |

I wanted to thank you for your site. I used it heavily when I started working at internships in college and I am now a PhD student who still finds her way back on the site for help. I really appreciate how straightforward and helpful your content is.

Melissa

Learn Excel with high quality video training. Our videos are quick, clean, and to the point, so you can learn Excel in less time, and easily review key topics when needed. Each video comes with its own practice worksheet.

View Paid Training & Bundles