When is a database not a database? When it is a spreadsheet. What do spreadsheets have to do with databases do you ask? Spreadsheets are actually very rudimentary databases and, while not advisable, ...

Excel’s familiarity meets database power Excel is a tool that a vast majority of business users are comfortable with. They are already familiar with sorting, filtering, and basic formulas.

When you want to organize, sort, and perform basic analysis on a lightweight database, full-fledged database software seems like overkill and expensive. Here is where Excel can step in to save the ...

Charts and sparklines are powerful data visualization tools in Excel. Here’s a guide to the most popular chart types in Excel and how to best use them.

I consider myself an Excel poweruser. I program in it daily (20ish hours a week) and manage a few thousand lines of code for my personal use (stocks and finance). Outside of Excel, I know very ...