Alchemex was founded in November 2001 in Durban, South Africa, with the vision to provide practical solutions for small and medium sized companies around the world to assist them with the common frustrations associated with getting good information out of
If you are looking for an easy and yet useful function that can Sum data based on multiple conditions, then look no further than the Sumifs function. Assuming that you want to calculate the total sales figure for a given
In the past few weeks I have been watching some of my colleagues, at all levels, in a bit of frenzy over the Sage brand changes. It has been quite eventful, and will be so seemingly until December this
Given that you have a list of names & surnames in a data range and your task is to extract the first letter of the names as the initial. By using the LEFT text function this supposedly complex task can
One often finds, when trying to convince people to use one software package over another that they want to know the software’s core strengths. I was recently asked this with regards to Sage Business Intelligence, or more specifically, Alchemex Smart
There are many associations to CSI even the extreme being Criminal Scene Investigation. What I am however referring to is the CSI which gives back to ones community and or those in need. The “giving” aspect which makes up a
You have created budgets for various branches on different worksheets in your excel spreadsheet. However you are wondering how you can automatically generate a consolidated budget for all the branches. Well, no need to worry because by using the consolidate
You have taken time to create a product sales PivotTable and placed the branch field in the report filter area, product name in the row area and product sales in the values areas. However you want to analyse sales per
The Like Operator is used in Filters and Parameters for doing pattern matching. Combinations of literal characters and wildcard characters can be used to locate patterns. The two wildcard characters that are supported by most Data Access Drivers are the
The Direct SQL Query tool allows direct interrogation via SQL of data within your Administrator defined Data Connections. The query tool allows only SELECT queries and {call} type queries for stored procedure execution (if supported). UPDATE, DELETE and INSERT and