Passionate and pragmatic Software Engineer at the intersection of backend, data engineering, and developer tooling. I’ve started my programming journey more than 8 years ago with a book on learning ...

In this post, we will show you how to grey out unused cells in Excel on a Windows 11/10 PC. When you create a spreadsheet in Excel, it displays thousands of blank rows and columns. While this is ...

Select the cell(s) where you want the text to appear vertically. Go to the Home tab in the top ribbon. In the Alignment group, click the Orientation drop-down arrow. Choose Vertical Text from the list ...

A new COPILOT function in Excel lets you use AI in a formula. The new skill is now available to Microsoft 365 insiders. Reduces some of the complexity involved in creating formulas. Get more in-depth ...

Have you ever stared at a tangled web of Excel formulas, wondering if there’s a better way to make sense of it all? For many, Excel’s LAMBDA function feels like a cryptic puzzle—powerful but ...

Did you know that you can leave notes on specific Excel cells for people to read? It’s a great way to safeguard against data entry mistakes by putting in reminders or instructions. Here’s how to set ...

So if you can’t beat ‘em, how do you join them and use AI to write résumés that stand out in a sea of applications? Résumé writing experts say it’s important to avoid common pitfalls and know when a ...

Have you ever been frustrated by Excel treating blank cells as zeros? It’s a small quirk, but one that can wreak havoc on your data analysis. Whether you’re building financial models, tracking ...

Q. Could you explain how the AGGREGATE function works in Excel? A. AGGREGATE is possibly the most versatile function in Excel. Think of it as an advanced version of the SUBTOTAL function that offers ...