Business Automation and Software Blog

Excel Tips: Keyboard Shortcuts to Access the Ribbon Programs

Posted by Robert Baran on Fri, Jan 18, 2013 @ 11:14 AM

Excel Tips and Tricks / Business Reporting Question: How do I access any ribbon command in a few keystrokes?

Read More

Topics: Business Reporting, Excel Tips and Tricks

Increase Your Productivity and Profitability with ERP Software

Posted by Robert Baran on Fri, Dec 07, 2012 @ 10:06 AM

Has your company grown in the last five years? Is your customer base expanding while your software falls behind? As companies grow, they must increasingly rely on the proper activities, processes and business management systems to run their business. Many of these processes, systems or activities may be outdated, resulting in a lack of efficiency, profitability or growth.

Read More

Topics: ERP Software

Manufacturing Software Proven to Manage Inventory Costs

Posted by Nicole Sherman on Thu, Nov 29, 2012 @ 01:51 PM

Are your inventory costs getting out of control? Are you looking for a system that can help you properly manage your inventory without wasting crucial company money? Manufacturing and distribution companies rely on manufacturing software in order to increase their overall efficiency and improve their operations. Every company is unique; therefore, each company has its own set of needs when it comes to manufacturing software. While some companies may be looking to decrease the time a particular task takes to complete, other companies may be interested in improving their financial predictions. Whatever the need may be, manufacturing software can solve the common problem of inventory costs.

Read More

Topics: Manufacturing ERP Software, inventory control

Excel Tips and Tricks: Workdays

Posted by Robert Baran on Fri, Nov 23, 2012 @ 01:16 PM

Excel Tips and Tricks / Business Reporting Question: How can I calculate the number of workdays between two dates? The usual off days are Saturday, Sunday and public holidays.

Read More

Topics: Business Reporting, Excel Tips and Tricks

Excel Tips and Tricks: Two Chart Types

Posted by Robert Baran on Fri, Nov 16, 2012 @ 11:04 AM

Excel Tips and Tricks / Business Reporting Question: Is it possible to combine two or more chart types in a chart?

Read More

Topics: Business Reporting, Excel Tips and Tricks

Excel Tips and Tricks: PV Function

Posted by Robert Baran on Fri, Nov 09, 2012 @ 11:45 AM

Excel Tips and Tricks / Business Reporting Question: How much deposit do I need to pay in order to have a monthly installment of $400 over a period of 4 years for a car costing $15,000? The interest rate is 8.5%.

Read More

Topics: Business Reporting, Excel Tips and Tricks

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