Excel: Principal Component Analysis (PCA)

Learning PCA with Excel A student in Learning Tree’s Course 195, Power Excel: Analyzing Data to Make Business Decisions, asked “can you do Principal Component Analysis using Excel?” The answer that popped into my head was, “sure, but why would you want to?” If all you want are the results, you’re much better off using […]
Read More ›

How to Create Your Own Array Functions in Excel VBA

Excel Array Functions In a previous instalment, we saw how to use MINVERSE, one of Excel’s built-in array functions and we saw how we can use <ctrl><shift><enter> to insert the array result into a rectangular array of cells. We also mentioned that many Excel experts, like Mr. Excel, call such functions “CSE” functions, as a […]
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.