Business Automation and Software Blog

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.

Topics: Business Reporting, SYSPRO software

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

Topics: Business Reporting, Excel Tips and Tricks

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.

Topics: Business Reporting, Excel Tips and Tricks

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

Topics: Business Reporting, Excel Tips and Tricks

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

Topics: Business Reporting, Excel Tips and Tricks

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?

Topics: Business Reporting, Excel Tips and Tricks

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

Topics: Business Reporting, Excel Tips and Tricks

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?

Topics: Business Reporting, Excel Tips and Tricks

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.

Topics: Business Reporting, Excel Tips and Tricks

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?

Topics: Business Reporting, Excel Tips and Tricks