Optimize SQL Server Queries with Index Statistics

Television’s Mythbusters seem to have a lot of fun; it’s interesting that so many myths seem to involve blowing stuff up on camera. SQL myth-busting may not be as visually dramatic, but for people who are interested in query performance, it is much more important. There are a lot of people who think that it […]
Read More ›

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 ›

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.