How to Benefit From Excel and ERP Software

Pivot Tables

It is pretty normal for many small businesses that don’t have a purpose-built system to manage different aspects of their operations such as inventory and sales completely separately. It’s easy enough to manually track inventory when you only have so much on hand. These small businesses typically use QuickBooks as introductory accounting software and Excel … Read more

Is Excel a Good Inventory Program?

Excel for Inventory Management

Many small businesses use Microsoft Excel spreadsheets to manage their inventory and other areas of their business, most often because they lack more sophisticated software systems.  This is not uncommon and can work for very small businesses just starting out – Excel is an excellent business tool and can be used in many situations.  However, … Read more

Break-up with Spreadsheets for Accounting and Inventory Software

Small to medium size businesses are becoming more confident in their ability to compete against larger competitors thanks to new technology helping to level the playing field. Chatbots, machine learning, AI and voice command tools are providing opportunities for small businesses to reach more customers and improve processes without the need to hire highly qualified … Read more

Life’s a Slice(r) with Excel 2010

As discussed in a previous post, Excel Pivot Tables are powerful tools for analyzing and reporting on data from your accounting software package, and other business data sources. Starting back with Office 2010, Excel released a new feature that takes Pivot Tables a step further: the Slicer – which allows you to slice and dice an existing … Read more