I use EndNote X9 and occasionally want to analyse references in Microsoft Excel or using Python. I thus need my EndNote references in CSV filetype. For some reason, it can be very difficult to export (or copy and paste) from EndNote into a format that is acceptable in Excel. Whilst there are ways of exporting […]
General Technology
How to Downgrade to scikit-learn Version 0.23.2
I use Pycaret a bit for analysis of academic documents and whenever I update Python I get an error that I should be using scikit-learn version 0.23.2. The error is something like ValueError: Sklearn version error. If you get the scikit-learn version error merely run the following:
How to automate EndNote library daily backups
I use EndNote X9 for my doctoral studies. I love the way it integrates so well with Microsoft Word however it drives me crazy how unstable the library is. I learnt the hard way that the library becomes corrupt when it’s stored on a shared drive such as Microsoft OneDrive or Google Drive. I now […]
How to Clear Chrome Browser Cache
Follow these instructions to clear the cache in your Google Chrome Browser.
Identify Unique Values in Excel or Google Sheets
I often work with large lists of email addresses when helping Mailchimp clients with their email marketing needs. Occasionally I need to identify unique values only in a list. For example a list of 100,000 contacts may have duplicate contacts and I need to quickly identify records where the email address isn’t duplicated. Fortunately it […]
How to add a G Suite Gmail Signature Across All Devices
On moving from Google Inbox to Gmail I have been very frustrated with the need, in Gmail, to set a signature multiple times. For example I need to set a signature on my PC and on my Android devices. I change my signature often so this duplication of tasks is annoying. Set a Global Gmail […]
How to speed up FileZilla
I have used FileZilla for years for my FTP needs. It is one of the first applications that I install when I get a new computer. I was recently using FileZilla to download a few thousand WordPress files from a server. Although my internet connection was very fast, and the server from which I was […]
Easily Speed up FileOptimizer Image Compression
I’ve used FileOptimizer for my image compression needs for many years. I’ve tried other image compressors such as Kraken.io, Compressor.io, TinyJPG, TinyPNG but FileOptimizer meets my needs best. I need to compress PNG, GIF and JPG/JPEG files for my email marketing and website purposes; faster loading images are essential for effective email marketing and webpage […]
How to restore a Google Docs file you’ve overwritten
I love Google Docs, Google Sheets and Google Slides. One thing however that I’ve become very adept at is overwriting a document, spreadsheet or presentation that I intended to copy. I’m so used to opening an existing file in Microsoft Word, Excel or PowerPoint, making changes and then clicking Save as that I forget that […]
What to do if 1Password won’t accept your password
I recently decided to start using 1Password version 6 (I previously used 1Password 4). The reason I upgraded was to get access to 1Password Families and 1Password Teams. I uninstalled 1Password version 4 from all my devices and installed version 6 (as well as creating an online login). On one of my Windows 10 PCs […]