Evaluating Formulas in Excel

If you build formulas with the help of the Function Library, a dialog box pops up, and helps you fill in the different areas with the correct information, then evaluates…

Continue Reading Evaluating Formulas in Excel

Finding Worksheets in Excel

When working with Excel, especially if you are trying to fully automate a workbook, you can create many worksheets to keep from recreating the wheel.  Doing so often means navigating…

Continue Reading Finding Worksheets in Excel

Removing Duplicates in Excel

  Removing duplicate information can be both helpful and intimidating when working with many line items in Excel. Follow these steps to make the process easy : Ensure your data…

Continue Reading Removing Duplicates in Excel

Embedding Documents in Excel

Embedding documents in an Excel workbook is a technique that is not widely used, mostly because not many people know you can embed a document in a worksheet. There are…

Continue Reading Embedding Documents in Excel