Marco Marzaduri: digital productivity
I am Marco Marzaduri (Marco Roberto Maria Marzaduri) and I work in computing: cybersecurity, digital forensics and web development. Here I collect the methods I use every day to work better with a computer: spreadsheets that do not break, small automations that save hours, files and folders you find at the first attempt, clear documents.
Every article starts from a concrete office problem and solves it step by step, with a real example and a final summary worth keeping at hand.
What I write about here
- Spreadsheets: formulas, lookups, pivot tables and charts.
- Automation: macros, scripts and repetitive flows.
- Digital organisation: files, email, passwords and backups.
- Writing & documents: Markdown, LaTeX, PDF and presentations.
Report – Rai 3
In 2017 I appeared in the Italian investigative programme Report (Rai 3), in the episode “Un italiano a Panama”. The excerpt is on my YouTube channel.
My other sites
My professional website is marzaduri.com; digital forensics and security on marzaduri.org; web development and networks on marzaduri.net; programming, cloud and data on marcomarzaduri.com; systems, hardware and devices on marcomarzaduri.org.
Topics
- Spreadsheets — Formulas, lookup functions, pivot tables, validation and charts in Excel, LibreOffice and Google Sheets.
- Automation — Macros, Python scripts for files and PDFs, no-code automations and repetitive flows to hand over to the computer.
- Digital organisation — Folders, file names, email, calendar, notes, passwords and personal backups kept in order.
- Writing & documents — Markdown, LaTeX, PDF, templates and styles, technical documentation and effective presentations.