Category Archives: Microsoft Excel

Optimising your time when doing VAT Quarterly Returns

Now I am going to say this from the start.  I am not an accountant I just happen to be very good at finding solutions to problems and relatively good at Excel.

I say relatively good because I know people who are far better than me.

I help a small family run business optimise their VAT process.  Previously everything was written down on a bit of paper and then all the receipts put into a file with invoices and finally the analysis on top.

Continue reading Optimising your time when doing VAT Quarterly Returns

Microsoft Excel – Weekday Function and VLookups

Microsoft Excel 2010 - LogoMicrosoft Excel is the world’s most used spreadsheet tool.  But what do people use it for really?  I would admit that I began using it at school for creating lists and slight calculations.  However, now with what I have learnt in terms of automation, KPI creation, VBA and analysis. Continue reading Microsoft Excel – Weekday Function and VLookups