> For the complete documentation index, see [llms.txt](https://www.indiainvestments.wiki/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://www.indiainvestments.wiki/excel.md).

# EXCEL

- [Excel for Fun and Profit](https://www.indiainvestments.wiki/excel/index.md): Intro to excel calculators and spreadsheets, and how to use them for your finances
- [Reactive UI & Updates](https://www.indiainvestments.wiki/excel/reactivity.md): Reactive UI : Data Chaining and Updates in Excel with Formula and Functions
- [Using External Data : Google Finance](https://www.indiainvestments.wiki/excel/using-external-data-google-finance.md): Fetching data for ticker(s) using GOOGLEFINANCE() function in Google Spreadsheet
- [Using External Data : Working with CSV Format](https://www.indiainvestments.wiki/excel/using-external-data-working-with-csv-format.md): A close look at how to parse CSV data dumps and process the same in your excel sheet or spreadsheet
- [CSV Format](https://www.indiainvestments.wiki/excel/using-external-data-working-with-csv-format/csv-format.md): Closer look at CSV format, and how to operate on these to display in a table format, using SPLIT() and TRANSPOSE() functions
- [Computing LTCG Eligible Equity Units](https://www.indiainvestments.wiki/excel/using-external-data-working-with-csv-format/computing-ltcg-eligible-equity-units.md): Step-by-step guide on how to compute equity units eligible for LTCG taxation, if redeemed, using Spreadsheet
- [Process for Estimating Tax](https://www.indiainvestments.wiki/excel/using-external-data-working-with-csv-format/process-for-estimating-tax.md): A peek into tax estimation process for redeeming units that are outside STCG zone
- [Quantifying Returns: CAGR and XIRR](https://www.indiainvestments.wiki/excel/quantifying-returns-cagr-and-xirr.md): How to do returns in excel or spreadsheet? Read along to find out
- [CAGR: Point-to-Point Annualized Returns](https://www.indiainvestments.wiki/excel/quantifying-returns-cagr-and-xirr/cagr.md): We'll take a look at what CAGR is, how it works, and how we can compute CAGR of various listed assets.
- [A Gentle Introduction to XIRR](https://www.indiainvestments.wiki/excel/quantifying-returns-cagr-and-xirr/xirr.md): What is XIRR? How can I use it to make financial decisions? What affects XIRR in a good way and a bad way? Find answers to these queries here
- [A Rigorous Introduction to XIRR](https://www.indiainvestments.wiki/excel/quantifying-returns-cagr-and-xirr/xirr-math.md): Mathematical formulation of XIRR, discounted cashflows, NPV, and decay.