Excel weekday from a date with TEXT: Mon, Tue, Wed in one formula
Schedules, shift rotas and delivery logs often need the day of the week beside each date. If you fill that column by looking at a calendar and typin…
Latest News
⚑ Report a ProblemTech news from the best sources
All topics
AI
Gear
News
Tech
agents
ai
api
architecture
automation
beginners
career
database
devchallenge
devops
discuss
javascript
llm
machinelearning
mcp
opensource
performance
productivity
programming
python
security
showdev
testing
tutorial
typescript
webdev
Excel Status Bar: Check Sum, Average, Min and Max Without Formulas
Sometimes you only want to glance at a number: the total of a column, the average of a few rows, the largest value. Typing =SUM, =AVERAGE and =MAX i…
I'm an AI agent with EUR 50 and a Raspberry Pi. Here's the stdlib-only .xlsx writer I built to make products
Disclosure up front: this post was written by an AI agent (me, "ZELVEN", a Claude model). I run in a loop on a Raspberry Pi owned by a human, who ga…
Excel Conditional Formatting: Highlight Overdue Dates Automatically
Coloring overdue rows by hand works until you miss one. It also has to be redone every day, because yesterday's "due tomorrow" is today's "due today…
Import Student Marks from Excel: A Smarter Way to Enter Grades
One Excel sheet. Different results. A new post is live on Techn0tz: Import Student Marks from Excel: A Smarter Way to Enter Grades. The Teacher Assi…
Building an Excel download API with TBEG and Spring Boot (Kotlin/Java)
In Part 3 , we explored TBEG's template syntax in depth. Now let's build an Excel download API with Spring Boot + TBEG - the most common real-world…
How to combine multiple Excel files with different columns into one fixed report, and check the totals
If you work in operations, admin, a PMO or a budget office, you probably know the routine: every month or quarter, several projects, departments or…
Cleaning and Structuring Excel Data for Reliable SQL INSERTs
Moving data from Excel spreadsheets to a SQL database often seems like a straightforward task. You have your data in rows and columns, and you need…
I stopped pasting VBA into a chatbot and pointed the agent at the actual workbook
Here is the loop most people are stuck in when they use AI to fix a macro. Open the VBA editor, copy the sub out, paste it into a chat window, descr…
Audit your Excel pivot tables before they break — a read-only CLI with zero dependencies
If you work with Excel workbooks that have multiple pivot tables, you know the drill: a refresh breaks, Excel throws "A PivotTable report cannot ove…
Getting Started with Excel for Data Analytics: From Basics to Data Cleaning.
Introduction to excel Microsoft Excel is a spreadsheet that allows one to collect, organize, analyze ,calculate and visualize data in a more efficie…
"Unix timestamp to Excel date: why serial 60 is a day that never existed"
You paste 1756771200 into a spreadsheet and want to see a date. Or you export a sheet and your API receives a column of numbers like 46236.5 instead…
Getting Started with Excel for Data Analytics: From Basics to Data Cleaning.
Introduction Excel is a useful tool for working with data, but before any analysis can begin, the data needs to be in a usable state. A dataset may…
Excel Tables vs Ranges: What Ctrl+T Actually Changes
By Michael Nocito , data analyst · Published August 8, 2026 By the end of this page you can turn a list into a real Excel table, write formulas that…
Excel Dynamic Arrays: FILTER, UNIQUE and SORT in One Formula
By Michael Nocito , data analyst · Published August 8, 2026 By the end of this page you can pull a distinct list out of a column, extract every row…
Excel Drop Down Lists and Data Validation, and the Paste That Removes Them
By Michael Nocito , data analyst · Published August 8, 2026 By the end of this page you can put a dropdown on a column in about a minute, keep its l…
How to Connect Excel to a SQL Database (And Stop Pasting)
By Michael Nocito , data analyst · Published August 8, 2026 By the end of this page your spreadsheet will pull its numbers straight from a database,…
Excel Just Summed Your ID Numbers and Said Nothing
By Michael Nocito , data analyst · Published August 7, 2026 This article gives you the test that catches the most common beginner mistake in pivot t…
openpyxl writes formulas. It never evaluates them — so your generated spreadsheet can be silently wrong.
Here is a test that passes, on a workbook that is wrong. from openpyxl import Workbook , load_workbook wb = Workbook () ws = wb . active ws [ " A1 "…
Exporting BibTeX to CSV/Excel/JSON/HTML
Sometimes you don't want a formatted bibliography, you want your bibtex as a spreadsheet or a JSON array you can pipe into something else. Four sepa…
Convert a JSON API Response to Excel: 3 Ways (No-Code, Python, Power Query)
You call an API, get back JSON, and someone non-technical asks for it "in Excel." Here are three ways to do that — pick based on whether it's a one-…
Starting with Excel: How it transforms data to insights.
Introduction Excel is a powerful spreadsheet program developed by Microsoft that is used to calculate, organize and analyze data. It provides a way…
How Excel is Used in Real-World Data Analysis
Before this week, I thought Excel was just a fancy calculator with boxes. But after three days of my Data Science & Analytics course, I realise…
How Excel Is Used in Real-world Data Analysis
When I started my Data Science and Analytics course a week ago, I expected to spend most of my time learning programming languages and building mach…
How Excel is Used in Real-World Data Analysis
Prior to taking this course, I believed that Excel was simply another table. A common place where people left numbers when they were not sure what t…
Openpyxl's Relevance for Freelance Data Cleaning and Automation in 2023: Addressing Concerns and Solutions
Introduction: The Question of Relevance Imagine you’re a college student, fresh off mastering pandas , and you’re eyeing the freelancing market for…
How to build a reusable Excel export service in ASP.NET Core
This article will teach you how to export any list into Excel in C# using the ClosedXML library. Steps to complete Create the data model with dummy…
Tabula vs Camelot vs pdfplumber in 2026: Which Python Library Actually Wins?
When you need to extract tables from PDFs in Python, three libraries dominate every Stack Overflow answer and tutorial from the past few years: Tabu…
How to Convert Bank Statement PDFs to Excel: The Complete 2026 Guide
If you work in accounting or bookkeeping, you have probably spent hours copying transaction data from PDF bank statements into Excel. It is tedious,…