I am sure anyone that has played with Excel – and that’s just about everyone – has come across Pivot tables, and there will be users reading this that use Pivot tables ranging in skills and understanding from knowing what
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
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
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
If you haven’t read the blog post on this blog site by Sean Elliott about simplifying the work of a financial director, I would take a quick read here. Although he covers some product specific material, his message should resonate
As an FD, looking at financial data is an everyday part of my working life. It stands to reason that I should be ever on the search to find smarter ways of interpreting the data more effectively. I am fortunate
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
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
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
How many of you actually noticed or read in the press that Microsoft Excel turned 25 years old recently. No? me neither! What is it about this application that it very easily doubles as a ubiquitous source of productivity around