Business Automation and Software Blog

Excel Tips and Tricks: Rank Function

Posted by Robert Baran on Fri, Nov 02, 2012 @ 09:46 AM

Excel Tips and Tricks / Business Reporting Question: How do I return the rank of a number in a list of numbers relative to other values in a list?

Read More

Topics: Business Reporting, Excel Tips and Tricks

Improve Supply Chain Inventory Control and Warehouse Efficiency

Posted by Nicole Sherman on Wed, Oct 31, 2012 @ 10:52 AM

Manufacturing and distribution companies are constantly challenged to improve the quality and delivery of their products, in addition to improving service to their customers. As businesses continue to grow and change, executives need to keep a close eye on the operational efficiency of the company. By closely examining operational capabilities as they relate to the changing environment, companies can find ways to improve their efficiency and profit.

Read More

Topics: Warehouse Efficiency, Manufacturing ERP Software, inventory control

Improve Quality Control regarding Document Management

Posted by Nicole Sherman on Tue, Oct 30, 2012 @ 08:18 AM

If your business is like any other business out there, you are probably inundated with hundreds of text files, images; video and audio files a day. Where do you store and keep track of all of these important files? If you are like most companies, you do not have a specific strategy for storing business-critical documents. Many companies allow their employees to store their files as they like, making it difficult to find files should an employee be absent.

Read More

Topics: document management

Why SMB's Should Consider Moving their ERP Software to the Cloud

Posted by Nicole Sherman on Mon, Oct 29, 2012 @ 10:59 AM
Read More

Topics: ERP Software, Cloud Based ERP Solutions

What Features Should I Look for in Manufacturing Software?

Posted by Robert Baran on Fri, Oct 26, 2012 @ 08:12 AM

Selecting manufacturing software can be difficult if you do not know what you are looking for in a manufacturing software solution. Prior to selecting any type of manufacturing software, you need to sit down and determine your needs. What are you looking to gain from investing in manufacturing software? Are you trying to get away from managing your business using spreadsheets and out-of-the-box bookkeeping software? Or do you need a solution that can help you better manage your warehouse processes and keep better track of your inventory?

Read More

Topics: Manufacturing ERP Software

Excel Tips and Tricks: Conditional Formatting

Posted by Robert Baran on Fri, Oct 05, 2012 @ 11:18 AM

Excel Tips and Tricks / Business Reporting Question: In Excel 2010, is there a way to automatically highlight upcoming and past due dates?

Read More

Topics: Business Reporting, Excel Tips and Tricks

Excel Tips: Using Value Field Settings in PivotTables

Posted by Robert Baran on Fri, Sep 28, 2012 @ 11:40 AM

Excel Tips and Tricks / Business Reporting Question: I would like to have two fields for analyzing sales in the PivotTable, one in a percentage format and the other in a value format. How can I accomplish this?

Read More

Topics: Business Reporting, Excel Tips and Tricks

Excel Tips: PivotTable Calculated Fields

Posted by Robert Baran on Fri, Sep 21, 2012 @ 01:44 PM

Excel Tips and Tricks / Business Reporting Question: How can I create my own calculated fields to include in the PivotTable? I intend to have a mark-up of 25% on the sales figure and then calculate the profit.

Read More

Topics: Business Reporting, Excel Tips and Tricks

Excel Tips and Tricks: PivotTable

Posted by Robert Baran on Fri, Sep 14, 2012 @ 10:26 AM

Excel Tips and Tricks / Business Reporting Question: How do I create an interactive report that can quickly be used to summarize large amounts of data?

Read More

Topics: Business Reporting, Excel Tips and Tricks

Excel Tips and Tricks: Subtotal

Posted by Robert Baran on Fri, Sep 07, 2012 @ 09:22 AM

Excel Tips and Tricks / Business Reporting Question: I have a long data list of products & selling prices stored in an Excel sheet. Is it possible to have a breakdown of subtotals for each product category?

Read More

Topics: Business Reporting, Excel Tips and Tricks