Author: Jiri Krecek
-
Excel: Hidden Gem – LET()
Simplify messy Excel formulas with the LET function. Learn how to tame VLOOKUP chaos and build readable, maintainable spreadsheets.
-
Excel: Absolute vs Relative Reference
Learn the difference between relative and absolute references in Excel. Simple visual examples show when to use $, no confusing math. Plus fun Excel history!
-
Excel: Repeat Table Headers In Print
Transform messy Excel printouts into professional reports. Learn to set print areas, repeat headers across pages, and add polished headers/footers for boardroom-ready documents.
-
What You Don’t Measure Will Control You
There is a moment every leader, owner, or business eventually faces. Not a dramatic one – a quiet one. One day, you look at your process you’ve trusted for years and suddenly realize: “I have no idea how long this actually takes.”or “I don’t know how often this problem really happens.”or“I think I know… but…
-
EXCEL: Find Hidden Blank Values
Ever been handed a spreadsheet by someone that looked like Swiss cheese? Empty cells everywhere, you then tried to apply conditional formatting and all went down South from there? Some cells were truly empty, others contained formulas returning “”. The Problem You are working on a process re-engineering project and need to get your data…
-
Why Your Best Employees Keep Making the Same Mistakes
Ever had that experience when you see something you don’t like and your first reaction is: ” I literally explained to them how to fix it last week, so why is it happening again?” Deja vu. We’ve all lived it. It’s not your people.It’s not laziness.It’s not incompetence.It is process ambiguity. The real problem isn’t…
-
EXCEL: Create a Project Gantt Chart
You may have heard about a Gantt chart while working on a project and if you worked in Microsoft Project then you have definitely seen one too. A Gantt chart’s horizontal bars let you visually track project phases and tasks, and, in this article, we’ll dive into using Excel alone to create such a tracker.…
-
Web Design: Verify Your URL With Mastodon
You may be one of those people who’s grown tired of mainstream social media—Facebook, Instagram, the endless noise—and in your search for something calmer and more human you’ve discovered Mastodon, the open‑source, decentralized social platform. If so, good for you. It’s a refreshing change of pace. If you also happen to run your own website…
-
Excel: Smarter Dropdown
Modern Excel workflows live or die by how cleanly you structure your data and how strongly you enforce referential integrity. Using drop down menus inside Excel cells is one of many ways to achieve this, but keeping up the drop down lists can be tedious. One of the simplest upgrades you can make — and…