Home

Microsoft Excel Articles

Microsoft Excel Article Total views Author Post date Categories
Conditional formatting in Excel 2007 - entire row colours 30,305 jethro 19/09/2008 - 11:03am AND, conditional formatting, Excel, Excel, functions
Excel 2007 Conditional Formatting 17,158 jethro 04/03/2008 - 3:15pm conditional formatting, Excel
Back To Basics: Data Filters in Excel 2003 and Excel 2007 9,033 jethro 19/06/2008 - 2:38am data filters, Excel, Excel, SUBTOTAL
Excel Function of the Week - VLOOKUP & HLOOKUP 7,989 jethro 15/12/2008 - 7:39pm Excel, HLOOKUP, VLOOKUP
Excel Function of the week - ISNA 6,058 jethro 03/12/2008 - 10:00am Excel, Excel, ISNA
Dynamically refreshing pivot tables when data ranges change 5,598 jethro 26/02/2009 - 1:09am Excel, Excel, pivot table, range names
Excel Function of the Week - ROUND 5,530 jethro 27/10/2008 - 2:58pm Excel, ROUND
Excel Function of the Week - IF 4,807 jethro 20/10/2008 - 7:24pm Excel, Excel, IF
Dynamic Ranges - and using VBA to create them 4,730 jethro 30/10/2007 - 3:35pm Addin, COUNT, COUNTA, Excel, functions, MATCH, MONTH, OFFSET, TODAY, VBA, WEEKNUM
Back To Basics: Using Absolute References in Excel 3,971 jethro 25/02/2008 - 8:19pm absolute references, Excel, Excel
Finding MAX date with an Array Formula in Excel 3,819 jethro 09/10/2007 - 8:15am array formulas, Excel, functions, IF, MAX
Excel function of the week INT 3,604 jethro 17/11/2008 - 8:56am Excel, Excel, INT, VBA
Excel VBA Best Practice - performance issues 3,461 jethro 31/03/2009 - 7:12am Excel, VBA
Using the VBA recorder and editor in Excel 2,879 jethro 08/09/2008 - 1:39pm Excel, Excel, VBA
Drupal Meetup and Website Management 2,788 jethro 25/10/2008 - 10:49am Drupal, Excel, LiveMesh, Office, OneNote, Word
Security vulnerabilities announced in Microsoft Excel and Drupal 2,750 jethro 26/02/2009 - 11:43am Drupal, Excel, patches, security
Excel Dashboard Competition 2,728 jethro 17/04/2008 - 7:03am Excel
Permutations in Excel 2,628 jethro 07/01/2008 - 11:04am Excel, functions, PERMUT
Excel function of the week - FIND and SEARCH 2,579 jethro 10/11/2008 - 8:54pm Excel, FIND, SEARCH
Excel Function of the Week - MOD 2,533 jethro 03/11/2008 - 6:45pm Excel, MOD
Power Pivot for Excel 2010 2,182 jethro 22/12/2009 - 12:38pm Excel, Office, pivot table
Excel Links for today 2,096 jethro 03/07/2009 - 2:18pm calculation, Excel, VBA
Windows Home Server Power Pack 1 released and other news 2,090 jethro 28/07/2008 - 11:55am Drupal, Excel, Office, social, Windows Home Server, Windows Live
Excel Function of the Week - VALUE 2,027 jethro 25/11/2008 - 12:22pm CONCATENATE, Excel, VALUE
HALF OFF Charley Kyd's Dashboard products 1,905 jethro 03/12/2009 - 4:12am Charts, Excel