How to create quarters in Excel

Currently, there’s no function that will convert dates into quarters in Microsoft® Excel®.  However, using the CHOOSE function, we can easily convert dates into quarters in Excel. The CHOOSE function returns a value from a list of items based on a position number. For example, if we had a function =CHOOSE(3,”Apples”,”Bananas”,”Peaches”,”Pineapples”) the function would return […]

Continue reading


Build advanced reporting skills and save time for your business with Excel on Steroids 2013 Online

Sage Intelligence – a division of Sage, the global leader in integrated accounting, payroll and payment systems – has launched Excel on Steroids 2013 Online. The course aims to help you build advanced reporting skills so that you can save time and streamline your business reporting and analysis. It is the latest offering from the rapidly […]

Continue reading