Author: Caroline Benson

Most people who use computers, both professionally and for home use will have come across Microsoft Word, Excel, PowerPoint – well my favourite is Excel, followed closely by PowerPoint.

Excel is powerful once you grasp the use of formulas and graphs.

An example of something I helped a friend with sometime back was; extracting data from a workbook with over 100,000 rows of data that was useful to build a graph/ chart.

I used a combination of IF and MATCH statements that produced a list of data that met a certain condition. From this a cool graph/ chart was built that allowed the user to understand the distribution of data across the Globe.

All the information is in the data but taking that data and creating a story via a chart, it really goes to say that “a Picture Tells a Thousand Words” (or Rows of Data on this case!)

Reach out if you need support setting up financial or other data heavy applications. I will help you set it up so going forward you can go on to use it by yourself.

I recently had the opportunity to install a security package across multiple laptops in a household. They used their laptops for business and personal work, including banking, so it was critical their data and private information was protected.

Overall, it took 4 hours to clean up their devices from malware, install and test the new security software and they were very happy with the result.

As part of their laptop usage was for business, they were able to claim a percentage back for tax purposes.

I will always provide an invoice but please let me know if any part of your setup is related so that I can remind you to put in for your tax deductibles.