Alex Taylor (@Allr)

Create Array and R1C1 Formulas in Excel with Python

Most formulas address a single cell at a time: =A1+A2 refers to two coordinates and lives in a third. An array formula is different — it treats a whole block of cells as input and writes its result in

2d ago · 7 min readallr.hashnode.dev

How to Group and Outline Data in Excel with Python

A project plan usually carries two different levels of information at once: the phases, and the tasks inside each phase along with their owners and durations. Flattened into one list, the reader has t

3d ago · 6 min readallr.hashnode.dev

How to Format Long Text in Excel Cells Using Python

Every exported report has one or two columns that refuse to stay in their place: order notes, error logs, product descriptions. By default the text runs sideways, either spilling over the neighbouring

6d ago · 6 min readallr.hashnode.dev

How to Create and Format Lists in Word Documents Using Python

A runbook needs numbered steps. A requirements checklist reads better with bullets. A specification document usually wants a hierarchy such as "1. Overview / 1.1 Background / 1.1.1 Scope". In Word thi

6d ago · 6 min readallr.hashnode.dev

Identify and Highlight Duplicate and Unique Data in Excel with Python

When registration forms from several channels are merged, a repeated email address usually means someone submitted twice. When an inventory list is reconciled, a duplicated product code means the ledg

Oct 16 · 5 min readallr.hashnode.dev

Alex Taylor

About

Available for

Alex Taylor's blogs

Create Array and R1C1 Formulas in Excel with Python

How to Group and Outline Data in Excel with Python

How to Format Long Text in Excel Cells Using Python

How to Create and Format Lists in Word Documents Using Python

Identify and Highlight Duplicate and Unique Data in Excel with Python

Alex Taylor

About

Available for

Alex Taylor's blogs

Create Array and R1C1 Formulas in Excel with Python

How to Group and Outline Data in Excel with Python

How to Format Long Text in Excel Cells Using Python

How to Create and Format Lists in Word Documents Using Python

Identify and Highlight Duplicate and Unique Data in Excel with Python

Alex Taylor

About

Available for

Alex Taylor's blogs

Create Array and R1C1 Formulas in Excel with Python

How to Group and Outline Data in Excel with Python

How to Format Long Text in Excel Cells Using Python

How to Create and Format Lists in Word Documents Using Python

Identify and Highlight Duplicate and Unique Data in Excel with Python

Search Hashnode

Alex Taylor

About

Available for

Alex Taylor's blogs

Create Array and R1C1 Formulas in Excel with Python

How to Group and Outline Data in Excel with Python

How to Format Long Text in Excel Cells Using Python

How to Create and Format Lists in Word Documents Using Python

Identify and Highlight Duplicate and Unique Data in Excel with Python