Shortcut is the superhuman AI agent for Excel. Automate spreadsheet tasks, generate formulas instantly, and build LBOs, DCFs, and 3-statement models in minutes. Save 10-15 hours per week on finance and spreadsheet work with AI-powered Excel automation.

Tenno is an app that lets you create powerful dynamic documents where you can easily add and orchestrate computational elements. You can think of it as a mix between Word and Excel with a sprinkle of Javascript. You could also think of it as a more interactive and user friendly version of Jupyter notebooks. With Tenno you can build formulas like you do in spreadsheets, you can create charts, but you can also easily call APIs and mix and match everything. Tenno has an interactive live mode, where you see changes as you type, allowing for a very quick iteration loop. If you are into literate programming, Tenno could be something for you.

MarkItDown is a utility for converting various files to Markdown (e.g., for indexing, text analysis, etc). It supports:

In email correspondence seen by Retraction Watch and a follow-up Zoom call, Heshmati told the student he had used Excel’s autofill function to mend the data. He had marked anywhere from two to four observations before or after the missing values and dragged the selected cells down or up, depending on the case. The program then filled in the blanks. If the new numbers turned negative, Heshmati replaced them with the last positive value Excel had spit out.

If some cells, rows, or columns on a worksheet do not appear, you have the option of copying all cells—or only the visible cells.

Glide Data Grid is a no compromise, outrageously fast data grid for your React project, with rich rendering and TypeScript support.

Duplicates: =COUNTIF($A$2:A2,A2)

Uniques: =IF(COUNTIF(A$2:A2,A2)=1,MAX(B$1:B1)+1,VLOOKUP(A2,A$1:B1,2,0))

Article that describes the steps to generate the code in MS Excelwithout using any Visual Basic or other scripting.

jXLS is a small and easy-to-use Java library for writing Excel files using XLS templates and reading data from Excel into Java objects using XML configuration.

A website for people who need to work with Excel files in Python