Home

Microsoft Excel Articles

  • Buffer
  • Sharebar
  • Buffer
Microsoft Excel Article Total views Author Post date Categories
HALF OFF Charley Kyd's Dashboard products 162,455 jethro 03/12/2009 - 4:12am Charts, Excel
Conditional formatting in Excel 2007 - entire row colours 127,633 jethro 19/09/2008 - 11:03am AND, conditional formatting, Excel, Excel, functions
Excel 2007 Conditional Formatting 61,191 jethro 04/03/2008 - 3:15pm conditional formatting, Excel
Excel Function of the week - ISNA 52,539 jethro 03/12/2008 - 10:00am Excel, Excel, ISNA
Back To Basics: Data Filters in Excel 2003 and Excel 2007 45,844 jethro 19/06/2008 - 2:38am data filters, Excel, Excel, SUBTOTAL
Excel Dashboard Competition 45,723 jethro 17/04/2008 - 7:03am Excel
Dynamically refreshing pivot tables when data ranges change 31,390 jethro 26/02/2009 - 1:09am Excel, Excel, pivot table, range names
Excel Function of the Week - VLOOKUP & HLOOKUP 30,133 jethro 15/12/2008 - 7:39pm Excel, HLOOKUP, VLOOKUP
Power Pivot for Excel 2010 22,806 jethro 22/12/2009 - 12:38pm Excel, Office, pivot table
Excel Function of the Week - ROUND 20,395 jethro 27/10/2008 - 2:58pm Excel, ROUND
Dynamic Ranges - and using VBA to create them 18,220 jethro 30/10/2007 - 3:35pm Addin, COUNT, COUNTA, Excel, functions, MATCH, MONTH, OFFSET, TODAY, VBA, WEEKNUM
Finding MAX date with an Array Formula in Excel 14,545 jethro 09/10/2007 - 8:15am array formulas, Excel, functions, IF, MAX
Conditional formatting - debugging in Excel 2007 and 2010 vs 2003 14,163 jethro 27/08/2010 - 7:05am conditional formatting, Excel
When Copy and Paste is broken in Excel 12,755 jethro 28/08/2009 - 8:51am Excel
Excel 2010 - some of the major advantages over 2003 or 2007 11,725 jethro 01/06/2010 - 4:33pm Charts, Excel, Office, pivot table, security
Excel function of the week - FIND and SEARCH 10,815 jethro 10/11/2008 - 8:54pm Excel, FIND, SEARCH
Back To Basics: Using Absolute References in Excel 10,263 jethro 25/02/2008 - 8:19pm absolute references, Excel, Excel
Excel function of the week INT 10,110 jethro 17/11/2008 - 8:56am Excel, Excel, INT, VBA
Excel VBA Best Practice - performance issues 9,800 jethro 31/03/2009 - 7:12am Excel, VBA
Excel Function of the Week - IF 9,334 jethro 20/10/2008 - 7:24pm Excel, Excel, IF
Permutations in Excel 8,407 jethro 07/01/2008 - 11:04am Excel, functions, PERMUT
Relative conditional formatting in Excel 2007 8,012 jethro 20/07/2010 - 8:23am conditional formatting, Excel, IF
Office 2007 and 2010 Sundry Tips and Hints 7,434 jethro 07/05/2010 - 4:57pm conditional formatting, Excel, Office, OneNote, PowerPoint, SmartArt, VBA
Using the VBA recorder and editor in Excel 7,321 jethro 08/09/2008 - 1:39pm Excel, Excel, VBA
Excel Function of the Week - MOD 7,178 jethro 03/11/2008 - 6:45pm Excel, MOD