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.
Business Automation and Software Blog
Excel Tips and Tricks – Turn Your Data 90 degrees in Excel
Topics: accounting software, Business Reporting, Excel Tips and Tricks
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?
Topics: Business Reporting, Excel Tips and Tricks
Excel Tips: Keyboard Shortcuts to Access the Ribbon Programs
Excel Tips and Tricks / Business Reporting Question: How do I access any ribbon command in a few keystrokes?
Topics: Business Reporting, Excel Tips and Tricks
Excel Tips and Tricks: Future Dates Projection
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?
Topics: Business Reporting, Excel Tips and Tricks
Excel Tips and Tricks: Subtotal Visible Cells
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
Topics: Business Reporting, Excel Tips and Tricks
Excel Tips and Tricks / Business Reporting Question: Is it possible to link a table from an intranet/internet website to my spreadsheet?
Topics: Business Reporting, Excel Tips and Tricks
Topics: Business Reporting, Excel Tips and Tricks
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.
Topics: Business Reporting, Excel Tips and Tricks
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?
Topics: Business Reporting, Excel Tips and Tricks
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