Home

Microsoft Excel Articles

  • Buffer
  • Sharebar
  • Buffer
Microsoft Excel Article Total viewssort icon Author Post date Categories
Conditional formatting in Excel 2007 - entire row colours 229,438 jethro 19/09/2008 - 11:03am AND, conditional formatting, Excel, Excel, functions
HALF OFF Charley Kyd's Dashboard products 216,017 jethro 03/12/2009 - 4:12am Charts, Excel
Excel 2007 Conditional Formatting 169,607 jethro 04/03/2008 - 3:15pm conditional formatting, Excel
Back To Basics: Data Filters in Excel 2003 and Excel 2007 80,650 jethro 19/06/2008 - 2:38am data filters, Excel, Excel, SUBTOTAL
Using a slider to control values in a cell in Excel 72,196 jethro 04/01/2013 - 12:26pm Charts, controls, Excel
Excel Function of the week - ISNA 71,584 jethro 03/12/2008 - 10:00am Excel, Excel, ISNA
Dynamically refreshing pivot tables when data ranges change 67,350 jethro 26/02/2009 - 1:09am Excel, Excel, pivot table, range names
Excel Dashboard Competition 66,652 jethro 17/04/2008 - 7:03am Excel
Excel Function of the Week - ROUND 52,149 jethro 27/10/2008 - 2:58pm Excel, ROUND
Conditional formatting - debugging in Excel 2007 and 2010 vs 2003 51,656 jethro 27/08/2010 - 7:05am conditional formatting, Excel
Excel Function of the Week - VLOOKUP & HLOOKUP 50,524 jethro 15/12/2008 - 7:39pm Excel, HLOOKUP, VLOOKUP
Power Pivot for Excel 2010 38,965 jethro 22/12/2009 - 12:38pm Excel, Office, pivot table
How to remove #N/A errors in Excel 37,671 jethro 14/12/2012 - 12:21pm Excel, functions, IF, ISNA
Pasting in Office 2013 32,253 jethro 11/03/2013 - 7:31am Excel, Excel, formatting, Office, Outlook, PowerPoint, Word
How to Use Excel to buy a Second Hand Car 31,673 jethro 13/08/2012 - 3:34pm Charts, Excel
Excel Slow? It may be the Google Desktop application causing it. 31,527 jethro 20/12/2007 - 2:56pm Addin, Excel, Search
Excel 2010 - some of the major advantages over 2003 or 2007 30,414 jethro 01/06/2010 - 4:33pm Charts, Excel, Office, pivot table, security
Dynamic Ranges - and using VBA to create them 28,877 jethro 30/10/2007 - 3:35pm Addin, COUNT, COUNTA, Excel, functions, MATCH, MONTH, OFFSET, TODAY, VBA, WEEKNUM
A practical way to use the IF function in Excel 28,134 jethro 25/05/2012 - 11:09am data filters, Excel, Excel, functions, IF
Excel function of the week - FIND and SEARCH 27,089 jethro 10/11/2008 - 8:54pm Excel, FIND, SEARCH
Using Named Ranges in Excel 2007 and 2010 26,301 jethro 29/06/2012 - 10:53am Excel, range names
Finding MAX date with an Array Formula in Excel 24,245 jethro 09/10/2007 - 8:15am array formulas, Excel, functions, IF, MAX
Using VBA Code to Delete Cells Based on the Font Color 22,281 jethro 11/05/2012 - 8:37am Excel, VBA
When Copy and Paste is broken in Excel 21,333 jethro 28/08/2009 - 8:51am Excel
Excel Tools for Business Half Price Sale 21,185 jethro 10/01/2014 - 8:29am Excel
Back To Basics: Using Absolute References in Excel 19,416 jethro 25/02/2008 - 8:19pm absolute references, Excel, Excel
Excel function of the Week - Sum 19,164 jethro 04/05/2012 - 11:29am Excel, Excel, functions, SUM
Excel Function of the Week - IF 18,364 jethro 20/10/2008 - 7:24pm Excel, Excel, IF
Permutations in Excel 17,440 jethro 07/01/2008 - 11:04am Excel, functions, PERMUT
Using the SUBTOTAL Function in Excel 17,207 jethro 06/10/2015 - 9:43am Excel, Excel, functions, SUBTOTAL
Introduction to the new tables in Excel 2010 17,088 jethro 27/04/2012 - 10:36am Excel, Excel, Office, SUBTOTAL, Tables
Excel VBA Best Practice - performance issues 16,220 jethro 31/03/2009 - 7:12am Excel, VBA
Excel function of the week INT 15,766 jethro 17/11/2008 - 8:56am Excel, Excel, INT, VBA
Office 2007 and 2010 Sundry Tips and Hints 15,576 jethro 07/05/2010 - 4:57pm conditional formatting, Excel, Office, OneNote, PowerPoint, SmartArt, VBA
Using the VBA recorder and editor in Excel 15,533 jethro 08/09/2008 - 1:39pm Excel, Excel, VBA
Relative conditional formatting in Excel 2007 15,393 jethro 20/07/2010 - 8:23am conditional formatting, Excel, IF
Default sorting options in Excel 14,538 jethro 29/07/2009 - 9:54am Excel, sort
Excel function of the week - AND 14,026 jethro 23/12/2010 - 9:28am AND, Excel, functions, IF
Excel Function of the Week - MOD 13,696 jethro 03/11/2008 - 6:45pm Excel, MOD
Tech Talk Christmas Summary 13,688 jethro 24/12/2010 - 11:29am Blogging, Drupal, Excel, Office, Outlook, phones, photography, Windows Home Server, Windows Live
Excel News - 2010, coding and other news 13,399 jethro 18/03/2010 - 4:04pm Charts, Excel, Office
Round up of Excel Tips and Hints 12,645 jethro 09/06/2011 - 6:10am Excel, INDEX, MATCH, Office, pivot table, Ribbon, VBA, VLOOKUP
Office 2010 and the World Cup 12,314 jethro 23/06/2010 - 8:05am Excel, Football, Office, Word
Excel Function of the Week - SUMIF 12,210 jethro 20/04/2012 - 10:26am absolute references, Excel, functions, SUMIF
Excel Function of the Week - VALUE 11,950 jethro 25/11/2008 - 12:22pm CONCATENATE, Excel, VALUE
Navipane for Excel 11,932 jethro 25/09/2007 - 12:49pm Addin, Excel, unhide, VBA
When Excel 2003 doesn't display data and Excel 2010 information 11,712 jethro 28/10/2009 - 8:18am Excel, VBA
Link Round Up 11,355 jethro 12/04/2012 - 4:27pm Drupal, Excel, functions, INDEX, photography, social, Web Design, Windows 8
Drupal Meetup and Website Management 11,347 jethro 25/10/2008 - 10:49am Drupal, Excel, LiveMesh, Office, OneNote, Word
Excelerators Quiz and giveaway 10,502 jethro 27/01/2010 - 7:29am Excel, Free
Windows Home Server Power Pack 1 released and other news 10,206 jethro 28/07/2008 - 11:55am Drupal, Excel, Office, social, Windows Home Server, Windows Live
Excel Links and news 9,216 jethro 07/12/2009 - 6:45pm Excel, INDIRECT, Office
Office 2007 and 2010 8,940 jethro 10/08/2009 - 1:28pm Charts, Excel, Office, OneNote, Word
Intraday Charts and Pattern Fills in Excel 2007 8,604 jethro 07/01/2008 - 8:39pm Charts, Excel
The future revealed - on PsyJournal 8,332 jethro 22/02/2008 - 11:54am Back To Basics Information, Excel
Security vulnerabilities announced in Microsoft Excel and Drupal 8,308 jethro 26/02/2009 - 11:43am Drupal, Excel, patches, security
Microsoft Office 2003 Service Pack 3 - problems with Excel Macros 8,267 jethro 04/10/2007 - 9:30am Excel, Office, patches
Around the world in Excel days 8,176 jethro 10/04/2009 - 10:21am Charts, conditional formatting, Excel, Ribbon, VBA
This Weeks Web Roundup 8,128 jethro 20/11/2008 - 3:32am email, Excel, File Sharing, filters, funny, LiveMesh, Movies, Music, social, Windows Live
The week in review 8,127 jethro 08/11/2009 - 12:27am Charts, Cycling, Excel, gadgets, photography, Windows 7, Windows Live
Advanced Excel Applications 7,754 jethro 04/10/2008 - 6:17pm Excel
Sundry Excel Tips 7,685 jethro 25/03/2008 - 1:15pm Charts, COUNTIF, Excel, SUMPRODUCT
Excel Tools and News from the web 7,663 jethro 01/05/2009 - 11:01am conditional formatting, Excel, IF, IFERROR, INDEX, ISNA, SUMPRODUCT, VBA, VLOOKUP
Excel News from Charley Kyd 7,624 jethro 27/07/2009 - 4:26pm Excel, Office
Excel Calculation Errors 7,493 jethro 26/09/2007 - 1:13pm calculation, Excel, patches
VBA primer plans 7,474 jethro 22/08/2008 - 1:10pm Excel, VBA
Developing in Excel 2007 7,214 jethro 15/10/2008 - 12:00pm Excel, IF, INDEX, MATCH, MOD, VLOOKUP
Manipulating and Massaging Data in Excel and VBA 7,102 jethro 13/11/2007 - 10:33am CLEAN, data cleansing, Excel, SUBSTITUTE, TRIM, VBA
A real blog post 6,898 jethro 16/03/2009 - 7:12am Excel, NOW, random
News from around the Web 6,719 jethro 20/10/2009 - 1:47pm Excel, funny, Home Theatre, Office, OneNote, Outlook
Excel Links for today 6,563 jethro 03/07/2009 - 2:18pm calculation, Excel, VBA
Excel 2007 Calculation Error Fix from Microsoft 6,485 jethro 10/10/2007 - 12:26pm calculation, Excel, patches
Riding and other bits and pieces 6,389 jethro 04/10/2009 - 8:49am Charts, Cycling, Excel, Office, VBA, Windows Live
Excel Links 5,971 jethro 24/06/2009 - 8:31am Excel
Cool content for the week of 21 March 2009 5,742 jethro 21/03/2009 - 1:26pm browser, Excel, gadgets, VBA
Excel Media Player, Floating Point and Shadows 5,627 jethro 22/04/2008 - 7:33am calculation, Compatibility, Excel, formatting
Microsoft Excel Hack Security Issue 5,506 jethro 19/01/2008 - 10:34am Excel, security
Free Excel Tools updated 5,017 jethro 02/04/2008 - 10:25am Addin, Excel
Excel 2007 Tips 4,482 jethro 08/11/2007 - 10:48am conditional formatting, Excel, pivot table
Microsoft Office Links 4,476 jethro 13/03/2008 - 9:35am Excel, Outlook, Ribbon, Vista
Bill Jelen Is Giving Away His Book For Free 4,074 jethro 02/11/2007 - 5:08pm Excel