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 |

Just wanted to say thank you - I have wasted so much time doing manual time calculations in Excel and then found your website and now its all done with formulas automatically. So clear and easy to understand!

Nick

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