Excel: Interpreting the Principal Components Analysis (PCA)

  What Does Principal Component Analysis Tell Us? In the first installment, we indicated that the primary reason to do a principal component analysis (PCA) in Excel was to increase our own understanding. If your goal is the PCA itself, a better choice of tool might be R, Matlab, or similar tool. Now that we […]
Read More ›

Excel: Some Range Selection Quickies

Selecting a range of cells in an Excel worksheet, is such a common thing to do that many take it for granted. However, there are a few shortcuts that are worth reviewing, and a very useful formula technique called dynamic named ranges, that in my opinion, is underutilized by many Excel analysts. A Review of […]
Read More ›

Filtering Multiple Excel Pivot Tables with a Single Slicer

There are many occasions when it would be valuable to have two (or or three or possibly more) Excel pivot tables respond to changes in a single slicer filter. This is easy to do when one understands the inner workings of pivot tables. Under normal circumstances if you create several Excel pivot tables each will […]
Read More ›

Extending Excel Functionality with an RTD Server: Part One

Part One: Accessing a Web Service Using C# In the previous installment we saw how to create a COM server for use by Microsoft Excel. We will now look at how we can use this technology to create what Excel calls a “Real-time Data”, or RTD server. An RTD server is called at regularly scheduled […]
Read More ›

Extending Excel Functionality with a C# COM Library

Creating Compiled Code Libraries for Excel Using C# Excel analysts and developers who create useful functions often wish to share their work with coworkers and others. For many applications, creating an Excel macro workbook (xlam file) is sufficient. But for some code, the need for more power requires the development of libraries of compiled code. […]
Read More ›

Type to search blog.learningtree.com

Do you mean "" ?

Sorry, no results were found for your query.

Please check your spelling and try your search again.