Although the types of tasks you’ll be given will obviously vary depending on what your services are and what your clients do for a living, I thought it might be a good idea to provide three different examples so you can get a basic idea of what to expect. These are not unusual tasks and cover the main areas of research, data entry, collation and attention to detail.
Example VA tasks
(Please read all the instructions carefully)
Below is the download button for an Excel spreadsheet which has a tab for each of the tasks.
- Click the pink button above to download the spreadsheet to your computer
- Enter the required information for each task in the relevant tab
- If you’re not comfortable with a task then just leave it
- Email the spreadsheet to me at email@example.com when you’ve finished
Task 1 – Excel data sorting
a) On tab one of the spreadsheet is a list of companies and contact names
b) Data sort the spreadsheet in alphabetical order by company name
c) Highlight the cell of any duplicate company names in yellow
d) Google ‘how to sort data in an Excel doc’ if you’re not sure how to do this
Task 2 – Online research
a) Go to the book department on Amazon
b) Find the top best sellers in the History category
c) List the names of the top five books along with the publisher on the second tab in the spreadsheet
Task 3- Proofreading
There are mistakes in the paragraph below:
“When Apple launched its first iPhone in 2007, it didn’t dissappoint. In fact, it immediately captured the collective imagination with a geeky allure driven by Apples slick design, the phone’s smart flexibilty and it’s inovative multi-touch approach.”
a) Find the mistakes
b) List them on tab three of your spreadsheet
c) Then email the completed spreadsheet to me at firstname.lastname@example.org
d) Sit back and relax then make a cup of coffee/tea in return for all your hard work
Don’t do any of the three tasks I’ve given you.
Now click here to find out why I’ve done this.