Using Matlab Functions in Microsoft Excel

If it wasn’t already clear, the world of big data and analytics has brought home the point that applications can no longer function alone. Many applications must live, work, and play together seamlessly in what some folks call an “ecosystem”. Today we will see that it is very easy to use the advanced capabilities of […]
Read More ›

Excel as a Database: How to Create a Data Model in Excel 2013

Many blogs, including some originating from our friends in the rainy Pacific Northwest, have referred to the “new” data models in Excel 2013. I’m not sure “new” is quite the right word. “Useful”, absolutely. “Interesting”, most definitely. But what we are really seeing here is not so much new as it is another step in […]
Read More ›

How to Use SQL and the Excel Data Model to Repair Data

In the previous instalment on querying economic data with SQL we saw a problem not uncommon in the world of worksheets-as-database. Errors and inconsistencies that seem trivial when looking at the data themselves become annoying impediments to creating the pivot table we want. In many cases, the traditional tools of the SQL database are well […]
Read More ›

Excel as a Database: How to Query Economic Data With SQL

As we noted in the previous post on how to use Power Pivot Linked Tables, a wealth of economic information is available for download from banks and government agencies, as well as the United Nations. Unfortunately, the structure of that data differs from source to source, and rarely does it meet our requirements as is. In […]
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.