Microsoft Excel Resources

Browse Resources

Tutor Hunt Resources
- How to start tutoring at Tutor Hunt
- How to find a tutor at Tutor Hunt
- The Benefits of a Scientific Education
- What is the importance of academic subjects in everyday life?
- The Benefits of Studying English
- Extra curricular activities
- The importance & benefits of private tutoring
- Good revision techniques
- Tracking student progress
- Finding a secondary school to suit your child
- Possible options after completing GCSEs
- Tips on choosing the right university
- How to find the right tutor
- Tutoring tips
- Methods to help you improve your dyslexic child's reading
- The importance of education in future life
Excel Power Query - Merging and Appending Queries
Power Query Merge and AppendDon`t be put off by the terminology, Power Query is simply sorting and organising data that you wish to import into your Excel spreadsheet and in doing so ...
Excel Introduction
ExcelExcel is a software programme designed to take data and conduct
analysis to extract useful information in tabular or graphic from. The information can then be used for a
varie...
Conditional Formatting - An Introduction
Conditional formatting
What is conditional formatting?
In literal terms it is getting the format of a cell to
change depending upon the content of the cell linked to a rul...
Using Tables in Excel
I was recently asked what my favourite tip was for using Microsoft Excel more effectively. Without a lot of thought I was able to answer - Tables!
"But", I hear you say, "my data is ...

Dynamic Drop Down Lists
Dynamic Drop Down Lists
One of my previous post show that how to create Drop Down List in excel. Here I`m going to discuss how to create Dynamic Drop Down List. Copy below data.
P...
Excel tips
Excel Tip: To copy formats only, select, then first click the Format Painter on the Home Ribbon, then click the destination cell.
Excel Tip: To copy formats only, copy as nor...

