|
Title |
Description | All terms | Post date |
|---|---|---|---|
| External Data |
This video demonstrates how to automatically import data from a Microsoft Access database using Excel's External Data Range feature. This is a powerful technique to pull data into Excel, and is extremely important when automating recurring processes. |
Excel, Ribbon UI | 11/12/2009 - 11:06 |
| Hyperlinks |
Demonstrates how to utilize hyperlinks to create a cohesive collection of related electronic documents, and how to use them to keep our digital workpapers organized. |
Excel, Ribbon UI | 11/30/2009 - 17:03 |
| Parameter |
This video demonstrates how to set up a parameter query used with Excel's External Data range feature to dynamically control which records from the external data source are imported. |
Excel, Ribbon UI | 11/12/2009 - 16:50 |
| Pivot Table - Refresh |
You can change the underlying data, and refresh the Pivot Table report simply by clicking the Refresh button. This is wonderful for recurring reports since it means that once you have your Pivot Table report set up just right, you can simply change the underlying data and click refresh. |
Excel, Menu UI | 10/16/2009 - 11:51 |
| Pivot Tables - First |
This is a basic "my first pivot table" video, just to get you warmed up. |
Excel, Ribbon UI | 10/15/2009 - 15:27 |
| Pivot Tables - First |
Jeff walks through a basic pivot table example just to get you warmed up. |
Excel, Menu UI | 10/15/2009 - 15:00 |
| Pivot Tables - GetPivotData |
Extract values from PIvot Tables through the use of Excel's GetPivotData function. |
Excel, Ribbon UI | 12/21/2009 - 13:26 |
| Pivot Tables - Part 1 |
In this video podcast, Jeff introduces Pivot Tables in general, explains what they are and how they can be helpful, and walks through an easy example just to get us warmed up. |
Excel, Ribbon UI | 10/09/2009 - 15:09 |
| Pivot Tables - Remove Field |
This video demonstrates how to remove a field from a Pivot Table |
Excel, Ribbon UI | 10/15/2009 - 15:42 |
| Pivot Tables - Remove Field |
How to remove a field from a Pivot Table |
Excel, Menu UI | 10/15/2009 - 15:45 |