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

Did you know that there are ways to reduce your workload by automating many of the tasks you do in Excel? Our Excel Functions and Formulas class will empower you with the ability to build complex formulas, to make crunching

Did you know that there are ways to reduce your workload by automating many of the tasks you do in Excel? Our Excel Functions and Formulas class will empower you with the ability to build complex formulas, to make crunching

A Personal Workbook in Excel holds information that is specific to your computer copy of Excel. The workbook is created by Excel if it is needed, so you have no control over one being created or not. There are a

Don’t Believe It! Don’t believe that Excel is just another spreadsheet program! It is much more. By using 3D functionality, you can make Excel act like a database. Excel is much more robust than it was ten years ago, and