Excel Tips and Tricks / Business Reporting Question: Is it possible to combine two or more chart types in a chart?
Business Automation and Software Blog
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: Conditional Formatting
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: Using Value Field Settings in PivotTables
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
Excel Tips and Tricks / Business Reporting Question: I have a list of product sales with different transaction dates. How do I calculate the total sales for transactions between 2009/03/20 and 2009/03/30 by using one formula?
Topics: Business Reporting, Excel Tips and Tricks