Author: Jiri Krecek
-
Excel: Counting Specific Cells
When working in Excel, many people reach for COUNTIF to tally values, or worse yet, they manually count the cells! Ouch! COUNTIF only works with one condition on one range. What if you need to count cells in one column based on criteria in another column and have two ranges to deal with, such as…
-
Web Design: When the Shiny Buttons Break
I had just finished polishing my article: “Web Design: Why To Own A Website?” The whole point was simple — own your digital presence, don’t rent it from platforms that can change the rules overnight and boot you out. Then came the irony. WordPress offered me a shiny button: “Cross‑publish to Facebook.” Why not? I…
-
Web Design: Why To Own A Website?
In a world where algorithms change overnight and platforms rise and fall, the one thing you can truly own is your website. Social media accounts may feel like enough, but they are rented space — subject to rules, restrictions, and sudden shifts that can erase your visibility in an instant. You do not own the…
-
Bookkeeping: The Work You Love To Hate
There are many things a new or seasoned business owner looks forward to and truly enjoys in their work. Bookkeeping is rarely one of them. It’s mundane, thankless, and often mind‑numbing—yet unavoidable. If you’re a woodworker crafting your next charcuterie board masterpiece, a plumber racing between appointments, or a freelance photographer driving from wedding to…
-
No Green Triangles, Please
Remember those green triangles Excel just looooooves to slap on everything? “Number stored as text” , “inconsistent formula” this, inconsistent formula that, …?Yeah, we’re killing those today. You can go surgical Or you can go nuclear Need Help? Need help streamlining your processes or solving tricky business problems? I offer one-on-one consultations to get you…
-
Excel – Highlight Duplicates
Ever scan a list trying to spot duplicates with your eyes? You may even sort it in ascending order and then go down and look for matches sitting next to each other? Stop torturing yourself. The 10-second fix That is literally it! Every duplicate will light up for you, without confusion, without formulas, without eye…
-
Excel – The Dreaded 15-Digit Limit
If you work in banking, you probably already know about this, but in case you haven’t stumbled upon this hidden limit, try the below experiment with me… Analysts at banks must hate Excel for this I know I did. Don’t believe me? Try this right now: type these numbers into Excel: Then watch what happens…
-
Excel – Filter With Wildcards
The Problem Ever tried to use Excel’s filter and looked for records with specific prefixes, suffixes, strings, or format? It can be maddening, if you have to manually check the boxes for all that meet the criteria, because dirty data can make records show up in the filter more than once (I’m looking at you…
-
Excel – Flash Fill. Like Magic!
The Problem Have you ever taught someone a trick, shown them once, and they immediately got it? Excel’s Flash Fill does exactly that – it watches your pattern and when you say the magic word it applies it to thousands of rows. Instantly. What magic is hiding behind? CTRL+E Excel is smart enough to detect…