Excel is a powerful tool and there are often many different ways to achieve the results you are after. There are no right or wrong ways – that is providing you get your correct result - however some approaches may be easier to understand than others, easier to maintain, more efficient on your time, or just easier to debug when the results are not what you expect.
The articles are written for the Excel user who has some experience already with the tool and not for the complete beginner. So for example you should already have some understanding of the ribbon, how to enter data into the spreadsheet, how to add formulas. The articles are not meant to replace Excel's inbuilt help but are more suggestions on how you can work more effectively with Excel. The articles are not prescriptive, if you have a different way of doing something that works for you, that is fine.
The articles are broadly split into 3 categories, using Excel specific features, using VBA to write Excel macros, and Design which covers higher level issues and a bit of catchall for other Excel topics.
At the bottom of each article is a statement about Excel and OS version used to create the article, although it will never be anything prior to Excel 2007 as there was such a big change from 2003 to 2007, but some of the principles may still apply to early versions of Excel. Certainly there are some features, which require more recent versions of Excel such as spark lines which require Excel 2010.
Windows 7 or higher is assumed, although many of the articles will work on lower versions of Windows, and may work on the Mac version.
19-Sep-2013 Excel Article: Excel Tables (Part 6) - Preserving Entry Order
25-Jun-2013 Excel Article: Excel Tables (Part 5) - Running Totals
12-Jun-2013 Excel Article: Excel Tables (Part 4) - Totals
31-May-2013 Excel Article: Excel Tables (Part 3) - Structured References
31-May-2013 Excel Article: Excel Tables (Part 2) - Creating an Excel Table
21-May-2013 Excel Article: Excel Tables (Part 1) - An Introduction
25-Apr-2013 Design Article: Questions to ask before designing a spreadsheet solution
11-Apr-2013 Excel Article: Sumif and Sumifs. Conditional summation
28-Feb-2013 Excel Article: What is that dollar in the formula? Relative and absolute references
27-Feb-2013 Excel Article: How to get graphs to update automatically when new data is added to a plain table
26-Feb-2013 Excel Article: How to get formulas to update automatically when new data is added to a plain table