Text Length

Feb 24, 2011 marketingteam Leave a comment Business Intelligence

Question: I need to export the stock list to our database program for further analysis. Last time I tried the routine, the names of the products were truncated because the wrong field size was used in the table. How can I return the number of characters in a text string? This will enable me to identify the maximum […]

Text Conversion

Feb 17, 2011 marketingteam Leave a comment Business Intelligence

Question: I usually export my inventory data into Excel for further analysis. However the products names appear in upper case when I do this. Is there a way of converting the product names to lowercase and then capitalizing each word – how do I do this in Excel? Answer: By using the proper function Why: […]

Multiple Data Consolidations for PivotTables

Feb 10, 2011 marketingteam Leave a comment Business Intelligence

Question: As an effective tool for working with large volumes of data, I usually use PivotTables to summarize, organize and view the same data in many different ways quickly and easily. However the data is usually in one data source/range. Is it possible to create a PivotTable based on multiple data consolidation ranges? Answer: Yes, with the PivotTable […]

Splitting of Windows

Feb 3, 2011 marketingteam Leave a comment Business Intelligence

Question: Is it possible to view different parts of the data worksheet at the same time? For instance when I import the payroll summary report from the payroll system, I would like to see the top ten & bottom ten earners. We have over five hundred employees on our payroll and this analysis is crucial […]

Publishing an Excel workbook to an intranet or internet

Jan 27, 2011 marketingteam Leave a comment Business Intelligence

Question: We have adopted a policy in our company where the financial director is expected to publish quarterly financial results to the server/Intranet. This can then be read by all the concerned parties. However we only want to send a static copy of the statement/s. Is there an option in excel that we can use to […]

Datedif Function

Jan 13, 2011 marketingteam Leave a comment Business Intelligence

Question: Is there a function in Excel that I can use to calculate the number of days between 2 dates. I would like to work out the number of days between an invoice date and invoice payment date. Answer: Yes, using the DATEDIF function DATEDIF is not listed with other functions under the formula tab in Excel 2007. […]

Excel Line Breaks

Dec 23, 2010 marketingteam Leave a comment Excel Tips & Tricks

Question: I am using Excel 2007 for my sales numbers; I sometimes enter a lot of sales numbers in an Excel cell. The problem I face is that when I enter more data into a cell the original data is hidden. Is there a way to avoid the original numbers being hidden? Answer: Yes, using […]

Top Selling Products

Dec 15, 2010 marketingteam Leave a comment Excel Tips & Tricks

Question: In order to effectively monitor the performance of the stock items, I need to have a list of the best performing products in quantity sold. This helps in planning and making sure that enough stock is available at all times. I specifically need to display a list of the top three items. How can […]

Creating Report Short Cuts

Dec 10, 2010 marketingteam Leave a comment Sage Intelligence Tips & Tricks

Question: Is there a way that I can run my Alchemex reports from my desktop or a shared location so that I don’t have to open Alchemex every time I want to run a report? Answer: Yes, using the Create Report Shortcut option in the Report Manager. Working with Report Shortcut files The Report Shortcut […]

Backup Metadata and Upgrade

Dec 10, 2010 marketingteam Leave a comment Sage Intelligence Tips & Tricks

I am using Alchemex version 6.8 and have downloaded the latest Alchemex 7 Smart Reporting from the website. How do I go about backing up my current metadata and templates, as I would like to make these available and use the templates in the new Alchemex 7 version? Even if you are not upgrading your […]

All Solutions

All Solutions

Additional Reports

Sage Intelligence Tips & Tricks

Excel Tips & Tricks

All Solutions

Additional Reports

Sage Intelligence Tips & Tricks

Excel Tips & Tricks

Get Support Assistance

Knowledgebase

Report Writers

Text Length

Text Conversion

Multiple Data Consolidations for PivotTables

Splitting of Windows

Publishing an Excel workbook to an intranet or internet

Datedif Function

Excel Line Breaks

Top Selling Products

Creating Report Short Cuts

Backup Metadata and Upgrade

Solutions

Resources

Learning

Support