Do you use LinkedIn advertising? Or do you use another form of online advertising? Or perhaps you haven’t gone down the road of paid-for advertising yet. LinkedIn, Facebook and Google all have their positives and negatives in terms of advertising. Ultimately it depends on what your objective is that will help determine where you should … Continued
Getting clients from A to B with rome2rio
Like many Virtual Assistants part of my remit with some clients is to plan their upcoming travel arrangements. Most of the time it’s a straightforward flight or two, perhaps with a taxi pick-up at one end or the other but now and again it can be a bit more of a challenge.
Time saving shortcuts for Publisher
As Virtual Assistants, it is our job to make sure we have a good level of technical knowledge, and can use our tools efficiently. Using keyboard shortcuts is one way of saving time and getting the job done more quickly and efficiently. There are some generic keyboard shortcuts that can be used with most computer … Continued
Formula-free super quick maths
Normally in Excel, if you want to do some calculations on values in a cell or range of cells, then it’s fairly easy to do using a formula. However the way to do it would be to write the formulas into adjacent cells, convert the answers to values and then copy and paste the values … Continued
Designing in Publisher: Adding Bleed
Following a previous article on page layout in Publisher, we look at how to set bleed on your publisher document in order to prepare it for commercial printing. So what exactly is ‘bleed’? If you intend to send your publication to a commercial printer, you will probably need to add bleed and crop marks to … Continued
Mail Merge with Personalised Hyperlinks
I recently had a piece of work to do for a client that appeared on the surface to be a simple task. Just mail merging a document using a standard excel spreadsheet. What I thought would be a quick job turned into something much longer when I discovered there were hyperlinks in the spreadsheet that … Continued
How to: Word counts in Excel
Ever needed to know the word count of text in a certain cell in Excel? It’s not something that you would need know often, but now and again, it’s a useful thing to know how to do. Here’s a scenario: You have a spreadsheet of product data ready to upload to an e-commerce site. Some … Continued
Identifying unique values in a database
Conditional formatting is a very useful tool in Microsoft Excel that can be used for a variety of purposes when analysing data. It’s particularly useful for identifying trends in a particular record field or for highlighting inconsistent data.
Add a calculator into Microsoft Excel
Microsoft Excel has lots of little hidden tips, tricks and add-ons that many people don’t know about, and it’s my mission to make these lesser known functions known to the world!
What makes a good subject line?
On average, 8 out of 10 people will read the subject line copy, but only 2 out of 10 will read the rest.










