Business Automation and Software Blog

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: I have a list of all the company’s employees in an Excel report and would like to assign the specific department they work in. Is there a way to do this without having to type the department next to each employee’s name?

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

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?

Topics: Business Reporting, Excel Tips and Tricks