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