If you are planning for an exhilarating sales year in 2010 focusing on growing revenues of your exciting product lines of typewriters, fax machines and Sony Walkman then you need Business Intelligence urgently. OK, so it’s a silly example because these are long discontinued products but sometimes the market forces that drive old products out [...]
{ 0 comments }
How many times have you heard, ‘I have limited access to data so I had to make assumptions about what I thought happened and therefore made what I thought were reasonable conclusions, but there are potentially other explanations as well.’ – or something along those lines in a vain attempt to explain away a poor [...]
{ 0 comments }
Selecting Multiple Columns You can select multiple columns in the report manager by using the “Crtl” or “Shift” key along with a mouse click. Hold down “Shift” for selecting multiple adjacent columns or “Crtl” for selecting multiple random columns. This is useful tip when moving, deleting or adding the aggregate function to multiple columns.
{ 0 comments }
If you want to move or copy a union report from one folder to another you need to export the report to an easy attainable location then import to the new folder in the Report Manager. The reason you can’t copy and paste a union report is that the sub reports then get left behind [...]
{ 0 comments }
How many times have you heard, ‘I have limited access to data so I had to make assumptions about what I thought happened and therefore made what I thought were reasonable conclusions, but there are potentially other explanations as well.’ – or something along those lines in an attempt to explain away a poor business [...]
{ 0 comments }
Question: I would like to see which cells are blank in a column of data, and I don’t want to resort the the column. Is there a quick way that I could do this? Answer: Yes, using the ‘Go To Special…’ option Process (Excel 2003, 2007, 2010): In this example, we have [...]
{ 0 comments }
I am looking for a courier service, you provide a courier service. You are very aware that you operate in a very competitive space where competition is centred on price and service. I am looking for a service that can give me easy access to the information in your system but you don’t currently give [...]
{ 0 comments }
Question: I have a sheet of sales information and would like to add together all lines for not only a specific product category, but for all sales of that product category in a particular region. How can I do this with one formula? Answer: By using the SUMIFS function Process (Excel 2007 and 2010): [...]
{ 0 comments }
Everybody knows the quote that “If you do what you’ve always done, you’ll get what you’ve always got”, but have you really applied that thinking in a practical way in your business. So for example, you may be struggling to generate the levels of profitability you are expecting for your business but your sales people [...]
{ 0 comments }
Question: I have a sheet of sales information and would like to add together all lines for a specific sales person. How can I do this? Answer: By using the SUMIF function Process (Excel 2003, 2007 and 2010): The SUMIF function is very useful, allowing you to total a number of lines [...]
{ 0 comments }
|
|
|
|
|
|
Powered by Alchemex Copyright © 2012,
Entries (RSS)
and Comments (RSS).