Question:     How do I access any ribbon command in a few keystrokes? Answer:      By using access keys: Access keys provide a way to quickly use a command by pressing a few keystrokes, no matter where you are in the program. Every command in a program that uses an Office Fluent ribbon can be accessed […]

Continue reading

Question:     How can I calculate the date that a project ends, this date falls after a certain amount of years, months and days? Answer:        By using the Date function, =Date(Year,month,Day) Why:            To predict the completion date of a project Applies To:   Excel 2003, 2007, and 2010 1. Refer to the data below     […]

Continue reading

Question:     How can I quickly calculate the total sales for each month and copy only the visible cells or subtotals to a new worksheet.  Answer:        By using the Subtotal command and visible cells only option. Why:            If some cells, rows, or columns on the worksheet are not displayed, you have the option of copying […]

Continue reading

Question:     Is it possible to link a table from an intranet/internet website to my spreadsheet? Answer:        Yes, by using the get external data from web option (Web query) Why:            You can use a Web query to retrieve refreshable data that is stored on your intranet or the Internet, such as a single table, multiple […]

Continue reading

Question:     I have a list of sales transactions for various months. How can I quickly calculate the total sales for each month? Answer:        By using the Subtotal command Why:            To calculate the total sales for each month Applies To:   Excel 2003, 2007 and 2010 1. Refer to the data given below       […]

Continue reading

Question:     How do I calculate the sum for a range of numbers with error values within the range?  Using the standard sum function in Microsoft Excel returns an error. Answer:        By using the Aggregate function in MS Excel 2010.  Why:         To find the sum for a range of numbers where there are error values […]

Continue reading

Question:     Is there a function in MS Excel that can be used to predict future sales based on past performance or sales trends? Answer:        Yes, by using the Trend function Description:   Returns values along a linear trend. Fits  a  straight line (using the method of least squares) to the arrays known_y’s and known_x’s. Returns […]

Continue reading

Question:     How can I calculate the number of workdays between two dates? The usual off days are Saturday, Sunday and public holidays. Answer:        By using the Networkdays function   Why:            To calculate the number of workdays between two dates                      Applies To: Excel (2010, 2007):   1.         The data below will be used […]

Continue reading

Question:     Is it possible to combine two or more chart types in a chart? Answer:        Yes   Why:            To display the results of different sets of data in one graph                  Applies To: Excel 2010, 2007, 2003:   1.         Refer to the data given below                 […]

Continue reading

Question:     How much deposit do I need to pay in order to have a monthly installment of $400 over a period of 4 years for a car costing $15,000? The interest rate is 8.5% Answer:        The PV function will be used to find a solution. The PV Function returns the present value of an […]

Continue reading