Spreadsheets are undeniably powerful. They can come in handy for all sorts of applications like tracking and forecasting cash flow, creating loan amortization schedules, analyzing sales data, and even ...

It’s the end of the month, and you’re staring at a mountain of Excel spreadsheets that need updating. You sigh, knowing that hours of tedious work lie ahead. But what if I told you there’s a way to ...

If you ever wanted to click a magic button and make complex business tasks happen automatically, macros can make that wish come true. Macros are small programs that execute commands you specify. Write ...

While Microsoft Excel is one of the most powerful spreadsheet applications, it’s also the most intimidating tool in the Microsoft Office suite. If you’ve never used Excel before or are just a bit ...

I recently wrote about five ways spreadsheets kill your business. Spreadsheets are a versatile tool for performing quick, ad hoc data analysis, developing presentation materials, creating small ...

Fifteen years ago, I logged my concerns about the limitations of Excel. Have we overcome these problems? Has the downside of spreadsheets been reduced? A deeper look sees progress in some areas - and ...