My Latest Excel Top Tips

This  website is about getting the best from excel so here are some top tips for this week:

1. Use data validation to control entries in cells  – the dialog box is found on the data ribbon.  The ‘list’ option is particularly useful – see my data validation video
2. Using Vlookup is a good way to retrieve data from along list – see the video here
3. Good structure is essential for anything other than very simple spreadsheets – keep your inputs, calculations and outputs on separate sheets
4. The magic camera tool is a simple way of combining different tables and charts into a fantastic looking report
5. Use conditional formatting to find duplicate data
6. Use the match formula to find out if something exists in a long list