Business Automation and Software Blog

Financial Software Makes Business Reporting Clear

Posted by Robert Baran on Wed, Jan 04, 2023 @ 11:00 AM

Business reporting is an essential part of your operation. You need clear numbers to tell the story of how the company is faring. Financial software takes the data collected from your ERP to give you clear and powerful stories that all stakeholders can understand.

Read More

Topics: Business Reporting, SYSPRO software

Excel Tips and Tricks – Turn Your Data 90 degrees in Excel

Posted by Nicole Sherman on Mon, Jul 22, 2013 @ 08:57 PM

Do you use Excel for your business reporting needs? Many businesses use Excel accounting software, and we receive many questions regarding its proper use. If you – like us – have ever questioned how to perform a certain function in Excel, you’ve come to the write place. Periodically we will highlight Excel tips and tricks (like the Excel tip found in this article) to help you get the most out of your accounting software solution.

Read More

Topics: accounting software, Business Reporting, Excel Tips and Tricks

Excel Tips and Tricks: Date Data Validation

Posted by Robert Baran on Fri, Jan 25, 2013 @ 11:53 AM

Excel Tips and Tricks / Business Reporting Question: I would like to ensure that the end date is greater than the start date? Can this be done in MS Excel?

Read More

Topics: Business Reporting, Excel Tips and Tricks

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

Excel Tips and Tricks: Future Dates Projection

Posted by Robert Baran on Fri, Jan 11, 2013 @ 12:10 PM

Excel Tips and Tricks / Business Reporting Question: How can I calculate the date that a project ends, this date falls after a certain amount of years, months and days?

Read More

Topics: Business Reporting, Excel Tips and Tricks

Excel Tips and Tricks: Subtotal Visible Cells

Posted by Robert Baran on Fri, Jan 04, 2013 @ 02:35 PM

Excel Tips and Tricks / Business Reporting Question: How can I quickly calculate the total sales for each month and copy only the visible cells or subtotals to a new worksheet

Read More

Topics: Business Reporting, Excel Tips and Tricks

Excel Tips and Tricks: Excel Web Query

Posted by Robert Baran on Fri, Dec 28, 2012 @ 09:00 AM

Excel Tips and Tricks / Business Reporting Question: Is it possible to link a table from an intranet/internet website to my spreadsheet?

Read More

Topics: Business Reporting, Excel Tips and Tricks

Excel Tips and Tricks: Subtotal Command

Posted by Robert Baran on Fri, Dec 21, 2012 @ 09:00 AM
Read More

Topics: Business Reporting, Excel Tips and Tricks

Excel Tips and Tricks: Aggregate Function

Posted by Robert Baran on Fri, Dec 14, 2012 @ 01:11 PM

Excel Tips and Tricks / Business Reporting Question: How do I calculate the sum for a range of numbers with error values within the range? Using the standard sum function in Microsoft Excel returns an error.

Read More

Topics: Business Reporting, Excel Tips and Tricks

Excel Tips and Tricks: Trends

Posted by Robert Baran on Fri, Nov 30, 2012 @ 01:26 PM

Excel Tips and Tricks / Business Reporting Question: Is there a function in MS Excel that can be used to predict future sales based on past performance or sales trends?

Read More

Topics: Business Reporting, Excel Tips and Tricks