Business Automation and Software Blog

Excel Tips and Tricks: Subtotal

Posted by Robert Baran on Fri, Sep 07, 2012 @ 09:22 AM

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?

Read More

Topics: Business Reporting, Excel Tips and Tricks

Excel Tips and Tricks: Negative Data Bars

Posted by Robert Baran on Fri, Aug 03, 2012 @ 12:44 PM

Excel Tips and Tricks / Business Reporting Question: We have just upgraded from MS Excel 2007 to MS Excel 2010. When applying conditional formatting in MS Excel 2007 we were unable to display negative data bars. Can this be done in MS Excel 2010?

Read More

Topics: Business Reporting, Excel Tips and Tricks

Excel Tips and Tricks: Using the DATEIF Function

Posted by Robert Baran on Fri, May 25, 2012 @ 02:46 PM

Excel Tips and Tricks / Business Reporting Question: Is there a function in Excel that I can use to calculate the number of days between 2 dates. I would like to work out the number of days between an invoice date and invoice payment date.

Read More

Topics: Business Reporting, Excel Tips and Tricks