Cash flow forecasting – one size does not fit all
As we entered lockdown, I challenged myself and my business partner, Myles, to create a one-size-fits-almost-all cash flow template...
Insights
Articles relating to new developments in Microsoft Excel and best-practice modelling as well as our company news
Xero reporting in Excel
Clarity now offer a full suite of Xero based Xero reports, learn more...
Clarity Launch new Xero Debtors reporting template
After many weeks of development we have finally...
Free Cashflow Templates
Clarity publishes free Excel based cashflow templates
Free Excel Templates
At the start of 2020 we decided to offer a range of free Excel templates on our Shop webpage...
What’s your view?!
Recently I was struck by the variety of clients that we support – something epitomised by two photos
The smart new way to make Xero reporting easier
Xero is a great accounting package. But clients using Xero could not create a tailored profit and loss report quickly and easily. Some Clarity was clearly needed!
Government accidentally publishes spreadsheet containing New Year Honours addresses
The risk of spreadsheet-based data breaches – and 3 ways to reduce it
FAST Modelling – What’s it all about?
By Giles Male
From Xero to Hero
The launch of our first Excel based Xero Profit and Loss (P&L) template. Accounting and spreadsheet consultancy from Clarity, qualified accountnats and DataDear experts.
Clarity Consultancy Services become a DataDear Expert
Clarity Consultancy Services become a DataDear Expert
5 reasons why you should adopt the FAST Standard for all spreadsheet modelling
The FAST Standard is not just for financial models. Myles discusses the benefits of applying the FAST Standard to all spreadsheet models
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
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 - 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
Favourite Excel tweets this month
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 - 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.
Our client creates 100 jobs in Wales
Our client, Retail Merchandising Services (RMS) which provides a complete solution to retailers from shopfitting to installing new retail displays is creating 100 new jobs in South Wales.
To learn more about Clarity and how we can help you, just call or email.