Do you struggle to compile a report of Total Sales per Product? If your answer is yes, then the Subtotal Command can be the solution to your problem. The Subtotal Command automatically applies grouping and subtotals into a data list,
Question: I am using the Alchemex Report Manager Module, there are a lot of icons on the toolbar, but I am unsure of what their functionality is? The Report Manager Toolbar has various Icons: To activate the
Question: I have made several changes and customized the original Sales report that shipped with my Alchemex Software. Is there any way I can get hold of the original sales report? Answer: Yes, you can download the standard Alchemex
As an accountant, do you struggle to easily categorize debtors based on how much they owe your company? If you do, your struggles are over as we have a solution for you. The Conditional formatting – Icon Sets option creates
Have you ever tried to filter data based on multiple and complex criteria yet without any success? Thus you are frustrated that the Excel Autofilter Option is not yielding the desired results. Well, the Advanced Filter Option is the solution
Common sense dictates that the End Date of an employment contract should be greater than the Start Date. But alas, one can easily enter the End Date wrongly in an MS Excel data range. To ensure that the End Dates
Have you ever found yourself in a situation where you have thousands of duplicate values in a column? Perhaps you were importing client data into MS Excel from an accounting system or simply combining data in MS Excel. But alas,
When using a PivotTable in the template file take the following into account: PivotTable Limitations – ensure that you do not display too many row fields that could cause the pivot table limitation to be reached. Use report filter/page fields
When developing a template using Alchemex, it is recommended to do so using Excel 2003 and to link the template back as an .xlt file. This will ensure that the template is compatible on all versions of Excel. However if
It is no secret that small to medium sized enterprises (SMEs) are vital to the lifeblood of our economy, contributing about half of South Africa’s GDP and employing 60% of its labour force. In some developed countries, the SME sector