Protect an Excel worksheet and use the auto filter.  A how to guide.

Add a count formula across multiple sheets in Excel.

In Excel you may wish to drill down on a range which has a header value not already contained in the rows.  The following article shows a practical example of how to generate a unique row name based on the heading in a specific place.  The procedure is in VBA.

This is a social media dashboard created in Excel.  It is free to download and has all of the graphs and source formula in the file.

Trap a range area with VBA and loop to next range area.  This little used Excel VBA technique is awesome and a real win when you learn the mechanics of it.