Excel Sparklines: Weapons of Mass Visualization

Data Visualization Today, the phrase “Data visualization” evokes mental images of beautiful images, works of art, really, that convey information about our world. But we’ve all seen other beautiful images that seem to have a point, but it’s difficult to discern what that point actually is. The heart and soul of data visualization is the quick, […]
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 ›

Excel As a Database: How to Use Power Pivot Linked Tables

It seems almost trivial to say that Excel is a spreadsheet application. Yet, many organizations use Excel workbooks as a repository for data, in other words, as a database system. I myself have seen United States military operations executed from worksheets, pretty much because the people involved weren’t quite sure how to use Access. For […]
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 ›

How to Link Excel to MATLAB to Solve Complex Equations

Solving Linear System and Linear Optimization Equations Using Microsoft Excel and MATLAB In the previous instalment on linear systems we saw that Excel can easily invert a modest-sized matrix and find solutions to a set of simultaneous linear equations. In the real world, a place I allude to frequently and try to avoid as much as […]
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.