Welcome to our "Learn-How-To" Videos
We are displaying all the videos we have created to help each Excel user from beginner to advance level.
Learn how to create Multiple dependent dropdown lists using the...
Read MoreLearn how to create Multiple dependent dropdown lists using MATCH,...
Read MoreLearn how to create macros to send emails through Outlook...
Read MoreLearn how to create a duplicate removal tool in Excel...
Read MoreLearn how to create a "NESTED IF with AND" formula...
Read MoreLearn how to create macros to send bulk emails through...
Read MoreLearn how to use the INDIRECT formula.
Read MoreLearn how to create your own Profit and Loss Statement...
Read MoreLearn how to use cell referencing in excel.
Read MoreLearn how to create an IFS with AND formula.
Read MoreLearn how to use AND, OR, IF and IFERROR formulas...
Read MoreWhat clients say about us ...
GREAT JOB! Thank you john, super quick and EXACTLY what I needed.






Great communications. Lots of hard work. Perfect result.




















Can’t recommend John-Roy highly enough. He really knows his stuff and was able to supply a piece of work that some VBA developers didn’t think be done but he did so really quickly. Not only that he is very friendly and easy to work with. Highly recommended.








































John was excellent to work with and a star on excel, no hesitation in recommending him. Will work with John in the future.




















John-Roy was extremely fast and provided a quick screencast demonstrating the task was completed correctly in Excel. On-time and done right. Thank you John-Roy!


It was a great experience with John, recommended!






Excellent excel skills, quite a bit beyond my own.




















John went beyond the call of duty in getting me what I wanted. What was impressive is that some freelancers replied and said it could not be done, but John delivered thank you.






John in a Wiz, amazing to work with and needed little guidance, used is own initiative and completed the projects promptly.






Top notch, understood intricate details and acted right away and within tight timescales. Will be using John again, truly excellent level of care and attention.




















Great working with John-Roy. Did an amazing job with a system that is much easier to use than we expected originally.




















Brilliant for getting the job done, also goes the extra mile with enhancements and suggests to improve where possible. Great to work with!




















John-Roy is highly skilled, quick, efficient and flexible. I will definitely use this contractor again.






Brilliant work, in a short time with an informative video. Will definitely be working with John-Roy again.




















John-Roy not only handled the task, but he also went above and beyond the requirements to give us more insight into our dataset. Would highly recommend his work!




















5 star work. Micro project finished on time and on budget.








































As always, you brief, he does – and quickly. Thoroughly recommended.




















John-Roy was an excellent freelancer to work with. Communication was easy and he was open and honest with regard to deadlines and time required to complete the job. He really took the time to understand exactly what I needed, and provided me with a an Excel file that was easy to understand and work with. The quality of his work is flawless and I would have no issue whatsoever recommending him or working with him again.


John-Roy is one of the most professional people I’ve worked with. Took time to even include short videos on the steps of running and setting up the macro. The timeliness was beyond my expectation and will recommend him to anyone needing assistance.




















“Very smart, very clever freelancer! Excellent work! Will be re-hiring him for another project.”


Brilliant to work with. An expert in his field who I would definitely use again.


Good approach [in solving data consolidation], handled some of my messy [spreadsheet data] bits well, will be using [his services] again.




















Very quick turnaround and the macro did exactly what I want. Very happy with John’s work and will ask him to help me again.




















The guy knows his stuff. Fast, good communication. Honestly, anything excel related… You can’t get better!




















Great job, really good quality and communication and John-Roy did a very fast turnaround. We would definitely use him again.






























