Beyond Excel: VBA and Database Manipulation:

February, 2010

1

February 24, 2010  6:40 PM

Drill Down – Part 1

Craig Hatmaker Craig Hatmaker Profile: Craig Hatmaker

Last post I showed how we can present summarized data when what our users want is supported by detail that would fill up tens of thousands of rows.  When we summarized the data, in a sense, we duplicated the functionality of a simple "pivot table."  Pivot Tables have one feature we didn't...

February 19, 2010  5:38 PM

Group By and Aggregate SQL Functions

Craig Hatmaker Craig Hatmaker Profile: Craig Hatmaker

At this point, we have everything we need for about 95% of user reporting and analytical requests.  On rare occasions we need to summarize the data prior to putting it into our Excel spreadsheets.  This happens when the raw detail for an expected time frame exceeds Excel's normal 65,536 row limit...


February 9, 2010  9:23 PM

Adding Excel Formulas – Part II

Craig Hatmaker Craig Hatmaker Profile: Craig Hatmaker

Last post showed the Fields Table column holding Excel Formulas to embed into your database result sets.  We also talked about how to enter formulas that reference database fields.  This is truly powerful stuff that turns basic data extracts into analytical information.  So let's start adding...


February 6, 2010  5:37 PM

Adding Excel Formulas

Craig Hatmaker Craig Hatmaker Profile: Craig Hatmaker

It's great that we can download and display data in Excel where users can sort it, filter it, print it... whatever they want to it.  It's great that we can summarize that data in interactive pivot tables.  It's great that we can display those pivot tables in interactive charts.  Those of you...


February 2, 2010  5:57 PM

Setting Column Widths or Hiding Them

Craig Hatmaker Craig Hatmaker Profile: Craig Hatmaker

Sometimes we want to include large fields in our results but don't want them hogging screen realestate.  We can limit those results using the "Width" colum in our Fields Table (See below).  If you couple this with the Format "W" (Wrap), you can display comments and notes...


1

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to: