Resource Area

Our Microsoft Excel resource area provides you with a wealth of resources including Excel hints and tips and new developments in Microsoft Excel and best practice modelling.


ICAEW Spreadsheet Competency Framework
Our thoughts on the ICAEW Spreadsheet Competency Framework

ICAEW launch Spreadsheet Competency Framework 6th July 2016
The ICAEW will be launching their Spreadsheet Competency Framework at Chartered Accountants' Hall in London on 6th July 2016

Bespoke Excel Training become a FAST Standard accredited training centre
We are pleased to announce that Bespoke Excel Training have become a FAST Standard accredited training centre.

FSO launch FAST Level 1 certification
The FAST Standard Organisation have launched the FAST Level 1 certification

How To Excel - Frequently asked questions
How To Excel - Questions that are frequently asked in our Bespoke Excel Training courses

How To Excel - Excel tweets of the month
Here are our favourite Excel tweets this month

How To Excel - FAQ - Which are the best shortcuts in Excel?
Excel Frequently Asked Questions Which are the best shortcuts in Excel?

How To Excel - FAQ - What are absolute references in Excel?
How To Excel - Frequently asked questions What are absolute references in Excel?

How To Excel - User defined functions (UDFs) in Excel
Excel's User defined functions give the user the ability to create their own custom functions. These UDFs can then be used in the same way as normal formulae such as SUM().

How To Excel - Excel Tweets of the month
Here are a few of our favourite Excel Tweets this month

How To Excel - February's Quick Tips
Some Quick Tips from our How To Excel series

How To Excel - VBA to create a list of Pivot Tables in Excel
The macro below will analyse your Excel workbook and create a list of pivot tables and their attributes in a new sheet. This is a great tool for auditing complex Excel spreadsheets containing multiple pivot tables.

Excel in business - Hadoop + Excel = Powerful business intelligence toolset?
Microsoft and Hortonworks are extending their partnership to develop an enhanced Hive ODBC (open database connectivity) driver. Find out more here.

Excel in business - Environmentally friendly add-in for Microsoft Excel
Adobe have launched Adobe LeanPrint, software designed to make printing from Microsoft Excel "lean, clean and green" offering a possible 40% saving on printing costs. Read our review here

Excel in business - Microsoft Excel coming soon to a tablet near to you
Microsoft is putting its new operating system Windows 8 on show at an event in Barcelona today. It will then be made publicly available for testing. All very interesting but why should we really care? Find out more here.

How To Excel - How to use the IFERROR function
=IFERROR(value,value_if_error) Find out more...

How To Excel - Excel Tweets of the month
Here are a few of our favourite Excel Tweets this month