Question: I usually export the stock movement data from our Accounting Package into Excel. However I struggle to calculate the total for the negative values (stock out) and positive values (stock in) separately .The data is placed in one column when exported to Excel. Is there a way of overcoming the allocation of positives and […]

Continue reading

Question: As the organizer of weekly sales meetings, I am required to prepare an electronic attendance register to the Sales Director. I currently use MS Excel for recording the attendance. I usually enter “A” for staff who attended the meeting and an “X” for those who were absent. Is there a better way of tracking […]

Continue reading

Question: I have a workbook that I use for budgeting and need to paste the same data into many of the worksheets. Is there a quicker way of doing this than the usual copy & paste? Answer: Yes, with the FILL ACROSS WORKSHEETS option. Why:  To fill data in many worksheets simultaneously Process (Excel 2003, […]

Continue reading

Question: Can I evaluate multiple conditions in a formula?  Answer: Yes, with the Nested If Statement  Why:    In order to construct more elaborate tests of the data Process (Excel 2003, 2007 and 2010): The If statement can be used to conduct conditional tests on values and formulas. However if more elaborate testing of data will […]

Continue reading

Question: Am I able to load an option such as solver add-in, if it is not found on the data ribbon?   Answer: Yes, with the Excel Add in command.   Process (Excel 2003, 2007 and 2010): The Solver Add-in is a Microsoft Office Excel add-in (add-in: A supplemental program that adds custom commands or custom […]

Continue reading

Question: Can I create and save different groups of values on a worksheet and then switch between these values to view the different results?   Answer: Yes, with the SCENARIO MANAGER   Process (Excel 2003, 2007 and 2010): A scenario is a set of values that Microsoft Office Excel saves and can substitute automatically on […]

Continue reading

 Question: Can I find the result I want by adjusting the input value?   Answer: Yes, with the GOAL SEEK What IF analysis Tool   Process (Excel 2003, 2007 and 2010): Goal Seek is a powerful what if analysis tool which takes a result and determines possible input values that produce that result. For instance, […]

Continue reading

Question: If I want to borrow money from a financial institution, can I create a table that displays the loan repayment figures based on various repayment periods and interest rates?   Answer: Yes, with the DATA INPUT TABLE (Using two variables)   Process (Excel 2003, 2007 and 2010): By using the PMT function one can […]

Continue reading

Question: I am recording monthly sales amounts and there seems to be a constant, upward trend, though the increase each month isn’t always the same amount. Can I use Excel to tell me when I’ll hit a certain sales amount?   Answer: Yes, with the FORECAST function   Process (Excel 2003, 2007 and 2010):   […]

Continue reading

Question: How do I specify what rows or pages I would like printed in Excel?   Answer: By using Excel’s Print options   Process (Excel 2003, 2007 and 2010):   Excel allows you to print a selection of cells, a selection or pages from a particular worksheet, or the entire workbook. Here’s how it can […]

Continue reading