Microsoft Excel Tips

Tracing Formulas in Excel 2007

By Claire Jarrett

In many Excel worksheets, formulas are used in a very straightforward way. The actual formulas and the cells they reference can be seen. Finding errors is easy because you're working with a limited number of cells. In more complex calculations, however, a formula in one cell may depend upon the results of a formula in another cell. There are no limits on the number of references a formula can support, so a formula can reference cells that use any number of other cells, which may contain additional references! To help you spot troubles with more complicated formulas, Microsoft offers some built-in utilities and features that provide assistance in tracing formulas in Excel 2007.

Read more...
 

Protecting Worksheets And Workbooks In Excel 2003

By Claire Jarrett

Protecting worksheets and workbooks in Excel 2003 can be especially important if you plan to share the document with other people. You can prevent accidental changes to the content, layout, and formulas included in a workbook by protecting worksheets and workbooks. It's important to choose the right level of protection to provide access to the data and worksheet functions without unnecessary interference.

Read more...
 

Using the Query Wizard in Excel 2003

By Claire Jarrett

In Excel, a query can help you locate and extract precise information stored within a row or record. Queries can help you extract data from information sources that are large or closed. Additionally, you can create repeatable queries that can deliver updated data without requiring you to restructure your query each time you run it. You can easily create a query using the Query Wizard in Excel 2003.

Read more...
 

Creating Your Own Functions in Excel

By Dinesh Takyar

Writing custom functions in Excel is easy and important because everybody needs to perform a calculation specific to their situation every now and then. Some companies may offer a special bonus to their employees while some other companies may offer more travel allowance or Christmas benefits. Using the standard available functions in Microsoft Excel may not provide the solution. The solution to the problem lies in creating your own function.

Read more...
 

Excel Pivot Tables - Complex Reports Made Easy

By Debra Dalgleish

With a pivot table in Microsoft Excel you can summarize thousands of rows and columns of data into a concise summary.

Read more...
 


photo