45 minutes to automate month-end accounts

See how powerful Power Query can be. Try our 45 minute video to see how it can completely automate your month-end accounts process:

Instant accounts with Power Query

Since the Excel Power Query tools became an integral part of Excel 2016, the number of people asking for help with using Power Query to solve long-standing spreadsheet and other accounting data-related issues has increased dramatically.

If you are already considering implementing a Power Query based solution, or just want to investigate whether the new tools might be of use in your organisation, we would be happy to discuss providing consultancy or tailored training.

Prices start at £400 plus expenses and VAT for a half day consultancy visit. If you are interested, please contact us at: training@tkb.co.uk

Online Excel Courses

Improve your Excel skills Start here


The essential Excel book for accountants - edition 2

From doing the basics better to creating an interactive dashboard, Essential Excel for Accountants is packed with hundreds of practical techniques and hints and tips for improving your use of spreadsheets. Just £12.00 inc. VAT for a 250+ page PDF.

Essential Excel for Accountants (and others) covers versions of Excel from Excel 2007 to Excel 2019 and Excel for Office 365

Buy the book online

See the answer to the Excel Challenge


"Brilliant detective work -  worth the subscription already!"

"Superstar - you have no idea how much hassle and time we have spent on that - even uninstalled and reinstalled Microsoft Office. Thanks, thanks, thanks, thanks...................."

"The information in your newsletter saved me £2,000 last year."

Some of the many comments regarding the help we have provided via e-support and our other services.

If you are an accountant and use Microsoft Office products we could save you lots of time, aggravation and money. The Knowledge Base e-support service entitles you to help and support on IT related issues via email for just £5 a month.


One year's subscription to our Gold Service can gain you discounts on software, hardware, training courses, workshops, a regular newsletter and telephone/fax support.

If at the end of your year's membership you don't feel that you have received value for money, we will refund your subscription in full.

Further information is available about these IT services.

IT Regularly is the Knowledge Base's specialist magazine which deals with IT matters relating to accountancy practices. Visit the Newsletter main page.

If you have any queries, comments or would like to know more about services offered by The Knowledge Base, please send us an email

© 1998 The Knowledge Base. Disclaimer