Top 10 Excel Tricks for Increased Efficiency

Considering the time today’s IT professionals spend staring at Microsoft Excel spreadsheets, one might think we’d all be Excel wizards by now. The truth is that while Excel has a low barrier to entry, to become a true super user takes a lot of time, energy, and dedication. While you may think you’re an above-average […]
Read More ›

Creating Rollover Interaction in Excel Dashboards

Excel Dashboards can be great for conveying critical summary data regarding the state of investments, an important project, or even an entire business enterprise. Dashboards also pose many challenging problems for developers; one of the more important ones being, how to convey information using a limited amount of monitor real estate. One solution is to […]
Read More ›

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 ›

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.