The recent announcement from Microsoft that they have now integrated Python into it’s Excel spreadsheet software has opened up a wealth of new applications for data analytics, automation and number ...

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 ...

A decade ago, Ben Collins quit his job as a corporate accountant and started teaching other people how to use spreadsheets more effectively. That move, terrifying as it seemed at the time, paid off ...

Unlocking a super power I never bothered to learn.

In the world of data management, small businesses often face a critical decision: should they use spreadsheets like Microsoft Excel or Google Sheets, or should they invest in a more complex database ...

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 ...

One option for sharing reports with your team is to simply rattle off numbers. Think something like this: "We allocated 10% of operating budget to maintenance, 15% to hardware upgrades, 18% to ...

Many people know how time-consuming it can be to convert handwritten notes into an Excel spreadsheet, entering data can sometimes take people hours. However, with this specific Microsoft feature, you ...

With all the new programs, applications and devices being released on an almost daily basis, the spreadsheet's story and its legacy as a powerhouse could be lost. The story of the electronic ...