Category: Microsoft Office

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 […]

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 […]

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 […]

How to Solve Linear Equations in Excel Using the MINVERSE and MMULT Functions Systems of linear equations pop up everywhere you look. Small retail shops want to maximize the profit from the distribution of goods taking up limited shelf space. Chemists need to balance constituents of a complex reaction. Economists are compelled to build models; […]

In my last post we looked at how to set up the system to use OPENROWSET to read Excel Worksheets from SQL Server. I believe that using the OPENROWSET function is the most flexible and practical method for linking Excel worksheets to SQL Server. Before we look at OPENROWSET, however, let’s take a moment to review […]