Business Automation and Software Blog

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
0 Comments Click here to read/write comments

Topics: Business Reporting, Excel Tips and Tricks

Excel Tips and Tricks: Workdays

Posted by Robert Baran on Fri, Nov 23, 2012 @ 01:16 PM

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.

Read More
0 Comments Click here to read/write comments

Topics: Business Reporting, Excel Tips and Tricks

Excel Tips and Tricks: Two Chart Types

Posted by Robert Baran on Fri, Nov 16, 2012 @ 11:04 AM

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

Read More
0 Comments Click here to read/write comments

Topics: Business Reporting, Excel Tips and Tricks

Excel Tips and Tricks: PV Function

Posted by Robert Baran on Fri, Nov 09, 2012 @ 11:45 AM

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

Read More
0 Comments Click here to read/write comments

Topics: Business Reporting, Excel Tips and Tricks

Excel Tips and Tricks: Rank Function

Posted by Robert Baran on Fri, Nov 02, 2012 @ 09:46 AM

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?

Read More
0 Comments Click here to read/write comments

Topics: Business Reporting, Excel Tips and Tricks

Excel Tips and Tricks: Conditional Formatting

Posted by Robert Baran on Fri, Oct 05, 2012 @ 11:18 AM

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

Read More
0 Comments Click here to read/write comments

Topics: Business Reporting, Excel Tips and Tricks

Excel Tips: Using Value Field Settings in PivotTables

Posted by Robert Baran on Fri, Sep 28, 2012 @ 11:40 AM

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?

Read More
0 Comments Click here to read/write comments

Topics: Business Reporting, Excel Tips and Tricks

Excel Tips: PivotTable Calculated Fields

Posted by Robert Baran on Fri, Sep 21, 2012 @ 01:44 PM

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.

Read More
0 Comments Click here to read/write comments

Topics: Business Reporting, Excel Tips and Tricks

Excel Tips and Tricks: PivotTable

Posted by Robert Baran on Fri, Sep 14, 2012 @ 10:26 AM

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?

Read More
0 Comments Click here to read/write comments

Topics: Business Reporting, Excel Tips and Tricks

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
0 Comments Click here to read/write comments

Topics: Business Reporting, Excel Tips and Tricks

All posts