Contextures -- Excel Tips

Excel Quick Tips Videos 01

Wed, 23 Dec 2009 12:44:00 EST

Excel tips in a set of very short videos, including freeze panes, print comments and create a quick series of numbers.

Colour Filter Headings

Mon, 07 Dec 2009 16:32:00 EST

UPDATE: Event code colours the filtered column headings, when an AutoFilter is applied. Updated to prevent unnecessary clearing of Undo stack, per tip from Nigel Hunt.

Excel Advent Calendar

Wed, 02 Dec 2009 00:01:00 EST

Click a numbered square and a macro reveals a Christmas picture each day. Formulas show current date and days till Christmas.

Excel VBA Intro - Record and Run a Macro in Excel 2007

Thu, 26 Nov 2009 15:50:00 EST

Record a macro to automate a task, show the Developer tab on Ribbon, run the recorded macro.

Excel Holiday Dinner Planner

Sat, 10 Oct 2009 14:53:00 EDT

Create a detailed preparation schedule for holiday meals. Enter details and Excel calculates start times.

Movie Collection Database Sample File

Sat, 05 Sep 2009 09:18:00 EDT

Sample file uses Data Validation and Advanced Filter to extract a list of movies for selected category or actor; file contains macros to automate list updates and filter.

Pivot Table from Multiple Sheets

Mon, 24 Aug 2009 09:18:00 EDT

Sample file from Excel MVPs, Kirill Lapin (KL), with amendments by Hector Miguel Orozco Diaz. Uses code to automatically create a pivot table from multiple sheets in a workbook.

Excel -- You might be an Excel Nerd If

Mon, 03 Aug 2009 15:04:00 EDT

Yes, you might be an Excel Nerd if any of the entries in the Contextures Blog giveaway sound familiar. A humorous look at Excel, from those who live there.