Creating an Excel template allows a person to reuse a workbook setup over and over, without the need to recreate the wheel every time, nor continuously to clean out old information. By using a template, your workbook is ready and

Hiding certain rows or columns in Excel can make viewing complex, detailed information easier to read. Grouping Rows in Excel allows you to quickly collapse and expand similar data to create more useful views. Select the rows with similar data

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 Legend, as that can be added differently to the chart

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 your formula as you move through the setup process. If

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 approach to our jobs, or even life. Here we look

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; you have a utilitarian list of Excel functions at your

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 to various print jobs, and can be exhausting. You can

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 three different ways to embed and/or link documents in Excel,

  Using 3D References allows us to use Excel more like a database than a spreadsheet. As Excel functionality has increased, so has Excel’s capabilities, including the speed that connections update, and the types of connections that can be made

Have you inherited a spreadsheet and you need to figure out what is going on in it?  It can be a challenge to have to click on each cell to see where the formulas are to get a full understanding of how