Publishing an Excel Workbook to an intranet/internet location 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 […]

Continue reading

The Right Function Question: I usually import data from our accounts system into Excel for further analysis. The difficulty I face is that the names are combined with the initials. However I would like to analyze the data based on the initials. Is there a formula one can type so as to extract the initials […]

Continue reading

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 […]

Continue reading

Continue reading

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 […]

Continue reading

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 […]

Continue reading

Question: One of the problems I face as the payroll administrator is that when entering the salaries for staff members, I sometimes enter figures outside the respective salary bands. Our employees are categorized into various grades which then determine the salary bracket. Is there a way of adding some validation so that when the wrong […]

Continue reading

Question:   When working with large spreadsheets, it gets a bit frustrating when you go to read the data in a distant row or column and the headings at the top of the page or down the side of the sheet disappear. Given that I have a huge list of data to analyze in excel, is […]

Continue reading

Question:  I am in charge of finance for a large company with various branches throughout the country. The branch accountants send their budgets quarterly to the Head Office.  I then present a consolidated budget to the company board.  Currently I have to recreate the consolidated budget for all the branches. This obviously takes time and […]

Continue reading

Question:   One of my tasks as the Sales Manager is to calculate the percentage increase or decrease in sales at the end of the financial year in comparison to prior year sales figures. The formula is quite complex and usually the data captures make mistakes when called upon to enter the formula. Is it possible […]

Continue reading