Extending Excel Functionality with a C# COM Library

Creating Compiled Code Libraries for Excel Using C# Excel analysts and developers who create useful functions often wish to share their work with coworkers and others. For many applications, creating an Excel macro workbook (xlam file) is sufficient. But for some code, the need for more power requires the development of libraries of compiled code. […]
Read More ›

How to Use Power Query to Import Hadoop Data into Excel

When Power Query was first introduced early in 2013 it was known as the Data Explorer. In some ways, Data Explorer was a better name. The primary job of Power Query is to enable Excel users to examine data, decide what values need to be imported into Excel, and then complete the import process. If […]
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 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 ›

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.