>

Tutorials

•  Filtering Data

•  Data Validation

•  Conditional Formatting

•  Array Formulas

Custom Functions

•  Sum By Color

•  Count By Color

•  Calculate Working Days

•  Get Workbook Name

•  Get Name and File Path

•  Interior Cell Color Value

•  Get Font Color Value

•  Last Used Cell

Numbers

•  Prime Number Test

Visual Basic

•  Word Count

•  Delete Empty Rows

Non Excel

•  Discount Mathematics

•  Bank Statement Key

•  Euro Currency

•  UK Income Tax Bands      and Tax Allowances

•  Spam Bot Food

Finance

•  Secured Loans

•  Homeowner Loans

Links

•  4Tops

•  AbleBits

•  Excel Hints

•  Mead In Kent

•  Synkronizer

•  The Excel Nexus

•  Get Excel Help

•  Microsoft Excel Repair

•  Excel Tutorial

•  Japanese Recipes

 

               

I am a Microsoft Certified Excel Expert with many years of experience in building spreadsheet models.

I am a management accountant by profession and my skills and experience with Microsoft Excel have been
gained through many years of daily use - Microsoft Excel is probably the number one analytical and reporting
tool used by accountants and finance professionals.

This site is intended for experienced users of Microsoft Excel who are using it almost everyday in the
workplace but are only really scratching the surface of what this powerful application has to offer.

This site will explore the more advanced features of Microsoft Excel and will include tutorials, solutions, hints,
tips and downloads.  Any comments or suggestions are welcome.

Click here to contact me.