Topic area
Formulas & Excel logic
Writing formulas from Python, reading their results, and replacing them with code.
Topics in formulas & excel logic
Each topic page gathers every guide, how-to, comparison and fix on its subject.
- Formulas in workbooksWriting formulas with openpyxl, reading cached results, named ranges and recalculation.
- Excel functions in pandasSUMIF, COUNTIF, IF, INDEX MATCH, LEFT/MID and friends, translated function by function.
- Python in ExcelThe =PY() formula: referencing ranges with xl(), returning DataFrames and plotting in cells.
Formulas in workbooks
- GuideWorking with Excel Formulas in Python
- How-toStore Formula Results with xlsxwriter So Every Viewer Shows Values
- How-toAdd SUM and AVERAGE Formulas with Python
- How-toAudit Every Formula in a Workbook with Python
Excel functions in pandas
- GuideExcel Formula Equivalents in pandas
- How-toApproximate-Match VLOOKUP for Tiered Rates in pandas
- How-toAVERAGEIFS, MAXIFS and MINIFS Equivalents in pandas
- How-toCHOOSE, SWITCH and IFS Equivalents in pandas
Python in Excel
- GuideUsing Python in Excel
- How-toClean Data with pandas in Python in Excel
- FixFix Python in Excel Errors
- How-toForecast a Time Series with Python in Excel
Other areas