Excel Tips

After adding a chart or graph to your Excel workbook, some items may need labeling, in order for management to see details about the data. This is different than a…

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…

We have all had those “Aha” moments, when the blinders are removed, the light bulb goes on, and things become clear. These revolutionary learning experiences can radically change our entire…

You know your way around a spreadsheet. You know how to set up your columns; you use some swanky shortcuts to reduce the time it takes you to input data;…

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…

  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…

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…

  Using 3D References between worksheets in an Excel workbook has been around for many years. It allows us to use Excel more like a database than a spreadsheet. As…

When prepping a workbook for a template, typically it needs to be cleared of data, so that the template is ready for new data each time a new workbook is…