Business Automation and Software Blog

Excel Tips and Tricks – Turn Your Data 90 degrees in Excel

Posted by Nicole Sherman on Mon, Jul 22, 2013 @ 08:57 PM

Do you use Excel for your business reporting needs? Many businesses use Excel accounting software, and we receive many questions regarding its proper use. If you – like us – have ever questioned how to perform a certain function in Excel, you’ve come to the write place. Periodically we will highlight Excel tips and tricks (like the Excel tip found in this article) to help you get the most out of your accounting software solution.

Read More

Topics: accounting software, Business Reporting, Excel Tips and Tricks

Excel Tips and Tricks: Date Data Validation

Posted by Robert Baran on Fri, Jan 25, 2013 @ 11:53 AM

Excel Tips and Tricks / Business Reporting Question: I would like to ensure that the end date is greater than the start date? Can this be done in MS Excel?

Read More

Topics: Business Reporting, Excel Tips and Tricks

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

Topics: Business Reporting, Excel Tips and Tricks

Excel Tips and Tricks: Future Dates Projection

Posted by Robert Baran on Fri, Jan 11, 2013 @ 12:10 PM

Excel Tips and Tricks / Business Reporting Question: How can I calculate the date that a project ends, this date falls after a certain amount of years, months and days?

Read More

Topics: Business Reporting, Excel Tips and Tricks

Excel Tips and Tricks: Subtotal Visible Cells

Posted by Robert Baran on Fri, Jan 04, 2013 @ 02:35 PM

Excel Tips and Tricks / Business Reporting Question: How can I quickly calculate the total sales for each month and copy only the visible cells or subtotals to a new worksheet

Read More

Topics: Business Reporting, Excel Tips and Tricks

Excel Tips and Tricks: Excel Web Query

Posted by Robert Baran on Fri, Dec 28, 2012 @ 09:00 AM

Excel Tips and Tricks / Business Reporting Question: Is it possible to link a table from an intranet/internet website to my spreadsheet?

Read More

Topics: Business Reporting, Excel Tips and Tricks

Excel Tips and Tricks: Subtotal Command

Posted by Robert Baran on Fri, Dec 21, 2012 @ 09:00 AM
Read More

Topics: Business Reporting, Excel Tips and Tricks

Excel Tips and Tricks: Aggregate Function

Posted by Robert Baran on Fri, Dec 14, 2012 @ 01:11 PM

Excel Tips and Tricks / Business Reporting Question: How do I calculate the sum for a range of numbers with error values within the range? Using the standard sum function in Microsoft Excel returns an error.

Read More

Topics: Business Reporting, Excel Tips and Tricks

Excel Tips and Tricks: Trends

Posted by Robert Baran on Fri, Nov 30, 2012 @ 01:26 PM

Excel Tips and Tricks / Business Reporting Question: Is there a function in MS Excel that can be used to predict future sales based on past performance or sales trends?

Read More

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

Topics: Business Reporting, Excel Tips and Tricks