New Improved Version of Excel Formula Help


Share on facebook
Share on twitter
Share on linkedin

Good news!!! We have upgraded the excel formula help page to a new, more easily accessible and better laid out page. Now the 50 formulas have been categorized in to 6 areas

Also, each formula has its own easy to remember url. For eg. you need help on countif formula, just type http://chandoo.org/excel-formulas/countif.html

This means, more of you can discover the formulas and help through search and sharing the links.

Remember, you can also buy an easy to read excel formula help e-book for just 5$.

Please spread the word about excel formula help page by stumbling it or tweeting about it or adding it to your delicious bookmarks. You will do me and this blog a very great favor by spreading the word.

Share on facebook
Share on twitter
Share on linkedin

Share this tip with your colleagues

Excel and Power BI tips - Chandoo.org Newsletter

Get FREE Excel + Power BI Tips

Simple, fun and useful emails, once per week.

Learn & be awesome.

Welcome to Chandoo.org

Thank you so much for visiting. My aim is to make you awesome in Excel & Power BI. I do this by sharing videos, tips, examples and downloads on this website. There are more than 1,000 pages with all things Excel, Power BI, Dashboards & VBA here. Go ahead and spend few minutes to be AWESOME.

Read my storyFREE Excel tips book

Chandoo is an awesome teacher

– Jason

Excel formula list - 100+ examples and howto guide for you

100 Excel Formulas List

From simple to complex, there is a formula for every occasion. Check out the list now.

20 Excel Templates

Calendars, invoices, trackers and much more. All free, fun and fantastic.

IRR and data tables in Excel

Using IRR with Data Tables – Modeling Cash-flow Scenarios in Excel

Do you want to simulate multiple cash-flow scenarios and calculate the rate of return? Then this article is for you. In this page, learn how to,

  • Introduction to IRR & XIRR functions
  • Calculate rate of return from a set of cash-flows with XIRR
  • Simulating purchase or terminal value changes with data tables
  • Apply conditional formatting to visualize the outputs
  • Common issues and challenges faced when using XIRR

One Response to “New Improved Version of Excel Formula Help”

  1. Stephen says:

    I inherited an excel worksheet from a co-worker who has left. She has used a ^ in the formula in a way I do not understand. I thought that ^ meant to raise to the power of XXX but here it looks like more a ref point. =D5*($B$71*(1+$B$72)^C4) where row 4 is number of years b4 year 0 c4 year 1 d4 year 2…..year25 row 5 is amount that diminish each year by a small% and b71 and b72 are % if I remove the ^ and cell the result is correct but I get small triangle in top left corner of the cell. Anyone know why the ^ is needed

Leave a Reply